Results for “hr_org_information_types”

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

Overview

HR_ORG_INFORMATION_TYPES is a Human Resources (PER) setup table in the HR schema that defines the categories of descriptive information that may be attached to an organization. Each row represents a distinct information type — for example, an organization classification, a legal reporting attribute, or a legislative identifier — and drives how the corresponding detail records are captured, validated, and presented in Oracle E-Business Suite 12.1.1 and 12.2.2. The table acts as the controlling vocabulary for the HR_ORGANIZATION_INFORMATION extension mechanism, ensuring that every organization-level attribute is associated with a governed type rather than being stored as an unconstrained value.

In Data Vault terms, the heuristic classification mined from the foreign-key structure is hub-leaning. This suggests a modeling approach in which ORG_INFORMATION_TYPE functions as the natural business key of a hub, with the descriptive columns behaving as hub attributes rather than as a standalone satellite. The dependency pattern supports this: HR_ORGANIZATION_INFORMATION and HR_ORG_INFO_TYPES_BY_CLASS both reference this table, making it an integration point rather than a transactional detail store.

Key Information Stored

The documented physical schema contains thirteen columns. The most significant are listed below.

• ORG_INFORMATION_TYPE — the primary key of HR_ORG_INFORMATION_TYPES_PK. This is the stable identifier referenced by all dependent tables and is the business key candidate for the type itself.
• DESCRIPTION — the user-facing label for the information type.
• DESTINATION — indicates where the collected information is routed or applied within the application.
• DISPLAYED_ORG_INFORMATION_TYPE — controls the alternate or display-oriented presentation of the type.
• FND_APPLICATION_ID — ties the information type to the owning Oracle Application Object Library application, enabling product-specific type sets.
• LEGISLATION_CODE — restricts the information type to a specific legislative context, supporting country-specific organization data requirements.
• NAVIGATION_METHOD — defines how the type is reached in the user interface.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• ZD_EDITION_NAME — the editioning column present in 12.2.x, which participates with ORG_INFORMATION_TYPE in the unique primary key index HR_ORG_INFORMATION_TYPES_PK.

The surrogate-versus-business-key distinction is important here: ORG_INFORMATION_TYPE is the functional identifier, while the unique index combines it with ZD_EDITION_NAME to enforce uniqueness per edition in the 12.2.2 schema.

Common Use Cases and Queries

The most frequent requirement is to resolve organization detail rows to their descriptive type. A typical reporting join pattern follows:

• Join HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT to HR_ORG_INFORMATION_TYPES.ORG_INFORMATION_TYPE to label each organization attribute with its DESCRIPTION.
• Filter by LEGISLATION_CODE to retrieve only the information types applicable to a country's statutory reporting.
• Filter by FND_APPLICATION_ID to isolate the information types owned by a particular product, which is useful when auditing which module introduced a given organization attribute.
• Join through HR_ORG_INFO_TYPES_BY_CLASS to determine which information types are enabled for a particular organization classification, a common pattern when validating organization setup completeness.
• Compare rows across editions using ZD_EDITION_NAME when analyzing 12.2.2 editioning behavior or diagnosing why an organization attribute is unexpectedly unavailable.

Related Objects

• HR_ORGANIZATION_INFORMATION — references this table via ORG_INFORMATION_CONTEXT; stores the actual organization-level values for each type.
• HR_ORG_INFO_TYPES_BY_CLASS — references ORG_INFORMATION_TYPE; maps information types to organization classifications.
• HR_ORGANIZATION_UNITS — the organization master that supplies the organization_id used in reporting joins.
• FND_APPLICATION — resolves FND_APPLICATION_ID to the owning application.
• FND_LANGUAGES / FND_TERRITORIES — commonly joined against LEGISLATION_CODE for country-context reporting.