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 nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30Y
HIRE_DATEDate()DATEY
TERMINATION_CODEVarchar2(16)CODE
ORIGINAL_HIRE_DATEDate()DATE
SENIORITY_DATEDate()DATE
HIRE_SEQUENCENumber(5)NUMBER5
FIRST_WORK_DATEDate()DATE
LAST_WORK_DATEDate()DATE
TERMINATION_DATEDate()DATE
ROE_STATUSVarchar2(30)VARCHAR30
ROE_ISSUED_DATEDate()DATE
ROE_LETTERVarchar2(30)VARCHAR30
ROE_COMMENTSVarchar2(2000)VARCHAR2000
REHIRE_STATUSVarchar2(30)VARCHAR30
EXPECTED_RETURN_DATEDate()DATE
INCOME_GUARANTEENumber(5)PERCENT
USER_FIELD_VALUE_01Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_02Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_03Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_04Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_05Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_06Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_07Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_08Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_09Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_10Varchar2(2000)VARCHAR2000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top