Search Results igs_da_out_unt_as

Overview

The IGS_DA_OUT_UNT_AS table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a repository for detailed information regarding outgoing Advanced Standing (AS) units for a student within the context of a Degree Audit request. Advanced Standing typically refers to academic credit granted for prior learning, and this table stores the specific unit-level details of such credits that are being considered or have been applied as part of a student's degree progression audit. Its primary role is to maintain a granular, auditable record of these units linked to a specific student and audit request batch.

Key Information Stored

The table's structure is designed to uniquely identify and describe each unit of advanced standing. The primary key consists of three columns, ensuring each record is distinct within the audit context: BATCH_ID and PERSON_ID together link the record to a specific student's audit request, while UNIT_SEQ_NUM provides a unique sequence for multiple units within that request. While the full column list is not detailed in the provided metadata, based on its purpose, one can infer it likely contains columns for the unit code, title, credit value, granting institution, status, and the effective date of the advanced standing. The foreign key relationship confirms that BATCH_ID and PERSON_ID are critical for maintaining referential integrity with the parent audit request record.

Common Use Cases and Queries

This table is central to reporting and processes involving student transfer credit and exemptions. Common use cases include generating detailed audit reports that list all advanced standing credits applied to a student's degree program, supporting academic advising sessions, and feeding data into official academic transcripts. A typical query would join this table to the student and program tables to analyze advanced standing patterns. For example:

SELECT daoua.* FROM igs_da_out_unt_as daoua JOIN igs_da_req_stdnts dars ON daoua.batch_id = dars.batch_id AND daoua.person_id = dars.person_id WHERE dars.person_id = :student_id ORDER BY daoua.unit_seq_num;

This retrieves all outgoing advanced standing units for a specific student across audit batches. Data from this table is also crucial for compliance reporting and assessing the impact of transfer credit on time-to-degree metrics.

Related Objects

The table maintains a direct and critical relationship with the IGS_DA_REQ_STDNTS table, which stores the header-level information for a student's degree audit request. The documented foreign key constraint enforces that every record in IGS_DA_OUT_UNT_AS must correspond to an existing record in IGS_DA_REQ_STDNTS, using the composite key of BATCH_ID and PERSON_ID. This relationship ensures that unit-level advanced standing details are always tied to a valid audit request. Consequently, IGS_DA_REQ_STDNTS is the primary parent table. Other related objects likely include views or APIs that aggregate this detailed data for presentation within the Student System's Degree Audit functionality, though they are not explicitly named in the provided metadata.