Search Results igs_en_unitsetpstype




Overview
Explore in AI Chat

Overview

The IGS_EN_UNITSETPSTYPE table is a configuration table within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary role is to enforce academic governance by defining course type restrictions on unit sets (also known as majors, minors, or specializations). A unit set represents a defined collection of academic units. This table acts as a control mechanism, restricting the specific course versions (e.g., Bachelor of Science 2022 intake) to which a particular unit set can be attached or linked. If no records exist for a given unit set in this table, the system interprets this as having no restrictions, allowing the unit set to be linked to any course version.

Key Information Stored

The table stores a composite key that uniquely identifies a restriction rule. The UNIT_SET_CD and VERSION_NUMBER columns together identify the specific unit set being restricted. The COURSE_TYPE column holds the code for the type of course (e.g., 'UNDERGRAD', 'POSTGRAD_RESEARCH') to which the unit set is permitted to link. The presence of a record signifies an explicit allowance; the absence of a record for a potential course type implies a restriction. This design allows administrators to create a positive list of compatible course types for each unit set.

Common Use Cases and Queries

A primary use case is during the setup or maintenance of academic programs, where an administrator needs to ensure a specialized unit set is only available within appropriate degree paths. For reporting, queries often join this table to course and unit set master data to audit or list effective restrictions. A common SQL pattern retrieves all permitted course types for a given unit set:

  • SELECT course_type FROM igs_en_unitsetpstype WHERE unit_set_cd = '&unit_set_code' AND version_number = &version_num;

Conversely, to find all unit sets that can be attached to a specific course type, one would query:

  • SELECT us.unit_set_cd, us.version_number FROM igs_en_unitsetpstype ust JOIN igs_en_unit_set_all us ON ust.unit_set_cd = us.unit_set_cd AND ust.version_number = us.version_number WHERE ust.course_type = '&course_type_code';

Related Objects

This table maintains critical foreign key relationships with core master tables in the Student System. It references the IGS_EN_UNIT_SET_ALL table via the UNIT_SET_CD and VERSION_NUMBER columns, ensuring any restriction is tied to a valid, existing unit set. Furthermore, it references the IGS_PS_TYPE_ALL table via the COURSE_TYPE column, validating that the restricted type is a defined and active course type within the system. These relationships are essential for maintaining data integrity across the academic structure.