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.

  • Table: IGS_PS_PRG_UNIT_REL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_PRG_UNIT_REL,  object_name:IGS_PS_PRG_UNIT_REL,  status:VALID,  product: IGS - Student System ,  description: This table will store the relationship between Program type and unit type levels ,  implementation_dba_data: IGS.IGS_PS_PRG_UNIT_REL , 

  • View: IGS_PS_PRG_UNIT_REL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_PRG_UNIT_REL_V,  object_name:IGS_PS_PRG_UNIT_REL_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_PS_PRG_UNIT_REL_V , 

  • Table: IGS_PS_UNIT_TYPE_LVL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_TYPE_LVL,  object_name:IGS_PS_UNIT_TYPE_LVL,  status:VALID,  product: IGS - Student System ,  description: This table stores the unit program type level code and description. These would be associated with units. ,  implementation_dba_data: IGS.IGS_PS_UNIT_TYPE_LVL , 

  • View: IGS_PR_ACAD_UNIT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_ACAD_UNIT_V,  object_name:IGS_PR_ACAD_UNIT_V,  status:VALID,  product: IGS - Student System ,  description: This view contains Student Unit Attempt details with statistics and grades. ,  implementation_dba_data: APPS.IGS_PR_ACAD_UNIT_V , 

  • Table: IGS_PS_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_TYPE_ALL,  object_name:IGS_PS_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values. ,  implementation_dba_data: IGS.IGS_PS_TYPE_ALL , 

  • View: IGS_DA_XML_COURSEINSTITUTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_COURSEINSTITUTION_V,  object_name:IGS_DA_XML_COURSEINSTITUTION_V,  status:VALID,  product: IGS - Student System ,  description: XML element CourseInstitutionTypeProvides the Unit"s Institution code based on the batch_id, person_id and local_institution_cd. ,  implementation_dba_data: APPS.IGS_DA_XML_COURSEINSTITUTION_V , 

  • View: IGS_PR_ACAD_LOAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_ACAD_LOAD_V,  object_name:IGS_PR_ACAD_LOAD_V,  status:VALID,  product: IGS - Student System ,  description: This view contains the details of a Student Program Attempt within a Load Calendar with cumulative and period statistics. ,  implementation_dba_data: APPS.IGS_PR_ACAD_LOAD_V , 

  • View: IGS_DA_XML_COURSE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_COURSE_V,  object_name:IGS_DA_XML_COURSE_V,  status:VALID,  product: IGS - Student System ,  description: XML element CourseType (child of CourseInstitution)1)(SUA) Student Unit Attempt"s at local Institution. Includes Units local institution Units and currently enrolled units.Enrolled units can be excluded EIP Control feature code.2) (AV) Adv ,  implementation_dba_data: APPS.IGS_DA_XML_COURSE_V ,