Results for “gpa_period”

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

Overview

IGS_PR_SDT_PROG_PRD_V is an Oracle E-Business Suite view owned by the APPS schema in the IGS (Student System) product. It is a reporting view that consolidates student course attempt details with academic period information and derived academic performance values, producing one row per student, course, and progress calendar instance. The view name follows the IGS naming convention: "PR" denotes progression/performance, "SDT" refers to the student, and "PROG_PRD" indicates that the rows are scoped to progress calendar types and their related academic periods.

The view is primarily used to support student academic record reporting, particularly around grade point average (GPA) and weighted average mark (WAM) calculations. Notably, it exposes a column named WAM_COURSE, which is directly relevant to the search term "wam_course." The view calls the function IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE to resolve course and period level GPA and WAM values based on the institution's configured SCPM (Student Course Performance Method) setup. This makes the view a convenient single source for reporting weighted academic performance without requiring direct calls to the performance calculation function.

Underlying Base Objects

The view is defined over several IGS base tables and joins them through a combination of direct predicates and correlated EXISTS subqueries. The documented base objects include:

• IGS_EN_STDNT_PS_ATT — aliased SCA; the student course attempt (student program/attempt) record that provides PERSON_ID and COURSE_CD.
• IGS_CA_INST — joined twice as CI (the progress calendar instance) and ACAD_CI (the parent academic calendar instance).
• IGS_CA_TYPE — joined twice as CAT (the progress calendar type, where S_CAL_CAT = 'PROGRESS') and ACAD_CAT (the academic calendar type, where S_CAL_CAT = 'ACADEMIC').
• IGS_CA_INST_REL — aliased ACAD_CIR; links the progress calendar instance to its superior academic calendar instance.
• IGS_CA_STAT — aliased CS; provides the calendar status and excludes instances whose S_CAL_STATUS is 'PLANNED'.

Two correlated EXISTS clauses further constrain the result set. The first validates the student's course attempt against IGS_EN_SU_ATTEMPT and IGS_CA_INST_REL, and the second validates against IGS_AS_SC_ATMPT_ENR and IGS_CA_INST_REL. Together these ensure that only students with a genuine attempt or enrolment record tied to the progress calendar are returned. Although the documented metadata lists no base objects, the view text confirms the relationships above.

Key Columns

The view exposes a broad set of columns for student, calendar, and performance context:

• PERSON_ID, COURSE_CD — the student and course identifiers that form the core of each row.
• ROWID — the row identifier inherited from IGS_EN_STDNT_PS_ATT, enabling the view to be used as an update target in some reporting tools.
• CAL_TYPE, SEQUENCE_NUMBER, ALTERNATE_CODE — identify the progress calendar instance (CI), with its academic counterpart (ACAD_CI).
• START_DT, END_DT — the calendar instance's start and end dates.
• DESCRIPTION — the progress calendar type description.
• GPA_COURSE, GPA_PERIOD — course-level and period-level grade point averages returned by IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE.
• WAM_COURSE, WAM_PERIOD — course-level and period-level weighted average marks. WAM_COURSE is the column most directly associated with the "wam_course" search, while WAM_PERIOD gives the corresponding period-level figure.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

The view is typically used to report a student's weighted average marks and grade point averages per course and per progress period. The following query returns the course-level WAM and GPA for a given student:

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

To compare course-level and period-level performance across all students in a given progress calendar instance:

SELECT person_id, course_cd, wam_course, wam_period, gpa_course
FROM   apps.igs_pr_sdt_prog_prd_v
WHERE  cal_type = :p_cal_type
AND    sequence_number = :p_sequence_number
ORDER  BY course_cd, person_id;

Because the view filters to non-PLANNED progress calendars and to attempts with a matching enrolment or attempt record, it is well suited to end-of-period transcript extracts, performance dashboards, and progression reviews. It should be queried within the APPS schema, and callers should be aware that the GPA and WAM columns are computed by IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE, so results depend on the configured grading and performance schemes.