Search Results s_institution_status

Overview

The IGS_PE_PERSON_ID_TYP_V view is a reporting and integration object within the Oracle Student System (IGS) product family of Oracle E-Business Suite. Owned by the APPS schema and validated in ETRM for releases 12.1.1 and 12.2.2, the view consolidates person identification type definitions with associated institution and lookup context. Rather than requiring applications to join the person identification type table to institution organization and lookup tables independently, the view presents a pre-joined result set that is convenient for both concurrent program logic and ad-hoc querying.

The user search term "s_institution_status" corresponds directly to the S_INSTITUTION_STATUS column exposed by this view. That column carries the internal (system-facing) status code for the institution associated with a given person identification type, and it is one of the principal reasons report authors target this view rather than the underlying base table. A companion column, INSTITUTION_STATUS, exposes the descriptive institution status, allowing report developers to work with either the coded or descriptive value.

Underlying Base Objects

The view text shows four referenced sources, joined with an outer-join pattern designed to preserve person identification type rows even where institutional data is absent:

• IGS_PE_PERSON_ID_TYP — the primary source, aliased PIT, holding person identification type definitions such as preferred and unique indicator flags, format mask, region and closed indicators, and audit columns.
• IGS_OR_INST_ORG_BASE_V — aliased OU, supplying the party name and institution status; joined to the primary table on INSTITUTION_CD = PARTY_NUMBER(+ ).
• IGS_OR_INST_STAT — aliased INS_STS, providing the internal status code; outer-joined on institution status with a filter restricting the internal status to 'ACTIVE'.
• IGS_LOOKUP_VALUES — aliased LKUPS, resolving the internal person identification type code to its lookup meaning, constrained by LOOKUP_TYPE = 'PERSON_ID_TYPE'.

Key Columns

• ROW_ID — the ROWID of the underlying person identification type row, enabling direct updates or row-level identification.
• PERSON_ID_TYPE and S_PERSON_ID_TYPE — the descriptive and internal identifier for the person identification type.
• INSTITUTION_CD and NAME — the institution code and the associated party name.
• INSTITUTION_STATUS and S_INSTITUTION_STATUS — the descriptive and coded institution status values central to the user's search.
• PREFERRED_IND, UNIQUE_IND, REGION_IND, CLOSED_IND — indicator flags governing identification type behavior.
• MEANING and LOOKUP_TYPE — resolved lookup text for the person identification type.
• FORMAT_MASK — the display/edit mask applied to the identifier value.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include validating configured identification types by institution, driving student admission or registration reports, and extracting lookup-resolved identification type metadata for integration. A representative query filtering on institution status is:

• SELECT person_id_type, meaning, institution_cd, name, s_institution_status FROM igs_pe_person_id_typ_v WHERE s_institution_status = 'ACTIVE';
• SELECT institution_cd, institution_status, person_id_type, preferred_ind FROM igs_pe_person_id_typ_v ORDER BY institution_cd, person_id_type;

Because the joins to OU and INS_STS are outer joins, rows without matching institution data are still returned, with null institution columns. Report developers should therefore account for nulls in S_INSTITUTION_STATUS when filtering. The view is read-only in practice and should be treated as a reporting object; verification of the exact join behavior against a specific 12.2.2 instance is advisable before relying on it for high-volume integrations.