Search Results us_pre_tax_deductions

Overview

APPS.PAY_US_CONTRIBUTION_HISTORY_V is a reporting and integration view in Oracle E-Business Suite that exposes United States pre-tax contribution history for employees. It joins the contribution history fact table PAY_US_CONTRIBUTION_HISTORY to person, person type, lookup, and tax unit information, producing a denormalized record suitable for payroll reporting, benefits analysis, and downstream integration. The view is especially relevant when users search for "us_pre_tax_deductions", since the view filter on the HR_LOOKUPS lookup type US_PRE_TAX_DEDUCTIONS directly drives the contr_type column. In EBS 12.1.1 and 12.2.2 the view resides in the APPS schema and is referenced by concurrent programs, Oracle HRMS extracts, and custom reports requiring contribution history by person and tax unit.

Underlying Base Objects

The view is defined over the synonym PAY_US_CONTRIBUTION_HISTORY (aliased pch) as its primary source, joined to PER_PEOPLE_F (ppf), the PER_PERSON_TYPES synonym (ptype), HR_LOOKUPS (hlv), and HR_TAX_UNITS_V (htu). The join logic restricts results to employees: ptype.system_person_type = 'EMP'. The person join is bounded by year-level date comparisons between date_from/date_to and the person record's effective_start_date/effective_end_date, and is further filtered to the latest person record via a MAX(effective_start_date) subquery over PER_PEOPLE_F. The lookup join requires hlv.lookup_type = 'US_PRE_TAX_DEDUCTIONS' and hlv.lookup_code = pch.contr_type, so contr_type values are validated against the US pre-tax deduction lookup set. The tax unit join to HR_TAX_UNITS_V is outer (htu.business_group_id(+) = pch.business_group_id and htu.tax_unit_id(+) = pch.tax_unit_id). Documented referenced base objects also include the HR_API, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages, which support person-name resolution and row-level security through the view's dependencies.

Key Columns

• contr_history_id — Primary identifier of the contribution history record.
• person_id / full_name — Employee identifier and resolved full name from HR_PERSON_NAME.
• date_from / date_to — Effective range of the contribution history record.
• legislation_code — Legislation context, typically 'US' for this view.
• amt_contr / max_contr_allowed / includable_comp — Contribution amount, statutory maximum, and includable compensation used in limit testing.
• tax_unit_id / name — Tax unit identifier and its name from HR_TAX_UNITS_V.
• contr_type / meaning — Contribution type code joined to HR_LOOKUPS and its US_PRE_TAX_DEDUCTIONS meaning.
• contr_information_category and contr_information1–30 — Descriptive flexfield context and attribute columns.
• source_system — Originating system of the contribution record.
• business_group_id — Business group partitioning the record.
• last_update_date, last_updated_by, creation_date, created_by, object_version_number — Standard WHO audit columns.

Common Use Cases and Queries

Typical usage includes pre-tax deduction limit monitoring, 401(k) and cafeteria-plan reporting, and reconciliation of contribution history against payroll balances. A representative query lists contributions for a person over a period:

SELECT person_id, full_name, contr_type, meaning, amt_contr, max_contr_allowed, date_from, date_to FROM apps.pay_us_contribution_history_v WHERE person_id = :p_person_id AND date_from >= :p_start_date ORDER BY date_from;

To aggregate contributions by deduction type for a business group:

SELECT contr_type, meaning, SUM(amt_contr) total_contrib FROM apps.pay_us_contribution_history_v WHERE business_group_id = :p_bg_id AND legislation_code = 'US' GROUP BY contr_type, meaning;

Limit testing against includable compensation may be performed by comparing amt_contr to max_contr_allowed grouped by tax_unit_id. Because the view applies HR_SECURITY indirectly through PER_PEOPLE_F and related packages, results honor the security profile of the querying user. Reports and interfaces should filter on business_group_id and effective dates to limit result sets.