Search Results per_special_info_types




Overview
Explore in AI Chat

Overview

The PER_SPECIAL_INFO_TYPES table is a core configuration table within the Oracle E-Business Suite Human Resources (PER) module, versions 12.1.1 and 12.2.2. It serves as the master definition repository for special information types (SITs) available to a specific Business Group. SITs are a flexible framework that allows organizations to define and capture additional, non-standard information about people (employees, applicants, contacts) beyond the standard HRMS fields. The table's role is to establish the metadata for each SIT, including its name, context, and availability rules, thereby enabling the extension of the core HR data model to meet unique business requirements.

Key Information Stored

The table stores the metadata that defines each special information type. The primary column is the SPECIAL_INFORMATION_TYPE_ID, which is the unique identifier and primary key for each SIT definition. The BUSINESS_GROUP_ID column is a critical foreign key that scopes the SIT to a specific Business Group, ensuring data isolation and security. Other essential columns typically include NAME (the descriptive label for the SIT), LEGISLATION_CODE (for country-specific SITs), ACTIVE_FLAG (to control availability), and columns defining the context (e.g., PERSON_TYPE) in which the SIT can be used. The table does not store the actual special information data for individuals; it stores the definitions of what types of information can be captured.

Common Use Cases and Queries

A primary use case is the administration and audit of configured SITs within a Business Group. HR system administrators frequently query this table to generate a list of active SITs for documentation or to identify unused types for cleanup. For example, a query to list all SITs for a specific Business Group (ID 123) would be: SELECT name, legislation_code, person_type FROM per_special_info_types WHERE business_group_id = 123 AND active_flag = 'Y';. This table is also central during the setup of new SITs via the "Special Information Types" form in the HRMS application. From a reporting perspective, this table is joined to the transactional tables that store the actual SIT data (like PER_SPECIAL_INFO_TYPES_F) to provide meaningful descriptions in custom reports.

Related Objects

PER_SPECIAL_INFO_TYPES has defined relationships with several other key HR objects, as indicated by the provided foreign key metadata.

  • HR_ALL_ORGANIZATION_UNITS: The BUSINESS_GROUP_ID column in PER_SPECIAL_INFO_TYPES is a foreign key to this table, enforcing that a SIT definition is linked to a valid Business Group.
  • PER_SPECIAL_INFO_TYPE_USAGES: This is a crucial child table. Its SPECIAL_INFORMATION_TYPE_ID column is a foreign key to PER_SPECIAL_INFO_TYPES. It controls where a specific SIT can be used (e.g., on which forms, assignments, or organizations), making it essential for understanding the full deployment of a SIT definition.

Furthermore, while not listed in the provided FKs, the transactional data for SITs is stored in tables such as PER_SPECIAL_INFO_TYPES_F and PER_SPECIAL_INFO_TL (for translated names), which also reference the SPECIAL_INFORMATION_TYPE_ID from this master definition table.