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

IDFD Form Definition#

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

This is the beginning number for the RL-2 Slips, using the modulus 7 method, to derive the ninth digit. The RL-2 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-2 Slips. Users only need to enter the first 8 digits in this field, from the previous RPYEC run.

Field IdentifierDescirptionSuggested Field SourceSuggested Variable
R2-FORM-NUM-LASTRL-2 Slip ending numberConstantSystem Derived

After each RPYEC run, this identifier is updated to store the last number assigned according to the R2-FORM-NUM-BEG Identifier. After users run the RPRL2/RPRL2W program to print the actual RL-2 Slips, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so the next RPYEC run can begin with the correct new number.

Field IdentifierDescirptionSuggested Field SourceSuggested Variable
EXCLUDE-EEExclude EmployeeData Base ColumnEnter your company data
R2-BOX-AEmployment IncomeElementR2-BOX-A
R2-BOX-B-QPPEmployee’s QPP contributionElementR2-BOX-B-QPP
R2-BOX-B-CPPEmployee’s CPP contributionElementR2-BOX-B-CPP
R2-BOX-CEmployee’s EI PremiumsElementR2-BOX-C
R2-BOX-DRPP contributionsElementR2-BOX-D
R2-BOX-EQuebec Income Tax deductedElementR2-BOX-E
R2-BOX-FUnion DuesElementR2-BOX-F
R2-BOX-F-PRTUnion Dues PrintedNot specifiedInformation only, do not set up this identifier
R2-BOX-GQPP Pensionable EarningsElementR2-BOX-G
R2-BOX-G-EXCEPTQPP Excepted EarningsElementR2-BOX-G-EXCEPT
R2-BOX-G-OTHERQPP Other EarningsElementR2-BOX-G-OTHER
R2-BOX-G-PRTQPP Earnings PrintedNot specifiedInformation only, do not set up this identifier
R2-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.
R2-BOX-HMeals and AccommodationElementR2-BOX-H
R2-BOX-IPersonal Use Motor VehicleElementR2-BOX-I
R2-BOX-JEmployer Paid Private Health PlanElementR2-BOX-J
R2-BOX-KTrip to Designated Remote AreaElementR2-BOX-K
R2-BOX-LOther BenefitsElementR2-BOX-L
R2-BOX-MCommissionsElementR2-BOX-M
R2-BOX-NCharitable DonationsElementR2-BOX-N
R2-BOX-OOther Income not in Box AElementR2-BOX-O
R2-BOX-O-CODEBox O Footnote CodeNot specifiedDo not set up this identifier
R2-BOX-O-RAPayment by Supplemental Unemployment Benefit ElementElementEnter your company data
R2-BOX-O-RBScholarship, bursaries, fellowshipElementEnter your company data
R2-BOX-O-RCResearch GrantsElementEnter your company data
R2-BOX-O-RDFees for services renderedElementEnter your company data
R2-BOX-O-REPost-doctoral fellowship awardElementEnter your company data
R2-BOX-O-RFMaternity AllowanceElementEnter your company data
R2-BOX-O-RGBenefit under Labour Adjustment Benefits ActElementEnter your company data
R2-BOX-O-RHLabour Adjustment BenefitsElementEnter your company data
R2-BOX-O-RIPlant Workers Adjustment ProgramElementEnter your company data
R2-BOX-O-RJRetirement AllowanceElementEnter your company data
R2-BOX-O-RKDeath BenefitsElementEnter your company data
R2-BOX-O-RLPatronage DividendsElementEnter your company data
R2-BOX-O-RMSelf-Employed CommissionsElementEnter your company data
R2-BOX-O-RNBenefit Paid under Wage Loss Insurance PlanElementEnter your company data
R2-BOX-O-ROBenefits Received by a ShareholderElementEnter your company data
R2-BOX-O-RPBenefits Received by a PartnerElementEnter your company data
R2-BOX-O-RQRetirement Compensation ArrangementElementEnter your company data
R2-BOX-O-RRNon Resident in CanadaElementEnter your company data
R2-BOX-O-RSEmployment Assistance AllowanceElementEnter your company data
R2-BOX-O-RTIndemnities Paid by EmployerElementEnter your company data
R2-BOX-O-RUAmount Paid to Beneficiary under RESPElementEnter your company data
R2-BOX-O-RVAmount Paid to Subscriber under RESPElementEnter your company data
R2-BOX-O-RWAction Emploi ProgramElementEnter your company data
R2-BOX-O-RZMiscellaneousElementEnter your company data
R2-BOX-PContributions to Multi-Employer Insurance PlanElementR2-BOX-P
R2-BOX-QDeferred Salary or WagesElementR2-BOX-Q
R2-BOX-RTax Exempt Income Paid to an IndianElementR2-BOX-R
R2-BOX-STips ReceivedElementR2-BOX-S
R2-BOX-TTips AllocatedElementR2-BOX-T
R2-BOX-UPhased RetirementElementR2-BOX-U
R2-CHILD-EXPChild Care Expenses (MESS)ElementR2-CHILD-EXP
R2-BOX-56PPIP Insurable EarningsElementR2-BOX-56
R2-DEDN-FORCEDeduction for Canadian Force or Police OfficersElementR2-DEDN-FORCE
R2-NOTE-01User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-02User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-03User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-04User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-05User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-06User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-07User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-08User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-09User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-10User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-11User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-12User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-13User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-14User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-15User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-16User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-17User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-18User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-19User Defined Footnote DescriptionPay ComponentEnter your company data
R2-NOTE-20User Defined Footnote DescriptionPay ComponentEnter your company data
R2-ALPHA-01User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-02User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-03User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-04User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-05User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-06User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-07User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-08User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-ALPHA-09User Defined Alpha Footnote DescriptionData Base ColumnEnter your company data
R2-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-2 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-ADDR2Transmitter 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-LANGTechnical contact LanguageConstantEnter your company data
FILE-ACCT-EMAILAccounting E-mail addressConstantEnter your company data

RPRL2W Selection Criteria#

RELEVE 2 FORMS #

The RPRL2W process prints the Releve 2 forms.

RPRL2W Report Parameters

FieldDescription
Print RL2 CopyMandatory. Defines if the Employer or Employee copy will be printed. Options are:
* 01:Employer copy. Prints 1 employee on 1 page. Use as the Employer Copy to send to the government or keep for reference.
* 02: Employee copy. Print 1 employee on 1 page. Use as the Employee Copy to distribute to the employees.
Print RL2 Copy lexicon available.
Trial Print OnlyWhen this toggle is set to YES, users can print RL-2 slips for verification.
When set to NO (non-trial mode), RPRL2W updates the Gvt Headers Govt Print Stage of the run.
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

RPRL2W Report Filters
FieldDescription
PersonPerson Code of the employee being tested with. Optional. Multiple selection and LOV available.
GVT RunMandatory.
Defines the GVT Run number to extract the data from and produce the RL-2 slips.

RPRL2W Slip Print Processing#

The RPRL2W Form Print program format is based on the current Government published RL-2.L Form. The IN-412-V RL Requirements for Computer-Generated Forms document is included in the year end software.

The RPRL2W 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-2 Slip is printed with footnote codes until all footnotes codes are printed.

The RPRL2W program generates Summary Totals by each Business Number. At the end of the RPRL2W run, a grand total is generated for all Business Numbers.

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

The RPRL2W Summary and Grand Totals are accumulated for the Boxes shown on the Slip. The footnote codes are not totaled.

Users should confirm that the RPRL2W Boxes balance to the RPGRC Summary Report.

If the RPRL2W process cannot select any information from the xml file to print, users must run RMEX with the RPRL2/RPRL2W Mex ID to review any error or exception messages to identify the problem.

Employer and Employee Copy
Users are required to print the Employer and Employee Copy of the RL-2. Users must run RPRL2W twice; once to print the Employer Copy and once to print the Employee Copy.

When RPRL2W is run, the Print RL-2 Copy field defines if the Employer or Employee Copy is printed.

Employer Copy

  • On one sheet, the RL-2 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-2 copy is printed for one employee
  • The Employee Copy should be distributed to the Employees

Duplicate Copies
If an employee loses their RL-2 Slip, the employee can request the employer to issue a duplicate copy of their original RL-2 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 RPRL2W with the new GVT Run number, RPRL2W will automatically print the DUPLICATE COPY or AMENDED on the RL-2 Slip depending on the GVT Run option of the RPRL2W run.

When RPRL2W is run in non-trial mode, the GVT Header stage will be updated to Duplicate or Amended.

2. Run RPRL2W with the 'Gvt Form Option' set to 'Duplicate Forms' and the 'Trial Print Only' set to 'Yes'

  • RPGRC retrieves all GVT Headers with the Print Stage defined as 'Duplicate Requested'.
  • 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 RPRL2W to print the duplicate forms

  • Run the Form Print RPRL2W 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'
  • Users can re-run the Form Print program for the Employee Copy or the Employer Copy. 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-2 slip and needs to revise the Box information, users may need to either correct the employee amounts or modify the IDFDV set up, then re-run the RPGRC and RPRL2W processes. This produces the Amended RL-2 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 RPRL2/RPRL2W 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 RPRL2W to print the Amended forms.

  • When the user is running RPRL2W with the new GVT Run number) RPRL2/RPRL2W will automatically print the word DUPLICATE COPY or AMENDED on the RL-2 form, depending on the GVT Run option of the RPGRC run.
  • If other wording is required to print on the RL-2 slip, in the Duplicate/Amended parameter, users can enter the text for RPRL2W, such as CANCEL COPY or ORIGINAL COPY.
  • At the end of the RPRL2W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage.

RL-2 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 2.
3. The Provincial Government Registration for Quebec.

  • RL-2 slips are printed in alphabetical order by the employee’s Surname, First Name.
  • The font size for printing RL-2 slips is the standard 10 characters per inch font size.
  • Negative (credit) amounts are never allowed for RL-2 reporting. If negative amounts are encountered, an exception message is displayed, 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-2 Slip, the Box is left as Blank.
  • Users can sort inactive and active employees so inactive employees are printed separately for mailing purposes.
  • If the Employment Status is A (Active) then the Employee is considered Active, otherwise the employee is considered Inactive.
  • When RPRL2/RPRL2W is run, RL-2 Grand Totals are generated for all RL-2 Slips as Execution Run Log Exception messages to balance to RPYEC summary report.
  • Users MUST run the RMEX report for the Mex ID from the RPRL2W run to print the RL-2 Grand Totals to verify all records are printed.

RL-2 Slip Print Distribution#

On the RL-2 Slip, users can print the user defined distribution information for users to distribute the RL-2 Slips to the employees. Users must set up the following Identifiers, derived from the IDFDV form:
Field IdentifierSuggested Field SourceSuggested Variable
R2-EE-REFERConstant1
R2-EE-DESTINConstant1
R2-EE-REFER2 DED.ENTITY_CODE
R2-EE-REFER2 EID.PERSON_CODE

If the R2-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 R2-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 R2-EE-REFER2 and R2-EE-REFER2

If the R2-EE-DESTIN value = 1, the employee’s pay destination is concatenated to R2-EE-REFER2

Numbering of RL-2 Slips#

Refer to the Quebec publication IN-800-V section 4.4 Numbering of R Slips.

The number on each RL-2 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, R2-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-2 Slip number assigned as an exception message on the RPYEC report.

Users need to verify all RL-2 box information on the RPYEC summary report. If the RL-2 Summary report is incorrect, users can re-run RPYEC as many times as required without changing the R2-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 RPRL2/RPRL2W to print the RL-2 Forms.

After the RPRL2W program is run, users must manually go into the IDFDV form and update the R2-FORM-NUM-BEG with the last Form Number assigned + 1 for the next RPYEC RL-2 run.

For each RPYEC run, users must ensure that the R2-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-2 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-2 for the employees, the system derives the RL-2 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-2 xml file to send to the Quebec government,

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 R2-FORM-NUM-BEG is updated correctly with the highest number.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
R2-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
R2-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 R2-FORM-NUM-BEG Identifier. After RPRL2/RPRL2W is run to print the actual RL-2 Slip, users must manually add 1 to this number and then update the R2-FORM-NUM-BEG Identifier so that the next RPYEC run can begin with the correct new number.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
R2-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-2 Slip and for the government Amended/Canceled XML file.

RL-2 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
R2-NOTE-01User defined footnote descriptionPay ComponentEnter your company data
R2-NOTE-02User defined footnote descriptionPay ComponentEnter your company data
R2-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-2 Slip

For AlphaNumeric Field Variables:

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

RL-2 Slip - Retirement and Annuity Income#

RL-2 Slip - 2019 Format#

Users should read the following Form Descriptions and refer to 2019 Guide to Filing the RL-2 Slip RL-2.G-V prior to setting up IDFDV form.
The Ministere du Revenu du Quebec web site is: http://www.revenu.gouv.qc.ca

RL-2 Slip - Box Descriptions#

BoxNumber on RL-2 slip (Top right corner)Derived from the IDFDV form, as below. Please refer to the section Numbering of RL-2 Slip for full details.
Field IdentifierR2-FORM-NUM-BEG
BoxYearPre-printed on RL-2 Slip or from the user defined Calendar Year
BoxCode du releveSystem derived.
If printing an Amended Form define as 1, otherwise define as 0 for Original or Duplicate Forms.
BoxProvenance des revenusDerived from the IDFDV form, as below

Field IdentifierField VariableSuggested Variable
R2-RELEVE-CODE1ConstantFERR-A

Box: Employer’s Name and Address, derived from the IDFDV form, as below

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

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

SeqField IdentifierDescriptionField Variable
2100R2-ER-ADDR2Employee Address Line 1MAIL
2110R2-ER-ADDR2Employee Address Line 2Blank
2120R2-ER-ADDR3Employee CityBlank
2130R2-ER-ADDR4Employee ProvinceBlank or Constant NAME
2140R2-ER-ADDR5Employee CountryBlank or Constant NAME
2150R2-ER-POSTALEmployee Postal CodeBlank or Constant NAME
2160R2-ER-MAG-PROVEmployee Prov for Mag FileBlank
2170R2-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 R2-EE-MAG-PROV Identifier should be set to ZZ – Other.
All of the following Box Information is derived from the IDFDV form, as below

BoxTitleField IdentifierField VariableSuggested Variable
APayments from Pension PlanR2-BOX-AElementR2-BOX-A
BPayments from RRSP, RRIF, DPSP, PRPP, VRSPR2-BOX-BElementR2-BOX-B
COther PaymentsR2-BOX-CElementR2-BOX-C
DRefund of RRSP PremiumsR2-BOX-DElementR2-BOX-D
EDeath BenefitR2-BOX-EElementR2-BOX-E
FRefund of unused RRSP ContributionsR2-BOX-FElementR2-BOX-F
GTaxable Amount of Revocated Pension PlanR2-BOX-GElementR2-BOX-G
HOther Income (RRSP, RRIF)R2-BOX-HElementR2-BOX-H
IDeduction Amount (RRSP, RRIF)R2-BOX-IElementR2-BOX-I
JQuebec Income Tax WithheldR2-BOX-JElementR2-BOX-J
KDeath IncomeR2-BOX-KElementR2-BOX-K
LWithdrawal under LLPR2-BOX-LElementR2-BOX-L
MTax Paid AmountsR2-BOX-MElementR2-BOX-M
NSIN of Contributor’s SpouseR2-BOX-NElementR2-BOX-N
OWithdrawal under HBPR2-BOX-OElementR2-BOX-O

Box: Centre of RL Slip. Slip Footnote Information. Derived from the IDFDV form, as below

Field IdentifierSuggested Variable
R2-NOTE-01R2-NOTE-20
R2-ALPHA-01R2-ALPHA-10
  • Up to 2 lines of messages can be printed on each RL-2 slip
  • 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#

XML Layout#

IDIF – RL-2 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_R2_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-2 and RL-2 xml files.


Notes#

Click to create a new notes page