!!!Alias: IVEEM
The INF_CV_EMPLOYMENTS table is used to import employee’s employment information into the software data structures.   Employees normally will have one employment record (that may have date effective splits) but may have multiple employment types.  Each employment record reflects one period of employment under one set of terms.
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |
|[ENTITY_CODE]|Varchar2(16)|Y|
|[PERSON_CODE]|Varchar2(16)|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|Y|
|[HIRE_DATE]|Date()|Y|
|[TERMINATION_CODE]|Varchar2(16)| |
|[ORIGINAL_HIRE_DATE]|Date()| |
|[SENIORITY_DATE]|Date()| |
|[HIRE_SEQUENCE]|Number(5)| |
|[FIRST_WORK_DATE]|Date()| |
|[LAST_WORK_DATE]|Date()| |
|[TERMINATION_DATE]|Date()| |
|[ROE_STATUS]|Varchar2(30)| |
|[ROE_ISSUED_DATE]|Date()| |
|[ROE_LETTER]|Varchar2(30)| |
|[ROE_COMMENTS]|Varchar2(2000)| |
|[REHIRE_STATUS]|Varchar2(30)| |
|[EXPECTED_RETURN_DATE]|Date()| |
|[INCOME_GUARANTEE]|Number(5)| |
|[USER_FIELD_VALUE_01]|Varchar2(2000)| |
|[USER_FIELD_VALUE_02]|Varchar2(2000)| |
|[USER_FIELD_VALUE_03]|Varchar2(2000)| |
|[USER_FIELD_VALUE_04]|Varchar2(2000)| |
|[USER_FIELD_VALUE_05]|Varchar2(2000)| |
|[USER_FIELD_VALUE_06]|Varchar2(2000)| |
|[USER_FIELD_VALUE_08]|Varchar2(2000)| |
|[USER_FIELD_VALUE_09]|Varchar2(2000)| |
|[USER_FIELD_VALUE_10]|Varchar2(2000)| |
|[CREATE_DATE]|Date()| |
|[CREATE_USER]|Varchar2(30)| |
|[CHANGE_DATE]|Date()| |
|[CHANGE_USER]|Varchar2(30)| |