Search Results hr_org_info_types_by_class




Overview
Explore in AI Chat

Overview

The HR_ORG_INFO_TYPES_BY_CLASS table is a core configuration table within the Oracle E-Business Suite Human Resources (PER) module. It functions as a control mechanism that governs which organization information types are available for data entry based on an organization's classification. This table enforces data integrity and ensures that users can only define relevant information for specific types of organizations, such as departments, divisions, or cost centers. Its role is pivotal in maintaining the structured and classification-specific nature of organizational data within the HRMS foundation.

Key Information Stored

The table's structure is straightforward, consisting primarily of two key columns that form its primary key. The ORG_CLASSIFICATION column stores the code for an organization classification, such as 'DEPARTMENT' or 'COMPANY'. The ORG_INFORMATION_TYPE column stores the name of an organization information type, which defines a specific category of descriptive information, like 'Cost Allocation' or 'Reporting Information'. The relationship defined by each row explicitly permits the specified information type to be used for organizations belonging to the specified classification. This pairing is enforced by a foreign key constraint linking ORG_INFORMATION_TYPE to the HR_ORG_INFORMATION_TYPES table.

Common Use Cases and Queries

A primary use case is the setup and validation of organization details forms. When a user enters information for a new department, the application queries this table to determine which information type segments should be displayed. Administrators use this table during implementation to tailor the system to business needs by granting or restricting information types. Common queries include listing all enabled information types for a specific classification or identifying which classifications can use a particular information type.

  • To find all information types available for the 'DEPARTMENT' classification:
    SELECT org_information_type FROM hr_org_info_types_by_class WHERE org_classification = 'DEPARTMENT';
  • To verify if a specific information type is valid for a given organization's classification:
    SELECT 'Y' FROM hr_org_info_types_by_class WHERE org_classification = :p_class_code AND org_information_type = :p_info_type;

Related Objects

This table has a direct and essential relationship with the HR_ORG_INFORMATION_TYPES table, which holds the master definition of all organization information types, including their user-defined prompts and validation rules. It is fundamentally linked to the HR_ORGANIZATION_INFORMATION table, which stores the actual instance data entered for each organization using the types permitted here. The table's configuration directly impacts user interfaces, such as the Organization Classification and Organization Details forms, and is referenced by underlying HRMS APIs and business logic that validate organization-related transactions.