Search Results igs_ps_usec_grd_schm




Overview
Explore in AI Chat

Overview

The table IGS_PS_USEC_GRD_SCHM is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Student System) product family. Its primary function is to establish and manage the relationship between a specific unit section (a scheduled offering of a unit or course) and the grading schema applicable to it. This table is critical for academic administration, as it ensures that the correct grading rules, scales, and versioned definitions are applied when assessing student performance for a particular class or section. By linking a unit section to a formal grading schema, the system enforces consistent grading policies across the institution.

Key Information Stored

The table stores the essential foreign key references that define the relationship. The primary key is a surrogate identifier, UNIT_SECTION_GRADING_SCHEMA_ID. The most significant columns are the foreign keys: UOO_ID, which links to the specific unit offering option (section) in the IGS_PS_UNIT_OFR_OPT_ALL table, and the composite foreign key consisting of GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER. This composite key references a specific version of a grading schema defined in the IGS_AS_GRD_SCHEMA table, thereby capturing the exact set of grades (e.g., A, B, C, Pass/Fail) and their associated numeric values, grade points, and precedence that are valid for that section.

Common Use Cases and Queries

A primary use case is the academic setup and validation process when scheduling classes. Administrators assign a grading schema to a section, which the system then uses to validate all grade entries for students enrolled in that section. For reporting, this table is central to queries that analyze grading patterns across different sections or ensure compliance with grading policy versions. A common SQL pattern retrieves the grading schema details for all sections of a given unit.

SELECT usgs.uoo_id,
       usgs.grading_schema_code,
       usgs.grd_schm_version_number,
       gs.description
FROM igs.igs_ps_usec_grd_schm usgs
JOIN igs.igs_as_grd_schema gs
  ON usgs.grading_schema_code = gs.grading_schema_code
 AND usgs.grd_schm_version_number = gs.version_number
WHERE usgs.uoo_id IN (SELECT uoo_id
                       FROM igs.igs_ps_unit_ofr_opt_all
                       WHERE unit_code = 'MATH101');

Related Objects

The IGS_PS_USEC_GRD_SCHM table is a junction entity with defined foreign key relationships to two principal tables:

  • IGS_AS_GRD_SCHEMA: This relationship (via GRADING_SCHEMA_CODE and GRD_SCHM_VERSION_NUMBER) ties the unit section to the master definition of a grading schema, including all its configured grades and rules.
  • IGS_PS_UNIT_OFR_OPT_ALL: This relationship (via UOO_ID) connects the grading schema assignment to the specific scheduled unit section, which contains details like location, instructor, and schedule.

The table's primary key, UNIT_SECTION_GRADING_SCHEMA_ID, is likely referenced by other transactional entities in the student system, such as those handling individual student grade entries or assessment components, to maintain data integrity.