[{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|ENTITY_CODE]:This field displays the entity associated with the pay run. ;[Pay Run|PAY_RUN_NUMBER]:This field displays the unique sequential number assigned to a pay run by the pay calculation process. ;[User|USER_NAME]:This field displays the user id of the person who ran [UPCALC]. ;[Payroll|PAYROLL_CODE]:This field shows the payroll that was calculated for this payrun. ;[Pay Point Set|PAY_POINT_SET_CODE]:The pay point set is a set of payroll calculation instructions to be executed for this payroll during the pay cycle. These pay point sets are defined in the [IPPP] screen. ;[Pay Calendar|PAY_CALENDAR_CODE]:This field defines which calendar is to be used for this payroll. ;[Pay Period|PAY_PERIOD]:This field identifies the pay period for which the pay run is calculated. ;[Stage|PAY_RUN_STAGE]:This field indicates the stage the pay run is in. ;[Pay Period Future|PAY_PERIOD_FUTURE]:This field identifies the period for any ‘advance’ pays that were calculated. ;[Country Name|COUNTRY_CODE]:This field identifies the county associated with the pay run. ;[Bank Transit|BANK_TRANSIT_CODE]:The bank associated with the pay run is defined in this field. ;[Bank Account|BANK_ACCOUNT]:The bank account associated with the pay run is defined in this field. ;[Starting Number|STARTING_NUMBER]: ;[Start Date/Time|PAY_RUN_START_TIMESTAMP]:This field indicates the date and time that the payrun started ([UPCALC]). ;[End Date/Time|PAY_RUN_END_TIMESTAMP]:This field indicates the date and time that the payrun ended. ;[Employees|EMPLOYEE_COUNT]: ;[Reversal Pays|REVERSAL_PAY_COUNT]:This field shows the total of reversal category headers in the pay run. ;[Adjustment Pays|ADJUSTMENT_PAY_COUNT]:This is the total of adjustment category headers in the pay run. ;[Current Pays|CURRENT_PAY_COUNT]:This field shows the total of regular category headers in the pay run. ;[Future Pays|FUTURE_PAY_COUNT]:This is the total of future category headers in the pay run. ;[Advance Pays|ADVANCE_PAY_COUNT]:This is the total of advance category headers in the pay run. ;[Bonus Pays|BONUS_PAY_COUNT]:This is the total of bonus category headers in the pay run. ;[Retro Pays|RETROACTIVE_PAY_COUNT]:This is the total of retroactive category headers in the pay run. ;[Disbursed|DISBURSED]:This field indicates if the pays in this payrun have been disbursed (UPDISB). ;[Trial Run|TRIAL_RUN]: ;[Journalized|JOURNALIZED]: ;[Journalized Fund|JOURNALIZED_FUND]:This field indicates if the GL Fund processing has been run for this pay run. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPPRN] [{InsertPage page='Internal.IVPPRN' default='Click to create a new discussion page'}] }] ;[Pay Run|PAY_RUN_NUMBER]: ;[Stage|PAY_RUN_STAGE]: This field indicates that the pay run is: *Running *Pay In Progress *Calculated/Paid *Approved (This value is not valid in the 3.05.01 release) *Closed *Journalized *Cancelled ;[Period|PAY_PERIOD]:This field identifies the pay period for which the pay run is calculated. ;[End Date|?PAY_PERIOD_END_DATE]:This field shows the end date of the payrun. ;[Employees|EMPLOYEE_COUNT]:This field displays the number of employees in the pay run. \\ ---- !!Pay Runs tab ;[Entity|ENTITY_CODE]:This field shows the entity to which the pay run belongs. ;[Payroll|PAYROLL_CODE]:This field shows the payroll that was calculated for this payrun. ;[Description|DESCRIPTION]:This field gives the description of the payroll. ;[Future Pay Per|PAY_PERIOD]:This field identifies the period for any ‘advance’ pays that were calculated. ;[Current Pays|CURRENT_PAY_COUNT]:This field shows the total of regular category headers in the pay run. ;[Bonus Pays|BONUS_PAY_COUNT]:This is the total of bonus category headers in the pay run. ;[Future Pays|FUTURE_PAY_COUNT]:This is the total of future category headers in the pay run. ;[Retro Pays|RETROACTIVE_PAY_COUNT]:This is the total of retroactive category headers in the pay run. ;[Advance Pays|ADVANCE_PAY_COUNT]:This is the total of advance category headers in the pay run. ;[Adjustment Pays|ADJUSTMENT_PAY_COUNT]:This is the total of adjustment category headers in the pay run. ;[Reversal Pays|REVERSAL_PAY_COUNT]:This field shows the total of reversal category headers in the pay run. ;[Journalized Fund|JOURNALIZED_FUND]:This field indicates if the GL Fund processing has been run for this pay run. ;[Start Date/Time|PAY_RUN_START_TIMESTAMP]:This field indicates the date and time that the payrun started ([UPCALC]). ;[End Date/Time|PAY_RUN_END_TIMESTAMP]:This field indicates the date and time that the payrun ended. ;[Trial Payrun|TRIAL_RUN]:This field is not valid after the 3.05.01 release. ;[User|USER_NAME]:This field displays the user id of the person who ran [UPCALC]. ;[Disbursed|DISBURSED]:If the Disbursed toggle is ON, the pays in this payrun have been disbursed ([UPDISB]). If this toggle is OFF, the pays have not yet been disbursed. \\ ---- !!Pays tab ;[Employee Name|EEM_ID]:This field holds the person code and name of the employee associated with the pay. ;[Pay #|PAY_NUMBER]:This is the pay number for this pay for the employee. ;[Stage|PAY_HEADER_STAGE]:This field indicates the stage of the pay. *To be Audited (This value is not valid after for the 3.05.02 release and beyond) *Audited (This value is not valid after for the 3.05.02 release and beyond) *Attached to Pay *Pay in Progress *Calculated Pay *Approved (This value is not valid in the 3.05.01 release) *Closed *Cancelled (This value is not valid in the 3.05.01 release) ;[Pay Category|PAY_CATEGORY_CODE]:This field indicates the category of the pay. ;[Seq|PAY_RUN_SEQUENCE]:If an employee has been paid multiple times in the same pay period, this field indicates which pay should be run first. ;[PC|PC_CODE]:This field shows the [pay component|PAY COMPONENTS] number included in this pay. ;[Abbreviation|PC_ABBREVIATION]:This field provides a short description of the [pay component|PAY COMPONENTS] displayed. ;[Amount|AMOUNT]:This field displays the dollar amount or hours associated with the [pay component|PAY COMPONENTS] for this pay. \\ ---- !!Pay Run Totals tab ;[PC|PC_CODE]:This field shows the [pay component|PAY COMPONENTS] included in this pay. ;[Abbreviation|PC_ABBREVIATION]:This field provides a short description of the [pay component|PAY COMPONENTS] displayed. ;[Amount $|AMOUNT]:This field displays the TOTAL dollar amount associated with the [pay component|PAY COMPONENTS] for this pay. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IPVP] [{InsertPage page='Internal.IPVP' default='Click to create a new discussion page'}] }]