This page (revision-15) was last changed on 19-Oct-2022 20:33 by Karen Parrott

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

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 19-Oct-2022 20:33 32 KB Karen Parrott to previous
14 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
13 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
12 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
11 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
10 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
9 26-Nov-2021 10:22 32 KB Meg McFarland to previous | to last
8 26-Nov-2021 10:22 32 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 34 KB mmcfarland to previous | to last
6 26-Nov-2021 10:22 34 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 34 KB mmcfarland to previous | to last
4 26-Nov-2021 10:22 38 KB mmcfarland to previous | to last
3 26-Nov-2021 10:22 38 KB mmcfarland to previous | to last
2 26-Nov-2021 10:22 38 KB mmcfarland to previous | to last
1 26-Nov-2021 10:22 347 bytes mmcfarland to last

Page References

Incoming links Outgoing links
CDN_RELEVE 2_PROCESS...nobody
CDN_RELEVE2_PROCESS

Version management

Difference between version and

At line 3 added 2 lines
[{TableOfContents }]
At line 9 changed one line
For 2017-2018 reporting, the IDFD HL$CAN-R2-2017 Form Code is used. \\ \\
For the Current Year reporting, the IDFD HL$CAN-R2-YYYY Form Code is used. \\ \\
At line 54 added one line
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 56 added one line
At line 59 added one line
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 68 changed one line
|R2-BOX-G-PRT-0|QPP Earnings Printed ZERO|Not specified|Do not set up this identifier, High Line internal use only. If the value of this box is 1.00, then Box G will be printed with 0.00.
|R2-BOX-G-PRT-0|QPP Earnings Printed ZERO|Not specified|Do not set up this identifier, High Line internal use only. \\If the value of this box is 1.00, then Box G will be printed with 0.00.
At line 167 changed 2 lines
!!!RPRL2/RPRL2W Selection Criteria
[{InsertPage page='RPRL2}]
!!!RPRL2W Selection Criteria
At line 171 changed 2 lines
!!!RPRL2/RPRL2W Slip Print Processing
The RPRL2/RPRL2W Form Print program format is based on the Government published RL-2.L (2016-10) Form. \\ \\
!!!RPRL2W Slip Print Processing
The RPRL2W Form Print program format is based on the current Government published RL-2.L Form. The IN-412-V RL Requirements for Computer-Generated Forms document is included in the year end software. \\
At line 174 changed one line
High Line supports the latest version of the government published form at the time of programming and informs users of the form version being used. High Line recommends using the same form version as the RPRL2/RPRL2W program. \\ \\
The RPRL2W Form Print program prints all information generated based on the GVT Run number. \\
At line 176 changed one line
The RPRL2 Form Print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria. \\ \\
If an employee has many footnote codes to be reported, each subsequent RL-2 Slip is printed with footnote codes until all footnotes codes are printed. \\
At line 178 changed one line
The RPRL2W Form Print program prints all information generated based on the GVT Run number. \\ \\
The RPRL2W program generates Summary Totals by each Business Number. At the end of the RPRL2W run, a grand total is generated for all Business Numbers. \\
At line 180 changed one line
If an employee has many footnote codes to be reported, each subsequent RL-2 Slip is printed with footnote codes until all footnotes codes are printed. \\ \\
Users must run RMEX with the RPRL2W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\
At line 182 changed one line
The RPRL2/RPRL2W program generates Summary Totals by each Business Number. At the end of the RPRL2/RPRL2W run, a grand total is generated for all Business Numbers. \\ \\
The RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\
At line 184 changed one line
Users must run RMEX with the RPRL2/RPRL2W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\ \\
Users should confirm that the RPRL2W Boxes balance to the RPGRC Summary Report. \\
At line 186 changed one line
The RPRL2/RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\ \\
If the RPRL2W process cannot select any information from the xml file to print, users must run RMEX with the RPRL2/RPRL2W Mex ID to review any error or exception messages to identify the problem. \\
At line 188 removed 4 lines
Users should confirm that the RPRL2/RPRL2W Boxes balance to the RPGRC Summary Report. \\ \\
If the RPRL2/RPRL2W process cannot select any information from the xml file to print, users must run RMEX with the RPRL2/RPRL2W Mex ID to review any error or exception messages to identify the problem. Typically, the problem is because of an invalid Directory or File name. \\ \\
At line 193 changed one line
Users are required to print the Employer and Employee Copy of the RL-2. Users must run RPRL2/RPRL2W twice; once to print the Employer Copy and once to print the Employee Copy. \\ \\
Users are required to print the Employer and Employee Copy of the RL-2. Users must run RPRL2W twice; once to print the Employer Copy and once to print the Employee Copy. \\
At line 195 changed one line
When RPRL2/RPRL2W is run, the Print RL-2 Copy field defines if the Employer or Employee Copy is printed. \\ \\
When RPRL2W is run, the Print RL-2 Copy field defines if the Employer or Employee Copy is printed.
At line 198 changed 2 lines
* On one sheet, the RL-2 information is printed for 3 different employees
* The Employer Copy can be sent to the government or to be kept by your organization \\ \\
* On one sheet, the RL-2 information is printed
* The Employer Copy can be sent to the government or to be kept by your organization
At line 201 changed 3 lines
[Employee Copy|]\\
* On one sheet, 3 RL-2 copies are printed for one employee
* The Employee Copy should be distributed to the Employees \\ \\
[Employee Copy|]
* On one sheet, 1 RL-2 copy is printed for one employee
* The Employee Copy should be distributed to the Employees \\
At line 214 changed one line
When users are running RPRL2 with the new _HL.xml file (RPRL2W with the new GVT Run number), RPRL2/RPRL2W will automatically print the DUPLICATE COPY or AMENDED on the RL-2 Slip depending on the GVT Run option of the RPRL2 run. \\
When users are running RPRL2W with the new GVT Run number, RPRL2W will automatically print the DUPLICATE COPY or AMENDED on the RL-2 Slip depending on the GVT Run option of the RPRL2W run. \\
At line 216 changed one line
When RPRL2/RPRL2W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\ \\
When RPRL2W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\
At line 218 changed 3 lines
2. Run RPRL2/RPRL2W with the 'Gvt Form Option' set to 'Duplicate Forms' and the 'Trial Print Only' set to 'Yes'
*RPGRC retrieves all GVT Headers with the Print Stage defined as 'Duplicate Requested' and generates the HL xml file for the RPRL2/RPRL2W Form Print program.
*There is no need to generate a government xml file for duplicate forms. Users do not need to enter the Govt Interface Format definition for RPGRC.\\ \\
2. Run RPRL2W with the 'Gvt Form Option' set to 'Duplicate Forms' and the 'Trial Print Only' set to 'Yes'
*RPGRC retrieves all GVT Headers with the Print Stage defined as 'Duplicate Requested'.
*There is no need to generate a government xml file for duplicate forms. Users do not need to enter the Govt Interface Format definition for RPGRC.\\
At line 222 changed 2 lines
3. Run RPRL2/RPRL2W to print the duplicate forms
*Run the Form Print RPRL2/RPRL2W program to read the HL xml file from RPGRC to print the duplicate forms
3. Run RPRL2W to print the duplicate forms
*Run the Form Print RPRL2W program to print the duplicate forms
At line 225 changed one line
*Users can re-run the Form Print program for the Employee Copy or the Employer Copy from the same HL xml file. The GVT Header stage will be updated to 'Duplicate Printed' depending on the 'Trial Print Only' field setting. \\ \\
*Users can re-run the Form Print program for the Employee Copy or the Employer Copy. The GVT Header stage will be updated to 'Duplicate Printed' depending on the 'Trial Print Only' field setting. \\
At line 228 changed one line
If a user discovers erroneous box information on the RL-2 slip and needs to revise the Box information, users may need to either correct the employee amounts or modify the IDFDV set up, then re-run the RPGRC and RPRL2/RPRL2W processes. This produces the Amended RL-2 slip. \\
If a user discovers erroneous box information on the RL-2 slip and needs to revise the Box information, users may need to either correct the employee amounts or modify the IDFDV set up, then re-run the RPGRC and RPRL2W processes. This produces the Amended RL-2 slip. \\
At line 242 changed 2 lines
*__Do not__ set the Trial Print Only toggle to ON, for the RPYEC process
*Users can set the Retain Amend/Reject Form to ON, to retain the original copy prior to generating the amendment.
*__Do not__ set the Trial Print Only toggle to YES, for the RPYEC process
*Users can set the Retain Amend/Reject Form to YES, to retain the original copy prior to generating the amendment.
At line 249 changed one line
*Do not set the Trial Print Only toggle to ON, for the RPGRC process
*Do not set the Trial Print Only toggle to YES, for the RPGRC process
At line 256 changed 4 lines
6. Run RPRL2/RPRL2W to print the Amended forms. \\
*When the user is running RPRL2 with the new _HL.xml file, (RPRL2W with the new GVT Run number) RPRL2/RPRL2W will automatically print the word DUPLICATE COPY or AMENDED on the RL-2 form, depending on the GVT Run option of the RPGRC run.
*If other wording is required to print on the RL-2 slip, in the Duplicate/Amended parameter, users can enter the text for RPRL2, such as CANCEL COPY or ORIGINAL COPY.
*At the end of the RPRL2/RPRL2W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage. \\ \\
6. Run RPRL2W to print the Amended forms. \\
*When the user is running RPRL2W with the new GVT Run number) RPRL2/RPRL2W will automatically print the word DUPLICATE COPY or AMENDED on the RL-2 form, depending on the GVT Run option of the RPGRC run.
*If other wording is required to print on the RL-2 slip, in the Duplicate/Amended parameter, users can enter the text for RPRL2W, such as CANCEL COPY or ORIGINAL COPY.
*At the end of the RPRL2W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage. \\ \\
At line 261 removed 9 lines
__RPRL2/RPRL2W Void Forms__\\
*After the RL-2 slip are printed, the RPRL2/RPRL2W process will generate an intermediate Summary Total on the RMEX report
*Users will bundle the Summary Total with the current year RL-2 slip to send to the government
*If an employee requires more than one RL-2 slip, and this employee’s RL-2 information is split between 2 summaries, then this employee’s RL-2 information will be printed on the first Summary Total. Consequently, there may be more RL-2 slips on the Summary.
*When the last RL-2 slip is printed for the first Summary, if the last RL-2 information prints on the TOP RL-2 slip, the BOTTOM RL-2 slip will be VOIDED so users can separate the RL-2 slips by Summary.
*When RPRL2/RPRL2W is run, if there is more than one Government Registration Number from IDGR:
**The RL-2 forms will be sorted by Government Registration Numbers
**RPRL2/RPRL2W will generate totals for each Government Registration Number on the RMEX report.
*When the last RL-2 form is printed for the first Government Registration Number, if the last RL-2 information prints on the TOP RL-2 slip, the BOTTOM RL-2 slip will be VOIDED so users can separate the RL-2 slips by Government Registration Number.
At line 271 removed one line
At line 286 changed one line
* Users MUST run the RMEX report for the Mex ID from the RPRL2/RPRL2W run to print the RL-2 Grand Totals to verify all records are printed. \\ \\
* Users MUST run the RMEX report for the Mex ID from the RPRL2W run to print the RL-2 Grand Totals to verify all records are printed. \\ \\
At line 288 changed one line
!! RL-2 Slip Print Distribution
! RL-2 Slip Print Distribution
At line 306 changed one line
__Numbering of RL-2 Slips__\\
!Numbering of RL-2 Slips
At line 330 changed one line
On the IDFDV form, R2-FORM-NUM-BEG Field Identifier, users must enter the 8 digit beginning number assigned by Ministere du Revenu du Quebec. \\ \\
On the IDFDV form, R2-FORM-NUM-BEG Field Identifier, users must enter the 8 digit beginning number assigned by Ministere du Revenu du Quebec. \\
At line 332 changed one line
After RPYEC is run, RPYEC displays the last RL-2 Slip number assigned as an exception message on the RPYEC report. \\ \\
After RPYEC is run, RPYEC displays the last RL-2 Slip number assigned as an exception message on the RPYEC report. \\
At line 336 changed one line
Once all of the information is verified with the RPYEC report, users should run RPGRC to generate the xml files for RPRL2/RPRL2W to print the RL-2 Forms. \\ \\
Once all of the information is verified with the RPYEC report, users should run RPGRC to generate the xml files for RPRL2/RPRL2W to print the RL-2 Forms. \\
At line 338 changed one line
IMPORTANT: After the RPRL2/RPRL2W program is run, users must __manually go into the IDFDV form and update the R2-FORM-NUM-BEG with the last Form Number assigned + 1__ for the next RPYEC RL-2 run. \\ \\
%%IMPORTANTNOTE: After the RPRL2W program is run, users must __manually go into the IDFDV form and update the R2-FORM-NUM-BEG with the last Form Number assigned + 1__ for the next RPYEC RL-2 run. \\ \\
At line 344 changed 3 lines
The IPGH Form Number is used by RPGRC to generate:
*The government RL-2 xml file to send to the Quebec government, and
*The _HL.xml file for RPRL2 to print the exact same number on RL-2 form
The IPGH Form Number is used by RPGRC to generate the government RL-2 xml file to send to the Quebec government,
At line 352 changed one line
Please enter the 8 digit number assigned to you by Ministere du Revenu, such as 71997012. \\ \\
Please enter the 8 digit number assigned to you by Ministere du Revenu, such as 71997012. \\
At line 362 removed one line
At line 364 changed one line
Users can set up the following Identifiers to print user defined footnote codes and messages:
Users can set up the following Identifiers to print user defined footnote codes and messages: \\
At line 382 changed one line
*Define the Field Variable. If the Field Variable value is greater than 0, then the description and the amount will be printed in the center of the RL-2 Slip.\\ \\
*Define the Field Variable. If the Field Variable value is greater than 0, then the description and the amount will be printed in the center of the RL-2 Slip.\\
At line 385 changed one line
Example: R2-ALPHA-02 defines the STAT EE Statistic Component. When STAT EE = 1.00, then print Employee Non-Contrib. Use decode(~,'1',' ',NULL) in the derivation expression. \\ \\
Example: R2-ALPHA-02 defines the STAT EE Statistic Component. When STAT EE = 1.00, then print Employee Non-Contrib. Use decode(~,'1',' ',NULL) in the derivation expression. \\
At line 387 changed 2 lines
__Printing RPRL2/RPRL2W__\\
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the "Run Options" tab. \\ \\
!!RL-2 Slip - Retirement and Annuity Income
!RL-2 Slip - 2019 Format
Users should read the following Form Descriptions and refer to 2019 Guide to Filing the RL-2 Slip RL-2.G-V prior to setting up IDFDV form.\\
The Ministere du Revenu du Quebec web site is: http://www.revenu.gouv.qc.ca \\ \\
At line 390 removed 9 lines
Users should run all Government Form Print programs, such as RPRL1/RPRL1W and RPRL2/RPRL2W with this setting. \\ \\
All Form Print programs are aligned with the government forms in a PDF format. Users can adjust the parameters for the Top Margin and the Between Form Space when generating the PDF file. Once the PDF file is generated, users will not need to adjust the Page Set up when printing. \\ \\
!!!RL-2 Slip - Retirement and Annuity Income
!RL-2 Slip - 2017 Format
Users should read the following Form Descriptions and refer to 2017 Guide to Filing the RL-2 Slip RL-2.G-V (2016-10) prior to setting up IDFDV form.\\ \\
At line 400 changed 2 lines
__Box__: Number on RL-2 slip (Top right corner), derived from the IDFDV form, as below. Please refer to the section Numbering of RL-2 Slip for full details. \\
__Field Identifier__: R2-FORM-NUM-BEG\\ \\
|Box|Number on RL-2 slip (Top right corner)|Derived from the IDFDV form, as below. Please refer to the section Numbering of RL-2 Slip for full details.
|Field Identifier|R2-FORM-NUM-BEG
|Box|Year|Pre-printed on RL-2 Slip or from the user defined Calendar Year
|Box|Code du releve|System derived. \\If printing an Amended Form define as 1, otherwise define as 0 for Original or Duplicate Forms.
|Box|Provenance des revenus|Derived from the IDFDV form, as below
At line 403 removed 5 lines
__Box: Year__ - Pre-printed on RL-2 Slip or from the user defined Calendar Year \\ \\
__Box: Code du releve.__ System derived. If printing an Amended Form define as 1, otherwise define as 0 for Original or Duplicate Forms.\\ \\
__Box: Provenance des revenus.__ derived from the IDFDV form, as below\\
At line 410 changed one line
\\ \\
At line 428 changed one line
*If the Country Code is not Canada or USA, then the R2-ER-MAG-PROV Identifier should be set to ZZ – Other. \\ \\
*If the Country Code is not Canada or USA, then the R2-ER-MAG-PROV Identifier should be set to ZZ – Other. \\
At line 435 changed one line
*If a SIN number does not exist, leave this field blank \\ \\
*If a SIN number does not exist, leave this field blank \\
\\
__Box: Reference Number (Numero de reference employeur)__. Contains the employee’s Person Code, (PERSON-CODE Identifier) as an additional employee identifier.\\
At line 437 removed 2 lines
__Box: Reference Number (Numero de reference employeur)__. Contains the employee’s Person Code, (PERSON-CODE Identifier) as an additional employee identifier.\\ \\
At line 444 changed one line
\\ \\
\\
At line 446 removed one line
At line 461 changed one line
*If the Country Code is not Canada or USA, then the R2-EE-MAG-PROV Identifier should be set to ZZ – Other.\\ \\
*If the Country Code is not Canada or USA, then the R2-EE-MAG-PROV Identifier should be set to ZZ – Other.\\
At line 463 changed one line
All of the following Box Information is derived from the IDFDV form, as below
%%informationNOTE: All of the following Box Information is derived from the IDFDV form, as below%%
At line 482 changed one line
\\ \\
At line 470 added 2 lines
!XML Layout
At line 497 changed 3 lines
%%important The government requires users to validate the government XML file according to the downloaded government xml schema using a validation parser prior to sending the file to the government.%%
__Validating the Govt XML File__\\
%%importantNOTE: The government requires users to validate the government XML file according to the downloaded government xml schema using a validation parser prior to sending the file to the government.%%
\\
!Validating the Govt XML File
At line 508 changed one line
----
![Notes|Edit:Internal.CDN RELEVE 2 PROCESS]
[{InsertPage page='Internal.CDN RELEVE 2 PROCESS' default='Click to create a new notes page'}]
This page (revision-15) was last changed on 19-Oct-2022 20:33 by Karen ParrottTop