Alias: IVSEP#

The INF_CV_EXPERIENCES table is used to import employee experience data, for automatic wage increases, into the software data structures.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
EXPERIENCE_TYPEVarchar2(30)VARCHAR30Y
ENTITY_CODEVarchar2(16)CODEY
DEPARTMENT_CODEVarchar2(16)CODE
UNIT_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODE
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
EXPERIENCE_START_DATEDate()DATE
EXPERIENCE_LAST_STEP_DATEDate()DATE
EXPERIENCE_STATUSVarchar2(30)VARCHAR30Y
UNIT_CODE_SCALEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
STEP_CODEVarchar2(16)CODE
EXPERIENCE_LAST_WORKED_DATEDate()DATE
EXPERIENCE_LAST_EVAL_DATEDate()DATE
ELIGIBLE_DAYSNumber(18)AMT12V6
ELIGIBLE_HOURSNumber(18)AMT12V6
ELIGIBLE_UNITSNumber(18)AMT12V6
PRE_ELIGIBLE_DAYSNumber(18)AMT12V6
PRE_ELIGIBLE_HOURSNumber(18)AMT12V6
PRE_ELIGIBLE_UNITSNumber(18)AMT12V6
WORKED_DAYSNumber(18)AMT12V6
WORKED_HOURSNumber(18)AMT12V6
WORKED_UNITSNumber(18)AMT12V6
ABSENT_DAYSNumber(18)AMT12V6
ABSENT_HOURSNumber(18)AMT12V6
ACCUMULATED_DAYSNumber(18)AMT12V6
ACCUMULATED_HOURSNumber(18)AMT12V6
ACCUMULATED_UNITSNumber(18)AMT12V6
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