Results for “pqh_de_result_sets”

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

Overview

PQH_DE_RESULT_SETS is a table owned by the HR schema within the PQH (Public Sector HR) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The documented description, "DE - Result Sets," indicates that the table serves as a persistent store for result set definitions produced by the Data Enabler (DE) framework used in Public Sector HR and, by extension, in Oracle Advanced Benefits validation processing. A result set in this context represents a reusable grouping or range definition against which validation logic evaluates eligible results, typically in the context of grade step progression, salary validation, or plan eligibility rules.

From a Data Vault modeling perspective, the metadata classifies this table heuristically as standalone. That classification suggests the table functions as a reference or lookup object rather than as a transactional hub or link. The absence of incoming primary-key relationships from other core HR tables, combined with a small column footprint, is consistent with a table whose principal role is to define and bound value ranges that other processes consume.

Key Information Stored

The table is documented with ten columns in the 12.2.2 ETRM schema. The primary key is enforced by PQH_DE_RESULT_SETS_PK, which appears both as the table's primary key constraint and as a unique index (listed under the alternate naming PQH_DE_RESULTS_SETS_PK in the unique index metadata) on RESULT_SET_ID. RESULT_SET_ID is therefore the surrogate primary key and the only documented business-key candidate; no additional unique index is recorded, meaning no composite natural key is formally enforced at the database level.

• RESULT_SET_ID — Surrogate primary key identifying each result set row.
• GRADUAL_VALUE_NUMBER_FROM — Lower bound of the numeric gradual value range associated with the result set.
• GRADE_ID — Foreign reference to the grade to which the result set range applies.
• GRADUAL_VALUE_NUMBER_TO — Upper bound of the numeric gradual value range.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework to detect concurrent updates.

The pairing of GRADUAL_VALUE_NUMBER_FROM and GRADUAL_VALUE_NUMBER_TO with GRADE_ID indicates that each result set defines a numeric interval scoped to a grade, supporting gradual or step-based value progression.

Common Use Cases and Queries

Typical usage centers on resolving the valid numeric interval for a given grade before validation logic is executed. A representative query returns the range for a specific result set:

• SELECT result_set_id, grade_id, gradual_value_number_from, gradual_value_number_to FROM hr.pqh_de_result_sets WHERE result_set_id = :p_result_set_id;
• SELECT * FROM hr.pqh_de_result_sets WHERE grade_id = :p_grade_id AND :p_value BETWEEN gradual_value_number_from AND gradual_value_number_to;

Reporting scenarios include auditing configured grade ranges, identifying overlapping intervals for a grade, and confirming the audit trail via CREATED_BY and LAST_UPDATED_BY. Because the table is standalone with no documented child tables, joins are predominantly driven from consumer processes rather than from dependent structures within the same product.

Related Objects

The only foreign-key relationship documented in the ETRM metadata is an inbound reference from the global temporary table PO_VALIDATION_RESULTS_GT, which carries a RESULT_SET_ID column pointing to PQH_DE_RESULT_SETS. This indicates that validation processing populates a temporary result set keyed back to this definition table.

• PO_VALIDATION_RESULTS_GT — Joins on PO_VALIDATION_RESULTS_GT.RESULT_SET_ID = PQH_DE_RESULT_SETS.RESULT_SET_ID.
• HR.PQH_DE_RESULT_SETS — Fully qualified object reference in the HR schema.
• PQH_DE_RESULT_SETS_PK / PQH_DE_RESULTS_SETS_PK — Primary key constraint and unique index on RESULT_SET_ID.

Grade-related reference tables (keyed by GRADE_ID) and the Public Sector HR validation engines that invoke PO_VALIDATION_RESULTS_GT are the principal logical dependents, though no further FK metadata is recorded for this object.