INF_CV_ACCRUALS
Back to current versionRestore this version

Alias: IVAAC#

(INF_CV_ACCRUALS)

Leave Accruals

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
LEAVE_TYPE_CODEVarchar2(16)Y
LEAVE_POLICY_CODEVarchar2(16)Y
ENTITY_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
LEAVE_POLICY_YEARNumber(5)Y
UNOFFICIALVarchar2(30)Y
START_DATEDate()
END_DATEDate()
LEAVE_POLICY_STATUSVarchar2(30)
EVALUATED_BYVarchar2(50)
EVALUATED_DATEDate()
ENTITLEMENT_FROZENVarchar2(4)
LAST_PAYNO_PROCESSEDNumber(5)
SERVICE_EVALUATION_DATEDate()
ENTITLEMENT_GIVEN_DATEDate()
AC_CODEVarchar2(16)
EFFECTIVEDate()
ACCRUAL_TYPEVarchar2(30)
ACCRUAL_VALUEVarchar2(200)
ACCRUAL_VALUE_OVERRIDEVarchar2(200)
ACCRUAL_VALUE_BASISVarchar2(30)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.