Results for “unit_flag”

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

Overview

The IGS_OR_ORG_ALT_IDTYP table belongs to the IGS (Student System) product family within Oracle E-Business Suite. In the ETRM metadata for releases 12.1.1 and 12.2.2, this object is explicitly flagged as obsolete and is documented as not implemented in the database. Conceptually, it represents the user-defined registry of external agencies, institutions, or systems for which alternate identifier codes are maintained against an organization or person record. Each row describes a distinct alternate identification "type" (for example, a state agency ID, a testing body reference, or an external system key) that downstream transactions can then reference when capturing an alternate ID value.

From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. That suggests it functions as a reference or master entity whose business key is reused as a foreign key target by dependent transactional tables — a natural candidate for a hub, with descriptive attributes such as descriptions and preference flags carried in a satellite.

Key Information Stored

The table is documented with 13 columns in the 12.1.1 physical schema. The most significant are:

• ORG_ALTERNATE_ID_TYPE — the primary key column of IGS_OR_ORG_ALTERNATE_ID_TY_PK, and also the sole unique index (IGS_OR_ORG_ALT_IDTYP_U1) column. This is the business-key candidate that uniquely names each alternate ID type.
• ID_TYPE_DESCRIPTION — the human-readable label presented to users when selecting an alternate ID type.
• SYSTEM_ID_TYPE — classifies the type as a system or internal identifier category.
• INST_FLAG and UNIT_FLAG — indicate whether the alternate ID type is valid for institution-level or unit-level records respectively.
• PREF_INST_IND and PREF_UNIT_IND — preference indicators governing default selection at institution or unit scope.
• CLOSE_IND — marks the type as closed/retired and unavailable for new entries.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO audit columns.

The surrogate primary key and the unique business key are, in this case, the same column, which is common for small reference tables in the IGS schema.

Common Use Cases and Queries

Functional use cases center on validating and labelling alternate ID type codes when organizations or institutions are mapped to external agencies. Typical patterns include:

• Listing all open, institution-applicable alternate ID types for a selection list.
• Resolving a description for a stored code on an integration or reporting extract.
• Confirming which types are flagged as preferred defaults during data entry.

A representative query is:

SELECT org_alternate_id_type, id_type_description
FROM igs_or_org_alt_idtyp
WHERE close_ind = 'N'
AND inst_flag = 'Y'
ORDER BY id_type_description;

Reporting usage is generally limited to lookup/validation lists joined onto transaction tables via ORG_ALTERNATE_ID_TYPE.

Related Objects

The FK relationships documented for this object identify the dependent tables that consume the alternate ID type code:

• IGS_OR_ORG_ALT_IDS — joined on ORG_ALTERNATE_ID_TYPE; stores the actual alternate ID values assigned to each organization.
• IGS_DA_SETUP — joined on DEFAULT_INST_ID_TYPE; holds the default institution ID type configuration.
• IGS_OR_CWLK_DTL — joined on ALT_ID_TYPE; captures alternate ID type usage in the calendar/workload detail stream.

Because the table is obsolete and undocumented as implemented, these relationships should be confirmed against the target database's actual dictionary before use.