Search Results pqh_fr_validations




Overview
Explore in AI Chat

Overview

PQH_FR_VALIDATIONS is a transactional table owned by the HR schema and delivered as part of the PQH — Public Sector HR product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the validation records associated with a person, capturing the outcome of pension and prior-employment validation processes that public-sector organizations must perform — typically for French public sector payroll and pension administration, where a person's service history and employer contributions must be independently verified.

Each row represents one validation instance: the pension fund or employer against which the validation is raised, the person under validation, the requested and completed dates, and the financial amounts, deductions, and percentages that result. The table therefore acts as the persistent record of validation activity and is the parent of the event and period detail tables that describe how a validation progressed. From a Data Vault modeling perspective, the mined key structure classifies this object as hub-leaning: VALIDATION_ID behaves as a stable surrogate business key, while the associated event and period tables provide the descriptive and temporal context.

Key Information Stored

The remaining columns are equally relevant. The table contains 23 documented columns, of which the following are the most operationally significant:

Common Use Cases and Queries

Typical reporting scenarios include identifying validations that remain incomplete, summarizing employer and employee contribution amounts by pension fund, and auditing validations performed against previous employers.

The simplest query pattern joins the parent validation to its detail tables:

SELECT v.validation_id, v.person_id, v.status,
       v.request_date, v.completion_date,
       v.employer_amount, v.employee_amount
FROM   hr.pqh_fr_validations v
WHERE  v.business_group_id = :p_bg_id
AND    v.status = 'PENDING';

To surface outstanding validations by prior employer:

SELECT v.validation_id, pe.employer_name, v.request_date
FROM   hr.pqh_fr_validations v,
       hr.per_previous_employers pe
WHERE  v.previous_employer_id = pe.previous_employer_id
AND    v.completion_date IS NULL;

Aggregated contribution reporting groups the monetary columns by PENSION_FUND_ID and PENSION_FUND_TYPE_CODE, while period-level drill-down joins PQH_FR_VALIDATION_PERIODS on VALIDATION_ID.

Related Objects

  • PQH_FR_VALIDATION_EVENTS — references this table via VALIDATION_ID; holds the individual events recorded against a validation.
  • PQH_FR_VALIDATION_PERIODS — references this table via VALIDATION_ID; holds the dated period segments and their amounts.
  • PER_PREVIOUS_EMPLOYERS — joined through PREVIOUS_EMPLOYER_ID; the source of prior-employment details.
  • PER_ALL_PEOPLE_F — the standard person view joined on PERSON_ID to resolve the individual under validation.

Because PQH_FR_VALIDATIONS is the parent of both the event and period tables, referential integrity restricts deletion of a validation while dependent detail rows exist. Reporting solutions should always filter by BUSINESS_GROUP_ID to respect EBS multi-organization security.