Results for “primary_structure_flag”

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

Overview

PER_ORGANIZATION_STRUCTURES is an Oracle E-Business Suite Human Resources (PER) table that stores organization hierarchy names and their defining attributes. It serves as the master registry for organization structures—such as position hierarchies, organization hierarchies, and other reporting or functional groupings—that are used throughout Oracle HRMS and integrated modules. Each row represents one named hierarchy within a specific business group, and the table functions as the anchor point for versions, security profiles, and downstream planning or reporting logic that reference a hierarchy by identifier.

From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as a hub. This is appropriate because the table carries a surrogate primary key (ORGANIZATION_STRUCTURE_ID) that acts as the stable identity for each structure, with descriptive attributes and audit columns layered alongside it. In a rigorous Data Vault design, the descriptive fields would typically be split into a satellite, but the hub classification reflects the table's central role as the referenced entity.

Key Information Stored

The table is owned by the HR schema and contains 37 documented columns. The most significant columns are:

• ORGANIZATION_STRUCTURE_ID — Surrogate primary key (PER_ORGANIZATION_STRUCTURE_PK) that uniquely identifies each hierarchy.
• NAME — The hierarchy name; combined with BUSINESS_GROUP_ID it forms the unique business key (PER_ORGANIZATION_STRUCTURE_UK2).
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the structure to a business group.
• PRIMARY_STRUCTURE_FLAG — Indicates whether the structure is the primary hierarchy for its business group.
• POSITION_CONTROL_STRUCTURE_FLG — Flags a structure used for position control.
• COMMENTS — Free-text description of the hierarchy.
• OBJECT_VERSION_NUMBER — Optimistic locking column introduced for concurrent update control in release 12.x.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who columns for audit and traceability.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context captured on insert or update.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — Descriptive flexfield storage for client-specific extensions.

The surrogate key (ORGANIZATION_STRUCTURE_ID) is the operational join column used by child tables, while the business-key candidate (NAME, BUSINESS_GROUP_ID) enforces uniqueness of hierarchy names within a business group.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing all hierarchies for a business group, identifying the primary hierarchy, and retrieving structure details for a security profile or a versioned hierarchy.

• Listing named hierarchies within a business group:

  SELECT organization_structure_id, name, primary_structure_flag
  FROM   per_organization_structures
  WHERE  business_group_id = :p_business_group_id;

• Identifying the primary hierarchy:

  SELECT organization_structure_id, name
  FROM   per_organization_structures
  WHERE  business_group_id = :p_business_group_id
  AND    primary_structure_flag = 'Y';

• Retrieving versions of a hierarchy by joining to PER_ORG_STRUCTURE_VERSIONS.
• Populating LOVs and value sets for concurrent program parameters that accept an organization structure.
• Auditing structure creation and maintenance via the Who columns and concurrent request identifiers.

Related Objects

The following objects reference or depend on PER_ORGANIZATION_STRUCTURES through documented foreign keys:

• PER_ORG_STRUCTURE_VERSIONS — references ORGANIZATION_STRUCTURE_ID; holds dated versions of each hierarchy.
• PER_SECURITY_PROFILES — references ORGANIZATION_STRUCTURE_ID; ties security profiles to a hierarchy.
• HR_ALL_ORGANIZATION_UNITS — referenced by BUSINESS_GROUP_ID; provides the owning business group.
• PA_IMPLEMENTATIONS_ALL and PA_IND_RATE_SCHEDULES_ALL_BG / PA_IND_RATE_SCH_REVISIONS — Projects (PA) tables that reference the structure for implementation and indirect rate schedule configuration.
• IGW_IMPLEMENTATIONS_ALL — references the structure through APR_ORG_STRUCTURE_ID and PRP_ORG_STRUCTURE_ID.
• PQH_RULE_SETS — references ORGANIZATION_STRUCTURE_ID for ruleset configuration.
• Additional referencing tables include PER_PERF_MGMT_PLANS, PER_CALENDAR_ENTRIES, HRI_ORG_PARAMS, HRI_ORG_HRCHY_SUMMARY, GHR_BREAKDOWN_CRITERIA, and PJI_SYSTEM_SETTINGS, confirming the table's role as a widely referenced hub across HRMS and adjacent modules.