Alias:LSL#
(P2K_LR_SENIORITY_LISTS)Unique Keys: Employee EEM_ID + Unit DUN_ID + JOB_ROSTER + Job DJB_ID
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 | ||
CHANGE_USER | VARCHAR2(30) | VARCHAR30 | Y | |
CHANGE_DATE | DATE | DATE | Y | |
CREATE_DATE | DATE | DATE | Y | |
CREATE_USER | VARCHAR2(30) | VARCHAR30 | 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 | ||
ALT_SENIORITY_DATE | DATE | DATE | Y | |
DJB_ID | NUMBER(10,0) | ID | Link to P2K_CM_JOBS |
User Fields: Allowed
Audit Logging: Allowed