Search Results igs_da_out_unt_cat

Overview

The IGS_DA_OUT_UNT_CAT table is a core data repository within the Oracle E-Business Suite Student System (IGS), specifically designed for the Degree Audit functionality. Its primary role is to store detailed categorization information for academic units (courses or subjects) identified for a student during a degree audit request processing run. This table acts as an output log, capturing how each unit is classified against defined academic categories (e.g., major requirements, electives, general education) for a specific audit instance. As indicated by its product module classification, this object is part of the legacy IGS system, which is noted as obsolete, suggesting newer architectural components may supersede it in current implementations.

Key Information Stored

The table's structure is designed to uniquely associate a unit category with a specific unit from a specific audit for a specific student. The primary key is a composite of five columns, ensuring this granular uniqueness. Key columns include:

• BATCH_ID: Links the record to a specific degree audit batch or request run.
• PERSON_ID: Identifies the student (person) for whom the audit was performed.
• UNIT_SEQ_NUM and OSS_UNIT_LOCATOR: Together, these fields uniquely identify the specific academic unit within the student's academic record that was evaluated.
• UNIT_CATEGORY: Stores the code or identifier for the academic category (e.g., CORE, ELECTIVE) into which the unit was placed by the degree audit engine.

Common Use Cases and Queries

This table is essential for reviewing and reporting on the results of automated degree audits. A primary use case is generating a detailed audit trail to explain how a student's completed and in-progress units satisfy their program requirements. Administrators may query this table to verify categorization logic or troubleshoot discrepancies. A typical reporting query would join this table to person and unit master data to produce a readable audit report. For example:

SELECT dauc.person_id, dauc.unit_category, u.unit_code
FROM igs_da_out_unt_cat dauc
JOIN igs_ps_unit u ON dauc.oss_unit_locator = u.unit_locator
WHERE dauc.batch_id = :batch_id
AND dauc.person_id = :student_id
ORDER BY dauc.unit_seq_num;

Given its "obsolete" status, direct operational use may be limited in upgraded environments, with data potentially migrated or accessed via higher-level application interfaces.

Related Objects

The table's relationships are primarily defined by its composite primary key. The columns BATCH_ID, PERSON_ID, UNIT_SEQ_NUM, and OSS_UNIT_LOCATOR are foreign keys that reference corresponding output tables from the degree audit process. Specifically, it would relate to a parent table storing the main list of audited units (likely named similarly, e.g., IGS_DA_OUT_UNIT), using the same combination of columns (excluding UNIT_CATEGORY) as its primary key. The UNIT_CATEGORY column may reference a validation table (e.g., IGS_PS_UNIT_CAT) defining valid category codes. Therefore, this table is a child entity in the degree audit output data model, providing detailed categorical breakdowns for each unit record produced by the audit engine.