Results for “hr_org_info_types_by_class”

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

Overview

The HR_ORG_INFO_TYPES_BY_CLASS table is a core configuration object within the Oracle E-Business Suite Human Resources (PER) module. It defines which organization information types are available for specific organization classifications. In effect, it acts as the intersection that governs the visibility and applicability of descriptive flexfield segments and "Extra Information" types across the various classes of organizations modeled in Oracle HRMS, such as business groups, legal entities, operating units, inventory organizations, and reporting establishments.

Because an organization's classification determines which categories of additional information it may carry, this table drives which Extra Information types (EITs) the application presents when a user opens an organization and navigates to the "Others" or classification-specific information region. Each row binds one organization classification to one organization information type, optionally marking that pairing as mandatory and enabling or disabling it. When Oracle HRMS renders the organization form, it joins classifications to information types through this table to determine the appropriate set of configurable fields.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. The table's primary key is essentially a composite of two business descriptors (classification and information type) rather than a single surrogate identifier, and its dependent attributes such as flags and audit columns describe the nature of that relationship. It may be most usefully modeled as a satellite attached to the relationship between classification and information type.

Key Information Stored

The documented physical schema contains ten columns in the HR schema. The most significant attributes are:

• ORG_CLASSIFICATION — The organization classification to which an information type applies (for example, HR_ORGANIZATION_UNITS or INV_ORGANIZATION). This forms part of the primary key.
• ORG_INFORMATION_TYPE — The identifier of the organization information type (Extra Information type) being made available to that classification. This is the second component of the primary key and the foreign key column.
• MANDATORY_FLAG — Indicates whether the information type must be populated for organizations of that classification, enabling required-field enforcement.
• ENABLED_FLAG — Controls whether the classification-and-type pairing is currently active and presented to users.
• ZD_EDITION_NAME — The edition name used by the Oracle EBS 12.2.2 editioning and online patching framework, ensuring the row is visible only within the correct edition.

The primary key is defined as HR_ORG_INFO_TYPES_BY_CLASS_PK. According to the documented unique index, the business-key candidate is the combination of ORG_CLASSIFICATION, ORG_INFORMATION_TYPE, and ZD_EDITION_NAME. On the base table the PK spans ORG_CLASSIFICATION and ORG_INFORMATION_TYPE, with the edition column completing the unique key for the online patching model in 12.2.2. Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) record row-level change history.

Common Use Cases and Queries

Configuration and reporting scenarios typically center on answering which information types are valid for a given organization class, or which classes accept a particular EIT. A representative query to list enabled Extra Information types for one classification is:

SELECT org_information_type, mandatory_flag, enabled_flag
FROM hr_org_info_types_by_class
WHERE org_classification = :p_classification
AND enabled_flag = 'Y';

A reverse lookup identifies all classifications that expose a given information type:

SELECT org_classification, mandatory_flag
FROM hr_org_info_types_by_class
WHERE org_information_type = :p_type_id
AND enabled_flag = 'Y';

Implementation teams use these queries during setup validation to confirm that a newly defined EIT is actually assigned to the intended classification, and auditors use them to verify that mandatory information types are enforced. Because HRMS caches organization setup, changes to this table typically require users to re-query or re-login before new pairings appear.

Related Objects

The most significant related objects, based on the documented foreign key relationships and HRMS design, include:

• HR_ORG_INFORMATION_TYPES — The referenced parent table. Join on HR_ORG_INFO_TYPES_BY_CLASS.ORG_INFORMATION_TYPE = HR_ORG_INFORMATION_TYPES.ORG_INFORMATION_TYPE to resolve type names and descriptions.
• HR_ORGANIZATION_INFORMATION — Stores the actual information values captured for each organization; this table governs which types are permissible there.
• HR_ALL_ORGANIZATION_UNITS — The master organization entity whose classifications constrain which information types apply.
• HR_ORG_CLASSIFICATIONS — Defines the classification codes referenced by ORG_CLASSIFICATION.
• FND_FLEX_VALUES and related flexfield definition tables — Provide the underlying value set and segment metadata behind many information types.

These relationships make HR_ORG_INFO_TYPES_BY_CLASS the connective configuration layer between organization classifications and the extensible information model of Oracle HRMS.