!!!Alias: IVPDS The INF_CV_DISBURSEMENTS table is used to import historical employee payroll information at a disbursement level into the software data structures. !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[PERSON_CODE]|Varchar2(16)|[CODE]|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HIRE_DATE]|Date()|[DATE]| | |[PAY_NUMBER]|Number(5)|[NUMBER5|NUMBERn]|Y| |[PAY_ISSUE_DATE]|Date()|[DATE]|Y| |[DISBURSEMENT_AMOUNT]|Number(14)|[AMT12V2|AMTnn]|Y| |[PAY_DESTINATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[COUNTRY_CODE]|Varchar2(16)|[CODE]| | |[BANK_TRANSIT_CODE]|Varchar2(16)|[CODE]| | |[BANK_ACCOUNT]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[STARTING_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[CHECK_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[CHECK_AMOUNT]|Number(14)|[AMT12V2|AMTnn]| | |[CHECK_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHECK_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PAID_TO_ORDER_OF]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[CLEAR_AMOUNT]|Number(14)|[AMT12V2|AMTnn]| | |[CLEAR_DATE]|Date()|[DATE]| | |[CHECK_PRINTED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[PREVIOUS_OUTSTANDING]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[RECONCILE_DATE]|Date()|[DATE]| | |[OVERRIDE_CHECK_DATE]|Date()|[DATE]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |