Search Results grade_point_average




Overview
Explore in AI Chat

Overview

IGSBV_ACAD_TRANSCRIPT_TERMS is a read-only view within the Oracle E-Business Suite Student System (IGS) module, which is documented as obsolete in Release 12.1.1 and 12.2.2. The view presents term-level transcript details for academic records, consolidating term identifiers, effective date ranges, credit point totals, and grade point average (GPA) figures into a single queryable object. Its primary role is to support reporting and integration scenarios that require a per-term summary of a student's academic performance, particularly the grade_point_average value that was the subject of the user's search.

The object is defined with a WITH READ ONLY clause over IGS_AD_TERM_DETAILS, meaning it exposes no DML capability and serves purely as a query surface. Notably, the ETRM documentation records that the view is "Not implemented in this database" in the reviewed environment, so availability depends on the specific instance and patch level.

Underlying Base Objects

The view text is documented as a straightforward projection over a single base table:

  • IGS_AD_TERM_DETAILS — the sole referenced base object, providing all columns exposed by the view. The ETRM metadata lists no other referenced base objects.
  • The view applies only column aliasing and the WITH READ ONLY constraint; no joins, unions, or aggregations are documented, so cardinality matches the underlying term-detail rows one-to-one.

Because the definition is a direct select, the view inherits the base table's row-level content and any security or filtering applied at the table level. Reports built on the view depend on data maintained in IGS_AD_TERM_DETAILS by Student System transcript and enrollment processing.

Key Columns

The view exposes the following columns, several of which carry renamed aliases:

Common Use Cases and Queries

Typical usage centers on producing term-by-term GPA reporting for a transcript, verifying earned versus attempted credit points, and feeding external systems with academic standing data. A representative query retrieving GPA values for a transcript is:

  • SELECT TERM, GRADE_POINT_AVERAGE, TOTAL_GPA_UNITS FROM IGSBV_ACAD_TRANSCRIPT_TERMS WHERE TRANSCRIPT_ID = :p_transcript_id ORDER BY EFFECTIVE_START_DATE;
  • SELECT TERM, TOTAL_CREDIT_POINT_ATTEMPTED, TOTAL_CREDIT_POINT_EARNED, GRADE_POINT_AVERAGE FROM IGSBV_ACAD_TRANSCRIPT_TERMS WHERE GRADE_POINT_AVERAGE IS NOT NULL;

Because the view is read-only and not implemented in every database, developers should confirm its presence in the target instance and, where absent, query IGS_AD_TERM_DETAILS directly, applying the same aliases for consistency. Given the module's obsolete designation, new development should treat this view as a legacy reporting artifact.