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_TYPE_V is a read-only database view owned by the APPS schema in the Oracle E-Business Suite environment (12.1.1 and 12.2.2). It belongs to the IGS product family, commonly referred to as the Oracle Student System, and specifically to the person and alternate identifier areas of that module. The view exposes the relationship between a person's preferred identifier type and the corresponding alternate person identifier records, providing a compact, filtered projection that reporting layers and integrations can consume without embedding the join and date-filter logic themselves.
Its practical role is that of a convenience view: it returns only the identifier rows whose type is flagged as preferred and whose validity window currently covers the system date. This makes it suitable for operational reporting, concurrent program queries, and inbound/outbound integration extracts where a single active identifier per person/type is expected.
Underlying Base Objects
The view is defined over two documented base tables:
- IGS_PE_PERSON_ID_TYP (aliased PIT) — the identifier type definition table, which holds each PERSON_ID_TYPE and a PREFERRED_IND flag.
- IGS_PE_ALT_PERS_ID (aliased API) — the alternate person identifier table, which stores the actual identifier values (API_PERSON_ID) linked to a person (PE_PERSON_ID), with START_DT and END_DT validity dates.
The join is performed on PERSON_ID_TYPE equality between the two tables. The view further restricts results with two predicates: PIT.PREFERRED_IND = 'Y', and SYSDATE BETWEEN API.START_DT AND NVL(API.END_DT, SYSDATE). The second predicate means an open-ended identifier (null END_DT) remains visible indefinitely, while expired identifiers are excluded. Note that the view does not enforce a one-row-per-person guarantee at the database level; where multiple rows satisfy the predicates, all are returned.
Key Columns
- PERSON_ID_TYPE — the identifier type code from IGS_PE_PERSON_ID_TYP; identifies the classification of the alternate person ID (for example, national ID, passport, or institution-specific identifier).
- API_PERSON_ID — the actual alternate person identifier value stored in IGS_PE_ALT_PERS_ID.
- PE_PERSON_ID — the internal person identifier linking the row back to the person record, typically used to join to person or party tables elsewhere in IGS.
Because only three columns are exposed, the view is deliberately narrow; all descriptive attributes of the identifier type must be obtained by joining back to IGS_PE_PERSON_ID_TYP.
Common Use Cases and Queries
Typical scenarios include producing a current preferred identifier listing for a person, validating that an identifier exists before an integration hand-off, and driving concurrent extracts that require active identifiers only. A straightforward query returns all preferred identifiers:
SELECT person_id_type, pe_person_id, api_person_id FROM apps.igs_pe_person_id_type_v;
To retrieve the preferred identifier for a specific person:
SELECT api_person_id FROM apps.igs_pe_person_id_type_v WHERE pe_person_id = :p_person_id AND person_id_type = :p_type;
To combine identifier values with their type descriptions:
SELECT v.pe_person_id, v.api_person_id, t.description FROM apps.igs_pe_person_id_type_v v, apps.igs_pe_person_id_typ t WHERE t.person_id_type = v.person_id_type;
Because the view already applies the preferred and date predicates, callers should avoid re-imposing PREFERRED_IND filters, which are not exposed as columns. Queries should be schema-qualified with APPS and run under an appropriate IGS responsibility to respect row-level security and grants.
-
Lookup Type: PERSON_ID_TYPE 12.1.1
Person Id Type
-
Lookup Type: PERSON_ID_TYPE 12.2.2
Person Id Type
-
APPS.IGS_PE_PERSON_ID_TYPE_V·↳ IGS_PE_ALT_PERS_ID·↳ IGS_PE_PERSON_ID_TYP·Explore IGS module →
-
This entity describes the type of person ids which may be attributed to a person. eg. OLAA id, VTAC id, old id.
-
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 →
-
This table holds the system administration setup details for self service admission application. There will be only one record in this table
-
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_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: IGS_PE_DUP_PAIRS 12.1.1
APPS.IGS_PE_DUP_PAIRS·↳ IGS_PE_DUP_PAIRS_ALL·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_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 →
-
APPS.IGS_PE_API_ALT_PERS_ID_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_EN_GEN_003·Explore IGS module →
-
APPS.IGS_PE_PAIR_DUP_PERSON_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_PE_DUP_PAIRS·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 →
-
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 →
-
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 →
-
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: 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_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 information about recruitment probability index values
-
View: IGS_AD_IMP_NEAR_MTCH 12.1.1
APPS.IGS_AD_IMP_NEAR_MTCH·↳ IGS_AD_IMP_NEAR_MTCH_ALL·Explore IGS module →
-
This entity describes the duplicate pair of persons in the system
-
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 →
-
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 →
-
APPS.IGS_AD_IMP_PAR_MATCHES_V·↳ FND_LOOKUP_VALUES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_IMP_NEAR_MTCH·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 →
-
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 →
-
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_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 →
-
Holds information about person's alternate person identifiers
-
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_V 12.1.1
APPS.IGS_PE_PERSON_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·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 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: 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_ID_TYP_V 12.2.2
Not implemented in this database·Explore IGS module →