This document covers the following topics:
Balance initialization elements
Supported dimensions
Overview of tax– related balances
Balances that require initialization
Required Canadian legislative balances
Canadian users should run the Initial Balance Structure Creation process to create the elements and input values required to feed the predefined legislative balances. You may need to define additional elements and input values to set up initial balances for your own earnings and deductions.
The Canadian balance initialization process initializes balances with contexts of "Jurisdiction," "Tax Unit Id," and “Source ID” and for pay period, monthly and annual dimensions. The “Jurisdiction” is the Canada Post province abbreviation. The “Source ID” context is used for PMED (Provincial Medical), and WCB (Workers Compensation) balance types and must be set up prior to initializing balances. Data must be stored for each pay period (week, month, etc.) for the production of the Record of Employment (ROE).
The following balance dimensions (BD) are currently supported for Canada:
Assignment Default Run
Assignment Fiscal Quarter to Date
Assignment Fiscal Year to Date
Assignment Inception to Date
Assignment-Level Current Run
Assignment Lifetime to Date
Assignment Month
Assignment Pay Date
Assignment Payments
Assignment Payments in Jurisdiction
Assignment Period to Date
Assignment Quarter to Date
Assignment Year to Date
Assignment within Government Reporting Entity Inception to Date
Assignment within Government Reporting Entity Month
Assignment within Government Reporting Entity Pay Date
Assignment within Government Reporting Entity Period to Date
Assignment within Government Reporting Entity Quarter to Date
Assignment within Government Reporting Entity Run
Assignment within Government Reporting Entity Year to Date
Assignment in Jurisdiction within Government Reporting Entity Month
Assignment in Jurisdiction within Government Reporting Entity Pay Date
Assignment in Jurisdiction within Government Reporting Entity Period to Date
Assignment in Jurisdiction within Government Reporting Entity Quarter to Date
Assignment in Jurisdiction within Government Reporting Entity Run
Assignment in Jurisdiction within Government Reporting Entity Month
Assignment in Jurisdiction within Government Reporting Entity Year to Date
Assignment in Jurisdiction within Tax Group Year to Date
Assignment within Tax Group Year to Date
Assignment within Reporting Unit Month
Assignment within Reporting Unit Pay Date
Assignment within Reporting Unit Period to Date
Assignment within Reporting Unit Quarter to Date
Assignment within Reporting Unit Run
Assignment within Reporting Unit Year to Date
Payments
Payments in Jurisdiction
Government Reporting Entity Inception to Date
Government Reporting Entity Month
Government Reporting Entity Pay Date
Government Reporting Entity Period to Date
Government Reporting Entity Quarter to Date
Government Reporting Entity Run
Government Reporting Entity Year to Date
Government Reporting Entity in Jurisdiction Month
Government Reporting Entity in Jurisdiction Pay Date
Government Reporting Entity in Jurisdiction Period to Date
Government Reporting Entity in Jurisdiction Quarter to Date
Government Reporting Entity in Jurisdiction Run
Government Reporting Entity in Jurisdiction Year to Date
Person Fiscal Quarter to Date
Person Fiscal Year to Date
Person Lifetime to Date
Person Month
Person Pay Date
Person Period to Date
Person Quarter to Date
Person Run
Person Year to Date
Person within Government Reporting Entity Month
Person within Government Reporting Entity Pay Date
Person within Government Reporting Entity Period to Date
Person within Government Reporting Entity Quarter to Date
Person within Government Reporting Entity Run
Person within Government Reporting Entity Year to Date
Person within Reporting Unit Month
Person within Reporting Unit Pay Date
Person within Reporting Unit Quarter to Date
Person within Reporting Unit Run
Person within Reporting Unit Year to Date
Person in Jurisdiction Month
Person in Jurisdiction Pay Date
Person in Jurisdiction within Government Reporting Entity Month
Person in Jurisdiction within Government Reporting Entity Pay Date
Person in Jurisdiction within Government Reporting Entity Period to Date
Person in Jurisdiction within Government Reporting Entity Quarter to Date
Person in Jurisdiction within Government Reporting Entity Run
Person in Jurisdiction within Government Reporting Entity Year to Date
Person in Jurisdiction within Tax Group Year to Date
Person within Tax Group Year to Date
Person within a Payroll in Jurisdiction and Government Reporting Entity Period to Date
Person within a Payroll and Government Reporting Entity Period to Date
Reporting Unit Month
Reporting Unit Pay Date
Reporting Unit Quarter to Date
Reporting Unit Year to Date
Subject to Tax for a Person in Payroll and Government Reporting Entity Period to Date
Subject to Tax for Assignment within Government Reporting Entity Run
Subject to Tax for a Person within Government Reporting Entity Run
Subject to Tax in Jurisdiction for Assignment within Government Reporting Entity Run
If you require additional dimensions, you can request them through Oracle Support.
The upload_date in the pay_balance_batch_lines table automatically determines the pay period. If you are uploading multiple pay periods, each pay period has a different upload date, which reflects the date paid.
In accordance with the tax related information entered in the Oracle HRMS database, the payroll run can build tax related balances for each of the following tax types:
Federal Tax
Provincial Tax
Canada Pension
Quebec Pension
Employment Insurance
Provincial Parental Insurance Plan
The following tax related balances are created for each employee assignment by tax type:
Gross Earnings
Exempt Earnings
Subject Earnings
Pre Tax Reductions
Reduced Subject Earnings
Employer Liability
For taxes with upper earnings limits, the following balances are created:
Taxable Earnings
Excess Earnings
For taxes with pay period exemptions, the following balance is created:
Basic Exemption
Tax related balances exist in the system in the following locations:
SOE
View Balance Form, View Employee Assignment Process Results
T4, T4A, RL1 Register Reports
Statutory Deductions Reports, Payroll Register, and so on
The following is a list of Canadian balances that should be initialized in Oracle Payroll in order to obtain accuracy and consistency in the different areas of the system that use and report such balances.
The Canadian balance initialization process enables customers to initialize balances for an entire year.
If balances are being initialized in mid-April for a monthly dimension, the correct balances must be setup for January, February, March, and April.
Oracle Payroll does not require initialization of individual balances for Earnings and Deductions in order to derive the necessary tax related balances. However, if there is a requirement to initialize these balances for reporting or any other reason, the system does support loading of such balances. Initialization of individual balances does not impact calculation of tax related cumulative balances.
For each Jurisdiction Tax type, the following balances must be initialized:
Gross Earnings (GROSS_EARNINGS_BD_JD)
Subject (SUBJECT_BD_JD)
Pretax Reductions (PRETAX_REDNS_BD_JD)
Supplemental Subject (SUPP_SUBJECT_BD_JD)
Note: Only required if using Option 2 tax method.
Employee Withheld (TAX_WITHHELD_BD_JD)
Supplemental Withheld (SUPP_TAX_WITHELD_BD_JD)
Note: Only required if using Option 2 tax method.
Taxable Earnings for taxes with upper limits (CPP, QPP, EI) (TAX_TAXABLE_BD_JD)
EE Basic Exemption (BASIC_EXEMPT_BD_JD)
Employer Liability (ER_LIABILITY_BD_JD)
Exempt Earnings (EXEMPT_BD_JD)
Reduced Subject (REDUCED SUBJECT_BD_JD)
Excess (EXCESS_BD_JD)
Note: All balances must be initialized by Tax_unit_id and Jurisdiction.
Taxable Earnings must be set for Canada Pension (CPP), Quebec Pension (QPP), Employment Insurance (EI) and the Provincial Parental Insurance Plan (PPIP). The balance initialization process does not include validation for upper limits and hence the amount initialized must NOT exceed the upper limit.
There are no derived balances in Canada.
The following balances require initialization by Reporting Unit and Jurisdiction:
PMED (Provincial Medical)
WCB (Workers Compensation)
Other balances to consider are:
Net (NET_BD)
This Balance holds Net Pay, exclusive of non-payroll payments.
Payments (PAYMENTS_BD)
This balance holds Net Pay, inclusive of non-payroll payments.
You must initialize the above two balances in order to see accurate YTD Net Pay figures in the on line Statement of Earnings. Currently the YTD Net on the cheque stub and deposit advice is derived and does not use these balances explicitly.
The T4, T4A, RL1 and RL2 balances hold the specific box related balances; as such, they must be initialized based on your reporting requirements. For ongoing maintenance of these balances, you must set up the Balance feeds explicitly for these balances. To do so, use the Balance/Balance Feeds window.
| Oracle Balance Name | T4 Box |
|---|---|
| T4_BOX20 | RPP contributions |
| T4_BOX44 | Union dues |
| T4_BOX46 | Charitable donations |
| T4_BOX52 | Pension adjustment |
| T4_OTHER_INFO_AMOUNT30 to T4_OTHER_INFO_AMOUNT80 | Other information codes 30 to 80 |
There are predefined feeds for the remaining T4 boxes:
Box 14: Employment income
Box 16: Employee's CPP contributions
Box 17: Employee's QPP contributions
Box 18: Employee's EI premiums
Box 22: Income tax deducted
Box 24: EI insurable earnings
Box 26: CPP-QPP pensionable earnings
Box 55: Employee's PPIP contributions
Box 56: PPIP Insurable earnings
| Oracle Balance Name | T4A Box |
|---|---|
| T4A_BOX16 | Pension or superannuation |
| T4A_BOX18 | Lump-sum payments |
| T4A_BOX20 | Self-employed commissions |
| T4A_BOX24 | Annuities |
| T4A_BOX26 | Eligible retiring allowances |
| T4A_BOX27 | Non-eligible retiring allowances |
| T4A_BOX28 | Other income |
| T4A_BOX30 | Patronage allocations |
| T4A_BOX32 | Registered pension plan contributions (past service) |
| T4A_BOX34 | Pension adjustment |
| T4A_BOX40 | RESP accumulated income payments |
| T4A_BOX42 | RESP educational assistance payments |
| T4A_BOX46 | Charitable donations |
There is a predefined feed for the T4A Box 22: Income tax deducted.
| Oracle Balance Name | RL1 Slip Box |
|---|---|
| RL1_BOXD | RPP contributions |
| RL1_BOXF | Union dues |
| RL1_BOXH | Meals and accommodations |
| RL1_BOXI | Motor vehicle |
| RL1_BOXJ | Private health services plan |
| RL1_BOXK | Trips – remote area |
| RL1_BOXL | Other benefits |
| RL1_BOXM | Commissions |
| RL1_BOXN | Charitable donations |
| RL1_BOXO_AMOUNT_RA to RL1_BOXO_AMOUNT_RZ | Other income codes RA to RZ |
| RL1_BOXP | Multi employer insurance plan |
| RL1_BOXQ | Deferred salary or wages |
| RL1_BOXS | Tips received |
| RL1_BOXT | Tips allocated |
| RL1_BOXU | Phased retirement |
There are predefined feeds for the remaining RL1 boxes:
Box A: Employment income
Box B: Employee's QPP contributions
Box C: Employee's EI contributions
Box E: Income tax deducted
Box G: QPP pensionable earnings
Box R: Status Indian exempt income
| RL2 Slip Box | Oracle Balance Name |
|---|---|
| Box A Unregistered Plan | Life Annuity payments unregistered plan |
| Box A Registered Plan | Life Annuity payments registered plan |
| Box B | Benefits under an RRSP, RRIF, DPSP, and annuities |
| Box C | Other payments |
| Box D | Refund of RRSP premiums paid to surviving spouse |
| Box E | Benefits at the time of death |
| Box F | Refund of undeducted RRSP contributions |
| Box G | Taxable amount due to revoked registration of an RRSP or RRIF |
| Box H | Other Income RRSP or RRIF |
| Box I | Amount giving entitlement to a deduction for RRSP or RRIF |
| Box K | Income earned after death RRSP or RRIF |
| Box L | Income earned after death RRSP or RRIF |
| Box M | Tax-paid Amounts |
| Box O | Withdrawal under the Home Buyers Plan |
There is a predefined feed for RL2 Box J: Quebec income tax withheld at source.
The following table lists required Canadian legislative balances.
Note: The Balance Names and Dimension Names are case sensitive and MUST be loaded in Initcaps. This is similar to how they are stored in the Balance Type and Dimension tables in Oracle Payroll.
| Balance | Dimension |
|---|---|
| Gross Earnings | Assignment in JD within GRE Year to Date |
| Gross Pay | Assignment in JD within GRE Year to Date |
| Net | Assignment in JD within GRE Year to Date |
| Payments | Assignment in JD within GRE Year to Date |
| FED Gross | Assignment in JD within GRE Year to Date |
| FED Subject | Assignment in JD within GRE Year to Date |
| FED Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| FED Supp Subject | Assignment in JD within GRE Year to Date |
| FED Supp Withheld | Assignment in JD within GRE Year to Date |
| PROV Gross | Assignment in JD within GRE Year to Date |
| PROV Subject | Assignment in JD within GRE Year to Date |
| PROV Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| PROV Supp Subject | Assignment in JD within GRE Year to Date |
| PROV Supp Withheld | Assignment in JD within GRE Year to Date |
| CPP Gross | Assignment in JD within GRE Year to Date |
| CPP Subject | Assignment in JD within GRE Year to Date |
| CPP Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| CPP ER Taxable | Assignment in JD within GRE Year to Date |
| CPP ER Liability | Assignment in JD within GRE Year to Date |
| CPP EE Basic Exemption | Assignment in JD within GRE Year to Date |
| CPP ER Basic Exemption | Assignment in JD within GRE Year to Date |
| QPP Gross | Assignment in JD within GRE Year to Date |
| QPP Subject | Assignment in JD within GRE Year to Date |
| QPP Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| QPP ER Taxable | Assignment in JD within GRE Year to Date |
| QPP ER Liability | Assignment in JD within GRE Year to Date |
| QPP EE Basic Exemption | Assignment in JD within GRE Year to Date |
| QPP ER Basic Exemption | Assignment in JD within GRE Year to Date |
| EI Gross | Assignment in JD within GRE Year to Date |
| EI Subject | Assignment in JD within GRE Year to Date |
| EI Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| EI ER Taxable | Assignment in JD within GRE Year to Date |
| EI ER Liability | Assignment in JD within GRE Year to Date |
| EI Hours | Assignment in JD within GRE Year to Date |
| PPIP Gross | Assignment in JD within GRE Year to Date |
| PPIP Subject | Assignment in JD within GRE Year to Date |
| PPIP Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| PPIP ER Taxable | Assignment in JD within GRE Year to Date |
| PPIP ER Liability | Assignment in JD within GRE Year to Date |
| PMED Gross | Assignment in JD within GRE Year to Date |
| PMED Subject | Assignment in JD within GRE Year to Date |
| PMED Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| PMED Liability | Assignment in JD within GRE Year to Date |
| WCB Gross | Assignment in JD within GRE Year to Date |
| WCB Subject | Assignment in JD within GRE Year to Date |
| WCB Pre Tax Reductions | Assignment in JD within GRE Year to Date |
| WCB Taxable | Assignment in JD within GRE Year to Date |
| WCB ER Liability | Assignment in JD within GRE Year to Date |
| T4 Balances (discussed previously) | Assignment in JD within GRE Year to Date |
| T4A Balances | Assignment in JD within GRE Year to Date |
| RL1 Balances | Assignment in JD within GRE Year to Date |
| RL2 Balances | Assignment in JD within GRE Year to Date |