Search Results igs_ps_unit_grd_schm




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_GRD_SCHM table is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its primary function is to establish and manage the formal relationship between academic units (courses or subjects) and the grading schemas used to assess student performance within those units. This table acts as a critical junction, ensuring that for any given unit version, the correct and approved grading scale is applied consistently across the institution's academic processes. The metadata explicitly notes this table is "Not implemented in this database," indicating it may have been a design artifact in a specific release or its functionality was superseded in later implementations of Oracle EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure is designed to link unit and grading schema master data through foreign key relationships. The primary identifier is the system-generated UNIT_GRADING_SCHEMA_ID. The most significant columns are the foreign keys that define the relationships: UNIT_CODE and UNIT_VERSION_NUMBER, which reference a specific version of an academic unit from the IGS_PS_UNIT_VER_ALL table; and GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER, which reference a specific version of a grading schema from the IGS_AS_GRD_SCHEMA table. This version-aware design allows institutions to manage changes to both units and grading schemas over time while maintaining historical accuracy.

Common Use Cases and Queries

The primary use case is to retrieve the applicable grading schema for a student's enrollment in a specific unit version, which is essential for calculating grades, academic standing, and generating transcripts. A typical query would join the unit offering or enrollment records to this table to fetch the correct grading scale. For reporting, this table enables analysis of which grading schemas are applied across the unit catalog. A sample SQL pattern to find all grading schemas linked to a unit would be:

  • SELECT ugs.unit_code, ugs.unit_version_number, ugs.grading_schema_code, ugs.grd_schm_version_number, gs.description FROM igs_ps_unit_grd_schm ugs JOIN igs_as_grd_schema gs ON ugs.grading_schema_code = gs.grading_schema_code AND ugs.grd_schm_version_number = gs.version_number WHERE ugs.unit_code = :p_unit_code;

Related Objects

The table's integrity is defined by its relationships with two key master tables, as documented in the provided foreign key metadata.

  • IGS_AS_GRD_SCHEMA: This table stores the master definitions of grading schemas (e.g., A-F, Pass/Fail, numeric scales). IGS_PS_UNIT_GRD_SCHM links to it via the columns GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER.
  • IGS_PS_UNIT_VER_ALL: This table contains all versions of academic units. IGS_PS_UNIT_GRD_SCHM links to it via the columns UNIT_CODE and UNIT_VERSION_NUMBER.

The primary key constraint IGS_PS_UNIT_GRD_SCHM_PK on UNIT_GRADING_SCHEMA_ID ensures each relationship record is uniquely identifiable.