Search Results per_pos_structure_versions

Overview

The table PER_POS_STRUCTURE_VERSIONS is a core data object within the Oracle E-Business Suite Human Resources (HR) module. It serves as a version control mechanism for position hierarchies, enabling organizations to model and maintain changes to their reporting structures over time. Each row in this table represents a distinct, dated version of a specific position hierarchy, allowing for historical tracking and future-dated structural changes. Its role is critical for maintaining data integrity in organizational reporting, succession planning, and workforce analysis, as it anchors the relationships between positions defined within a hierarchy.

Key Information Stored

The table's primary identifier is the POS_STRUCTURE_VERSION_ID. Key columns include POSITION_STRUCTURE_ID, which links to the parent hierarchy definition in PER_POSITION_STRUCTURES, and BUSINESS_GROUP_ID, which links to the operating unit in HR_ALL_ORGANIZATION_UNITS. Other essential columns are DATE_FROM and DATE_TO, which define the effective start and end dates for which this version of the hierarchy is active. This versioning model allows multiple, non-overlapping effective-dated records for a single position structure, forming a complete history.

Common Use Cases and Queries

A primary use case is retrieving the active position hierarchy version for reporting or validation at a given point in time. This is fundamental for processes like generating organizational charts or validating supervisory assignments. The table is also directly referenced by the Global Human Resources (GHR) processes for mass organizational changes, as indicated by the foreign key relationships from GHR_MASS_REALIGNMENT and GHR_MASS_TRANSFERS. A user searching for "ghr_mass_transfers" would encounter this table as it stores the OLD_POS_STRUCTURE_VERSION_ID to track the hierarchy version before a mass transfer. A common query pattern finds the current version for a structure:

• SELECT * FROM per_pos_structure_versions WHERE position_structure_id = :p_struct_id AND SYSDATE BETWEEN date_from AND NVL(date_to, SYSDATE);

Related Objects

PER_POS_STRUCTURE_VERSIONS is a central hub in the position hierarchy data model. It has a primary key referenced by PER_POS_STRUCTURE_ELEMENTS, which stores the actual parent-child position relationships for each version. It is a foreign key parent to tables supporting specific functionalities: GHR_MASS_REALIGNMENT and GHR_MASS_TRANSFERS (for U.S. Federal HR processes), and PQH_ROUTING_HISTORY (for position management workflows). It is itself a child table, referencing PER_POSITION_STRUCTURES for the hierarchy definition and HR_ALL_ORGANIZATION_UNITS for the business group context.