!!!Alias: IVAAC (INF_CV_ACCRUALS) \\ Leave Accruals !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[LEAVE_TYPE_CODE]|Varchar2(16)|Y| |[LEAVE_POLICY_CODE]|Varchar2(16)|Y| |[ENTITY_CODE]|Varchar2(16)|Y| |[PERSON_CODE]|Varchar2(16)|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)| | |[HIRE_DATE]|Date()| | |[LEAVE_POLICY_YEAR]|Number(5)|Y| |[UNOFFICIAL]|Varchar2(30)|Y| |[START_DATE]|Date()| | |[END_DATE]|Date()| | |[LEAVE_POLICY_STATUS]|Varchar2(30)| | |[EVALUATED_BY]|Varchar2(50)| | |[EVALUATED_DATE]|Date()| | |[ENTITLEMENT_FROZEN]|Varchar2(4)| | |[LAST_PAYNO_PROCESSED]|Number(5)| | |[SERVICE_EVALUATION_DATE]|Date()| | |[ENTITLEMENT_GIVEN_DATE]|Date()| | |[AC_CODE]|Varchar2(16)| | |[EFFECTIVE]|Date()| | |[ACCRUAL_TYPE]|Varchar2(30)| | |[ACCRUAL_VALUE]|Varchar2(200)| | |[ACCRUAL_VALUE_OVERRIDE]|Varchar2(200)| | |[ACCRUAL_VALUE_BASIS]|Varchar2(30)| | |[CREATE_DATE]|Date()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.