Payroll Pre-Validation, Extract and Post-Extract
Payroll extraction for the RCMP is carried out bi-weekly. Each detachment (Division) in the database has a separate extraction process. In addition, there are separate processes for Overtime and Standby extractions. This function performs both Overtime and Standby extraction processes.
There are three elements to the Payroll extraction processes:
ˇ Overtime and Standby Pre-validation reports
ˇ Overtime and Standby Extract
ˇ Overtime and Standby Post-payroll reports
Overtime and Standby Pre-Validation Reports
ˇ Select Payroll > Payroll Pre-Validation
ˇ Select the Division to report on
ˇ Select either Overtime Claims or Operational Readiness/Availability Claims
ˇ For the very first extraction run for the selected division and claims type, select the Period end date of the payroll period. Only claims during that period will be reported on. For subsequent runs, the date will be automatically set to two weeks from the last extraction run for the selected division and claims type.
ˇ Select Pre-Validation report (all claims for the selected personnel/teams due to be extracted in the next extraction run) or Data Entry Validation report (all manual claims entered for the selected personnel/teams due to be extracted in the next extraction run)
ˇ Select the preferred report sequence (Sort keys 1 to 5).
ˇ Click Submit
Pre-Validation report
Sample pre-validation overtime report
Data Entry Validation Report
Sample overtime data entry validation report
Overtime and Standby Extract
ˇ Select Payroll > Payroll Extract
ˇ Select Division
ˇ Select Overtime Claims or Standby Claims (separate extracts required)
ˇ For the very first extraction run for the selected division and claims type, select the Period end date of the payroll period. Only claims during that period will be reported on. For subsequent runs, the date will be automatically set to two weeks from the last extraction run for the selected division and claims type.
ˇ Click Submit
ˇ Click Continue to perform the period extract.
Two reports will be produced - one for the Payout of Overtime and one for Confirmation of Banked Lieu time.
Payout of Overtime
Confirmation of Banked Lieu time
Overtime and standby post-payroll reports
ˇ Select Payroll > Post-Payroll Extract
ˇ Select Division to report on
ˇ Select either Overtime Claims or Standby Claims
ˇ Select Period end date to be reported.
ˇ Select Payroll Extract Verification report (all claims for the selected division that were extracted in the selected period); or Reprint Division Report for Payout (to reprint the Payout of Overtime report for the selected period); or Reprint Unpaid Banked Time Confirmation (to reprint the confirmation of banked lieu time report for the selected period); or Download Payroll Extracted .csv file (to download the 'comma separated values' file of the extracted claims for the selected period); or Reverse Payroll Extract (to undo the last extract in order to possibly make changes and re-extract)
ˇ For Payroll Extract Verification Report, also select the preferred report sequence (Sort keys 1 to 5).
ˇ Click Submit
Payroll Extract Verification report
Reprint Division Report for Payout
Reprint Unpaid Banked Time Confirmation
Download Payroll Extracted .csv file
Reverse Payroll Extract
ˇ Click Continue to reverse the extract.
