Search Results pref_inst_ind




Overview
Explore in AI Chat

Overview

IGS.IGS_OR_ORG_ALT_IDTYP is a foundational setup (control) table within the Oracle E-Business Suite student and institution product family, owned by the IGS schema. It stores the user-defined registry of alternate identification types that can be assigned to organizations, organizational units, and institutions. In practice, it functions as the master list from which valid alternate ID codes are drawn whenever an alternate identifier, such as a government registration number or a partner system key, is created against an organization or unit record. Because alternate IDs are widely exchanged with external agencies and downstream systems, this table governs which identifier labels are active, which are closed, and which carry preferred status for a given entity class.

Under the heuristic Data Vault classification mined from its foreign-key structure, this object is best modeled as a hub-leaning entity. It holds a stable, uniquely identified business concept, the alternate ID type, that is referenced by multiple transactional and setup satellites. Its primary key, IGS_OR_ORG_ALTERNATE_ID_TY_PK, is defined on the column ORG_ALTERNATE_ID_TYPE.

Key Information Stored

The table contains thirteen documented columns. The dominant business key is ORG_ALTERNATE_ID_TYPE (VARCHAR2(30)), which is also the subject of the unique index IGS_OR_ORG_ALT_IDTYP_U1 and the primary key constraint. It is the value that dependent tables store as a foreign key reference.

  • ORG_ALTERNATE_ID_TYPE — the surrogate and business key; the alternate ID type code itself.
  • ID_TYPE_DESCRIPTION — a human-readable description (VARCHAR2(60)) used in lookups and reports.
  • INST_FLAG / UNIT_FLAG — flags indicating whether the type applies to institution alternate IDs, unit (organization) alternate IDs, or both. These govern applicability by entity class.
  • CLOSE_IND — indicates whether the type is still available for use; closed types remain valid for historical data but are hidden from new entry.
  • SYSTEM_ID_TYPE — the system-assigned ID type, typically used to associate an internal or external system identifier.
  • PREF_INST_IND — marks a type as the preferred alternate ID type for institutions.
  • PREF_UNIT_IND — marks a type as the preferred alternate ID type for organization units. This is the column surfaced by the search term "pref_unit_ind."
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who audit columns for change tracking and accountability.

Common Use Cases and Queries

Typical usage includes populating alternate ID type list-of-values in forms, validating that a unit or institution alternate ID is of a permitted type, and identifying preferred identifiers during integration or reporting. For example, retrieving all active unit-level types available for entry:

SELECT ORG_ALTERNATE_ID_TYPE, ID_TYPE_DESCRIPTION
FROM IGS.IGS_OR_ORG_ALT_IDTYP
WHERE UNIT_FLAG = 'Y' AND NVL(CLOSE_IND,'N') = 'N';

To locate the preferred institution alternate ID type:

SELECT ORG_ALTERNATE_ID_TYPE, ID_TYPE_DESCRIPTION
FROM IGS.IGS_OR_ORG_ALT_IDTYP
WHERE PREF_INST_IND = 'Y';

Reporting scenarios frequently join this table to the actual alternate ID values to render meaningful descriptions and to distinguish institution versus unit identifiers, supporting data cleansing and duplicate identifier review.

Related Objects

The table is referenced by several dependent objects via the ORG_ALTERNATE_ID_TYPE column:

  • IGS_OR_ORG_ALT_IDS — stores the actual alternate ID values captured against organizations; joined on ORG_ALTERNATE_ID_TYPE.
  • IGS_DA_SETUP — uses DEFAULT_INST_ID_TYPE to point at the default institution alternate ID type.
  • IGS_OR_CWLK_DTL — references ALT_ID_TYPE, used in the organization crosswalk detail process.
  • APPS.IGS_OR_ORG_ALT_IDTYP — the APPS-layer synonym or view exposing the same structure.

Together these relationships confirm the table's role as the controlling hub for alternate organization and institution identifiers in the IGS module.