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#
| Field | Description |
|---|---|
| Form Code | Mandatory. Enter the current year Form Code, defined on IDFDV |
| Govt Interface Format | Mandatory. Defined the IDIFform Interface Format Code to be used to generate the Magnetic Media file to send to the government. |
| Period Type | Mandatory. Defines the period type for the report, such as Year, Quarter |
| Period End Date | Mandatory. Defines the end date of the reporting period |
| As of Date | Mandatory. Defines the start date of the reporting period |
| Govt Form Option | Mandatory. 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 By | Mandatory. Defines at what level the employees should be sorted. The options are: * Not Specified * Department * Department T4 * Pay Destination * Location * T4 Destination |
| Sort People By | Mandatory. Defines how the employees should be sorted. The options are: *Person Code *Last Name, First Name *Destin, Last, First |
| Sort by Active/Inactive | Defines if the employees should be sorted by the active/inactive status. Optional. |
| Directory Name | Defines 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 Name | Defines the name of the file that will be created, such as RPGRC-2017-mex.txt. Optional |
| Trace Level | the 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 Detail | Defines if the employee's detailed information should be printed on the report. Optional |
| Trial Print Only | Defines 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 File | Defines 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 Comment | Enter text to print on the header of the report. Optional |
RPGRC Report Filters#
| Field | Description |
|---|---|
| GVT Run Number | Defines a specific Gvt Run Number to report on. Optional |
| Entity | Defines a specific Entity to report on. Optional |
| Federal Regist Set | Defines a specific Federal Registration Set to report on. |
| Federal Regist Number | Defines a specific Federal Registration Number to report on. Optional |
| People List | Defines a specific list of employees to report on. Optional |
| Person | Defines the Person Code of an employee you are testing with. Optional |
| Select Province | Defines a specific Province to report on. Optional |
| Province Regist Set | Defines a specific Province Registration Set to report on. Optional |
| Prov Regist Number | Defines a specific Province Registration Number to report on. Optional |
