CANADIAN GOVERNMENT REPORTING#

Processing Information#

This is the Government Payroll Reporting for Canada. This process reads the Government Reporting table information generated by RPYEC.

A Summary Total Report, by government registration, or by employee detail, for a selected Form Code as defined on IDFDV, is produced.

Each RPGRC run generates one GVT Run (Government Run Number) and all employees processed by a RPGRC run belong to this GVT Run Number.

After RPGRC is run, user can go into IPGR to view details by GVT Run number. From the IPGR form, the user can pop into an employee’s detail government reporting information on IPGH (Government Header) form by double clicking on the employee line. Alternately, users can also go directly to IPGH form by employee.

User can generate many RPGRC runs for different sets of employees. This generates multiple GVT Run numbers.

The RPGRC process generates the:

  • XML files for the Print Form programs, RPT4, RPT4A, RPRL1 etc., to print the T4, T4A or Releve Forms.
  • Magnetic Media file to be submitted to the government.

At the end of each run, RPGRC removes any GVT Run Number that does not have any GVT Headers associated to it.

Once the government xml file is generated, it is ready for an xml parser validation prior to sending the file to the government.


RPGRC Report Parameters#

FieldDescription
Form CodeMandatory. Enter the current year Form Code, defined on IDFDV
Govt Interface FormatMandatory. Defined the IDIFform Interface Format Code to be used to generate the Magnetic Media file to send to the government.
Period TypeMandatory. Defines the period type for the report, such as Year, Quarter
Period End DateMandatory. Defines the end date of the reporting period
As of DateMandatory. Defines the start date of the reporting period
Govt Form OptionMandatory. Defines the type of form to be run. The options are:
*01: New forms only
*02: All normal forms
*03: Duplicate Forms
*04: Amended forms
*05: Rejected Froms
*06: Cancelled forms.
Sort Level ByMandatory. Defines at what level the employees should be sorted. The options are:
* Not Specified
* Department
* Department T4
* Pay Destination
* Location
* T4 Destination
Sort People ByMandatory. Defines how the employees should be sorted. The options are:
*Person Code
*Last Name, First Name
*Destin, Last, First
Sort by Active/InactiveDefines if the employees should be sorted by the active/inactive status. Optional.
Directory NameDefines the directory name where the media file will be saved, such as OUTPUT. Mandatory if the "Create Trace File" field is set to YES.
File NameDefines the name of the file that will be created, such as RPGRC-2017-mex.txt. Optional
Trace Levelthe level of detail to be printed on the exception report. Optional. Users should always run RPYEU with the Trace Level set to "Exceptions Only" when running all employees.
Print Employee DetailDefines if the employee's detailed information should be printed on the report. Optional
Trial Print OnlyDefines if the report should be generated for verification purposes only. In non-trial mode, RPGRC updates the GVT Headers, Govt File State, of the run. Optional
Create FileDefines if interface files should be generated. One file is for the dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages. Set this field to NO during testing. Optional
User CommentEnter text to print on the header of the report. Optional

RPGRC Report Filters#

FieldDescription
GVT Run NumberDefines a specific Gvt Run Number to report on. Optional
EntityDefines a specific Entity to report on. Optional
Federal Regist SetDefines a specific Federal Registration Set to report on.
Federal Regist NumberDefines a specific Federal Registration Number to report on. Optional
People ListDefines a specific list of employees to report on. Optional
PersonDefines the Person Code of an employee you are testing with. Optional
Select ProvinceDefines a specific Province to report on. Optional
Province Regist SetDefines a specific Province Registration Set to report on. Optional
Prov Regist NumberDefines a specific Province Registration Number to report on. Optional

Notes #

Click to create a new notes page