[{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]:
;[Pay Calendar|PAY_CALENDAR_CODE]:
;[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]:
;[Country Name|COUNTRY_CODE]:
;[Bank Transit|BANK_TRANSIT_CODE]:
;[Bank Account|BANK_ACCOUNT]:
;[Starting Number|STARTING_NUMBER]:
;[Start Date/Time|PAY_RUN_START_TIMESTAMP]:
;[End Date/Time|PAY_RUN_END_TIMESTAMP]:
;[Employees|EMPLOYEE_COUNT]:
;[Reversal Pays|REVERSAL_PAY_COUNT]:
;[Adjustment Pays|ADJUSTMENT_PAY_COUNT]:
;[Current Pays|CURRENT_PAY_COUNT]:
;[Future Pays|FUTURE_PAY_COUNT]:
;[Advance Pays|ADVANCE_PAY_COUNT]:
;[Bonus Pays|BONUS_PAY_COUNT]:
;[Retro Pays|RETROACTIVE_PAY_COUNT]:
;[Disbursed|DISBURSED]:
;[Trial Run|TRIAL_RUN]:
;[Journalized|JOURNALIZED]:
;[Journalized Fund|JOURNALIZED_FUND]:



[{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'}] 	

}]