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

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

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
8 26-Nov-2021 10:22 3 KB rforbes to previous
7 26-Nov-2021 10:22 3 KB khiggs to previous | to last
6 26-Nov-2021 10:22 3 KB jmyers to previous | to last
5 26-Nov-2021 10:22 3 KB JEscott to previous | to last
4 26-Nov-2021 10:22 3 KB Administrator to previous | to last
3 26-Nov-2021 10:22 3 KB Administrator to previous | to last
2 26-Nov-2021 10:22 3 KB Administrator to previous | to last
1 26-Nov-2021 10:22 3 KB Administrator to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 2 changed 4 lines
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Unique Keys: [DPS_ID_CHILD_OF] + [EFFECTIVE] + [EXPIRY]\\
Child Table: [P2K_SA_PREMIUM_USAGES], [P2K_CM_DISTRIBUTIONS]\\
Parent Table: [P2K_CM_POSITIONS]
ERD: [ERD-CM40]
At line 9 changed one line
\\
At line 36 changed one line
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4]| |
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
At line 47 changed one line
|[AUTHORIZED_FTE]|Number(9)|[AMT5V4]| |
|[AUTHORIZED_FTE]|Number(9)|[AMT5V4|AMTnn]| |
At line 70 added 6 lines
|[BYPASS_ORG_CHART]|Varchar2(1)|[TOGGLE]| |
|[ORG_RECORD_TYPE]|Varchar2(2)|[X_ORG_RECORD_TYPE]| |
|[SP_KEY_POSITION]|Varchar2(1)|[TOGGLE]| |
|[PERFORMANCE_ELIGIBLE]|VARCHAR2(1)| [TOGGLE]| |
|[POSTING_RESP_CHECK_LEVEL]|VARCHAR2(2)| [X_RESPONSIBILITY_LEVEL]| |
|[REPORT_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
At line 77 added 6 lines
!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_EVALUATION_POINTS]
|[DRV_FIRST_MANAGER_EID]
At line 85 added 5 lines
----
![Notes|Edit:Internal.P2K_CM_POSITION_DETAILS]
[{InsertPage page='Internal.P2K_CM_POSITION_DETAILS' default='Click to create a new notes page'}]