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 4 lines
[{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
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
At line 8 removed 632 lines
!!IDFD Form Definition
__IDFD Changes__\\
For the Current Year reporting, the IDFD HL$CAN-R1-YYYY Form Code is used. \\ \\
High Line provides this definition each year as part of the year end software delivered in December. It is not necessary to maintain this form, unless instructed to do so by High Line.
This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code.
__IDFD Store Options__\\
%%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.%%
After the current year IDFD is loaded, users must set up their organizations's information for this Form Definition on the IDFDV form. Users can copy the IDFDV Variable definition form the last year to the current year. Please refer to the 'Copy Last Year's Definition to Current Year' section below for full details.
!!IDFDV Form Definition Variables
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
|R1-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|R1-ER-CAREOF|Employer Name (care of)|Data Base Column|Optional
|R1-ER-ADDR1|Employer Address Line 1|Data Base Column|DLN.ADDRESS_LINE_1
|R1-ER-ADDR2|Employer Address Line 2|Data Base Column|DLN.ADDRESS_LINE_2
|R1-ER-ADDR3|Employer City|Data Base Column|DLN.LOCALITY
|R1-ER-ADDR4|Employer Province|Data Base Column|DSP.STATE_PROVINCE_CODE
|R1-ER-ADDR5|Employer Country|Data Base Column|DCO.COUNTRY_NAME
|R1-ER-POSTAL|Employer Postal Code|Data Base Column|DLN.ZIP_POSTAL
|R1-ER-MAG-PROV|Employer Prov for Mag File|Constant|Blank
|R1-ER-MAG-CNTRY|Employer Country for Mag File|Constant|Blank
|R1-NEQ-NUMBER|Quebec Enterprise NEQ #|Constant|Enter your company data
|R1-EE-NAME1|Employee Surname|Data Base Column|EID.LAST_NAME
|R1-EE-NAME2|Employee First Name|Data Base Column|EID.FIRST_NAME
|R1-EE-NAME3|Employee Middle Initial|Data Base Column|EID.MIDDLE_NAME
|R1-EE-ADDR1|Employee Address Line 1|Data Base Column|EPS.ADDRESS_LINE_1
|R1-EE-ADDR2|Employee Address Line 2|Data Base Column|EPS.ADDRESS_LINE_2
|R1-EE-ADDR3|Employee City|Data Base Column|EPS.LOCALITY
|R1-EE-ADDR4|Employee Province|Data Base Column|DSP.STATE_PROVINCE_CODE
|R1-EE-ADDR5|Employee Country|Data Base Column|DCO.COUNTRY_CODE
|R1-EE-POSTAL|Employee Postal Code|Data Base Column|EPS.ZIP_POSTAL
|R1-EE-MAG-PROV|Employee Prov for Mag File|Constant|Blank
|R1-EE-MAG-CNTRY|Employee Country for Mag File|Constant|Blank
|R1-EE-SIN|Social Insurance Number|Data Base Column|EID.GOVERNMENT_CODE
|R1-EE-REFER|Print Distribution|Constant|Blank or 1. If 1, print employee distribution
|R1-EE-DESTIN|Print Pay Destination|Constant|Blank or 1. If 1, employee destination is concatenated to employee distribution for printing purposes
|R1-EE-REFER1|Employee Distribution 1|Data Base Column|PPA.PAYROLL_CODE
|R1-EE-REFER2|Employee Distribution 2|Data Base Column|EID.PERSON_CODE
|R1-FORM-NUM-BEG|RL-1 Slip beginning number|Constant|Enter your company data
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. \\ \\
||Field Identifier||Descirption||Suggested Field Source||Suggested Variable
|R1-FORM-NUM-LAST|RL-1 Slip ending number|Constant|System Derived
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
|EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
|R1-BOX-A|Employment Income|Element|R1-BOX-A
|R1-BOX-B-QPP|Employee’s QPP contribution|Element|R1-BOX-B-QPP
|R1-BOX-B-CPP|Employee’s CPP contribution|Element|R1-BOX-B-CPP
|R1-BOX-C|Employee’s EI Premiums|Element|R1-BOX-C
|R1-BOX-D|RPP contributions|Element|R1-BOX-D
|R1-BOX-E|Quebec Income Tax deducted|Element|R1-BOX-E
|R1-BOX-F|Union Dues|Element|R1-BOX-F
|R1-BOX-F-PRT|Union Dues Printed|Not specified|Information only, do not set up this identifier
|R1-BOX-G|QPP Pensionable Earnings|Element|R1-BOX-G
|R1-BOX-G-EXCEPT|QPP Excepted Earnings|Element|R1-BOX-G-EXCEPT
|R1-BOX-G-OTHER|QPP Other Earnings|Element|R1-BOX-G-OTHER
|R1-BOX-G-PRT|QPP Earnings Printed|Not specified|Information only, do not set up this identifier
|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-H|Meals and Accommodation|Element|R1-BOX-H
|R1-BOX-I|Personal Use Motor Vehicle|Element|R1-BOX-I
|R1-BOX-J|Employer Paid Private Health Plan|Element|R1-BOX-J
|R1-BOX-K|Trip to Designated Remote Area|Element|R1-BOX-K
|R1-BOX-L|Other Benefits|Element|R1-BOX-L
|R1-BOX-M|Commissions|Element|R1-BOX-M
|R1-BOX-N|Charitable Donations|Element|R1-BOX-N
|R1-BOX-O|Other Income not in Box A|Element|R1-BOX-O
|R1-BOX-O-CODE|Box O Footnote Code|Not specified|Do not set up this identifier
|R1-BOX-O-RA|Payment by Supplemental Unemployment Benefit Element|Element|Enter your company data
|R1-BOX-O-RB|Scholarship, bursaries, fellowship|Element|Enter your company data
|R1-BOX-O-RC|Research Grants|Element|Enter your company data
|R1-BOX-O-RD|Fees for services rendered|Element|Enter your company data
|R1-BOX-O-RE|Post-doctoral fellowship award|Element|Enter your company data
|R1-BOX-O-RF|Maternity Allowance|Element|Enter your company data
|R1-BOX-O-RG|Benefit under Labour Adjustment Benefits Act|Element|Enter your company data
|R1-BOX-O-RH|Labour Adjustment Benefits|Element|Enter your company data
|R1-BOX-O-RI|Plant Workers Adjustment Program|Element|Enter your company data
|R1-BOX-O-RJ|Retirement Allowance|Element|Enter your company data
|R1-BOX-O-RK|Death Benefits|Element|Enter your company data
|R1-BOX-O-RL|Patronage Dividends|Element|Enter your company data
|R1-BOX-O-RM|Self-Employed Commissions|Element|Enter your company data
|R1-BOX-O-RN|Benefit Paid under Wage Loss Insurance Plan|Element|Enter your company data
|R1-BOX-O-RO|Benefits Received by a Shareholder|Element|Enter your company data
|R1-BOX-O-RP|Benefits Received by a Partner|Element|Enter your company data
|R1-BOX-O-RQ|Retirement Compensation Arrangement|Element|Enter your company data
|R1-BOX-O-RR|Non Resident in Canada|Element|Enter your company data
|R1-BOX-O-RS|Employment Assistance Allowance|Element|Enter your company data
|R1-BOX-O-RT|Indemnities Paid by Employer|Element|Enter your company data
|R1-BOX-O-RU|Amount Paid to Beneficiary under RESP|Element|Enter your company data
|R1-BOX-O-RV|Amount Paid to Subscriber under RESP|Element|Enter your company data
|R1-BOX-O-RW|Action Emploi Program|Element|Enter your company data
|R1-BOX-O-RZ|Miscellaneous|Element|Enter your company data
|R1-BOX-P|Contributions to Multi-Employer Insurance Plan|Element|R1-BOX-P
|R1-BOX-Q|Deferred Salary or Wages|Element|R1-BOX-Q
|R1-BOX-R|Tax Exempt Income Paid to an Indian|Element|R1-BOX-R
|R1-BOX-S|Tips Received|Element|R1-BOX-S
|R1-BOX-T|Tips Allocated|Element|R1-BOX-T
|R1-BOX-U|Phased Retirement|Element|R1-BOX-U
|R1-CHILD-EXP|Child Care Expenses (MESS)|Element|R1-CHILD-EXP
|R1-BOX-56|PPIP Insurable Earnings|Element|R1-BOX-56
|R1-DEDN-FORCE|Deduction for Canadian Force or Police Officers|Element|R1-DEDN-FORCE
|R1-NOTE-01|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-02|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-03|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-04|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-05|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-06|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-07|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-08|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-09|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-10|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-11|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-12|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-13|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-14|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-15|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-16|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-17|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-18|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-19|User Defined Footnote Description|Pay Component|Enter your company data
|R1-NOTE-20|User Defined Footnote Description|Pay Component|Enter your company data
|R1-ALPHA-01|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-02|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-03|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-04|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-05|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-06|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-07|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-08|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-09|User Defined Alpha Footnote Description|Data Base Column|Enter your company data
|R1-ALPHA-10|Stock option 110(1)(d.1)|Data Base Column|Enter your company data
|FILE-TYPE-OF-DATA|Type of Data|Constant|P01 for Releve 1
|FILE-TRAN-NUM|Transmitter number|Constant|Enter ‘NP’ and 6 digits, such as NP001159
|FILE-TYPE-PACKAGE|Type of Package|Constant|Enter your company data
|FILE-TRAN-TYPE|Transmitter type indicator|Constant|Enter your company data
|FILE-SLIP-SOURCE|Source of RL-1 slips used|Constant|Enter your company data
|FILE-TRAN-NAME1|Transmitter Name – line 1|Constant|Enter your company data
|FILE-TRAN-NAME2|Transmitter Name – line 2|Constant|Enter your company data
|FILE-TRAN-ADDR1|Transmitter Address – line 1|Constant|Enter your company data
|FILE-TRAN-ADDR2|Transmitter Address – line 2|Constant|Enter your company data
|FILE-TRAN-CITY|Transmitter City|Constant|Enter your company data
|FILE-TRAN-PROV|Transmitter Province|Constant|Enter your company data
|FILE-TRAN-COUNTRY|Transmitter Country|Constant|Enter your company data
|FILE-TRAN-POSTAL|Transmitter Postal Code|Constant|Enter your company data
|FILE-CONT-NAME|Technical contact name|Constant|Enter your company data
|FILE-CONT-TEL-AREA|Technical contact tel area code|Constant|Enter your company data
|FILE-CONT-TEL|Technical contact telephone|Constant|Enter your company data
|FILE-CONT-TEL-EXT|Technical contact tel extn|Constant|Enter your company data
|FILE-CONT-LANG|Technical contact Language|Constant|Enter your company data
|FILE-CONT-EMAIL|Contact E-mail address|Constant|Enter your company data
|FILE-ACCT-NAME|Accounting contact name|Constant|Enter your company data
|FILE-ACCT-TEL-AREA|Accounting contact tel area code|Constant|Enter your company data
|FILE-ACCT-TEL|Accounting contact telephone|Constant|Enter your company data
|FILE-ACCT-TEL-EXT|Accounting contact tel extn|Constant|Enter your company data
|FILE-ACCT-EMAIL|Accounting E-mail address|Constant|Enter your company data
!!!RPRL1W Selection Criteria
[{InsertPage page='RPRL1W}]
!!!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.\\ \\
The RPRL1W Form Print program prints all information generated based on the GVT Run number. \\
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. \\
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. \\
Users must run RMEX with the RPRL1W Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report. \\
The RPRL1W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled. \\
Users should confirm that the RPRL1W Boxes balance to the RPGRC Summary Report. \\
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. \\ \\
__Employer and 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. \\
When RPRL1W is run, the Print RL-1 Copy field defines if the Employer or Employee Copy is printed.
[Employer Copy|]\\
* On one sheet, the RL-1 information is printed
* The Employer Copy can be sent to the government or to be kept by your organization \\ \\
[Employee Copy|]\\
* On one sheet, 1 RL-1 copy is printed for one employee
* The Employee Copy should be distributed to the Employees \\ \\
__Duplicate Copies__\\
If an employee loses their RL-1 Slip, the employee can request the employer to issue a duplicate copy of their original RL-1 slip to replace the lost or destroyed slips. \\
To issue Duplicate copies:\\
1. Go to the IPGH form for the employee and highlight the form to be duplicated
*Change the Print Stage to 'Duplicate Requested'
*Click Save
*Repeat for all employees who have requested duplicate copies
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. \\
When RPRL1W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended. \\ \\
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.\\ \\
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. \\ \\
__Amended Copies__ \\
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. \\
To issue Amended copies: \\
1. Update the employee’s YTD information through payroll.\\
2. Check the IDFDV set up and revise the Box information, if necessary. \\
3. Go to the IPGH form for the employee. Locate the form to be amended.
*Change the 'Print Stage' to 'Amendment Requested'
*Save
*Repeat this for all employees who requested Amended copies of their forms. \\
4. Run RPYEC with the GVT Form Option set to Amended Forms \\
*__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.
*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:
**Print Stage = Amend, Form not Printed
**File Stage = Amend, File not Created \\
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:
**Print Stage = No Change, Existing Value
**File Stage = Amend File Created \\
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. \\ \\
!!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.
!! RL-1 Slip Print Distribution
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:\\
||Field Identifier||Suggested Field Source||Suggested Variable
|R1-EE-REFER|Constant|1
|R1-EE-DESTIN|Constant|1
|R1-EE-REFER1| |DED.ENTITY_CODE
|R1-EE-REFER2| |EID.PERSON_CODE
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. \\ \\
If the R1-EE-REFER value = 1, the distribution information is printed from:
*The employee’s pay destination, such as Department, if defined
*Concatenates with the values from R1-EE-REFER1 and R1-EE-REFER2
If the R1-EE-DESTIN value = 1, the employee’s pay destination is concatenated to R1-EE-REFER1 \\ \\
__Numbering of RL-1 Slips__\\
Refer to the Quebec publication IN-800-V section 4.4 Numbering of R Slips. \\
The number on each RL-1 Slip must be composed of nine digits, with the ninth digit representing the check digit. \\
The Ministere du Revenu du Quebec assigns each Employer with a beginning number that contains 8 digits. The ninth digit is derived from the 8 digits number using the modulus 7 method. \\
Example:\\
Beginning number: 71997012 \\
Using modulus 7 method to retrieve the remainder number:\\
71997012 / 7 = 10285287 with the remainder 3 \\ \\
Therefore the RL Slip number is:\\
719970123 (71997012 concatenated with the remainder 3) \\ \\
The next RL Slip number is calculated by:\\
* Add 1 to the beginning number to calculate the next number:
**71997012 + 1 = 71997013
**71997013 / 7 = 10285287 with the remainder 4 \\ \\
Therefore the RL Slip number is:
*719970134 (71997013 concatenated with the remainder 4) \\ \\
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. \\
After RPYEC is run, RPYEC displays the last RL-1 Slip number assigned as an exception message on the RPYEC report. \\
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. \\
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. \\
%%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. \\
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. \\
The IPGH Form Number is used by RPGRC to generate:
*The government RL-1 xml file to send to the Quebec government, and
*The _HL.xml file for RPRL1W to print the exact same number on RL-1 form
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. \\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R1-FORM-NUM-BEG|Releve1 Form beginning number|Constant|Enter your company data
Please enter the 8 digit number assigned to you by Ministere du Revenu, such as 71997012. \\ \\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R1-FORM-NUM-LAST|Releve1 Form Last Assigned #|Constant|System Derived
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. \\ \\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R1-FORM-NUM-ORIG|Releve1 Original Form Number|Not Specified|Do not set up this identifier
__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-1 Slip and for the government Amended/Canceled XML file.__ \\ \\
__Exclude EEs__\\
Users can exclude certain employees from Releve1 reporting by setting up the EXCLUDE-EE Identifier on the IDFDV form. \\
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 R1-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
|R1-ER-ADDR1|DLN.ADDRESS_LINE_1
|R1-ER-ADDR2|DLN.ADDRESS_LINE_2
|R1-ER-ADDR3|DLN.LOCALITY
|R1-ER-ADDR4|DSP.STATE_PROVINCE_CODE
|R1-ER-ADDR5|DCO.COUNTRY_CODE
|R1-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
|R1-EE-ADDR1|EPS.ADDRESS_LINE_1
|R1-EE-ADDR2|EPS.ADDRESS_LINE_2
|R1-EE-ADDR3|EPS.LOCALITY
|R1-EE-ADDR4|DSP.STATE_PROVINCE_CODE
|R1-EE-ADDR5|DCO.COUNTRY_CODE
|R1-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. \\ \\
!RL-1 Slip Box O Explanatory Notes
The RL-1 Slip Code (Case O) box defines the appropriate alphabetic code for different types of income. \\ \\
If several codes apply to Box O, then Box O will print RZ, and in the center of RL-1 slip, it will print the Footnote Code and the corresponding income explanatory note, such as “RJ $10000.00, RC $5000.00” \\ \\
The RL-1 Slip will print as much information as possible in the center, depending on the size of each Footnote Code. If there is not enough space in the center of RL-1 Slip to print all Footnote Codes, then subsequent RL-1 Slips will be printed until all Footnote Codes are printed. \\ \\
!RL-1 Slip Footnotes and Messages
Users can set up the following Identifiers to print user defined footnote codes and messages: \\
__For Numeric Field Variables:__
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R1-NOTE-01|User defined footnote description|Pay Component|Enter your company data
|R1-NOTE-02|User defined footnote description|Pay Component|Enter your company data
|R1-NOTE-20|User defined footnote description|Pay Component|Enter your company data
*In the Description field, enter a brief description, up to 30 characters
*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 \\
\\
__For AlphaNumeric Field Variables:__
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R1-ALPHA-01|User defined footnote description|Pay Component|Enter your company data
|R1-ALPHA-02|User defined footnote description|Pay Component|Enter your company data
|R1-ALPHA-10|User defined footnote description|Pay Component|Enter your company data
*In the Description field, enter a brief description, up to 30 characters
*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.\\
If a user wants to print the message only when a Field Variable is defined, the ‘ ’ decode can be used to return for printing. \\
Example: R1-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. \\ \\
!!!Electronic RL-1 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. \\
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. \\
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_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. \\ \\
The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567). \\ \\
!!!RL-1 Slip - Employment and Other Income
__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.\\ \\
__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\\
__Box: Year__ - Pre-printed on RL-1 Slip or from the user defined Calendar Year \\
__Box: Employer’s Name and Address__, derived from the IDFDV form, as below\\
||Seq||Field Identifier||Description||Field Variable
|1000|R1-ER-NAME|Employer Name|DED.ENTITY_NAME
|1220|R1-ER-ADDR2|Employer Address Line 1|MAIL
|1230|R1-ER-ADDR2|Employer Address Line 2|Blank
|1240|R1-ER-ADDR3|Employer City|Blank
|1250|R1-ER-ADDR4|Employer Province|Blank or Constant NAME
|1260|R1-ER-ADDR5|Employer Country|Blank or Constant NAME
|1270|R1-ER-POSTAL|Employer Postal Code|Blank or Constant NAME
|1280|R1-ER-MAG-PROV|Employer Prov for Mag File|Blank
|1290|R1-ER-MAG-CNTRY|Employer Country for Mag File|Blank
*The Reference Text field will guide the user to set up each Address Identifier.
*If the mailing address for the Employer is not defined on IDLN, the primary address on IDLN will be used
*If there was an Address set up prior to 2006, and the word MAIL is defined, then the mailing address will be used, otherwise the primary address will be used.
*If the Country Code is not Canada or USA, then the R1-ER-MAG-PROV Identifier should be set to ZZ – Other. \\ \\
__Box: Employee’s Social Insurance #__, derived from the IDFDV form, as below
||Field Identifier||Field Variable||Suggested Variable
|R1-EE-SIN|Constant|EID.GOVERNMENT_CODE
*Invalid SIN numbers are reported on the RPYEC exception report
*SIN numbers defined as 999 999 999 are invalid
*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.\\
__Box: Employee’s Name__, derived from the IDFDV form, as below
||Field Identifier||Suggested Variable
|R1-EE-NAME1|EID.LAST_NAME
|R1-EE-NAME2|EID.FIRST_NAME
|R1-EE-NAME3|EID.MIDDLE_NAME
\\
__Box: Employee’s Address__, derived from the IDFDV form, as below
||Seq||Field Identifier||Description||Field Variable
|2100|R1-ER-ADDR1|Employee Address Line 1|MAIL
|2110|R1-ER-ADDR2|Employee Address Line 2|Blank
|2120|R1-ER-ADDR3|Employee City|Blank
|2130|R1-ER-ADDR4|Employee Province|Blank or Constant NAME
|2140|R1-ER-ADDR5|Employee Country|Blank or Constant NAME
|2150|R1-ER-POSTAL|Employee Postal Code|Blank or Constant NAME
|2160|R1-ER-MAG-PROV|Employee Prov for Mag File|Blank
|2170|R1-ER-MAG-CNTRY|Employee Country for Mag File|Blank
*The Reference Text field will guide the user to set up each Address Identifier.
*If the mailing address for the employee is not defined on IEPI, the primary address on IEPI will be used.
*If there was an Address set up prior to 2006, and the word MAIL is defined, then the mailing address will be used, otherwise the primary address will be used.
*If the Country Code is not Canada or USA, then the R1-EE-MAG-PROV Identifier should be set to ZZ – Other.\\
__Box: Area below the Employee Information__, derived from the IDFDV form, as below. Print for RL-1 distribution purposes.
||Field Identifier||Suggested Variable
|R1-EE-REFER|1
|R1-EE-REFER1|DED.ENTITY_CODE
|R1-EE-REFER2|EID.PERSON_CODE
If the R1-EE-REFER = 1, then:
*The distribution will be printed below the employee address for distribution purposes. Otherwise, the distribution will not be printed.
*The distribution information is printed from the R1-EE-REFER1 and R1-EE-REFER 2 Identifiers \\ \\
__Box: A__ - Employment Income, derived from the IDFDV form, as below. This is the taxable earnings applicable for Quebec income tax withheld.
||Field Identifier||Suggested Variable
|R1-BOX-A|R1-BOX-A
__Box: B__ - Employee QPP Contributions|Derived from the IDFDV form, as below
||Field Identifier||Suggested Variable
|R1-BOX-B-QPP|R1-BOX-B-QPP
*The Employee’s QPP contribution is also retrieved from the R1-BOX-B-CPP Field Identifier.
* The QPP Employee contribution is not printed on the RL-1 Slip for each employee. It is reported on the RL-1 government file. \\
All of the following Box Information is derived from the IDFDV form, as below
||Box||Title||Field Identifier||Suggested Variable
|C|Employee EI Premiums|R1-BOX-C|R1-BOX-C
|D|Employee RPP Premiums|R1-BOX-D|R1-BOX-D
|E|Quebec Income Tax Withheld|R1-BOX-E|R1-BOX-E
|F|Union Dues|R1-BOX-F|R1-BOX-F
__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 \\ \\
||Field Identifier||Suggested Variable
|R1-BOX-G|R1-BOX-G
|R1-BOX-G-EXCEPT|R1-BOX-G-EXCEPT
|R1-BOX-G-OTHER|R1-BOX-G-OTHER
|R1-BOX-G-PRT|R1-BOX-G-PRT
|R1-BOX-G-PRT-0|R1-BOX-G-PRT-0
* If R1-BOX-G-PRT-0 = 1.00, then Box G is printed with 0.00.
* Otherwise, if R1-BOX-G-PRT-0 is not defined and if the value from R1-BOX-G-PRT is greater than zero, the amount from R1-BOX-G-PRT will be printed, otherwise Box G is blank.\\ \\
__Box G Processing__\\
The R1-BOX-G-EXCEPT value should define the remuneration that is taxable, but not pensionable, such as:
*Remuneration paid to employee for work not covered by QPP
*An amount allocated under an employee trust
*An amount paid by a custodian under an employee benefit plan, etc.
Please see refer to Guide to Filing the RL-1 Slip Box G for details. \\
The R1-BOX-G-OTHER identifier is not currently used. The value should define any other remuneration that is pensionable, but not taxable. \\
Box G QPP Pensionable Earnings are derived from one of the following:
1. If there are no pensionable earnings (Identifier R1-BOX-G = 0), Box G is printed as 0.00\\
2. If pensionable earnings are over the QPP maximum earnings for the year (IPCT form, Tax Rate Code 010101, QPP Annual Maximum Earnings for Quebec), then leave Box G 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. \\
3. If pensionable earnings are the same as the employment income and there is no amount in Box Q and Box U, then leave Box G 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.
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.\\ \\
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\\
If the result of this calculation is zero, then Box G is printed with ‘0’.\\ \\
Example: R1-BOX-G-PRT = 0.00 and R1-BOX-G-PRT-0 = 1.00, then Box G is printed as 0.00\\ \\
Otherwise, if the revised Box G = Box A, Box Q and Box U, then Box G is 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.\\
Otherwise, the Box G amount is printed. \\ \\
All of the following Box Information is derived from the IDFDV form, as below
||Box||Title||Field Identifier||Suggested Variable
|H|QPIP Employee Premium|R1-BOX-H|R1-BOX-H
|I|QPIP Earnings|R1-BOX-I|R1-BOX-I
|J|Employer Paid Private Health Plan|R1-BOX-J|R1-BOX-J
|K|Trip to Designated Remote Area|R1-BOX-K|R1-BOX-K
|L|Other Benefits|R1-BOX-L|R1-BOX-L
|M|Commissions|R1-BOX-M|R1-BOX-M
|N|Charitable Donations and Gifts|R1-BOX-N|R1-BOX-N
|O|Other income not included in Box A|R1-BOX-O|R1-BOX-O
|P|Contributions to multi-employer insurance plan|R1-BOX-P|R1-BOX-P
|Q|Deferred Salary or Wages|R1-BOX-Q|R1-BOX-Q
|R|Tax Exempt Income Paid to an Indian|R1-BOX-R|R1-BOX-R
|S|Tips received|R1-BOX-S|R1-BOX-S
|T|Tips allocated by Employer|R1-BOX-T|R1-BOX-T
|U|Phased Retirement|R1-BOX-U|R1-BOX-U
\\
__Box: O CODE__ (case O), derived from the IDFDV form, as below
||Field Identifier||Suggested Variable
|R1-BOX-O-CODE|R1-BOX-O-CODE
*Derived from the R1-BOX-O-RA to R1-BOX-O-RZ Identifiers. The derived footnote code is stored in R1-BOX-O-CODE to print on RL-1 Form.
*If more than one Identifier has a value greater than zero, then RZ is stored in Identifier R1-BOX-O-CODE
*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
||Field Identifier||Suggested Variable
|R1-BOX-O-RA|R1-BOX-O-RZ
|R1-NOTE-01|R1-NOTE-20
|R1-ALPHA-01|R1-ALPHA-10
*Up to 4 lines of messages can be printed on each RL-1 form
*Line 1 and Line 2 are printed beside the Box O Footnote Code, with up to 30 characters for each message
*Line 3 and Line 4 are concatenated together and will be printed beside the Employee’s name, up to 54 characters
*If there are more than 4 lines to be reported, the extra information is printed as Execution Run Log messages
!!!Magnetic Media - Government XML File
__IDIF – RL-1 Govt XML File Layout__\\
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. \\ \\
Users must run the RPYEC and the RPGRC processes to generate the Magnetic Media file in the government XML file format. Please refer to the Government Reporting Procedures, Sequence section in this manual that describes how the processes should be run. \\ \\
%%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__\\
A validating parser, from any third party tool, will perform the following checks on the government XML file generated by RPGRC:
1. Verify the government XML file is properly created according to the XML syntax rules, such as the file is well formed, no missing xml tags, etc.\\
2. Verify the government XML file conforms to the schema downloaded from the government web site.\\
Validating parser software is NOT provided by High Line. Organizations can use any third party validating parser tool.
High Line uses the XML SPY Home edition tool to validate the RL-1 and Rl-2 xml files.
----
![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