Search Results igs_da_out_unt_ah

Overview

The IGS_DA_OUT_UNT_AH table is a core data repository within the Oracle E-Business Suite Student System (IGS) module. It serves as the designated storage location for all outgoing academic history data pertaining to a student during a Degree Audit request process. In the context of academic advising and degree progress tracking, this table acts as a staging or output area where the system compiles and organizes a student's completed academic units (courses) for evaluation against degree program requirements. Its existence is critical for the batch-oriented processing of degree audits, ensuring that the historical academic data used for evaluation is consistent, traceable, and linked to a specific audit request.

Key Information Stored

The table's structure is designed to uniquely identify and store academic history records for a specific student within a specific audit batch. The primary key is a composite of three columns, which together form the unique identifier IGS_DA_OUT_UNT_AH_PK. The BATCH_ID links the record to a specific degree audit request batch. The PERSON_ID uniquely identifies the student. The UNIT_SEQ_NUM provides a sequence number for each academic unit (course) record within the student's history for that batch. While the provided metadata does not list all columns, typical data stored would include details for each academic unit, such as unit code, title, grade, credit hours, term taken, and potentially the result status, all relevant to the degree audit evaluation.

Common Use Cases and Queries

The primary use case is supporting the batch degree audit functionality. When an advisor runs an audit for a group of students, the system populates this table with the relevant academic history for each student in the batch. Common queries involve extracting this compiled history for reporting, troubleshooting audit results, or feeding data to external systems. A typical SQL pattern would join this table to the student request table to retrieve a full audit dataset.

SELECT ah.*
FROM igs.igs_da_out_unt_ah ah,
     igs.igs_da_req_stdnts req
WHERE ah.batch_id = req.batch_id
  AND ah.person_id = req.person_id
  AND req.batch_id = :p_batch_id;

This data is essential for generating detailed audit reports that list all courses considered during the evaluation, providing transparency into the audit process.

Related Objects

The table has defined relationships with other key objects in the Degree Audit subsystem, primarily through foreign key constraints.

• IGS_DA_REQ_STDNTS: This is the primary parent table. The foreign key from IGS_DA_OUT_UNT_AH (BATCH_ID, PERSON_ID) references IGS_DA_REQ_STDNTS, ensuring that every stored academic history record is associated with a valid student request within a specific audit batch. This is the core relationship for tracing audit output back to its source request.

As a child table of IGS_DA_REQ_STDNTS, IGS_DA_OUT_UNT_AH is likely referenced by various Degree Audit reporting views and may be populated by internal APIs or concurrent programs responsible for executing the audit engine and writing its output.