Search Results per_people_info_types




Overview
Explore in AI Chat

Overview

The PER_PEOPLE_INFO_TYPES table is a core reference table within the Oracle E-Business Suite Human Resources (HR) module. It serves as a master repository for defining the categories of supplementary information that can be captured for a person (employee, applicant, or contingent worker) beyond the standard data held in primary tables like PER_ALL_PEOPLE_F. This table enables the system's flexible extra information functionality, allowing organizations to configure and store custom person-specific attributes tailored to their business needs. Its role is to provide the metadata or definition for these information types, which are then instantiated with actual values in the related PER_PEOPLE_EXTRA_INFO table.

Key Information Stored

The table's primary function is to define the characteristics of each unique information type. While the full column list is not detailed in the provided metadata, the structure centers on the INFORMATION_TYPE column, which serves as the unique identifier (Primary Key) for each defined category. Typical columns in such a definition table would include a user-facing name, a description, system flags controlling data entry and display, and potentially validation rules. The INFORMATION_TYPE value stored here is the key reference point used throughout the application to identify a specific category of extra information, such as 'Emergency Contact Details', 'Professional Certifications', or 'Custom ID Number'.

Common Use Cases and Queries

This table is primarily accessed to understand what additional person information has been configured in the system or to validate data during integration and reporting. A common administrative query lists all active information types. For reporting, one typically joins this table to PER_PEOPLE_EXTRA_INFO to get a comprehensible description alongside the stored data. A fundamental SQL pattern is:

  • SELECT pit.information_type, pit.user_name, pei.information_value FROM per_people_info_types pit, per_people_extra_info pei WHERE pit.information_type = pei.information_type AND pei.person_id = :p_person_id;

This table is also crucial for data validation scripts and when building custom interfaces or extensions that populate person extra information, as it provides the valid list of INFORMATION_TYPE codes.

Related Objects

The PER_PEOPLE_INFO_TYPES table has a direct and essential relationship with the PER_PEOPLE_EXTRA_INFO table, as documented in the provided metadata. The PER_PEOPLE_EXTRA_INFO.INFORMATION_TYPE column is a foreign key that references PER_PEOPLE_INFO_TYPES.INFORMATION_TYPE. This enforces referential integrity, ensuring that every piece of stored extra information corresponds to a pre-defined and valid information type. No other foreign key relationships are documented in the provided excerpt. This table is a parent reference table, and its definitions are likely accessed by various HR APIs and user interface forms that manage the capture and display of person extra information.