Search Results cpp_qpp_exempt_flag

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:

• EMP_FED_TAX_INF_ID — primary identifier for the federal tax information record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — datetracked validity period for the record, supporting historical and future-dated tax configurations.
• TAX_CALC_METHOD — the coded tax calculation method, retained alongside its resolved description.
• CALCULATION_METHOD — the descriptive meaning of TAX_CALC_METHOD derived from the CA_TAX_CALC_METHOD lookup. This is the column most directly associated with the search term "calculation_method."
• EMPLOYMENT_PROVINCE_NAME — the descriptive province name derived from the CA_PROVINCE lookup.
• TAX_CREDIT_AMOUNT, BASIC_EXEMPTION_FLAG, ADDITIONAL_TAX, ANNUAL_DEDN — federal tax credit and exemption attributes.
• TOTAL_EXPENSE_BY_COMMISSION, TOTAL_REMNRTN_BY_COMMISSION, PRESCRIBED_ZONE_DEDN_AMT, OTHER_FEDTAX_CREDITS — deduction, credit, and prescribed-zone amounts used in federal tax computation.
• CPP_QPP_EXEMPT_FLAG, FED_EXEMPT_FLAG, EI_EXEMPT_FLAG — statutory exemption indicators for CPP/QPP, federal tax, and employment insurance respectively.
• FED_OVERRIDE_AMOUNT, FED_OVERRIDE_RATE, FED_LSF_AMOUNT — federal override values and labour-sponsored fund amounts.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — audit columns, with LAST_UPDATED_BY resolved to the FND_USER user name.

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.