Search Results igs_or_org_inst_type




Overview
Explore in AI Chat

Overview

The IGS_OR_ORG_INST_TYPE view is a secured, Multi-Org compliant reporting object within the Oracle E-Business Suite IGS – Student System product family. It is owned by the APPS schema and holds a VALID status in both the 12.1.1 and 12.2.2 release levels. The view exposes institution type reference data for student organizations, allowing external reports, concurrent programs, and integration interfaces to read organization institution type setup without querying the base table directly. Because the definition applies a runtime predicate against USERENV('CLIENT_INFO'), the view automatically restricts returned rows to the operating unit (ORG_ID) of the current session, enforcing Oracle's Multi-Org Access Control (MOAC) model. This makes it the preferred access path for any custom inquiry or extract that must remain consistent with the user's current organization context.

Underlying Base Objects

The view is defined over a single documented base object: IGS_OR_ORG_INST_TYPE_ALL, an _ALL suffixed table that stores institution type records across all operating units. The view selects from this table using the alias TAB and inherits every column of the base table, adding the pseudo-column ROWID projected as ROW_ID. The WHERE clause compares the row's ORG_ID to the value decoded from the first ten characters of the client information string. When the leading character is a space, the decode returns NULL; the NVL chain then falls back to -99, so the predicate resolves to NVL(...,-99) = NVL(...,-99). Sessions that do not supply a client information value effectively match rows whose ORG_ID is NULL or -99, while normal sessions are filtered to their own organization. No other base tables, synonyms, or database links are documented as referenced objects.

Key Columns

  • ROW_ID – The physical ROWID of the underlying IGS_OR_ORG_INST_TYPE_ALL row, useful for de-duplication and direct row identification.
  • ORG_ID – The operating unit identifier that drives the Multi-Org security predicate and links the record to organizational hierarchy setup.
  • INSTITUTION_TYPE – The institution type code, the primary business key used to classify the organization.
  • DESCRIPTION – The descriptive text associated with the institution type code, used widely in reports and list of values.
  • SYSTEM_INST_TYPE – Indicates whether the institution type is a system-defined (seeded) value, distinguishing delivered reference data from user-entered records.
  • CLOSE_IND – The close indicator that flags whether the institution type is active or closed for further use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle WHO columns providing audit and concurrency information.

Common Use Cases and Queries

Typical usage includes institution type list-of-values lookups, validation of organization level institution types prior to student data load, and reporting of active versus closed types per operating unit. A representative query retrieving active institution types for the current session organization is:

  • SELECT institution_type, description, system_inst_type FROM igs_or_org_inst_type WHERE NVL(close_ind,'N') = 'N' ORDER BY institution_type;
  • SELECT org_id, institution_type, description FROM igs_or_org_inst_type WHERE system_inst_type IS NOT NULL AND close_ind IS NULL;
  • SELECT COUNT(*), org_id FROM igs_or_org_inst_type GROUP BY org_id; to audit institution type distribution across organizations visible to the session.

Because the view applies MOAC filtering automatically, developers should not add a conflicting ORG_ID predicate unless cross-organization reporting through a secured responsibility is intended. When a broader scope is required, the base table IGS_OR_ORG_INST_TYPE_ALL should be considered instead, subject to the appropriate security review.