Search Results ca_tax_calc_method




Overview
Explore in AI Chat

Overview

APPS.PAY_CA_EMP_FED_TAX_INFO_D is a reporting view in Oracle EBS Payroll (Oracle HRMS) that exposes Canadian employee federal tax information. The view is defined over the date-tracked (datetracked) table PAY_CA_EMP_FED_TAX_INFO_F and enriches it with descriptive lookups and audit information. Its primary purpose is to provide a denormalized, user-readable representation of each employee's federal tax election records, including effective-dated attributes such as tax credit amounts, exemption flags, additional tax, prescribed zone deductions, and CPP/EI election details.

The view is particularly relevant to the search term "ca_tax_calc_method". The column TAX_CALC_METHOD is stored as a lookup code on the underlying table, and the view resolves it to a meaningful description through the CALCULATION_METHOD column. This resolution joins the base table to HR_LOOKUPS where LOOKUP_TYPE = 'CA_TAX_CALC_METHOD'. Similarly, the employee's province of employment is resolved through a second join to HR_LOOKUPS using LOOKUP_TYPE = 'CA_PROVINCE'. Because the lookup joins are outer joins (+), records are returned even when a corresponding lookup row is absent.

Underlying Base Objects

The documented base objects referenced by the view are:

  • PAY_CA_EMP_FED_TAX_INFO_F (accessed via synonym) — the primary date-tracked entity table holding Canadian employee federal tax information. Each row is keyed by EMP_FED_TAX_INF_ID with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE defining the datetrack validity window.
  • HR_LOOKUPS (view) — used twice (aliased HRL and HRL1) to resolve the tax calculation method (CA_TAX_CALC_METHOD) and the employment province (CA_PROVINCE) into descriptive meanings.
  • FND_USER (synonym) — joined through an outer join on LAST_UPDATED_BY to retrieve the USER_NAME of the last updater.
  • HR_API (package) — referenced as part of the view's metadata, consistent with HRMS date-tracked objects that are maintained through the HR_API business process APIs.

The view therefore functions as a read-optimized layer that shields consumers from the numeric lookup codes and surrogate user IDs stored on the base entity.

Key Columns

Common Use Cases and Queries

Typical usage includes payroll reporting, tax configuration audits, and integration extracts that require decoded calculation methods and province names. A representative query to find employees by tax calculation method is:

  • SELECT emp_fed_tax_inf_id, calculation_method, employment_province_name, effective_start_date, effective_end_date FROM apps.pay_ca_emp_fed_tax_info_d WHERE tax_calc_method = :p_method;
  • Auditing exemptions: SELECT * FROM apps.pay_ca_emp_fed_tax_info_d WHERE fed_exempt_flag = 'Y' AND effective_end_date = HR_API.g_high_date;
  • Reporting CPP elections: SELECT emp_fed_tax_inf_id, cpp_election_date, cpp_revocation_date FROM apps.pay_ca_emp_fed_tax_info_d WHERE cpp_election_date IS NOT NULL;
  • Resolving the latest record per employee by filtering on the high date and ordering by effective_start_date DESC.

Because the view exposes the datetracked table directly, queries should always constrain on the effective dates to return the correct version of the tax information for the reporting period required.