Search Results igs_pr_stu_ou_hist_all

Overview

The table IGS_PR_STU_OU_HIST_ALL is a core data entity within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as a historical repository for student program outcomes. This table is designed to track changes to a student's progression and final results within an academic program over time. Its role is critical for maintaining a complete, auditable record of a student's academic journey, supporting compliance, reporting, and longitudinal analysis. As an "_ALL" table, it is architected to support multi-organization access (Multi-Org) within the EBS environment.

Key Information Stored

The table's primary key structure defines the granularity of the historical record. Each row is uniquely identified by a combination of PERSON_ID (the student), COURSE_CD (the academic program), SEQUENCE_NUMBER (a specific instance or version of the student's program attempt), and HIST_START_DT (the effective date when this historical snapshot begins). While the provided metadata does not list all columns, the foreign key relationships and standard practice indicate it stores outcome-related attributes that were valid from the HIST_START_DT until a subsequent history record supersedes it. This typically includes fields such as final grade, outcome status, completion date, and potentially the organizational unit responsible at that point in time.

Common Use Cases and Queries

This table is central to generating official academic transcripts, auditing program completion status changes, and analyzing student cohort outcomes. Common reporting scenarios include tracing the evolution of a student's result for a specific program or identifying all students whose program outcome was updated within a given period. A typical query pattern involves joining to the main student program outcome table to get the current record and to this history table for the prior states.

• Sample Query Pattern: Retrieving the full history for a student's program attempt.

  SELECT hist.*
  FROM igs_pr_stu_ou_hist_all hist
  WHERE hist.person_id = :p_person_id
    AND hist.course_cd = :p_course_cd
    AND hist.sequence_number = :p_sequence_number
  ORDER BY hist.hist_start_dt DESC;

• Data from this table feeds regulatory reports that require proof of historical academic standings and supports operational inquiries into past academic decisions.

Related Objects

The table has a direct and integral relationship with the primary student program outcome table, as defined by its foreign key constraint. This relationship is fundamental to the data model.

• IGS_PR_STDNT_PR_OU_ALL: This is the primary ("header") table for current student program outcomes. The history table (IGS_PR_STU_OU_HIST_ALL) references it via a foreign key on the composite columns (PERSON_ID, COURSE_CD, SEQUENCE_NUMBER). This design ensures every history record is linked to a specific, active program attempt record. Joins between these tables are essential for comparing current versus historical data.