Search Results igs_or_org_alternate_id_ty_pk

Overview

The IGS_OR_ORG_ALT_IDTYP table is a core reference table within the Oracle E-Business Suite Student System (IGS). It functions as a master repository for defining the types of alternate identifiers that can be assigned to organizational entities, such as institutions, departments, or other parties within the system. Its primary role is to provide a controlled list of external agencies, systems, or classification schemes—like a state education board, a national accreditation body, or an internal legacy system—for which an organization may maintain a secondary or external code. This enables the system to consistently track and manage multiple identifiers for a single organization across different contexts, ensuring data integrity and supporting complex reporting and integration requirements.

Key Information Stored

The table's structure is designed to catalog the valid types of alternate IDs. While the full column list is not detailed in the provided metadata, the primary key column, ORG_ALTERNATE_ID_TYPE, is explicitly identified. This column stores the unique code representing the type of alternate identifier (e.g., 'STATE_REG', 'FED_TAX_ID', 'LEGACY_SYS_CODE'). Other typical columns in such a reference table would include a description field for the ID type, control attributes like start and end dates to manage validity, and who columns for auditing (CREATED_BY, CREATION_DATE, etc.). The existence of a primary key constraint (IGS_OR_ORG_ALTERNATE_ID_TY_PK) on ORG_ALTERNATE_ID_TYPE enforces uniqueness and is the anchor point for all foreign key relationships.

Common Use Cases and Queries

This table is central to processes requiring the validation and reporting of organization identifiers. A common use case is during data entry or integration from external systems, where an incoming organization record's alternate ID type is validated against this table before being stored in the related IGS_OR_ORG_ALT_IDS table. For reporting, it is frequently joined to provide meaningful descriptions for coded ID types. A typical query pattern involves joining to the detail table to list all alternate IDs for a specific organization:

• SELECT alt_ids.org_id, idtyp.org_alternate_id_type, alt_ids.alternate_id FROM igs_or_org_alt_ids alt_ids, igs_or_org_alt_idtyp idtyp WHERE alt_ids.org_alternate_id_type = idtyp.org_alternate_id_type AND alt_ids.org_id = :p_org_id;

Administrative setups, such as configuring default values in the IGS_DA_SETUP table, also rely on the valid codes stored in IGS_OR_ORG_ALT_IDTYP.

Related Objects

The IGS_OR_ORG_ALT_IDTYP table has defined foreign key relationships with several other tables in the IGS schema, as documented in the metadata. These relationships illustrate its critical role as a parent reference table.

• IGS_OR_ORG_ALT_IDS: This is the primary child table. It stores the actual alternate ID values for specific organizations. It references IGS_OR_ORG_ALT_IDTYP via the column IGS_OR_ORG_ALT_IDS.ORG_ALTERNATE_ID_TYPE to ensure every stored ID has a valid, predefined type.
• IGS_DA_SETUP: References this table via IGS_DA_SETUP.DEFAULT_INST_ID_TYPE, likely to define a default institution identifier type for a particular process or module setup.
• IGS_OR_CWLK_DTL: References this table via IGS_OR_CWLK_DTL.ALT_ID_TYPE, indicating its use in crosswalk or mapping details, possibly for system integrations or data conversions.