Results for “per_parent_spines”

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

Overview

PER_PARENT_SPINES is a core Human Resources table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the HR schema and delivered under the PER (Human Resources) product. The table stores the definition of pay scales, which were historically known as "parent spines" — the top-level containers that group related spinal points and grade spine mappings into a coherent pay structure. In older terminology the "spine" represented the hierarchy of pay progression steps within a grade or pay scale, and PER_PARENT_SPINES acts as the master header record from which the detailed spine structure is derived.

Each row in this table represents a single pay scale definition, uniquely identified by PARENT_SPINE_ID and scoped to a specific business group. Because the table holds the canonical, slowly-changing definition of a pay scale and is referenced by many downstream tables through foreign keys, the heuristic Data Vault classification positions it as a hub-leaning entity. As a modeling suggestion, this table behaves like a hub: it carries a stable surrogate key (PARENT_SPINE_ID), a natural business key composed of NAME and BUSINESS_GROUP_ID, and descriptive attributes. Downstream tables such as PER_SPINAL_POINTS and PER_GRADE_SPINES_F function as satellites or link tables referencing this hub, recording the detailed points and grade associations that make up the pay scale.

Key Information Stored

The table contains 69 documented columns, but the columns of greatest functional importance are a relatively small subset. The surrogate primary key is PARENT_SPINE_ID, enforced through the PER_PARENT_SPINES_PK index. The business-key candidate is the combination of NAME and BUSINESS_GROUP_ID, enforced by the unique index PER_PARENT_SPINES_UK2. This means a pay scale name must be unique within a given business group.

• PARENT_SPINE_ID — surrogate primary key identifying the pay scale; the parent value for all dependent spine-related tables.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS; determines the enterprise/business group that owns the pay scale definition.
• NAME — the business-facing name of the pay scale; combined with BUSINESS_GROUP_ID it forms the unique business key.
• INCREMENT_FREQUENCY and INCREMENT_PERIOD — control the periodicity of automatic progression increments along the spine.
• LAST_AUTOMATIC_INCREMENT_DATE — records when automatic increments were last applied, supporting the pay progression engine.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent request and program context columns recording which process created or last updated the row.
• COMMENTS — free-text notes describing the pay scale.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — developer extensibility (DDF) flexfield columns.
• INFORMATION_CATEGORY and INFORMATION1 through INFORMATION30 — additional descriptive flexfield columns reserved for customer-defined information.

Common Use Cases and Queries

Typical usage centers on reporting and validation of pay structures, integration with payroll and compensation processes, and troubleshooting pay progression. Common queries retrieve all pay scales for a business group, join to grade spine mappings, or examine increment configuration.

Listing pay scales for a business group:

SELECT parent_spine_id, name, increment_frequency, increment_period
FROM   per_parent_spines
WHERE  business_group_id = :p_business_group_id;

Joining pay scales to their spinal points:

SELECT ps.name, sp.spinal_point_id, sp.point_value
FROM   per_parent_spines ps, per_spinal_points sp
WHERE  ps.parent_spine_id = sp.parent_spine_id
AND    ps.business_group_id = :p_business_group_id;

Other frequent scenarios include auditing grade spine configurations via PER_GRADE_SPINES_F, verifying entitlement calculations from PER_CAGR_ENTITLEMENT_RESULTS, and cross-checking pay rates defined against each spine in PAY_RATES.

Related Objects

The following documented relationships are the most significant for understanding and navigating this table.

• HR_ALL_ORGANIZATION_UNITS — referenced via PER_PARENT_SPINES.BUSINESS_GROUP_ID; provides the owning business group.
• PER_SPINAL_POINTS — references this table through PARENT_SPINE_ID; holds the individual points that comprise the pay scale.
• PER_GRADE_SPINES_F — references PARENT_SPINE_ID; maps grades to spines within the pay structure.
• PER_SPINAL_POINT_PLACEMENTS_F — references PARENT_SPINE_ID; records employee placements at specific spine points.
• PAY_RATES — references PARENT_SPINE_ID; stores pay rate definitions tied to the spine.
• PER_CAGR_ENTITLEMENT_LINES_F, PER_CAGR_ENTITLEMENT_RESULTS, and PER_CAGR_RETAINED_RIGHTS — all reference PARENT_SPINE_ID; drive collective agreement (CAGR) entitlement calculation, results, and retained rights processing.

When querying or extracting pay scale data, always filter by BUSINESS_GROUP_ID to respect the multi-tenant business group partition and to align with the unique key definition.