!!!Alias: EEM
(P2K_HR_EMPLOYMENTS)

Unique Keys: \\
Child Table: \\
Parent Table: \\
ERD: [ERD-HR2]
\\ 

This table identies the relationship between the employee and the company.
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[ROE_STATUS]|Varchar2(2)|[X_ROE_STATUS]| |
|[EID_ID]|Number(10)|[ID]|Y|Link to [P2K_HR_IDENTITIES]
|[DEN_ID]|Number(10)|[ID]|Y|Link to [P2K_CM_ENTITIES]
|[EMPLOYMENT_TYPE]|Varchar2(2)|[X_EMPLOYMENT_TYPE]|Y|
|[HIRE_DATE]|Date()|[DATE]|Y|
|[TERMINATION_DATE]|Date()|[DATE]| |
|[HIRE_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |
|[ORIGINAL_HIRE_DATE]|Date()|[DATE]|Y|
|[SENIORITY_DATE]|Date()|[DATE]|Y|
|[FIRST_WORK_DATE]|Date()|[DATE]| |
|[LAST_WORK_DATE]|Date()|[DATE]| |
|[DTR_ID]|Number(10)|[ID]| |Link to [P2K_CM_TERMINATION_REASONS]
|[REHIRE_STATUS]|Varchar2(2)|[X_REHIRE_STATUS] |
|[EXPECTED_RETURN_DATE]|Date()|[DATE]| |
|[ROE_LETTER]|Varchar2(1)|[X_ROE_LETTER]| |
|[ROE_ISSUED_DATE]|Date()|[DATE]| |
|[ROE_COMMENTS]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[LAST_PAY_NUMBER]|Number(5)|[NUMBER5|NUMBERn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[INCOME_GUARANTEE]|Number(5)|[PERCENT]| |

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


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.P2K_HR_EMPLOYMENTS] 	
[{InsertPage page='Internal.P2K_HR_EMPLOYMENTS' default='Click to create a new discussion page'}] 	

}]