Results for “per_special_info_types”

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

Overview

PER_SPECIAL_INFO_TYPES is a Human Resources (PER) configuration table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the special information types that are available to a specific Business Group. In EBS terminology, a special information type is a user-defined category of extra personal data that can be captured for employees, applicants, and other person records — for example, professional licences, memberships, security clearances, or language proficiencies. Rather than storing the actual person-level data, this table acts as the master definition list from which the corresponding PER_SPECIAL_INFO_TYPE_USAGES rows are derived and against which any dependent detail structures are validated. It therefore sits at the top of the special-information hierarchy and controls which types are enabled for a given enterprise.

From a heuristic Data Vault modelling perspective, the documented foreign-key structure classifies this object as satellite-leaning. It holds descriptive attributes about a single business concept (a special information type) and is anchored to the Business Group hub represented by HR_ALL_ORGANIZATION_UNITS, rather than acting as a pure relationship link.

Key Information Stored

The table contains 36 documented columns. The most significant are:

• SPECIAL_INFORMATION_TYPE_ID — the surrogate primary key, enforced by the unique index PER_SPECIAL_INFO_TYPES_PK.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the Business Group that owns the type. This is the principal business-key candidate and confirms the multi-tenant (Business Group) scope of the definition.
• ID_FLEX_NUM — links the type to the descriptive flexfield definition that supplies its extra attributes.
• ENABLED_FLAG — controls whether the special information type is active and selectable in HR forms and self-service pages.
• MULTIPLE_OCCURRENCES_FLAG — determines whether more than one occurrence of the type may be recorded for a single person.
• COMMENTS — free-text description of the type.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — the standard concurrent-program audit set that records the process which last created or updated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the mandatory WHO-column audit trail.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the descriptive flexfield segments used by customers to extend the definition without modifying the base schema.

The primary key is the surrogate SPECIAL_INFORMATION_TYPE_ID; the natural business key is the combination of BUSINESS_GROUP_ID (and the associated flexfield configuration) that scopes the definition.

Common Use Cases and Queries

Typical reporting and administration tasks include validating which special information types are enabled for a Business Group, auditing definitions against their usages, and driving LOV queries in custom forms. A representative query is:

• Listing enabled types for a Business Group: SELECT special_information_type_id, enabled_flag, multiple_occurrences_flag FROM per_special_info_types WHERE business_group_id = :p_bg_id AND enabled_flag = 'Y';
• Auditing who last changed a definition: join PER_SPECIAL_INFO_TYPES to FND_USER on LAST_UPDATED_BY to resolve the user name.
• Reconciling definitions to usages: LEFT JOIN per_special_info_type_usages usg ON usg.special_information_type_id = sit.special_information_type_id to find types defined but never used, or usages whose parent definition is disabled.

Because the table is Business Group scoped, all queries should filter on BUSINESS_GROUP_ID to respect row-level security and the multiple-Business-Group architecture of a shared EBS instance.

Related Objects

• PER_SPECIAL_INFO_TYPE_USAGES — the principal dependent table. Its SPECIAL_INFORMATION_TYPE_ID foreign key points back to this table, recording where each type is used.
• HR_ALL_ORGANIZATION_UNITS — parent of BUSINESS_GROUP_ID, supplying the Business Group definition.
• PER_SPECIAL_INFO_TYPES_PK — the unique index enforcing the primary key.
• FND_ID_FLEX_STRUCTURES — conceptually related through ID_FLEX_NUM, describing the descriptive flexfield backing each type.
• FND_USER — referenced indirectly through the WHO columns for audit reporting.

These relationships make PER_SPECIAL_INFO_TYPES the governing definition table for all special-information data captured against persons in Oracle HRMS.