This page (revision-70) was last changed on 19-Oct-2022 20:29 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by kparrott

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
70 19-Oct-2022 20:29 46 KB Karen Parrott to previous
69 26-Nov-2021 10:22 47 KB Karen Parrott to previous | to last
68 26-Nov-2021 10:22 46 KB Karen Parrott to previous | to last
67 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
66 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
65 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
64 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
63 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
62 26-Nov-2021 10:22 45 KB kparrott to previous | to last
61 26-Nov-2021 10:22 45 KB kparrott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 29 changed one line
#* IDFD - Set up Form Code and Government File Definition
#* IDFD - Set up the Form Code and Government File Definition
At line 31 changed 2 lines
#* The information on this form is provided by High Line using a script. Users only need to execute the script to load the most current information
#* IDFDV - Users must set up the Form and File Definition with user information
#* The information on this form is provided by High Line using a script. Users only need to execute the script to load the most current information.
#* IDFDV - Users must set up the Form and File Definition with your user information
At line 35 changed 4 lines
#* The information on this form is provided by High Line using a script. Users only need to execute the script to load the most current information
#* RDIF - Print the government Magnetic Media file layout from IDIF form
#* RPYEC - means ‘Report Payroll Year End Canada’
#* Extracts information from YTD according to FORM CODE from IDFDV
#* The information on this form is provided by High Line using a script. Users only need to execute the script to load the most current information.
#* RDIF - Print the government Magnetic Media file layout from the [IDIF] form
#* RPYEC - Stands for ‘Report Payroll Year End Canada’
#* Extracts information from YTD according to the FORM CODE from IDFDV
At line 42 changed 5 lines
#* Stores results by GVT Run Number for each employee in Government Reporting tables in the database
# IPGR - Form inquiry by GVT Run Number after the RPYEC process is run
# IPGH - Form inquiry by GVT Header inquiry after the RPYEC process is run for an employee
#* Users can change the Print Stage to request a ‘Duplicate Copy’ or ‘Amended Copy’
#* RPGRC - means ‘Report Payroll Government Reporting Canada’
#* Stores results by GVT Run Number for each employee in the Government Reporting tables in the database
# IPGR - View data by GVT Run Number after the RPYEC process is run
# IPGH - View data by GVT Header after the RPYEC process is run for an employee
#* Users can change the Print Stage to request a ‘Duplicate' or ‘Amended Copy’
#* RPGRC - Stands for ‘Report Payroll Government Reporting Canada’
At line 51 changed 5 lines
#* Check the exception messages from the Summary Report and correct exceptions
#* Generates the High Line XML file to feed into the Form print program RPT4, RPT4A, RPRL1 etc to print T4, T4A or Releve Forms by employee
# Form Print - RPT4/RPT4A/RPRL1 etc. to print government forms for the employee
#* Reads the XML file generated from the RPGRC process to print on Government Forms
#* Prints the Employee Copy or Employer Copy on Government Forms
#* Check the exception messages from the Summary Report and correct any exceptions
#* Generates the High Line XML file to feed into the Form print programs RPT4, RPT4A, RPRL1 etc to print T4, T4A or Releve Forms by employee
# Form Print - RPT4, RPT4A, RPRL1 etc. to print government forms for the employee
#* Reads the XML file generated from the RPGRC process to print on government forms
#* Prints the Employee or Employer Copy on government forms
At line 57 changed one line
# RMEX - Reads the Execution Run Log from the Form Print program RPT4/RPT4A/RPRL1
# RMEX - Reads the Execution Run Log from the Form Print programs RPT4, RPT4A, RPRL1
At line 59 changed one line
# UPGRUNDO - Users can undo by GVT Run number by employee
# UPGRUNDO - Allows users can undo by GVT Run number by employee
At line 66 added one line
The IDFD form provides on-line help and updates to the T4 definitions. This form defines the default values for users to enter in the IDFDV form.
At line 68 added one line
High Line provides seed data scripts to our clients with the Year End software release to load in the IDFD Form Code SEED_IDFD_HL$CAN_T4_YYYY.sql.
At line 68 changed one line
* Seed data scripts are delivered to clients with the year end software release used to load in the IDFD form code definition SEED_IDFD_HL$CAN_T4_YYYY.sql.
* It is not necessary to maintain this form, unless instructed to do so by High Line.
At line 70 changed one line
* When loading the year end software, the [IDFD] definition will be automatically be loaded. Users are not allowed to change the IDFD definitions.
* This seed data script is a re-runable script, it will not erase the IDFDV set up of the same Form Code.
At line 72 changed one line
* After IDFD is loaded, users must set up the company information for this form definition on the [IDFDV] screen.
!!IDFDV Form Definition
At line 74 changed one line
* Users can copy the IDFDV Variable definition from the last year to the current year. Please read [PR_CAN_Govt_Reporting_2017_eP.doc] section ['Copy Last Year's Definition to Current Year']
!IDFDV - Form Code HL$CAN-T4- YYYY (where YYYY is the current reporting year)
After the HL$CAN-T4- YYYY has been loaded, users can copy the 'IDFDV Variable' definition from last year to the current year by using the "Copy" button on the IDFDV form as follows:
# On the IDFDV form, select last year's Form Code
# Press the "Copy Form Definition" button
# The Copying dialog box is displayed. enter the current year Form Code
# Set the "Copy Definition with Variables" toggles to ON. This will copy the variables set up from the previous year to the current year for the same Field Identifier name.
At line 76 changed one line
* This seed data script is a re-runable script, it will not erase the IDFDV set up of the same Form Code
T4 Form Definition Variables
Use the Variable Definition (IDFDV) form to enter the variable data needed to complete the printing of T4’s. \\
At line 78 changed one line
!!IDFDV Form Definition
Users should only work with the 'Field Source' and 'Field Variable' columns. The Derivation Expression field can be used by __advanced__ users or under the guidance of High Line. In this form, users define where, in their particular set up, each required field of data is to be retrieved from.
At line 80 changed 2 lines
!IDFDV - Form Code HL$CAN-T4- YYYY (where YYYY is the current reporting year)
* Users must set up the company information for this form definition on the [IDFDV] form.
Example: Users can reference pay components, elements, database items, etc. For more information regarding the possible sources, refer the Field Descriptions table below. \\
At line 83 changed one line
!IDFDV - Form Variables
Please refer to Revenue Canada for a clearer and more in depth description of the appropriate method to complete your forms. Users should read the following FORM DESCRIPTIONS and refer to ‘Employer’s Guide – Filing T4 Slip and Summary 2017 (RC4120)’ prior to setting up IDFDV form.
At line 85 changed one line
;IDFD FORM:HL$CAN-T4-CCYY - supplied by system
For more information on this process, please refer to the Canadian 2017 YE Training Manual.
!HL$CAN-T4-YYYY Form Variables
;IDFD FORM:HL$CAN-T4-YYYY - supplied by system
At line 129 removed one line
At line 169 removed one line
At line 234 added 46 lines
!Special Notes for T4 Boxes
__Exclude EEs__
Users can exclude certain employees from T4 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 = Election Worker or Self Employed, then:\\
* For the EXCLUDE-EE Identifier, set up the following:
** Field variable = EASD.ASSIGNMENT_TITLE
** Derivation Expression = decode(~,'Election Worker','Y',‘Self Employed’,'Y','N')
If a user has a complex situation to exclude an employee, a statistic can be used to indicate the employee is excluded. \\ \\
Example: An employee is excluded when they work in certain groups or with certain hours. Users can keep track of this by using a STAT CODE. If an employee is to be excluded, then set the STAT CODE value to 1.00.
Then on IDFDV set up the following for the EXCLUDE-EE Identifier
* Field Source = Statistics
* Field variable = the STAT CODE that is used to exclude employee
* Derivation Expression = decode(~,1,'Y','N')
__Employee Primary Address and Mailing Address__
If users want to use the employee Primary Address for reporting, the Identifiers 2100 – 2170 do not need to be set up. Leave these Identifiers blank and the system will use the Primary Address as the default. \\ \\
If users want to use the employee "Mailing Address" for reporting, the following Identifiers need to be set up:
||Seq||FieldIdentifier||Description||Field Variable
|1220|T4-EE-ADDR1|Employee Address Line 1|MAIL
|1230|T4-EE-ADDR2|Employee Address Line 2|Blank
|1240|T4-EE-ADDR3|Employee City|Blank
|1250|T4-EE-ADDR4|Employee Province|Blank or constant NAME
|1260|T4-EE-ADDR5|Employee Country|Blank or constant NAME
|1270|T4-EE-POSTAL|Employee Postal Code|BLANK
|1280|T4-EE-MAG-PROV|Employee Prov for Mag File|Blank
|1290|T4-EE-MAG-CNTRY|Employee Country for Mag File|Blank
* The Reference Text field will guide the user to setup each Address Identifier.
* If the mailing address for the employee is not defined on the IEPI form, 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 2160 T4-EE-MAG-PROV Identifier should be set to ZZ – Other.
__For both Primary Address and Mailing Address set up:__
Identifiers 2130, 2140 are used for printing on the government forms.
* For Identifier 2130, users can specify to print PROV NAME.
* For Identifier 2140, users can specify to print COUNTRY NAME.
* If blank, PROV CODE or COUNTRY CODE will be printed as the default for mailing purposes.
Identifiers 2160, 2170 are used for Magnetic Media filing. Users do not need to set these up, the PROV CODE and COUNTRY CODE are used as the default.
For the Employee Mailing Address and the Employee Address, users can use the primary address or the mailing address, derived from the IDFDV form.
At line 227 changed 2 lines
This extracts information from YTD according to the FORM CODE from IDFDV and will produce the Summary Total Report by government registration.
This process also stores the results by GVT Run Number for each employee in the Government Reporting table.
This report extracts information from YTD records according to the FORM CODE on IDFDV and produces the Summary Total Report by government registration.
This process also stores the results by GVT Run Number for each employee in the Government Reporting tables.
At line 234 changed 2 lines
After the [RPYEC] process is run, the GVT Run Number is generated for this RPYEC run for all qualified employees.
Users can go into the [IPGR] and [IPGH] forms to view the T4 generated by this GVT Run Number.
__Notes for RPYEC__
* Each RPYEC run generates one GVT Run (Government Run Number)
* All employees processed by the RPYEC run belong to this GVT Run Number
* At end of RPYEC, the Government Reporting Statistics are printed with the GVT Run Number generated
* After RPYEC is run, users can go into the IPGR (Government Run) form to view the details by GVT Run number
* From the IPGR form, users can pop into an employee’s detail government reporting information on the IPGH (Government Header) form, by double clicking on the employee line.
* Alternately, users can go directly to IPGH (Government Header) inquiry form by employee
* Users can generate many RPYEC runs for different sets of employees. This generates multiple GVT Run numbers. Users can run one RPGRC (Government Reporting) run to pick up all GVT Runs to generate one print form file for printing and one government interface file
* Employee Government Header information can be re-generated by subsequent RPYEC runs if the Government Header has not been filed to the government
* At the end of each run, RPYEC removes any GVT Run Number that does not have GVT Header associated with it
At line 300 added one line
__Canadian Government Reporting - RPGRC__
At line 240 changed 3 lines
;GVT Run Number:Enter the GVT Run Number from the RPYEC run
;Form Code:Enter HL$CAN-T4-YYYY for current reporting year
;Govt Interface Format:Enter HL$CAN-T4-YYYY\\This Interface Format is defined on the IDIF form and is provided in our software
|GVT Run Number|Enter the GVT Run Number from the RPYEC run
|Form Code|Enter HL$CAN-T4-YYYY for current reporting year
|Govt Interface Format|Enter HL$CAN-T4-YYYY\\This Interface Format is defined on the IDIF form and is provided in our software
At line 246 changed 2 lines
After the [RPGRC] process is run, the government xml file is generated and is ready for an xml parser validation prior to sending to the government;
the internal xml file is generated for printing of the T4 by the RPT4 program.
After the [RPGRC] process is run, the government xml file is generated and is ready for an xml parser validation prior to sending to the government. The internal xml file is generated for printing of the T4s by the RPT4 process.
At line 253 changed 3 lines
For Oracle reports, you must run all Government Form Print programs (i.e. RPT4, RPT4A, RPT4ANR, RPNR4, RPRL1, RPRL2) and send the report to a PDF file instead of to the Previewer.
All Form Print programs are aligned with the government forms in the 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 do not need to adjust the Page Set up when printing.
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the Run Options tab.
At line 257 changed 11 lines
!!Report Parameters & Filters
||Report Parameters||This section is used for both Oracle and Windward report
|Print T4 Copy|Defines the Employer or Employee copy to be printed.\\From Lexicon: [T4 Forms|X_T4_FORMS] lexicon available
|Exception Level|Users should always run with 'Exception Only' unless for needed for tracing
|Duplicate/Amended|Optional. Defines text to print on the T4 form to indicate a 'Duplicate' or 'Amended' copy\\
There are two ways to print Duplicate or Amended T4 forms, please read below.
|Test Form Set-Up|Optional\\All users should test their Printer with this 'Test Form Set Up' toggle to find out the correct Page Set Up for 'Top Margin Adjustment' and 'Between Form Space' adjustment prior to printing the actual T4 Forms.\\ \\Since each Printer's Page Set Up margin varies differently, each time when the user is printing the T4 forms on a different Printer, the user should do a Printer Set up test
|Trial Print only|Optional\\This toggle allows users to print T4 forms for verification\\ \\In non-trial mode, the RPT4 updates the GVT Headers Govt Print Stage of the run
|Show T4 Form|Optional\\If this toggle is set to ON, RPT4 will print the T4 Form image downloaded from the CRA website on the background for users to view the T4 information.
|User Comment|Optional\\Users can enter a comment to print on the Parameter page
Users should run all Government Form Print programs, such as RPT4, RPT4A, RPT4ANR, RPNR4, RPRL1, RPRL2 with this setting.
At line 269 changed 6 lines
||Report Parameters||(* Oracle Report Only)
|Directory Name|Enter a valid directory name, must be the same as RPGRC run
|XML File Name|The XML File name that is generated from RPGRC with the file extension _HL.xml
|Slips Per Segment|Optional\\Users no longer need to send in T4 Segments when filing less than 500 slips on paper forms, however, the user can still choose to use the T4 segments at their discretion\\
\\If a user sends in T4 slips in a bundle of 200 or other quantities, then users need to update this field
|Adjust Top Margin|Optional\\Defines the Top Margin Adjustment for printing the form\\
All Form Print programs are aligned with the government forms in the 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, the users will not need to adjust the Page Set up when printing.
!!RPT4 Report Parameters
This section is used for both Oracle and Windward report versions
||Field||Description
|Print T4 Copy|Defines if the Employer or Employee copy will be printed.
|Exception Level|Defines the level of detail on the exception report. Users should always run with 'Exception Only' unless for needed for tracing
|Duplicate/Amended|Optional. Defines the text to print on the T4 form to indicate if it is a 'Duplicate' or an 'Amended' copy. \\There are two ways to print Duplicate or Amended T4 forms, please read below.
|Test Form Set-Up|Optional\\Defines if RPT4 shouldprint the actual T4s, or to print a sample of the T4 form to find out the correct page set up for the printer.\\ \\Since each Printer's Page Set Up margin varies differently, each time a user is printing the T4 forms on a different Printer, the user should do a Printer Set up test.
|Trial Print only|Optional\\When set to YES, will produce a report for verification purposes only.\\ \\In non-trial mode, RPT4 updates the GVT Headers Govt Print Stage of the run.
|Show T4 Form|Optional\\Allows users the option to print the T4s form image on the background for testing purposes only. Default is NO. \\ \\When users are running RPT4 for the actual T4 form printing, __DO NOT__ set this toggel to ON.
|User Comment|Optional\\Users can enter a comment to print on the heading of the report
!RPT4 Report Parameters(* Oracle Report Only)
|Directory Name|Defines the directory where the file will be saved. Must be the same as the RPGRC run.
|XML File Name|Defines the xml file name that is generated from RPGRC with the _HL.xml extension.
|Slips Per Segment|Optional\\Users are no longer required to send in T4 Segments when filing less than 500 slips on paper forms, however, users have the option to use the T4 segments at their discretion.\\
\\If a user sends in T4 slips in a bundle of 200 or other quantities, then users need to define this field
|Adjust Top Margin|Optional\\Defines the adjustment spacing for the Top Margin when printing the T4 form\\
At line 277 changed one line
\\If adjustment is needed, then re-run RPT4 by entering the Top Margin adjustment
\\If adjustment is needed, re-run RPT4 by entering the Top Margin adjustment.
At line 281 changed one line
\\If adjustment is needed, then re-run RPT4 by entering the 'Between Form Space'
\\If adjustment is needed, re-run RPT4 by entering the 'Between Form Space'
At line 283 changed one line
|Show Frame (Test Only)|Used when a user is testing the margin set up or to debug a Print Format problem. Users can use this toggle to show the line border of the internal Frames
|Show Frame (Test Only)|Used when testing the margin set up or to debug a Print Format problem. Users can use this toggle to show the line border of the internal frames.
At line 286 changed 2 lines
|GVT Run (WW only)|This is not used for Oracle RPT4 reports. Used for Windward RPT4 reports only
|Person Code|Optional. If a Person Code is not entered, all the employees in the xml file will be printed
|GVT Run (WW only)|Mandatory when running Windward RPT4 reports only. This is __not used__ for Oracle RPT4 reports.
|Person Code|Optional. Person code of the employee being tested with. If a Person Code is not defined, all the employees in the xml file will be printed.
At line 289 changed 2 lines
%%information For Oracle report, if the combination of 'Top Margin Adjustment' and 'Between Form Space' pushes the Form to go over to the next page,
users should check the alignment with the actual pre-printed form and re-run RPT4 with different 'Top Margin' and 'Between Form Space' again.%%
%%information For Oracle reports only, if the combination of 'Top Margin Adjustment' and 'Between Form Space' pushes the Form to go over to the next page, users should check the alignment with the actual pre-printed form and re-run RPT4 with different 'Top Margin' and 'Between Form Space' again.%%
At line 294 removed one line
!RPT4 - Sample Print
At line 296 removed 2 lines
%%warning IMPORTANT: When printing from the pdf file, users must turn on the ACTUAL SIZE toggle to print on the pre-printed government forms to avoid re-sizing of the form.%%
At line 302 changed one line
The RPT4 Program 'Print Format' is based on the Government published T4 (15) Form. If you are using other versions of the T4 form, such as T4(12), please test the RPT4 form layout prior to printing.
The RPT4 Program's 'Print Format' is based on the Government published T4 (15) Form. If you are using other versions of the T4 form, such as T4(14), please test the RPT4 form layout prior to printing.
At line 304 changed 2 lines
Please be advised that High Line will support the latest version of the government published form at time of programming. High Line will inform users of the form version being used. We suggest that users should use the same version of the form as the RPT4 program.
However, if a user receives a different version of the form from the government, and RPT4 program does not align properly with the form, then there are two options for this situation:
High Line will support the latest version of the government published form at time of programming and inform users of the form version being used. High Line recommends using the same form version as the RPT4 program.
If a user receives, or is using, a different version of the form, and the RPT4 program does not align properly with the form, users should re-order the correct form from the government that is the same as the RPT4 program.
At line 307 changed 2 lines
# Users can re-order the form from the government that is the same as the RPT4 program (if users are using a prior year version of the T4)
# Inform High Line of the form variation. High Line will assess whether the PRT4 program needs to be revised or not.
* The RPT4 Form Print program prints all information generated by the RPGRC _HL.xml file, according to the selection criteria.
* If an employee has multiple footnotes codes to be reported, each T4 Form is printed with 6 footnotes until all footnotes are printed.
* The RPT4 program generates Summary Totals, by each Business Number, at the end of the RPT4 run. A grand total is generated for all Business Numbers of the run.
* Users must run RMEX with the RPT4 Mex ID to obtain the summary and grand totals to balance to the RPYEC Summary report.
* The RPT4 summary and grand totals are accumulated for the boxes shown on the T4 Form. The footnotes are not totaled.
* Users should verify the RPT4 Boxes balance to the RPYEC report.
At line 310 changed one line
The RPT4 Form Print program prints all information generated by from the RPGRC _HL.xml file according to the selection criteria.
If RPT4 cannot select any information from the xml file to print, users must run RMEX with the RPT4 Mex ID to review any errors or exception messages to locate the problem.
Typically, the problem is because of an invalid directory or file name.
At line 312 changed one line
If an employee has nultiple footnotes to be reported, each T4 Form is printed with 6 footnotes until all footnotes are printed.
__Laser Form Printing__
When printing T4 forms using the Laser forms, users are required to print the Employer Copy and Employee Copy of the T4s.
At line 314 changed one line
The RPT4 program generates Summary Totals by each Business Number, at the end of the RPT4 run. A grand total is generated for all Business Numbers of the run.
* When RPT4 is run, the "Print T4 Copy" parameter defines if the Employer or the Employee Copy should be printed.
* Users must run RPT4 twice; once to print the Employer Copy, and once to print the Employee Copy
* Employer Copy T4 forms:
** On one sheet, the T4 information is printed for two separate employees.
** The Box 54 Business Number is printed.
** The Employer Copy is sent to the government or is kept by your organization.
At line 316 changed one line
Users must run RMEX with the RPT4 Mex ID to obtain the summary and grand totals to balance to the RPYEC Summary report.
* Employee Copy T4 forms:
** On one sheet, two copies of the T4 is printed for one employee.
** The Box 54 Business Number is NOT printed.
** The Employee Copy is distributed to the employees
At line 318 changed one line
The RPT4 Summary and Grand Totals are accumulated for the boxes shown on the T4 Form. The footnotes are not totaled.
!Duplicate Copies
At line 320 changed one line
Users should verify the RPT4 Boxes to balance to RPYEC.
If an employee loses their T4 form, the employee can request the employer to issue a Duplicate Copy' of their original T4 or T4A form to replace the lost or destroyed forms.
At line 322 changed 2 lines
If RPT4 cannot select any information from the xml file to print, users must run RMEX with the RPT4 Mex ID to review any errors or exception messages to locate the problem.
Usually the problem is because of an invalid directory or file name.
To issue Duplicate Copies:
# 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.
At line 325 changed one line
!Duplicate or Amended Copies
# Run RPGRC 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 RPT4 and RPT4A programs
** 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
At line 327 changed one line
If an employee loses their T4 form, users need to reissue a 'Duplicate Copy' of the original T4 form.
# Run RPT4 or RPT4A to print the duplicate forms
** Run the Form Print RPT4, RPT4A, ect. programs to read 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.
At line 329 changed 2 lines
If a user discovers erroneous box information on the T4 form and need to revise the Box information, users should modify the IDFDV set up and then re-run the RPYEC, RPGRC, RPT4 programs.
This willproduce an 'Amended' T4 form.
!Amended Copies
At line 332 changed one line
There are two ways to print a 'Duplicate Copy' or an 'Amended' T4 form:
If a user discovers erroneous box information on the T4 form 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 RPT4 processes.
This produces the 'Amended' T4 form.
At line 334 changed 8 lines
# Go to the IPGH form for the employee and highlight the form to be duplicated. Change the Print Stage to '11-Duplicate requested. Run the RPYEC and RPGRC programs to generate the _HL.xml file that contains the Duplicate/Amended records
#* When a user is running RPT4 with the new _HL.xml file, RPT4 will automatically print the word 'DUPLICATE COPY' or 'AMENDED' on the T4 form, depending on the GVT Run option of RPGRC run
#* At the end of the RPT4 run, in non-trial mode, the GVT Header stage will be updated with either a 'Duplicate' or 'Amended' stage
# When RPT4 is run, users can enter the word 'DUPLICATE COPY' or 'AMENDED' on the prompt.
#* This method should be used when users have many forms to be printed with 'DUPLICATE COPY' or 'AMENDED' and there is not enough time to re-generate the _HL.xml file from RPYEC, RPGRC, and the original _HL.xml file still exists
#* When RPT4 is run, the manually defined word 'DUPLICATE COPY' or 'AMENDED' will be printed on T4 form
#* At the end of RPT4 run, in non-trial mode, the GVT Header comment field will be updated with the user defined wording, such as 'Duplicate Copy' or 'Amended'
#* If other wording is required to print on the T4 form, users can enter the text on this prompt for RPT4, such as 'CANCEL COPY', 'ORIGINAL COPY'
To issue Amended copies:
At line 343 changed one line
!T4 Slip Print Characteristics
# Update the employee’s YTD information through payroll.
# Check the IDFDV set up and revise the box information, if necessary
# 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.
## 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
# 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
# Run RPT4 to print the Amended forms.
## When the user is running RPT4 with the new _HL.xml file, RPT4 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 T4 form, in the Duplicate/Amended parameter, users can enter the text for RPT4, such as CANCEL COPY or ORIGINAL COPY.
## At the end of the RPT4 run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage.
At line 345 changed one line
T4 slips are printed in alphabetical order by employee's SURNAME, FIRST NAME within a government registration number.
!RPTR Void Forms`
* After the T4 slips are printed, the RPT4 process will generate an intermediate Summary Total on the RMEX report
* Users will bundle the Summary Total with the current year T4 slips to send to the government
* If an employee requires more than one T4 form, and this employee’s T4 information is split between 2 summaries, then this employee’s T4 information will be printed on the first Summary Total. Consequently, there may be more T4 slips on the Summary.
* When the last T4 form is printed for the first Summary, if the last T4 information prints on the TOP T4 slip, the BOTTOM T4 slip will be VOIDED so users can separate the T4 slips by Summary.
* When RPT4 is run, if there is more than one Government Registration Number from IDGR;
** The T4 forms will be sorted by Government Registration Numbers
** RPT4 will generate totals for each Government Registration Number on the RMEX report.
* When the last T4 form is printed for the first Government Registration Number, if the last T4 information prints on the TOP T4 slip, the BOTTOM T4 slip will be VOIDED so users can separate the T4 slips by Government Registration Number.
At line 347 removed one line
If employees are paid by multiple government registrations, then multiple T4 slips are produced by government registration number for these employees.
At line 349 removed one line
The font size for printing T4 slips is the standard 12 character per inch font, character mode.
At line 351 changed 2 lines
Negative (credit) amounts are never allowed for T4 reporting and therefore if negative amounts are encountered, an exception message is displayed.
Users must resolve the negative amount and re-run the process.
!T4 Processing
Users can print a specific province, or all provinces. If all provinces are to be printed, a T4 will be generated for each province that an employee has worked in.
At line 354 changed one line
If there is no amount to be printed for a Box on the T4 form, the Box is left as BLANK. Zero or 'NIL' is __NOT__ allowed
T4 slips are printed by government registration number, then in alphabetical order by the employee SURNAME, FIRST NAME.
At line 356 changed one line
Users can sort inactive and active employees so inactive employees are printed separately, for mailing purposes.
If an employee is paid by multiple government registrations, then multiple T4 slips are produced, by government registration number, for the employee.
At line 358 changed one line
If the Employment Status is A (Active) then the Employee is considered Active, otherwise the employee is considered Inactive.
The font size for printing T4 slips is the standard 12 character per inch font, character mode.
At line 360 changed one line
The T4 slip has an "Other Information" area to report up to 6 footnotes and amounts for each form
Negative (credit) amounts are never allowed for T4 reporting. Therefore if negative amounts are encountered, an exception message is displayed and the user must resolve the negative amount and re-run the process.
At line 362 changed one line
If there are more than 6 footnotes to be reported in the "Other Information" area, then a 2nd or 3rd T4 slip is produced
If there is no amount to be printed in a Box on the T4 form, the Box is left as BLANK. A zero amount or 'NIL' is __NOT__ allowed.
At line 364 changed one line
The 2nd or 3rd T4 slip prints the employee's demographic information only, the numeric boxes are not printed.
Users can sort inactive and active employees so inactive employees are printed separately for mailing purposes.
At line 366 changed one line
If an employee works in more than one province, then one T4 slip is produced for each province for the employee. The "Other Information" area information T4 slips are also produced by Province
If the Employment Status is A (Active) then the employee is considered Active, otherwise the employee is considered inactive.
At line 368 changed one line
The T4 Magnetic Media File is in an xml file format and allows all footnotes to be reported for one employee. Multiple XML records are generated for one employee if there are more than 6 footnotes
The T4 slip has an "Other Information" area to report up to 6 footnote codes and amounts for each form.
At line 370 changed one line
Alphanumeric fields are left-justified with no space between each character, such as JOHN DOE, not J O H N D O E
If there are more than 6 footnote codes to be reported, then subsequent T4 slips are generated until all footnote codes have been printed.
At line 372 changed one line
The numeric fields are lined up with the decimal
The subsequent T4 slips must report $1.00 in Employment Income Box 14 in order for Canada Customs and Revenue Agency (CCRA) to process the additional T4 slip. If all numeric boxes are zero, the T4 slip will be bypassed.
If additional T4 slips are reported with $1.00 in Box 14, then the previous T4 slip is reduced by $1.00 in Box 14.
The T4 Magnetic Media File also includes the subsequent T4 record(s) with the Other Information area in the same manner as the T4 slip. Consequently, an employee can have multiple "110" code records. The Box 14 reporting for the additional code "110" records will also contain $1.00.
If an employee works in more than one province, then one T4 slip is produced for each province for the employee. The "Other Information" area information T4 slips are also produced by Province
At line 481 added 4 lines
The Alphanumeric fields are left-justified with no space between each character, such as JOHN DOE, not J O H N D O E.
The numeric fields are lined up with the decimal place.
At line 376 changed one line
Users __MUST__ run the RMEX report for the Mex ID from the RPT4 run to print the T4 grand totals to verify all records are printed
Users __MUST__ run the RMEX report for the Mex ID of the RPT4 run to print the T4 grand totals to verify all records are printed.
At line 380 changed 2 lines
On T4 Form, the last line in the Address Box is used to print the user defined distribution information for users to hand out the T4 forms to the employees.
Users must set up the following identifiers:
On the T4 Form, the last line in the Address Box is used to print the user defined distribution information for users to dsitribute the T4 forms to the employees.
Users must set up the following identifiers:\\
At line 383 changed 2 lines
|T4-EE-DISTR|(constant) blank or 1|
|T4-EE-DESTIN|(constant) blank or 1|
|T4-EE-DISTR|Constant|Blank or 1|
|T4-EE-DESTIN|Constant|Blank or 1|
At line 388 changed 2 lines
If the T4-EE-DISTR value = 1 (not null), then the distribution will be printed below the employee address for distribution purposes.
The distribution is visible outside the window envelope, otherwise, the distribution will not be printed.
If T4-EE-DISTR value = 1 (not null), the distribution will be printed below the employee address for distribution purposes, and the distribution will be visible outside the window envelope.
Otherwise, the distribution will not be printed.
At line 391 changed one line
If the T4-EE-DESTIN value = 1, then the employee's pay destination is printed along with the T4-EE-DISTR1 and the T4-EE-DISTR2
If T4-EE-DESTIN value = 1, the employee's pay destination will be printed along with T4-EE-DISTR1 and T4-EE-DISTR2.
At line 393 changed 4 lines
Therefore on the T4 form, the logic for printing distribution is:
*If T4-EE-DISTR = 1, then the distribution information is printed from:
**optional employee's pay destination T4-EE-DESTIN if specified (such as Department or Pay destination of the employee)
**concatenates with the values from T4-EE-DISTR1 and T4-EE-DISTR2
Therefore, the logic for printing the distribution on the T4 form is:\\
If T4-EE-DISTR = 1, the distribution information is printed from:
*The employee's pay destination T4-EE-DESTIN, if defined, such as Department or Pay destination
*Concatenates with the values from T4-EE-DISTR1 and T4-EE-DISTR2
At line 401 changed one line
Users should read the following FORM DESCRIPTIONS and refer to "Employers' Guide - Filing the T4 Slips and Summary Forms" RC4120(E) Rev. 16" prior to setting up the IDFDV form.
Users should read the following Form Descriptions and refer to "Employers' Guide - Filing the T4 Slips and Summary Forms" RC4120(E) Rev. 16" prior to setting up the IDFDV form.
At line 403 changed 2 lines
;Box - Year:
From user specified Calendar Year YYYY
;Box - Year: From user defined Calendar Year YYYY
At line 418 changed 3 lines
*The IDFDV form Reference Text field will guide the user to set up each Address Identifier.\\ \\
*If the mailing address is not defined for the Employer on IDLN of IDEN location, the IDLN primary address will be used.\\ \\
*If users have previous Address set up prior to 2005, if the word ‘MAIL’ is defined, the mailing address will be used, otherwise the primary address will be used
*The IDFDV Reference Text field will guide the user to set up each Address Identifier.\\ \\
*If the Employer mailing address is not defined on IDLN or IDEN location, the primary address on IDLN will be used.\\ \\
*If there was an Address set up prior to 2006, and the word ‘MAIL’ is defined, the mailing address will be used, otherwise the primary address will be used.
*If the Country Code is not Canada or USA, the 2160 T4-EE-MAG-PROV Identifier should be set to 'ZZ-Other'.
At line 423 changed 2 lines
The Business Number is derived automatically according to employee’s YTD federal government registration number from IDGV or from the employee's Group IDGR form\\ \\
When the user is printing the 'Employee Copy', Box 54 BN number is not printed
The Business Number is derived automatically according to employee’s YTD federal government registration number from IDGV or the employee's Group IDGR form\\ \\
When users are printing the 'Employee Copy', Box 54 is not printed.
At line 434 changed 2 lines
** Invalid SIN numbers are: 999999999.
* If the SIN number does not exist, leave blank. Example: SIN is "9999999999".
* SIN numbers defined as 999999999 are invalid
* If a SIN number does not exist, leave this field blank.
At line 437 changed one line
;Box - Employee's name (Surname, First name, Middle Initial):
;Box - Employee's name:
At line 442 changed one line
|T4-EE-NAME3™|EID.MIDDLE_NAME
|T4-EE-NAME3|EID.MIDDLE_NAME
At line 456 changed one line
*The IDFDV form Reference Text field will guide the user to set up each Address Identifier.
*The IDFDV Reference Text field will guide the user to set up each Address Identifier.
At line 458 changed one line
*If the user has previous Address set up prior to 2005, if the word 'MAIL' is defined, then the mailing address will be used, otherwise the primary address will be used
*If there was an Address set up prior to 2006, and the word ‘MAIL’ is defined, the mailing address will be used, otherwise the primary address will be used.
*If the Country Code is not Canada or USA, the 2160 T4-EE-MAG-PROV Identifier should be set to 'ZZ-Other'.
At line 461 removed 4 lines
Printing for distribution of T4 purpose
The last line in the Address Box is used to print the user defined distribution information for users to hand out the T4 forms to the employees
At line 575 added one line
The last line in the Address Box is used to print the user defined distribution information for users to distribute the T4 forms to employees.
At line 467 changed 2 lines
|T4-EE-DISTR|(constant)|Blank or 1|
|T4-EE-DESTIN|(constant)|Blank or 1|
|T4-EE-DISTR|Constant|Blank or 1|
|T4-EE-DESTIN|Constant|Blank or 1|
At line 471 changed 2 lines
* If the T4-EE-DISTR value = 1 (not null), then the distribution will be printed below the employee address for distribution purposes. The distribution is visible outside the window envelope.
*Otherwise, the distribution will not be printed
* If T4-EE-DISTR value = 1 (not null), the distribution will be printed below the employee address and the distribution is visible outside the window envelope.
*Otherwise, the distribution will not be printed.
At line 474 changed one line
*If the T4-EE-DESTIN value = 1, then the employee's pay destination is printed along with the T4-EE-DISTR1 and the T4-EE-DISTR2.
*If T4-EE-DESTIN value = 1, then the employee's pay destination is printed along with T4-EE-DISTR1 and T4-EE-DISTR2.
At line 476 changed 4 lines
Therefore on T4 form, the logic for printing distribution is:
*If T4-EE-DISTR = 1, then the distribution information is printed from:
**optional employee's pay destination T4-EE-DESTIN if defined, such as Department or Pay destination of the employee
**concatenates with the values from T4-EE-DISTR1 and T4-EE-DISTR2 \\
Therefore, the logic for printing the distribution on the T4 form is:\\
If T4-EE-DISTR = 1, the distribution information is printed from:
*The employee's pay destination T4-EE-DESTIN, if defined, such as Department or Pay destination
*Concatenates with the values from T4-EE-DISTR1 and T4-EE-DISTR2
At line 483 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 485 changed one line
*This is the taxable earnings applicable for federal income tax withheld \\
This is the taxable earnings applicable for federal income tax withheld \\
At line 487 changed one line
;Box 16 - Employee's CPP contributions:
;Box 16 - Employee's CPP Contributions:
At line 489 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 497 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 610 added 2 lines
*The Employer portion of QPP contribution is also retrieved from the IDFDV form, Field Identifier T4-BOX-16-ER
*The QPP Employer contribution is not printed on the T4 form for each employee. It is accumulated into the Total CPP Employer contribution amount and will be reported on the government Magnetic Media Releve 1 file \\
At line 524 changed 4 lines
*# There are no insurable earnings (i.e. if Box 24 = 0, then Box 24 = blank)
*# Insurable earnings are the same as the employment income in Box 14. Example: i.e. if Box 24 = Box 14, then Box 24 = blank
*# Insurable earnings are over the EI maximum earnings for the year from the IPCT form Tax Rate Code '011001' EI Annual Maximum Earnings.
Example: if Box 24 >= EI maximum earnings, then Box 24 = Blank)
# There are no insurable earnings. Example: If Box 24 = 0, then Box 24 = blank.
# Insurable earnings are the same as the employment income in Box 14. Example: If Box 24 = Box 14, then Box 24 = blank.
# Insurable earnings are over the EI maximum earnings for the year, from IPCT, Tax Rate Code '011001', EI Annual Maximum Earnings.
Example: If Box 24 >= EI maximum earnings, then Box 24 = Blank.
At line 529 changed 3 lines
*The derived EI Insurable Earnings is printed according to the IDFDV form set up on RPYEC Summary report
*The EI Insurable Earnings that is printed on the T4 Form and reported on the Magnetic Media file will be printed on the RPYEC Summary report under the T4-BOX-24-PRT Identifier.
Users should verify this reported EI Insurable Earnings is correct according to the government specification
*The derived EI Insurable Earnings are printed according to the IDFDV form set up on RPYEC Summary report.
*The EI Insurable Earnings that are printed on the T4 Form and reported on the Magnetic Media file will be printed on the RPYEC Summary report under the T4-BOX-24-PRT Identifier.
Users should verify the reported EI Insurable Earnings are correct according to the government specifications.
At line 545 changed 4 lines
*The T4-BOX-26-EXCEPT entry should specify the remuneration that are taxable but not pensionable such as:
**remuneration paid to an employee while the employee worked in excluded employment, not subject to CPP
**amount paid for clergy member's residence from which CPP is not deducted
**remuneration paid to Status Indian on reserve where no CPP is deducted
*The T4-BOX-26-EXCEPT entry should define the remuneration that are taxable, but not pensionable such as:
**Remuneration paid to an employee while the employee worked in excluded employment, not subject to CPP/QPP
**Amount paid for clergy member's residence from which CPP/QPP is not deducted
**Remuneration paid to Status Indian on reserve where no CPP/QPP is deducted
At line 550 changed one line
*The T4-BOX-26-OTHER entry should specify the remuneration that are pensionable but not taxable
*The T4-BOX-26-OTHER entry should define the remuneration that are pensionable but not taxable.
At line 554 changed 3 lines
**Pensionable earnings are the same as the employment income in Box 14. example: if Box 26 = Box 14, then Box 26 = Blank
*Pensionable earnings are over the CPP/QPP maximum earnings for the year from the IPCT form Tax Rate Code '010101' CPP Annual Maximum Earnings.
**Pensionable earnings are the same as the employment income in Box 14. Example: if Box 26 = Box 14, then Box 26 = Blank
**Pensionable earnings are over the CPP/QPP maximum earnings for the year, from IPCT, Tax Rate Code '010101', CPP Annual Maximum Earnings.
At line 559 changed 8 lines
*Otherwise perform one of the following conditions:
**If Box 14 > Box 26 CPP/QPP earnings
***Use the IDFDV T4-BOX-26-EXCEPT Field Identifier entry to obtain the amount for excepted employment
***the excepted employment amount is then subtracted from Box 14
***if the new Box 14 amount is equal to Box 26 CPP/QPP earnings, this box will be blank, otherwise Box 26 CPP/QPP earnings will be printed
**the following conditions are covered by this logic:
***remuneration paid to an employee before age 18 or after age 70 during the year, then this box will be printed
***an employee is being remunerated by excepted employment as specified from "Employer's Guide", this box will be printed
*Otherwise, perform one of the following conditions:
**If Box 14 > Box 26 CPP/QPP earnings:
***Use the T4-BOX-26-EXCEPT Field Identifier entry to obtain the amount for the excepted employment
***The excepted employment amount is then subtracted from Box 14
***If the new Box 14 amount is equal to Box 26 CPP/QPP earnings, this box will be blank, otherwise Box 26 CPP/QPP earnings will be printed.\\
At line 676 added 4 lines
**The following conditions are covered by this logic:
***Remuneration paid to an employee before age 18 or after age 70 during the year, then this box will be printed.
***An employee is being remunerated by excepted employment as defined from the "Employer's Guide", this box will be printed.
At line 569 changed 5 lines
**for Quebec, if Box 26 QPP earnings > Box 14, Box 26 is always printed
**for all other provinces:
**use thw IDFDV T4-BOX-26-OTHER Field Identifier entry to obtain the amount for pensionable employment
**the pensionable employment amount is then added to Box 14
**if the new Box 14 amount is equal to Box 26 CPP/QPP earnings, this box will be blank, otherwise Box 26 CPP/QPP earnings will be printed
**For Quebec, if Box 26 QPP earnings > Box 14, Box 26 is always printed
**For all other provinces:
**Use the T4-BOX-26-OTHER Field Identifier entry to obtain the amount for pensionable employment
**The pensionable employment amount is then added to Box 14
**If the new Box 14 amount is equal to Box 26 CPP/QPP earnings, this box will be blank. Otherwise Box 26 CPP/QPP earnings will be printed.
At line 575 changed one line
*The derived CPP/QPP Pensionable Earnings is printed according to the IDFDV form set up on RPYEC Summary report
*The derived CPP/QPP Pensionable Earnings are printed according to the IDFDV form set up on the RPYEC Summary report.
At line 577 changed 2 lines
*Then the CPP/QPP Pensionable Earnings that is printed on the T4 Form will also be printed on the RPYEC Summary report under the T4-BOX-26-PRT Identifier.
Users should verify this reported CPP/QPP Pensionable Earnings is correct according to the government specification
*The CPP/QPP Pensionable Earnings that are printed on the T4 Form will also be printed on the RPYEC Summary report, under the T4-BOX-26-PRT Identifier.
Users should verify the reported CPP/QPP Pensionable Earnings are correct according to the government specifications.
At line 623 changed one line
;Box 50 - RPP or DPSP registration number:
;Box 50 - RPP or DPSP Registration Number:
At line 637 changed 3 lines
*The values from T4-BOX-50-RPP1, T4-BOX-50-RPP2, T4-BOX-50-RPP3, T4-BOX-50-RPP4 and T4-BOX-50-RPP5 are used for comparison
*The largest value from T4-BOX-50-RPP1, T4-BOX-50-RPP2, T4-BOX-50-RPP3, T4-BOX-50-RPP4 and T4-BOX-50-RPP5 is used and the corresponding
T4-BOX-50-REG1, T4-BOX-50-REG2, T4-BOX-50-REG3, T4-BOX-50-REG4 and T4-BOX-50-REG5 is reported
*The values from T4-BOX-50-RPP1, T4-BOX-50-RPP2, T4-BOX-50-RPP3, T4-BOX-50-RPP4 and T4-BOX-50-RPP5 are used for comparison.
*The largest value from T4-BOX-50-RPP1, T4-BOX-50-RPP2, T4-BOX-50-RPP3, T4-BOX-50-RPP4 and T4-BOX-50-RPP5 are used and the corresponding
T4-BOX-50-REG1, T4-BOX-50-REG2, T4-BOX-50-REG3, T4-BOX-50-REG4 and T4-BOX-50-REG5 are reported
*The T4-BOX-50-PRT Identifier is for the XML file only. There is no need to set this Identifier up.
At line 641 removed 3 lines
*The following Identifier from the IDFDV form is for Information Purpose only. There is no need to set this Identifier up
||Field Identifier||
|T4-BOX-50-PRT|This is used for XML file only
At line 647 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 649 changed one line
*Box 52 is rounded up to the nearest Dollar, no cents are printed.
*Box 52 is rounded up to the nearest Dollar. No cents are printed.
At line 653 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 657 changed 2 lines
DDerived from the IDFDV form
||Field Identifier||Suggested Field Variable (Element)
Derived from the IDFDV form
||Field Identifier||Suggested Field Variable
At line 660 changed 7 lines
*This box will be blank under one of the following conditions:
*#There are no insurable earnings (if Box 56 = 0, then Box 56 = blank)
*#Insurable earnings are the same as the employment income in Box 14 (if Box 56 = Box 14, then Box 56 = blank)
*#Insurable earnings are over the PPIP maximum earnings for the year from the IPCT form Tax Rate Code '011201' QPIP Annual Employee Maximum for the province (if Box 56 >= QPIP maximum earnings, then Box 56 = blank)
*The derived PPIP Insurable Earnings is printed according to the IDFDV form set up on the RPYEC Summary report
*The PPIP Insurable Earnings that is printed on the T4 Form and reported on the Magnetic Media file will be printed on the RPYEC Summary
report under the T4-BOX-56-PRT Identifier. Users should verify this reported PPIP Insurable Earnings is correct according to the government specification
*Boc 56 will be blank under one of the following conditions:
*#If there are no insurable earnings. Example: if Box 56 = 0, then Box 56 = blank
*#Insurable earnings are the same as the employment income in Box 14. Example: if Box 56 = Box 14, then Box 56 = blank
*#Insurable earnings are over the PPIP maximum earnings for the year, from IPCT, Tax Rate Code '011201', QPIP Annual Employee Maximum for the Province. Example: if Box 56 >= QPIP maximum earnings, then Box 56 = blank
*The derived PPIP Insurable Earnings is printed according to the IDFDV form set up on the RPYEC Summary report.
*The PPIP Insurable Earnings that are printed on the T4 Form and reported on the Magnetic Media file will be printed on the RPYEC Summary report under the T4-BOX-56-PRT Identifier. Users should verify the reported PPIP Insurable Earnings are correct according to the government specifications.
At line 670 changed one line
||Field Identifier||Suggested Field Variable (Element)
||Field Identifier||Suggested Field Variable
At line 672 changed 3 lines
*Up to 6 footnotes can be printed per T4 form
*If there are more than 6 footnotes to be reported, then a second or third T4 slip will be produced
*The second or third T4 slip numeric boxes will be blank, the employee's demographic information will be printed along with the footnote codes
*Up to 6 footnote codes can be printed on each T4 form
*If there are more than 6 footnote codes to be reported, subsequent T4 form will be produced
*The subsequent T4 slip numeric boxes will be blank. The employee's demographic information will be printed along with the footnote codes.
At line 676 changed one line
!!Magnetic Media - Government XML file
!!Magnetic Media File - Government XML file
At line 679 changed one line
*The government xml file layouts are provided by the government on their web site each year
The government XML 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 format. \\
The IDIF layout is provided by High Line with the year end software (SEED_IDIF_HL$CAN_T4_YYYY). Users do not need to modify this form.
At line 681 changed one line
*The IDIF form is used to define the government file in an xml file format
Users must run the RPYEC and RPGRC processes to generate the Magnetic Media file in the government XML file format. Please refer 'Government Reporting Procedures, Sequence' section that describes how the process is run.
At line 683 changed one line
*The IDIF layout is provided with the Year End software. Users do not need to set up this form SEED_IDIF_HL$CAN_T4_CCYY.sql
%%warning IMPORTANT: The government requires users to validate the government XML file according to the downloaded government XML schema using a validating parser prior to sending the file to the government.
At line 685 changed one line
* Users must run the RPYEC and RPGRC processes to generate the Magnetic Media file in the govt xml file format. Please read PR_CAN_Govt_Reporting_2016_eP.doc Government Reporting Sequence that describes the process to be run
!Validating the Govt XML File
A validating parser tool from any third party will perform the following checks on the government XML file generated by RPGRC:
At line 687 changed 2 lines
%%warning IMPORTANT: The government requires users to validate the govt xml file according to the downloaded government xml schema using a validating parser prior to sending to the government. Please read PR_CAN_Govt_Reporting_2013_P2K.doc for xml file validation.%%
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.
At line 802 added 22 lines
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 T4 and T4A xml files.
!!Electronic T4 Print Facility
Employees can consent, or withdraw their consent, to print their T4 form through Self Service.
If an employee chooses to receive electronic T4 forms, they must enter their consent in the My T4 Consent form (WEPT4). \\ \\
To print their T4, employees must run the RET4 process and select the Reporting Year they want to print. The output of the T4 will be in a pdf format. \\ \\
If an employee has chosen to receive electronic T4 forms, using either the consent form WEPT4 or IEPT4, a paper copy is NOT printed during the RPT4 T4 printing process. \\ \\
Organizations can:
* Manage the consent for employees to receive electronic T4 forms using the Maintain Employee T4 Consent form (IEPT4).
* Control the years that T4 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).