Search Results igs_or_institution




Overview
Explore in AI Chat

Overview

The view IGS_OR_INSTITUTION belongs to the IGS (Student System) product family within Oracle E-Business Suite. Its purpose, as documented in the ETRM metadata, is to describe institution details — that is, it exposes a denormalized, report-ready representation of institutions registered against the Oracle Student System organization model. The view consolidates institution descriptors from the Higher Education (HZ) party model, the IGS organizational party extensions, institution type and control-type lookups, and preferred alternate identifier data.

The ETRM listing classifies the owning product as Obsolete. Under the 12.2.2 documented metadata, the view is reported as "Not implemented in this database," meaning it is not deployed in the reference instance from which the ETRM extract was taken. Consequently, reliance on this view in a 12.1.1 or 12.2.2 environment should be confirmed by querying ALL_VIEWS / DBA_VIEWS before any report or integration is built against it. Where the view does exist, it functions primarily as a reporting and integration abstraction rather than a transactional object; it carries no DML of its own and inherits all change history from the underlying tables.

Underlying Base Objects

The ETRM "referenced base objects" section documents no base objects for this view, which reflects the fact that the view was not implemented in the source database at extraction time. The view text preserved in the metadata, however, identifies the constituent objects explicitly. These are:

  • HZ_PARTIES — the TCA party master, aliased HP, supplying party name, party number, audit columns, and the DFF attribute columns.
  • IGS_PE_HZ_PARTIES — aliased IHP, the IGS extension of the party record holding institution-specific attributes such as status, control type, institution type, and phone components.
  • IGS_OR_ORG_INST_TYPE — aliased OIT, providing the institution type description.
  • IGS_LOOKUP_VALUES — joined twice, as OICT (lookup type OR_INST_CTL_TYPE) and INP, for control-type and priority meanings.
  • IGS_AD_CODE_CLASSES — aliased INP1, supplying secondary school location name and description.
  • An inline subquery over IGS_OR_ORG_ALT_IDS and IGS_OR_ORG_ALT_IDTYP — aliased PID — which restricts to the preferred alternate ID type (PREF_INST_IND = 'Y') effective as of SYSDATE.

The driving join is HP.PARTY_ID = IHP.PARTY_ID with the filter IHP.INST_ORG_IND = 'I', which restricts output to parties flagged as institutions. Institution type, control type, class-code, and lookup joins are largely outer joins, so the view tolerates partially populated institution records.

Key Columns

Common Use Cases and Queries

Typical uses include institutional reporting (producing a catalog of institutions with type, control, and preferred identifier), student-system integration extracts feeding external bodies such as government reporting agencies, and validation queries in data-conversion projects populating IGS_PE_HZ_PARTIES. A representative query is:

  • SELECT institution_cd, party_name, description, ctrl_description, pref_inst_alt_id FROM igs_or_institution WHERE oi_institution_status = 'A' ORDER BY party_name;
  • SELECT oi_institution_type, COUNT(*) FROM igs_or_institution GROUP BY oi_institution_type;
  • SELECT party_id, party_name FROM igs_or_institution WHERE pref_inst_id_type IS NOT NULL;

Because the view is marked obsolete and unimplemented in 12.2.2, equivalents should be constructed directly against HZ_PARTIES, IGS_PE_HZ_PARTIES, and the associated IGS organization tables should the view be absent.