RPYEC

RPYEC - CANADIAN PAYROLL YEAR END SUMMARY#

This report 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

FieldDescription
Form CodeMandatory. Enter the current year Form Code, defined on IDFDV.
NOTE: Always use current year form code, such as HL$CAN-T4-20YY.
DO NOT use a prior year form code as the Identifiers may be obsolete.
LOV available
Period TypeMandatory. Enter the Period Type, such as Month or Year. LOV available
Period End DateMandatory. Enter the end date of the reporting period. LOV Available
As of DateMandatory. Enter the start date of the reporting period. LOV Available
Govt Form OptionMandatory. 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 FormOptional. Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government?
Yes/No LOV
Sort Level ByMandatory. How should the employees be grouped for sorting?
Sort Level By LOV available
Sort People ByMandatory. How should the employees on the report be sorted?
Sort People By LOV available
Sort by Active/InactiveOptional. Should the employees on the report be sorted by their status?
Sort By LOV available
Combine Fed RegistOptional. 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
File Name
Trace LevelOptional. 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 AuditOptional. 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 DetailOptional. Defines whether to print the report with employee’s detailed information.
Yes/No LOV available
Trial Print OnlyOptional. 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
Create Data Dump
Process RemittanceOptional. To generate monthly remittances.
Yes/No LOV
Update RemittanceOptional. To update monthly remittances.
Yes/No LOV
User CommentOptional. Users can enter text that will print on the header of the report.

Report Filters

FieldDescription
EntityOptional. To define and report on a specific Entity.
LOV available
Federal Regist SetOptional. To define and report on a specific Federal Registration Set, defined on IDGV.
LOV available
Federal Regist NumberOptional. Defines the Employer Identification Number, defined on IDGV.
LOV available
People ListOptional. To define and report on the people in the defined list.
LOV available
PersonOptional. Enter the Person Code of the employee you are testing with.
LOV available
Select ProvinceOptional. To define and report on a specific Province.
LOV available
Province Regist SetOptional. To define and report on a specific Provincial Registration Set, defined on IDGV. Not required for Annual reporting.
LOV available
Prov Regist NumberOptional. To define and report on a specific Province Registration Number.
LOV available

RPYEC Notes