Search Results igs_da_out_unt_en

Overview

The IGS_DA_OUT_UNT_EN table is a core data structure within the Oracle E-Business Suite Student System (IGS). It serves as the transactional repository for storing details of a student's outgoing enrollment units processed during a Degree Audit request. A Degree Audit is a critical academic function that evaluates a student's completed coursework against the requirements of a specific academic program. This table's role is to hold the specific unit enrollment records that are sent out for evaluation as part of that audit process, enabling the system to track and analyze which courses are being considered for credit fulfillment.

Key Information Stored

The table's structure is designed to uniquely identify and link enrollment units to a specific student's audit request. The primary key is a composite of three columns, establishing a unique record for each unit in an audit. The BATCH_ID and PERSON_ID columns together form a foreign key link to the originating audit request record in the IGS_DA_REQ_STDNTS table, ensuring data integrity. The UNIT_SEQ_NUM provides a unique sequence identifier for each unit within that specific audit request for a student. While the provided metadata does not list all columns, typical data stored would include identifiers for the academic unit (course), the enrollment attempt, term, and potentially the grade or status associated with that enrollment for audit evaluation.

Common Use Cases and Queries

This table is primarily accessed for reporting and troubleshooting within the Degree Audit module. Common scenarios include generating detailed audit trails, reconciling the units evaluated in an audit, and supporting data extracts for institutional reporting. A typical query would join this table to the student and request header information to list all units processed for a specific audit. For example, to retrieve the audit units for a particular student and batch, a developer might use a SQL pattern such as:

• SELECT * FROM igs.igs_da_out_unt_en WHERE batch_id = &BATCH_ID AND person_id = &PERSON_ID ORDER BY unit_seq_num;

Data from this table is also fundamental for any custom reports that analyze the historical composition of degree audit evaluations over time.

Related Objects

The IGS_DA_OUT_UNT_EN table has a direct and dependent relationship with the main Degree Audit request table. As documented in the metadata, the table references IGS_DA_REQ_STDNTS via a foreign key constraint. The join is performed using the BATCH_ID and PERSON_ID columns. This relationship ensures that every unit enrollment record is associated with a valid, existing Degree Audit request for a student. The primary key IGS_DA_OUT_UNT_EN_PK (BATCH_ID, PERSON_ID, UNIT_SEQ_NUM) is likely referenced by other child tables or views within the IGS schema that may store further details about the evaluation results for each specific unit.