Search Results grading_schema_description




Overview
Explore in AI Chat

Overview

IGSBV_USEC_GRADING_SCHEMAS is a read-only Oracle EBS view owned by the APPS schema within the Oracle Student System (formerly Student Records / ETRM) product family. It presents the association between unit sections offered within the institution and the grading schemas that govern how student results are recorded and assessed against those sections. The view consolidates three sources: the unit-section-to-grading-schema assignment, the grading schema definition itself, and the unit offering option details. This produces a denormalized, human-readable record that pairs the technical grading schema code and version with its descriptive text, alongside the unit's identifying attributes.

The view carries a WITH READ ONLY clause, meaning it is intended strictly for query and reporting purposes. No inserts, updates, or deletions are permitted against it. In Oracle EBS 12.1.1 and 12.2.2 environments, such views are typically exposed for reporting layers, integration extracts, and Oracle Application Framework (OAF) pages that need to resolve a grading schema description without directly navigating the underlying normalized relationships. The column GRADING_SCHEMA_DESCRIPTION is especially significant, as it is the attribute commonly sought when users or interfaces need the human-readable label for a grading schema rather than its internal code.

Underlying Base Objects

The view is defined over three documented base objects:

  • IGS_PS_USEC_GRD_SCHM (alias US) — the unit section grading schema assignment table. This is the driving table, holding the association between a unit offering option (UOO_ID) and a grading schema code with version.
  • IGS_AS_GRD_SCHEMA (alias GR) — the grading schema master, supplying the authoritative description and version details.
  • IGS_PS_UNIT_OFR_OPT_ALL (alias UN) — the unit offering option view/table, supplying unit code, version, calendar type, location, and unit class information.

The joins are equi-joins. The assignment table links to the grading schema master on both GRADING_SCHEMA_CODE = GR.GRADING_SCHEMA_CD and GRD_SCHM_VERSION_NUMBER = GR.VERSION_NUMBER, ensuring version-accurate resolution. The assignment table links to the unit offering option on US.UOO_ID = UN.UOO_ID. Because the ETRM metadata documents no additional referenced base objects, the view's grain is one row per unit section grading schema assignment, enriched with schema description and unit attributes.

Key Columns

Common Use Cases and Queries

Typical usage includes resolving the description of the grading schema applied to a given unit section, auditing default schema assignments per unit, and feeding reporting or integration extracts.

SELECT unit_cd, version_number, grading_schema_code,
       grading_schema_description, default_grad_schema_indicator
FROM   apps.igsbv_usec_grading_schemas
WHERE  unit_cd = :unit_code;

SELECT unit_cd, grading_schema_code, grading_schema_description
FROM   apps.igsbv_usec_grading_schemas
WHERE  default_grad_schema_indicator = 'Y';

Because the view is read-only and pre-joins the schema description, it removes the need for callers to resolve GRADING_SCHEMA_CD and VERSION_NUMBER against the grading schema master manually, simplifying queries that surface the grading_schema_description.