RELEVE 1 PROCESS#

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
  • Generating the Magnetic Media xml file required to electronically submit to the government.

IDFD Form Definition#

IDFD Changes
For 2017-2018 reporting, the IDFD HL$CAN-R1-2017 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. I twill not erase the IDFDV set up of the same Form Code.

IDFD Store Options
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.

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 IdentifierDescirptionSuggested Field SourceSuggested Variable
R1-ER-NAMEEmployer NameData Base ColumnDED.ENTITY_NAME
R1-ER-CAREOFEmployer Name (care of)Data Base ColumnOptional
R1-ER-ADDR1Employer Address Line 1Data Base ColumnDLN.ADDRESS_LINE_1
R1-ER-ADDR2Employer Address Line 2Data Base ColumnDLN.ADDRESS_LINE_2
R1-ER-ADDR3Employer CityData Base ColumnDLN.LOCALITY
R1-ER-ADDR4Employer ProvinceData Base ColumnDSP.STATE_PROVINCE_CODE
R1-ER-ADDR5Employer CountryData Base ColumnDCO.COUNTRY_NAME
R1-ER-POSTALEmployer Postal CodeData Base ColumnDLN.ZIP_POSTAL
R1-ER-MAG-PROVEmployer Prov for Mag FileConstantBlank
R1-ER-MAG-CNTRYEmployer Country for Mag FileConstantBlank
R1-NEQ-NUMBERQuebec Enterprise NEQ #ConstantEnter your company data
R1-EE-NAME1Employee SurnameData Base ColumnEID.LAST_NAME
R1-EE-NAME2Employee First NameData Base ColumnEID.FIRST_NAME
R1-EE-NAME3Employee Middle InitialData Base ColumnEID.MIDDLE_NAME
R1-EE-ADDR1Employee Address Line 1Data Base ColumnEPS.ADDRESS_LINE_1
R1-EE-ADDR2Employee Address Line 2Data Base ColumnEPS.ADDRESS_LINE_2
R1-EE-ADDR3Employee CityData Base ColumnEPS.LOCALITY
R1-EE-ADDR4Employee ProvinceData Base ColumnDSP.STATE_PROVINCE_CODE
R1-EE-ADDR5Employee CountryData Base ColumnDCO.COUNTRY_CODE
R1-EE-POSTALEmployee Postal CodeData Base ColumnEPS.ZIP_POSTAL
R1-EE-MAG-PROVEmployee Prov for Mag FileConstantBlank
R1-EE-MAG-CNTRYEmployee Country for Mag FileConstantBlank
R1-EE-SINSocial Insurance NumberData Base ColumnEID.GOVERNMENT_CODE
R1-EE-REFERPrint DistributionConstantBlank or 1. If 1, print employee distribution
R1-EE-DESTINPrint Pay DestinationConstantBlank or 1. If 1, employee destination is concatenated to employee distribution for printing purposes
R1-EE-REFER1Employee Distribution 1Data Base ColumnPPA.PAYROLL_CODE
R1-EE-REFER2Employee Distribution 2Data Base ColumnEID.PERSON_CODE
R1-FORM-NUM-BEGRL-1 Slip beginning numberConstantEnter 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.

R1-FORM-NUM-LASTRL-1 Slip ending numberConstantSystem 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 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.

EXCLUDE-EEExclude EmployeeData Base ColumnEnter your company data
R1-BOX-AEmployment IncomeElementR1-BOX-A
R1-BOX-B-QPPEmployee’s QPP contributionElementR1-BOX-B-QPP
R1-BOX-B-CPPEmployee’s CPP contributionElementR1-BOX-B-CPP
R1-BOX-CEmployee’s EI PremiumsElementR1-BOX-C
R1-BOX-DRPP contributionsElementR1-BOX-D
R1-BOX-EQuebec Income Tax deductedElementR1-BOX-E
R1-BOX-FUnion DuesElementR1-BOX-F
R1-BOX-F-PRTUnion Dues PrintedNot specifiedInformation only, do not set up this identifier
R1-BOX-GQPP Pensionable EarningsElementR1-BOX-G
R1-BOX-G-EXCEPTQPP Excepted EarningsElementR1-BOX-G-EXCEPT
R1-BOX-G-OTHERQPP Other EarningsElementR1-BOX-G-OTHER
R1-BOX-G-PRTQPP Earnings PrintedNot specifiedInformation only, do not set up this identifier
R1-BOX-G-PRT-0QPP Earnings Printed ZERONot specifiedDo 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-HMeals and AccommodationElementR1-BOX-H
R1-BOX-IPersonal Use Motor VehicleElementR1-BOX-I
R1-BOX-JEmployer Paid Private Health PlanElementR1-BOX-J
R1-BOX-KTrip to Designated Remote AreaElementR1-BOX-K
R1-BOX-LOther BenefitsElementR1-BOX-L
R1-BOX-MCommissionsElementR1-BOX-M
R1-BOX-NCharitable DonationsElementR1-BOX-N
R1-BOX-OOther Income not in Box AElementR1-BOX-O
R1-BOX-O-CODEBox O Footnote CodeNot specifiedDo not set up this identifier
R1-BOX-O-RAPayment by Supplemental Unemployment Benefit ElementElementEnter your company data
R1-BOX-O-RBScholarship, bursaries, fellowshipElementEnter your company data
R1-BOX-O-RCResearch GrantsElementEnter your company data
R1-BOX-O-RDFees for services renderedElementEnter your company data
R1-BOX-O-REPost-doctoral fellowship awardElementEnter your company data
R1-BOX-O-RFMaternity AllowanceElementEnter your company data
R1-BOX-O-RGBenefit under Labour Adjustment Benefits ActElementEnter your company data
R1-BOX-O-RHLabour Adjustment BenefitsElementEnter your company data
R1-BOX-O-RIPlant Workers Adjustment ProgramElementEnter your company data
R1-BOX-O-RJRetirement AllowanceElementEnter your company data
R1-BOX-O-RKDeath BenefitsElementEnter your company data
R1-BOX-O-RLPatronage DividendsElementEnter your company data
R1-BOX-O-RMSelf-Employed CommissionsElementEnter your company data
R1-BOX-O-RNBenefit Paid under Wage Loss Insurance PlanElementEnter your company data
R1-BOX-O-ROBenefits Received by a ShareholderElementEnter your company data
R1-BOX-O-RPBenefits Received by a PartnerElementEnter your company data
R1-BOX-O-RQRetirement Compensation ArrangementElementEnter your company data
R1-BOX-O-RRNon Resident in CanadaElementEnter your company data
R1-BOX-O-RSEmployment Assistance AllowanceElementEnter your company data
R1-BOX-O-RTIndemnities Paid by EmployerElementEnter your company data
R1-BOX-O-RUAmount Paid to Beneficiary under RESPElementEnter your company data
R1-BOX-O-RVAmount Paid to Subscriber under RESPElementEnter your company data
R1-BOX-O-RWAction Emploi ProgramElementEnter your company data
R1-BOX-O-RZMiscellaneousElementEnter your company data
R1-BOX-PContributions to Multi-Employer Insurance PlanElementR1-BOX-P
R1-BOX-QDeferred Salary or WagesElementR1-BOX-Q
R1-BOX-RTax Exempt Income Paid to an IndianElementR1-BOX-R
R1-BOX-STips ReceivedElementR1-BOX-S
R1-BOX-TTips AllocatedElementR1-BOX-T
R1-BOX-UPhased RetirementElementR1-BOX-U
R1-CHILD-EXPChild Care Expenses (MESS)ElementR1-CHILD-EXP
R1-BOX-56PPIP Insurable EarningsElementR1-BOX-56
R1-DEDN-FORCEDeduction for Canadian Force or Police OfficersElementR1-DEDN-FORCE
R1-NOTE-01User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-02User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-03User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-04User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-05User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-06User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-07User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-08User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-09User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-10User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-11User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-12User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-13User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-14User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-15User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-16User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-17User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-18User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-19User Defined Footnote DescriptionPay ComponentEnter your company data
R1-NOTE-20User Defined Footnote DescriptionPay ComponentEnter your company data
R1-ALPHA-01User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-02User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-03User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-04User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-05User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-06User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-07User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-08User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-09User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R1-ALPHA-10Stock option 110(1)(d.1)Data Base ColumnEnter your company data
FILE-TYPE-OF-DATAType of DataConstantP01 for Releve 1
FILE-TRAN-NUMTransmitter numberConstantEnter ‘NP’ and 6 digits, such as NP001159
FILE-TYPE-PACKAGEType of PackageConstantEnter your company data
FILE-TRAN-TYPETransmitter type indicatorConstantEnter your company data
FILE-SLIP-SOURCESource of RL-1 slips usedConstantEnter your company data
FILE-TRAN-NAME1Transmitter Name – line 1ConstantEnter your company data
FILE-TRAN-NAME2Transmitter Name – line 2ConstantEnter your company data
FILE-TRAN-ADDR1Transmitter Address – line 1ConstantEnter your company data
FILE-TRAN-ADDR2Transmitter Address – line 2ConstantEnter your company data
FILE-TRAN-CITYTransmitter CityConstantEnter your company data
FILE-TRAN-PROVTransmitter ProvinceConstantEnter your company data
FILE-TRAN-COUNTRYTransmitter CountryConstantEnter your company data
FILE-TRAN-POSTALTransmitter Postal CodeConstantEnter your company data
FILE-CONT-NAMETechnical contact nameConstantEnter your company data
FILE-CONT-TEL-AREATechnical contact tel area codeConstantEnter your company data
FILE-CONT-TELTechnical contact telephoneConstantEnter your company data
FILE-CONT-TEL-EXTTechnical contact tel extnConstantEnter your company data
FILE-CONT-LANGTechnical contact LanguageConstantEnter your company data
FILE-CONT-EMAILContact E-mail addressConstantEnter your company data
FILE-ACCT-NAMEAccounting contact nameConstantEnter your company data
FILE-ACCT-TEL-AREAAccounting contact tel area codeConstantEnter your company data
FILE-ACCT-TELAccounting contact telephoneConstantEnter your company data
FILE-ACCT-TEL-EXTAccounting contact tel extnConstantEnter your company data
FILE-ACCT-EMAILAccounting E-mail addressConstantEnter your company data

RPRL1 Selection Criteria#

RELEVE 1 FORMS - Oracle Report Process#

The RPRL1 process will print the Releve 1 forms. This process is used for Oracle Reports only. Please refer to RPRL1W for Windward Report Parameters.

RPRL1 Report Parameters - *Oracle Reports Only*

FieldDescription
Print RL1 CopyMandatory. Defines if the Employer or Employee copy will be printed. Options are:
* 01:Employer copy. Prints 3 employees on 1 page. Use as the Employer Copy to send to the government or keep for reference.
* 02: Employee copy. Print 1 employee 3 times on 1 page. Use as the Employee Copy to distribute to the employees.
Print RL1 Copy lexicon available.
Exception LevelDefines the level of detail on the exception report. Users should always run with this field set to 'Exceptions Only', unless required for tracing.
Optional. Trace Level lexicon available.
Duplicate/AmendedDefines if this is a 'Duplicate' or 'Amended' run.//Optional. Text
Test Form Set-upAllows users to test their printer set up prior to running the actual RL-1 slips. High Line recommends all users should run RPRL1 with this toggle set to YES to print a sample on the actual RL-1 slip to confirm the correct margin page set up. Users should do a printer set up test each time a different printer is used.
Optional. Yes or No lexicon available
Show RL1 FormAllows users to print RL-1 slips with the form setup lines. When running RPRL1 for the actual form printing, DO NOT set this toggle to Yes.
When set to YES, RPRL1 will print the RL-1 Form image on the background for users to view the RL-1 information.

The downloaded form is for viewing and testing purposes only and should not be used to submit to the government or distributed to the employees. Users must print the Releve1 on the pre-printed forms as they contain the correct wording printed on the back of the form. Optional. Yes or No lexicon available
Trial Print OnlyWhen this toggle is set to YES, users can print RL-1 slips for verification.
When set to NO (non-trial mode), RPRL1 updates the Gvt Headers Govt Print Stage of the run.
Directory NameEnter a valid Directory name. Must be the same as RPGRC run.
Optional. Text
XML File NameEnter the name of the XML File generated from RPGRC with the _HL.xml file extension.
Optional. Text
Adjust Top MarginDefines the adjustment spacing for the Top Margin when printing the RL-1 slip.
Optional. Adjust Top Margin, Lexicon available
Between FormDefines the adjustment spacing between RL-1 slips that are printed on the same page.
Optional. Between Form, Lexicon available
Show FrameAllows users to print RL-1 slips with the form setup lines. When running RPRL1 for the actual form printing, DO NOT set this toggle to YES.
Optional. Yes or No, Lexicon available
When set to YES, the frame will be displayed on the report.



RPRL1 Report Filters

FieldDescription
Person CodePerson Code of the employee being tested with. Optional, Multiple selection and LOV available.

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.

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.

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.

The RPRL1 form print program prints all information generated by the RPGRC_HL.xml file according to the defined criteria.

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.

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.

Users must run RMEX with the RPRL1 Mex ID to obtain the Summary and Grand totals to balance to the RPGRC Summary report.

The RPRL1 Summary and Grand Totals are accumulated for the Boxes shown on the Slip, the Footnote Codes are not totaled.

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.

Employer and Employee Copy
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.

When RPRL1 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 for 3 different employees
  • The Employer Copy can be sent to the government or to be kept by your organization

Employee Copy

  • On one sheet, 3 RL-1 copies are 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: 11 – Duplicate requested
  • Click Save
  • Repeat for all employees who have requested duplicate copies

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 RPRL1 is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended.

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.

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.

Amended Copies
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.

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 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.
  • 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 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:
    • Print Stage = No Change, Existing Value
    • File Stage = Amend File Created
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.

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.

RL-1 Slip Print Distribution#

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:
Field IdentifierSuggested Field SourceSuggested Variable
R1-EE-REFERConstant1
R1-EE-DESTINConstant1
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, depending on the envelope.

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 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 to print the RL-1 Forms.

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.

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 RPRL1 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 IdentifierDescriptionSuggested Field SourceSuggested Variable
R1-FORM-NUM-BEGReleve1 Form beginning numberConstantEnter your company data
Please enter the 8 digit number assigned to you by Ministere du Revenu, such as 71997012.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
R1-FORM-NUM-LASTReleve1 Form Last Assigned #ConstantSystem Derived
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.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
R1-FORM-NUM-ORIGReleve1 Original Form NumberNot SpecifiedDo 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 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 IdentifierSuggested Field Variable
R1-ER-ADDR1DLN.ADDRESS_LINE_1
R1-ER-ADDR2DLN.ADDRESS_LINE_2
R1-ER-ADDR3DLN.LOCALITY
R1-ER-ADDR4DSP.STATE_PROVINCE_CODE
R1-ER-ADDR5DCO.COUNTRY_CODE
R1-ER-POSTALDLN.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 IdentifierSuggested Field Variable
R1-EE-ADDR1EPS.ADDRESS_LINE_1
R1-EE-ADDR2EPS.ADDRESS_LINE_2
R1-EE-ADDR3EPS.LOCALITY
R1-EE-ADDR4DSP.STATE_PROVINCE_CODE
R1-EE-ADDR5DCO.COUNTRY_CODE
R1-EE-POSTALEPS.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 IdentifierDescriptionSuggested Field SourceSuggested Variable
R1-NOTE-01User defined footnote descriptionPay ComponentEnter your company data
R1-NOTE-02User defined footnote descriptionPay ComponentEnter your company data
R1-NOTE-20User defined footnote descriptionPay ComponentEnter 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 Numeric Field Variables:

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
R1-ALPHA-01User defined footnote descriptionPay ComponentEnter your company data
R1-ALPHA-02User defined footnote descriptionPay ComponentEnter your company data
R1-ALPHA-10User defined footnote descriptionPay ComponentEnter 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.

Printing RPRL1
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the "Run Options" tab.

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.

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 or Releve 2 forms, using either the consent form WEPT4 or IEPT4, a paper copy is NOT printed during the RPT4 T4 printing process.

Organizations can also manage the consent for employees to receive electronic Releve 1 using the Maintain Employee T4 Consent form (IEPT4).

Organizations can control the years that Releve1 forms are available for employees to print, by setting a Preference on the IMST form, as below.

Setup/Implementation
Users must set up the EE_T4_GVT_RUN Preference with the values of the GVT Run Numbers that contain the information for the employee’s T4s (from the RPYEC run) on the IMST form, Preference tab.

The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567).

RL-1 Slip - Employment and Other Income#

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 - 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

SeqField IdentifierDescriptionField Variable
1000R1-ER-NAMEEmployer NameDED.ENTITY_NAME
1220R1-ER-ADDR2Employer Address Line 1MAIL
1230R1-ER-ADDR2Employer Address Line 2Blank
1240R1-ER-ADDR3Employer CityBlank
1250R1-ER-ADDR4Employer ProvinceBlank or Constant NAME
1260R1-ER-ADDR5Employer CountryBlank or Constant NAME
1270R1-ER-POSTALEmployer Postal CodeBlank or Constant NAME
1280R1-ER-MAG-PROVEmployer Prov for Mag FileBlank
1290R1-ER-MAG-CNTRYEmployer Country for Mag FileBlank
  • 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 IdentifierField VariableSuggested Variable
R1-EE-SINConstantEID.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 IdentifierSuggested Variable
R1-EE-NAME1EID.LAST_NAME
R1-EE-NAME2EID.FIRST_NAME
R1-EE-NAME3EID.MIDDLE_NAME


Box: Employee’s Address, derived from the IDFDV form, as below

SeqField IdentifierDescriptionField Variable
2100R1-ER-ADDR1Employee Address Line 1MAIL
2110R1-ER-ADDR2Employee Address Line 2Blank
2120R1-ER-ADDR3Employee CityBlank
2130R1-ER-ADDR4Employee ProvinceBlank or Constant NAME
2140R1-ER-ADDR5Employee CountryBlank or Constant NAME
2150R1-ER-POSTALEmployee Postal CodeBlank or Constant NAME
2160R1-ER-MAG-PROVEmployee Prov for Mag FileBlank
2170R1-ER-MAG-CNTRYEmployee Country for Mag FileBlank
  • 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 IdentifierSuggested Variable
R1-EE-REFER1
R1-EE-REFER1DED.ENTITY_CODE
R1-EE-REFER2EID.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 IdentifierSuggested Variable
R1-BOX-AR1-BOX-A


Box: B - Employee QPP Contributions|Derived from the IDFDV form, as below

Field IdentifierSuggested Variable
R1-BOX-B-QPPR1-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

BoxTitleField IdentifierSuggested Variable
CEmployee EI PremiumsR1-BOX-CR1-BOX-C
DEmployee RPP PremiumsR1-BOX-DR1-BOX-D
EQuebec Income Tax WithheldR1-BOX-ER1-BOX-E
FUnion DuesR1-BOX-FR1-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 IdentifierSuggested Variable
R1-BOX-GR1-BOX-G
R1-BOX-G-EXCEPTR1-BOX-G-EXCEPT
R1-BOX-G-OTHERR1-BOX-G-OTHER
R1-BOX-G-PRTR1-BOX-G-PRT
R1-BOX-G-PRT-0R1-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, RPRL1 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, RPRL1 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, RPRL1 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

BoxTitleField IdentifierSuggested Variable
HMeals and AccommodationR1-BOX-HR1-BOX-H
IPersonal Use Motor VehicleR1-BOX-IR1-BOX-I
JEmployer Paid Private Health PlanR1-BOX-JR1-BOX-J
KTrip to Designated Remote AreaR1-BOX-KR1-BOX-K
LOther BenefitsR1-BOX-LR1-BOX-L
MCommissionsR1-BOX-MR1-BOX-M
NCharitable Donations and GiftsR1-BOX-NR1-BOX-N
OOther income not included in Box AR1-BOX-OR1-BOX-O
PContributions to multi-employer insurance planR1-BOX-PR1-BOX-P
QDeferred Salary or WagesR1-BOX-QR1-BOX-Q
RTax Exempt Income Paid to an IndianR1-BOX-RR1-BOX-R
STips receivedR1-BOX-SR1-BOX-S
TTips allocated by EmployerR1-BOX-TR1-BOX-T
UPhased RetirementR1-BOX-UR1-BOX-U



Box: O CODE (case O), derived from the IDFDV form, as below

Field IdentifierSuggested Variable
R1-BOX-O-CODER1-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 IdentifierSuggested Variable
R1-BOX-O-RAR1-BOX-O-RZ
R1-NOTE-01R1-NOTE-20
R1-ALPHA-01R1-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 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.

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.

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.