Search Results hr_h2pi_organization_class




Overview
Explore in AI Chat

Overview

HR.HR_H2PI_ORGANIZATION_CLASS is a Human Resources (PER) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores H2PI-classified organization attribute data. The H2PI designation relates to the organization classification and hierarchy processing infrastructure used to persist derived organization information—such as classification codes, category assignments, and related descriptive attributes—against a specific organization and business group context.

Functionally, the table acts as a companion to HR_ORGANIZATION_INFORMATION, holding organization-classification records keyed by an organization identifier, a client discriminator, and a business group identifier. The ETRM metadata classifies this table heuristically as standalone under the Data Vault classification exercise, meaning the mined foreign-key structure does not reveal hub-and-link patterns typical of a central entity or transactional relationship. In a Data Vault modeling suggestion, this object would best be represented as a satellite hanging off an organization hub, since it stores descriptive, context-qualified attributes (ORG_INFORMATION_CONTEXT, ORG_INFORMATION1, ORG_INFORMATION2, STATUS) about an organization rather than representing a distinct business entity or an associative relationship between two entities.

Key Information Stored

The table contains nine documented columns in the 12.2.2 physical schema. The most significant are:

  • ORGANIZATION_ID — Part of the composite primary key; identifies the organization to which the classification row belongs.
  • CLIENT_ID — Part of the composite primary key; the client discriminator used in multi-tenant and Multi-Org contexts.
  • BUSINESS_GROUP_ID — Part of the composite primary key; scopes the record to a specific HR business group, which is the primary security and partitioning boundary in PER.
  • ORG_INFORMATION_ID — Foreign key to HR_ORGANIZATION_INFORMATION; links the classification row to the parent organization-information record.
  • ORG_INFORMATION_CONTEXT — The context or classification type that qualifies the attribute payload (for example, a descriptive flexfield context or organization-class code).
  • ORG_INFORMATION1 and ORG_INFORMATION2 — Generic attribute columns holding the classification value pairs associated with the org-information context.
  • STATUS — Indicates the active or inactive state of the classification record.
  • LAST_UPD_DATE — Audit timestamp recording the most recent modification to the row.

The surrogate/business key is defined by the primary key constraint HR_H2PI_ORGANIZATION_CLASS_PK on the composite (ORGANIZATION_ID, CLIENT_ID, BUSINESS_GROUP_ID). No separate unique index is documented, so these three columns together serve as the effective business-key candidate set. The ORG_INFORMATION_ID column carries the only documented referential constraint.

Common Use Cases and Queries

Typical usage centers on resolving organization classifications for a business group, validating that a given organization carries the expected H2PI classification, and reporting on classification coverage across a business group. A representative query joining to the parent information table is:

  • SELECT c.ORGANIZATION_ID, c.ORG_INFORMATION_CONTEXT, c.ORG_INFORMATION1, c.ORG_INFORMATION2, c.STATUS FROM HR.HR_H2PI_ORGANIZATION_CLASS c WHERE c.BUSINESS_GROUP_ID = :p_bg_id AND c.STATUS = 'A';
  • Join pattern: SELECT c.*, i.* FROM HR.HR_H2PI_ORGANIZATION_CLASS c JOIN HR.HR_ORGANIZATION_INFORMATION i ON i.ORG_INFORMATION_ID = c.ORG_INFORMATION_ID;
  • Audit pattern: filter on LAST_UPD_DATE to identify rows modified after a given date for incremental extraction or reconciliation.

Common scenarios include troubleshooting missing organization classifications after a business group copy or setup migration, building extracts for downstream HR analytics, and reconciling classification rows between source and target environments.

Related Objects

  • HR_ORGANIZATION_INFORMATION — The documented parent referenced by the ORG_INFORMATION_ID foreign key; the primary join target.
  • HR_ALL_ORGANIZATION_UNITS — Source of the ORGANIZATION_ID business entity against which classification rows are keyed.
  • HR_ORGANIZATION_UNITS — Base organization definition table joined via ORGANIZATION_ID.
  • HR_ORGANIZATION_UNITS_F — Date-tracked organization records used for point-in-time classification reporting.
  • PER_BUSINESS_GROUPS — Provides the BUSINESS_GROUP_ID context used for scoping and security.
  • FND_ID_FLEX_STRUCTURES and related flexfield objects — Describe the context semantics used in ORG_INFORMATION_CONTEXT.
  • PER_ORGANIZATION_CLASS_API (or equivalent PER organization API routines) — Programmatic maintenance paths for organization classification data.