Results for “institution_type”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_OR_ORG_INST_TYPE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGS — Student System product family. Its status is VALID in both 12.1.1 and 12.2.2. The view exposes the set of institution type definitions maintained for an educational establishment, and resolves the internal institution type classification into a user-readable lookup meaning. This makes it a convenient, denormalized source for reporting, concurrent programs, integrations, and extensions that need institution type data without joining the lookup infrastructure manually.

The object is closely associated with the search term "system_inst_type." In the underlying data model, SYSTEM_INST_TYPE is the stored lookup code that classifies each institution type record, while SYSTEM_INST_TYPE_DESC is the human-readable description of that code. The view layers the two together so that consumers can read either the code or its displayed meaning from a single SELECT.

Underlying Base Objects

The view is defined over two sources: the base table IGS_OR_ORG_INST_TYPE and the lookup view IGS_LOOKUPS_VIEW. The join is performed on the lookup code and restricted by lookup type, as shown in the view text:

  • IGS_OR_ORG_INST_TYPE (aliased OIT) — the transactional/setup table holding institution type records. It supplies the ROWID, the institution type code, its description, the system institution type code, the close indicator, and the standard WHO audit columns.
  • IGS_LOOKUPS_VIEW (aliased LKUP) — the Oracle lookups source that translates OIT.SYSTEM_INST_TYPE into a meaning. The join condition is OIT.SYSTEM_INST_TYPE = LKUP.LOOKUP_CODE and LKUP.LOOKUP_TYPE = 'SYSTEM_INSTITUTION_TYPE'.
  • No additional base objects are documented for this view in the ETRM 12.2.2 metadata; the view text above is the authoritative definition.

Key Columns

  • ROW_ID — the ROWID of the IGS_OR_ORG_INST_TYPE row, useful for direct row identification or update targeting.
  • INSTITUTION_TYPE — the institution type code being defined.
  • DESCRIPTION — the descriptive text associated with the institution type.
  • SYSTEM_INST_TYPE — the stored system institution type lookup code; this is the "system_inst_type" element referenced by the view's search context.
  • SYSTEM_INST_TYPE_DESC — the MEANING from IGS_LOOKUPS_VIEW for the code in SYSTEM_INST_TYPE, providing the displayed description of the lookup.
  • CLOSE_IND — indicates whether the institution type record is closed or inactive.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified the record and when.

Common Use Cases and Queries

The view is typically used to list active institution types with their descriptive lookup meanings, to validate that a stored SYSTEM_INST_TYPE has a defined lookup, or to feed downstream integrations and reports with a clean classification list.

List all institution types with their system lookup descriptions:

  • SELECT institution_type, description, system_inst_type, system_inst_type_desc, close_ind FROM apps.igs_or_org_inst_type_v ORDER BY institution_type;

Retrieve only open (non-closed) institution types:

  • SELECT institution_type, description, system_inst_type_desc FROM apps.igs_or_org_inst_type_v WHERE NVL(close_ind,'N') = 'N';

Filter by a specific system institution type code:

  • SELECT institution_type, description FROM apps.igs_or_org_inst_type_v WHERE system_inst_type = :p_system_inst_type;

Because the view already joins to IGS_LOOKUPS_VIEW, consumers avoid replicating the LOOKUP_TYPE = 'SYSTEM_INSTITUTION_TYPE' lookup join in their own SQL, reducing the risk of mismatched or missing lookup translations.