Search Results pay_grade_rules_f

Overview

The PAY_GRADE_RULES_F table is a core data structure within the Oracle E-Business Suite (EBS) Human Capital Management (HCM) Payroll module. It functions as the primary repository for storing grade rates and progression point rates, which are fundamental components of compensation management. This table enables the system to define and maintain the specific monetary values or rates associated with job grades or steps within a progression ladder for an employee's position. Its role is critical in automating payroll calculations, ensuring employees are paid according to their designated grade and step within the organizational hierarchy. As a date-effective table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it maintains a full history of rate changes over time, allowing for accurate retroactive payroll processing and historical reporting.

Key Information Stored

The table's structure is designed to link compensation rules to specific organizational and rate definitions. Its primary key is a composite of GRADE_RULE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. Key columns include:

• GRADE_RULE_ID: The unique identifier for a specific grade rule record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE: Define the date range during which the grade rule is active.
• BUSINESS_GROUP_ID: A foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the rule to a specific business group for security and data partitioning.
• RATE_ID: A foreign key to the PAY_RATES table, which holds the actual monetary value, frequency, and currency of the rate associated with this grade or progression point.
• Additional columns typically include attributes for the associated GRADE_ID or PROGRESSION_POINT_ID, and context-sensitive descriptive flexfield columns.

Common Use Cases and Queries

This table is central to compensation analysis, payroll validation, and audit reporting. A common use case is identifying the current effective rate for a specific grade to validate an employee's pay. For example, a payroll administrator might run a query to list all active grade rules for a business group. Sample SQL to find current grade rules and their linked pay rates would be:

SELECT pgr.grade_rule_id, pgr.effective_start_date, pgr.effective_end_date, pr.rate_value, pr.currency_code
FROM pay_grade_rules_f pgr, pay_rates pr
WHERE pgr.rate_id = pr.rate_id
AND SYSDATE BETWEEN pgr.effective_start_date AND pgr.effective_end_date
AND pgr.business_group_id = &business_group_id;

Another critical use case is during payroll runs, where the engine references this table to determine the base pay for an assignment based on its grade. Retroactive payroll processing also relies heavily on the date-effective history stored in this table to recalculate earnings using the historically correct grade rates.

Related Objects

PAY_GRADE_RULES_F is part of a tightly integrated schema within the Payroll module. Key related objects include:

• PAY_RATES (Table): Holds the detailed rate definition (value, frequency, currency) linked via the RATE_ID foreign key. This is the most direct and critical relationship.
• HR_ALL_ORGANIZATION_UNITS (Table): Provides the business group context via the BUSINESS_GROUP_ID foreign key.
• PER_GRADES (Table): Likely referenced via a GRADE_ID column (implied by the table's purpose) to define the job grade itself.
• PAY_PAYROLL_RELATIONS (Table): May reference grade rules to apply rates within specific payroll definitions.
• Various Payroll calculation engines and APIs (e.g., in the PAYXX packages) will read from this table to source compensation data during pay processing.