Results for “grading_schema_code”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_USEC_GRD_SCHM is a transactional entity within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to capture the grading schemas that are associated with individual unit sections. In the academic structure of Oracle Student System, a unit offering option represents a deliverable instance of a unit, and a grading schema defines how students within that offering are assessed and graded. This table therefore acts as the associative bridge that records which grading schema, and which version of that schema, applies to a given unit section offering.

From a data modeling perspective, the mined relationship structure suggests this object behaves as a link table. It resolves a many-to-many style association between unit offering options and grading schemas, carrying descriptive attributes — most notably the default indicator — that qualify the relationship rather than describe either parent entity in isolation. Analysts designing an integration or warehouse layer should treat IGS_PS_USEC_GRD_SCHM as an association entity, with its own primary key and two foreign key branches.

Key Information Stored

The table is owned by the IGS schema and, in the documented 12.1.1 physical schema, contains ten columns. The most significant are summarized below.

Two unique indexes define the business keys. IGS_PS_USEC_GRD_SCHM_U1 covers UNIT_SECTION_GRADING_SCHEMA_ID, while IGS_PS_USEC_GRD_SCHM_U2 spans the composite of UOO_ID, GRADING_SCHEMA_CODE, and GRD_SCHM_VERSION_NUMBER — this composite is the true natural key, guaranteeing that a unit offering option cannot reference the same schema version twice.

Common Use Cases and Queries

Typical reporting scenarios include determining which grading schema is active for a unit section, and auditing where a particular grading schema version has been deployed. The join to the unit offering option table is the standard entry point:

  • Resolving the grading schema for a section: select g.GRADING_SCHEMA_CODE, g.GRD_SCHM_VERSION_NUMBER, g.DEFAULT_FLAG from IGS_PS_USEC_GRD_SCHM g where g.UOO_ID = :uooid.
  • Identifying the default schema only: add the predicate DEFAULT_FLAG = 'Y' to the previous query.
  • Reverse impact analysis for a schema version: filter on GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER and join back to IGS_AS_GRD_SCHEMA to retrieve schema definitions.
  • Regression queries: compare CREATION_DATE and LAST_UPDATE_DATE ranges to detect recently added or modified associations at a campus or term level.

Because the table is narrow and key-driven, these queries are efficient when driven through the unique indexes, particularly U2 for point lookups by unit offering option.

Related Objects

The most significant related objects derive from the documented foreign keys and primary key relationships.

  • IGS_AS_GRD_SCHEMA — parent table for grading schema definitions, joined on GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER.
  • IGS_PS_UNIT_OFR_OPT_ALL — parent table for unit offering options, joined on UOO_ID.
  • IGS_PS_USEC_GRD_SCHM_PK — primary key constraint on UNIT_SECTION_GRADING_SCHEMA_ID.
  • IGS_PS_USEC_GRD_SCHM_U1 and IGS_PS_USEC_GRD_SCHM_U2 — unique indexes enforcing surrogate and composite business keys respectively.

Downstream, assessment and grading interfaces within the IGS module consume these associations when resolving how a student's result should be recorded for a given unit section.