!!!Alias: IVPPRN The INF_CV_PAYRUNS table is used to import historical payroll information at a payrun level into the software data structures. !!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. |[ENTITY_CODE]|Varchar2(16)|Y| |[PAY_RUN_NUMBER]|Number(10)|Y| |[USER_NAME]|Varchar2(30)|Y| |[PAYROLL_CODE]|Varchar2(16)|Y| |[PAY_POINT_SET_CODE]|Varchar2(16)|Y| |[PAY_CALENDAR_CODE]|Varchar2(16)|Y| |[PAY_PERIOD]|Number(10)|Y| |[PAY_RUN_STAGE]|Varchar2(30)|Y|Validation: Must be one of the fixed lexicon values from [X_PAY_RUN_STAGE] |[PAY_PERIOD_FUTURE]|Number(10)| | |[COUNTRY_CODE]|Varchar2(16)| | |[BANK_TRANSIT_CODE]|Varchar2(16)| | |[BANK_ACCOUNT]|Varchar2(30)| | |[STARTING_NUMBER]|Number(10)| | |[PAY_RUN_START_TIMESTAMP]|Date()| |Validation: Must be a valid date. |[PAY_RUN_END_TIMESTAMP]|Date()| |Validation: Must be a valid date. |[EMPLOYEE_COUNT]|Number(5)| | |[REVERSAL_PAY_COUNT]|Number(5)| | |[ADJUSTMENT_PAY_COUNT]|Number(5)| | |[CURRENT_PAY_COUNT]|Number(5)| | |[FUTURE_PAY_COUNT]|Number(5)| | |[ADVANCE_PAY_COUNT]|Number(5)| | |[BONUS_PAY_COUNT]|Number(5)| | |[RETROACTIVE_PAY_COUNT]|Number(5)| | |[DISBURSED]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True |[TRIAL_RUN]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True |[JOURNALIZED]|Varchar2(4)| | |[JOURNALIZED_FUND]|Varchar2(4)| | |[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.