Search Results igs_en_bat_sua_ints_pk

Overview

The table IGS_EN_BAT_SUA_INTS is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master control table for batch uploads of student unit attempts. Its primary role is to store the header-level metadata and control information for each distinct batch of student enrollment data before the data is processed by the system's concurrent programs. This table is a mandatory prerequisite; a record must exist for a batch before the associated concurrent program can be executed to validate and upload the detailed unit attempt records from its child tables.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on the BATCH_ID, which is the table's primary key. This unique identifier is critical for linking the batch header to its detailed transaction lines. Other columns typically found in such control tables include status flags (e.g., 'NEW', 'PROCESSING', 'ERROR', 'COMPLETE'), creation dates, the name or ID of the user who initiated the batch, and parameters used for the upload process (such as academic calendar period, mode of study, or unit set). The table essentially holds the administrative and processing context for a group of student unit attempt transactions being uploaded en masse.

Common Use Cases and Queries

The primary use case is the batch creation and monitoring of student enrollments. An administrator would first insert a record into IGS_EN_BAT_SUA_INTS to generate a BATCH_ID, then populate the child table IGS_EN_BLK_SUA_INTS with the detailed enrollment records for multiple students. A common operational query is to check the status of all recent batches to monitor system processing.

• Sample Query: Monitoring Batch Status

  SELECT batch_id, creation_date, created_by, status
  FROM igs.igs_en_bat_sua_ints
  WHERE creation_date > SYSDATE - 1
  ORDER BY creation_date DESC;

• Sample Query: Joining to Child Records for a Specific Batch

  SELECT bat.batch_id, blk.*
  FROM igs.igs_en_bat_sua_ints bat,
       igs.igs_en_blk_sua_ints blk
  WHERE bat.batch_id = blk.batch_id
  AND bat.batch_id = 12345;

Related Objects

IGS_EN_BAT_SUA_INTS has a direct, documented parent-child relationship within the Student System's data model. It is the parent table referenced by the detail transaction table.

• IGS_EN_BLK_SUA_INTS: This is the primary and, according to the provided metadata, the only table with a documented foreign key relationship. The child table IGS_EN_BLK_SUA_INTS stores the individual student unit attempt records for a batch. The tables are joined on the BATCH_ID column (IGS_EN_BLK_SUA_INTS.BATCH_ID references IGS_EN_BAT_SUA_INTS.BATCH_ID). This relationship is enforced by the foreign key constraint.

The table's primary key constraint is named IGS_EN_BAT_SUA_INTS_PK on the BATCH_ID column. This key is essential for maintaining referential integrity with all associated detail records.