Results for “employer_amount”

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

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:

• VALIDATION_ID — the surrogate primary key, enforced by PQH_FR_VALIDATIONS_PK. It is the sole documented unique index and the join key used by all dependent tables.
• PERSON_ID — identifies the person whose validation is being recorded; the principal business-key candidate together with the pension fund and request details.
• PENSION_FUND_TYPE_CODE and PENSION_FUND_ID — classify and identify the pension scheme against which the validation is performed.
• PREVIOUS_EMPLOYER_ID — foreign key to PER_PREVIOUS_EMPLOYERS, linking the validation to a declared prior employer.
• REQUEST_DATE and COMPLETION_DATE — the temporal boundaries of the validation cycle.
• PREVIOUSLY_VALIDATED_FLAG and STATUS — indicate whether the person was validated before and the current processing state.
• EMPLOYER_AMOUNT, EMPLOYEE_AMOUNT, DEDUCTION_PER_PERIOD, and PERCENT_OF_SALARY — monetary outcomes, each paired with a corresponding currency code column.
• BUSINESS_GROUP_ID — provides the multi-organization security boundary.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER support concurrency control and standard EBS audit reporting.

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.