Search Results igs_pe_person_types

Overview

The IGS_PE_PERSON_TYPES table is a core reference table within the Oracle E-Business Suite's Student System (IGS). It serves as the master repository for defining and managing the various classifications or categories of individuals within the academic ecosystem. Its primary role is to establish a standardized set of person types, such as Prospective Student, Applicant, Enrolled Student, Alumni, Faculty, or Staff, which are then used to categorize records in the broader person model (IGS_PE_PERSON). A critical functional enhancement noted in the documentation is its modification to support capturing the enrollment method type related to self-service operations, indicating its integration with student-facing portals and automated enrollment workflows in versions 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on the PERSON_TYPE_CODE, which serves as the unique identifier and primary key for the table. This code is a short, meaningful key (e.g., 'PROSP', 'APPLIC', 'STUDENT') that defines the person type. Based on standard EBS patterns and the described foreign key relationships, the table likely contains descriptive columns such as DESCRIPTION, along with standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and columns to control system behavior (e.g., ENABLED_FLAG, SYSTEM_TYPE). The self-service enrollment method linkage suggests there may be columns to associate a person type with specific enrollment processes or rules.

Common Use Cases and Queries

This table is fundamental for person data segmentation and security. Common use cases include configuring application behavior based on person type, generating population-specific reports, and enforcing data access rules. For instance, a self-service portal would query this table to determine which enrollment functions are available to a user categorized as a 'STUDENT'. A typical query would retrieve all active person types for a lookup list, or join to the main person table to count individuals by category.

• Retrieving all defined person types: SELECT person_type_code, description FROM igs.igs_pe_person_types WHERE enabled_flag = 'Y' ORDER BY 1;
• Counting active persons by type: SELECT pt.person_type_code, pt.description, COUNT(p.person_id) FROM igs.igs_pe_person p, igs.igs_pe_person_types pt WHERE p.person_type_code = pt.person_type_code GROUP BY pt.person_type_code, pt.description;

Related Objects

The IGS_PE_PERSON_TYPES table is a central reference point for numerous other entities in the Student System, as evidenced by its foreign key relationships. The primary table IGS_PE_PERSON will reference it to categorize each person record. The documented foreign keys show it is specifically referenced by setup and user role tables: IGS_PE_USR_ADISC_ALL, IGS_PE_USR_ARG_ALL, IGS_PE_USR_AVAL_ALL (likely related to user authorizations), IGS_PE_STUP_DATA_EMT_ALL (enrollment method setup), IGS_PE_TYP_INSTANCES_ALL, and IGS_PE_PER_TYPE_MAP. This network of dependencies underscores its critical role in defining data access, enrollment rules, and functional permissions based on a person's type.