Search Results igs_ps_unit_level_all




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_LEVEL_ALL table is a core reference entity within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for defining the academic levels associated with units of study offered by an institution. In the context of higher education administration, a unit level is a classification that indicates the academic rigor and typical stage of a student's program, such as "Undergraduate," "Postgraduate," "Doctoral," or custom institutional levels. This table is critical for enforcing academic and business rules across the student lifecycle, including curriculum definition, fee assessment, progression tracking, and award management. Its multi-org structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units within a single installation.

Key Information Stored

While the provided metadata does not list specific columns, the primary key is documented as UNIT_LEVEL. Based on its function as a reference entity, the table typically contains columns to define and describe each academic level. Common columns in such a structure would include UNIT_LEVEL (the unique code), a DESCRIPTION, an optional SYSTEM_DEFAULT indicator, and columns controlling data lifecycle like START_DATE, END_DATE, and CREATION_DATE. The table's primary purpose is to maintain a controlled list of valid unit levels that are referenced by numerous transactional and configuration tables throughout the Student System and integrated financial modules.

Common Use Cases and Queries

This table is primarily used in validation, reporting, and as a lookup source. Administrators use it to maintain the list of active academic levels. Common reporting scenarios include listing all configured unit levels or analyzing unit offerings by level. In technical implementations, it is frequently joined to transactional data. A typical query pattern involves joining to the unit version table to retrieve all units at a specific level:

  • SELECT uv.unit_code, uv.version_number, ul.unit_level, ul.description FROM igs_ps_unit_ver_all uv, igs_ps_unit_level_all ul WHERE uv.unit_level = ul.unit_level AND ul.unit_level = 'POSTGRAD';

Another critical use case is in fee configuration, where fee schedules and rates are often defined based on the student's unit level.

Related Objects

The IGS_PS_UNIT_LEVEL_ALL table is a central reference point with extensive foreign key relationships across the Student System and Financial modules, as documented in the metadata. Key related objects include: