Search Results src_unit_id

Overview

The table IGS_DA_IN_SRC_UNTS is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the Degree Audit functionality. Its primary role is to serve as the transactional repository for all source academic units provided by a third-party system for students undergoing a degree audit request. This table acts as the staging area for incoming transfer credit or external course data, which is then processed and evaluated against a student's academic program requirements. Its existence is critical for automating the assessment of a student's progress toward a degree by incorporating external academic history.

Key Information Stored

The table's central purpose is to store detailed records of external units for specific audit requests. While the full column list is not provided in the metadata, the documented primary and foreign keys reveal its core structure. The SRC_UNIT_ID column serves as the unique primary key for each source unit record. Each record is explicitly linked to a specific student's audit request via the foreign key columns BATCH_ID and PERSON_ID, which reference the IGS_DA_REQ_STDNTS table. Typically, such a table would also contain columns for unit details like course code, title, credit hours, grade, issuing institution, and completion date, enabling a comprehensive evaluation against the target degree program.

Common Use Cases and Queries

The primary use case involves processing and reporting on external credits submitted for a degree audit. Common operational and reporting queries include retrieving all source units for a specific audit batch to review incoming data, or listing external credits for a particular student to inform academic advising. A typical SQL pattern would join this table to the student request table to provide context.

• Sample Query: SELECT src.* FROM igs_da_in_src_unts src, igs_da_req_stdnts req WHERE src.batch_id = req.batch_id AND src.person_id = req.person_id AND req.request_number = '&REQ_NUM';
• Reporting Use Case: Generating a summary report of all third-party submitted units within a given date range, aggregated by source institution, to analyze transfer credit trends.

Related Objects

IGS_DA_IN_SRC_UNTS has a direct and essential relationship with the student audit request table, forming the backbone of the degree audit intake process.

• IGS_DA_REQ_STDNTS: This is the primary parent table, linked via a foreign key relationship. The columns IGS_DA_IN_SRC_UNTS.BATCH_ID and IGS_DA_IN_SRC_UNTS.PERSON_ID reference the corresponding columns in IGS_DA_REQ_STDNTS. This ensures every source unit is associated with a valid, existing degree audit request for a specific student and processing batch.

This table is also likely referenced by various Degree Audit engine packages and views responsible for processing, matching, and applying these source units to requirement groups, though these are not explicitly documented in the provided metadata.