!!!Alias: IVPPRN (INF_CV_PAYRUNS) \\ Pay Runs !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[PAY_RUN_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y| |[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[PAYROLL_CODE]|Varchar2(16)|[CODE]|Y| |[PAY_POINT_SET_CODE]|Varchar2(16)|[CODE]|Y| |[PAY_CALENDAR_CODE]|Varchar2(16)|[CODE]|Y| |[PAY_PERIOD]|Number(10)|[NUMBER10|NUMBERn]|Y| |[PAY_RUN_STAGE]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[PAY_PERIOD_FUTURE]|Number(10)|[NUMBER10|NUMBERn]| | |[COUNTRY_CODE]|Varchar2(16)|[CODE]| | |[BANK_TRANSIT_CODE]|Varchar2(16)|[CODE]| | |[BANK_ACCOUNT]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[STARTING_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[PAY_RUN_START_TIMESTAMP]|Date()|[TIMESTAMP]| | |[PAY_RUN_END_TIMESTAMP]|Date()|[TIMESTAMP]| | |[EMPLOYEE_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[REVERSAL_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[ADJUSTMENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[CURRENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[FUTURE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[ADVANCE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[BONUS_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[RETROACTIVE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | |[DISBURSED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[TRIAL_RUN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[JOURNALIZED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[JOURNALIZED_FUND]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |