Search Results per_people_extra_info_pk

Overview

The PER_PEOPLE_EXTRA_INFO table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically in versions 12.1.1 and 12.2.2. It serves as a flexible repository for storing supplemental, non-standardized information about a person (employee, applicant, or contingent worker) beyond the core attributes defined in primary tables like PER_ALL_PEOPLE_F. Its role is to support the extensibility of the HR data model, allowing organizations to define and capture custom information types relevant to their specific business or regulatory requirements without modifying the core application tables.

Key Information Stored

The table's structure is designed to hold key-value pairs of extra information, linked to a person and a specific information type. The primary key is PERSON_EXTRA_INFO_ID, a unique system-generated identifier. The most critical columns include PERSON_ID, which links to the person in PER_ALL_PEOPLE_F, and INFORMATION_TYPE, a foreign key to PER_PEOPLE_INFO_TYPES that categorizes the extra data (e.g., 'Emergency Contact Details', 'Professional Certifications'). The actual data is stored in attribute columns (PEI_INFORMATION1 through PEI_INFORMATION30, and PEI_INFORMATION_CATEGORY), which are generic character fields whose meaning is defined by the associated INFORMATION_TYPE. This design allows for a wide variety of custom data to be stored in a structured, queryable manner.

Common Use Cases and Queries

This table is central to scenarios requiring custom person attributes. Common use cases include storing visa/passport details for global workforces, recording emergency contact information, tracking professional licenses or union memberships, and capturing company-specific demographic data. For reporting, a typical query joins this table to the core person tables and the info types table to provide context. A sample pattern is:

• SELECT ppf.full_name, ppei.information_type, ppei.pei_information1
• FROM per_people_extra_info ppei,
• per_all_people_f ppf,
• per_people_info_types ppit
• WHERE ppei.person_id = ppf.person_id
• AND ppei.information_type = ppit.information_type
• AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date
• AND ppit.system_info_type = 'N'; -- User-defined types

Data is typically created and maintained via the standard Oracle HRMS person forms or APIs, which handle the validation logic defined for each information type.

Related Objects

PER_PEOPLE_EXTRA_INFO has integral relationships with several other HR objects. Its primary foreign key relationship is with PER_PEOPLE_INFO_TYPES, which defines the valid INFORMATION_TYPE values and their configurations. The PERSON_ID column links to the central PER_ALL_PEOPLE_F table. For programmatic access, key APIs include HR_PERSON_EXTRA_INFO_API for creating and maintaining records. Dependent views may exist to simplify reporting on specific information categories. Understanding these relationships is essential for accurate data integration, custom reporting, and extension development within the HR module.