Search Results igs_en_blk_sua_ints_pk




Overview
Explore in AI Chat

Overview

The table IGS_EN_BLK_SUA_INTS is a legacy data staging table within the Oracle E-Business Suite (EBS) Student System (IGS), which is now marked as obsolete. Its primary function was to serve as an intermediate holding area for student unit attempt (SUA) data destined for import into the core transactional table, IGS_EN_SI_ATTEMPT_ALL. This table was designed to operate within a batch processing framework, where data was loaded in discrete blocks. As explicitly noted in the ETRM metadata, every row in this table was required to be associated with a parent batch record in the IGS_EN_BAT_SUA_INTS table, ensuring data integrity and traceability during the import process.

Key Information Stored

The table's structure is centered on capturing the details necessary to create or update a student's enrollment in a specific unit. While the full column list is not provided in the excerpt, the documented primary and foreign keys reveal its core architecture. The UPLOAD_ID column serves as the table's unique primary key (IGS_EN_BLK_SUA_INTS_PK). The BATCH_ID column is a critical foreign key that links each block of unit attempt data to a controlling record in the IGS_EN_BAT_SUA_INTS batch table. Typically, other columns would include identifiers for the student (PERSON_ID), the academic unit (UNIT_CD, VERSION_NUMBER), the teaching calendar (CAL_TYPE, CI_SEQUENCE_NUMBER), and the enrollment status, forming a complete record for import.

Common Use Cases and Queries

The primary use case for this table was the bulk loading of student enrollment data, often from external systems or during mass enrollment periods. Data would be inserted into IGS_EN_BLK_SUA_INTS, validated, and then processed by a concurrent program to transfer it into the live IGS_EN_SI_ATTEMPT_ALL table. Common queries would involve validating data prior to import or troubleshooting failed batches. A typical pattern would be to join to the batch table to review all data for a specific processing run:

  • SELECT blk.* FROM igs_en_blk_sua_ints blk, igs_en_bat_sua_ints bat WHERE blk.batch_id = bat.batch_id AND bat.batch_name = '&BATCH_NAME';

Given its status as obsolete and not implemented in the documented database, direct operational use in EBS 12.1.1 or 12.2.2 is unlikely. Its relevance is now primarily historical or for understanding data flows in legacy implementations.

Related Objects

The ETRM documentation specifies a clear, singular relationship for this table. It is a child table dependent on the batch control table.

  • IGS_EN_BAT_SUA_INTS: This is the parent table. The relationship is enforced by a foreign key where IGS_EN_BLK_SUA_INTS.BATCH_ID references a record in IGS_EN_BAT_SUA_INTS. Every block of SUA data must belong to a defined batch.
  • IGS_EN_SI_ATTEMPT_ALL: As stated in the description, this is the ultimate target transactional table. Data staged in IGS_EN_BLK_SUA_INTS was processed and inserted into this table, which holds the official student unit attempt records.