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 15 changed one line
%%important Users must run the RPYEU process with the current year Form Code, or a copy of this Form Code that has the "Store Option" set up to store the Names, Addresses and the Amounts in the Government Remittance Tables.%%
%%important Users must run the RPYEC process with the current year Form Code, or a copy of this Form Code that has the "Store Option" set up to store the Names, Addresses and the Amounts in the Government Remittance Tables.%%
At line 53 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 users run the RPRL1 program to print the actual RL-2 Slips, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so 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 users run the RPRL2/RPRL2W program to print the actual RL-2 Slips, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so the next RPYEC run can begin with the correct new number.\\ \\
At line 167 changed one line
!!!RPRL2 Selection Criteria
!!!RPRL2/RPRL2W Selection Criteria
At line 169 added one line
[{InsertPage page='RPRL2W}]
At line 170 changed 2 lines
!!!RPRL2 Slip Print Processing
The RPRL2 program Print Format is based on the Government published RL-2.L (2016-10) Form. If you are using other versions of this form, such as the 2004-10 version, please test the RPRL2 program form layout prior to printing. \\ \\
!!!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 173 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 program. \\ \\
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 175 changed one line
If, however, an organization user receives a different version of the form from the government, and the RPRL2 program does not align properly with the form, users should re-order the Form from the government that is the same as RPRL2 program. \\ \\
The RPRL2 Form Print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria. \\ \\
At line 177 changed one line
The RPRL2 form print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria. \\ \\
The RPRL2W Form Print program prints all information generated based on the GVT Run number. \\ \\
At line 179 changed one line
If an employee has many Footnotes to be reported, each subsequent RL-2 Slip is printed with Footnote Codes until all Footnotes Codes are printed. \\ \\
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 181 changed one line
The RPRL2 program generates Summary Totals by each Business Number. At the end of the RPRL1 run, a grand total is generated for all Business Numbers. \\ \\
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 183 changed one line
Users must run RMEX with the RPRL2 Mex ID to obtain the Summary and Grand totals to 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 185 changed one line
The RPRL2 Summary and Grand Totals are accumulated for the Boxes shown on the Slip, the Footnote Codes are not totaled. \\ \\
The RPRL2/RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\ \\
At line 187 changed one line
Users should confirm that the RPRL2 Boxes balance to the RPGRC Summary Report. \\ \\
Users should confirm that the RPRL2/RPRL2W Boxes balance to the RPGRC Summary Report. \\ \\
At line 189 changed one line
If the RPRL2 process cannot select any information from the xml file to print, users must run RMEX with the RPRL2 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. \\ \\
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 192 changed one line
Users are required to print the Employer and Employee Copy of the RL-2. Users must run RPRL2 twice; once to print the Employer Copy and again 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 194 changed one line
When RPRL2 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 209 changed one line
*Change the Print Stage to: 11 – Duplicate requested
*Change the Print Stage to 'Duplicate Requested'
At line 213 changed one line
When users are running RPRL1 with the new _HL.xml file, RPRL1 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 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 215 changed one line
When RPRL2 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 217 changed 3 lines
2. Run RPRL2 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 11– Duplicate requested and generates the HL xml file for the Form Print RPRL2 program.
*There is no need to generate a govt 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 221 changed 4 lines
3. Run RPRL2 to print the duplicate forms
*Run the Form Print RPRL1 program to read the HL xml file from RPGRC to print the duplicate forms
*At the end of the Form Print, if the Trial Print Only field is set to No, the GVT Header stage will be updated to 12 – Duplicate Printed
*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 12 – Duplicate Printed depending on the Trial Print Only field setting. \\ \\
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 the end of the Form Print, if the 'Trial Print Only' field is set to No, the GVT Header stage will be updated to 'Duplicate Printed'
*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 227 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 RPRL1 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 233 added one line
At line 235 added one line
At line 234 changed one line
*Change the Print Stage to Amendment Requested
*Change the 'Print Stage' to 'Amendment Requested'
At line 237 changed 2 lines
4. Run RPYEC with the GVT Form Option set to Amended Forms \\
*Do not set the Trial Print Only toggle to ON, for the RPYEC process
4. Run RPYEC with the GVT Form Option set to 'Amended Forms' \\
*__Do not__ set the Trial Print Only toggle to ON, for the RPYEC process
At line 240 changed one line
*The RPYEC process will retrieve all GVT Headers with the Print Stage set to Amendment Requested and re-derives the YTD according to the IDFDV setup to generate the GVT Header with:
*The RPYEC process will retrieve all GVT Headers with the Print Stage set to 'Amendment Requested' and re-derives the YTD according to the IDFDV setup to generate the GVT Header with:
At line 243 changed one line
5. Run RPGRC with the GVT Form Option set to Amended Forms \\
5. Run RPGRC with the 'GVT Form Option' set to 'Amended Forms' \\
At line 245 changed one line
*The RPGRC process will retrieve all GVT Headers with the Print Stage set to Amend, File not Created and generates the HL xml file for the RPT4 print program.
*The RPGRC process will retrieve all GVT Headers with the Print Stage set to 'Amend, File not Created' and generates the HL xml file for the RPRL2/RPRL2W print program.
At line 250 changed 2 lines
6. Run RPRL2 to print the Amended forms. \\
*When the user is running RPRL2 with the new _HL.xml file, RPRL2 will automatically print the word DUPLICATE COPY or AMENDED on the T4 form, depending on the GVT Run option of the RPGRC run.
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.
At line 253 changed one line
*At the end of the RPRL2 run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage. \\ \\
*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 255 changed 2 lines
__RPRL2 Void Forms__\\
*After the RL-2 slip are printed, the RPRL2 process will generate an intermediate Summary Total on the RMEX report
__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
At line 260 changed one line
*When RPRL1 is run, if there is more than one Government Registration Number from IDGR;
*When RPRL2/RPRL2W is run, if there is more than one Government Registration Number from IDGR:
At line 262 changed one line
**RPRL1 will generate totals for each Government Registration Number on the RMEX report.
**RPRL2/RPRL2W will generate totals for each Government Registration Number on the RMEX report.
At line 267 changed one line
When RPYEC is run, users must enter:
When RPYEC is run, users must enter:\\
At line 269 changed 3 lines
1. The Federal Government Registration to select employees at the Federal level.
2. The Province of Quebec to run RPYEC for Releve 2
3. The Provincial Government Registration for Quebec
1. The Federal Government Registration to select employees at the Federal level.\\
2. The Province of Quebec to run RPYEC for Releve 2.\\
3. The Provincial Government Registration for Quebec.\\
At line 279 changed 2 lines
* When RPRL2 is run, RL-2 Grand Totals are generated for all RL-2 Slips as Execution Run Log Exception messages to balance to RPYEC summary report.
* Users MUST run the RMEX report for the Mex ID from the RPRL2 run to print the RL-1 Grand Totals to verify all records are printed. \\ \\
* When RPRL2/RPRL2W is run, RL-2 Grand Totals are generated for all RL-2 Slips as Execution Run Log Exception messages to balance to RPYEC summary report.
* 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 301 changed one line
Refer to Quebec publication IN-800-V section 4.4 Numbering of R Slips. \\
Refer to the Quebec publication IN-800-V section 4.4 Numbering of R Slips. \\
At line 332 changed one line
IMPORTANT: After the RPRL1 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 354 changed one line
__When users are running Amended or Canceled forms, the system will retrieve the Original Releve Form Number and pass this Identifier to print on the RL-2 Slip and for the government Amended/Canceled XML file.__ \\ \\
When users are running Amended or Canceled forms, the system will retrieve the Original Releve Form Number and pass this Identifier to print on the RL-2 Slip and for the government Amended/Canceled XML file. \\ \\
At line 356 removed 2 lines
__Exclude EEs__\\
Users can exclude certain employees from Releve1 reporting by setting up EXCLUDE-EE Identifier on the IDFDV form. \\ \\
At line 359 removed 49 lines
If the value of the EXCLUDE-EE Identifier is set to Yes, the employee is by-passed. \\ \\
Example: If a user does not want to report employees whose Assignment Title is Election Worker or Self Employed, set up the R2-EXCLUDE-EE Identifier with the following: \\
*Field variable = EASD.ASSIGNMENT_TITLE
*Derivation Expression =
**decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N') \\ \\
__NOTE:__ Use UPPER(~) to convert an alphanumeric field to compare all upper case letters. \\ \\
If a user has a complex situation to exclude an employee, a STAT CODE can be used to define the employee should be excluded. \\ \\
Example: An employee is excluded when they work in certain groups, or with certain hours. Users can keep track of this by setting the STAT CODE value to 1.00. Then the EXCLUDE-EE Identifier on IDFDV, should be set up with:
*Field Source = Statistics
*Field variable = the STAT CODE that is used to exclude employee
*Derivation Expression = decode(~,1,'Y','N') \\ \\
__Primary and Mailing Addresses__\\
[Employer Address|] \\
If a user wants to use the Employer Primary Address, the 1220–1290 Identifiers do not need to be set up. Leave these Identifiers blank and the system will use the Primary Address as the default. \\ \\
If a user wants to use the Employer Mailing Address, the following Identifiers need to be defined:
||Field Identifier||Suggested Field Variable
|R2-ER-ADDR2|DLN.ADDRESS_LINE_1
|R2-ER-ADDR2|DLN.ADDRESS_LINE_2
|R2-ER-ADDR3|DLN.LOCALITY
|R2-ER-ADDR4|DSP.STATE_PROVINCE_CODE
|R2-ER-ADDR5|DCO.COUNTRY_CODE
|R2-ER-POSTAL|DLN.ZIP_POSTAL
* The Reference Text field will guide the setup of each Address Identifier.
* If the mailing address is not defined for the Employer on the IDLN form or the Location field on the IDEN form, the IDLN primary address will be used.
* If an Address was set up prior to 2006, and if the word MAIL is defined, the mailing address will be used, otherwise the primary address will be used. \\ \\
[Employee Address|] \\
If a user wants to use the Primary Address, the 2100–2140 Identifiers do not need to be set up. Leave these Identifiers blank and the system will use the Primary Address as the default. \\ \\
If a user wants to use the Mailing Address, the following Identifiers need to be defined:
||Field Identifier||Suggested Field Variable
|R2-EE-ADDR2|EPS.ADDRESS_LINE_1
|R2-EE-ADDR2|EPS.ADDRESS_LINE_2
|R2-EE-ADDR3|EPS.LOCALITY
|R2-EE-ADDR4|DSP.STATE_PROVINCE_CODE
|R2-EE-ADDR5|DCO.COUNTRY_CODE
|R2-EE-POSTAL|EPS.ZIP_POSTAL
* The Reference Text field will guide the setup of each Address Identifier.
* If the mailing address is not defined for the Employee on the IEPI form, the IEPI primary address will be used.
* If an Address was set up prior to 2006, and if the word MAIL is defined, the mailing address will be used, otherwise the primary address will be used. \\ \\
At line 420 changed one line
__For Numeric Field Variables:__
__For AlphaNumeric Field Variables:__
At line 432 changed one line
__Printing RPRL2__\\
__Printing RPRL2/RPRL2W__\\
At line 439 removed 3 lines
!Electronic RL-2 Print
Employees can consent, or withdraw their consent, to receive/print their Releve 1 or Releve 2 slips through Self Service. If an employee chooses to receive electronic Releve 1 or Releve 2 slips, they must enter their consent in the My T4 Consent form (WEPT4). \\ \\
Employees must run the RERL1 (Print My Releve 1 slip) and select the Reporting Year they want to print. The output Releve 1 slip will be in a pdf format. \\ \\
At line 443 removed 11 lines
If an employee has chosen to receive electronic Releve 1 or Releve 2 forms, using either the consent form WEPT4 or IEPT4, a paper copy is NOT printed during the RPT4 T4 printing process. \\ \\
Organizations can also manage the consent for employees to receive electronic Releve 1 using the Maintain Employee T4 Consent form (IEPT4). \\ \\
Organizations can control the years that Releve1 forms are available for employees to print, by setting a Preference on the IMST form, as below. \\ \\
__Setup/Implementation__\\
Users must set up the EE_T4_GVT_RUN Preference with the values of the GVT Run Numbers that contain the information for the employee’s T4s (from the RPYEC run) on the IMST form, Preference tab. \\ \\
The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567). \\ \\
At line 456 changed one line
Users should read the following Form Descriptions and refer to 2017 Guide to Filing the RL-2 Slip RL-2.G-V (2017-10) prior to setting up IDFDV form.\\ \\
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 556 changed one line
%%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.%%
%%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.%%
At line 565 changed one line
High Line uses the XML SPY Home edition tool to validate the RL-2 and Rl-2 xml files.
High Line uses the XML SPY Home edition tool to validate the RL-2 and RL-2 xml files.
This page (revision-15) was last changed on 19-Oct-2022 20:33 by Karen ParrottTop