Results for “per_spinal_points”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_SPINAL_POINTS is a core Human Resources configuration table in Oracle E-Business Suite, owned by the HR schema and available in both release 12.1.1 and 12.2.2. It stores the list of progression points that make up a pay scale, otherwise known as a spinal column or salary spine. Each row identifies a discrete point on a defined progression structure, allowing Oracle HRMS and Oracle Payroll to model incremental salary steps used in grade structures, collective agreements, and public-sector pay frameworks. Because pay scales frequently form hierarchies—points grouped beneath a parent spine and further organized through associated steps—the table functions as a bridge between the organizational definition of a business group and the granular increments that employees may occupy.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is satellite-leaning. This modeling suggestion reflects that PER_SPINAL_POINTS carries descriptive attributes tied to its parents rather than acting purely as a relationship link. It is best treated as a descriptive satellite hanging from the pay-scale and business-group hubs, with its own surrogate key providing row identity.

Key Information Stored

The table contains 46 documented columns in the ETRM 12.2.2 physical schema. The most significant are summarized below.

• SPINAL_POINT_ID — the surrogate primary key defined by the unique index PER_SPINAL_POINTS_PK. It uniquely identifies each progression point row.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the point to a specific business group and governing multi-tenancy within HRMS.
• PARENT_SPINE_ID — foreign key to PER_PARENT_SPINES, linking the point to its parent pay spine and establishing the hierarchical relationship between spines and points.
• SEQUENCE — the ordinal position of the point within its spine, used for ordering and reporting.
• SPINAL_POINT — the business-facing name or code of the progression point.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard concurrent program audit columns identifying the process that created or updated the record.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns tracking ownership and change history.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the HRMS business logic to detect concurrent updates.
• INFORMATION_CATEGORY through INFORMATION30 — a flexible attribute block (attribute category and 30 descriptive flexfield segments) for client-specific extensions without schema change.

The SPINAL_POINT_ID surrogate key is the only documented unique business-key candidate; other columns are descriptive or reference attributes.

Common Use Cases and Queries

Typical usage centers on validating and reporting pay-scale structures. Developers frequently join PER_SPINAL_POINTS to PER_SPINAL_POINT_STEPS_F to retrieve the rate or step amount associated with each point, and to PER_PARENT_SPINES to present the full spine hierarchy. A common query pattern retrieves all points for a business group ordered by sequence:

• SELECT spinal_point_id, spinal_point, sequence, parent_spine_id FROM per_spinal_points WHERE business_group_id = :p_bg_id ORDER BY parent_spine_id, sequence;
• Joining to steps for compensation reporting: SELECT p.spinal_point, s.amount FROM per_spinal_points p, per_spinal_point_steps_f s WHERE p.spinal_point_id = s.spinal_point_id;

Reporting scenarios include grade-and-step validation during payroll processing, verifying that an employee's assigned point exists within the correct spine, and generating pay-scale audit extracts for collective bargaining or regulatory submissions.

Related Objects

• PER_PARENT_SPINES — referenced via PARENT_SPINE_ID; defines the parent pay spine to which each point belongs.
• HR_ALL_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID; supplies the business group context.
• PER_SPINAL_POINT_STEPS_F — references PER_SPINAL_POINTS.SPINAL_POINT_ID; holds the step and rate detail for each point.
• PER_SPINAL_POINTS_PK — the primary key unique index enforcing SPINAL_POINT_ID uniqueness.
• Related Oracle HRMS grade and pay-scale views and the PER business components and public APIs that maintain spinal point definitions.