Search Results igs_as_grd_sch_grade




Overview
Explore in AI Chat

Overview

The IGS_AS_GRD_SCH_GRADE table is a core data structure within the Oracle E-Business Suite Student System (IGS) in releases 12.1.1 and 12.2.2. It functions as the master definition table for individual grades that exist within a grading schema. A grading schema is a structured set of possible grades (e.g., A, B, C, D, F, Pass, Fail) used for assessing student performance. This table stores the specific characteristics and metadata for each grade code, linking it to its parent grading schema and version. Its primary role is to serve as a reference and validation point for grade-related transactions across the academic suite, ensuring data integrity and consistency in assessment recording, award processing, and academic standing.

Key Information Stored

The table's structure is centered on uniquely identifying a grade within the context of its specific grading schema version. The primary key is a composite of three columns: GRADING_SCHEMA_CD, VERSION_NUMBER, and GRADE. This design enforces that a grade code (GRADE) is uniquely defined per schema version. While the provided metadata focuses on keys, typical columns in such a table would include descriptive attributes for the grade. These often encompass a DESCRIPTION, an INDICATOR for whether the grade is a passing or failing mark (e.g., PASS_IND), a NUMERIC equivalent or value for calculations (GRADE_VALUE), an ORDER sequence for ranking grades, and flags controlling usage (e.g., IN_USE_IND). The table's foreign key relationship to IGS_AS_GRD_SCHEMA validates that every grade record belongs to a defined parent schema.

Common Use Cases and Queries

This table is central to numerous academic operations. Common use cases include the setup and maintenance of grading schemas, the validation of grades entered for student assessments, and the processing of academic awards. For reporting and data extraction, typical SQL patterns involve joining this table to various transactional tables. A fundamental query retrieves all grades for a specific schema:

  • SELECT grade, description, pass_ind, grade_value FROM igs_as_grd_sch_grade WHERE grading_schema_cd = 'UG' AND version_number = 1 ORDER BY grade_order;

Another critical pattern is joining to student assessment records to generate grade reports or calculate Grade Point Averages (GPA), leveraging the numeric GRADE_VALUE:

  • SELECT s.student_id, g.grade, g.description, g.grade_value FROM igs_as_su_atmpt_itm s, igs_as_grd_sch_grade g WHERE s.grading_schema_cd = g.grading_schema_cd AND s.gs_version_number = g.version_number AND s.grade = g.grade;

Related Objects

The extensive foreign key relationships documented highlight the table's integral role. Key related objects include: