Search Results igsfv_usec_grading_schemas

Overview

The IGSFV_USEC_GRADING_SCHEMAS view resides in the APPS schema of Oracle E-Business Suite and belongs to the IGS (Student System) product family, part of the Oracle Student System / Higher Education suite. As its name indicates, this is the full view describing the grading schemas that are associated with unit sections. A grading schema defines the structure and rules by which students' academic performance in a unit offering is assessed and recorded (for example, letter-grade versus numeric schemas).

The view's role is primarily reporting, inquiry, and integration. Rather than exposing the raw foreign keys held on the transactional grading-schema assignment table, the view joins across three base objects to resolve the human-readable GRADING_SCHEMA_DESCRIPTION, the unit code, version, calendar type, location, and unit class. Because it is declared WITH READ ONLY, it cannot be used for DML; it is intended strictly as a query surface for forms, reports, concurrent programs, and external integrations that require a denormalized picture of unit-section grading configuration.

The object carries a VALID status and is registered against the documented ETRM metadata for both the 12.1.1 and 12.2.2 releases, confirming continuity of the interface across those versions.

Underlying Base Objects

The ETRM metadata lists no formally "referenced base objects" for the documented layer, but the view definition itself establishes the lineage through an inner join of three APPS tables:

• IGS_PS_USEC_GRD_SCHM (aliased US) — the unit-section grading schema assignment table. This is the driving entity that maps a unit-section offering option (UOO) to a grading schema code and version, and carries the default indicator and audit columns.
• IGS_AS_GRD_SCHEMA (aliased GR) — the grading schema definition table, supplying the descriptive text via DESCRIPTION. The join is on GRADING_SCHEMA_CODE = GR.GRADING_SCHEMA_CD plus matching version number.
• IGS_PS_UNIT_OFR_OPT_ALL (aliased UN) — the unit offering option "all" view, providing the unit code, version, calendar type, calendar instance sequence, location, and unit class. The join is on US.UOO_ID = UN.UOO_ID.

The joins are equijoins with no outer-join keywords, so a row is returned only where a valid grading schema assignment exists with a matching schema definition and unit offering option.

Key Columns

• UNIT_SECTION_GRADING_SCHEMA_ID — surrogate primary identifier for the assignment record.
• UNIT_SECTION_ID — exposes US.UOO_ID, identifying the unit offering option (unit section) to which the schema applies.
• GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER — the grading schema key and its version, together resolving the definition.
• DEFAULT_GRAD_SCHEMA_INDICATOR — the DEFAULT_FLAG; flags whether this is the default grading schema for the unit section.
• GRADING_SCHEMA_DESCRIPTION — the resolved descriptive text; this is the column most commonly sought when users search for grading_schema_description.
• UNIT_CODE, VERSION_NUMBER, CALENDAR_TYPE, CAL_INST_SEQUENCE_NUMBER, LOCATION_CODE, UNIT_CLASS — the descriptive unit-offering context.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — standard audit columns inherited from the assignment table.

Common Use Cases and Queries

Typical usage includes validating which grading schema is attached to a unit section, listing all default grading schemas for a calendar instance, and joining to enrollment or assessment data for grade-scheme-aware reporting. Example queries:

• List grading schemas for a unit: SELECT unit_code, version_number, grading_schema_code, grading_schema_description, default_grad_schema_indicator FROM igsfv_usec_grading_schemas WHERE unit_code = :p_unit;
• Find defaults within a calendar: SELECT * FROM igsfv_usec_grading_schemas WHERE calendar_type = :p_cal_type AND default_grad_schema_indicator = 'Y';
• Search by description: SELECT unit_code, grading_schema_description FROM igsfv_usec_grading_schemas WHERE UPPER(grading_schema_description) LIKE '%GRADE%';

All queries are read-only by definition.