Search Results igs_pr_stu_acad_stat




Overview
Explore in AI Chat

Overview

The IGS_PR_STU_ACAD_STAT table is a core data repository within the Oracle E-Business Suite (EBS) Student System (IGS) for versions 12.1.1 and 12.2.2. Its primary function is to store historical and current academic performance statistics for students that are sourced from external systems. This table acts as a central point for aggregating and retaining key performance indicators, such as grade point averages or credit hour totals, which are often imported from feeder institutions or other external data sources. Its existence supports comprehensive student academic profiling, longitudinal tracking, and reporting that extends beyond the data generated natively within the EBS application.

Key Information Stored

The table's structure is designed to uniquely identify a specific statistical record for a student within a precise academic context. Its composite primary key consists of six columns: PERSON_ID (the student), COURSE_CD (the program of study), CAL_TYPE and CI_SEQUENCE_NUMBER (defining the academic calendar instance), STAT_TYPE (the category of statistic), and TIMEFRAME (the period to which the statistic applies). Typical data stored includes the actual statistic value, the date it was last updated, and a logical deletion flag. The critical columns, therefore, are the primary key components, along with a value column (e.g., STAT_VALUE) and a LAST_UPDATE_DATE, which are implied by the table's purpose of storing statistical data.

Common Use Cases and Queries

This table is essential for generating official academic transcripts, conducting institutional research, and validating admission or progression requirements that consider prior academic performance. A common reporting use case involves querying for a student's external academic history to present a unified academic record. A typical SQL pattern would join this table to related person and course tables to retrieve a student's imported statistics.

SELECT ipsas.person_id,
       ipsas.course_cd,
       ipsas.stat_type,
       ipsas.timeframe,
       ipsas.stat_value
FROM igs_pr_stu_acad_stat ipsas
WHERE ipsas.person_id = :student_id
AND ipsas.course_cd = :program_code
ORDER BY ipsas.timeframe DESC;

Data integration processes also frequently interact with this table, using the primary key to perform MERGE operations that update existing statistics or insert new records from external feeds.

Related Objects

The IGS_PR_STU_ACAD_STAT table maintains defined foreign key relationships with several fundamental tables in the Student System, ensuring referential integrity for its core identifiers:

  • IGS_EN_STDNT_PS_ATT_ALL: Links via PERSON_ID and COURSE_CD to validate the student's enrollment in the specific program of study.
  • IGS_CA_INST_ALL: Links via CAL_TYPE and CI_SEQUENCE_NUMBER to validate the academic calendar instance (e.g., a specific semester or term).
  • IGS_PR_STAT_TYPE: Links via STAT_TYPE to validate the category of the academic statistic being stored, such as 'GPA' or 'EARNED_CREDITS'.

These relationships are critical for any query or data load that requires contextual information about the student, program, calendar, or statistic type associated with a record in IGS_PR_STU_ACAD_STAT.