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 | ||
| 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
