[{TableOfContents }] !!!CANADIAN PAY RUN INTERFACE FILE The Canadian Pay Run Interface File screen is used to import historical payroll information at a payrun level into the software data structures. Canadian Pay Run Interface File data is maintained on the [INF_CV_PAYRUNS] table. ;[ID|ID]:This field uniquely identifies the Canadian pay run record within the data base. ;[|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)| | [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPPRN] [{InsertPage page='Internal.IVPPRN' default='Click to create a new discussion page'}] }]