Search Results pay_us_contribution_history_v




Overview
Explore in AI Chat

Overview

PAY_US_CONTRIBUTION_HISTORY_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) product. It exposes United States contribution history information—data describing pre-tax deduction and contribution amounts recorded against employees over defined date ranges—in a denormalized, report-friendly form. The view is valid in both EBS 12.1.1 and 12.2.2 and is documented as the "Contribution History View."

Its primary role is to support reporting, reconciliation, and integration of US contribution and pre-tax deduction history. Rather than requiring callers to join the raw contribution history table to person, lookup, and tax unit sources manually, the view presents a single read-only interface that resolves key descriptive attributes such as the person's full name, the contribution type meaning, and the tax unit name. Because it resolves these relationships internally, it is commonly referenced by concurrent programs, BI Publisher data models, and custom inquiry screens.

Underlying Base Objects

The view is defined primarily over the base table PAY_US_CONTRIBUTION_HISTORY (referenced through the PAY_US_CONTRIBUTION_HISTORY synonym), aliased as PCH, which supplies the contribution history rows and the CONTR_INFORMATION1 through CONTR_INFORMATION30 descriptive flexfield segment columns. The documented referenced base objects include HR_API and HR_GENERAL packages, HR_PERSON_NAME and HR_SECURITY packages, the HR_LOOKUPS view, the HR_TAX_UNITS_V view, the PER_PEOPLE_F view, and the PER_PERSON_TYPES synonym.

In its view text, the definition joins PER_PEOPLE_F (PPF) to PAY_US_CONTRIBUTION_HISTORY on PERSON_ID and constrains the person's effective dates so that the contribution period falls within the person record's effective range. PER_PERSON_TYPES is joined on PERSON_TYPE_ID and filtered to SYSTEM_PERSON_TYPE = 'EMP'. HR_LOOKUPS is joined with LOOKUP_TYPE = 'US_PRE_TAX_DEDUCTIONS' and LOOKUP_CODE = CONTR_TYPE to resolve the meaning of the contribution type. HR_TAX_UNITS_V is an outer join on BUSINESS_GROUP_ID and TAX_UNIT_ID, providing the tax unit name where one exists.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing includable compensation against contribution amounts, reconciling pre-tax deduction history for a tax unit, and feeding payroll history extracts. A sample query follows:

SELECT person_id, full_name, contr_type, meaning,
       date_from, date_to, amt_contr,
       max_contr_allowed, includable_comp, name tax_unit
FROM   apps.pay_us_contribution_history_v
WHERE  includable_comp IS NOT NULL
AND    date_from >= :p_start_date
ORDER  BY person_id, date_from;

Because HR_SECURITY is among the referenced objects, access is subject to the security profile applied to the reporting session.