This page (revision-15) was last changed on 25-Feb-2022 14:29 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 25-Feb-2022 14:29 4 KB Lilia Urtan to previous
14 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
13 26-Nov-2021 10:22 4 KB mmcfarland to previous | to last
12 26-Nov-2021 10:22 4 KB kparrott to previous | to last
11 26-Nov-2021 10:22 3 KB jmyers to previous | to last
10 26-Nov-2021 10:22 2 KB JMyers to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 46 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links
RPGRC
RPGRC

Version management

Difference between version and

At line 4 changed one line
This is the Government Payroll Reporting for Canada. This process reads the Government Reporting table information generated by [RPYEC].
This is the Report Payroll Government Reporting for Canada. This process reads the Government Reporting table information generated by [RPYEC].
At line 6 changed one line
A Summary Total Report, by government registration, or by employee detail, for a selected Form Code as defined on [IDFDV], is produced.
A Summary Total Report by government registration or by detail employee for a selected Form Code as defined on [IDFDV] is produced.
At line 10 changed one line
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.
After RPGRC is run, user can go into [IPGR] Government Run screen for online inquiry by GVT Run number. From the [IPGR] screen, the user can pop into employee’s detail government reporting information on [IPGH] (Government Header) inquiry screen. The user can also go directly to [IPGH] inquiry screen by employee.
At line 12 changed one line
User can generate many RPGRC runs for different sets of employees. This generates multiple GVT Run numbers.
The user may run one or many RPGRC runs for different sets of employees and will this generate multiple GVT Run numbers.
At line 14 changed 3 lines
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.
The RPGRC generates the government Magnetic Media file to be submitted to the government.
At line 18 changed one line
At the end of each run, RPGRC removes any GVT Run Number that does not have any GVT Headers associated to it.
The RPGRC generates the XML files to feed into the Oracle form print programs - RPT4, RPT4A, RPRL1 etc to print T4, T4A or Releve Forms by employees.
At line 20 changed one line
Once the government xml file is generated, it is ready for an xml parser validation prior to sending the file to the government.
At the end of each run, RPGRC removes any GVT Run Number that does not have GVT Header associates with it.
At line 25 changed one line
!!RPGRC Report Parameters
!!Report Parameters & Filters
At line 27 changed 10 lines
||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.
||Report Parameters||
|Form Code|Mandatory, LOV available\\This field allows you to choose the form for the report.
|Govt Interface Format|Mandatory, LOV available\\This field allows you to choose the government interface form for the report.
|Period Type|Mandatory, [Period Type|X_IDFD_PERIOD_TYPE] Lexicon available\\This field allows you to choose the period type for the report.
|Period End Date|Mandatory,Date, LOV Available\\This field allows you to choose the period end date for the report.
|As of Date|Mandatory,Date, LOV Available\\This field allows you to choose the as of date for the report.
|Govt Form Option|Mandatory, [Govt Form Option|X_GVT_FORM_OPTION] Lexicon available\\This field allows you to choose the government form option for the report.
|Sort Level By|Mandatory, [Sort Level By|X_T4_SORT_LEVEL] Lexicon available\\This field lets you sort the report by level.
|Sort People By|Mandatory, [Sort People By|X_PERSON_SORT] Lexicon available\\This field will indicate how the people information will be sorted.
|Sort by Active/Inactive|Optional, [Sort By|X_W2_SORT_ACTIVE] Lexicon available\\This field lets you sort the report by active/inactive.
|Directory Name|Optional,Text\\This field allows you to provide a directory name.
|File Name|Optional,Text\\This field allows you to provide a file name.
|Trace Level|Optional, [Trace Level|X_TRACE_LEVEL], Lexicon available. This field defines the exception level (report messages) required.
|Print Employee Detail|Optional, Lexicon available\\If <Yes> then the employee details will be displayed on the report, otherwise no details will display on the report.
|Trial Print Only|Optional, Lexicon available\\You may choose to run the report in a trial mode to see results
|Create File|Optional,[Yes or No|X_YES_NO],Lexicon available\\If NO, the report will be run without creating an interface file (normally for testing purposes).
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
At line 38 changed 8 lines
|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
|Print Exceptions| Defines if exception messages should be printed on the report. This parameter is defaulted to 'N'. Otional
|User Comment|Enter text to print on the header of the report. 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.
||Report List Filters||
|GVT Run Number|Optional, Multiple selections, LOV available\\This field limits the report to the specified run numbers.
|Entity|Optional, Multiple selections, LOV available\\This field limits the report to the specified entities.
|Federal Regist Set|Optional, Multiple selections, LOV available\\This field limits the report to the specified federal registration sets.
|Federal Regist Number|Optional, Multiple selections, LOV available\\This field limits the report to the specified federal registration numbers.
|People List|Optional, Multiple selections, LOV available\\This field limits the report to the specified people lists.
|Person|Optional, Multiple selections, LOV available\\This field limits the report to the specified persons.
|Select Province|Optional, Multiple selections, LOV available\\This field limits the report to the specified provinces.
|Province Regist Set|Optional, Multiple selections, LOV available\\This field limits the report to the specified province registration sets.
|Prov Regist Number|Optional, Multiple selections, LOV available\\This field limits the report to the specified province registration numbers.
At line 47 changed 11 lines
!!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
----
![Notes|Edit:Internal.RPGRC]
[{InsertPage page='Internal.RPGRC' default='Click to create a new notes page'}]
At line 60 removed 2 lines
This page (revision-15) was last changed on 25-Feb-2022 14:29 by Lilia UrtanTop