Search Results igs_ps_unit_int_lvl




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_INT_LVL table is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to support the WEFTSU (Weighted Equivalent Full-Time Student Unit) reporting framework by categorizing academic units in relation to the program level of study. This grouping is essential for governmental and institutional reporting, where student load and funding calculations are often broken down by the level of the program (e.g., undergraduate, postgraduate). Notably, the provided ETRM metadata explicitly classifies the IGS module as "Obsolete," indicating this table is part of a legacy system footprint. Furthermore, the documentation states it is "Not implemented in this database," which typically means the table structure exists in the application's data dictionary but is not populated or actively used in a standard implementation, often superseded by later functionality.

Key Information Stored

Based on the provided metadata, the table's central data point is a code representing the intersection of a unit and a course level. The primary key is a single column: UNIT_INT_COURSE_LEVEL_CD. This column acts as a unique identifier for a specific grouping, such as "UNDERGRAD_CORE" or "POSTGRAD_RESEARCH." The table's description suggests it holds the master list of these valid grouping codes, which are then referenced by other transactional tables to classify individual unit versions. No other columns are detailed in the excerpt, implying this is a simple reference or lookup table.

Common Use Cases and Queries

In an active implementation, this table would serve as the authoritative source for valid unit-level intersection codes. Common use cases would include validating data entry in unit maintenance forms and generating WEFTSU reports aggregated by program level. A typical query would involve joining this table to unit version data to analyze the distribution of units across different levels. For example, a report to list all units classified at a particular level might use a SQL pattern such as: SELECT uv.unit_cd, uv.version_number FROM igs_ps_unit_ver_all uv INNER JOIN igs_ps_unit_int_lvl ul ON uv.unit_int_course_level_cd = ul.unit_int_course_level_cd WHERE ul.unit_int_course_level_cd = '&LEVEL_CODE';. However, given the "Obsolete" and "Not implemented" status, direct operational use in EBS 12.1.1 or 12.2.2 is highly unlikely.

Related Objects

The table maintains defined foreign key relationships with two other tables, as per the provided metadata:

  • IGS_PS_UNIT_VER_ALL: This is the primary related table. The foreign key from IGS_PS_UNIT_VER_ALL.UNIT_INT_COURSE_LEVEL_CD references the primary key of IGS_PS_UNIT_INT_LVL. This links each version of a unit to its designated program level grouping for WEFTSU calculations.
  • IGS_AD_SBMAO_FN_UITT: This table, which appears to be related to admissions or financial data, also references the intersection level code via its UNIT_INT_COURSE_LEVEL_CD column, indicating the grouping was used in broader functional processes.
These relationships confirm the table's role as a parent reference table for the UNIT_INT_COURSE_LEVEL_CD code.