Search Results igs_ps_unit_type_lvl




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_TYPE_LVL table is a core reference table within the Oracle E-Business Suite Student System (IGS). It functions as a master data repository for defining and classifying the academic level of units within an institution's curriculum. Specifically, it stores the valid unit program type level codes and their descriptions, which are subsequently associated with individual academic units. This table provides a standardized classification mechanism that is critical for curriculum management, program structuring, and financial assessment processes. Its role is to ensure consistency in how units are categorized by level across the student lifecycle, from program enrollment to fee calculation.

Key Information Stored

The table's primary purpose is to maintain a controlled list of unit type levels. While the full column list is not detailed in the provided metadata, the structure is defined by its primary and unique keys. The UNIT_TYPE_ID column serves as the primary key, providing a unique numeric identifier for each record. The LEVEL_CODE column is defined as a unique key, holding the actual business code (e.g., 'UG' for Undergraduate, 'PG' for Postgraduate, 'RS' for Research) that is referenced throughout the application. A description column, implied by the documentation, would store the full name corresponding to each LEVEL_CODE. This simple but essential structure acts as a validation point for numerous transactional tables.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and as a source for descriptive flexfield value sets. Common operational scenarios include defining the permissible unit levels when creating or updating a unit version (IGS_PS_UNIT_VER_ALL) and establishing program-unit relationships (IGS_PS_PRG_UNIT_REL). In financial modules, it is referenced to determine applicable fee assessment rates and items based on a unit's level. A typical reporting query would join this table to unit or fee tables to produce lists categorized by unit level.

  • Sample Query: SELECT utl.level_code, utl.description, COUNT(u.unit_cd) FROM igs_ps_unit_ver_all u, igs_ps_unit_type_lvl utl WHERE u.unit_type_id = utl.unit_type_id GROUP BY utl.level_code, utl.description;
  • Use Case: Generating a summary report of all active units grouped by their academic level.

Related Objects

The IGS_PS_UNIT_TYPE_LVL table is a central reference point, as evidenced by its numerous foreign key relationships. The documented relationships show it is integral to both Program Structure (PS) and Financials (FI) modules. The following tables reference IGS_PS_UNIT_TYPE_LVL via the specified join columns:

  • IGS_PS_UNIT_VER_ALL.UNIT_TYPE_ID: Associates a unit version with its academic level.
  • IGS_PS_PRG_UNIT_REL.UNIT_TYPE_ID: Defines the level of a unit within the context of a specific program.
  • IGS_FI_FEE_AS_ITEMS.UNIT_TYPE_ID: Links fee assessment items to a specific unit level.
  • IGS_FI_FEE_AS_RATE.UNIT_TYPE_ID and IGS_FI_FEE_AS_RT_H_ALL.UNIT_TYPE_ID: Used to determine applicable fee assessment rates based on unit level.
  • IGS_FI_FTCI_ACCTS.UNIT_TYPE_ID and IGS_FI_INVLN_INT_ALL.UNIT_TYPE_ID: Referenced in financial transaction and invoicing interfaces.
  • IGS_FI_ER_ORD_DTLS.ORDER_ATTR_VALUE: References the LEVEL_CODE (not UNIT_TYPE_ID) for eCommerce order attribute validation.