Search Results igs_or_crosswalk

Overview

The IGS_OR_CWLK_DTL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Institutional Global Systems) product family. It functions as a detail table within a crosswalk mechanism, storing the specific mapping or translation details between different identifier systems for an institution. Its primary role is to maintain a detailed, auditable record of alternate identifiers (such as legacy system IDs or external partner codes) associated with a master crosswalk entry, enabling data integration and synchronization across disparate systems.

Key Information Stored

The table's structure is designed to capture mapping details and standard audit information. The most critical columns include:

• CROSSWALK_DTL_ID: The unique primary key identifier for each detail record in the crosswalk.
• CROSSWALK_ID: A foreign key linking the detail record to its parent header record in the IGS_OR_CROSSWALK table.
• ALT_ID_TYPE: The classification of the alternate identifier (e.g., 'LEGACY_STUDENT_ID', 'PARTNER_CODE'), typically referencing a lookup.
• ALT_ID_VALUE: The actual value of the alternate identifier for the given type.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Provide essential audit trail data.
• Standard Concurrent Program WHO Columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE): Track the origin of changes made by batch processes.

Common Use Cases and Queries

This table is central to operations that require translating or resolving institutional identifiers. A common use case is during data migration or interfacing, where an external system provides an identifier of a specific type (ALT_ID_TYPE) that must be resolved to the internal EBS institution key. For reporting, it allows joins to present both primary and alternate identifiers. A typical query pattern involves fetching all alternate IDs for a given crosswalk or finding the primary crosswalk ID from a known alternate value.

Sample Query: Resolve an Alternate Identifier
SELECT cwlk.crosswalk_id, cwlk_dtl.alt_id_type, cwlk_dtl.alt_id_value
FROM igs.igs_or_cwlk_dtl cwlk_dtl,
igs.igs_or_crosswalk cwlk
WHERE cwlk_dtl.crosswalk_id = cwlk.crosswalk_id
AND cwlk_dtl.alt_id_type = 'LEGACY_SYS_ID'
AND cwlk_dtl.alt_id_value = '&provided_legacy_id';

Related Objects

The IGS_OR_CWLK_DTL table exists within a defined relational schema, with documented foreign key relationships that dictate data integrity and common join paths.

• Primary Key: IGS_OR_CWLK_DTL_PK on column CROSSWALK_DTL_ID.
• Foreign Key (Parent Reference): The CROSSWALK_ID column references the IGS_OR_CROSSWALK table. This links detail records to their parent crosswalk definition.
• Foreign Key (Lookup Reference): The ALT_ID_TYPE column references the IGS_OR_ORG_ALT_IDTYP table (or a similarly named lookup), validating the type of alternate identifier being stored.