Search Results special_info_category




Overview
Explore in AI Chat

Overview

The HR.PER_SPECIAL_INFO_TYPE_USAGES table is a configuration and control table within the Oracle E-Business Suite Human Capital Management (HCM) module, specifically for releases 12.1.1 and 12.2.2. Its primary role is to govern where and how Special Information Types (SITs) can be utilized across the application. SITs are flexible, user-defined data fields that extend the standard person, assignment, or other entity records. This table acts as a junction, defining the permissible categories (or contexts) for each SIT within a given business group, thereby enforcing data integrity and appropriate usage.

Key Information Stored

The table's structure is focused on the relationship between a category and a type. The two core columns form a composite primary key. The SPECIAL_INFORMATION_TYPE_ID is a foreign key that references HR.PER_SPECIAL_INFO_TYPES, identifying the specific user-defined information type. The SPECIAL_INFO_CATEGORY is a VARCHAR2(30) code that dictates the application context where the SIT is allowed, such as for job requirements, position requirements, training skills, or personal analysis. The table also includes standard Oracle "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes.

Common Use Cases and Queries

This table is central to administrative setup and reporting on SIT availability. A common use case is determining all SITs enabled for a specific functional area, such as position management. The following query pattern is typical:

  • Retrieving All Configured Usages: To audit or report on the mapping between SITs and their enabled categories, a join to the base types table is essential: SELECT psitu.SPECIAL_INFO_CATEGORY, psit.SPECIAL_INFORMATION_TYPE, psit.SPECIAL_INFORMATION_TYPE_ID FROM hr.PER_SPECIAL_INFO_TYPE_USAGES psitu, hr.PER_SPECIAL_INFO_TYPES psit WHERE psitu.SPECIAL_INFORMATION_TYPE_ID = psit.SPECIAL_INFORMATION_TYPE_ID ORDER BY psitu.SPECIAL_INFO_CATEGORY;
  • Validating Setup for an Integration: Before an integration populates SIT data, a check against this table can confirm the target SIT is valid for the intended category (e.g., 'POSITION_REQUIREMENTS').
  • Security & Access Control: The categories control which application windows and forms a SIT appears in, effectively restricting data entry and view access based on the configured usage.

Related Objects

The table has defined relationships with other core HCM objects, primarily serving as a detail to the master SIT definition table.

  • HR.PER_SPECIAL_INFO_TYPES: This is the primary parent table. The foreign key relationship is PER_SPECIAL_INFO_TYPE_USAGES.SPECIAL_INFORMATION_TYPE_ID → PER_SPECIAL_INFO_TYPES.SPECIAL_INFORMATION_TYPE_ID. This ensures a usage record cannot exist without a corresponding, valid Special Information Type definition.
  • APPS.PER_SPECIAL_INFO_TYPE_USAGES: A public synonym pointing to the HR schema table, used by application code and standard queries.
  • APPS.PER_SPECIAL_INFO_TYPE_USAG_WHO: A database view that is automatically generated for auditing and likely includes the standard who column information from this table.