Search Results igs_as_grd_sch_grade

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:

• IGS_AS_GRD_SCHEMA: The parent table defining the overall grading schema to which grades belong.
• IGS_AS_SU_ATMPT_ITM: A primary transactional table storing grades awarded for student unit assessment items.
• IGS_AV_STND_UNIT_ALL: Used in academic standing calculations, referencing allowed grades.
• IGS_EN_SPA_AWD_AIM and IGS_EN_SPAA_HIST: Reference grades for student award aims and award history.
• IGS_AS_INS_GRD_ENTRY and IGS_AS_INC_GRD_CPROF: Support functions for instructor grade entry and incomplete grade processing.
• IGS_AS_CHN_GRD_REQ: Manages grade change requirements, referencing both current and target grades from this table.