!!!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|PRIME_ASSIGNMENT]
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[EEM_ID]|Number(10)|[ID]|Y|Link to [P2K_HR_EMPLOYMENTS]
|[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[PRIME_ASSIGNMENT]|Varchar2(1)|[TOGGLE]| |
|[ASSIGNMENT_TYPE]|Varchar2(2)|[X_ASSIGN_TYPE]|Y|
|[ASSIGNMENT_STATUS]|Varchar2(2)|[X_ASSIGN_STATUS]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_START_DATE]|Date()|[DATE]|Y|
|[ASSIGNMENT_END_DATE]|Date()|[DATE]| |
|[TS_SENIORITY_DATE]|Date()|[DATE]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[WAGE_PROGRESSION_DATE]|Date()|[DATE]| |


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_LAST_REVIEW_DATE]


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


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