Search Results igs_ps_unit_lvl_all




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_LVL_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS). It serves a critical function in academic program management by defining the specific academic level of a unit (or subject) within the context of a particular program type. This table allows for granular control over unit classification, as the level defined here overrides any default level assigned directly to the unit itself. Its role is to ensure that the same unit can be correctly categorized at different academic levels (e.g., undergraduate, postgraduate) depending on the type of program in which it is offered, thereby supporting complex curriculum structures and accurate academic reporting.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a unit-level assignment for a program type. The key columns are UNIT_CD and VERSION_NUMBER, which identify the specific unit version, paired with COURSE_CD and COURSE_VERSION_NUMBER, which identify the specific program version. A critical attribute is the UNIT_LEVEL column, which stores the overriding academic level code for the unit within the specified program context. The table also includes a COURSE_TYPE column, which links to the program type (e.g., Bachelor, Master) for which this level override is applicable. This design ensures that level mappings are precise to both a specific unit version and a specific program version.

Common Use Cases and Queries

A primary use case is academic auditing and compliance reporting, where institutions must demonstrate that units are taught at the appropriate level for a given qualification type. For instance, a "Research Methods" unit might be considered a 400-level unit in a Bachelor's program but a 500-level unit in a Master's program. This table enables that distinction. A common query would retrieve the effective unit level for all units within a specific program version, joining to the unit and program version tables for descriptive information.

SELECT uv.unit_cd,
       uv.title,
       ul.unit_level,
       cv.course_cd,
       cv.version_number
FROM igs_ps_unit_lvl_all ul,
     igs_ps_unit_ver_all uv,
     igs_ps_ver_all cv
WHERE ul.unit_cd = uv.unit_cd
  AND ul.version_number = uv.version_number
  AND ul.course_cd = cv.course_cd
  AND ul.course_version_number = cv.course_version_number
  AND cv.course_cd = 'BSC_COMPSCI';

Another key scenario is during enrollment and progression checking, where a student's academic level is compared against the level of units they are attempting to enroll in, using this table as the authoritative source for the unit's level within their program.

Related Objects

The IGS_PS_UNIT_LVL_ALL table maintains integral relationships with several other foundational tables in the Student System, as documented by its foreign key constraints:

  • IGS_PS_TYPE_ALL: Joined via the COURSE_TYPE column. This links the unit level override to a specific program type (e.g., Certificate, Diploma).
  • IGS_PS_VER_ALL: Joined via the COURSE_CD and COURSE_VERSION_NUMBER columns. This establishes the relationship to the specific academic program version.
  • IGS_PS_UNIT_LEVEL_ALL: Joined via the UNIT_LEVEL column. This provides validation and descriptive details for the academic level code.
  • IGS_PS_UNIT_VER_ALL: Joined via the UNIT_CD and VERSION_NUMBER columns. This links to the master definition of the unit version, containing its default attributes.

These relationships position IGS_PS_UNIT_LVL_ALL as a central junction table that connects program structures, unit definitions, and academic level classifications.