Search Results igs_as_grd_schema

Overview

The IGS_AS_GRD_SCHEMA table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for grading schemas, which are structured sets of available marks, grades, and results used to assess student performance in unit attempts. A grading schema defines the permissible outcomes for an assessment, such as letter grades (A, B, C), numeric scores, or result statuses (Pass, Fail, Incomplete). The table's primary role is to provide a centralized, version-controlled repository for these assessment frameworks, ensuring consistency and integrity in academic evaluation across the institution's curriculum and offerings.

Key Information Stored

The table's structure is designed to uniquely identify and describe each grading schema. Its primary key is a composite of GRADING_SCHEMA_CD and VERSION_NUMBER, allowing for the management of multiple iterations of the same grading schema code over time. While the specific column list is not detailed in the provided metadata, based on its description and common patterns, the table typically stores critical attributes such as the schema's descriptive name, its effective dates, status (e.g., active, inactive), the grading basis (e.g., grade, mark, result), and control flags indicating if it is used for official assessment, incompletes, or appeals. The versioning mechanism is essential for maintaining historical accuracy and supporting changes to grading policies without affecting previously recorded assessments.

Common Use Cases and Queries

This table is fundamental to processes involving the setup, assignment, and application of grades. Common functional use cases include defining the grading rules for a new course or program, updating assessment criteria for a unit offering, and configuring the valid grades for an assessment item. From a reporting and query perspective, technical consultants often join this table to decode grading schema references stored in transactional tables. A typical SQL pattern retrieves the active grading schema definition for a specific code:

• SELECT * FROM igs.igs_as_grd_schema WHERE grading_schema_cd = 'LETTER_GRADE' AND version_number = (SELECT MAX(version_number) FROM igs.igs_as_grd_schema WHERE grading_schema_cd = 'LETTER_GRADE' AND status = 'ACTIVE');

Another frequent query involves listing all grading schemas assigned to a particular unit or course offering by joining with related tables like IGS_PS_UNIT_GRD_SCHM or IGS_PS_USEC_GRD_SCHM.

Related Objects

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

• IGS_AS_GRD_SCH_GRADE: Stores the individual grade values (e.g., A, B+, B) that belong to a specific grading schema.
• IGS_PS_UNIT_GRD_SCHM and IGS_PS_USEC_GRD_SCHM: Assign grading schemas at the unit and unit section (offering) levels, respectively.
• IGS_AS_UNITASS_ITEM_ALL and IGS_PS_UNITASS_ITEM: Link assessment items to a specific grading schema.
• IGS_AS_APPR_GRD_SCH and IGS_AS_INC_GRD_CPROF: Reference schemas used for grade appeals and incomplete grade processing.
• IGS_PS_AWD, IGS_PS_OFR_PAT, IGS_EN_PLAN_UNITS, and IGS_PS_UNIT_OFR_OPT_ALL: Associate grading schemas with broader academic structures like awards, patterns, and study plans.

These relationships underscore the table's critical role in integrating assessment rules across the academic lifecycle.