!!!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|AMTnn]| | |[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\\ ---- ![Notes|Edit:Internal.P2K_CM_DEPARTMENT_DETAILS] [{InsertPage page='Internal.P2K_CM_DEPARTMENT_DETAILS' default='Click to create a new notes page'}]