Search Results per_person_types

Overview

The PER_PERSON_TYPES table is a core reference table within the Oracle E-Business Suite Human Resources (HR) module. It serves as the master repository for defining and managing the classification of individuals within the system. Its primary role is to establish the specific person types, such as Employee, Applicant, or Ex-employee, that are visible and available for assignment within a given Business Group. This table enforces data integrity and security by ensuring that person type definitions are scoped appropriately to an organization's operational context, preventing cross-Business Group data contamination.

Key Information Stored

The table's structure is designed to define and control person type metadata. The primary key, PERSON_TYPE_ID, uniquely identifies each type definition. A critical column is BUSINESS_GROUP_ID, which links the person type to a specific Business Group, thereby controlling its visibility. Other essential columns include SYSTEM_PERSON_TYPE, which holds the internal system name (e.g., 'EMP', 'APL'), and USER_PERSON_TYPE, which stores the user-friendly name displayed in the application. Additional columns typically manage active/inactive status, creation dates, and last update details, which are standard for EBS audit trails.

Common Use Cases and Queries

This table is central to reporting, data validation, and system configuration. A common use case is generating a list of all active person types available within a specific Business Group for setup or audit purposes. Another frequent scenario involves validating the person type assigned to an individual in PER_ALL_PEOPLE_F against the master definitions. Sample SQL to retrieve active person types for a Business Group would be:

• SELECT user_person_type, system_person_type FROM hr.per_person_types WHERE business_group_id = &bg_id AND active_flag = 'Y';

For data integrity checks, a join with PER_ALL_PEOPLE_F is standard:

• SELECT ppf.full_name, ppt.user_person_type FROM hr.per_all_people_f ppf, hr.per_person_types ppt WHERE ppf.person_type_id = ppt.person_type_id AND ppf.business_group_id = &bg_id;

Related Objects

As indicated by the foreign key metadata, PER_PERSON_TYPES has integral relationships with several key HR tables. The most significant is with PER_ALL_PEOPLE_F, where the PERSON_TYPE_ID foreign key assigns a type to each person record. The table also references HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID to scope the types. Furthermore, it is linked to the PER_PERSON_TYPE_USAGES_UPGRADE table through multiple foreign keys (PERSON_TYPE_ID, APP_PERSON_TYPE_ID, EMP_PERSON_TYPE_ID), which manages the mapping and upgrade logic for person types during system transitions or data migrations. These relationships underscore its role as a foundational reference point for person classification throughout the HR schema.