Search Results per_spinal_points




Overview
Explore in AI Chat

Overview

The PER_SPINAL_POINTS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining the individual progression points that constitute a pay scale or salary spine. A spinal point represents a specific step or grade level within a structured pay progression framework, often used in public sector and other organizations with formalized salary bands. The table's primary role is to store the definitional attributes of each point, enabling the system to manage employee compensation, progression rules, and grade-based reporting. It is a foundational table for configuring and administering pay spines within an organization's business group.

Key Information Stored

The table stores metadata that defines each unique progression point. While the full column list is not detailed in the provided metadata, the documented primary and foreign key relationships indicate the critical data elements. The SPINAL_POINT_ID column is the primary key, uniquely identifying each record. The BUSINESS_GROUP_ID column links the point to a specific operating entity (HR_ALL_ORGANIZATION_UNITS), enforcing data security. The PARENT_SPINE_ID column is a foreign key to PER_PARENT_SPINES, which defines the overarching pay scale to which this specific point belongs. Other typical columns in such a structure would include a sequence number (e.g., SEQUENCE), a point value or code, and potentially descriptive fields.

Common Use Cases and Queries

This table is central to compensation administration and reporting. Common use cases include generating salary range reports by spine and point, validating employee salary placements against defined pay scales, and configuring automatic progression rules. A typical query would join PER_SPINAL_POINTS to its parent spine and related step details to list a complete pay structure. For example:

  • SELECT spine.spine_name, point.sequence, point.spinal_point_id FROM per_parent_spines spine, per_spinal_points point WHERE spine.parent_spine_id = point.parent_spine_id AND spine.business_group_id = :p_bg_id ORDER BY spine.spine_name, point.sequence;
  • Integration with employee assignments via the PER_ALL_ASSIGNMENTS_F table to determine which employees are on a specific spinal point.
  • Reporting on the distribution of employees across different points within a spine for workforce planning.

Related Objects

PER_SPINAL_POINTS is a key node in the HR data model with documented relationships to several other objects. The primary key (SPINAL_POINT_ID) is referenced by the foreign key in the PER_SPINAL_POINT_STEPS_F table, which likely holds detailed step increments or rates associated with each point. The table itself has two important foreign key dependencies:

  • HR_ALL_ORGANIZATION_UNITS: Joined via PER_SPINAL_POINTS.BUSINESS_GROUP_ID. This enforces multi-org security, scoping each spinal point to a specific business group.
  • PER_PARENT_SPINES: Joined via PER_SPINAL_POINTS.PARENT_SPINE_ID. This defines the parent pay scale that contains this collection of points.

These relationships ensure data integrity and allow for the hierarchical construction of complete pay scales from the spine definition down to the individual point steps.