This page (revision-4) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 904 bytes JMyers to previous
3 26-Nov-2021 10:22 956 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
P 2 K_CM_COORDINATORS
P2K_CM_COORDINATORS

Version management

Difference between version and

At line 4 changed one line
Parent Table: [P2K_CM_DEPARTMENTS]\\
Parent Table: ___\\
At line 6 changed one line
Department Coordinator information.
Date sensitive department information.
At line 13 changed 3 lines
|[COORDINATOR_TYPE]|Varchar2(2)|[X_COORDINATOR_TYPE]|Y|
|[START_DATE]|Date()|[DATE]|Y|
|[END_DATE]|Date()|[DATE]|Y|
|[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]
At line 20 changed 2 lines
|[EID_ID]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES]
|[DPS_ID]|Number(10)|[ID]| |link to [P2K_CM_POSITIONS]
|[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]
At line 44 added 3 lines
[{If var='loginstatus' contains 'authenticated'
At line 27 changed 2 lines
![Notes|Edit:Internal.P2K_CM_COORDINATORS]
[{InsertPage page='Internal.P2K_CM_COORDINATORS' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.P2K_CM_DEPARTMENT_DETAILS]
[{InsertPage page='Internal.P2K_CM_DEPARTMENT_DETAILS' default='Click to create a new discussion page'}]
}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by JMyersTop