This page (revision-15) was last changed on 31-Aug-2022 17:21 by Karen Parrott

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 31-Aug-2022 17:21 4 KB Karen Parrott 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 3 lines
The RPGRC form allows you to print out a listing Canadian government reporting.
----
!!Report Parameters & Filters
This is the Government Payroll Reporting for Canada. This process reads the Government Reporting table information generated by [RPYEC].
At line 8 changed 17 lines
||Report Parameters||
|Form Code|Mandatory, LOV available\\This field allows you to chose the form for the report.
|Govt Interface Format|Mandatory, LOV available
|Period Type|Mandatory, [Period Type|X_IDFD_PERIOD_TYPE] Lexicon available
|Period End Date|Mandatory,Date, LOV Available
|As of Date|Mandatory,Date, LOV Available
|Govt Form Option|Mandatory, [Govt Form Option|X_GVT_FORM_OPTION] Lexicon available
|Sort Level By|Mandatory, [Sort Level By|X_T4_SORT_LEVEL] Lexicon available
|Sort People By|Mandatory, [Sort People By|X_PERSON_SORT] Lexicon available
|Sort by Active/Inactive|Optional, [Sort By|X_W2_SORT_ACTIVE] Lexicon available
|Directory Name|Optional, Text
|File Name|Optional, Text
|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
|Trial Print Only|Optional, Lexicon available
|Create File|Optional, Lexicon available
|User Comment|Optional, Text
A Summary Total Report, by government registration, or by employee detail, for a selected Form Code as defined on [IDFDV], is produced.
At line 26 changed 10 lines
||Report List Filters||
|GVT Run Number|Optional, Multiple selections, LOV available
|Entity|Optional, Multiple selections, LOV available
|Federal Regist Set|Optional, Multiple selections, LOV available
|Federal Regist Number|Optional, Multiple selections, LOV available
|People List|Optional, Multiple selections, LOV available
|Person|Optional, Multiple selections, LOV available
|Select Province|Optional, Multiple selections, LOV available
|Province Regist Set|Optional, Multiple selections, LOV available
|Prov Regist Number|Optional, Multiple selections, LOV available
Each RPGRC run generates one GVT Run (Government Run Number) and all employees processed by a RPGRC run belong to this GVT Run Number.
At line 37 changed one line
[{If var='loginstatus' contains 'authenticated'
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.
At line 12 added 12 lines
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.
\\
\\
At line 40 changed 2 lines
![Discussion|Edit:Internal.RPGRC]
[{InsertPage page='Internal.RPGRC' default='Click to create a new discussion page'}]
!!RPGRC Report Parameters
At line 43 changed one line
}]
||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.
At line 45 changed one line
[CLEANUP]
|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.
!!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
This page (revision-15) was last changed on 31-Aug-2022 17:21 by Karen ParrottTop