Search Results igs_as_unit_class_all




Overview
Explore in AI Chat

Overview

The table IGS_AS_UNIT_CLASS_ALL is a core reference table within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to define and store the valid classifications for academic units, which are used to map to a unit's mode of delivery or study. This mapping is critical for associating units with specific business rules related to assessment, fee calculation, and program structure. The table supports the multi-organization architecture standard in Oracle EBS, as indicated by the "_ALL" suffix and the presence of an ORG_ID column, allowing data to be partitioned by operating unit. It is important to note that, according to the provided metadata, this specific table was not implemented in the documented database instance, suggesting it may exist as a defined structure but without populated data in certain deployments.

Key Information Stored

While the full column list is not detailed in the excerpt, the structure and foreign key relationships imply several key attributes. The central column is UNIT_CLASS, which serves as the primary key and holds the unique code for a unit classification (e.g., codes representing "Lecture," "Laboratory," "Tutorial," or "Distance Learning"). The table almost certainly includes descriptive columns such as a name and description for the class. Critically, it contains an ORG_ID column to identify the operating unit, enabling the setup of institution-specific unit classes. Additional columns likely track system-controlled data like creation date, created by, last update date, and last updated by, which are standard in EBS tables.

Common Use Cases and Queries

This table is primarily referenced for validation and descriptive purposes in transactional processes. A common use case is validating the unit class assigned to a unit offering option or a fee trigger. For reporting, it is used to translate unit class codes into meaningful descriptions. Sample SQL patterns include joining to related transactional tables to generate lists of units by their classification or to analyze fee structures associated with different unit modes.

  • Retrieving all defined unit classes for a specific operating unit: SELECT unit_class, description FROM igs_as_unit_class_all WHERE org_id = :p_org_id ORDER BY unit_class;
  • Joining to unit offering options to list units by class: SELECT uoo.unit_code, uoo.version_number, uc.description FROM igs_ps_unit_ofr_opt_all uoo JOIN igs_as_unit_class_all uc ON uoo.unit_class = uc.unit_class AND uoo.org_id = uc.org_id;

Related Objects

The IGS_AS_UNIT_CLASS_ALL table is a key reference point for numerous other entities in the Student System, as evidenced by its extensive foreign key relationships. Key dependent tables include:

These relationships underscore the table's role in integrating academic structure with assessment and financial functionality.