Search Results mark_capped_flag




Overview
Explore in AI Chat

Overview

IGS_AS_CHN_GRD_REQ is a Student System (IGS) table in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that stores the change grade request history of a student. It captures the audit trail of requests to modify a previously awarded grade, recording both the incumbent grade value and the proposed replacement, along with the requestor, approver, timestamps, and status. The table belongs to the obsolete IGS product line, and the ETRM documentation notes that it is "Not implemented in this database," meaning the object is documented for reference but is not physically deployed in the standard shipped schema.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link. Its composite primary key of PERSON_ID, COURSE_CD, UOO_ID, and REQUEST_DATE ties a student, a course attempt, and a unit offering occurrence to a point in time, which is characteristic of a relationship (link) entity rather than a hub or a pure satellite. The multiple grading-schema references reinforce this associative role.

Key Information Stored

The table carries 32 documented columns. The most operationally significant are:

The documented unique index IGS_AS_CHN_GRD_REQ_PK (PERSON_ID, COURSE_CD, UOO_ID, REQUEST_DATE) is the business-key candidate, while the surrogate identity is the same composite in this design. There is no separate system-generated single-column surrogate documented.

Common Use Cases and Queries

Typical reporting scenarios include auditing grade amendments, tracking approval turnaround times, and reproducing the state of a grade before a change. A representative query lists pending requests for an approver:

  • SELECT person_id, course_cd, uoo_id, request_date, current_grade, change_grade, current_status FROM igs_as_chn_grd_req WHERE approver_id = :p_approver AND current_status = 'PENDING';
  • Joining to the grading schema to resolve grade descriptions: ... JOIN igs_as_grd_sch_grade g ON g.grading_schema_cd = r.change_grading_schema_cd;
  • Historic audit per attempt: filter on PERSON_ID, COURSE_CD, and UOO_ID and order by REQUEST_DATE descending.

Because the table is marked obsolete and not implemented in the standard database, these patterns apply primarily where a legacy IGS installation has retained the object.

Related Objects

The following objects are most significant, drawn from the documented foreign keys:

  • IGS_AS_GRD_SCH_GRADE — referenced twice, via CURRENT_GRADING_SCHEMA_CD/CURRENT_GS_VERSION_NUMBER/CURRENT_GRADE and CHANGE_GRADING_SCHEMA_CD/CHANGE_GS_VERSION_NUMBER/CHANGE_GRADE.
  • IGS_EN_SU_ATTEMPT_ALL — referenced via PERSON_ID, COURSE_CD, and UOO_ID, tying the request to the student unit attempt.
  • IGS_AS_CHN_GRD_REQ_PK — the primary-key constraint defining uniqueness across the four key columns.

These relationships establish the change grade request as a link between an enrollment attempt and its before/after grading schema definitions.