Results for “claim_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_CA_EMP_FED_TAX_INFO_V is an APPS-owned view in the Oracle E-Business Suite Payroll (PAY) product that exposes Canadian federal tax information held against employee assignments. It is a reporting and integration-friendly interface over the underlying employee federal tax information entity, presenting the effective-dated federal tax attributes for each assignment together with decoded lookup meanings. The view carries a status of VALID in the documented environment.

Because Canadian federal tax rules require a variety of statutory attributes — the province of employment, tax credit amounts, claim codes, exemption flags, commission-based expense and remuneration totals, prescribed zone deductions, and CPP/QPP and EI exemption indicators — the view consolidates these into a single queryable structure. It is typically consumed by payroll reporting, statutory extracts, HR analytics, and downstream integrations that must read or reconcile employee federal tax setups without navigating the underlying transactional table directly. The view also exposes descriptive names resolved from lookups, such as the meaning of the employment province code and the tax calculation method, which simplifies presentation in reports.

Underlying Base Objects

The documented view metadata identifies the following referenced base objects: FND_SESSIONS (SYNONYM), HR_API (PACKAGE), HR_LOOKUPS (VIEW), and PAY_CA_EMP_FED_TAX_INFO_F (SYNONYM).

• PAY_CA_EMP_FED_TAX_INFO_F is the primary source of data. The view text aliases this synonym, selecting its statutory columns and decoding values through joins to HR_LOOKUPS.
• HR_LOOKUPS supplies the human-readable meanings. Two lookup joins are evident: one produces EMPLOYMENT_PROVINCE_NAME from the employment province code, and another produces CALCULATION_METHOD from the tax calculation method code.
• HR_API and FND_SESSIONS are referenced as supporting objects, consistent with the standard Oracle EBS pattern in which a view or its dependents rely on session context and HR API package logic.

The view does not alter or store data; it is a read-only projection over the effective-dated federal tax record, preserving the effective start and end dates of each row. Note that the underlying object is referenced through a synonym, so the physical base table resides in the HR/Payroll schema while the view remains owned by APPS.

Key Columns

The view exposes the row identifier and surrogate key ROW_ID and EMP_FED_TAX_INF_ID, along with EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and a duplicated D_EFFECTIVE_END_DATE for date-effectivity handling. Contextual keys include LEGISLATION_CODE, ASSIGNMENT_ID, and BUSINESS_GROUP_ID. The employment province attribute is central to the searched term employment_province: the view returns both the coded value (EMPLOYMENT_PROVINCE) and its decoded label (EMPLOYMENT_PROVINCE_NAME).

Statutory and financial columns include TAX_CREDIT_AMOUNT, CLAIM_CODE, BASIC_EXEMPTION_FLAG, ADDITIONAL_TAX, ANNUAL_DEDN, TOTAL_EXPENSE_BY_COMMISSION, TOTAL_REMNRTN_BY_COMMISSION, PRESCRIBED_ZONE_DEDN_AMT, and OTHER_FEDTAX_CREDITS. Exemption and method indicators include CPP_QPP_EXEMPT_FLAG, FED_EXEMPT_FLAG, EI_EXEMPT_FLAG, TAX_CALC_METHOD and its decoded CALCULATION_METHOD, plus FED_OVERRIDE_AMOUNT and FED_OVERRIDE_RATE. A flexible descriptive flexfield-style block, CA_TAX_INFORMATION_CATEGORY and CA_TAX_INFORMATION1 through CA_TAX_INFORMATION14, is also exposed.

Common Use Cases and Queries

Typical scenarios include reporting employees by province of employment, validating claim codes and federal exemptions, reconciling commission and prescribed zone amounts, and extracting federal tax setup for audit or migration. A representative query filtering on the searched term is:

SELECT assignment_id, employment_province, employment_province_name, claim_code, tax_credit_amount FROM apps.pay_ca_emp_fed_tax_info_v WHERE employment_province = :p_province AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

Reports requiring condition-specific extraction may additionally filter on FED_EXEMPT_FLAG, CPP_QPP_EXEMPT_FLAG, or EI_EXEMPT_FLAG, and join ASSIGNMENT_ID to HR assignment views for organizational context.