Search Results igs_da_in_prg




Overview
Explore in AI Chat

Overview

The IGS_DA_IN_PRG table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a staging table specifically designed for the Degree Audit process. Its primary role is to store incoming program-related information transmitted from a third-party system for students who are the subject of a Degree Audit request. This table acts as an intermediary data store, holding external program data before it is validated and processed into the main student information system tables, ensuring data integrity during the import workflow.

Key Information Stored

The table's structure is centered around linking incoming program data to a specific student and audit request. Based on the provided metadata, the primary key is PRGM_SEQ_IN_ID, a unique sequence identifier for each incoming program record. Two critical foreign key columns establish essential relationships: BATCH_ID and PERSON_ID. These columns reference the IGS_DA_REQ_STDNTS table, thereby tethering each program record to a specific student within a specific batch of audit requests. While the full column list is not detailed, the table's purpose implies it likely stores data points such as the program code, version, academic plan, and potentially the student's enrollment status as reported by the external system.

Common Use Cases and Queries

The primary use case involves the ETL (Extract, Transform, Load) process for third-party degree audit data. Common operational and reporting queries include identifying all incoming program records for a specific audit batch to monitor the volume and status of data loads, or troubleshooting mismatches between external and internal program definitions. A typical validation query might join IGS_DA_IN_PRG with internal program tables to flag discrepancies.

  • Identifying incoming programs for a specific student request: SELECT * FROM igs_da_in_prg WHERE batch_id = &batch_id AND person_id = &person_id;
  • Summarizing incoming data volume per batch: SELECT batch_id, COUNT(*) FROM igs_da_in_prg GROUP BY batch_id;

Related Objects

IGS_DA_IN_PRG is integral to a network of Degree Audit tables. Its most direct relationship is with the IGS_DA_REQ_STDNTS table, which holds the master list of student requests for an audit batch, as enforced by the foreign key constraint. Furthermore, the table is referenced by the IGS_DA_IN_USET table via the PRGM_SEQ_IN_ID column. This indicates that IGS_DA_IN_USET stores more granular "unit set" or requirement group data that is associated with a specific incoming program record in IGS_DA_IN_PRG. This hierarchy structures the incoming data from programs down to their constituent components.