Results for “pay_grade_rules_f”

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

Overview

PAY_GRADE_RULES_F is a core Payroll (PAY) table residing in the HR schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the values associated with grade rates and progression point rates, capturing the monetary or numeric amounts that apply to a grade or spinal point within a defined rate structure. In EBS, this table underpins compensation configuration, enabling the definition of minimum, mid, and maximum values per grade rule so that payroll and compensation processes can evaluate an employee's placement relative to a defined grade rate.

The _F suffix indicates a date-tracked ("date-effective") table, meaning records are versioned across effective date ranges rather than physically updated. Each row therefore represents a rate value as it applies during a specific EFFECTIVE_START_DATE to EFFECTIVE_END_DATE window. Under the heuristic Data Vault classification mined from the foreign-key structure, this object is best modeled as a link, since it associates independent business entities — a grade or progression point and a payroll rate definition — within an effective-dated relationship. It is not a pure hub or satellite, as its identity is derived from the combination of those references plus the temporal key.

Key Information Stored

The table contains 23 documented columns. The most significant are summarized below.

• GRADE_RULE_ID — Surrogate identifier for the grade rule. It forms the leading component of the primary key and links related date-effective rows for the same rule.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — The date-effective boundaries that, together with GRADE_RULE_ID, constitute the composite primary key PAY_GRADE_RULES_F_PK. These columns define the validity window of each rate value.
• BUSINESS_GROUP_ID — Identifies the business group (an HR organization) that owns the record; foreign key to HR_ALL_ORGANIZATION_UNITS.
• RATE_ID — References the payroll rate definition; foreign key to PAY_RATES.
• GRADE_OR_SPINAL_POINT_ID — Identifies the grade or spinal (progression) point to which the rate value applies.
• RATE_TYPE — Indicates the nature of the rate value held on the row.
• MINIMUM, MID_VALUE, MAXIMUM — The defined low, midpoint, and high values for the grade rule range.
• VALUE — The primary monetary or numeric amount for the rule.
• CURRENCY_CODE — Currency in which monetary values are expressed.
• SEQUENCE — Ordering attribute for related rule rows.
• OBJECT_VERSION_NUMBER — Optimistic locking control for concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns.

The primary key is a surrogate-and-temporal composite (GRADE_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE). The unique index PAY_GRADE_RULES_F_PK is the only documented business-key candidate; no separate natural-key unique index is recorded.

Common Use Cases and Queries

Typical uses include compensation reporting, grade-rate validation, and effective-date reconstruction of pay structures. A common requirement is retrieving the rate value active on a given date:

• Point-in-time rate lookup — Filter where :as_of_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE for a specific GRADE_RULE_ID.
• Grade range reporting — Select MINIMUM, MID_VALUE, MAXIMUM, and CURRENCY_CODE for a business group to analyze pay bands.
• Rate structure joins — Join to PAY_RATES on RATE_ID to resolve the rate name and units for each grade rule.
• Audit and history — Use the effective dates and WHO columns to trace changes to grade rate values over time.

Sample pattern:

SELECT g.GRADE_RULE_ID, g.MINIMUM, g.MID_VALUE, g.MAXIMUM, g.CURRENCY_CODE
FROM PAY_GRADE_RULES_F g
WHERE g.BUSINESS_GROUP_ID = :bg_id
AND :as_of_date BETWEEN g.EFFECTIVE_START_DATE AND g.EFFECTIVE_END_DATE;

Related Objects

• PAY_RATES — Referenced via PAY_GRADE_RULES_F.RATE_ID; supplies the rate definition to which grade rule values belong.
• HR_ALL_ORGANIZATION_UNITS — Referenced via PAY_GRADE_RULES_F.BUSINESS_GROUP_ID; defines the owning business group.
• PAY_GRADE_RULES — The date-effective parent/translation table (via GRADE_RULE_ID) holding grade rule header attributes.
• PER_GRADES — Grade definitions to which grade rules and their rate values apply.
• PER_SPINAL_POINTS — Progression point definitions referenced through GRADE_OR_SPINAL_POINT_ID.
• PAY_RATE_DEFINITIONS — Underlying rate definition metadata associated with PAY_RATES.
• PAY_GRADE_RULES_F_VIEW-style API/view objects and the grade rate validation business logic that consume this table during compensation and payroll processing.