Results for “igs_pr_stu_acad_stat”

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

Overview

IGS_PR_STU_ACAD_STAT is a table in the IGS (Student System) product schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. As its description states, it stores student academic statistics originating from external sources. In practice, this table acts as a landing and consolidation point for statistics such as credit points and grade point averages that are calculated or supplied by systems outside Oracle Student System — for example, a legacy student records system, a partner institution, or an external assessment engine — and then associated with a specific student, course attempt, and calendar instance within EBS.

This makes it a data-integration object rather than a transactional one. Records are populated by inbound interfaces rather than through standard EBS forms, and they are subsequently consumed for reporting, articulation evaluation, and progression analysis. The metadata's heuristic Data Vault classification of this object is link, which suggests modelling it as an associative entity connecting a student attempt, a calendar instance, and a statistic type. This classification is a modeling suggestion derived from the foreign-key structure and should be validated against actual usage before being adopted.

Key Information Stored

The table contains 18 documented columns. Its primary key is IGS_PR_STU_ACAD_STAT_PK, defined over PERSON_ID, COURSE_CD, CAL_TYPE, CI_SEQUENCE_NUMBER, STAT_TYPE, and TIMEFRAME. A unique index, IGS_PR_STU_ACAD_STAT_U1, covers the identical column set, confirming this six-part combination as the business key that uniquely identifies one statistic per student, course attempt, statistic type, and reporting period. Because the primary key is composite and business-derived, there is no single surrogate key column in the documented schema.

The most significant columns are:

• PERSON_ID — identifies the student to whom the statistic applies; a foreign key to IGS_EN_STDNT_PS_ATT_ALL.
• COURSE_CD — the course associated with the statistic; also part of the foreign key to the student attempt table.
• CAL_TYPE and CI_SEQUENCE_NUMBER — together identify the calendar instance (academic period) via IGS_CA_INST_ALL.
• STAT_TYPE — the category of statistic recorded, constrained by IGS_PR_STAT_TYPE.
• TIMEFRAME — the reporting window the statistic covers.
• SOURCE_TYPE and SOURCE_REFERENCE — describe the external system and the identifier of the originating record, supporting traceability back to the source.
• ATTEMPTED_CREDIT_POINTS and EARNED_CREDIT_POINTS — credit volumes attempted versus successfully earned.
• GPA, GPA_CREDIT_POINTS, and GPA_QUALITY_POINTS — the grade point average and its constituent credit and quality point totals.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS audit columns recording who loaded or amended each row.

Common Use Cases and Queries

Typical usage centres on reconciliation of externally supplied statistics against internally held student data, and on reporting cumulative performance. A common query joins the table to the student attempt and statistic type reference tables to produce a readable extract:

• Retrieving a student's external GPA history: select PERSON_ID, COURSE_CD, STAT_TYPE, TIMEFRAME, GPA, EARNED_CREDIT_POINTS from IGS_PR_STU_ACAD_STAT where PERSON_ID = :person_id order by TIMEFRAME.
• Tracing data provenance: filter on SOURCE_TYPE and SOURCE_REFERENCE to identify rows loaded by a particular external feed, useful when investigating data-quality exceptions.
• Audit and load monitoring: query by CREATION_DATE or LAST_UPDATE_DATE to identify rows inserted or changed within a given interface run.
• Validating inbound loads: compare ATTEMPTED_CREDIT_POINTS and EARNED_CREDIT_POINTS against IGS_EN_STDNT_PS_ATT_ALL to detect discrepancies between external and internal records.

Related Objects

The foreign-key metadata identifies three direct dependencies:

• IGS_EN_STDNT_PS_ATT_ALL — joined on PERSON_ID and COURSE_CD; the student's programme attempt record.
• IGS_CA_INST_ALL — joined on CAL_TYPE and CI_SEQUENCE_NUMBER; the calendar instance defining the academic period.
• IGS_PR_STAT_TYPE — joined on STAT_TYPE; the reference table defining valid statistic categories.
• IGS_PR_STU_ACAD_STAT_PK and IGS_PR_STU_ACAD_STAT_U1 — the primary key constraint and unique index enforcing row uniqueness.

These relationships confirm the table's role as a link between student attempt data and calendar context, with the statistic type providing controlled classification. Any downstream reporting view or interface that summarizes external academic statistics will depend on this table and its three parent tables.