Alias: EAS#

(P2K_HR_ASSIGNMENTS)

Unique Keys: EEM_ID (Employment) + ASSIGNMENT_CODE + ASSIGNMENT_START_DATE
Child Table: P2K_HR_ASSIGNMENT_DETAILS
Parent Table: P2K_HR_EMPLOYMENTS

This table identifies an assignment of an employee. Employees may have multiple assignments, but only one may be a primary assignment

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EEM_IDNumber(10)IDYLink to P2K_HR_EMPLOYMENTS
ASSIGNMENT_CODEVarchar2(16)CODEY
PRIME_ASSIGNMENTVarchar2(1)TOGGLE
ASSIGNMENT_TYPEVarchar2(2)X_ASSIGN_TYPEY
ASSIGNMENT_STATUSVarchar2(2)X_ASSIGN_STATUSY
DESCRIPTIONVarchar2(50)DESCRIPTION
NEXT_REVIEW_DATEDate()DATE
ASSIGNMENT_START_DATEDate()DATEY
ASSIGNMENT_END_DATEDate()DATE
TS_SENIORITY_DATEDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
WAGE_PROGRESSION_DATEDate()DATE

Derived Fields#

Column Name
DRV_LAST_REVIEW_DATE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page