!!!Alias: DDD
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Date sensitive department information.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DDP_ID]|Number(10)|[ID]|Y|link to [P2K_CM_DEPARTMENTS]
|[EFFECTIVE]|Date()|[EFFECTIVE]|Y|
|[DLN_ID_LOCATED_IN]|Number(10)|[ID]|Y|link to [P2K_CM_LOCATIONS]
|[DWR_ID]|Number(10)|[ID]| |link to [P2K_CM_WORK_RULES]
|[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS]
|[EID_ID]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES]
|[DLN_ID_PAYDEST]|Number(10)|[ID]| |link to [P2K_CM_LOCATIONS]
|[DAA_ID]|Number(10)|[ID]| |link to [P2K_CM_AUTHORIZATION_AREAS]
|[DPS_ID]|Number(10)|[ID]| |link to [P2K_CM_POSITIONS]
|[DIN_ID]|Number(10)|[ID]| |link to [P2K_CM_INDUSTRIES]
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[DEPARTMENT_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[BURDEN_PERCENT]|Number(18)|[AMT12V6]| |
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |
|[EEOC_FUNCTION]|Varchar2(2)|[X_EEOC_FUNCTION]| |
|[BATCH_CODE]|Varchar2(16)|[CODE]| |
|[OFFICE_CODE]|Varchar2(16)|[CODE]| |
|[BURDEN_METHOD]|Varchar2(2)|[X_BURDEN_METHOD]| |
|[DDP_ID_REPORTING_TO]|Number(10)|[ID]| |link to [P2K_CM_DEPARTMENTS]
|[TWD_ID]|Number(10)|[ID]| |link to [P2K_TS_WORK_DIVISIONS]

User Fields: Allowed\\
Audit Logging: Allowed\\