Search Results institution_priority




Overview
Explore in AI Chat

Overview

IGS_OR_INSTITUTION_V is a reporting and integration view within the Oracle E-Business Suite Student System (IGS) product family. In the ETRM 12.2.2 documentation the product is flagged as Obsolete, and the view is explicitly noted as "Not implemented in this database." Its stated purpose is to describe institution details — the academic institutions, schools, and related educational bodies recorded in the Student System. The view projects a wide, denormalized column set from its parent entity so that downstream reports, extracts, and interfaces can resolve institution attributes without joining multiple tables manually.

The user search term "institution_priority" maps directly to the INSTITUTION_PRIORITY column exposed by this view, one of its more functionally meaningful attributes. It is accompanied by PRIORITY_DESCRIPTION, which supplies the human-readable ranking text for that priority code.

Underlying Base Objects

The view text shows a single-source definition: all columns are projected directly from the base table IGS_OR_INSTITUTION with no joins, unions, or aggregation. The view is therefore a thin wrapper over the institution entity, adding no filter predicate or derived logic in the excerpted definition. Although the ETRM metadata lists "none documented" for referenced base objects, the view text itself identifies IGS_OR_INSTITUTION as the sole source. Consumers should treat the view as a read-only presentation layer over that table.

Key Columns

Common Use Cases and Queries

Typical scenarios include enumerating institutions by priority, extracting institution master data for external systems, and resolving party linkage for admissions or recruitment reporting. Because the view is flagged obsolete and not implemented, queries should be validated against the actual database state before deployment.

List institutions ordered by priority:

SELECT institution_cd, name, institution_priority, priority_description
FROM igs_or_institution_v
WHERE institution_status = 'A'
ORDER BY institution_priority;

Retrieve local government institutions with contact details:

SELECT name, govt_institution_cd, inst_phone_area_code, inst_phone_number
FROM igs_or_institution_v
WHERE local_institution_ind = 'Y';