The Pay Report Output Maintenance process allows you a means of controlling the printing of the payroll stream reports as well as supplies a means of archiving your payroll stream reports. This process uses three new logicals, a new Global directory for archived reports and a new report list directory (one for each payroll).
The Payroll report archiving uses a global directory where reports for ALL payroll reports will be archived. This global directory is pointed to by the global location SRB$OPSRPT:. Each individual payroll would also have a payroll reporting directory created with the logic SRB$OPSLST defined to point to this directory, per payroll.
The Pay Report Output process also requires a batch queue called OPS$PBATCH be defined. This batch queue MUST be reserved for use by the Pay Report Output, which means the batch should not be used for any other purpose. The OPS$PBATCH must be a single stream batch when the payroll reports are to be archived.
Through the Pay Report Output Maintenance, define all applicable payroll stream reports to be viewed and/or printed. Only mark the reports you want printed every payroll run as Yes at the Send to Printer field. You have complete control over which printer and printer form is used for each report printed. Each report can also have 2 additional print definitions. These alternate print options allow you to print either a second copy of the report or you can specify an alternate to print just the last 1 or 2 pages or a report. These alternate print definitions include separate queue and form definitions so you can have the alternate print options output to a different printer.
The Payroll Archive Report [Y/N,Y/N] field in the User Specific Parameter Profile for each payroll allows you to control which payroll stream report control options you want to use. You can use one or both options.
The first Y/N option on this field controls the use of Delayed Print of the payroll stream reports.
The second Y/N option on this field controls archiving of the payroll stream reports as well as additional payroll reports through out the payroll system.
Delayed Print Option
When you want to control which payroll stream reports are to be printed, you would run the payroll stream phases with the Output set to point to the new global print directory. The reports will be generated at this new location. When you say 'Y'es to the Delayed print option, the system will automatically generate a batch submission to print all the reports you have selected. The generation of the batch to print the reports is created at the end of each payroll phase with submission to the OPS$PBATCH batch queue. The log created for the printing of the payroll stream reports will be the same job number of the payroll stream with the sixth character changed to a D for Earnings Detail, E for Earnings Summary and F for Payroll Processing, for example#####D.LOG.
Archiving Payroll Stream Reports
This option copies all payroll stream reports created into the global print directory changing the report name to reflect the payroll, pay period and report. For example, the Earnings Summary report could be renamed TEAC_199902_EARNSUM.RPT, where that payroll ID code is TEAC and the pay period is 199902. Each report generated by the payroll stream has a unique name. Changing the report names allow the reports to be easily identified. These reports can then be maintained on your system or moved onto another form of storage, such as CD ROM, for permanent storage. Renaming the reports allows for easy identification of report retrieval. When archiving the payroll stream reports is active the system automatically generates a batch job, which does the report copies at the end of each payroll phase with submission to the OPS$PBATCH batch queue. Note the OPS$PBATCH MUST be a single stream batch queue for this purpose. The log created for archiving of the payroll reports will be the same job number of the payroll stream phase with the sixth character changed to an A for Earnings Detail, B for Earnings Summary and C for Payroll Processing, for example #####A.LOG.
Archiving of payroll reports is automatically disabled if the pay period to be run has already been updated. This feature will prevent the actual payroll reports from being overlaid later.
When archiving the payroll reports is active, access to the Pay Report Output Review is based on the payroll ID code and pay period number. Reports are listed based on their new names. All available reports are listed regardless of the phase of the payroll stream.
When both Delayed print and Archiving reports are being used, the system archives the reports before the delayed print is processed for each phase of the payroll stream. Under these conditions, the Delayed print will use the newly created archived reports in the global print directory for printing instead of the original reports. The advantage is you do not have to set your output to point to the global print directory when you run the phases of the payroll stream. Output can be set to any location or printer. The only restriction is when your reports are set to print. You CANNOT have the reports automatically set to delete. With this method, the global print directory will only contain the archived reports using the full report names.
The following is a complete list of the archive file names for all applicable payroll stream reports.
Earnings Detail
-
######.LST ####_YYYYPP_EARNDET.RPT Earnings Detail Report
Earnings Summary
-
#####I.LST ####_YYYYPP_BNKEARN.RPT BANKED Earnings Report
-
#####J.LST ####_YYYYPP_EARNSUM.RPT Earnings Summary
-
#####N.LST ####_YYYYPP_COMPARE.RPT Gross Pay Comparison Report
-
#####S.LST ####_YYYYPP_TERMPay.RPT SASKATCHEWAN TERMINATION SALARY CALCULATIONS
Payroll Processing
-
#####E.LST ####_YYYYPP_STANDCT.RPT Standard COSTING
-
#####F.LST ####_YYYYPP_CHQREG.RPT CHEQUE REGISTER
-
#####K.LST ####_YYYYPP_PAPERT.RPT PAPER TRANSFER
-
#####C.LST ####_YYYYPP_OPTCHQ.RPT Optional CHEQUE RECEIPT
-
#####B.LST ####_YYYYPP_DEDREG.RPT Deduction REGISTER
-
#####H.LST ####_YYYYPP_TBLDED.RPT Deduction Table REGISTER
-
#####Y.LST ####_YYYYPP_PENRECL.RPT SASKATCHEWAN YEAR END PENSION RECALC
-
#####Z.LST ####_YYYYPP_TERMPEN.RPT SASKATCHEWAN TERMINATION PENSION RECALCULATION
-
#####D.LST ####_YYYYPP_DEDARR.RPT Deduction Arrears Register
-
#####G.LST ####_YYYYPP_BANKTSF.RPT ELECTRONIC BANK TRANSFER
-
#####A.LST ####_YYYYPP_PayREG.RPT Payroll REGISTER
-
#####L.LST ####_YYYYPP_LIFECOV.RPT Optional LIFE INSURANCE
-
#####M.LST ####_YYYYPP_STOBANK.RPT STORAGE BANK Report
-
#####P.LST ####_YYYYPP_BOGPEN.RPT BOGUS CPP PENSION Report
-
#####R.LST ####_YYYYPP_INTUPLR.RPT INTERLINK UPLOAD Pay Processing
-
#####V.LST ####_YYYYPP_EIDET.RPT EI Detail Report
-
#####W.LST ####_YYYYPP_GLSUM.RPT GL Summary Report
-
#####X.LST ####_YYYYPP_GLDIST.RPT GL Distribution Report
-
#####4.LST ####_YYYYPP_DEDCOMP.RPT Deduction Comparison Report (Optional)
-
#####5.LST ####_YYYYPP_LIFECOMP.RPT LIFE INSURANCE COVERAGE Comparison (Optional)
Payroll Update
-
#####E.LST ####_YYYYPP_STANDCT.RPT Standard COSTING
-
#####A.LST ####_YYYYPP_PYAUDIT.RPT MASTER FILE AUDIT Report
-
#####B.LST ####_YYYYPP_DBAUDIT.RPT DATA Base AUDIT Report
-
######.LST ####_YYYYPP_PayTOT.RPT Payroll TOTALS
-
#####D.LST ####_YYYYPP_BANKDIF.RPT STORAGE BANK Comparison
-
#####G.LST ####_YYYYPP_BANKSUM.RPT STORAGE BANK UPDATE
-
#####H.LST ####_YYYYPP_TERMLST.RPT EMPLOYEE TERMINATION
-
#####U.LST ####_YYYYPP_INTUPLU.RPT INTERLINK UPLOAD Payroll UPDATE
-
#####J.LST ####_YYYYPP_BASJRN.RPT JOURNAL ENTRY INTERFACE
-
#####I.LST ####_YYYYPP_BASINV.RPT INVOICE INTERFACE
Archiving the Detail GL Distribution Report-Online will only occur when this report is actually run to disk, and only when a 'F'ull version of the report is selected.
Detail GL Distribution Report - Online
-
######.LST ####_YYYYPP_GLDETON.RPT
The following additional payroll reports will also be archived, when the process is run to disk:
-
Build PDF / Email Earnings Statements ####_YYYYPP_EARNPDF.RPT
-
Build PDF / Email W2 Statements ####_YYYY01_W2PDF.RPT archived to the first pay period of the taxation year
-
Build PDF / Email T4/T4A Statements ####_YYYY01_T4F6PDF.RPT
-
including T4F / T4A and MERG_ for groups 6,7 and 8 archived to the first pay period of the taxation year
-
Where ## is an increment number from 01 to 99 for multiple reports per period
-
Personnel Absentee Bank Changes (HR 3,5,1) ####_YYYYPP_ABSBK##.RPT
-
Absence Employee Costing (HR 3,5,2,1) ####_YYYYPP_ABSCO##.RPT
-
Absence Employee Interface (HR 3,5,2,4) ####_YYYYPP_ABSTM##.RPT
-
Replacement Employee Costing (HR 3,5,2,5) ####_YYYYPP_REPCO##.RPT
-
Replacement Employee Interface (HR 3,5,2,8) ####_YYYYPP_REPTM##.RPT
-
Detailed Storage Bank Interface (HR 3,5,6,2) ####_YYYYPP_BNKIT##.RPT
-
Timesheet Entry Generation Process ####_YYYYPP_PayTM##.RPT
-
Timesheet/Variable Deduction Interface ####_YYYYPP_PayTM##.RPT
-
####_YYYYPP_PayVR##.RPT
-
WEB Timesheet Entry Import Process ####_YYYYPP_WEBTM##.RPT
-
Storage Bank Adjustments ####_YYYYPP_BNKAJ##.RPT
-
Cheque/Deposit Cancellations ####_YYYYPP_CHCAN##.RPT
-
Manual Cheque Entry ####_YYYYPP_MANCH##.RPT
-
Year to Date Adjustments ####_YYYYPP_YTDAJ##.RPT
-
Statement History Adjustments ####_YYYYPP_Sthis##.RPT
-
Arrears Adjustments ####_YYYYPP_AREAR##.RPT
-
Detailed Adjustments Report ####_YYYYPP_DETAD##.RPT
-
Deduction Advance Pay Calculation ####_YYYYPP_ADVNC##.RPT
-
Employee Salary Grid Increment ####_YYYYPP_GRDIN##.RPT
-
Salary Grid/Payroll Update ####_YYYYPP_GRDUP##.RPT
-
Salary Grid Increment by Storage Bank ####_YYYYPP_GRDIN##.RPT
-
Salary Grid Increment by Date ####_YYYYPP_GRDIN##.RPT