Search Results per_grade_spines_f




Overview
Explore in AI Chat

Overview

The PER_GRADE_SPINES_F table is a core data structure within the Oracle E-Business Suite Human Resources (HR) module, specifically in releases 12.1.1 and 12.2.2. As a date-effective table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE/END_DATE columns), it is designed to maintain a historical record of changes to grade progression points over time. Its primary role is to define and store the detailed spine or ladder of progression points associated with individual grades within a grade scale. This table enables the configuration of complex compensation and career progression frameworks, allowing organizations to model salary ranges, steps, and advancement criteria for positions assigned to specific grades.

Key Information Stored

The table's structure centers on linking a grade to its progression spine while maintaining temporal validity. The primary key is a composite of GRADE_SPINE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. Key columns include:

  • GRADE_SPINE_ID: The unique identifier for a specific grade spine record.
  • GRADE_ID: A foreign key to the PER_GRADES table, identifying the grade to which this spine applies.
  • PARENT_SPINE_ID: A foreign key to PER_PARENT_SPINES, linking to the overarching spine or scale definition that contains multiple progression points.
  • BUSINESS_GROUP_ID: A foreign key to HR_ALL_ORGANIZATION_UNITS, securing the data to a specific business group for multi-organization support.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: Define the period during which this specific grade-to-spine assignment is active, enabling historical tracking and future-dated updates.

Common Use Cases and Queries

This table is central to processes involving grade-based compensation and position management. A primary use case is generating reports that list all active progression points (e.g., salary steps) for a given grade, which is essential for compensation planning and employee advancement workflows. System administrators use this data when setting up or modifying grade scales. A typical query retrieves the current valid spine for a specific grade:

SELECT g.NAME, ps.NAME, pgs.effective_start_date
FROM per_grade_spines_f pgs,
per_grades g,
per_parent_spines ps
WHERE pgs.grade_id = g.grade_id
AND pgs.parent_spine_id = ps.parent_spine_id
AND g.NAME = '&grade_name'
AND SYSDATE BETWEEN pgs.effective_start_date AND pgs.effective_end_date;

Another critical use is in payroll and compensation calculations, where the assigned spine point for an employee's grade determines their specific pay rate within the grade's range.

Related Objects

PER_GRADE_SPINES_F is a nexus table within the HR grade and compensation schema. Its key relationships, as defined by its foreign keys, are:

  • PER_GRADES: The foundational table for grade definitions. PER_GRADE_SPINES_F assigns a progression spine to a grade from this table.
  • PER_PARENT_SPINES: The master table defining a complete scale or spine (e.g., "Administrative Salary Scale"). A single parent spine can be linked to multiple grades via PER_GRADE_SPINES_F.
  • HR_ALL_ORGANIZATION_UNITS: Provides the BUSINESS_GROUP_ID for data security and partitioning.

This table is also closely related to other compensation objects, such as those defining grade rates (PER_GRADE_RATES_F) and potentially employee assignments that reference a specific spine point within a grade.