!!!Alias: EEM
Unique Keys: \\
Child Table: \\
Parent Table: \\
\\ 
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)|[(Lexicon)]| |
|[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)|[(Lexicon)]|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)|[(Lexicon)] |
|[EXPECTED_RETURN_DATE]|Date()|[DATE]| |
|[ROE_LETTER]|Varchar2(1)|[(Lexicon)]| |
|[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\\