Functional Description
This NER is used to fetch information from the Employee Tax Exemptions/Overrides
table(F06017) to update the FC fields in Canadian Tax Override(P770105).
Purpose
Canadian Tax Override(P770105) does not use a business view to populate or update its fields.
Instead, table I/Os must be performed (This Canadian application shares F06017 with its US counterpart,
Employee Tax Overrides-US. Since this Canadian application was created after the US application, it
cannot use all of the table columns in F06017. As a result, only three table columns are being used. This
requires the use of Table I/Os). These table I/Os are performed within N0500132 NER being called in
P770105's Dialog is Initialized event, and the OK button. This function is being called in the
Dialog is Initialized event.
Setup Notes and Prerequisites
The following statutory codes are used as part of the DB key for each FC field:
StatutoryFC FieldTab
Code
*ARAdditional TaxFederal
*CCChild Care, Alimony, EtcOther
*CRCPP-QPP Tax Override%Other
*FRFederal Tax Override%Other
*K3Other Tax CreditFederal
*NCNet Tax CreditFederal
*PAAdditional TaxProvincial
*PDNet Tax CreditProvincial
*PRQuebec Tax OverrideProvincial
*PXAdditional DeductionProvincial
*RDPrescribed Area DeductionOther
*FSFedearal Canadian Stock AmountFedearal
*PSProvincial Stock AmountProvincial
Technical Specification
D0500132 - F06017 Fetch Canadian Tax Information by EE Data Structure
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnNetTaxCredit | OWNTC | MATH_NUMERIC | OPT | NONE |
The Personal Tax Credit amount, which comes from the TD1 form for federal or the corresponding province. | ||||
mnAdditionalTax | OWATX | MATH_NUMERIC | OPT | NONE |
For federal taxes, the amount of additional federal tax to be deducted per pay period. For provincial taxes, the amount of additional
| ||||
mnOtherTaxCredit | OWOTX | MATH_NUMERIC | OPT | NONE |
Federal tax credits, such as medical expenses and charitable donations,requested by an employee and authorized by the Canada
| ||||
mnAdditionalDeduction | OWADE | MATH_NUMERIC | OPT | NONE |
Quebec additional deductions claimed on the MR-19-V (Exemptions and Reductions form) or other deductions authorized by the Ministere
| ||||
szStatutoryCode1 | SC01 | char | OPT | NONE |
A code that allows you to override supplemental taxes for federal and state taxes and to add additional local residence taxes. Valid values
| ||||
mnEIRate | UCRT | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to compute U.S. unemployment and Canadian employer-paid employment insurance premiums. This rate is
| ||||
mnPrescribedAreaDeduction | OWPAD | MATH_NUMERIC | OPT | NONE |
An annual deduction for living in a prescribed area as listed on the TD1 (Personal Tax Credit Return). | ||||
mnChildCareAlimonyEtc | OWCLD | MATH_NUMERIC | OPT | NONE |
An annual deduction, such as child care expenses, alimony payments, maintenance payments, and so on. | ||||
mnFederalTaxOverrides | OWTXO | MATH_NUMERIC | OPT | NONE |
A flat percentage that overrides the standard tax rate. | ||||
cEIExempt | OWEXE | char | OPT | NONE |
An option that indicates whether the employee is exempt or non-exempt from tax deductions. Select one of the following options to indicate
| ||||
cPensionerNonResidentFlag | FICP | char | OPT | NONE |
This code indicates if the employee is a Non-Resident or a Pensioner of Canada. Valid values are:
N
Non-Resident of
| ||||
mnAddWithholding1 | AW01 | MATH_NUMERIC | OPT | NONE |
An additional amount to be withheld over and above the calculated withholding.
This could represent a flat withholding amount in situations
| ||||
szCompanyHome | HMCO | char | OPT | NONE |
The company number where the employee records generally reside. | ||||
cTaxCalcMethod | FICM | char | OPT | NONE |
A code that specifies the tax method that the Vertex payroll-tax calculation system uses to calculate certain taxes. The codes are defined in
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnQuebecNetTaxCredit | OWNTC | MATH_NUMERIC | OPT | NONE |
The Personal Tax Credit amount, which comes from the TD1 form for federal or the corresponding province. | ||||
mnQuebecAdditionalTax | OWATX | MATH_NUMERIC | OPT | NONE |
For federal taxes, the amount of additional federal tax to be deducted per pay period. For provincial taxes, the amount of additional
| ||||
mnCPPQPPTaxOverrides | OWTXO | MATH_NUMERIC | OPT | NONE |
A flat percentage that overrides the standard tax rate. | ||||
mnQuebecTaxOverrides | OWTXO | MATH_NUMERIC | OPT | NONE |
A flat percentage that overrides the standard tax rate. | ||||
cCPPQPPExempt | OWEXE | char | OPT | NONE |
An option that indicates whether the employee is exempt or non-exempt from tax deductions. Select one of the following options to indicate
| ||||
cEICPPQPPExempt | OWEXE | char | OPT | NONE |
An option that indicates whether the employee is exempt or non-exempt from tax deductions. Select one of the following options to indicate
| ||||
cAllTaxesExempt | OWEXE | char | OPT | NONE |
An option that indicates whether the employee is exempt or non-exempt from tax deductions. Select one of the following options to indicate
| ||||
szHoldEIRateCode | SC01 | char | OPT | NONE |
A code that allows you to override supplemental taxes for federal and state taxes and to add additional local residence taxes. Valid values
| ||||
mnEstimatedSalary | ESAL | MATH_NUMERIC | OPT | NONE |
The amount of estimated salary recorded on the employee's TDIX form. The system uses this amount and the estimated expenses, to
| ||||
jdDatePayPeriodEnding | PPED | JDEDATE | OPT | NONE |
The last day of a processing period (pay period, month, quarter or year). | ||||
mnAmtGrossPay | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
| ||||
mnPayDeductBenAccType | PDBA | MATH_NUMERIC | OPT | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
szTaxIdentificationNo | TAXX | char | OPT | NONE |
A number that identifies your company to the tax authority. This number can include the tax ID number for an individual, a federal or state
| ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnYTDUnionDues | AA | MATH_NUMERIC | OPT | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
mnYTDRegPenPlan | AA1 | MATH_NUMERIC | OPT | NONE |
A number that identifies the actual amount. | ||||
cEarnIncomeCredStatus | EIC | char | OPT | NONE |
A code that specifies whether the employee qualifies for the earned income credit and elects for the employer to give him or her the
| ||||
mnFedCanadaStockAmt | T4ST | MATH_NUMERIC | OPT | NONE |
Amount of Stock Options. | ||||
mnProvCanadaStockAmt | T4ST | MATH_NUMERIC | OPT | NONE |
Amount of Stock Options. |
None |
None |