Search Results igs_pr_gen_005




Overview
Explore in AI Chat

Overview

APPS.IGS_PR_SDT_PROG_PRD_V is a student progress reporting view within the Oracle E-Business Suite Student System (Oracle Student System / OSS) product family. The IGS_PR_ prefix denotes the Progress subsystem, while SDT_PROG_PRD_V identifies a "Student Programme Period" view — that is, a consolidated listing of a student's progress calendars and the associated academic calendar to which each progress period rolls up. The view surfaces one row per student, course, and progress calendar instance, joining the progress calendar instances to their parent academic calendar instance through the calendar instance relationship table.

The view exists primarily to serve the Progress Reporting and Statement of Results processes. Each row carries derived grade metrics — course GPA, period GPA, course WAM, and period WAM — computed at query time through the package function IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE. This is the critical detail implied by the user's search term igs_pr_gen_005: the view is a principal consumer of that package, and any investigation into that package's behaviour usually begins with this view.

Underlying Base Objects

The view definition joins several documented Student System tables. IGS_EN_STDNT_PS_ATT (alias SCA) is the driving table, holding the student's enrolled course attempt record. Progress calendar instances are drawn from IGS_CA_INST (alias CI), and the parent academic calendar instances come from a second instance of IGS_CA_INST (alias ACAD_CI). The linkage between the two is supplied by IGS_CA_INST_REL (alias ACAD_CIR), with the calendar type attributes resolved through two aliases of IGS_CA_TYPE (CAT and ACAD_CAT) and calendar status through IGS_CA_STAT. Correlated EXISTS subqueries reference IGS_EN_SU_ATTEMPT, IGS_CA_INST_REL, and IGS_AS_SC_ATMPT_ENR to confirm that a meaningful attempt or enrolment exists before a row is returned.

Filtering is strict: CAT.S_CAL_CAT = 'PROGRESS' and ACAD_CAT.S_CAL_CAT = 'ACADEMIC' constrain the calendar categories, while CS.S_CAL_STATUS <> 'PLANNED' excludes calendar instances that have not yet started.

Key Columns

Common Use Cases and Queries

Typical use is generating progress reports and verifying the GPA/WAM values produced by IGS_PR_GEN_005 for a given student. Because each row invokes the PL/SQL function four times, performance can degrade in bulk extracts, and queries should always filter by PERSON_ID or calendar instance.

SELECT person_id, course_cd, cal_type, sequence_number,
       gpa_course, gpa_period, wam_course, wam_period
  FROM apps.igs_pr_sdt_prog_prd_v
 WHERE person_id = :p_person_id;

A second common pattern reconciles progress calendar periods against their parent academic periods for a reporting term:

SELECT person_id, course_cd, alternate_code, start_dt, end_dt
  FROM apps.igs_pr_sdt_prog_prd_v
 WHERE cal_type = :p_cal_type
   AND sequence_number = :p_seq;

Data reconciliation and debugging of the IGS_PR_GEN_005 package also rely on this view to compare stored grade data against dynamically computed values.