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 khiggs

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 1 KB rforbes to previous
7 26-Nov-2021 10:22 1 KB rforbes to previous | to last
6 26-Nov-2021 10:22 901 bytes rforbes to previous | to last
5 26-Nov-2021 10:22 843 bytes rforbes to previous | to last
4 26-Nov-2021 10:22 843 bytes rforbes to previous | to last
3 26-Nov-2021 10:22 843 bytes rforbes to previous | to last
2 26-Nov-2021 10:22 835 bytes khiggs to previous | to last
1 26-Nov-2021 10:22 718 bytes khiggs to last

Page References

Incoming links Outgoing links
P 2 K_LR_SENIORITY_LISTS
P2K_LR_SENIORITY_LISTS

Version management

Difference between version and

At line 1 changed one line
!!!Alias:LIT
!!!Alias:LSL
At line 4 changed 2 lines
Unique Keys: \\
ERD:
Unique Keys: Employee [EEM_ID] + Unit [DUN_ID] + [JOB_ROSTER] + Job [DJB_ID]\\
ERD: [ERD-LR06]
At line 12 changed 8 lines
|[ID]|Number(10)|[ID]|Y|
|[ISSUE_TYPE_CODE]|Varchar2(16)|[CODE]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[ISSUE_TYPE_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[ID]|NUMBER(10,0)| [ID]|Y|
|[DUN_ID]|NUMBER(10,0)| [ID]|Y|Link to [P2K_CM_UNITS]
|[EEM_ID]|NUMBER(10,0)| [ID]|Y|Link to [P2K_HR_EMPLOYMENTS]
|[HIRE_SEQUENCE]|NUMBER(5,0)| [NUMBER5|NUMBERn]| |
|[CHANGE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|DATE| [DATE]|Y|
|[CREATE_DATE]|DATE| [DATE]|Y|
|[CREATE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[JOB_ROSTER]|VARCHAR2(30)| [X_JOB_ROSTER ]| |
|[SENIORITY_DATE]|DATE| [DATE]|Y|
|[SENIORITY_LIST_STATUS]|VARCHAR2(2)| [X_SENIORITY_LIST_STATUS ]| |
|[HIRE_SEQUENCE]|NUMBER(5,0)|[NUMBER5|NUMBERn]| |
|[ALT_SENIORITY_DATE]|DATE| [DATE]|Y|
|[DJB_ID]|NUMBER(10,0)| [ID]| |Link to [P2K_CM_JOBS]
At line 27 added one line
This page (revision-8) was last changed on 26-Nov-2021 10:22 by rforbesTop