Search Results igs_pe_person_id_typ

Overview

The IGS_PE_PERSON_ID_TYP table is a core reference table within the Oracle E-Business Suite's Student System (IGS). It functions as a master data repository that defines the various categories of identification numbers or codes that can be assigned to a person record. This table enables institutions to manage multiple identifiers for an individual beyond the primary system key, such as legacy IDs, identifiers from external agencies (e.g., OLAA, VTAC), or government-issued numbers. Its primary role is to provide a validated list of ID types, ensuring data consistency and integrity across all person-related transactions and records in the Student System.

Key Information Stored

The table's central column is PERSON_ID_TYPE, which serves as the primary key. This column stores the unique code representing a specific identification category. While the provided metadata does not list all columns, typical attributes for such a reference table would include a description field (e.g., DESCRIPTION) to provide a meaningful name for the ID type, control flags such as SYSTEM_IND (indicating if the type is system-generated), and columns for tracking data like CREATION_DATE and LAST_UPDATE_DATE. The table's structure is designed to be simple yet foundational, allowing for the flexible association of alternate identifiers to a core person entity.

Common Use Cases and Queries

This table is essential for setup, data validation, and reporting. Administrators use it to configure which ID types are available for assignment during person creation or data import processes. A common operational query involves joining this table to the IGS_PE_ALT_PERS_ID table to retrieve all alternate identifiers for a specific person. For reporting, it is used to translate ID type codes into human-readable descriptions. A typical SQL pattern is:

• SELECT pit.person_id_type, pit.description, api.alternate_id FROM igs_pe_person_id_typ pit, igs_pe_alt_pers_id api WHERE pit.person_id_type = api.person_id_type AND api.person_id = :p_person_id;

It is also critical in setup modules for Admissions, Data Access, and Tax Reporting (1098-T), where a default student ID type must be specified.

Related Objects

The IGS_PE_PERSON_ID_TYP table is referenced by numerous key tables across the Student System, as indicated by its foreign key relationships. The IGS_PE_ALT_PERS_ID table is the primary child table, storing the actual alternate ID values linked to a person. Other important dependencies include setup tables like IGS_DA_SETUP (Data Access), IGS_FI_1098T_SETUP (U.S. Tax Information), IGS_SS_ADMAPPL_SETUP (Admissions Application), and IGS_UC_DEFAULTS (UCAS Integration). The table IGS_AD_IMP_NEAR_MTCH_ALL (Admissions Import Near Match) also references it, highlighting its role in data matching and de-duplication processes during applicant import.