CANADIAN PAYROLL YEAR END SUMMARY#
This extracts information from YTD according to the Form Code on IDFDV and produces the Summary Total Report by government registration. This process also stores the results by GVT Run Number for each employee in the Government Reporting table.
RPYEC Report Parameters & Filters#
Report Parameters
| Field | Description |
|---|---|
| Form Code | Mandatory. Enter the current year Form Code, defined on IDFDV. NOTE: Always use current year form code, such as HL$CAN-T4-2017. DO NOT use a prior year form code as the Identifiers may be obsolete. LOV available |
| Period Type | Mandatory. Enter the Period Type, such as Month or Year. LOV available |
| Period End Date | Mandatory. Enter the end date of the reporting period. LOV Available |
| As of Date | Mandatory. Enter the start date of the reporting period. LOV Available |
| Govt Form Option | Mandatory. Defines the type of form to be run. Options are: * 01: New forms only * 02: All normal forms * 03: Duplicate forms * 04: Amended forms * 05: Rejected forms * 06: Cancelled forms. Govt Form Option LOV available |
| Retain Amend/Reject Form | Optional. Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government? Yes/No LOV |
| Sort Level By | Mandatory. How should the employees be grouped for sorting? Sort Level By LOV available |
| Sort People By | Mandatory. How should the employees on the report be sorted? Sort People By LOV available |
| Sort by Active/Inactive | Optional. Should the employees on the report be sorted by their status? Sort By LOV available |
| Combine Fed Regist | Optional. Should all the selected Federal Registrations reporting be combined? If a Province code is defined in the report filters, users can combine the Federal Registration Numbers with the Provincial Registration Numbers so that employees are grouped together for the same Provincial Registration Numbers. Yes/No LOV |
| Directory Name | Optional. Defines the name of the directory where the government Magnetic Media file will be stored. |
| File Name | Optional. Defines the name of the government Magnetic Media file. |
| Trace Level | Optional. Defines the level of detail to be printed on the report. Users should always run RPYEC with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing or debugging. If there is problem in RPYEC and a user needs to determine which employee has the problem, the user should run RPYEC with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem. When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statements by running RMEX for the RPYEC Execution ID. After determining which employee has the problem, users should run RPYEC for one employee with the Trace Level set to Utility Trace to determine the problem in detail. Trace Level LOV available. |
| Regist/Set Up Audit | Optional. Defines whether to print exceptions that may exist from set up. Options are: * 00 Do not print, run * 01: Print, do not run * 02: Print and run * 03: Excp and run. Print and Run LOV available |
| Print Employee Detail | Optional. Defines whether to print the report with employee’s detailed information. Yes/No LOV available |
| Trial Print Only | Optional. Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed. When set to Yes, the field will not be updated. When set to No, the Print Stage will be changed to Forms Printed. Yes/No LOV |
| Create Trace File | Optional. Should a trace file be generated? One file is for dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages. Yes/No LOV |
| Create Data Dump | Optional. When set to Yes, the RPYEC process will generate data dump files with a .csv extension for the Federal information. Users can open these data dump files in Excel for debugging and balancing purposes. Yes/No LOV |
| Process Remittance | Optional. To generate monthly remittances. Yes/No LOV |
| Update Remittance | Optional. To update monthly remittances. Yes/No LOV |
| User Comment | Optional. Users can enter text that will print on the header of the report. |
Report Filters
| Field | Description |
|---|---|
| Entity | Optional. To define and report on a specific Entity. LOV available |
| Federal Regist Set | Optional. To define and report on a specific Federal Registration Set, defined on IDGV. LOV available |
| Federal Regist Number | Optional. Defines the Employer Identification Number, defined on IDGV. LOV available |
| People List | Optional. To define and report on the people in the defined list. LOV available |
| Person | Optional. Enter the Person Code of the employee you are testing with. LOV available |
| Select Province | Optional. To define and report on a specific Province. LOV available |
| Province Regist Set | Optional. To define and report on a specific Provincial Registration Set, defined on IDGV. Not required for Annual reporting. LOV available |
| Prov Regist Number | Optional. To define and report on a specific Province Registration Number. LOV available |
RPYEC Notes
- The RPYEC process produces a Summary Total Report by Government Registrations. Users must balance this report to the RPREGT report.
- Each RPYEC run generates one Government Run Number (GVT Run).
- All employees processed by the RPYEC run belong to this GVT Run Number. At end of RPYEC, the Government Reporting Statistics are printed with the generated GVT Run Number. After RPYEC is run, users can go into the IPGR (Government Run) form to view the details by the GVT Run number.
- On the IPGR form, the employee’s detail government reporting information can be viewed. Alternately, users can go directly to the IPGH (Government Header) form by employee to view this information.
- Users can process many RPYEC runs for different sets of employees. This generates multiple GVT Run numbers. Users can run one RPGRC (Government Reporting) run to pick up all GVT Runs to generate one Print Form file for printing and one government interface file.
- Employee’s Government Header information are re-generated by subsequent RPYEC runs if the Government Header has not been filed to the government. The same IPGH information is removed automatically when a new IPGH is re-generated.
- At the end of each run, the RPYEC process removes any GVT Run Number that does not have GVT Header associated with it.
- Users can run the RPYEC process concurrently for different sets of employees.
- At the beginning of the RPYEC run, the Execution Run Log is stamped with the Execution Start Date. At the end of RPYEC run, the Execution End Date is stamped.
- For concurrent RPYEC runs that have not been finished with the Execution End Date, any other concurrent RPYEC runs will not remove the GVT Run Number, even if there are no GVT Headers.
