Search Results igs_pr_stu_acad_v




Overview
Explore in AI Chat

Overview

The view IGS_PR_STU_ACAD_V belongs to the IGS - Student System product family within Oracle E-Business Suite, a module now classified as obsolete in the ETRM (E-Business Suite Technical Reference Manual) for releases 12.1.1 and 12.2.2. Its documented purpose is to expose the academic information of a student in a denormalized, reporting-friendly form. Rather than requiring report developers or integration components to re-derive a student's academic calendar context, course enrollment, and grade point statistics from the normalized Student System schema, this view aggregates those elements into a single projection keyed principally by PERSON_ID and COURSE_CD.

The object is an application view, meaning it is intended for consumption by Oracle EBS forms, concurrent programs, reports, and external integrations rather than for direct transactional modification. Because the underlying product is obsolete, the view is best regarded as a legacy reporting artifact; in many environments it is not even instantiated, as indicated by the ETRM note "Not implemented in this database."

Underlying Base Objects

The ETRM metadata for this view records no owner and no referenced base objects, so the definitive source of truth for its definition is the view text itself. That text references aliases such as SPA, P, CRV, CI, CI2, and ST, which correspond to Student System base entities: a student program/application record (SPA), the party/identifier record (P), a course version table (CRV), academic calendar instances (CI2 for the academic calendar and CI for the load calendar), and a status type table (ST). The view also calls several packaged functions in IGS_PR_ACAD_DETAILS to derive GPA and credit point metrics.

The ETRM explicitly lists no referenced base objects, which is a documentation gap rather than an indication that the view is standalone. In practice the view is a join-and-compute layer over the Student System academic tables, supplemented by PL/SQL function calls at query time.

Key Columns

Common Use Cases and Queries

Typical usage involves retrieving a student's academic standing for a specific calendar sequence, or producing transcript-style extracts. The following query returns term and cumulative GPA for a student and academic sequence:

  • SELECT person_id, course_cd, acad_cal_type, acad_sequence_number, term_gpa, cum_gpa FROM igs_pr_stu_acad_v WHERE person_id = :p_person_id AND acad_sequence_number = :p_seq;
  • Reporting earned versus attempted credit points per term for enrollment monitoring.
  • Integration extracts feeding external student information systems or data warehouses.

Because the view invokes PL/SQL functions per row, performance tuning should favor filtering on PERSON_ID and the calendar keys. Given the obsolete status of IGS - Student System, deployments should verify object existence before relying on the view in production reporting.