Search Results system_institution_type

Overview

APPS.IGS_OR_ORG_INST_TYPE_V is a reporting and integration view within the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of the Higher Education vertical). It exposes institution type definitions used by the IGS (Student Systems) product family and enriches them with the decoded meaning of the associated system institution type lookup. The view is owned by the APPS schema and is intended for read-only consumption by reports, concurrent programs, and interface components that must present institution type information in a user-readable form.

The view's principal purpose is denormalization: rather than requiring callers to join IGS_OR_ORG_INST_TYPE to the lookup infrastructure and filter on LOOKUP_TYPE = 'SYSTEM_INSTITUTION_TYPE', the view performs that join internally and surfaces a pre-resolved description column. This is the standard Oracle EBS pattern for exposing flexfield or lookup-backed codes alongside their meanings.

Underlying Base Objects

The view text documents a two-table join:

• IGS_OR_ORG_INST_TYPE OIT — the primary base table holding institution type records, including the institution type code, its description, the associated system institution type code, close indicator, and standard WHO audit columns.
• IGS_LOOKUPS_VIEW LKUP — the lookup view used to resolve the meaning of the system institution type. The join is constrained by OIT.SYSTEM_INST_TYPE = LKUP.LOOKUP_CODE and LKUP.LOOKUP_TYPE = 'SYSTEM_INSTITUTION_TYPE'.

Both objects reside under the APPS schema in a standard EBS 12.1.1 or 12.2.2 installation. The view itself is defined with a SELECT list that aliases several columns, including OIT.ROWID as ROW_ID and LKUP.MEANING as SYSTEM_INST_TYPE_DESC. Because the view is a simple two-table equijoin, it is inherently read-only with respect to both base objects and carries no INSTEAD OF triggers. No additional base objects are documented in the ETRM metadata.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_OR_ORG_INST_TYPE row, aliased for downstream row identity purposes.
• INSTITUTION_TYPE — the institution type code defined in the base table.
• DESCRIPTION — the descriptive text for the institution type.
• SYSTEM_INST_TYPE — the system institution type code, joined to the lookup code.
• SYSTEM_INST_TYPE_DESC — the decoded lookup meaning corresponding to SYSTEM_INST_TYPE. This is the column most often consumed by reports and integrations.
• CLOSE_IND — the close/active indicator flag for the institution type record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the base table.

Common Use Cases and Queries

The view is typically used when a report or interface must list institution types together with a human-readable system institution type description, or when a validation routine needs to confirm that a system institution type code exists in the SYSTEM_INSTITUTION_TYPE lookup.

A representative query listing all active institution types:

SELECT institution_type,
       description,
       system_inst_type,
       system_inst_type_desc
FROM   apps.igs_or_org_inst_type_v
WHERE  close_ind = 'N';

A query resolving a specific system institution type by its lookup description:

SELECT institution_type,
       description
FROM   apps.igs_or_org_inst_type_v
WHERE  system_inst_type_desc = :p_description;

Because the view is read-only, it is safe to use in concurrent program data extracts and BI Publisher data templates without concerns regarding row-level locking. When performance is a consideration, callers should filter on SYSTEM_INST_TYPE or INSTITUTION_TYPE rather than on the decoded description, since those columns map directly to indexed base table columns.