Search Results igs_pr_acad_load_v




Overview
Explore in AI Chat

Overview

IGS_PR_ACAD_LOAD_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes the academic standing of a student program attempt within a specific load calendar, combining both period (term) and cumulative statistics. The view is documented as returning "the details of a Student Program Attempt within a Load Calendar with cumulative and period statistics." Its primary role is to give reporting, integration, and inquiry users a single denormalized source for GPA and credit-point measures without having to call the underlying IGS_PR_ACAD_DETAILS PL/SQL functions directly. This is particularly relevant for users searching on fields such as term_earned_cp, since that column is computed and surfaced by this view.

Underlying Base Objects

The view is defined over several base tables that supply the student program attempt, course version, and calendar context:

The GPA and credit-point columns are not stored values; they are derived at query time by calling functions in the IGS_PR_ACAD_DETAILS package (for example GET_LOAD_EARNED_CP, GET_LOAD_ATTEMPTED_CP, GET_LOAD_GPA, and their cumulative counterparts). The ETRM metadata does not list the view as having documented base objects, so the joins above should be confirmed against the deployed view text in the target environment.

Key Columns

ACAD_DESCRIPTION and ACAD_ALTERNATE_CODE describe the academic calendar instance (CI2), while LOAD_START_DT and LOAD_END_DT bound the load period.

Common Use Cases and Queries

Typical usage includes student academic transcripts, progression checks, and integrations that feed GPA or earned-credit analytics. A representative query for earned credit points in a load period is:

  • SELECT person_number, course_cd, load_cal_type, load_ci_sequence_number, term_earned_cp, term_attempted_cp, cum_earned_cp, cum_gpa FROM apps.igs_pr_acad_load_v WHERE person_number = :p_person;
  • Reporting cumulative earned credit points for a program: SELECT person_number, course_cd, cum_earned_cp, cum_gpa FROM apps.igs_pr_acad_load_v ORDER BY person_number;
  • Progression or eligibility checks comparing TERM_EARNED_CP against TERM_ATTEMPTED_CP for a given load calendar.

Because the derived columns invoke PL/SQL functions per row, performance-sensitive extracts should restrict rows by person, course, or load calendar rather than scanning the full view. Access is normally granted through the APPS schema, and callers should validate any function-based columns against the target release (12.1.1 or 12.2.2) since the IGS_PR_ACAD_DETAILS package logic governs their return values.