Results for “rate_value”

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

Overview

PQH_RATE_MATRIX_RATES_F is a datetracked table owned by the HR schema in Oracle E-Business Suite, belonging to the PQH (Public Sector HR) product family. It stores the rate value associated with each node in a rate matrix hierarchy. Rate matrices are a core construct in Oracle HRMS compensation and pay administration, enabling organizations to define multidimensional rate structures where each node in a hierarchy intersects with a criteria-driven rate definition to produce a specific pay rate. This table is therefore the transactional anchor that materializes the rate amount for any given combination of matrix node and rate criteria.

Based on the mined foreign key structure, the object carries a heuristic Data Vault classification of link. This classification is a modeling suggestion rather than a prescribed implementation: the table binds a matrix node to a criteria rate definition and attaches descriptive measures (the rate values) and audit attributes around that relationship. Reading it as a link with a dependent satellite of rate measures is a reasonable analytical stance, but Oracle implements it as a conventional datetracked entity within the HR schema.

Key Information Stored

The table exposes eighteen documented columns. The most significant are:

• RATE_MATRIX_RATE_ID — the system-generated surrogate identifier for the rate row.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the datetrack date range that makes the row valid for a defined period. These are integral to the primary key (PQH_RATE_MATRIX_RATES_F_PK), which combines RATE_MATRIX_RATE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE.
• RATE_MATRIX_NODE_ID — foreign key to PQH_RATE_MATRIX_NODES, identifying the hierarchy node to which the rate belongs.
• CRITERIA_RATE_DEFN_ID — foreign key to PQH_CRITERIA_RATE_DEFN, identifying the rate criteria definition that qualifies the value.
• MIN_RATE_VALUE, MAX_RATE_VALUE, MID_RATE_VALUE, and RATE_VALUE — the numeric rate values, representing the bounds, midpoint, and primary amount associated with the node/criteria combination.
• BUSINESS_GROUP_ID and LEGISLATION_CODE — the enterprise and statutory context in which the rate is valid.
• OBJECT_VERSION_NUMBER — the optimistic locking and change-detection attribute used by the HRMS datetrack infrastructure.
• ZD_EDITION_NAME — the editioning column that supports online patching and edition-based redefinition in 12.2.x; it participates in the unique business-key index alongside RATE_MATRIX_RATE_ID and the date range.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) record who created and modified the row and when.

Common Use Cases and Queries

Typical usage centers on retrieving the effective rate for a matrix node under a given criteria definition as of a point in time. Reporting queries frequently join this table to PQH_RATE_MATRIX_NODES and PQH_CRITERIA_RATE_DEFN. For example, to retrieve the current rate for a specific node:

• SELECT r.rate_matrix_rate_id, r.rate_matrix_node_id, r.criteria_rate_defn_id, r.rate_value FROM pqh_rate_matrix_rates_f r WHERE r.rate_matrix_node_id = :node_id AND TRUNC(SYSDATE) BETWEEN r.effective_start_date AND r.effective_end_date;
• Historic comparison between two effective dates relies on the datetrack columns to expose the rate in force at each date.
• Repository and validation reporting joins to PQH_CRITERIA_RATE_DEFN to enumerate all configured rates per criteria definition.
• Payroll and compensation analytics may aggregate RATE_VALUE, MIN_RATE_VALUE, and MAX_RATE_VALUE by business group or legislation to profile rate matrices.

Because the object is datetracked, all queries must constrain against the effective date range where a point-in-time result is required.

Related Objects

The following objects are the most significant points of integration, grounded in the documented foreign key relationships:

• PQH_RATE_MATRIX_NODES — referenced by PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID; the parent node definition in the matrix hierarchy.
• PQH_CRITERIA_RATE_DEFN — referenced by PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID; the definition of qualifying rate criteria.
• PQH_RATE_MATRIX_RATES_F_PK — the primary key constraint and index enforcing uniqueness on RATE_MATRIX_RATE_ID plus the datetrack range.
• The parent rate matrix header and hierarchy tables in the PQH rate matrix family, which frame the node structure referenced above.
• HRMS datetrack and business group tables, which provide the effective-dating and enterprise context consumed by this table.

Together these objects support the definition, maintenance, and retrieval of multi-dimensional rate structures used throughout Public Sector HR compensation processing.