Search Results igs_or_cwlk_dtl

Overview

The IGS_OR_CWLK_DTL table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically in releases 12.1.1 and 12.2.2. It functions as a detail table within an institution crosswalk mechanism. The table's purpose is to store detailed mapping records that facilitate the translation or association of institution identifiers from one system or format to another, often referred to as an OSS (Oracle Student System) institution crosswalk. This is critical for data integration, reporting, and ensuring consistency when interfacing with external systems or consolidating data from multiple sources within the student information ecosystem.

Key Information Stored

The table stores the specific mappings that constitute a crosswalk entry. The primary columns include CROSSWALK_DTL_ID, which serves as the unique system-generated identifier for each detail record. The ALT_ID_TYPE and ALT_ID_VALUE columns define the alternative identifier being mapped, such as a legacy system code or an external organization ID. The CROSSWALK_ID column is a foreign key that links the detail record to its parent crosswalk definition in the IGS_OR_CWLK table. The unique key constraint IGS_OR_CWLK_DTL_UK1 on ALT_ID_TYPE and ALT_ID_VALUE enforces data integrity by preventing duplicate identifier mappings within the system.

Common Use Cases and Queries

This table is central to processes that require identifier translation. A common use case is during data migration or system integration, where external application IDs must be correctly associated with internal EBS institution records for seamless data flow. Another scenario is in consolidated reporting, where data from disparate sources using different coding schemes must be normalized. A typical query would involve joining this table to the parent crosswalk and the organization master to retrieve a complete mapping.

SELECT cwlk.crosswalk_name,
       dtl.alt_id_type,
       dtl.alt_id_value,
       org.inst_display_name
FROM igs_ig.igs_or_cwlk_dtl dtl,
     igs_ig.igs_or_cwlk cwlk,
     igs_ig.igs_or_organization org
WHERE dtl.crosswalk_id = cwlk.crosswalk_id
AND cwlk.inst_org_id = org.inst_org_id
AND dtl.alt_id_type = 'LEGACY_SYS_CODE';

Related Objects

The IGS_OR_CWLK_DTL table has defined relationships with other key tables in the IGS schema, primarily through its foreign key constraints. The primary key IGS_OR_CWLK_DTL_PK (CROSSWALK_DTL_ID) uniquely identifies each row. The table references two parent tables: it links to the IGS_OR_CWLK table via the CROSSWALK_ID column to associate each detail record with its overarching crosswalk definition. Furthermore, it references the IGS_OR_ORG_ALT_IDTYP table via the ALT_ID_TYPE column, ensuring that the type of alternative identifier used in the mapping is a valid, predefined type within the system. These relationships are fundamental to maintaining referential integrity across the institution crosswalk data model.