Search Results igs_ps_prg_unit_rel




Overview
Explore in AI Chat

Overview

The IGS_PS_PRG_UNIT_REL table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. It serves as a critical configuration table that defines and enforces permissible academic relationships. Its primary function is to store the allowed associations between a student's program type level (represented by their career level) and the unit or course type levels they are permitted to undertake. This table acts as a foundational rule set, enabling the system to validate whether a specific unit type is appropriate for a student enrolled in a particular program type, thereby ensuring academic integrity and compliance with institutional regulations.

Key Information Stored

The table's structure is designed to capture the essential elements of the program-unit relationship. The primary identifier is the PS_PRUN_REL_ID, a system-generated unique key. The two fundamental foreign key columns define the relationship itself: STUDENT_CAREER_LEVEL references a specific program type level from the IGS_PS_TYPE_ALL table, and UNIT_TYPE_ID references a valid unit type level from the IGS_PS_UNIT_TYPE_LVL table. The existence of a record in this table explicitly authorizes the linkage between the two referenced entities. The table also maintains a unique key constraint (IGS_PS_PRG_UNIT_REL_UK) on the combination of STUDENT_CAREER_LEVEL and UNIT_TYPE_ID to prevent duplicate relationship definitions.

Common Use Cases and Queries

This table is central to academic setup and validation processes. A primary use case is during the course enrollment or unit selection process, where the system queries IGS_PS_PRG_UNIT_REL to verify if a student's program career level permits enrollment in a unit of a given type. Administrators use this table to define and maintain the academic framework for all programs. Common reporting and query patterns include listing all unit types available for a specific program type level, or identifying which program levels are authorized for a particular unit type. A typical validation query would be:

  • SELECT COUNT(*) FROM igs_ps_prg_unit_rel WHERE student_career_level = :p_program_level AND unit_type_id = :p_unit_type_id;

This returns a count greater than zero if the enrollment is permissible.

Related Objects

The IGS_PS_PRG_UNIT_REL table is integral to the Student System's data model, with defined relationships to key reference tables. It directly references two primary entities:

  • IGS_PS_TYPE_ALL: Joined via the STUDENT_CAREER_LEVEL column. This table contains definitions for program types and their levels, providing the "program" side of the relationship.
  • IGS_PS_UNIT_TYPE_LVL: Joined via the UNIT_TYPE_ID column. This table defines the various unit or course type levels (e.g., introductory, advanced, graduate) available within the institution, providing the "unit" side of the relationship.

These foreign key relationships ensure referential integrity, meaning a relationship cannot be established for a program level or unit type that does not exist in the system. This table is likely referenced by various application forms, validation APIs, and enrollment engines within the IGS module.