Search Results per_spinal_point_steps_f




Overview
Explore in AI Chat

Overview

The PER_SPINAL_POINT_STEPS_F table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master repository for defining and managing the sequential steps within a grade scale. This table enables the configuration of hierarchical progression paths for positions and employees, which is fundamental for compensation management, career path planning, and organizational structuring. Its role is to establish the incremental order of steps (e.g., Step 1, Step 2) associated with specific spinal points or grades, allowing for detailed control over pay scales and promotion ladders within a business group.

Key Information Stored

The table stores the definition of each step within a grade scale, with a primary key that supports effective-dated tracking. The most critical columns include STEP_ID, which uniquely identifies a step record, and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the period for which the step definition is valid. The SPINAL_POINT_ID is a foreign key that links the step to its parent grade or spinal point defined in the PER_SPINAL_POINTS table. The BUSINESS_GROUP_ID column anchors the data to a specific organizational unit, enforcing data security at the business group level. Additional columns, implied by the table's purpose, would typically store attributes like a sequence number to define the step's order within the grade and potentially descriptive information.

Common Use Cases and Queries

This table is central to operations involving grade and step administration. Common use cases include generating reports on an organization's complete grade-step matrix, validating compensation against approved pay scales, and automating promotion workflows that move an employee to the next sequential step. A typical query would join this table to the grade definition to list all steps for a specific grade scale.

  • Sample Query: To retrieve all active steps for a specific spinal point, a query would filter on SPINAL_POINT_ID and the current date falling between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, ordered by the step sequence.
  • Reporting Use Case: Compensation analysts use this data to create reports that map job positions to their corresponding grade and step, forming the basis for salary benchmarking and budget planning.

Related Objects

The PER_SPINAL_POINT_STEPS_F table has defined foreign key relationships with other critical HRMS tables, as documented in the ETRM metadata.

  • HR_ALL_ORGANIZATION_UNITS: Linked via the BUSINESS_GROUP_ID column. This relationship ensures all grade steps are scoped to a valid business group, maintaining the application's multi-org security model.
  • PER_SPINAL_POINTS: Linked via the SPINAL_POINT_ID column. This is the primary parent relationship, where each step record must belong to a defined grade or spinal point. This table defines the broader grade, while PER_SPINAL_POINT_STEPS_F defines its constituent steps.

This table is also a likely parent to other objects not listed in the provided excerpt, such as assignments or compensation records that store an employee's current grade step.