Search Results igs_da_in_uset_u2

Overview

The IGS_DA_IN_USET table is a core data staging table within the Oracle E-Business Suite (EBS) 12.1.1/12.2.2 Student Management (Campus Solutions) module. Its primary function is to temporarily store detailed unit set (e.g., major, minor, track) information received from a third-party degree audit engine for students whose academic progress has been evaluated. The table acts as an intermediary, holding processed audit results for individual unit sets associated with a student's program before this data is potentially integrated into the core EBS academic records. As explicitly noted in its documentation, this table is marked as "Obsolete," indicating it may be part of a legacy interface or slated for replacement in future releases.

Key Information Stored

The table stores a granular breakdown of degree audit results per unit set. Key columns include identifiers to link the data back to the specific audit request and student (BATCH_ID, PERSON_ID, PRGM_SEQ_IN_ID), and the academic program and unit set being evaluated (PROG_CODE, PROG_VERSION, UNIT_SET_CODE, UNIT_SET_VERSION). Crucially, it holds the audit outcome details: the UNIT_SET_GPA_TYPE (e.g., 'MAJ' for Major GPA), the completion indicator (UNIT_SET_COMPL_IND), the completion date (UNIT_SET_COMPL_DATE), and the source system (UNIT_SET_COMPL_SRC), which is noted to always signify a third-party system.

Common Use Cases and Queries

This table is primarily queried for reporting on batch degree audit results or for data validation during the interface process. Common scenarios include reconciling incoming third-party data and generating summary reports for academic advisors. A typical query would join to the parent program table to fetch all unit set results for a specific audit batch or student.

Sample Query: Fetch Unit Set Results for a Specific Audit Batch

SELECT uset.person_id,
       uset.unit_set_code,
       uset.unit_set_version,
       uset.unit_set_gpa_type,
       uset.unit_set_compl_ind,
       uset.unit_set_compl_date
FROM   igs.igs_da_in_uset uset
WHERE  uset.batch_id = :p_batch_id
ORDER BY uset.person_id, uset.unit_set_code;

Sample Query: Identify Completed Majors for a Student

SELECT unit_set_code, unit_set_version, unit_set_compl_date
FROM   igs.igs_da_in_uset
WHERE  person_id = :p_person_id
AND    unit_set_gpa_type = 'MAJ'
AND    unit_set_compl_ind = 'Y';

Related Objects

• Primary Key: The table's primary key is enforced by the IGS_DA_IN_USET_PK constraint on the columns (PRGM_SEQ_IN_ID, UNIT_SET_CODE, UNIT_SET_VERSION).
• Foreign Key (Parent Table): A critical relationship exists with the IGS_DA_IN_PRG table. The PRGM_SEQ_IN_ID column in IGS_DA_IN_USET references the IGS_DA_IN_PRG table, linking each unit set record to its parent program-level audit record received from the third-party system.
• Unique Indexes: The table has two unique indexes (IGS_DA_IN_USET_U1, IGS_DA_IN_USET_U2) that enforce alternative unique keys for data integrity, covering the primary key columns and a combination of batch, person, program, and unit set identifiers.