Table of Contents
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
- This field uniquely identifies the Canadian pay run record within the data base.
- Entity
- This field displays the entity associated with the pay run.
- Pay Run
- This field displays the unique sequential number assigned to a pay run by the pay calculation process.
- Payroll
- This field shows the payroll that was calculated for this payrun.
- Pay Point Set
- 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
- This field defines which calendar is to be used for this payroll.
- Pay Period
- This field identifies the pay period for which the pay run is calculated.
- Stage
- This field indicates the stage the pay run is in.
- Pay Period Future
- This field identifies the period for any ‘advance’ pays that were calculated.
- Country Name
- This field identifies the county associated with the pay run.
- Bank Transit
- The bank associated with the pay run is defined in this field.
- Bank Account
- The bank account associated with the pay run is defined in this field.
- Starting Number
- This field indicates the number of the first check in the series for the pay run.
- Start Date/Time
- This field indicates the date and time that the payrun started (UPCALC).
- End Date/Time
- This field indicates the date and time that the payrun ended.
- Employees
- This field displays the number of employees in the pay run.
- Reversal Pays
- This field shows the total of reversal category headers in the pay run.
- Adjustment Pays
- This is the total of adjustment category headers in the pay run.
- Current Pays
- This field shows the total of regular category headers in the pay run.
- Future Pays
- This is the total of future category headers in the pay run.
- Advance Pays
- This is the total of advance category headers in the pay run.
- Bonus Pays
- This is the total of bonus category headers in the pay run.
- Retro Pays
- This is the total of retroactive category headers in the pay run.
- Disbursed
- This field indicates if the pays in this payrun have been disbursed (UPDISB).
- Journalized Fund
- This field indicates if the GL Fund processing has been run for this 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
- This field identifies the pay period for which the pay run is calculated.
- End Date
- This field shows the end date of the payrun.
- Employees
- This field displays the number of employees in the pay run.
Pay Runs tab#
- Entity
- This field shows the entity to which the pay run belongs.
- Payroll
- This field shows the payroll that was calculated for this payrun.
- Description
- This field gives the description of the payroll.
- Future Pay Per
- This field identifies the period for any ‘advance’ pays that were calculated.
- Current Pays
- This field shows the total of regular category headers in the pay run.
- Bonus Pays
- This is the total of bonus category headers in the pay run.
- Future Pays
- This is the total of future category headers in the pay run.
- Retro Pays
- This is the total of retroactive category headers in the pay run.
- Advance Pays
- This is the total of advance category headers in the pay run.
- Adjustment Pays
- This is the total of adjustment category headers in the pay run.
- Reversal Pays
- This field shows the total of reversal category headers in the pay run.
- Journalized Fund
- This field indicates if the GL Fund processing has been run for this pay run.
- Start Date/Time
- This field indicates the date and time that the payrun started (UPCALC).
- End Date/Time
- This field indicates the date and time that the payrun ended.
- Trial Payrun
- This field is not valid after the 3.05.01 release.
- 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
- This field holds the person code and name of the employee associated with the pay.
- Pay #
- This is the pay number for this pay for the employee.
- 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
- This field indicates the category of the pay.
- Seq
- If an employee has been paid multiple times in the same pay period, this field indicates which pay should be run first.
- PC
- This field shows the pay component number included in this pay.
- Abbreviation
- This field provides a short description of the pay component displayed.
- Amount
- This field displays the dollar amount or hours associated with the pay component for this pay.
Pay Run Totals tab#
- PC
- This field shows the pay component included in this pay.
- Abbreviation
- This field provides a short description of the pay component displayed.
- Amount $
- This field displays the TOTAL dollar amount associated with the pay component for this pay.
