Search Results igs_as_appr_grd_sch




Overview
Explore in AI Chat

Overview

The IGS_AS_APPR_GRD_SCH table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a configuration and validation table that defines the approved relationships between academic units, assessment types, and grading schemas. Its primary role is to establish which grading schemas are permissible for specific assessment types within a given unit and version. This configuration enables the system to default the correct grading schema automatically when assessment items are linked to unit offerings and sections, ensuring consistency and adherence to academic rules during the assessment setup process.

Key Information Stored

The table's structure centers on defining a valid combination of key academic entities. Its composite primary key uniquely identifies each approved relationship through five columns: UNIT_CD and VERSION_NUMBER, which reference the specific academic unit; ASSESSMENT_TYPE, which defines the category of assessment; and GRADING_SCHEMA_CD with GS_VERSION_NUMBER, which together identify the specific grading schema approved for use. The table does not store transactional assessment data but rather the master list of allowed configurations. This design ensures referential integrity, as the foreign keys constrain the data to valid entries in the parent tables for units (IGS_PS_UNIT_VER_ALL), assessment types (IGS_AS_ASSESSMNT_TYP), and grading schemas (IGS_AS_GRD_SCHEMA).

Common Use Cases and Queries

A primary use case is the validation and defaulting of grading schemas during the creation of assessment items for a unit section. Administrators and academic staff rely on this table to ensure assessments are configured correctly. Common reporting and query scenarios include listing all approved grading schemas for a particular unit or validating a proposed assessment setup. Sample SQL patterns often involve joins to the related foreign key tables to retrieve descriptive names.

  • To find all approved grading schemas for a specific unit: SELECT * FROM igs_as_appr_grd_sch WHERE unit_cd = '&UNIT_CODE' AND version_number = &VERSION;
  • To list units configured to use a specific grading schema: SELECT unit_cd, version_number FROM igs_as_appr_grd_sch WHERE grading_schema_cd = '&SCHEMA_CODE';
  • For a detailed report joining to descriptive tables: SELECT uv.unit_cd, uv.version_number, at.assessment_type, gs.grading_schema_cd FROM igs_as_appr_grd_sch a JOIN igs_ps_unit_ver_all uv ON a.unit_cd = uv.unit_cd AND a.version_number = uv.version_number JOIN igs_as_assessmnt_typ at ON a.assessment_type = at.assessment_type JOIN igs_as_grd_schema gs ON a.grading_schema_cd = gs.grading_schema_cd AND a.gs_version_number = gs.version_number;

Related Objects

The IGS_AS_APPR_GRD_SCH table is centrally connected to several key master tables in the Student System via foreign key relationships, as documented in the ETRM. It depends directly on IGS_PS_UNIT_VER_ALL for valid unit definitions, on IGS_AS_ASSESSMNT_TYP for valid assessment type codes, and on IGS_AS_GRD_SCHEMA for valid grading schema definitions. While not explicitly listed in the provided metadata, this table is logically a parent to transactional assessment data. It likely feeds or is referenced by forms and APIs responsible for setting up unit section assessments (e.g., IGS_AS_SU_ATMPT_ITM), where the approved grading schema is defaulted and applied to individual student assessment items.