Search Results hr_org_information_types




Overview
Explore in AI Chat

Overview

The HR_ORG_INFORMATION_TYPES table is a core reference table within the Oracle E-Business Suite Human Resources (HRMS) module. It defines the valid information types, or contexts, that can be used to store additional descriptive attributes for an organization. In Oracle EBS, organizations are generic entities representing any operational unit, such as a company, division, department, or job. This table provides the master list of available "buckets" or categories of information—like financial details, classification data, or reporting structures—that can be attached to these organizations. Its primary role is to enforce data integrity by controlling what types of organization-specific information can be created, ensuring consistency across the application.

Key Information Stored

The table's structure is relatively simple, as it serves as a lookup or validation entity. The most critical column is ORG_INFORMATION_TYPE, which is the table's primary key. This column stores the unique code that identifies each information context, such as 'ORG_CLASS', 'FACILITY_INFORMATION', or 'FINANCIAL_INFORMATION'. While the provided ETRM metadata does not list all columns, typical implementation columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are almost certainly present to track row history. The table's design ensures that the ORG_INFORMATION_TYPE value is the central, controlled point of reference for all organization-related descriptive flexfields and supplementary data.

Common Use Cases and Queries

The primary use case is to query the valid list of information types available for defining organization details, often for setup, reporting, or data validation purposes. A common SQL pattern is to join this table with HR_ORGANIZATION_INFORMATION, which holds the actual data values for each type. For example, to retrieve all financial information defined for organizations, one might use a query such as:

  • SELECT hou.name, hoi.org_information1, hoi.org_information2
  • FROM hr_organizations hou,
  • hr_organization_information hoi,
  • hr_org_information_types hoit
  • WHERE hou.organization_id = hoi.organization_id
  • AND hoi.org_information_context = hoit.org_information_type
  • AND hoit.org_information_type = 'FINANCIAL_INFORMATION';

This table is also central when configuring which information types are applicable to specific organization classifications via the related HR_ORG_INFO_TYPES_BY_CLASS table.

Related Objects

As indicated by the foreign key relationships in the metadata, HR_ORG_INFORMATION_TYPES is directly referenced by two key tables. First, the HR_ORGANIZATION_INFORMATION table uses ORG_INFORMATION_TYPE as a foreign key in its ORG_INFORMATION_CONTEXT column; this is where the actual descriptive data for each organization and information type is stored. Second, the HR_ORG_INFO_TYPES_BY_CLASS table references it, governing which information types are enabled for specific organization classes (e.g., departments, divisions). Administratively, this table is also integral to the underlying setup of the Organization descriptive flexfield, which provides the user interface for entering the information defined by these types.