Search Results igs_or_org_alt_idtyp_v

Overview

The view IGS_OR_ORG_ALT_IDTYP_V belongs to the IGS – Student System product family within Oracle E-Business Suite. ETRM classifies this component as Obsolete, and the documented implementation note explicitly states that the object is not implemented in the reference database used to build the ETRM 12.2.2 documentation set. The view is therefore presented as a documented historical artifact rather than an object expected to be present in a standard 12.1.1 or 12.2.2 installation.

The view exposes organization alternate identification type definitions alongside the decoded meaning of the associated system identification type. In the Oracle Student System data model, organization alternate identifier types describe how an organization may be identified by external or alternate numbering schemes, and whether those identifiers are preferred at the institutional or unit level. The view joins the base alternate identifier type table to the generic lookup values view so that reporting and integration consumers receive a human-readable description instead of a raw lookup code. The user search term pref_unit_ind corresponds directly to one of the columns exposed by this view, indicating that the query of interest concerns the unit-level preferred indicator for organization alternate identifier types.

Underlying Base Objects

The ETRM metadata records no separately documented base objects for this view; however, the view text documents its two source objects explicitly. The primary source is the table IGS_OR_ORG_ALT_IDTYP, aliased as OAIT. The secondary source is IGS_LOOKUP_VALUES, aliased as LKUP. The two are joined on OAIT.SYSTEM_ID_TYPE = LKUP.LOOKUP_CODE, with the lookup restricted to records where LOOKUP_TYPE = 'OR_SYSTEM_ID_TYPE'. Because the join references the lookup values view rather than decoding through a code table directly, the view inherits the standard lookup semantics: only lookup codes with a defined row in IGS_LOOKUP_VALUES for the OR_SYSTEM_ID_TYPE lookup type will resolve to a description. The view also exposes OAIT.ROWID as the ROW_ID column, providing a row identifier that can be used for updatable-view or row-locking scenarios where the view is treated as a base for form or API validation logic.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_OR_ORG_ALT_IDTYP row, useful for precise row identification.
• ORG_ALTERNATE_ID_TYPE — the code identifying the alternate organization identifier type.
• ID_TYPE_DESCRIPTION — the descriptive text for the alternate identifier type.
• INST_FLAG and UNIT_FLAG — flags indicating applicability of the identifier type at the institution or unit level.
• CLOSE_IND — indicates whether the identifier type is closed to further use.
• SYSTEM_ID_TYPE and SYSTEM_ID_TYPE_DESC — the coded system identifier type and its decoded lookup meaning.
• PREF_INST_IND — the institution-level preferred indicator.
• PREF_UNIT_IND — the unit-level preferred indicator, the column referenced by the search term pref_unit_ind.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle Applications audit columns.

Common Use Cases and Queries

Typical usage involves reporting on the configured organization alternate identifier types and their preferred status. A representative query selecting the object of the user’s search is shown below:

SELECT org_alternate_id_type,
       id_type_description,
       system_id_type,
       system_id_type_desc,
       pref_inst_ind,
       pref_unit_ind
FROM   igs_or_org_alt_idtyp_v
WHERE  pref_unit_ind = 'Y';

Because ETRM marks the view as obsolete and not implemented, such queries will not execute against a certified 12.1.1 or 12.2.2 instance; the statement is provided for documentation and migration analysis only. Institutions upgrading from earlier Student System releases should verify whether equivalent functionality has been re-implemented in a supported object before relying on this view for reporting or integration.