P 2 K_LR_SENIORITY_LISTS
Back to current versionRestore this version

Alias:LSL#

(P2K_LR_SENIORITY_LISTS)

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



Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNUMBER(10,0) IDY
DUN_IDNUMBER(10,0) IDY
EEM_IDNUMBER(10,0) IDY
HIRE_SEQUENCENUMBER(5,0) NUMBER5
CHANGE_USERVARCHAR2(30) VARCHAR30Y
CHANGE_DATEDATE DATEY
CREATE_DATEDATE DATEY
CREATE_USERVARCHAR2(30) VARCHAR30Y
JOB_ROSTERVARCHAR2(30) X_JOB_ROSTER
SENIORITY_DATEDATE DATEY
SENIORITY_LIST_STATUSVARCHAR2(2) X_SENIORITY_LIST_STATUS

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page