Search Results unit_set_version

Overview

The IGS_DA_IN_USET table is a data storage object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designated as obsolete. Its core function is to serve as a staging area for unit set data received from an external, third-party degree audit system. When a student's degree audit request is processed externally, the resulting program and unit set information is transmitted back to Oracle EBS. This table temporarily holds the detailed unit set information (such as majors or minors) that is associated with a specific incoming program record before it is likely validated and integrated into the core student academic records.

Key Information Stored

The table's structure is designed to link unit set data to a specific incoming program audit and to uniquely identify the unit set itself. The primary key is a composite of three columns, ensuring uniqueness for each unit set record within the context of an audit. The critical columns include:

• PRGM_SEQ_IN_ID: A foreign key column that links each unit set record to its parent incoming program record in the IGS_DA_IN_PRG table. This establishes the relationship between a program and its constituent unit sets from the audit.
• UNIT_SET_CODE: The code identifying the specific type of unit set (e.g., a major, minor, or concentration).
• UNIT_SET_VERSION: The version number of the unit set, which is essential for tracking curriculum changes over time. Together with the UNIT_SET_CODE and PRGM_SEQ_IN_ID, this forms the table's primary key.

Common Use Cases and Queries

The primary use case revolves around processing and reviewing the results of an externally performed degree audit. A typical query would involve joining this table to its parent to analyze all unit sets returned for a specific audit request. For instance, to extract all incoming unit set data for a particular audit program sequence, one might use a SQL pattern such as:

SELECT uset.unit_set_code, uset.unit_set_version
FROM igs_da_in_uset uset
WHERE uset.prgm_seq_in_id = :p_prgm_seq_in_id
ORDER BY uset.unit_set_code;

Reporting use cases would include reconciliation reports to compare externally audited unit sets against the student's official academic plan within EBS, or data validation scripts executed as part of the interface loading process before the incoming data is applied.

Related Objects

The table has a direct and critical dependency on the IGS_DA_IN_PRG table via a foreign key relationship. The column IGS_DA_IN_USET.PRGM_SEQ_IN_ID references the primary key of IGS_DA_IN_PRG, making IGS_DA_IN_PRG the parent table for all incoming unit set data. This structure indicates that data flows from the external system into IGS_DA_IN_PRG (program-level data), which then has detailed child records in IGS_DA_IN_USET (unit set data). Given the "Obsolete" status of the IGS Student System module, these tables are part of a legacy interface and may be superseded by alternative functionality in later or different implementations.