P 2 K_CM_DEPARTMENT_DETAILS
Back to current versionRestore this version

Alias: DDD#

Unique Keys: _
Child Table: _
Parent Table: _

Date sensitive department information.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DDP_IDNumber(10)IDYlink to P2K_CM_DEPARTMENTS
EFFECTIVEDate()EFFECTIVEY
DLN_ID_LOCATED_INNumber(10)IDYlink to P2K_CM_LOCATIONS
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EID_IDNumber(10)ID link to P2K_HR_IDENTITIES
DLN_ID_PAYDESTNumber(10)ID link to P2K_CM_LOCATIONS
DAA_IDNumber(10)ID link to P2K_CM_AUTHORIZATION_AREAS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DIN_IDNumber(10)ID link to P2K_CM_INDUSTRIES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXPIRYDate()EXPIRYY
DEPARTMENT_NAMEVarchar2(50)VARCHAR50Y
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
BURDEN_PERCENTNumber(18)AMT12V6
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESS(Disambiguation)Varchar2(100)EMAIL
EEOC_FUNCTIONVarchar2(2)X_EEOC_FUNCTION
BATCH_CODEVarchar2(16)CODE
OFFICE_CODEVarchar2(16)CODE
BURDEN_METHODVarchar2(2)X_BURDEN_METHOD
DDP_ID_REPORTING_TONumber(10)ID link to P2K_CM_DEPARTMENTS
TWD_IDNumber(10)ID link to P2K_TS_WORK_DIVISIONS

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation