Search Results igs_pe_stat_details




Overview
Explore in AI Chat

Overview

The IGS_PE_STAT_DETAILS table is a core data object within the now-obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store detailed statistical and historical academic information for a person (typically a student) within the institution. This table acts as a central repository for tracking key academic milestones and enrollment patterns, linking a person's demographic record to critical calendar-based events in their academic lifecycle. As indicated by its "Obsolete" status, this table and the surrounding IGS module represent legacy functionality, and its use in active development or new integrations is strongly discouraged in favor of more current Oracle Student Management solutions.

Key Information Stored

The table's structure is designed to capture temporal academic data through relationships with the academic calendar. Its primary keys are PERSON_ID, linking to the party (HZ_PARTIES), and PERSON_PROFILE_ID, linking to the person's profile (HZ_PERSON_PROFILES). The most significant data points are a series of calendar references that mark important dates:

These foreign key relationships to IGS_CA_INST_ALL are fundamental, transforming simple date stamps into context-rich references within the institutional academic framework.

Common Use Cases and Queries

This table supports historical reporting and analysis of student academic journeys. Common operational and analytical queries would involve joining to calendar and person tables to generate timelines or segment populations based on enrollment history. A typical pattern would be to retrieve a student's key academic dates for a transcript or audit report.

Sample Query: Retrieve Basic Stat Details for a Person
SELECT psd.person_id,
hz.party_name,
matr_ci.start_dt AS matriculation_date,
recent_ci.start_dt AS recent_period_start
FROM igs_pe_stat_details psd
JOIN hz_parties hz ON psd.person_id = hz.party_id
LEFT JOIN igs_ca_inst_all matr_ci ON psd.matr_cal_type = matr_ci.cal_type AND psd.matr_sequence_number = matr_ci.sequence_number
LEFT JOIN igs_ca_inst_all recent_ci ON psd.recent_cal_type = recent_ci.cal_type AND psd.recent_sequence_number = recent_ci.sequence_number
WHERE psd.person_id = :p_person_id;

Reporting use cases include analyzing cohort persistence based on matriculation terms, identifying students who have been active across many academic periods, or verifying the applicable catalog year for degree requirement purposes.

Related Objects

The IGS_PE_STAT_DETAILS table is integrally connected to several foundational EBS objects, primarily through foreign key constraints:

  • HZ_PARTIES: The universal TCA (Trading Community Architecture) table storing the person's core demographic identity (PERSON_ID foreign key).
  • HZ_PERSON_PROFILES: Stores extended profile information for a person (PERSON_PROFILE_ID foreign key).
  • IGS_CA_INST_ALL: The table for academic calendar instances. IGS_PE_STAT_DETAILS maintains four separate foreign key relationships to this table to define the Matriculation, Initial, Recent, and Catalog calendar periods.

Given the obsolete nature of the IGS module, this table may also be referenced by other legacy IGS entities, custom reports, or data migration scripts, but its primary and documented relationships are with the core TCA and Academic Calendar structures listed above.