!!!Alias: IVEEM
(INF_CV_EMPLOYMENTS)

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.

Tables loaded:
*[P2K_HR_EMPLOYMENTS] (first record for each employee only)
*[P2K_AM_USER_FIELD_VALUES] (one for each user field value provided) 
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ENTITY_CODE]|Varchar2(16)|Y|Validation:	Must be a unique entity code
|[PERSON_CODE]|Varchar2(16)|Y|Validation:	Must be a valid [PERSON_CODE] already defined on the [P2K_HR_IDENTITIES] table.
|[EMPLOYMENT_TYPE]|Varchar2(30)|Y|Validation: 	If provided, must be one of the fixed lexicon values from [X_EMPLOYMENT_TYPE]
|[HIRE_DATE]|Date()|Y|Validation:	Must be a valid date
|[TERMINATION_CODE]|Varchar2(16)| |Validation:	The Termination Code provided must be defined on [P2K_CM_TERMINATION_REASONS].  
|[ORIGINAL_HIRE_DATE]|Date()| |Validation:	Must be a valid date. Derivation:	If not specified, this field is set to the [HIRE_DATE].
|[SENIORITY_DATE]|Date()| |Validation:	Must be a valid date. Derivation:	If not specified, this field is set to the [HIRE_DATE].
|[HIRE_SEQUENCE]|Number(5)| |
|[FIRST_WORK_DATE]|Date()| |Validation:	Must be a valid date.
|[LAST_WORK_DATE]|Date()| |Validation:	Must be a valid date.
|[TERMINATION_DATE]|Date()| |Validation:	Must be a valid date.
|[ROE_STATUS]|Varchar2(30)| |Validation: 	If provided, must be one of the fixed lexicon values from [X_ROE_STATUS]
|[ROE_ISSUED_DATE]|Date()| |:	Must be a valid date.
|[ROE_LETTER]|Varchar2(30)| |Validation: 	If provided, must be one of the valid letters supported by the Record of Employment form (A-M).  See the ROE form for the explanation of these codes in detail. Must be one of the fixed lexicon values from [X_ROE_LETTER].
|[ROE_COMMENTS]|Varchar2(2000)| |
|[REHIRE_STATUS]|Varchar2(30)| |Validation: 	If provided, must be one of the fixed lexicon values from [X_REHIRE_STATUS] 
|[EXPECTED_RETURN_DATE]|Date()| |Validation:	Must be a valid date.
|[INCOME_GUARANTEE]|Number(5)| |
|[USER_FIELD_VALUE_01]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM01, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_02]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM02, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_03]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM03, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_04]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM04, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_05]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM05, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_06]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM06, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_08]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM08, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_09]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM09, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[USER_FIELD_VALUE_10]|Varchar2(2000)| |Validation:	This value is applied against the User defined field EEM10, which must have been previously defined in the [P2K_AM_USER_FIELDS] table.  This may be accomplished through the cv_uf_employments.sql script.
|[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


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

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

}]