Search Results unit_type_id




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_TYPE_LVL table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules under the IGS schema. It functions as a master data repository for defining and managing the academic hierarchy levels associated with unit types. A unit type typically categorizes a course or subject (e.g., lecture, lab, tutorial), and this table defines the permissible academic levels (e.g., Undergraduate, Postgraduate, Doctoral) to which those unit types can be assigned. This ensures data integrity and enforces valid combinations when structuring academic programs and their constituent units within the system.

Key Information Stored

The table's structure is designed to maintain a controlled list of level codes with descriptive context and lifecycle status. The primary and critical columns are:

  • UNIT_TYPE_ID (NUMBER): The system-generated primary key (PK), uniquely identifying each record. It is populated by the sequence IGS_PS_UNIT_TYPE_LVL_S.
  • LEVEL_CODE (VARCHAR2(10)): A unique, user-defined code representing the academic level (e.g., 'UG', 'PG'). This column is enforced by a unique index (IGS_PS_UNIT_TYPE_LVL_U2).
  • DESCRIPTION (VARCHAR2(80)): The full textual description of the level code for reporting and user interfaces.
  • CLOSED_IND (VARCHAR2(1)): A flag indicating the record's active status. A value signifying 'Y' typically means the level code is closed for future association with new units, while 'N' indicates it is available for use.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

Common Use Cases and Queries

This table is primarily referenced in setups and validation routines. A common use case is during the configuration of an academic unit or program, where the system validates that the selected unit type is permissible for the intended academic level. For reporting and administration, queries often retrieve the active list of levels or check associations. A fundamental query to retrieve all active level codes is: 

SELECT UNIT_TYPE_ID, LEVEL_CODE, DESCRIPTION
FROM IGS.IGS_PS_UNIT_TYPE_LVL
WHERE CLOSED_IND = 'N'
ORDER BY LEVEL_CODE;
Another critical pattern involves joining this table to other unit-related entities using the UNIT_TYPE_ID or LEVEL_CODE to generate master-detail reports on program structures. Troubleshooting or data validation scripts may also query this table to identify invalid or orphaned references in transactional data.

Related Objects

Based on the provided dependency information, the IGS_PS_UNIT_TYPE_LVL table is referenced by other objects within the APPS context. While specific foreign key relationships are not enumerated in the excerpt, the presence of a unique index on UNIT_TYPE_ID (IGS_PS_UNIT_TYPE_LVL_U1) strongly suggests it is the parent table in a relationship. It is logically a reference point for transactional tables that store unit definitions, program requirements, or enrollment rules, where a UNIT_TYPE_ID foreign key would ensure that only valid, predefined unit type levels are used. The dependency list indicates that "APPS.IGS_PS_UNIT_TYPE_LVL" references this base table, which is likely a public synonym or a view built upon IGS.IGS_PS_UNIT_TYPE_LVL for application use.