Alias: IVALL#

The INF_CV_LEAVELINES table is used to import employee absence information into the software data structures.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
START_DATEDate()DATEY
END_DATEDate()DATEY
ORIG_LEAVE_BEGIN_DATEDate()DATEY
ACCRUAL_STATUSVarchar2(30)VARCHAR30Y
LEAVE_TYPE_CODEVarchar2(16)CODE
TIME_CODEVarchar2(16)CODE
LINE_NUMBERNumber(5)NUMBER5
DESCRIPTIONVarchar2(50)DESCRIPTION
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
LEAVE_REASONVarchar2(30)VARCHAR30
LEAVE_CERTIFIEDVarchar2(30)VARCHAR30
PAYROLL_COMPLETEVarchar2(4)VARCHAR4
LEAVE_APPROVALVarchar2(30)VARCHAR30
LEAVE_TIME_NOT_TAKENNumber(18)AMT12V6
ABSENCE_SOURCE_MODULEVarchar2(30)VARCHAR30
ABSENCE_SOURCE_KEYVarchar2(50)VARCHAR50
ENTITLEMENT_EARNEDVarchar2(4)VARCHAR4
OVERALL_LEAVE_TIMENumber(18)AMT12V6
TIME_BASISVarchar2(30)VARCHAR30
BANK_TIME_STILL_OWINGVarchar2(4)VARCHAR4
ACTUAL_LEAVEVarchar2(4)VARCHAR4
AUDIT_TEXTVarchar2(4000)VARCHAR4000
START_TIMENumber(5)MINUTES
END_TIMENumber(5)MINUTES
PARTIALLY_PROCESSEDVarchar2(4)VARCHAR4
PROJECTED_TIMENumber(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