Search Results unit_type_id




Overview
Explore in AI Chat

Overview

The IGS_PS_PRG_UNIT_REL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (iStudent) or Campus Solutions modules under the IGS schema. Its primary function is to define and enforce the permissible relationships between different academic program types and unit (or course) type levels. This table acts as a control mechanism, governing which types of units can be included within specific types of academic programs based on a student's career level. It is critical for ensuring academic integrity and accurate processing in areas like transcript generation and statistical reporting.

Key Information Stored

The table stores the core relationship rule and its associated processing flags. The primary identifier is the system-generated PS_PRUN_REL_ID, which uniquely defines each relationship record. The rule itself is defined by the combination of STUDENT_CAREER_LEVEL (the program type level) and UNIT_TYPE_ID (the ID for the program type level of the unit). The STUDENT_CAREER_TRANSCRIPT and STUDENT_CAREER_STATISTICS columns are key business rule flags, typically holding 'Y' or 'N' values, that determine if units of the specified type should appear on the student's official transcript and be considered for statistical calculations, respectively. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information.

Common Use Cases and Queries

This table is central to configuration and validation processes. A common use case is during program enrollment or unit enrollment, where the system validates that a student attempting to enroll in a unit is permitted based on the relationship between their program type and the unit's type. Another key use is during batch processes for generating official transcripts and compiling institutional statistics, where the flags in this table determine data inclusion.

A typical query to retrieve all active relationships for reporting or validation would be:

  • SELECT prun.PS_PRUN_REL_ID, prun.STUDENT_CAREER_LEVEL, prun.UNIT_TYPE_ID, prun.STUDENT_CAREER_TRANSCRIPT, prun.STUDENT_CAREER_STATISTICS FROM IGS.IGS_PS_PRG_UNIT_REL prun ORDER BY prun.STUDENT_CAREER_LEVEL;

To check the configuration for a specific program type level, one would query:

  • SELECT * FROM IGS.IGS_PS_PRG_UNIT_REL WHERE STUDENT_CAREER_LEVEL = '&PROGRAM_LEVEL';

Related Objects

The IGS_PS_PRG_UNIT_REL table is integrated into the EBS data model through defined foreign key relationships. It references two key lookup or validation tables:

  • IGS_PS_TYPE_ALL: The STUDENT_CAREER_LEVEL column references this table to validate the program type level.
  • IGS_PS_UNIT_TYPE_LVL: The UNIT_TYPE_ID column references this table to validate the unit type level ID.

The table's primary key, PS_PRUN_REL_ID, is enforced by the unique index IGS_PS_PRG_UNIT_REL_U1. The unique combination of STUDENT_CAREER_LEVEL and UNIT_TYPE_ID is enforced by the IGS_PS_PRG_UNIT_REL_U2 index, preventing duplicate relationship rules. As a foundational configuration table, it is likely referenced by various program and unit enrollment APIs, forms, and concurrent processes within the IGS modules.