!!!Alias: IVAAC (INF_CV_ACCRUALS) \\ Leave Accruals !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[LEAVE_TYPE_CODE]|Varchar2(16)|[CODE]|Y| |[LEAVE_POLICY_CODE]|Varchar2(16)|[CODE]|Y| |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[PERSON_CODE]|Varchar2(16)|[CODE]|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HIRE_DATE]|Date()|[DATE]| | |[LEAVE_POLICY_YEAR]|Number(5)|[NUMBER5|NUMBERn]|Y| |[UNOFFICIAL]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[START_DATE]|Date()|[DATE]| | |[END_DATE]|Date()|[DATE]| | |[LEAVE_POLICY_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[EVALUATED_BY]|Varchar2(50)|[DESCRIPTION]| | |[EVALUATED_DATE]|Date()|[DATE]| | |[ENTITLEMENT_FROZEN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[LAST_PAYNO_PROCESSED]|Number(5)|[NUMBER5|NUMBERn]| | |[SERVICE_EVALUATION_DATE]|Date()|[DATE]| | |[ENTITLEMENT_GIVEN_DATE]|Date()|[DATE]| | |[AC_CODE]|Varchar2(16)|[CODE]| | |[EFFECTIVE]|Date()|[EFFECTIVE]| | |[ACCRUAL_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ACCRUAL_VALUE]|Varchar2(200)|[VARCHAR200|VARCHARnn]| | |[ACCRUAL_VALUE_OVERRIDE]|Varchar2(200)|[VARCHAR200|VARCHARnn]| | |[ACCRUAL_VALUE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |