This page (revision-21) was last changed on 19-Oct-2022 20:32 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
21 19-Oct-2022 20:32 42 KB Karen Parrott to previous

Page References

Incoming links Outgoing links
CDN_RELEVE 1_PROCESS...nobody
CDN_RELEVE1_PROCESS

Version management

Difference between version and

At line 1 changed one line
!!!RELEVE 1 PROCESS
!!!RELEVE 1 PROCESS
At line 3 changed 2 lines
High Line has defined processes to complete Canadian government reporting from the employee's YTD information according to the government defined requirements. These processes include:
* Generating and printing the Rl-1 Slips
[{TableOfContents }]
High Line has defined processes to complete the Canadian government reporting from the employee's YTD information according to the government defined requirements. These processes include:
* Generating and printing the RL-1 Slips
At line 9 changed one line
For 2017-2018 reporting, the IDFD HL$CAN-R1-2017 Form Code is used. \\ \\
For the Current Year reporting, the IDFD HL$CAN-R1-YYYY Form Code is used. \\ \\
At line 11 changed one line
This seed data script is re-runnable. I twill not erase the IDFDV set up of the same Form Code.
This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code.
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 50 changed one line
This is the beginning number for the RL-1 Slips, using the modulus 7 method, to derive the ninth digit. The RL-1 Slip is printed with the complete 9 digit number. \\ \\For each RPYEC run, users must ensure this number contains the last number that was derived from the last RPYEC run and add 1, to define the next beginning number. This will ensure no duplicate numbers are derived for the RL-1 Slips. Users only need to enter the first 8 digits in this field, from the previous RPYEC run.
This is the beginning number for the RL-1 Slips, using the modulus 7 method, to derive the ninth digit. The RL-1 Slip is printed with the complete 9 digit number. \\ \\For each RPYEC run, users must ensure this number contains the last number that was derived from the last RPYEC run and add 1, to define the next beginning number. This will ensure no duplicate numbers are derived for the RL-1 Slips. Users only need to enter the first 8 digits in this field, from the previous RPYEC run. \\ \\
At line 54 added one line
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 53 removed one line
After each RPYEC run, this identifier is updated to store the last number assigned according to the R1-FORM-NUM-BEG Identifier. After users run the RPRL1 program to print the actual RL-1 Slips, users must manually add 1 to this number and then update the R1-FORM-NUM-BEG Identifier so the next RPYEC run can begin with the correct new number.
At line 57 added 3 lines
After each RPYEC run, this identifier is updated to store the last number assigned according to the R1-FORM-NUM-BEG Identifier. After users run the RPRL1W program to print the actual RL-1 Slips, users must manually add 1 to this number and then update the R1-FORM-NUM-BEG Identifier so the next RPYEC run can begin with the correct new number.\\ \\
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
At line 68 changed one line
|R1-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.
|R1-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 166 changed 2 lines
!!!RPRL1 Selection Criteria
[{InsertPage page='RPRL1}]
!!!RPRL1W Selection Criteria
[{InsertPage page='RPRL1W}]
At line 169 changed 2 lines
!!!RPRL1 Slip Print Processing
The RPRL1 program Print Format is based on the Government published RL-1.L (2016-10) Form. If you are using other versions of this form, such as the 2004-10 version, please test the RPRL1 program form layout prior to printing. \\ \\
!!!RPRL1W Slip Print Processing
The High Line RPRL1W program generates the form boxes, as well as the instructions. Pre-printed forms are no longer required. \\ \\
The RPRL1W Form Print program format is based on the current Government published RL-1.L Form. The IN-412-V RL Requirements for Computer-Generated Forms document is included in the year end software.\\ \\
At line 172 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 RPRL1 program. \\ \\
The RPRL1W Form Print program prints all information generated based on the GVT Run number. \\
At line 174 changed one line
If, however, an organization user receives a different version of the form from the government, and the RPRL1 program does not align properly with the form, users should re-order the Form from the government that is the same as RPRL1 program. \\ \\
If an employee has many footnote codes to be reported, each subsequent RL-1 Slip is printed with footnote codes until all footnote codes are printed. \\
At line 176 changed one line
The RPRL1 form print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria. \\ \\
The RPRL1W program generates Summary Totals by each Business Number. At the end of the RPRL1W run, a grand total is generated for all Business Numbers. \\
At line 178 changed one line
If an employee has many Footnotes to be reported, each subsequent RL-1 Slip is printed with Footnote Codes until all Footnotes Codes are printed. \\ \\
Users must run RMEX with the RPRL1W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\
At line 180 changed one line
The RPRL1 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 RPRL1W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\
At line 182 changed one line
Users must run RMEX with the RPRL1 Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\ \\
Users should confirm that the RPRL1W Boxes balance to the RPGRC Summary Report. \\
At line 184 changed one line
The RPRL1 Summary and Grand Totals are accumulated for the Boxes shown on the Slip, the Footnote Codes are not totaled. \\ \\
If the RPRL1W process cannot select any information from the xml file to print, users must run RMEX with the RPRL1W Mex ID to review any error or exception messages to identify the problem. \\ \\
At line 186 removed 4 lines
Users should confirm that the RPRL1 Boxes balance to the RPGRC Summary Report. \\ \\
If the RPRL1 process cannot select any information from the xml file to print, users must run RMEX with the RPRL1 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 191 changed one line
Users are required to print the Employer and Employee Copy of the RL-1. Users must run RPRL1 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-1. Users must run RPRL1W twice; once to print the Employer Copy and once to print the Employee Copy. \\
At line 193 changed one line
When RPRL1 is run, the Print RL-1 Copy field defines if the Employer or Employee Copy is printed. \\ \\
When RPRL1W is run, the Print RL-1 Copy field defines if the Employer or Employee Copy is printed.
At line 196 changed one line
* On one sheet, the RL-1 information is printed for 3 different employees
* On one sheet, the RL-1 information is printed
At line 200 changed one line
* On one sheet, 3 RL-1 copies are printed for one employee
* On one sheet, 1 RL-1 copy is printed for one employee
At line 208 changed one line
*Change the Print Stage to: 11 – Duplicate requested
*Change the Print Stage to 'Duplicate Requested'
At line 212 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-1 Slip depending on the GVT Run option of the RPRL1 run. \\
When users are running RPRL1W with the new GVT Run number, RPRL1W will automatically print the DUPLICATE COPY or AMENDED on the RL-1 Slip depending on the GVT Run option of the RPRL1W run. \\
At line 214 changed one line
When RPRL1 is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\ \\
When RPRL1W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\ \\
At line 216 changed 3 lines
2. Run RPRL1 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 RPRL1 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 RPRL1W 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 220 changed 4 lines
3. Run RPRL1 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 RPRL1W to print the duplicate forms
* Run the Form Print RPRL1W program 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'
* The GVT Header stage will be updated to 'Duplicate Printed' depending on the 'Trial Print Only' field setting. \\ \\
At line 226 changed one line
If a user discovers erroneous box information on the RL-1 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-1 slip. \\
If a user discovers erroneous box information on the RL-1 slip and needs to revise the Box information, users should either correct the employee amounts or modify the IDFDV set up and then re-run the RPGRC and RPRL1W processes. This produces the Amended RL-1 slip. \\
At line 231 changed one line
2. Check the IDFDV set up and revise the box information, if necessary. \\
2. Check the IDFDV set up and revise the Box information, if necessary. \\
At line 233 changed one line
*Change the Print Stage to Amendment Requested
*Change the 'Print Stage' to 'Amendment Requested'
At line 240 added one line
At line 237 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 242 changed 5 lines
5. Run RPGRC with the GVT Form Option set to Amended Forms \\
*Do not set the Trial Print Only toggle to ON, for the RPGRC process
*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.
*Users should enter the Govt Interface Format definition for the RPGRC to generate the amended government xml file.
*At the end of the RPGRC, the GVT Headers is updated with:
5. Run RPGRC with the 'GVT Form Option' set to 'Amended Forms'. \\
*Do not set the Trial Print Only toggle to YES, for the RPGRC process
*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 RPRL1W print program.
*Users should enter the Govt Interface Format definition for RPGRC to generate the amended government xml file.
*At the end of the RPGRC, the GVT Header is updated with:
At line 249 removed 4 lines
6. Run RPRL1 to print the Amended forms. \\
*When the user is running RPRL1 with the new _HL.xml file, RPRL1 will automatically print the word DUPLICATE COPY or AMENDED on the T4 form, depending on the GVT Run option of the RPGRC run.
*If other wording is required to print on the RL-1 slip, in the Duplicate/Amended parameter, users can enter the text for RPRL1, such as CANCEL COPY or ORIGINAL COPY.
*At the end of the RPRL1 run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage. \\ \\
At line 254 changed 9 lines
__RPRL1 Void Forms__\\
*After the RL-1 slip are printed, the RPRL1 process will generate an intermediate Summary Total on the RMEX report
*Users will bundle the Summary Total with the current year RL-1 slip to send to the government
*If an employee requires more than one RL-1 slip, and this employee’s RL-1 information is split between 2 summaries, then this employee’s RL-1 information will be printed on the first Summary Total. Consequently, there may be more RL-1 slips on the Summary.
*When the last RL-1 slip is printed for the first Summary, if the last RL-1 information prints on the TOP RL-1 slip, the BOTTOM RL-1 slip will be VOIDED so users can separate the RL-1 slips by Summary.
*When RPRL1 is run, if there is more than one Government Registration Number from IDGR;
**The RL-1 forms will be sorted by Government Registration Numbers
**RPRL1 will generate totals for each Government Registration Number on the RMEX report.
*When the last RL-1 form is printed for the first Government Registration Number, if the last RL-1 information prints on the TOP RL-1 slip, the BOTTOM RL-1 slip will be VOIDED so users can separate the RL-1 slips by Government Registration Number.
6. Run RPRL1W to print the Amended forms. \\
*When the user is running RPRL1W with the new GVT Run number, RPRL1W will automatically print the word DUPLICATE COPY or AMENDED on the RL-1 form, depending on the GVT Run option of the RPGRC run.
*If other wording is required to print on the RL-1 slip, in the Duplicate/Amended parameter, users can enter the text for RPRL1W, such as CANCEL COPY or ORIGINAL COPY.
*At the end of the RPRL1W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage. \\ \\
At line 261 added 18 lines
!!RL-1 Slip Print characteristics
When RPYEC is run, users must enter: \\
1. The Federal Government Registration to select employees at the Federal level.\\
2. The Province of Quebec to run RPYEC for Releve 1\\
3. The Provincial Government Registration for Quebec \\
* RL-1 slips are printed in alphabetical order by the employee’s Surname, First Name.
* The font size for printing RL-1 slips is the standard 10 characters per inch font size.
* Negative (credit) amounts are never allowed for RL-1 reporting. If negative amounts are encountered, an exception message is printed, and users must resolve the negative amount(s) and re-run the process.
* If there is no amount to be printed in a Box on the RL-1 Slip, the Box is left as Blank.
* Users can sort inactive and active employees for mailing purposes.
* If the Employment Status is A (Active) then the Employee is considered Active, otherwise the employee is considered Inactive.
* When RPRL1W is run, RL-1 Grand Totals are generated for all RL-1 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 RPRL1W run to print the RL-1 Grand Totals to verify all records are printed.
At line 265 changed one line
On the RL-1 Slip, users can print the user defined distribution information for users to distribute the RL-1 Slips to the employees. Users must set up the following Identifiers, derived from the IDFDV form:\\
On the RL-1 Slip, the last line in the Address Box is used to print the user defined distribution information for users to distribute the RL-1 Slips to the employees. Users must set up the following Identifiers:\\
At line 272 changed one line
If the R1-EE-REFER value = 1, the distribution will be printed below the employee address, and the distribution will be visible outside the window envelope, depending on the envelope. \\ \\
If the R1-EE-REFER value = 1, the distribution will be printed below the employee address, and the distribution will be visible outside the window envelope, for distribution purposes. Otherwise, the distribution will not be printed. \\ \\
At line 274 removed 2 lines
Otherwise, the distribution will not be printed. \\
At line 283 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 306 changed one line
On the IDFDV form, R1-FORM-NUM-BEG Field Identifier, users must enter the 8 digit beginning number assigned by Ministere du Revenu du Quebec. \\ \\
On the IDFDV form, R1-FORM-NUM-BEG Field Identifier, users must enter the 8 digit beginning number assigned by Ministere du Revenu du Quebec. \\
At line 308 changed one line
After RPYEC is run, RPYEC displays the last RL-1 Slip number assigned as an exception message on the RPYEC report. \\ \\
After RPYEC is run, RPYEC displays the last RL-1 Slip number assigned as an exception message on the RPYEC report. \\
At line 310 changed one line
Users need to verify all RL-1 box information on the RPYEC summary report. If the RL-1 Summary report is incorrect, users can re-run RPYEC as many times as required without changing the R1-FORM-NUM-BEG number. \\ \\
Users need to verify all RL-1 box information on the RPYEC summary report. If the RL-1 Summary report is incorrect, users can re-run RPYEC as many times as required without changing the R1-FORM-NUM-BEG number. \\
At line 312 changed one line
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-1 Forms. \\ \\
Once all of the information is verified with the RPYEC report, users should run RPGRC to generate the xml files for RPRL1/RPRL1W to print the RL-1 Forms. \\
At line 314 changed one line
IMPORTANT: After the RPRL1 program is run, users must __manually go into the IDFDV form and update the R1-FORM-NUM-BEG with the last Form Number assigned + 1__ for the next RPYEC RL-1 run. \\ \\
%%IMPORTANTNOTE: After the RPRL1W program is run, users must __manually go into the IDFDV form and update the R1-FORM-NUM-BEG with the last Form Number assigned + 1__ for the next RPYEC RL-1 run. \\
\\
For each RPYEC run, users must ensure that the R1-FORM-NUM-BEG number contains the beginning number to be used since the last RPYEC run so that no duplicate numbers are produced for the RL-1 forms. Users only need to enter the 8 digits of the previous RPYEC run in this field. \\
At line 316 changed one line
For each RPYEC run, users must ensure that the R1-FORM-NUM-BEG number contains the beginning number to be used since the last RPYEC run so that no duplicate numbers are produced for the RL-1 forms. Users only need to enter the 8 digits of the previous RPYEC run in this field. \\ \\
When RPYEC generates the GVT Header records for RL-1 for the employees, the system derives the RL-1 Slip number for each form and stores them in the GVT Header Form Number field. Users can view the Form Number on the IPGH form after RPYEC is run. \\
At line 318 removed 2 lines
When RPYEC generates the GVT Header records for RL-1 for the employees, the system derives the RL-1 Slip number for each form and stores them in the GVT Header Form Number field. Users can view the Form Number on the IPGH form after RPYEC is run. \\ \\
At line 322 changed one line
*The _HL.xml file for RPRL1 to print the exact same number on RL-1 form
*The _HL.xml file for RPRL1W to print the exact same number on RL-1 form
At line 324 changed one line
RPGRC displays the highest Form Number of the run at the end of the report. If a user is selecting to print a specific employee only, the printed Form Number will not be the latest Form Number being used. Consequently, it is the user’s responsibility to ensure the IDFDV R1-FORM-NUM-BEG is updated correctly with the highest number. \\ \\
RPGRC displays the highest Form Number of the run at the end of the report. If a user is selecting to print a specific employee only, the printed Form Number will not be the latest Form Number being used. Consequently, it is the user’s responsibility to ensure the IDFDV R1-FORM-NUM-BEG is updated correctly with the highest number. \\
At line 332 changed one line
After each RPYEC run, this identifier is updated to store the last number assigned according to the R1-FORM-NUM-BEG Identifier. After RPRL1 is run to print the actual RL-1 Slip, users must manually add 1 to this number and then update the R1-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 R1-FORM-NUM-BEG Identifier. After RPRL1W is run to print the actual RL-1 Slip, users must manually add 1 to this number and then update the R1-FORM-NUM-BEG Identifier so that the next RPYEC run can begin with the correct new number. \\ \\
At line 339 changed one line
Users can exclude certain employees from Releve1 reporting by setting up EXCLUDE-EE Identifier on the IDFDV form. \\ \\
Users can exclude certain employees from Releve1 reporting by setting up the EXCLUDE-EE Identifier on the IDFDV form. \\
At line 341 changed one line
If the value of the EXCLUDE-EE Identifier is set to Yes, the employee is by-passed. \\ \\
If the value of the EXCLUDE-EE Identifier is set to Yes, the employee is by-passed. \\
At line 347 changed one line
**decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N') \\ \\
**decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N') \\
At line 349 changed one line
__NOTE:__ Use UPPER(~) to convert an alphanumeric field to compare all upper case letters. \\ \\
__NOTE:__ Use UPPER(~) to convert an alphanumeric field to compare all upper case letters. \\
At line 351 changed one line
If a user has a complex situation to exclude an employee, a STAT CODE can be used to define the employee should be excluded. \\ \\
If a user has a complex situation to exclude an employee, a STAT CODE can be used to define the employee should be excluded. \\
At line 399 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 422 added one line
\\
At line 410 changed 2 lines
__For Numeric Field Variables:__
__For AlphaNumeric Field Variables:__
At line 418 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-1 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-1 Slip.\\
At line 423 removed 2 lines
__Printing RPRL1__\\
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the "Run Options" tab. \\ \\
At line 426 removed 4 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. \\ \\
At line 432 changed one line
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. \\ \\
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 434 changed one line
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. \\ \\
If an employee has chosen to receive electronic Releve 1 forms, using either the consent form WEPT4 or IEPT4, a paper copy is NOT printed during the RPRL1W printing process. \\
At line 436 changed one line
Organizations can also manage the consent for employees to receive electronic Releve 1 using the Maintain Employee T4 Consent form (IEPT4). \\ \\
Organizations can also manage the consent for employees to receive electronic Releve 1 using the Maintain Employee T4 Consent form (IEPT4). \\
At line 438 changed one line
Organizations can control the years that Releve1 forms are available for employees to print, by setting a Preference on the IMST form, as below. \\ \\
Organizations can control the years that Releve1 forms are available for employees to print, by setting a Preference on the IMST form, as below. \\
At line 441 changed one line
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. \\ \\
Users must set up the EE_R1_GVT_RUN Preference with the values of the GVT Run Numbers that contain the information for the employee’s RL-1s (from the RPYEC run) on the IMST form, Preference tab. \\ \\
At line 445 changed 2 lines
__RL-1 Slip - 2017 Format__\\
Users should read the following Form Descriptions and refer to 2017 Guide to Filing the RL-1 Slip RL-1.G-V (2017-10) prior to setting up IDFDV form.\\
__RL-1 Slip - 2018 Format__\\
Users should read the following Form Descriptions and refer to 2018 Guide to Filing the RL-1 Slip RL-1.G-V (2018-10) prior to setting up IDFDV form.\\ \\
At line 448 changed 4 lines
__RL-1 Slip - Box Descriptions__\\
||Box||Title||Description||Field Identifier
| |Number on RL-1 slip (Top right corner)|Derived from the IDFDV form, as below|R1-FORM-NUM-BEG
Please refer to the section Numbering of RL-1 Slip for full details. \\ \\
__RL-1 Slip - Box Descriptions__\\ \\
__Box__: Number on RL-1 slip (Top right corner), derived from the IDFDV form, as below. Please refer to the section Numbering of RL-1 Slip for full details. \\
__Field Identifier__: R1-FORM-NUM-BEG\\
At line 453 changed 2 lines
||Box||Title||Description
| |Year|Pre-printed on RL-1 Slip or from the user defined Calendar Year \\ \\
__Box: Year__ - Pre-printed on RL-1 Slip or from the user defined Calendar Year \\
At line 456 changed 2 lines
||Box||Title||Description
| |Employer’s Name and Address|Derived from the IDFDV form, as below
__Box: Employer’s Name and Address__, derived from the IDFDV form, as below\\
At line 475 changed 2 lines
||Box||Title||Description
| |Employee’s Social Insurance #|Derived from the IDFDV form, as below
__Box: Employee’s Social Insurance #__, derived from the IDFDV form, as below
At line 481 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 \\
At line 483 changed 2 lines
||Box||Title||Description
| |Reference Number (Numero de reference employeur)|Contains the employee’s Person Code, (PERSON-CODE Identifier) as an additional employee identifier.\\ \\
__Box: Reference Number (Numero de reference employeur)__. Contains the employee’s Person Code, (PERSON-CODE Identifier) as an additional employee identifier.\\
At line 486 changed 2 lines
||Box||Title||Description
| |Employee’s Name|Derived from the IDFDV form, as below
__Box: Employee’s Name__, derived from the IDFDV form, as below
At line 492 changed one line
\\ \\
\\
At line 494 changed 3 lines
||Box||Title||Description
| |Employee’s Address|Derived from the IDFDV form, as below
__Box: Employee’s Address__, derived from the IDFDV form, as below
At line 510 changed one line
*If the Country Code is not Canada or USA, then the R1-EE-MAG-PROV Identifier should be set to ZZ – Other.\\ \\
*If the Country Code is not Canada or USA, then the R1-EE-MAG-PROV Identifier should be set to ZZ – Other.\\
At line 512 changed 4 lines
||Box||Title||Description
| |Area below the Employee Information|Derived from the IDFDV form, as below
Print for RL-1 distribution purposes
__Box: Area below the Employee Information__, derived from the IDFDV form, as below. Print for RL-1 distribution purposes.
At line 525 changed 3 lines
||Box||Title||Description
|A|Employment Income|Derived from the IDFDV form, as below
__Box: A__ - Employment Income, derived from the IDFDV form, as below. This is the taxable earnings applicable for Quebec income tax withheld.
At line 530 changed one line
This is the taxable earnings applicable for Quebec income tax withheld. \\ \\
At line 532 changed 3 lines
||Box||Title||Description
|B|Employee QPP Contributions|Derived from the IDFDV form, as below
__Box: B__ - Employee QPP Contributions|Derived from the IDFDV form, as below
At line 539 changed one line
* The QPP Employee contribution is not printed on the RL-1 Slip for each employee. It is reported on the RL-1 government file. \\ \\
* The QPP Employee contribution is not printed on the RL-1 Slip for each employee. It is reported on the RL-1 government file. \\
At line 549 changed 4 lines
\\ \\
||Box||Title||Description
|G|QPP Pensionable Earnings|Derived from the IDFDV form, as below
Please refer to Guide to Filing the RL-1 Slip RL-1.G-V 2017-10 for Box G processing \\ \\
__Box: G__ - QPP Pensionable Earnings|Derived from the IDFDV form, as below. Please refer to Guide to Filing the RL-1 Slip RL-1.G-V 2017-10 for Box G processing \\ \\
At line 569 changed one line
Please see refer to Guide to Filing the RL-1 Slip Box G for details. \\ \\
Please see refer to Guide to Filing the RL-1 Slip Box G for details. \\
At line 578 changed one line
Example: If Box G is greater than or equal to the QPP maximum earnings, then Box G = Blank. \\When R1-BOX-G-PRT = 0.00, RPRL1 will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank. \\
Example: If Box G is greater than or equal to the QPP maximum earnings, then Box G = Blank. \\When R1-BOX-G-PRT = 0.00, RPRL1W will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank. \\
At line 581 changed one line
Example: Box G = Box A, and if Box Q and Box U = 0, then leave Box G blank. \\When R1-BOX-G-PRT = 0.00, RPRL1 will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank.
Example: Box G = Box A, and if Box Q and Box U = 0, then leave Box G blank. \\When R1-BOX-G-PRT = 0.00, RPRL1W will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank.
At line 583 changed one line
4. When an employee reaches the age 18 during the year, and if the employee worked prior to age 18, then usually Box A is greater than Box G. Box G will be printed with the amount from the R1-BOX-G Identifier.\\A message Box G-Employ period from [date] to [date] (French message: Case G:d'emploi du [date] au [date])’ will be printed in the center of the RL-1 slip. \\The From Date is the Hired date, and the To Date is end date of current reporting year.\\ \\
4. When an employee reaches the age 18 during the year, and if the employee worked prior to age 18, then usually Box A is greater than Box G. Box G will be printed with the amount from the R1-BOX-G Identifier.\\A message Box G-Employ period from (date) to (date) (French message: Case G: d'emploi du (date) au (date)’ will be printed in the center of the RL-1 slip. \\The From Date is the Hired date, and the To Date is end date of current reporting year.\\ \\
At line 585 changed one line
5. Calculate pensionable earnings from Box A with Box G excepted earnings, Box Q and Box U amount. Calculate revised Box G amount = Box A – Box G excepted amount + Box Q + Box U\\
5. Calculate pensionable earnings from Box A with Box G excepted earnings, Box Q and Box U amount. \\Calculate revised Box G amount = Box A – Box G excepted amount + Box Q + Box U\\
At line 590 changed one line
Example: R1-BOX-G-PRT = 0.00, RPRL1 will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank.\\
Example: R1-BOX-G-PRT = 0.00, RPRL1W will not generate the R1-BOX-G-PRT-0 Identifier, then Box G is left as blank.\\
At line 596 changed 2 lines
|H|Meals and Accommodation|R1-BOX-H|R1-BOX-H
|I|Personal Use Motor Vehicle|R1-BOX-I|R1-BOX-I
|H|QPIP Employee Premium|R1-BOX-H|R1-BOX-H
|I|QPIP Earnings|R1-BOX-I|R1-BOX-I
At line 611 changed 3 lines
\\ \\
||Box||Title||Description
|O|CODE (case O)|Derived from the IDFDV form
\\
__Box: O CODE__ (case O), derived from the IDFDV form, as below
At line 618 changed 4 lines
*If RZ is printed, then each Identifier with a value greater than zero will be printed in the center of the RL-1 Slip.\\ \\
||Box||Title||Description
| |Centre of RL Slip|Derived from the IDFDV form, as below
*If RZ is printed, then each Identifier with a value greater than zero will be printed in the center of the RL-1 Slip.\\
\\
__Box: Centre of RL Slip__, derived from the IDFDV form, as below
At line 634 changed one line
The government file layouts are provided by the government on their web site each year. High Line uses the IDIF form to define the government file as specified, in an xml file format. The IDIF layout is provided by High Line with the year end software (SEED_IDIF_HL$CAN_R1_2017.sql. Users do not need to modify this form. \\ \\
The government file layouts are provided by the government on their web site each year. High Line uses the IDIF form to define the government file as specified, in a .xml file format. The IDIF layout is provided by High Line with the year end software (SEED_IDIF_HL$CAN_R1_20YY.sql). \\ Users do not need to modify this form. \\ \\
At line 639 changed one line
\\ \\
At line 636 added 3 lines
----
![Notes|Edit:Internal.CDN RELEVE 1 PROCESS]
[{InsertPage page='Internal.CDN RELEVE 1 PROCESS' default='Click to create a new notes page'}]
This page (revision-21) was last changed on 19-Oct-2022 20:32 by Karen ParrottTop