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 removed 2 lines
[{TableOfContents }]
At line 11 changed one line
For the Current Year reporting, the IDFD HL$CAN-R2-YYYY Form Code is used. \\ \\
For 2017-2018 reporting, the IDFD HL$CAN-R2-2017 Form Code is used. \\ \\
At line 54 removed one line
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 56 removed one line
At line 59 removed one line
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 73 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 172 changed 2 lines
!!!RPRL2W Selection Criteria
!!!RPRL2/RPRL2W Selection Criteria
[{InsertPage page='RPRL2}]
At line 176 changed 2 lines
!!!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. \\
!!!RPRL2/RPRL2W Slip Print Processing
The RPRL2/RPRL2W Form Print program format is based on the Government published RL-2.L (2016-10) Form. \\ \\
At line 179 changed one line
The RPRL2W Form Print program prints all information generated based on the GVT Run number. \\
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. \\ \\
At line 181 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. \\
The RPRL2 Form Print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria. \\ \\
At line 183 changed one line
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. \\
The RPRL2W Form Print program prints all information generated based on the GVT Run number. \\ \\
At line 185 changed one line
Users must run RMEX with the RPRL2W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\
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 187 changed one line
The RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\
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. \\ \\
At line 189 changed one line
Users should confirm that the RPRL2W Boxes balance to the RPGRC Summary Report. \\
Users must run RMEX with the RPRL2/RPRL2W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\ \\
At line 191 changed one line
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. \\
The RPRL2/RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\ \\
At line 188 added 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 194 changed one line
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. \\
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. \\ \\
At line 196 changed one line
When RPRL2W is run, the Print RL-2 Copy field defines if the Employer or Employee Copy is printed.
When RPRL2/RPRL2W is run, the Print RL-2 Copy field defines if the Employer or Employee Copy is printed. \\ \\
At line 199 changed 2 lines
* 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
* 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 \\ \\
At line 202 changed 3 lines
[Employee Copy|]
* On one sheet, 1 RL-2 copy is printed for one employee
* The Employee Copy should be distributed to the Employees \\
[Employee Copy|]\\
* On one sheet, 3 RL-2 copies are printed for one employee
* The Employee Copy should be distributed to the Employees \\ \\
At line 215 changed one line
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. \\
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. \\
At line 217 changed one line
When RPRL2W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\
When RPRL2/RPRL2W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\ \\
At line 219 changed 3 lines
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.\\
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.\\ \\
At line 223 changed 2 lines
3. Run RPRL2W to print the duplicate forms
*Run the Form Print RPRL2W program to print the duplicate forms
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
At line 226 changed one line
*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. \\
*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. \\ \\
At line 229 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 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 RPRL2/RPRL2W processes. This produces the Amended RL-2 slip. \\
At line 243 changed 2 lines
*__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.
*__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.
At line 250 changed one line
*Do not set the Trial Print Only toggle to YES, for the RPGRC process
*Do not set the Trial Print Only toggle to ON, for the RPGRC process
At line 257 changed 4 lines
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. \\ \\
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. \\ \\
At line 261 added 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 added one line
At line 277 changed one line
* 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. \\ \\
* 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. \\ \\
At line 279 changed one line
! RL-2 Slip Print Distribution
!! RL-2 Slip Print Distribution
At line 297 changed one line
!Numbering of RL-2 Slips
__Numbering of RL-2 Slips__\\
At line 321 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 323 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 327 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 RPRL1 to print the RL-2 Forms. \\ \\
At line 329 changed one line
%%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. \\ \\
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. \\ \\
At line 335 changed one line
The IPGH Form Number is used by RPGRC to generate the government RL-2 xml file to send to the Quebec government,
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 RPRL1 to print the exact same number on RL-2 form
At line 341 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 345 changed one line
After each RPYEC run, this identifier is updated to store the last number assigned according to the R2-FORM-NUM-BEG Identifier. After RPRL2/RPRL2W is run to print the actual RL-2 Slip, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so that the next RPYEC run can begin with the correct new number. \\ \\
After each RPYEC run, this identifier is updated to store the last number assigned according to the R2-FORM-NUM-BEG Identifier. After RPRL1 is run to print the actual RL-2 Slip, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so that the next RPYEC run can begin with the correct new number. \\ \\
At line 362 added one line
At line 352 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 370 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 373 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 375 changed 4 lines
!!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 \\ \\
__Printing RPRL2/RPRL2W__\\
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the "Run Options" tab. \\ \\
At line 390 added 9 lines
Users should run all Government Form Print programs, such as RPRL1 and RPRL2 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 381 changed 5 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|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
__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\\ \\
At line 403 added 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 389 changed one line
\\ \\
At line 407 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 414 changed 3 lines
*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.\\
*If a SIN number does not exist, leave this field blank \\ \\
At line 437 added 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 423 changed one line
\\
\\ \\
At line 446 added one line
At line 439 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 441 changed one line
%%informationNOTE: All of the following Box Information is derived from the IDFDV form, as below%%
All of the following Box Information is derived from the IDFDV form, as below
At line 460 changed one line
\\ \\
At line 470 removed 2 lines
!XML Layout
At line 477 changed 3 lines
%%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
%%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__\\
At line 488 changed 3 lines
----
![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