INF_CV_EXPERIENCES
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation