Alias: IVAAC#

(INF_CV_ACCRUALS)
Leave Accruals

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
LEAVE_TYPE_CODEVarchar2(16)CODEY
LEAVE_POLICY_CODEVarchar2(16)CODEY
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
LEAVE_POLICY_YEARNumber(5)NUMBER5Y
UNOFFICIALVarchar2(30)VARCHAR30Y
START_DATEDate()DATE
END_DATEDate()DATE
LEAVE_POLICY_STATUSVarchar2(30)VARCHAR30
EVALUATED_BYVarchar2(50)DESCRIPTION
EVALUATED_DATEDate()DATE
ENTITLEMENT_FROZENVarchar2(4)VARCHAR4
LAST_PAYNO_PROCESSEDNumber(5)NUMBER5
SERVICE_EVALUATION_DATEDate()DATE
ENTITLEMENT_GIVEN_DATEDate()DATE
AC_CODEVarchar2(16)CODE
EFFECTIVEDate()EFFECTIVE
ACCRUAL_TYPEVarchar2(30)VARCHAR30
ACCRUAL_VALUEVarchar2(200)VARCHAR200
ACCRUAL_VALUE_OVERRIDEVarchar2(200)VARCHAR200
ACCRUAL_VALUE_BASISVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30