Results for “per_pos_structure_versions”

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

Overview

PER_POS_STRUCTURE_VERSIONS is a Human Resources (PER) module table owned by the HR schema that stores version control information for specific position hierarchies defined in Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, position structures represent hierarchical arrangements of positions—typically organization charts built from positions. Because these hierarchies change over time (through reorganizations, mass realignments, or structural edits), Oracle captures a discrete, dated version of each structure so that historical reporting, routing, and retrospective analysis remain accurate.

Each row records one version of a position structure, identified by the primary key POS_STRUCTURE_VERSION_ID, and tied back to its parent structure via POSITION_STRUCTURE_ID. The table therefore acts as the anchor point that downstream functional areas—such as Public Sector/HR routing (PQH_ROUTING_HISTORY), performance management, benefits, and mass transfer/realignment processes—reference when they need to point at a specific hierarchy snapshot rather than a structure abstractly. Based on the mined foreign key topology, the object is heuristically classified as hub-leaning: it holds a stable surrogate identifier that many surrounding tables reference, which is characteristic of a Data Vault hub. This is a modeling suggestion for downstream tooling, not an enforced EBS constraint.

Key Information Stored

Of the 17 documented columns, the following are the most significant. The surrogate primary key is POS_STRUCTURE_VERSION_ID (unique index PER_POS_STRUCTURE_VERSIONS_PK). There is no separate documented business-key unique index beyond the surrogate, so uniqueness of a version is effectively scoped by the structure plus its validity dates.

• POS_STRUCTURE_VERSION_ID – Surrogate primary key uniquely identifying one version.
• POSITION_STRUCTURE_ID – Foreign key to PER_POSITION_STRUCTURES; identifies the parent hierarchy this version belongs to.
• BUSINESS_GROUP_ID – Foreign key to HR_ALL_ORGANIZATION_UNITS; scopes the record to a business group (multi-tenant partition).
• DATE_FROM / DATE_TO – Effective start and end dates bounding the validity of the version.
• VERSION_NUMBER – Sequence number of this version within the structure.
• COPY_STRUCTURE_VERSION_ID – References the version this one was copied from, supporting version-to-version lineage.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrent program/request context identifying the process that created or updated the version.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER – Standard WHO audit columns and optimistic-locking version.

Common Use Cases and Queries

Typical uses include reconstructing a position hierarchy as it existed on a given date, tracing the source version of a copied structure, and joining version context onto routing or mass-transfer activity.

• Resolve the active version for a structure at a point in time, filtering on DATE_FROM/DATE_TO.
• Trace copy lineage by joining COPY_STRUCTURE_VERSION_ID back to POS_STRUCTURE_VERSION_ID.
• Identify versions created by a specific concurrent request via REQUEST_ID/PROGRAM_ID.

Illustrative pattern:

• SELECT v.POS_STRUCTURE_VERSION_ID, v.VERSION_NUMBER, v.DATE_FROM, v.DATE_TO FROM HR.PER_POS_STRUCTURE_VERSIONS v WHERE v.POSITION_STRUCTURE_ID = :p_structure AND :p_eff_date BETWEEN v.DATE_FROM AND NVL(v.DATE_TO, :p_eff_date);

Related Objects

The following referenced and referencing objects are the most significant:

• PER_POSITION_STRUCTURES – Parent structure; join on POSITION_STRUCTURE_ID.
• PER_POS_STRUCTURE_ELEMENTS – Child elements of the hierarchy; join on POS_STRUCTURE_VERSION_ID.
• PQH_ROUTING_HISTORY – Routing records for the version; join on POS_STRUCTURE_VERSION_ID (the user's original search term).
• GHR_MASS_REALIGNMENT and GHR_MASS_TRANSFERS – Reorganization/mass-transfer processes; join on OLD_POS_STRUCTURE_VERSION_ID.
• HR_ALL_ORGANIZATION_UNITS – Business group context; join on BUSINESS_GROUP_ID.
• PER_PERF_MGMT_PLANS and BEN_ENRT_PERD – Referencing plan/enrollment tables; join on POS_STRUCTURE_VERSION_ID.