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.
User
This field displays the user id of the person who ran UPCALC.
Payroll
This field shows the payroll that was calculated for this payrun.
Pay Point Set
Pay Calendar
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
Country Name
Bank Transit
Bank Account
Starting Number
Start Date/Time
End Date/Time
Employees
Reversal Pays
Adjustment Pays
Current Pays
Future Pays
Advance Pays
Bonus Pays
Retro Pays
Disbursed
Trial Run
Journalized
Journalized Fund

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.
User
This field displays the user id of the person who ran UPCALC.
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.