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:

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)YValidation: Must be a unique entity code
PERSON_CODEVarchar2(16)YValidation: Must be a valid PERSON_CODE already defined on the P2K_HR_IDENTITIES table.
EMPLOYMENT_TYPEVarchar2(30)YValidation: If provided, must be one of the fixed lexicon values from X_EMPLOYMENT_TYPE
HIRE_DATEDate()YValidation: Must be a valid date
TERMINATION_CODEVarchar2(16) Validation: The Termination Code provided must be defined on P2K_CM_TERMINATION_REASONS.
ORIGINAL_HIRE_DATEDate() Validation: Must be a valid date. Derivation: If not specified, this field is set to the HIRE_DATE.
SENIORITY_DATEDate() Validation: Must be a valid date. Derivation: If not specified, this field is set to the HIRE_DATE.
HIRE_SEQUENCENumber(5)
FIRST_WORK_DATEDate() Validation: Must be a valid date.
LAST_WORK_DATEDate() Validation: Must be a valid date.
TERMINATION_DATEDate() Validation: Must be a valid date.
ROE_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_ROE_STATUS
ROE_ISSUED_DATEDate() : Must be a valid date.
ROE_LETTERVarchar2(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_COMMENTSVarchar2(2000)
REHIRE_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_REHIRE_STATUS
EXPECTED_RETURN_DATEDate() Validation: Must be a valid date.
INCOME_GUARANTEENumber(5)
USER_FIELD_VALUE_01Varchar2(2000) Looking for EEM01 defined on IMUF
USER_FIELD_VALUE_02Varchar2(2000) Looking for EEM02 defined on IMUF
USER_FIELD_VALUE_03Varchar2(2000) Looking for EEM03 defined on IMUF
USER_FIELD_VALUE_04Varchar2(2000) Looking for EEM04 defined on IMUF
USER_FIELD_VALUE_05Varchar2(2000) Looking for EEM05 defined on IMUF
USER_FIELD_VALUE_06Varchar2(2000) Looking for EEM06 defined on IMUF
USER_FIELD_VALUE_07Varchar2(2000) Looking for EEM07 defined on IMUF
USER_FIELD_VALUE_08Varchar2(2000) Looking for EEM08 defined on IMUF
USER_FIELD_VALUE_09Varchar2(2000) Looking for EEM09 defined on IMUF
USER_FIELD_VALUE_10Varchar2(2000) Looking for EEM10 defined on IMUF
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


Notes #

Click to create a new notes page