Search Results igs_pr_stat_type




Overview
Explore in AI Chat

Overview

The IGS_PR_STAT_TYPE table is a core configuration table within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves as the master repository for defining the distinct categories or types of statistical data that an educational institution intends to capture and analyze. The table's primary role is to establish a controlled list of statistic types, which are then referenced by numerous operational and reporting tables throughout the system. This foundational design ensures data integrity and consistency, enabling the institution to systematically record and report on key performance indicators across different organizational levels, including institutional, organizational unit, cohort, and student academic statistics.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure centers on the STAT_TYPE column, which serves as the table's primary key. This column stores the unique code that identifies each statistic type, such as 'ENROLLMENT', 'GRADUATION_RATE', or 'RETENTION'. The table likely contains descriptive columns to provide a meaningful name and explanation for each type, along with control columns common to EBS tables (e.g., CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY). Its configuration nature means it is typically populated during system setup and is relatively static, with changes driven by evolving institutional reporting requirements.

Common Use Cases and Queries

The primary use case for IGS_PR_STAT_TYPE is to provide a validation list for statistic type entry across the Student System. Common operational scenarios include configuring statistical dashboards, setting up cohort analysis definitions, and generating standardized institutional reports. A fundamental query involves joining this master table with its related transactional tables to produce meaningful reports. For example, to list all institutional statistics with their type descriptions, one would use a query such as: SELECT ist.stat_value, tst.description FROM igs_pr_inst_stat ist, igs_pr_stat_type tst WHERE ist.stat_type = tst.stat_type;. Administrators may also query the table directly to review or maintain the installed set of statistic types: SELECT stat_type, description FROM igs_pr_stat_type ORDER BY 1;.

Related Objects

The IGS_PR_STAT_TYPE table is a central reference point, as evidenced by its numerous foreign key relationships. The STAT_TYPE column is referenced by the following key operational tables:

  • IGS_DA_CNFG_STAT.STAT_TYPE: Links statistic types to dashboard configuration.
  • IGS_PR_COHORT.STAT_TYPE: Associates statistic types with defined student cohorts.
  • IGS_PR_INST_STAT.STAT_TYPE: Stores the actual institutional-level statistic values for each type.
  • IGS_PR_ORG_STAT.STAT_TYPE: Stores statistic values at the organizational unit level.
  • IGS_PR_STU_ACAD_STAT.STAT_TYPE: Tracks statistic values at the individual student academic level.
  • IGS_PR_STA_TYPE_ELE.STAT_TYPE: Likely defines elements or components associated with a statistic type.
These relationships enforce referential integrity, ensuring that any statistic recorded in the system corresponds to a valid, pre-defined type from this master table.