Search Results calculation_method




Overview
Explore in AI Chat

Overview

PAY_CA_EMP_FED_TAX_INFO_D is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product module. It presents Canadian federal tax information for employees, combining data from the Canadian federal tax information entity with descriptive lookup values and audit user information. The suffix "D" denotes that this view exposes denormalized, human-readable descriptive values rather than raw coded identifiers, making it suitable for reporting, data extraction, and integration scenarios where lookup meanings are required without additional joins.

In EBS 12.1.1 and 12.2.2, the view operates as a read-only reporting layer over the PAY_CA_EMP_FED_TAX_INFO_F table. Its principal value lies in resolving several coded columns into their descriptive meanings: the tax calculation method is resolved against the CA_TAX_CALC_METHOD lookup type, and the employment province is resolved against the CA_PROVINCE lookup type. The view also resolves the LAST_UPDATED_BY foreign key to an FND_USER user name. This denormalization allows report authors and integrators to avoid repeated lookups against HR_LOOKUPS and FND_USER.

Underlying Base Objects

The documented view definition references the following objects:

  • PAY_CA_EMP_FED_TAX_INFO_F (SYNONYM) — the primary base entity holding Canadian employee federal tax information records. This is the driving table of the view and supplies the EMP_FED_TAX_INF_ID primary key and all tax-related attributes.
  • HR_LOOKUPS (VIEW) — joined twice to resolve coded values. The first join (HRL) resolves TAX_CALC_METHOD against LOOKUP_TYPE = 'CA_TAX_CALC_METHOD'; the second join (HRL1) resolves EMPLOYMENT_PROVINCE against LOOKUP_TYPE = 'CA_PROVINCE'.
  • FND_USER (SYNONYM) — outer-joined to resolve LAST_UPDATED_BY into the USER_NAME of the last updating application user.
  • HR_API (PACKAGE) — referenced as a supporting object associated with the view's underlying entity, consistent with the HR/payroll datetracked entity framework.

The joins against HR_LOOKUPS and FND_USER are outer joins (indicated by the (+) operator in the view text). Consequently, records with unclassified tax calculation methods, unmapped provinces, or null updater identifiers are still returned, with null descriptive values.

Key Columns

The view exposes the following principal columns:

Common Use Cases and Queries

The view is typically used to report current or historical federal tax setups for Canadian employees, to audit calculation method assignments, and to feed downstream payroll analytics. A representative query retrieving the calculation method for a specific record follows:

  • SELECT EMP_FED_TAX_INF_ID, CALCULATION_METHOD, TAX_CALC_METHOD, EMPLOYMENT_PROVINCE_NAME FROM APPS.PAY_CA_EMP_FED_TAX_INFO_D WHERE EMP_FED_TAX_INF_ID = :p_id;
  • SELECT EMPLOYMENT_PROVINCE_NAME, CALCULATION_METHOD, COUNT(*) FROM APPS.PAY_CA_EMP_FED_TAX_INFO_D GROUP BY EMPLOYMENT_PROVINCE_NAME, CALCULATION_METHOD;
  • SELECT d.EMP_FED_TAX_INF_ID, d.CALCULATION_METHOD, d.FED_EXEMPT_FLAG, d.LAST_UPDATED_BY, d.LAST_UPDATE_DATE FROM APPS.PAY_CA_EMP_FED_TAX_INFO_D d WHERE d.EFFECTIVE_START_DATE >= :start_date;

Because the view is denormalized and read-only, it is appropriate for SELECT-based reporting and integration extracts, but not for direct DML. Modifications to employee federal tax information must be performed against the underlying PAY_CA_EMP_FED_TAX_INFO_F entity through the supported payroll APIs.