Search Results pay_rates

Overview

The PAY_RATES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) and Payroll modules. It serves as the master repository for defining pay rates or pay scales that can be associated with job grades. This table is fundamental for establishing structured compensation frameworks, enabling organizations to define standard rates of pay, such as hourly wages or annual salaries, which are then linked to specific grades via grade rules. Its role is central to the configuration and administration of the compensation and payroll functions, ensuring that pay calculations are based on consistent, predefined rate definitions.

Key Information Stored

The table stores the definitional attributes for each pay rate. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal critical data points. The RATE_ID column is the unique primary key identifier for each pay rate record. The BUSINESS_GROUP_ID column links the rate to a specific business group, enforcing data security and partitioning at the HR organizational level. The PARENT_SPINE_ID column establishes a relationship to parent pay spines (PER_PARENT_SPINES), which is essential for managing complex, hierarchical pay scale structures. Other typical columns in such a table would include the rate name, currency, effective start and end dates (supporting date-tracking), and the actual rate value or a mechanism to derive it.

Common Use Cases and Queries

This table is primarily accessed for compensation setup, reporting, and payroll processing. Common scenarios include generating a list of all active pay rates within a business group for audit purposes, or identifying which grades are linked to specific rates for a compensation review. A typical query pattern involves joining PAY_RATES with related tables like PAY_GRADE_RULES_F to understand grade-rate mappings. For example, a report to show all grade rules with their associated rate names might use SQL similar to:

• SELECT pr.rate_id, pr.name rate_name, pgr.grade_id FROM pay_rates pr, pay_grade_rules_f pgr WHERE pr.rate_id = pgr.rate_id AND SYSDATE BETWEEN pgr.effective_start_date AND pgr.effective_end_date;

Data in this table is also critical for payroll calculations, where the system references the defined rate to compute an employee's earnings.

Related Objects

The PAY_RATES table has integral relationships with several other EBS objects, as indicated by its foreign keys. It is referenced by the PAY_GRADE_RULES_F table, which applies these rates to specific grades. The PER_PAY_BASES table also references PAY_RATES, linking pay bases (like "Annual Salary" or "Hourly") to the concrete rate definitions. Furthermore, it holds foreign keys to HR_ALL_ORGANIZATION_UNITS (for the business group) and PER_PARENT_SPINES (for pay spine hierarchy). These relationships underscore its position as a central hub in the compensation data model, connecting organizational structure, grade definitions, and pay calculation bases.