!!!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]| |