Search Results per_parent_spines




Overview
Explore in AI Chat

Overview

The PER_PARENT_SPINES table is a core data structure within the Oracle E-Business Suite Human Resources (HR) module. It serves as the master repository for defining and storing pay scales, which were historically referred to as "parent spines." A parent spine represents a foundational pay structure or salary scale, typically defined at the business group level. These structures are essential for systematic compensation management, providing the framework to which specific grade spines, spinal points, and pay rates are linked. The table's role is to establish the high-level definition of a pay scale, enabling consistent and rule-based compensation administration across the organization.

Key Information Stored

The table stores the defining attributes of each pay scale. The primary identifier is the PARENT_SPINE_ID, a system-generated unique key. The NAME column holds the descriptive title of the pay scale, such as "Executive Pay Scale" or "Technical Grade Scale." Each pay scale is scoped to a specific BUSINESS_GROUP_ID, which links to the HR_ALL_ORGANIZATION_UNITS table, ensuring data isolation and security by business group. While the provided metadata focuses on these core columns, the table likely contains additional standard HR columns for tracking creation date, last update date, and the user responsible for the changes, supporting auditability and data lifecycle management.

Common Use Cases and Queries

This table is central to compensation setup and reporting. A common administrative task is to retrieve all pay scales defined for a specific business group to review or maintain the compensation framework. The following query exemplifies this:

  • SELECT PARENT_SPINE_ID, NAME FROM HR.PER_PARENT_SPINES WHERE BUSINESS_GROUP_ID = &BUSINESS_GROUP ORDER BY NAME;

For reporting purposes, analysts often join this table to related objects to generate comprehensive compensation catalogs. A typical report might list all pay scales alongside their associated spinal points and corresponding pay rates, providing a complete view of the salary structure. Data from this table is also critical for processes that calculate entitlements, such as those managed via the Collective Agreement (CAGR) functionality, where eligibility for certain pay scales is determined.

Related Objects

The PER_PARENT_SPINES table has defined relationships with several key HR tables, acting as a parent entity in the compensation data model. The documented foreign key relationships are as follows:

  • PAY_RATES: References PER_PARENT_SPINES.PARENT_SPINE_ID via PAY_RATES.PARENT_SPINE_ID. This links the pay scale definition to the specific monetary values or formulas for pay.
  • PER_CAGR_ENTITLEMENT_LINES_F: References PER_PARENT_SPINES.PARENT_SPINE_ID via PER_CAGR_ENTITLEMENT_LINES_F.PARENT_SPINE_ID. This ties pay scales to collective agreement entitlements.
  • PER_GRADE_SPINES_F: References PER_PARENT_SPINES.PARENT_SPINE_ID via PER_GRADE_SPINES_F.PARENT_SPINE_ID. This associates the parent pay scale with specific grade-level spine definitions.
  • PER_SPINAL_POINTS: References PER_PARENT_SPINES.PARENT_SPINE_ID via PER_SPINAL_POINTS.PARENT_SPINE_ID. This defines the individual step points (e.g., Point 1, Point 2) within the overall pay scale.

Furthermore, the table itself references HR_ALL_ORGANIZATION_UNITS via its BUSINESS_GROUP_ID column, anchoring each pay scale to a business group.