Results for “org_structure_type”

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

Overview

The APPS.IGSBV_ORG_ALTERNATE_IDS view is a read-only reporting entity within the Oracle E-Business Suite Student System (IGS) product family. It consolidates alternate identifiers assigned to institutions and organizational units, exposing them alongside the descriptive attributes that define the type and purpose of each identifier. The view is defined with the WITH READ ONLY clause, confirming that it is intended strictly for query, extraction, and integration purposes rather than for direct DML operations.

Because alternate IDs frequently drive external system reconciliation, government reporting, and inter-agency data exchange, this view provides a denormalized access point that joins alternate ID assignments to their controlling ID type definitions. Users searching for attributes such as pref_unit_ind typically arrive here when determining whether a given alternate ID is flagged as the preferred identifier at the institutional or unit level.

Underlying Base Objects

The view is constructed from two underlying base tables in the APPS schema:

• IGS_OR_ORG_ALT_IDS (aliased OAI) — stores the actual alternate ID assignments for organizational structures, including the organization structure identifier, structure type, alternate ID type, the alternate ID value itself, and its effective date range.
• IGS_OR_ORG_ALT_IDTYP (aliased OAT) — stores the definition of each alternate ID type, including preference indicators and descriptive text.

The two objects are joined on ORG_ALTERNATE_ID_TYPE. The ETRM metadata for this view documents no additional referenced base objects, so the join above constitutes the complete definition. The view also embeds descriptor syntax (_LA:) to resolve lookup meanings for SYSTEM_ID_TYPE and ORG_STRUCTURE_TYPE against IGS_LOOKUP_VALUES.

Key Columns

• ORG_STRUCTURE_IDENTIFIER — the organizational structure ID to which the alternate ID belongs.
• ORG_STRUCTURE_TYPE and "_LA:ORG_STRUCTURE_TYPE_DESC" — the structure type code and its resolved lookup meaning.
• ORG_ALTERNATE_ID_TYPE and ORG_ALTERNATE_ID_TYPE_DESC — the alternate ID classification and its description.
• ORG_ALTERNATE_IDENTIFIER — the alternate ID value itself.
• "_LA:SYSTEM_ID_TYPE" — the resolved description of the system ID type lookup.
• PREF_INST_IND — indicates whether the alternate ID is the preferred identifier at the institution level.
• PREF_UNIT_IND — indicates whether the alternate ID is the preferred identifier at the organizational unit level. This is the column most commonly associated with the search term pref_unit_ind.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the active date range, mapped from START_DATE and END_DATE on the base table.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include identifying the preferred unit-level alternate ID for an organization, exporting identifier crosswalks for external systems, and auditing effective-dated identifier history.

• Locate preferred unit IDs for a given organizational structure.
• List all alternate ID types and their descriptions for reconciliation.
• Extract active identifiers as of a reporting date.

Sample query:

SELECT ORG_STRUCTURE_IDENTIFIER,
  ORG_ALTERNATE_ID_TYPE,
  ORG_ALTERNATE_IDENTIFIER,
  PREF_INST_IND,
  PREF_UNIT_IND,
  EFFECTIVE_START_DATE,
  EFFECTIVE_END_DATE
FROM APPS.IGSBV_ORG_ALTERNATE_IDS
WHERE PREF_UNIT_IND = 'Y'
  AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Additional filtering by ORG_STRUCTURE_TYPE or ORG_ALTERNATE_ID_TYPE is common when targeting specific institutional hierarchies or identifier standards.