INF_CV_LEAVELINES
Back to current versionRestore this version

Alias: IVALL#

(INF_CV_LEAVELINES)
Leave Lines

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

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