Results for “person_id_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PE_PERSON_ID_TYP is a reference (lookup) table within the Oracle E-Business Suite Student System module (IGS). It defines the categories, or types, of person identifiers that may be attributed to an individual in the institutional person registry. Examples cited in the ETRM documentation include an OLAA id, a VTAC id, or an "old id" — identifiers issued by external admissions bodies or legacy identifiers retained for historical reconciliation. Every alternate person identifier recorded against a person must be classified by one of the rows defined in this table, which makes it a foundational control object for identity management across the Student System.
From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning. It functions principally as a durable, business-key driven reference set that many downstream tables resolve against, rather than as a transactional or dependent-child structure. No foreign keys are recorded outbound from this table, confirming its role as a terminal lookup rather than a link between business entities.
Key Information Stored
The table carries 14 documented columns in the 12.1.1 ETRM schema. The most significant are:
- PERSON_ID_TYPE — the primary key and the business-key candidate. Also enforced by unique index IGS_PE_PERSON_ID_TYP_U1 and by primary key constraint IGS_PE_PERSON_ID_TYP_PK. This is the code referenced by all dependent foreign-key columns.
- DESCRIPTION — human-readable label for the identifier type.
- S_PERSON_ID_TYPE — the short or secondary display form of the type.
- INSTITUTION_CD — institution qualifier, allowing different identifier taxonomies per institution.
- PREFERRED_IND — flags whether an identifier of this type is treated as preferred.
- UNIQUE_IND — controls whether only one identifier of this type may be held per person.
- FORMAT_MASK — input/validation mask applied to the identifier value.
- REGION_IND — regional applicability indicator.
- CLOSED_IND — marks a type as retired so it is no longer offered for new assignments while remaining valid for history.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN support standard EBS auditing.
No separate surrogate sequence key is documented; the identifier type code itself serves as the primary key, and the unique index on PERSON_ID_TYPE is the sole business-key candidate.
Common Use Cases and Queries
Typical reporting and validation scenarios include listing all active identifier types for a given institution, resolving codes to descriptions on person-level reports, and validating that a person's identifiers respect uniqueness and preference rules.
- Lookup of active types:
SELECT person_id_type, description FROM igs_pe_person_id_typ WHERE closed_ind = 'N' ORDER BY description; - Joining identifiers to their type definitions:
SELECT a.person_id, a.person_id_type, t.description, a.person_id_value FROM igs_pe_alt_pers_id a, igs_pe_person_id_typ t WHERE a.person_id_type = t.person_id_type; - Enforcing uniqueness analysis: identify persons holding more than one identifier of a UNIQUE_IND type.
- Admissions and statutory extracts, such as 1098-T setup, where the configured PERSON_ID_TYPE drives which identifier is printed.
- Institution-specific configuration review, filtering by INSTITUTION_CD and REGION_IND.
Related Objects
The table is referenced by six documented foreign keys. The most significant are:
- IGS_PE_ALT_PERS_ID via PERSON_ID_TYPE — the principal child holding the actual alternate identifier values attributed to a person. This is the most operationally important dependency.
- IGS_AD_IMP_NEAR_MTCH_ALL via PERSON_ID_TYPE — used in admissions near-match processing and duplicate detection.
- IGS_SS_ADMAPPL_SETUP via PERSON_ID_TYPE — admissions application configuration.
- IGS_DA_SETUP via DEFAULT_STUDENT_ID_TYPE — defines the default student identifier type for the institution.
- IGS_FI_1098T_SETUP via PERSON_ID_TYPE — drives the identifier used on 1098-T tax reporting.
- IGS_UC_DEFAULTS via NI_NUMBER_ALT_PERS_TYPE — UCAS-related defaults for national insurance and alternate person identifiers.
Because these dependents rely on the PERSON_ID_TYPE code, any change to a type code or its CLOSED_IND status should be assessed against all referencing setups and person identifier records before being applied.
-
Lookup Type: PERSON_ID_TYPE 12.1.1
Person Id Type
-
Lookup Type: PERSON_ID_TYPE 12.2.2
Person Id Type
-
This entity describes the type of person ids which may be attributed to a person. eg. OLAA id, VTAC id, old id.
-
APPS.IGS_PE_PERSON_ID_TYPE_V·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
View: IGS_AD_RECRT_PI_INT 12.1.1
This is a Multi Org view based upon table IGS_AD_RECRT_PI_INT_ALL
APPS.IGS_AD_RECRT_PI_INT·↳ IGS_AD_RECRT_PI_INT_ALL·Explore IGS module →
-
Holds details about the near match between the imported data and existing data
-
This entity describes the other ids by which a person is known. eg. OLAA id, VTAC id, old id.
-
Gets the person details for the import process from the interface tables
APPS.IGS_AD_IMP_MATCHES_PP_V·↳ IGS_AD_API_INT·↳ IGS_AD_INTERFACE·↳ IGS_AD_STAT_INT·Explore IGS module →
-
APPS.IGS_PE_PAIR_ACT_PERSON_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_DUP_PAIRS·Explore IGS module →
-
View: IGSBV_ALTERNATE_IDS 12.1.1
This entity contains information about the various alternate identifiers for a person.
APPS.IGSBV_ALTERNATE_IDS·↳ HZ_PARTIES·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
View: IGR_I_PERSON_V 12.1.1
Person View
APPS.IGR_I_PERSON_V·↳ IGS_AD_PROSPECT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
View: IGS_PE_PID_TYPE_V 12.1.1
IGS_PE_PID_TYPE_V describes the person identifier types in the system
APPS.IGS_PE_PID_TYPE_V·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
This table holds the system administration setup details for self service admission application. There will be only one record in this table
-
View: IGS_PE_PERSON_ID_TYP_V 12.1.1
APPS.IGS_PE_PERSON_ID_TYP_V·↳ IGS_LOOKUP_VALUES·↳ IGS_OR_INST_ORG_BASE_V·↳ IGS_OR_INST_STAT·Explore IGS module →
-
View: IGSFV_ALTERNATE_IDS 12.1.1
This entity contains information about the various alternate identifiers for a person.
APPS.IGSFV_ALTERNATE_IDS·↳ HZ_PARTIES·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
View: IGS_PE_DUP_PAIRS_V 12.1.1
APPS.IGS_PE_DUP_PAIRS_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_DUP_PAIRS·Explore IGS module →
-
View: IGS_PE_DUP_PAIRS 12.1.1
APPS.IGS_PE_DUP_PAIRS·↳ IGS_PE_DUP_PAIRS_ALL·Explore IGS module →
-
Contains information about recruitment probability index values
-
APPS.IGS_PE_PAIR_DUP_PERSON_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_DUP_PAIRS·Explore IGS module →
-
View: IGS_AD_IMP_NEAR_MTCH 12.1.1
APPS.IGS_AD_IMP_NEAR_MTCH·↳ IGS_AD_IMP_NEAR_MTCH_ALL·Explore IGS module →
-
IGS_PE_MATCHES_PPA_V is used for the duplicate information about persons.
APPS.IGS_PE_DUP_MATCHES_PPA_V·↳ HZ_LOCATIONS·↳ HZ_PARTIES·↳ HZ_PARTY_SITES·Explore IGS module →
-
APPS.IGS_PE_API_ALT_PERS_ID_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_EN_GEN_003·Explore IGS module →
-
This entity describes the duplicate pair of persons in the system
-
IGS_PE_DUP_MATCHES_PP_V is used for the duplicate information about persons.
APPS.IGS_PE_DUP_MATCHES_PP_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_PE_ALT_PERS_ID·Explore IGS module →
-
View: IGS_FI_PARTIES_V 12.1.1
Displays parties of type 'PERSON' and 'ORGANIZATION' and related context information.
APPS.IGS_FI_PARTIES_V·↳ FND_LOOKUP_VALUES_VL·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
The interface table for the Ancillary attributes for the students.
-
View: IGS_AD_ENQ_PERSON_V 12.1.1
Obsolete
APPS.IGS_AD_ENQ_PERSON_V·↳ IGS_AD_PROSPECT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
View: IGS_FI_ANC_INT_V 12.1.1
The interface table for the Ancillary attributes for the students.
APPS.IGS_FI_ANC_INT_V·↳ HZ_PARTIES·↳ IGS_FI_ANC_INT·Explore IGS module →
-
View: IGS_AD_API_INT 12.1.1
APPS.IGS_AD_API_INT·↳ IGS_AD_API_INT_ALL·Explore IGS module →
-
Gets the person details for the import process from the interface and person address tables
APPS.IGS_AD_IMP_MATCHES_PPA_V·↳ IGS_AD_ADDRUSAGE_INT·↳ IGS_AD_ADDR_INT·↳ IGS_AD_API_INT·Explore IGS module →
-
Contains data of a person and his primary address.This view is used in duplicate matching of person.
APPS.IGS_PE_DUP_MATCHES_PRIM_PPA_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_PE_ALT_PERS_ID·Explore IGS module →
-
View: IGS_SS_ADMAPPL_SETUP_V 12.1.1
This view is for Admission Applications Setup
APPS.IGS_SS_ADMAPPL_SETUP_V·↳ IGS_AD_CODE_CLASSES·↳ IGS_AD_NOTE_TYPES·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View of IGS_AD_PS_APPL, for forms requiring this table as a context block. - Obsolete
APPS.IGS_AD_PS_APPL_APLCNTX_V·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_PS_APPL·↳ IGS_EN_GEN_003·Explore IGS module →
-
APPS.IGS_AD_IMP_PAR_MATCHES_V·↳ FND_LOOKUP_VALUES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_IMP_NEAR_MTCH·Explore IGS module →
-
View: IGS_PE_ALT_PERS_ID_V 12.1.1
APPS.IGS_PE_ALT_PERS_ID_V·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
View: IGS_FI_ANC_INT 12.1.1
The interface table for the Ancillary attributes for the students.
APPS.IGS_FI_ANC_INT·↳ IGS_FI_ANC_INT_ALL·Explore IGS module →
-
Holds information about person's alternate person identifiers
-
Stores 1098-T reporting requirements setup information
-
View: IGS_SS_PERSON_SEARCH_V 12.1.1
The entity is used in Self Service to query for a Person
APPS.IGS_SS_PERSON_SEARCH_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_ALT_PERS_ID·Explore IGS module →
-
View: IGS_SS_ADM_APPL 12.1.1
An Admission Application Online View which stores all admission applications received online.
APPS.IGS_SS_ADM_APPL·↳ IGS_SS_ADM_APPL_ALL·Explore IGS module →
-
View: IGS_PE_PERSON_V 12.1.1
APPS.IGS_PE_PERSON_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_PE_PERSON_DTLS_V 12.1.1
APPS.IGS_PE_PERSON_DTLS_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ IGS_EN_GEN_003·Explore IGS module →
-
View: IGS_PE_PERSON 12.1.1
IGS_PE_PERSON is used to manipulate the information about persons stored in the database.
APPS.IGS_PE_PERSON·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGF_AP_PERSON_V 12.1.1
APPS.IGF_AP_PERSON_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_EN_GEN_003·Explore IGF module →
-
View: IGS_AD_SS_PERSON_V 12.1.1
This view retrieves the Person Information
APPS.IGS_AD_SS_PERSON_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_PE_PERSON_SV 12.1.1
IGS_PE_PERSON_SV is used to manipulate the secured information about persons stored in the database.
APPS.IGS_PE_PERSON_SV·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
View: IGS_AD_SS_INTPER_V 12.1.1
INS Dependent details
APPS.IGS_AD_SS_INTPER_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore IGS module →
-
Stores all the details of the admission applications received online
-
View: IGS_PE_PERSON_ID_TYP_V 12.2.2
Not implemented in this database·Explore IGS module →