!!!Alias:LSL
(P2K_LR_SENIORITY_LISTS)

Unique Keys:  Employee [EEM_ID] + Unit [DUN_ID] + [JOB_ROSTER]\\
ERD: [ERD-LR06]

\\
\\
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[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]


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


----
![Notes|Edit:Internal.P2K_LR_SENIORITY_LISTS] 	
[{InsertPage page='Internal.P2K_LR_SENIORITY_LISTS' default='Click to create a new notes page'}]