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 added 2 lines
[{TableOfContents }]
At line 4 changed one line
* Generating and printing the Rl-1 Slips
* Generating and printing the RL-1 Slips
At line 9 changed one line
For 2018-2019 reporting, the IDFD HL$CAN-R1-YYYY Form Code is used. \\ \\
For the Current Year reporting, the IDFD HL$CAN-R1-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
|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 173 changed one line
The RPRL1W Form Print program prints all information generated based on the GVT Run number. \\ \\
The RPRL1W Form Print program prints all information generated based on the GVT Run number. \\
At line 175 changed one line
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. \\ \\
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 177 changed one line
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. \\ \\
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 179 changed one line
Users must run RMEX with the RPRL1W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\ \\
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 181 changed one line
The RPRL1W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\ \\
The RPRL1W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\
At line 183 changed one line
Users should confirm that the RPRL1W Boxes balance to the RPGRC Summary Report. \\ \\
Users should confirm that the RPRL1W Boxes balance to the RPGRC Summary Report. \\
At line 188 changed one line
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. \\ \\
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 190 changed one line
When RPRL1W 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 262 changed one line
3. The Provincial Government Registration for Quebec \\ \\
3. The Provincial Government Registration for Quebec \\
At line 314 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 316 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 318 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 320 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/RPRL1W 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 322 changed one line
IMPORTANT: 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. \\ \\
%%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 324 removed 2 lines
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 332 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 347 changed one line
Users can exclude certain employees from Releve1 reporting by setting up the 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 349 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 355 changed one line
**decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N') \\ \\
**decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N') \\
At line 357 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 359 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 407 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 418 removed one line
At line 426 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 434 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 436 changed one line
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. \\ \\
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 438 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 440 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 450 changed 3 lines
__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\\ \\
__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 454 changed one line
__Box: 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 479 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 481 changed one line
__Box: 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 488 changed one line
\\ \\
\\
At line 490 removed one line
At line 505 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 520 changed one line
\\ \\
At line 527 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 537 removed one line
\\ \\
At line 555 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 569 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 571 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 597 changed one line
\\ \\
\\
At line 603 changed 2 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.\\ \\
*If RZ is printed, then each Identifier with a value greater than zero will be printed in the center of the RL-1 Slip.\\
\\
At line 618 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 623 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