Results for “additional_tax”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_CA_EMP_PROV_TAX_INFO_D is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) product, classified as VALID in ETRM for releases 12.1.1 and 12.2.2. It presents date-tracked Canadian employee provincial tax information, exposing the same personal and provincial tax attributes held on the underlying date-tracked entity PAY_CA_EMP_PROV_TAX_INFO_F. The "_D" suffix denotes a descriptive (denormalized) view intended primarily for reporting, inquiry, and integration consumption rather than for direct data entry. The view resolves the technical identifiers that are otherwise unintelligible to report authors: the province code is translated into a human-readable province name via HR_LOOKUPS, and the numeric LAST_UPDATED_BY identifier is translated into a user name via FND_USER. Because it is defined over a date-tracked (datetracked) table, every row carries EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, allowing consumers to reconstruct the historical and current state of an employee's provincial tax elections. The user search term emp_province_tax_inf_id corresponds directly to the primary identifier column EMP_PROVINCE_TAX_INF_ID exposed by this view.
Underlying Base Objects
The view is defined in the APPS schema over the following documented objects:
PAY_CA_EMP_PROV_TAX_INFO_F(SYNONYM) — the primary date-tracked base entity supplying all tax attribute columns and theEMP_PROVINCE_TAX_INF_IDkey.HR_LOOKUPS(VIEW) — joined via an outer join onLOOKUP_TYPE = 'CA_PROVINCE'andLOOKUP_CODE = PTI.PROVINCE_CODEto supply thePROVINCE_NAME(the lookupMEANING).FND_USER(SYNONYM) — joined via an outer join onUSER_ID = PTI.LAST_UPDATED_BYto supply the updating user'sUSER_NAMEasLAST_UPDATED_BY.HR_API(PACKAGE) — referenced as part of the payroll datetrack infrastructure associated with the base entity's maintenance.
Both joins use the Oracle outer-join operator (+), so rows are retained even where no matching FND_USER or lookup row exists; in such cases PROVINCE_NAME or LAST_UPDATED_BY returns NULL. The view is read-only with respect to the base data; insertions and updates to provincial tax information are performed against the _F entity through the standard datetrack and payroll APIs, not through this view.
Key Columns
The view exposes the full set of provincial tax attributes. The most significant include:
EMP_PROVINCE_TAX_INF_ID— the surrogate primary key uniquely identifying a row of employee provincial tax information.EFFECTIVE_START_DATE/EFFECTIVE_END_DATE— the datetrack validity window for the record.PROVINCE_NAME— the descriptive province label resolved fromCA_PROVINCElookup values.TAX_CREDIT_AMOUNT,ADDITIONAL_TAX,ANNUAL_DEDN— monetary federal/provincial credit, additional tax, and annual deduction amounts.MARRIAGE_STATUS,NO_OF_DEPENDANTS,NO_OF_INFIRM_DEPENDANTS,NON_RESIDENT_STATUS,DISABILITY_STATUS— personal circumstances affecting provincial tax calculation.TOTAL_EXPENSE_BY_COMMISSION,TOTAL_REMNRTN_BY_COMMISSION,PRESCRIBED_ZONE_DEDN_AMT— commission-related expenses and prescribed-zone deductions.BASIC_EXEMPTION_FLAG,PROV_EXEMPT_FLAG,PMED_EXEMPT_FLAG,WC_EXEMPT_FLAG— exemption indicators (provincial, medicare/PMED, workers' compensation).PROV_OVERRIDE_RATE,PROV_OVERRIDE_AMOUNT,PROV_LSP_AMOUNT— provincial override rate/amount and labour-sponsored plan amount.LAST_UPDATE_DATE/LAST_UPDATED_BY— audit columns, with the latter resolved to a user name.
Common Use Cases and Queries
The view is typically used for provincial tax auditing, reconciliation between payroll results and employee tax elections, and feeding downstream reporting or integrations that require descriptive province and user names. A request for a specific record by its identifier — the pattern implied by the search term — is straightforward:
- Retrieve a single tax record by key:
SELECT * FROM APPS.PAY_CA_EMP_PROV_TAX_INFO_D WHERE EMP_PROVINCE_TAX_INF_ID = :p_id; - List current provincial tax setups by province:
SELECT EMP_PROVINCE_TAX_INF_ID, PROVINCE_NAME, TAX_CREDIT_AMOUNT, MARRIAGE_STATUS, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM APPS.PAY_CA_EMP_PROV_TAX_INFO_D WHERE PROVINCE_NAME = :province ORDER BY EFFECTIVE_START_DATE; - Audit recent changes:
SELECT EMP_PROVINCE_TAX_INF_ID, PROVINCE_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.PAY_CA_EMP_PROV_TAX_INFO_D ORDER BY LAST_UPDATE_DATE DESC; - Filter to a datetrack point in time:
... WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
Because the view already resolves lookups and user identifiers, it is preferable to the base _F table for read-only reporting. All monetary and flag semantics remain governed by the underlying payroll datetrack entity.
-
APPS.PAY_CA_EMP_PROV_TAX_INFO_D·↳ FND_GLOBAL·↳ FND_USER·↳ HR_API·Explore PAY module →
-
View: HR_ADP_CITY_TAX_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_CITY_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →
-
APPS.PAY_CA_EMP_ALL_FEDTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
View: HR_ADP_FED_TAX_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_FED_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →
-
View: HR_ADP_FED_TAX_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_FED_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
APPS.PAY_CA_EMP_PROV_TAX_INFO_D·↳ FND_USER·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
APPS.PAY_CA_EMP_ALL_FEDTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
APPS.PAY_CA_EMP_FED_TAX_INFO_D·↳ FND_GLOBAL·↳ FND_USER·↳ HR_API·Explore PAY module →
-
View for pay_ca_emp_prov_tax_info_v
APPS.PAY_CA_EMP_PROV_TAX_INFO_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
APPS.PAY_CA_EMP_FED_TAX_INFO_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
View: HR_ADP_STATE_TAX_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_STATE_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →
-
APPS.PAY_CA_EMP_FED_TAX_INFO_D·↳ FND_USER·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
APPS.PAY_CA_EMP_ALL_PROVTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
APPS.PAY_CA_EMP_ALL_PROVTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
APPS.PAY_CA_EMP_FED_TAX_INFO_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
View: HR_ADP_CITY_TAX_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_CITY_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
Canadian federal tax information
-
View: HR_ADP_STATE_TAX_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_STATE_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View for pay_ca_emp_prov_tax_info_v
APPS.PAY_CA_EMP_PROV_TAX_INFO_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
Canadian federal tax information
-
Canadian provincial tax information
-
Canadian provincial tax information
-
PACKAGE: APPS.PAY_CFT_SHD 12.2.2
-
PACKAGE: APPS.PAY_CFT_SHD 12.1.1
-
VIEW: APPS.HR_ADP_CITY_TAX_V 12.2.2