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
CDN T 4 PROCESS
CDN T4 PROCESS

Version management

Difference between version and

At line 6 changed 4 lines
!!T4
Employers’ Guide – Filing the T4 Slip and Summary \\
[https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4120.html]
\\ \\
!!Current Year End Changes
__New for 2018__ \\
An amendment reason explanation tag has been added at the Summary level for the following form types: T4, T4A, T4A-NR, T4RSP, T4RIF, T4E, T4AP, T4OAS, T1204, PRPP, T5, T5007, T5008, T5013, T5018, T3, NR4, TFSA, RRSP. The tag is not mandatory and is intended allow a filer to provide a brief explanation for the amendments within the file, up to 1309 characters. \\https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/filing-information-returns-electronically-t4-t5-other-types-returns-what-you-should-know-before.html#xmlspcs
At line 13 added one line
Employer's Guide - Filing T4 Slip and Summary 2017 (RC4120)|https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pub/tg/rc4120/rc4120-17e.pdf
At line 12 changed 4 lines
For the current year reporting, the T4 Form Layout is used and can be found at: \\
[https://www.canada.ca/en/revenue-agency/services/forms-publications/forms/t4.html]\\
[https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4120/employers-guide-filing-t4-slip-summary.html]
\\ \\
For 2017 reporting, T4 (14) Form Layout is used.\\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/t4/t4flat-14b.pdf
The latest T4 form (14) has no changes in alignment from lat year's form.
%%warning For Oracle reports, users must run all Government Form Print programs (i.e. RPT4, RPT4A, RPT4ANR, RPNR4, RPRL1, RPRL2) and send the report to PDF file instead of to the Previewer. All Form Print programs are aligned with the government forms in PDF format and allow you to adjust the parameters for 'Top Margin' and the 'Between Form Space' when generating the PDF file. Once the PDF file is generated, you do not need to adjust the page setup when printing.%%
At line 17 changed 2 lines
The current year Government XML File layout is used.\\
[https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/filing-information-returns-electronically-t4-t5-other-types-returns-what-you-should-know-before.html#xmlspcs]
The 2017 T4 Government XML File layout change for this reporting year. An amendment reason explanation tag has been added at the Summary level.
At line 20 changed 3 lines
Please download CRA XML Schema from: \\
[https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/filing-information-returns-electronically-t4-t5-other-types-returns-file.html#stp2]
\\
Please download CRA 2017 XML Schema from:\\
http://www.cra-arc.gc.ca/esrvc-srvce/rf/hwfl-eng.html
At line 24 changed 14 lines
The IDIF form is configured for the Current Year xml schema format.
\\ \\
__UPPHT Function__\\
The UPPHT Pay History Totals Interface - Canada T4 Footnotes Processing has
been created to support the COVID-19 Code 57, 58, 59, 60 reporting.
\\ \\
__IDFDV Form__\\
IDFD and IDFDV new form definition HL$CAN-T4-YYYY
\\ \\
!!T4A
Employers’ Guide – Filing the T4A Slip and Summary \\
[https://www.canada.ca/en/revenue-agency/services/forms-publications/forms/t4a.html]
\\ \\
!T4A Form
* The IDIF form is configured for the 2017 xml schema format.
At line 39 removed 2 lines
For the current year reporting, the T4A Form Layout is used. \\
[https://www.canada.ca/en/revenue-agency/services/forms-publications/forms/t4a.html]
At line 31 added 8 lines
T4A Form
For 2017 reporting, the T4A(17) Form Layout is used. \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/t4a/t4a-17e.pdf \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pub/tg/rc4157/rc4157-17e.pdf
* The latest T4A forms (17) has no changes in alignment from last year’s form.
At line 43 changed one line
There are no changes for the 2020 T4A Government XML File layout \\
The 2017 T4A Government XML File layout change for this reporting year. An amendment reason explanation tag has been added at the Summary level. \\
At line 45 changed 2 lines
Please download CRA XML Schema from: \\
[https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/filing-information-returns-electronically-t4-t5-other-types-returns-file.html#stp2]
Please download CRA 2017 XML Schema from: \\
http://www.cra-arc.gc.ca/esrvc-srvce/rf/hwfl-eng.html
At line 48 changed 2 lines
\\ \\
The IDIF form is configured for the Current Year xml schema format.
* The IDIF form is configured for the 2017 xml schema format.
At line 51 changed one line
__IDFDV Form__\\IDFD and IDFDV new form definition HL$CAN-T4A-YYYY
!T4ANR Form
For 2017 reporting, the T4ANR (16) Form Layout is used. \\
http://www.cra-arc.gc.ca/E/pbg/tf/t4a-nr/t4a-nr-16e.pdf
At line 51 added 6 lines
!NR4 Form
For 2017 reporting, the NR4 (17) Form Layout is used. \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/nr4/nr4-17e.pdf
At line 58 added one line
!Government Reporting – Sequence
At line 55 changed 10 lines
\\
__IPPC__\\
* Set up new Pay Components with PC Usages 5700, 5701, 5702, 5703, 5704, 5705 to be used for T4 Codes 57, 58, 59 and 60 reporting (new for 2020 reporting)\\
\\
__UPPHT__\\
* Produce the Pay History for the new Pay Components in IPVT
* Creates a csv file for reconciliation and balancing of the new Pay Component amounts
* Generates IDCL records for CAN_T4_2020, CAN_T4_2020_SUMMARY and CAN_T4_2020_YEARLY
\\
__RPREGT__\\
__RPREGT__
At line 66 changed one line
* For the 'Provide Totals By' parameter, select 'Fed Regist Number' \\ \\
* For the ‘Provide Totals By’ parameter, select ‘Fed Regist Number’ \\ \\
At line 88 changed one line
* Stands for 'Report Payroll Year End Canada'
* Stands for ‘Report Payroll Year End Canada’
At line 101 changed one line
* Users can change the Print Stage to request a 'Duplicate' or 'Amended Copy' \\ \\
* Users can change the Print Stage to request a ‘Duplicate' or ‘Amended Copy’ \\ \\
At line 104 changed one line
* Stands for 'Report Payroll Government Reporting Canada'
* Stands for ‘Report Payroll Government Reporting Canada’
At line 109 changed 2 lines
* 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 RPT4W, RPT4A, RPT4AW, RPRL1W etc. to print the T4, T4A and Releve Forms by employee
* 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, RPT4W, RPT4A, RPT4AW, RPRL1, RPRL1W etc. to print the T4, T4A or Releve Forms by employee \\ \\
At line 113 changed 2 lines
* RPT4W, RPT4AW, RPT4AW, RPRL1W, etc. to print government forms for the employee
* Reads the XML file generated from the RPGRC process to print on Government Forms
* RPT4, RPT4W, RPT4A, RPT4AW, RPRL1, RPRL1W etc. to print government forms for the employee
* Reads the XML file generated from the RPGRC process to print on the Government forms
At line 116 changed one line
* Generates grand totals for the RMEX report to balance to the RPGRC grand totals\\ \\
* Generates grand totals for the RMEX report to balance to the RPGRC grand totals \\ \\
At line 119 changed 2 lines
* Reads the Execution Run Log from the Form Print programs RPT4W, RPT4AW, RPRL1W etc.
* Prints grand totals to balance to the RPGRC grand totals\\ \\
* Reads the Execution Run Log from the Form Print programs RPT4, RPT4W, RPT4A, RPT4AW, RPRL1, RPRL1W etc.
* Prints grand totals to balance to the RPGRC grand totals \\ \\
At line 128 changed 2 lines
!IDFD - Form Code HL$CAN-T4-YYYY
(YYYY is the current reporting year) \\ \\
!IDFD - Form Code HL$CAN-T4-YYYY (where YYYY is the current reporting year)
At line 132 changed one line
High Line provides seed data scripts to our customers with the Year End software release to load in the IDFD Form Code SEED_IDFD_HL$CAN_T4_YYYY.sql.
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 140 changed one line
# Select last year's Form Code
# On the IDFDV form, select last year's Form Code
At line 146 changed one line
The Variable Definition (IDFDV) form is used to enter the variable data needed to complete the printing of T4's, for both the printed T4s and the Magnetic Media files. On this form, users define where, in their particular set up, each required field of data will be retrieved from. \\ \\
The Variable Definition (IDFDV) form is used to enter the variable data needed to complete the printing of T4’s, for both the printed T4s and the Magnetic Media files. On this form, users define where, in their particular set up, each required field of data will be retrieved from. \\ \\
At line 148 changed one line
Example: Users can reference pay components, elements, database items, etc. For more information regarding the possible sources, refer the Field Descriptions table below. \\
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 152 changed one line
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 the 'Employer's Guide - Filing T4 Slip and Summary 2018 (RC4120)' prior to setting up IDFDV form. \\ [https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4157/rc4157-19e.pdf] \\
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 the ‘Employer’s Guide – Filing T4 Slip and Summary 2017 (RC4120)’ prior to setting up IDFDV form.
At line 159 changed one line
|Level|Defaults in from the IDFD form, displays the Level (Federal, State, Employer, etc.) that is being reported on for forms/media file.
|Level|Defaults from the IDFD form, displays the Level (Federal, State, Employer, etc.) that is being reported on for forms/media file.
At line 163 added 2 lines
__Descriptions and Suggestions__\\
Users should read the following prior to setting up the IDFDV form:
At line 166 added 3 lines
* Employer’s Guide – Filing T4 Slip and Summary 2017 (RC4120)
* Refer to Revenue Canada for a clearer and more in depth description of the appropriate method to complete your forms, at: \\https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pub/tg/rc4120/rc4120-17e.pdf
At line 172 removed one line
At line 174 changed one line
[{InsertPage page='IDFDV_Form_Definitions_CDN T4'}]
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|T4-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|T4-ER-NAME2|Employer Name Line 2|Data Base Column|DED.ENTITY_NAME, optional
|T4-ER-CAREOF|Employer Name (care of)|Data Base Column|optional
|T4-ER-ADDR1|Employer Address Line 1|Data Base Column|DLN.ADDRESS_LINE_1
|T4-ER-ADDR2|Employer Address Line 2|Data Base Column|DLN.ADDRESS_LINE_2
|T4-ER-ADDR3|Employer City|Data Base Column|DLN.LOCALITY
|T4-ER-ADDR4|Employer Province|Data Base Column|DSP.STATE_PROVINCE_CODE
|T4-ER-ADDR5|Employer Country|Data Base Column|DCO.COUNTRY_CODE
|T4-ER-POSTAL|Employer Postal Code|Data Base Column|DLN.ZIP_POSTAL
|T4-ER-MAG-PROV|Employer Prov for Mag File|Constant|blank
|T4-ER-MAG-CNTRY|Employer Country for Mag File|Constant|blank
|T4-ACCT-NAME|Accounting contact name|Constant|Enter your company data
|T4-ACCT-TEL-AREA|Accounting contact tel area code|Constant|Enter your company data
|T4-ACCT-TEL|Accounting contact telephone|Constant|Enter your company data
|T4-ACCT-TEL-EXT|Accounting contact tel extn|Constant|Enter your company data
|T4-ACCT-LANG|Accounting contact Language|Constant|E
|T4-REGIST-PEN1|Registered pension plan number 1|Constant|Enter your company data
|T4-REGIST-PEN2|Registered pension plan number 2|Constant|Enter your company data
|T4-REGIST-PEN3|Registered pension plan number 3|Constant|Enter your company data
|T4-REGIST-PEN4|Registered pension plan number 4|Constant|Enter your company data
|T4-REGIST-PEN5|Registered pension plan number 5|Constant|Enter your company data
|T4-PROP1-SIN|Proprietor #1 SIN |Constant|Enter your company data
|T4-PROP2-SIN|Proprietor #2 SIN |Constant|Enter your company data
|T4-YOUTH-IND|Youth Hires Program Indicator|Constant|1
|T4-EE-NAME1|Employee Surname|Data Base Column|EID.LAST_NAME
|T4-EE-NAME2|Employee First Name|Data Base Column|EID.FIRST_NAME
|T4-EE-NAME3|Employee Middle Initial|Data Base Column|EID.MIDDLE_NAME
|T4-EE-ADDR1|Employee Address Line 1|Constant|EPS.ADDRESS_LINE_1
|T4-EE-ADDR2|Employee Address Line 2|Constant|EPS.ADDRESS_LINE_2
|T4-EE-ADDR3|Employee City|Constant|EPS.LOCALITY
|T4-EE-ADDR4|Employee Province|Constant |DSP.STATE_PROVINCE_CODE
|T4-EE-ADDR5|Employee Country|Constant|DCP.COUNTRY_CODE
|T4-EE-POSTAL|Employee Postal Code|Constant|EPS.ZIP_POSTAL
|T4-EE-MAG-PROV|Employee Prov for Mag File|Constant|blank
|T4-EE-MAG-CNTRY|Employee Country for Mag File|Constant|blank
|T4-BOX-SIN|Social Insurance Number|Data Base Column|EID.GOVERNMENT_CODE
|T4-EE-DISTR|Print Distribution on T4 form|Constant|blank or 1\\If 1, print employee distribution
|T4-EE-DESTIN|Print Pay Destination|Constant|blank or 1\\If 1, the employee destination is concatenated to employee distribution for printing purposes
|T4-EE-DISTR1|Employee Distribution 1|Data Base Column|PPA.PAYROLL_CODE
|T4-EE-DISTR2|Employee Distribution 2|Data Base Column|EID.PERSON_CODE
|T4-BOX-14|Employment Income|Element|T4-BOX-14
|T4-BOX-16|Employee's CPP contribution|Element|T4-BOX-16
|T4-BOX-16-ER|Employer's CPP contribution|Element|T4-BOX-16-ER
|T4-BOX-17|Employee's QPP contribution|Element|T4-BOX-17
|T4-BOX-17-ER|Employer's QPP contribution|Element|T4-BOX-17-ER
|T4-BOX-18|Employee's EI Premiums|Element|T4-BOX-18
|T4-BOX-18-ER|Employer's EI Premiums|Element|T4-BOX-18-ER
|T4-BOX-20|RPP contributions|Element|T4-BOX-20
|T4-BOX-22|Federal Income Tax deducted|Element|T4-BOX-22
|T4-BOX-24|EI Insurable Earnings|Element|T4-BOX-24
|T4-BOX-24-PRT|EI Insurable Earnings Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-26-CPP|CPP Pensionable Earnings|Element|T4-BOX-26-CPP
|T4-BOX-26-QPP|QPP Pensionable Earnings|Element|T4-BOX-26-QPP
|T4-BOX-26-EXCEPT|CPP/QPP Excepted Earnings|Element|T4-BOX-26-EXCEPT
|T4-BOX-26-OTHER|CPP/QPP Other Earnings|Element|T4-BOX-26-OTHER
|T4-BOX-26-PRT|CPP/QPP Earnings Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-28-CPP-PRT|CPP Exempt Indicator|Not specified|Information only, do not set up this identifier
|T4-BOX-28-QPP-PRT|QPP Exempt Indicator |Not specified|Information only, do not set up this identifier
|T4-BOX-28-EI-PRT|EI Exempt Indicator|Not specified|Information only, do not set up this identifier
|T4-BOX-28-PPIP-PRT|PPIP Exempt Indicator|Not specified |Information only, do not set up this identifier
|T4-BOX-29-PRT|Employment Code|Not specified|Information only, do not set up this identifier
|T4-BOX-44|Union Dues|Element|T4-BOX-44
|T4-BOX-44-PRT|Union Dues Printed|Not specified |Information only, do not set up this identifier
|T4-BOX-46|Charitable Donations|Element|T4-BOX-46
|T4-BOX-50-REG1|RPP Registration Number 1|Data Base Column|constant, must be numeric
|T4-BOX-50-REG2|RPP Registration Number 2|Data Base Column|constant, must be numeric
|T4-BOX-50-REG3|RPP Registration Number 3|Data Base Column|constant, must be numeric
|T4-BOX-50-REG4|RPP Registration Number 4|Data Base Column|constant, must be numeric
|T4-BOX-50-REG5|RPP Registration Number 5|Data Base Column|constant, must be numeric
|T4-BOX-50-RPP1|RPP Amount 1|Element|T4-BOX-50-RPP1
|T4-BOX-50-RPP2|RPP Amount 2|Element|T4-BOX-50-RPP2
|T4-BOX-50-RPP3|RPP Amount 3|Element|T4-BOX-50-RPP3
|T4-BOX-50-RPP4|RPP Amount 4|Element|T4-BOX-50-RPP4
|T4-BOX-50-RPP5|RPP Amount 5|Element|T4-BOX-50-RPP5
|T4-BOX-50-PRT|RPP or DPSP Plan Number Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-52|Pension Adjustment|Element|T4-BOX-52
|T4-BOX-55|PPIP Employee Premium|Element|T4-BOX-55
|T4-BOX-55-ER|PPIP Employer Premium|Element|T4-BOX-55-ER
|T4-BOX-56|PPIP Insurable Earnings|Element|T4-BOX-56
|OTHER-30|Housing, Board and Lodging|PC or Element|T4-BOX-OTH-30
|OTHER-31|Special work site|PC or Element|T4-BOX-OTH-31
|OTHER-32|Travel in prescribed zone|PC or Element|T4-BOX-OTH-32
|OTHER-33|Medical travel|PC or Element|T4-BOX-OTH-33
|OTHER-34|Personal use of employer auto|PC or Element|T4-BOX-OTH-34
|OTHER-35|Reasonable KM allowance|PC or Element |T4-BOX-OTH-35
|OTHER-36|Interest free loan|PC or Element|T4-BOX-OTH-36
|OTHER-37|Home relocation loan deduction|PC or Element|T4-BOX-OTH-37
|OTHER-38|Stock option benefits|PC or Element|T4-BOX-OTH-38
|OTHER-39|Stock option 110(1)(d)|PC or Element|T4-BOX-OTH-39
|OTHER-40|Other Taxable benefits|PC or Element|T4-BOX-OTH-40
|OTHER-41|Stock option 110(1)(d.1)|PC or Element|T4-BOX-OTH-41
|OTHER-42|Employment Commissions|PC or Element|T4-BOX-OTH-42
|OTHER-53|Deferred stock option benefits|PC or Element|T4-BOX-OTH-53
|OTHER-70|Officer expense allowance|PC or Element|T4-BOX-OTH-70
|OTHER-71|Status Indian employee|PC or Element|T4-BOX-OTH-71
|OTHER-72|Section 122.3 income|PC or Element|T4-BOX-OTH-72
|OTHER-73|Number of days outside Canada|PC or Element|T4-BOX-OTH-73
|OTHER-74|Pre 1990 Past Serv-Contributor|PC or Element|T4-BOX-OTH-74
|OTHER-75|Pre 1990 Past Serv-Not Contributor|PC or Element|T4-BOX-OTH-75
|OTHER-77|Workers Compensation repaid|PC or Element|T4-BOX-OTH-77
|OTHER-78|Fishers Gross earnings|PC or Element|T4-BOX-OTH-78
|OTHER-79|Fishers Net partnership amt|PC or Element|T4-BOX-OTH-79
|OTHER-80|Fishers Shareperson amt|PC or Element |T4-BOX-OTH-80
|OTHER-81|Placement Agency Earnings|PC or Element|T4-BOX-OTH-81
|OTHER-82|Drivers Earnings|PC or Element|T4-BOX-OTH-82
|OTHER-83|Barbers Earnings|PC or Element|T4-BOX-OTH-83
|OTHER-84|Public Transit Pass|PC or Element|T4-BOX-OTH-84
|OTHER-85|EE prem private health plan|PC or Element|T4-BOX-OTH-85
|OTHER-86|Security Options selections|PC or Element|T4-BOX-OTH-86
|OTHER-87|Emergency services volunteer exempt amount|PC or Element|T4-BOX-OTH-87
|OTHER-88|Indian (exempt income)|PC or Element|T4-BOX-OTH-88
|OTHER-97|Stock option benefit-before Feb 28, 2000|PC or Element|T4-BOX-OTH-97
|OTHER-98|Stock dedn 110(1)(d)-before Feb 28, 2000|PC or Element|T4-BOX-OTH-98
|OTHER-99|Stock dedn 110(1)(d.1)-before Feb 28, 2000|PC or Element|T4-BOX-OTH-99
|SUB-REF-ID|Submission Reference ID|Constant|Unique number for each filing
IDIF is set up to use GVT Run Number for Submission Reference ID as default, if users want to override the GVT Run Number, then enter the value in this IDFDV Identifier and manually change the IDIF set up for the <sbmt_ref_id> tag to pick up the Variable Name from IDFDV Identifier with this SUB-REF-ID sequence
|FILE-TYPE-CODE|Transmitter Type Code|Constant|Constant '904' for T4
|FILE-DATA-TYPE|Data Type Code|Constant|1
|FILE-TRAN-NUM|Transmitter number|Constant|MM999999
|FILE-TRAN-TYPE|Transmitter type indicator|Constant|1
|FILE-TRAN-NAME1|Transmitter Name - line 1|Constant|Enter your company data
|FILE-TRAN-NAME2|Transmitter Name - line 2|Constant|Enter your company data
|FILE-TRAN-ADDR1|Transmitter Address - line 1|Constant|Enter your company data
|FILE-TRAN-ADDR2|Transmitter Address - line 2|Constant|Enter your company data
|FILE-TRAN-CITY|Transmitter City|Constant|Enter your company data
|FILE-TRAN-PROV|Transmitter Province|Constant|Enter your company data
|FILE-TRAN-COUNTRY|Transmitter Country|Constant|Enter your company data
|FILE-TRAN-POSTAL|Transmitter Postal Code|Constant|Enter your company data
|FILE-CONT-NAME|Technical contact name|Constant|Enter your company data
|FILE-CONT-TEL-AREA|Technical contact tel area code|Constant|111
|FILE-CONT-TEL|Technical contact telephone|Constant|2223333
|FILE-CONT-TEL-EXT|Technical contact tel extn|Constant|1234
|FILE-CONT-LANG|Technical contact Language|Constant|E
|FILE-CONT-EMAIL|Contact E-mail address|Constant|Enter your company data
At line 310 added one line
At line 186 changed one line
* Derivation Expression = decode(~,'Election Worker','Y','Self Employed','Y','N') \\ \\
* Derivation Expression = decode(~,'Election Worker','Y',‘Self Employed’,'Y','N') \\ \\
At line 201 changed one line
If a user wants to use the Employer Primary Address, the user does not need to set up the 1220 - 1270 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.
If a user wants to use the Employer Primary Address, the user does not need to set up the 1220 – 1270 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.
At line 204 changed one line
||Seq #||Field Identifier||Description||Field Variable
||Seq||Field Identifier||Description||Field Variable
At line 216 changed 2 lines
* If an Address was set up and if 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, then the T4-ER-MAG-PROV Identifier should be set to ZZ - Other. \\
* If an Address was set up prior to 2006, and if the word MAIL is defined, the mailing address will be used, otherwise the primary address will be used.
* If the Country Code is not Canada or USA, then the T4-ER-MAG-PROV Identifier should be set to ZZ – Other. \\
At line 220 changed one line
If a user wants to use the Employee Primary Address, the user does not need to set up the 2100 - 2170 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.
If a user wants to use the Employee Primary Address, the user does not need to set up the 2100 – 2170 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.
At line 223 changed one line
||Seq #||Field Identifier||Description||Field Variable
||Seq||Field Identifier||Description||Field Variable
At line 235 changed 2 lines
* If an Address was set up and if 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, then the T4-EE-MAG-PROV Identifier should be set to ZZ - Other.
* If an Address was set up prior to 2006, and if the word MAIL is defined, the mailing address will be used, otherwise the primary address will be used.
* If the Country Code is not Canada or USA, then the T4-EE-MAG-PROV Identifier should be set to ZZ – Other.
At line 239 changed one line
* Users can print a specific Province, or all Provinces. If all Provinces are to be printed, the Print Program will print a T4 form for each province that an employee has worked in.
*Users can print a specific Province, or all Provinces. If all Provinces are to be printed, the Print Program will print a T4 form for each province that an employee has worked in.
At line 241 changed one line
* If an employee is paid by multiple government registrations, then multiple T4 slips are produced, by government registration number, for the employee.
*If an employee is paid by multiple government registrations, then multiple T4 slips are produced, by government registration number, for the employee.
At line 243 changed one line
* T4 slips are printed in alphabetical order by the employee's Surname, First Name, within a government registration number.
*T4 slips are printed in alphabetical order by the employee's Surname, First Name, within a government registration number.
At line 245 changed one line
* The font size for printing T4 slips is the standard 10 or 12 character per inch font, character mode.
*The font size for printing T4 slips is the standard 10 or 12 character per inch font, character mode.
At line 247 changed one line
* Negative (credit) amounts are never allowed for T4 reporting. If negative amounts are encountered, an exception message is printed and users must resolve the negative amount(s) and re-run the process.
*Negative (credit) amounts are never allowed for T4 reporting. If negative amounts are encountered, an exception message is printed and users must resolve the negative amount(s) and re-run the process.
At line 249 changed one line
* 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.
*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 251 changed 2 lines
* Users can sort inactive and active employees separately for mailing purposes.
** If the Employment Status is A (Active) then the employee is considered active, otherwise the employee is considered inactive.
*Users can sort inactive and active employees separately for mailing purposes.
At line 254 changed one line
* The T4 slip has an "Other Information" area to report up to 6 footnote codes and amounts for each form.
*If the Employment Status is A (Active) then the employee is considered active, otherwise the employee is considered inactive.
At line 390 added 2 lines
*The T4 slip has an "Other Information" area to report up to 6 footnote codes and amounts for each form.
At line 260 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 T4 slips are also generated by Province.
*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 T4 slips are also generated by Province.
At line 262 changed one line
* 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.
*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.
At line 264 changed one line
* 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 alphanumeric fields are left justified with no space between each character, such as JOHN DOE, not J O H N D O E.
At line 266 changed one line
* The numeric fields are lined up with the decimal.
*The numeric fields are lined up with the decimal.
At line 268 changed one line
* T4 grand totals are generated for all T4 forms as Execution Run Log Exception Messages to balance to the RPYEC Summary report
*T4 grand totals are generated for all T4 forms as Execution Run Log Exception Messages to balance to the RPYEC Summary report
At line 270 changed one line
*Users __MUST__ run the RMEX report with the RPT4W run Mex ID to print the T4 grand totals to verify all records are printed.
*Users __MUST__ run the RMEX report with the RPT4/RPT4W run Mex ID to print the T4 grand totals to verify all records are printed.
At line 273 changed one line
[{InsertPage page='RPYEC'}]
!RPYEC - Cdn Year End Summary Report - Selection Criteria
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 275 changed one line
[{InsertPage page='RPGRC'}]
* This report is used to balance to the Year-To-Date Register (RPREGT)
* Users must check the exception messages from this Summary Report and correct any exceptions
* Generate the T4 File in the federal format
* Generate the XML file to populate the T4 Print Programs to print the T4 Forms for all processed employees
At line 418 added 22 lines
! RPYEC Report Parameters
||Field||Desciption
|Form Code|Mandatory. Form Code that is defined on the IDFDV form.\\NOTE: Always use current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. \\For 2017-2018 reporting, the current year form code contains the Store Option field to store the Employer Addresses, Employee Addresses and Amounts in the government remittance tables, which can be viewed on the IPGR or IPGH forms.
|Period Type|Enter the Year for Annual Reporting
|Period End Date|Enter the Year Ending Date
|As of Date|The start date of the reporting period
|Govt Form Option|Mandatory. Defines the type of form to be run. Options are: \\* 01: New Forms only \\* 02: All normal forms \\* 03: Duplicte forms \\* 04: Amended forms \\* 05: Rejected forms \\* 06: Cancelled forms
|Retain Amend/Reject Forms|Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government?
|Sort Level By|Mandatory. How should the employees be grouped for sorting?
|Sort People By|Mandatory. How should the employees on the report be sorted?
|Sort Active/Inactive|Mandatory. Should the employees on the report be sorted by their status?
|Combine Fed Regist|Should all the selected Federal Registrations reporting be combined? \\If a Province code is defined in the report filters, users can combine the Fed Registration Numbers with the Prov Registration Numbers so that employees are grouped together for the same Prov Registration Numbers.
|Directory Name|The name of the directory where the government Magnetic Media file will be stored.
|File Name|The name of the government Magnetic Media file
|Trace Level|Users should always run RPYEC with the Trace Level set to Exceptions Only for all employees.\\ \\If there is problem in RPYEC and a user needs to determine which employee has the problem, the user should run RPYEC with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem. \\ \\When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statements by running RMEX for the RPYEC Execution ID. \\ \\After determining which employee has the problem, users should run RPYEC for one employee with the Trace Level set to Utility Trace to determine the problem in detail.
|Regist/Set Up Audit|Option to print exceptions that may exist from set up. Options are:\\* 00:Do not print, run \\* 01: Print, do not run \\* 02: Print and Run \\* 03: Excp and run
|Print Employee Detail|Option to print the report with employee’s detailed information
|Trial Print Only|Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed. \\When set to Yes, the field will not be updated. \\When set to No, the Print Stage will be changed to Forms Printed.
|Create Trace File|To generate trace files. One file is for dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages.
|Create Data Dump|When set to Yes, the RPYEC process will generate data dump files with a .csv extension for the Federal information. Users can open these data dump files in Excel for debugging and balancing purposes.
|Process Remittance|To generate monthly remittances
|Update Remittance|To update monthly remittances
At line 441 added 75 lines
!RPYEC Report Filters
||Field||Desciption
|Entity|To define and report on a specific Entity
|Federal Regist Set|To define and report on a specific Federal Registration Set (on IDGV)
|Federal Regist Number|Employer Identification Number (on IDGV)
|People List|This field limits the process to the people in the defined list.
|Person|Person Code of employee you are testing with
|Prov Regist Set|To define and report on a specific Provincial Registration Set (on IDGV). Not required for Annual reporting.
|Prov Regist Numbers|To define and report on a specific Province Registration Number.
__Notes for RPYEC__
* The RPYEC process produces a Summary Total Report by Government Registrations. Users must balance this report to the RPREGT report.
* Each RPYEC run generates one Government Run Number (GVT Run).
* 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 generated GVT Run Number.
* After RPYEC is run, users can go into the IPGR (Government Run) form to view the details by GVT Run Number.
* On the IPGR form, the employee’s detail government reporting information can be viewed. Alternately, users can go directly to the IPGH (Government Header) form by employee to view this information.
* Alternately, users can go directly to IPGH (Government Header) inquiry form by employee
* Users can process 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's Government Header information are re-generated by subsequent RPYEC runs if the Government Header has not been filed to the government. The same IPGH information is removed automatically when a new IPGH is re-generated.
* At the end of each run, RPYEC removes any GVT Run Number that does not have GVT Header associated with it.
* Users can run the RPYEC process concurrently for different sets of employees.
* At the beginning of the RPYEC run, the Execution Run Log is stamped with the Execution Start Date. At the end of RPYEC run, the Execution End Date is stamped.
* For concurrent RPYEC runs that have not been finished with the Execution End Date, any other concurrent RPYEC runs will not remove the GVT Run Number, even if there are no GVT Headers.
!!Canadian Government Reporting - RPGRC
This is the Government Payroll Reporting for Canada. This process reads the Government Reporting table information generated by the RPYEC process. \\ \\
A Summary Total Report, by government registration, or by employee detail, for a selected Form Code, as defined on IDFDV, is generated. \\ \\
Users should run the [RPGRC] process to generate the:
* Internal xml files for the Form Print programs, such as RPT4 and RPT4W/RPT4AW, to print the T4 and T4A forms
* Magnetic Media xml file to submit to the government. The government requires users to validate the government xml file according to the downloaded government xml schema, using a validating parser prior to submitting it to the government.
Each RPGRC run generates one GVT Run (Government Run Number). All employees processed by the RPGRC run belong to this GVT Run Number. \\ \\
After RPGRC is run, users can go into the IPGR form to view the details by GVT Run number. \\ \\
On the IPGR form, the employee’s detail government reporting information can be viewed. Alternately, users can go directly to the IPGH (Government Header) form by employee to view this information. \\ \\
Users can process many RPGRC runs for different sets of employees. This generates multiple GVT Run Numbers. \\ \\
At the end of each run, the RPGRC process removes any GVT Run Number that does not have GVT Headers associated with it. \\ \\
Once the government xml file is generated, it is ready for an xml parser validation prior to sending the file to the government.
!RPGRC Report Parameters
||Field||Description
|Form Code|Mandatory. Form Code that is defined on the IDFDV form.\\NOTE: Always use current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. \\ \\For 2017-2018 reporting, the current year form code contains the Store Option field to store the Employer Addresses, Employee Addresses and Amounts in the government remittance tables, which can be viewed on the IPGR or IPGH forms.
|Govt Interface Format|Enter HL$CAN-T4-YYYY\\This Interface Format is defined on the IDIF form and is provided in our software
|Period Type|Enter the Year for Annual Reporting
|Period End Date|Enter the Year Ending Date
|As of Date|The start date of the reporting period
|Govt Form Option|Mandatory. Defines the type of form to be run. Options are: \\* 01: New Forms only \\* 02: All normal forms \\* 03: Duplicte forms \\* 04: Amended forms \\* 05: Rejected forms \\* 06: Cancelled forms
|Sort Level By|Mandatory. How should the employees be grouped for sorting?
|Sort People By|Mandatory. How should the employees on the report be sorted?
|Sort Active/Inactive|Mandatory. Should the employees on the report be sorted by their status?
|Directory Name|The name of the directory where the government Magnetic Media file will be stored.
|File Name|The name of the government Magnetic Media file
|Trace Level|Users should always run RPYEC with the Trace Level set to Exceptions Only for all employees. \\ \\If there is problem in RPYEC and a user needs to determine which employee has the problem, the user should run RPYEC with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem. \\ \\When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statements by running RMEX for the RPYEC Execution ID. \\ \\After determining which employee has the problem, users should run RPYEC for one employee with the Trace Level set to Utility Trace to determine the problem in detail.
|Print Employee Detail|Option to print the report with employee’s detailed information
|Trial Print Only|Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed. \\When set to Yes, the field will not be updated. \\When set to No, the Print Stage will be changed to Forms Printed.
|Create File|To generate trace files. One file is for dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages.
!RPGRC Report Filters
||Field||Description
|GVT Run Number|Enter the GVT Run Number from the RPYEC run
|Entity|To define and report on a specific Entity
|Federal Regist Set|To define and report on a specific Federal Registration Set (on IDGV)
|Federal Regist Number|Employer Identification Number (on IDGV)
|People List|This field limits the process to the people in the defined list.
|Person|Person Code of employee you are testing with
|Prov Regist Set|To define and report on a specific Provincial Registration Set (on IDGV). Not required for Annual reporting.
|Prov Regist Numbers|To define and report on a specific Province Registration Number.
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 281 changed one line
The RPT4W and RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. __Pre-printed forms are not required.__\\
Once the year-to-date information is correct, run the RPT4/RPT4W report to print the T4 Forms.
At line 283 changed one line
Once the year-to-date information is correct, run the RPT4W report to print the T4 Forms.
* This report completes and prints the T4 forms, as well as the T4 Media file, based on the parameter selections
* Produces the T4 Forms
* Users should write down the Execution ID of the RPT4/RPT4W run and run RMEX to obtain the grand total report
At line 285 changed 2 lines
* This function generates and prints the T4 forms, as well as the T4 Media file, based on the parameter selections
* Users should write down the Execution ID of the RPT4W run and run RMEX to obtain the grand total report for the T4s printed by RPT4W
For Oracle Reports, before running any reports, users must define the Destination Format as PDF on the 'Run Options' tab. \\ \\
At line 527 added 2 lines
Users should run all Government Form Print programs, such as RPT4, RPT4W, RPT4AW, RPT4ANRW, RPNR4, RPRL1, RPRL2 with this setting. \\ \\
All T4 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 will not need to adjust the Page Set up when printing. \\ \\
At line 531 added one line
%%warning IMPORTANT: When printing from the pdf file, users must set the Page Sizing and Handling to “Actual Size” to print on the pre-printed government forms to avoid re-sizing of the form.%%
At line 292 changed one line
!RPT4W Report Parameters
!RPT4 Report Parameters __* Oracle Report Only * __
At line 294 changed 4 lines
|Print T4 Copy|Defines if the Employer or Employee copy will be printed. Options are: \\*01: Employer Copy. Prints 2 employees on one page. Use as the Employer Copy to send to government or keep for reference. \\*02: Employee Copy. Prints 1 employee 2 times on 1 page. Use as the Employee Copy to distribute to the employees
|Duplicate/Amended|Optional. Defines the text to print on the T4 form to indicate if it is a 'Duplicate' or an 'Amended' copy.
|Include Back Information|When set to YES, the report will print the information from the back of the T4.
|Trial Print only|Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed. \\When set to Yes, the field will not be updated. \\When set to No, the Print Stage will be changed to Forms Printed. \\Optional.
|Print T4 Copy|Defines if the Employer or Employee copy will be printed. Options are: \\*01: Employer Copy. Prints 3 employees on one page. Use as the Employer Copy to send to government or keep for reference. \\*02: Employee Copy. Prints 1 employee 3 times on 1 page. Use as the Employee Copy to distribute to the employees
At line 299 changed one line
|Duplicate/Amended|Optional. Defines the text to print on the T4 form to indicate if it is a 'Duplicate' or an 'Amended' copy.
|Test Form Set-Up|Allows users to test their printer set up prior to printing the actual T4 forms. \\High Line recommends all users should run RPT4 with this toggle set to YES to print a sample on the actual T4 form to confirm the correct margin page set up. \\Users should do a printer set up test each time a different printer is used.\\Optional
|Trial Print only|When this toggle is set to YES, users can print T4 forms for verification. When set to NO (non-trial mode), RPT4 updates the GVT Headers Govt Print Stage of the run. \\Optional.
|Show T4 Form|Allows users the option to print the T4s with the form set up lines. \\ \\When users are running RPT4 for the actual T4 form printing, __DO NOT__ set this toggle to ON. \\ \\The downloaded form is for viewing and testing purpose only and should not be used to submit to the government or distributed to the employees. Users must print the T4s on the pre-printed forms provided by the government as these forms contain the correct wording on the back of the form. \\Optional. Default is NO.
|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 generated from RPGRC with the _HL.xml extension.
|Slips Per Segment|Defines how many forms to print before breaking and totaling. \\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 must define this field. \\Optional.
|Adjust Top Margin|Defines the adjustment spacing for the Top Margin when printing the T4 form\\ \\Users should default to NULL or '00 - 0 line' adjustment to begin testing\\ \\After the PDF file is generated, print one page on blank paper, align the paper with the pre-printed form and check if the alignment fits into the box\\ \\If adjustment is needed, re-run RPT4 by entering the Top Margin adjustment. \\From Lexicon [Top Margin Adjust.|X_TOP_MARGIN_ADJ] \\Optional.
|Between Form Space|Defines the adjustment spacing between 2 forms printed on the same page\\ \\Users should default to NULL or '0 - 0 line space' to begin testing\\ \\After the PDF file is generated, print one page on blank paper, align the paper with the pre-printed form and check if the alignment fits between 2 forms\\ \\If adjustment is needed, re-run RPT4 by entering the 'Between Form Space'. From Lexicon [Between Form Space|X_BTWN_FORM_SPACE] \\Optional.
|Show Frame (Test Only)|Allows users the option to print the T4s with the form set up lines. Default is NO. \\ \\When users are running RPT4 for the actual T4 form printing, __DO NOT__ set this toggle to ON. \\The downloaded form is for viewing and testing purpose only and should not be used to submit to the government or distributed to the employees. Users must print the T4s on the pre-printed forms provided by the government as these forms contain the correct wording on the back of the form.
At line 550 added 22 lines
__NOTE:__ If the combination of Adjust Top Margin and Between Form Space pushes the Form to go over onto 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 options.
!RPT4 Report Filters
||Field||Description
|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.
__Execution Report__
* Produces the grand total report from RPT4/RPT4W by running RMEX for the execution ID of T4 run.
* Enter the Execution ID of the RPT4/RPT4W run to generate a grand total report and balance to the RPYEC report.
!RPT4W Report Parameters __* Windward Report Only* __
||Field||Description
|Print T4 Copy|Defines if the Employer or Employee copy will be printed. Options are: \\*01: Employer Copy. Prints 3 employees on one page. Use as the Employer Copy to send to government or keep for reference. \\*02: Employee Copy. Prints 1 employee 3 times on 1 page. Use as the Employee Copy to distribute to the employees
|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.
|Test Form Set-Up|Allows users to test their printer set up prior to printing the actual T4 forms. \\High Line recommends all users should run RPT4 with this toggle set to YES to print a sample on the actual T4 form to confirm the correct margin page set up. \\Users should do a printer set up test each time a different printer is used.\\Optional
|Trial Print only|When this toggle is set to YES, users can print T4 forms for verification. When set to NO (non-trial mode), RPT4 updates the GVT Headers Govt Print Stage of the run. \\Optional.
|Show T4 Form|Allows users the option to print the T4s with the form set up lines. \\ \\When users are running RPT4 for the actual T4 form printing, __DO NOT__ set this toggle to ON. \\ \\The downloaded form is for viewing and testing purpose only and should not be used to submit to the government or distributed to the employees. Users must print the T4s on the pre-printed forms provided by the government as these forms contain the correct wording on the back of the form. \\Optional. Default is NO.
At line 303 changed 4 lines
|GVT Run|Mandatory. Defines the GVT Run number to extract data from and produce the T4 form.
|Person|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.
|People List|Optional. A people list may be used to indicate specific employees that are to be processed.
|Status Type|Optional. Allows organizations to print forms for a defined Status Type. Options are: \\* Active \\* Cobra \\* Inactive \\* Leave \\*Pending \\*Retired \\*Survivor \\* Terminated \\*Unpaid Leave
|GVT Run (WW Only)|Mandatory (when running Windward report only). Defines the GVT Run number to extract data from and produce the T4 form.
|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.
|Status Type|Optional. Defines the pre-defined generic statuses allowing users to categorize the employment status into a specified type.
At line 578 added one line
At line 309 changed 2 lines
* Produces the grand total report from RPT4W by running RMEX for the execution ID of T4 run.
* Enter the Execution ID of the RPT4W run to generate a grand total report and balance to the RPYEC report.
* Produces the grand total report from RPT4/RPT4W by running RMEX for the execution ID of T4 run.
* Enter the Execution ID of the RPT4/RPT4W run to generate a grand total report and balance to the RPYEC report.
At line 314 changed 2 lines
!RPT4W Form Print Processing
The RPT4W and RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. __Pre-printed forms are not required.__ \\
!RPT4/RPT4W Form Print Processing
At line 317 changed one line
The RPT4W Program Print Format is based on the Government published T4 (19) Form. \\ \\
The RPT4/RPT4W Program Print Format is based on the Government published T4 (15) Form. High Line recommends using the same form version as the RPT4/RPT4W program. \\ \\
At line 319 changed one line
* The RPT4W Form Print program prints all information retrieved from the RPYEC GVT Run Number.
If you are using other versions of the T4 form, such as T4(14), please test the RPT4/RPT4W form layout prior to printing. If the RPT4/RPT4W program does not align with the form, users should re-order the form from the government so it is the same version that the RPT4/RPT4W process is programmed for. \\ \\
* The RPT4/RPT4W Form Print program prints all information retrieved from the RPGRC xml file, according to the selection criteria.
At line 322 changed 3 lines
* The RPT4W program generates Summary Totals, by each Business Number, at the end of the RPT4W run. A grand total is generated for all Business Numbers of the run.
* Users must run RMEX with the RPT4W Mex ID to obtain the summary and grand totals for the T4s printed using the RPT4W.
* The RPT4W summary and grand totals are accumulated for the Boxes shown on the T4 Form. The footnote codes are not totaled.
* The RPT4/RPT4W program generates Summary Totals, by each Business Number, at the end of the RPT4/RPT4W run. A grand total is generated for all Business Numbers of the run.
* Users must run RMEX with the RPT4/RPT4W Mex ID to obtain the summary and grand totals to balance to the RPYEC Summary report.
* The RPT4/RPT4W summary and grand totals are accumulated for the Boxes shown on the T4 Form. The footnote codes are not totaled.
* Users should verify the RPT4/RPT4W Boxes balance to the RPYEC report.
At line 326 changed 2 lines
!Form Printing
When printing T4 forms, users are required to print the Employer Copy and Employee Copy of the T4s.
If the RPT4/RPT4W process cannot select any information from the xml file to print, users must run RMEX with the RPT4/RPT4W 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 329 changed 2 lines
* When RPT4W is run, the "Print T4 Copy" parameter defines if the Employer or the Employee Copy should be printed.
* Users must run RPT4W twice; once to print the Employer Copy, and once to print the Employee Copy
!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.
* When RPT4/RPT4W is run, the "Print T4 Copy" parameter defines if the Employer or the Employee Copy should be printed.
* Users must run RPT4/RPT4W twice; once to print the Employer Copy, and once to print the Employee Copy
At line 352 changed one line
* RPGRC retrieves all GVT Headers with the Print Stage of 'Duplicate Requested' and generates the HL xml file for the Form Print RPT4W, RPT4AW, RPRL1W programs
* RPGRC retrieves all GVT Headers with the Print Stage of 'Duplicate Requested' and generates the HL xml file for the Form Print RPT4, RPT4W, RPT4AW, RPRL1 programs
At line 357 changed 2 lines
3. Run RPT4W to print the duplicate forms
* Run the Form Print RPT4W programs to read the RPYEC GVT Run Number to print duplicate forms
3. Run RPT4/RPT4W to print the duplicate forms
* Run the Form Print RPT4/RPT4W programs to read the HL xml file from RPGRC to print the duplicate forms
At line 360 changed one line
* Users can re-run the Form Print program for the Employee or the Employer Copy from the same GVT Run Number. The GVT Header stage will be updated to 'Duplicate Printed' depending on the 'Trial Print Only' field setting.
* Users can re-run the Form Print program for the Employee or the Employer Copy from the same HL xml file. The GVT Header stage will be updated to 'Duplicate Printed' depending on the 'Trial Print Only' field setting.
At line 364 changed one line
If a user discovers erroneous box information on the T4 form and needs to revise the Box information, users should either correct the employee amounts or modify the IDFDV set up and then re-run the RPYEC, RPGRC and RPT4W processes. This produces the Amended T4 form.
If a user discovers erroneous box information on the T4 form and needs to revise the Box information, users should either correct the employee amounts or modify the IDFDV set up and then re-run the RPYEC, RPGRC and RPT4/RPT4W processes. This produces the Amended T4 form.
At line 368 changed one line
1. Update the employee's YTD information through payroll.
1. Update the employee’s YTD information through payroll.
At line 375 changed 2 lines
* 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.
* 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.
At line 382 changed 2 lines
* 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.
* 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/RPT4W print program.
At line 389 changed 4 lines
5. Run RPT4W to print the Amended forms.
* When the user is running RPT4W with the new GVT Run Number, RPT4/RPT4W 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 RPT4W, such as CANCEL COPY or ORIGINAL COPY.
* At the end of the RPT4W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage.
5. Run RPT4/RPT4W to print the Amended forms.
* When the user is running RPT4/RPT4W with the new _HL.xml file, RPT4/RPT4W 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/RPT4W, such as CANCEL COPY or ORIGINAL COPY.
* At the end of the RPT4/RPT4W run in non-trial mode, the GVT Header Stage will be updated with either the DUPLICATE or AMENDED stage.
At line 670 added 10 lines
!RPT4/RPT4W Void Forms
* After the T4 slips are printed, the RPT4/RPT4W process will generate an intermediate Summary Total for 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/RPT4W is run, if there is more than one Government Registration Number from IDGR:
** The T4 forms will be sorted by Government Registration Numbers
** RPT4/RPT4W 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 402 changed one line
|Trial|When set to ON, allows users to review the report for verification prior to running the undo process. \\In non-trial mode, UPGRUNDO removes GVT Headers and GVT Run for the qualified GVT Run.\\Optional.
|Trial|When set to ON, allows users to review the report for verification prior to running the undo process. \\ \\In non-trial mode, UPGRUNDO removes GVT Headers and GVT Run for the qualified GVT Run.\\Optional.
At line 429 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. 19" 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 435 changed one line
||Seq #||Field Identifier||Description||Field Variable
||Seq||Field Identifier||Description||Field Variable
At line 447 changed one line
*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 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.
At line 451 changed one line
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. \\ \\
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 458 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|2200 |T4-BOX-SIN|EID.GOVERNMENT_CODE
||Field Identifier||Suggested Field Variable
|T4-BOX-SIN|EID.GOVERNMENT_CODE
At line 466 changed 4 lines
||Seq #||Field Identifier||Suggested Field Variable
|2000 |T4-EE-NAME1|EID.LAST_NAME
|2030 |T4-EE-NAME2|EID.FIRST_NAME
|2040 |T4-EE-NAME3|EID.MIDDLE_NAME \\ \\
||Field Identifier||Suggested Field Variable
|T4-EE-NAME1|EID.LAST_NAME
|T4-EE-NAME2|EID.FIRST_NAME
|T4-EE-NAME3|EID.MIDDLE_NAME \\ \\
At line 473 changed one line
||Seq #||Field Identifier||Description||Field Variable
||Seq||Field Identifier||Description||Field Variable
At line 485 changed one line
*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 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.
At line 491 changed 5 lines
||Seq #||Field Identifier||Field Variable||Suggested Field Variable
|2210 |T4-EE-DISTR|Constant|Blank or 1
|2215 |T4-EE-DESTIN|Constant|Blank or 1
|2220 |T4-EE-DISTR1| |DED.ENTITY_CODE
|2230 |T4-EE-DISTR2| |EID.PERSON_CODE
||Field Identifier||Field Variable||Suggested Field Variable
|T4-EE-DISTR|Constant|Blank or 1
|T4-EE-DESTIN|Constant|Blank or 1
|T4-EE-DISTR1| |DED.ENTITY_CODE
|T4-EE-DISTR2| |EID.PERSON_CODE
At line 508 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|3000 |T4-BOX-14|T4-BOX-14
||Field Identifier||Suggested Field Variable
|T4-BOX-14|T4-BOX-14
At line 514 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|3010 |T4-BOX-16|T4-BOX-16
||Field Identifier||Suggested Field Variable
|T4-BOX-16|T4-BOX-16
At line 523 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|3030 |T4-BOX-17|T4-BOX-17
||Field Identifier||Suggested Field Variable
|T4-BOX-17|T4-BOX-17
At line 532 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3040 |T4-BOX-18|T4-BOX-18
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-18|T4-BOX-18
At line 540 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3060 |T4-BOX-20|T4-BOX-20 \\ \\
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-20|T4-BOX-20 \\ \\
At line 545 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3070 |T4-BOX-22|T4-BOX-22 \\ \\
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-22|T4-BOX-22 \\ \\
At line 550 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3080 |T4-BOX-24|T4-BOX-24
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-24|T4-BOX-24
At line 564 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3090 |T4-BOX-26-CPP|T4-BOX-26-CPP \\ \\
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-26-CPP|T4-BOX-26-CPP \\ \\
At line 567 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3100 |T4-BOX-26-QPP|T4-BOX-26-QPP \\ \\
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-26-QPP|T4-BOX-26-QPP \\ \\
At line 570 changed 3 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3110 |T4-BOX-26-EXCEPT|T4-BOX-26-EXCEPT
|3120 |T4-BOX-26-OTHER|T4-BOX-26-OTHER
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-26-EXCEPT|T4-BOX-26-EXCEPT
|T4-BOX-26-OTHER|T4-BOX-26-OTHER
At line 607 changed one line
Users should verify the reported CPP/QPP Pensionable Earnings are correct according to the government specifications. \\ \\
Users should verify the reported CPP/QPP Pensionable Earnings are correct according to the government specifications. \\
At line 617 changed 5 lines
||Seq #||Field Identifier
|3130 |T4-BOX-28-CPP-PRT
|3140 |T4-BOX-28-QPP-PRT
|3150 |T4-BOX-28-EI-PRT
|3155 |T4-BOX-28-PPIP-PRT
||Field Identifier
|T4-BOX-28-CPP-PRT
|T4-BOX-28-QPP-PRT
|T4-BOX-28-EI-PRT
|T4-BOX-28-PPIP-PRT
At line 636 changed 3 lines
||Seq #||Field Identifier||
|3160 |T4-BOX-29-PRT|This is used for the XML file only
\\
||Field Identifier||
|T4-BOX-29-PRT|This is used for the XML file only
\\ \\
At line 642 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3180 |T4-BOX-44|T4-BOX-44
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-44|T4-BOX-44
At line 651 changed 3 lines
||Seq #||Field Identifier||Suggested Field Variable (Element)
|3190 |T4-BOX-46|T4-BOX-46
\\
||Field Identifier||Suggested Field Variable (Element)
|T4-BOX-46|T4-BOX-46
\\ \\
At line 657 changed 11 lines
||Seq #||Field Identifier||Suggested Field Variable||Suggested Field Variable (Element)
|3200 |T4-BOX-50-REG1|Constant|
|3210 |T4-BOX-50-REG2|Constant|
|3220 |T4-BOX-50-REG3|Constant|
|3230 |T4-BOX-50-REG4|Constant|
|3240 |T4-BOX-50-REG5|Constant|
|3205 |T4-BOX-50-RPP1| |T4-BOX-50-RPP1
|3215 |T4-BOX-50-RPP2| |T4-BOX-50-RPP2
|3225 |T4-BOX-50-RPP3| |T4-BOX-50-RPP3
|3235 |T4-BOX-50-RPP4| |T4-BOX-50-RPP4
|3245 |T4-BOX-50-RPP5| |T4-BOX-50-RPP5
||Field Identifier||Suggested Field Variable||Suggested Field Variable (Element)
|T4-BOX-50-REG1|Constant|
|T4-BOX-50-REG2|Constant|
|T4-BOX-50-REG3|Constant|
|T4-BOX-50-REG4|Constant|
|T4-BOX-50-REG5|Constant|
|T4-BOX-50-RPP1| |T4-BOX-50-RPP1
|T4-BOX-50-RPP2| |T4-BOX-50-RPP2
|T4-BOX-50-RPP3| |T4-BOX-50-RPP3
|T4-BOX-50-RPP4| |T4-BOX-50-RPP4
|T4-BOX-50-RPP5| |T4-BOX-50-RPP5
At line 675 changed 3 lines
||Seq #||Field Identifier||Suggested Field Variable
|3260 |T4-BOX-52|T4-BOX-52
Box 52 is rounded up to the nearest Dollar. No cents are printed. \\
||Field Identifier||Suggested Field Variable
|T4-BOX-52|T4-BOX-52
*Box 52 is rounded up to the nearest Dollar. No cents are printed. \\ \\
At line 681 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|3270 |T4-BOX-55|T4-BOX-55
||Field Identifier||Suggested Field Variable
|T4-BOX-55|T4-BOX-55
At line 687 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|3290 |T4-BOX-56|T4-BOX-56
||Field Identifier||Suggested Field Variable
|T4-BOX-56|T4-BOX-56
At line 699 changed 2 lines
||Seq #||Field Identifier||Suggested Field Variable
|4nnn|OTHER-nn|T4-BOX-OTH-nn
||Field Identifier||Suggested Field Variable
|OTHER-nn|T4-BOX-OTH-nn
At line 708 changed one line
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 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. \\
At line 710 changed one line
High Line delivers the IDIF form layout using Seed data along with the Year End release. Users do not need to modify this form
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 717 changed 2 lines
\\
A validating parser tool from any third party will perform the following checks on the government XML file generated by RPGRC: \\
A validating parser tool from any third party will perform the following checks on the government XML file generated by RPGRC:
At line 727 changed 4 lines
!!Electronic T4 Print Program
!Consent
The Canadian Government does not require employees to provide consent. As such, employees do not have to give consent in order to get their T4 forms online and the Electronic Consent logic has been removed. \\ \\
Organizations can now print the forms for selected employees using the new report parameter 'Status Type' and other existing report filters.
!!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). \\
At line 732 changed one line
Organizations can control the years the T4 forms are available for employees to print, by setting the EE_T4_GVT_RUN Preference on the IMST form.
Employees must run the RET4 process and select the Reporting Year they want to print. The output T4 will be in a pdf format. \\ \\
If an employee has chosen to receive electronic T4 forms, using either the consent WEPT4 or IEPT4 form, a paper copy is __NOT__ printed during the RPT4 T4 printing process. \\ \\
At line 734 changed 2 lines
!Employee T4’s – RET4 and BET4
The BET4 will produce current year T4’s only – if you’d like your employees to be allowed to print prior years, RET4 can be utilized – i.e. label the menu “T4 History”. The BET4 output of the T4 form will be in a pdf format. \\
Organizations can:
At line 737 changed one line
These functions can be added to the employee pay menu – or take advantage of the “Quick Links” to make this even easier.
* Manage the consent for employees to receive electronic T4 forms using the Maintain Employee T4 Consent (IEPT4) form.
* Control the years that T4 forms are available for employees to print, by setting a Preference on the IMST form, as below.
At line 740 changed 2 lines
__IMST__
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. \\
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).
At line 743 removed one line
The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567. \\ \\
At line 745 removed 28 lines
__Setup – RET4__\\
For RET4 2019:
# Run RPYEC
# RPGRC – note the gvt run# and the _HL.xml
# Ensure that the _HL.xml is on the directory used for both RPGRC and RPT4W
#IMST – set up the gvt run# that exists on the _HL.xml on the EE_T4_GVT_RUN preference
#RPT4W – use the _HL.xml and fill in with the same directory, data should be populated in the UT tables and show on the T4 form
#RET4 will default with 2019 and then launch
\\
For RET4 2018 and previous years
# Do NOT run RPYEC
# Do NOT run RPGRC – but note the 2018 _HL.xml and take note of the gvt run# from this file
#Ensure that the 2018 _HL.xml is on the directory used for RPT4W
#IMST – set up the gvt run# that exists on the 2018 _HL.xml on the EE_T4_GVT_RUN preference
#RPT4W – use the 2018 _HL.xml and fill in with directory that has the 2018 _HL.xml file, data should be populated in the UT tables and show on the T4 form
#RET4 will default with 2019, type in 2018 and then launch
__Setup – BET4__\\
For organizations that wish to use the BET4 process, the implementation steps below must be followed:
#The new function “BET4” MUST be added to the appropriate menu and provide execution rights to respective role and/or user
#The ‘T4_GVT_RUN’ lexicon is used to identify the government runs that will be available to the user, to select and print their T4 forms. Organizations should always maintain this record to ONLY have the official government run record.
*To update the lexicon, on the IMLN form, for the Lexicon Name ‘T4_GVT_RUN’, enter a unique value in the ‘Saved Value’ field, such as '01' and enter the Government Run number in the ‘Displayed’ value field.
This page (revision-70) was last changed on 19-Oct-2022 20:29 by Karen ParrottTop