Results for “current_grade”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGSBV_AS_CHNG_GRD_REQUESTS belongs to the IGS — Student System product family within Oracle E-Business Suite. It exposes the transactional detail of grade change request records, presenting both the currently recorded grade and the requested replacement grade for a student's unit attempt. The view is defined as a read-only reporting construct, as evidenced by the WITH READ ONLY clause in its definition, which prevents DML operations against it.

The prefix IGSBV follows the IGS naming convention for business views intended for inquiry and reporting rather than for direct application processing. Because the object is catalogued as Obsolete in the IGS — Student System module, it is associated with legacy higher-education functionality and is not implemented in the documented 12.2.2 database. Organizations running 12.1.1 or 12.2.2 should treat this metadata as a historical reference; the view may only be present where legacy IGS Student System components were deployed and retained.

In the context of a user search for change_gs_version_number, this view is the primary location where the grading schema version associated with a requested grade change is surfaced, specifically through the CHANGE_GS_VERSION_NUMBER column (with its counterpart CURRENT_GS_VERSION_NUMBER).

Underlying Base Objects

The view is constructed by joining a primary grade-change request table with several descriptive lookup tables. The metadata does not document an explicit owner or a discrete list of referenced base objects, but the embedded view text identifies the following sources:

• IGS_AS_CHN_GRD_REQ — the driving grade-change request table (aliased CGR).
• HZ_PARTIES — supplies the party name and number for the student.
• IGS_PS_UNIT_OFR_OPT_ALL — the unit offering option, joined to the person and unit records.
• IGS_PS_UNIT_VER_ALL — provides unit title information.
• IGS_AS_UNIT_CLASS_ALL — supplies the unit class description.
• IGS_AD_LOCATION — provides the location description.
• IGS_CA_INST_ALL — supplies teaching calendar instance descriptions.

Joins are established on party ID, UOO ID, unit code and version number, unit class, location code, and teaching calendar type with sequence number, producing one row per grade change request with its related descriptors.

Key Columns

• PERSON_NAME, PERSON_NUMBER — party identity of the student whose grade is being changed.
• CURRENT_MARK, CURRENT_GRADING_SCHEMA_CODE, CURRENT_GS_VERSION_NUMBER, CURRENT_GRADE — the grade currently held on the unit attempt.
• CHANGE_MARK, CHANGE_GRADING_SCHEMA_CODE, CHANGE_GS_VERSION_NUMBER, CHANGE_GRADE — the requested replacement grade, its schema, and the grading schema version (CHANGE_GS_VERSION_NUMBER) central to the user's search.
• REQUEST_DATE, REQUESTER_COMMENTS, REQUESTER_ID — request initiation detail.
• APPROVER_DATE, APPROVER_COMMENTS, APPROVER_ID, CURRENT_STATUS — approval workflow state.
• UNIT_CODE, UNIT_TITLE, UNIT_CLASS, LOCATION_CODE, TEACH_CALENDAR_TYPE — academic context.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical usage involves auditing grade amendment requests, tracing which grading schema version was applied to a requested change, and reporting approval status. A representative query filtering on the grading schema version is:

SELECT person_number, person_name, unit_code, current_grade,
       change_gs_version_number, change_grade, current_status
FROM   igsbv_as_chng_grd_requests
WHERE  change_gs_version_number = :p_gs_version
ORDER  BY request_date DESC;

Analysts may also reconcile current versus requested grades across a teaching calendar:

SELECT unit_code, teach_calendar_type, COUNT(*) requests
FROM   igsbv_as_chng_grd_requests
WHERE  current_status = 'PENDING'
GROUP  BY unit_code, teach_calendar_type;

Because the view is read-only and documented as obsolete/not implemented, verify availability against the target instance before relying on it in production reporting.