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 50 removed one line
At line 120 removed one line
At line 129 removed one line
!!IDFDV Form Definition
At line 131 changed one line
!IDFDV - Copy Last Year's Definition to Current Year
!!IDFDV - Copy Last Year's Definition to Current Year
At line 296 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 298 changed one line
If a user has a complex situation to exclude an employee, a statistic can be used to indicate the employee is excluded. \\ \\
If a user has a complex situation to exclude an employee, a statistic can be used to indicate the employee is excluded. \\
At line 302 changed one line
Then on IDFDV set up the following for the EXCLUDE-EE Identifier:
Then on IDFDV, set up the following for the EXCLUDE-EE Identifier:
At line 308 changed 2 lines
__Primary and Mailing Addresses__
[Employer Address|]
__Primary and Mailing Addresses__\\
[Employer Address|]\\
At line 326 changed one line
* If the Country Code is not Canada or USA, then the T4-ER-MAG-PROV Identifier should be set to ZZ – Other.
* If the Country Code is not Canada or USA, then the T4-ER-MAG-PROV Identifier should be set to ZZ – Other. \\
At line 328 changed one line
[Employee Address|]
[Employee Address|]\\
At line 372 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 394 changed one line
|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.
|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.
At line 406 changed 2 lines
|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
|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
At line 455 changed one line
|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.
|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.
At line 466 changed one line
|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.
|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.
At line 499 changed one line
%%IMPORTANT: 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.%%
%%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 505 changed one line
|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
|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 541 removed one line
At line 553 changed one line
__Laser Form Printing__
__Laser Form Printing__\\
At line 572 changed 5 lines
To issue Duplicate Copies:
# Go to the IPGH form for the employee and highlight the form to be duplicated.
** Change the Print Stage to 'Duplicate requested'.
** Click Save
** Repeat for all employees who have requested duplicate copies.
To issue Duplicate Copies:\\
1. Go to the IPGH form for the employee and highlight the form to be duplicated.
* Change the Print Stage to 'Duplicate requested'.
* Click Save
* Repeat for all employees who have requested duplicate copies.
At line 578 changed 3 lines
# 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 of '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' field for RPGRC
2. 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 of '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' field for RPGRC
At line 582 changed 4 lines
# Run RPT4 or RPT4A to print the duplicate forms
** Run the Form Print RPT4 or RPT4A programs to read the HL xml file from RPGRC to print the duplicate forms
** At the end of the Form Print, if the 'Trial Print Only' field is set to No, the GVT Header stage will be updated to '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 'Duplicate Printed' depending on the 'Trial Print Only' field setting.
3. Run RPT4 or RPT4A to print the duplicate forms
* Run the Form Print RPT4 or RPT4A programs to read the HL xml file from RPGRC to print the duplicate forms
* At the end of the Form Print, if the 'Trial Print Only' field is set to No, the GVT Header stage will be updated to '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 'Duplicate Printed' depending on the 'Trial Print Only' field setting.
At line 594 changed 3 lines
# 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
1. Update the employee’s YTD information through payroll.
2. Check the IDFDV set up and revise the box information, if necessary
3. Go to the IPGH form for the employee. Locate the form to be amended
At line 607 changed one line
# Run RPGRC with the GVT Form Option set to Amended Forms
4. Run RPGRC with the GVT Form Option set to Amended Forms
At line 615 changed one line
# Run RPT4 to print the Amended forms.
5. Run RPT4 to print the Amended forms.
At line 625 changed one line
* When RPT4 is run, if there is more than one Government Registration Number from IDGR;
* When RPT4 is run, if there is more than one Government Registration Number from IDGR:
At line 657 changed one line
__Box - Year__From user defined Calendar Year YYYY
__Box - Year__\\From user defined Calendar Year YYYY \\ \\
At line 659 changed one line
__Box - Employer's Name and Address__
__Box - Employer's Name and Address__\\
At line 674 changed one line
*If the Country Code is not Canada or USA, the 2160 T4-EE-MAG-PROV Identifier should be set to 'ZZ-Other'. \\ \\
*If the Country Code is not Canada or USA, the 1280 T4-EE-MAG-PROV Identifier should be set to 'ZZ-Other'. \\ \\
At line 676 changed one line
__Box 54 - Business Number_
__Box 54 - Business Number__\\
At line 679 changed one line
__Box 10 - Province of Employment__
__Box 10 - Province of Employment__ \\
At line 682 changed one line
__Box 12 - Employee's Social Insurance Number__
__Box 12 - Employee's Social Insurance Number__\\
At line 690 changed one line
__Box - Employee's name__
__Box - Employee's name__ \\
At line 697 changed one line
__Box - Employee's address__
__Box - Employee's address__\\
At line 714 changed one line
__Box - Last line of Employee Address__
__Box - Last line of Employee Address__\\
At line 718 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 732 changed one line
__Box 14 - Employment Income__
__Box 14 - Employment Income__\\
At line 735 changed one line
|T4-BOX-14||T4-BOX-14
|T4-BOX-14|T4-BOX-14
At line 738 changed one line
__Box 16 - Employee's CPP Contributions__
__Box 16 - Employee's CPP Contributions__\\
At line 745 changed one line
\\ \\
\\
At line 747 changed one line
__Box 17 - Employee's QPP contributions__
__Box 17 - Employee's QPP contributions__\\
At line 754 changed one line
\\ \\
\\
At line 756 changed one line
__Box 18 - Employee's EI Premiums__
__Box 18 - Employee's EI Premiums__\\
At line 762 changed one line
\\ \\
\\
At line 764 changed one line
__Box 20 - RPP Contributions__
__Box 20 - RPP Contributions__\\
At line 769 changed one line
__Box 22 - Income Tax Deducted__
__Box 22 - Income Tax Deducted__\\
At line 774 changed one line
__Box 24 - EI Insurable Earnings__
__Box 24 - EI Insurable Earnings__\\
At line 788 changed one line
__Box 26 - CPP/QPP Pensionable Earnings__
__Box 26 - CPP/QPP Pensionable Earnings__\\
At line 833 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 843 changed 5 lines
||Field Identifier||
|T4-BOX-28-CPP-PRT|
|T4-BOX-28-QPP-PRT|
|T4-BOX-28-EI-PRT|
|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 849 changed 2 lines
\\ \\
__Box 29 - Employment Code__
\\
__Box 29 - Employment Code__\\
At line 863 changed one line
|T4-BOX-29-PRT|This is used for the XML file only \\ \\
|T4-BOX-29-PRT|This is used for the XML file only
\\ \\
At line 865 changed one line
__Box 44 - Union Dues__
__Box 44 - Union Dues__\\
At line 874 changed one line
__Box 46 - Charitable Donations__
__Box 46 - Charitable Donations__\\
At line 877 changed one line
|T4-BOX-46|T4-BOX-46 \\ \\
|T4-BOX-46|T4-BOX-46
\\ \\
At line 879 changed one line
__Box 50 - RPP or DPSP Registration Number__
__Box 50 - RPP or DPSP Registration Number__\\
At line 894 changed 2 lines
*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 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
At line 898 changed one line
__Box 52 - Pension Adjustment__
__Box 52 - Pension Adjustment__\\
At line 904 changed one line
__Box 55 - Employee's PPIP Premiums__
__Box 55 - Employee's PPIP Premiums__\\
At line 907 changed one line
|T4-BOX-55|T4-BOX-55 \\ \\
|T4-BOX-55|T4-BOX-55
\\
At line 909 changed one line
__Box 56 - PPIP Insurable Earnings__
__Box 56 - PPIP Insurable Earnings__\\
At line 919 changed one line
\\ \\
\\
At line 921 changed one line
__Box - Other Information__
__Box - Other Information__\\
At line 953 changed one line
If an employee chooses to receive electronic T4 forms, they must enter their consent in the My T4 Consent form (WEPT4). \\ \\
If an employee chooses to receive electronic T4 forms, they must enter their consent in the My T4 Consent form (WEPT4). \\
At line 964 changed one line
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 966 removed one line
The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567).
At line 968 removed one line
This page (revision-70) was last changed on 19-Oct-2022 20:29 by Karen ParrottTop