Search Results igs_as_chn_grd_req

Overview

The table IGS_AS_CHN_GRD_REQ is a core data object within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as a historical audit and transaction log for formal grade change requests submitted for a student's unit (subject) attempts. Its primary role is to persistently record the details of a request to alter a student's grade, capturing both the original and proposed new grade information, the requester, and the request's status. This table is essential for maintaining academic integrity, providing an audit trail for grade modifications, and supporting workflow processes related to academic assessment within the institution.

Key Information Stored

The table's composite primary key uniquely identifies each request by combining the student identifier (PERSON_ID), the course code (COURSE_CD), the unit offering identifier (UOO_ID), and the timestamp of the request (REQUEST_DATE). Key columns include the original grade details (CURRENT_GRADING_SCHEMA_CD, CURRENT_GS_VERSION_NUMBER, CURRENT_GRADE) and the requested new grade details (CHANGE_GRADING_SCHEMA_CD, CHANGE_GS_VERSION_NUMBER, CHANGE_GRADE). Additional columns, inferred from standard practice, would typically store the request's status (e.g., Pending, Approved, Rejected), the reason for the change, the identifier of the person who made the request, and relevant approval dates and comments.

Common Use Cases and Queries

A primary use case is generating audit reports for academic committees, detailing all grade change requests within a specific period. Another is supporting operational queries to view pending requests for a faculty member's approval. Common SQL patterns include joining to student and unit attempt tables for comprehensive reporting.

• Audit Report for a Course: SELECT * FROM igs_as_chn_grd_req req, igs_en_su_attempt_all sua WHERE req.person_id = sua.person_id AND req.course_cd = sua.course_cd AND req.uoo_id = sua.uoo_id AND sua.course_cd = '&course_code';
• Pending Requests: SELECT person_id, course_cd, current_grade, change_grade, request_date FROM igs_as_chn_grd_req WHERE status = 'PENDING' ORDER BY request_date;
• Grade Change History for a Student: SELECT * FROM igs_as_chn_grd_req WHERE person_id = &student_id ORDER BY request_date DESC;

Related Objects

IGS_AS_CHN_GRD_REQ maintains critical referential integrity through foreign key relationships with other core Student System tables, as documented in the ETRM.

• IGS_EN_SU_ATTEMPT_ALL: The table links to the student's unit attempt record via the foreign key on columns PERSON_ID, COURSE_CD, and UOO_ID. This ensures every grade change request is associated with a valid student enrollment attempt.
• IGS_AS_GRD_SCH_GRADE (Two Relationships): The table references the grading schema grade table twice. First, to validate the original grade (via CURRENT_GRADING_SCHEMA_CD, CURRENT_GS_VERSION_NUMBER, CURRENT_GRADE). Second, to validate the requested new grade (via CHANGE_GRADING_SCHEMA_CD, CHANGE_GS_VERSION_NUMBER, CHANGE_GRADE). This ensures both grades are valid within the institution's defined grading schemes.