Search Results igs_pr_sta_type_ele




Overview
Explore in AI Chat

Overview

The IGS_PR_STA_TYPE_ELE table is a core data definition table within the Oracle E-Business Suite Student System (IGS) module. It functions as a mapping or association table, establishing the relationship between user-defined Statistic Types and the pre-defined System Statistic Elements. Its primary role is to define which specific statistical elements are applicable and can be populated for a given statistic type, thereby enabling the structured capture and reporting of various academic and institutional metrics. This table is essential for configuring the system's statistical reporting capabilities, ensuring data integrity by governing valid element-type combinations.

Key Information Stored

The table's structure is designed to enforce the association between a statistic type and its permissible elements. The key columns, which together form the primary key (IGS_PR_STA_TYPE_ELE_PK), are STAT_TYPE and S_STAT_ELEMENT. The STAT_TYPE column stores the code for a user-defined statistic type, which is validated against the parent IGS_PR_STAT_TYPE table. The S_STAT_ELEMENT column stores the code for a system-defined statistic element. This column is part of a composite foreign key relationship with the IGS_PS_AWD_HNR_BASE table, indicating where these defined elements are utilized in practice, such as in award or honors calculations.

Common Use Cases and Queries

A primary use case is the validation and setup of statistic reporting parameters during system configuration. Administrators use this table to determine which elements (e.g., "Total Enrollment," "Graduation Count," "Average GPA") are available for a specific statistic type (e.g., "Annual Program Statistics"). Common queries involve listing all elements for a type or verifying if a specific element is assigned. For reporting, the table is often joined to IGS_PR_STAT_TYPE for descriptions and to fact tables that store the actual statistical values.

  • Retrieve all system elements for a statistic type: SELECT s_stat_element FROM igs_pr_sta_type_ele WHERE stat_type = '&TYPE_CODE';
  • Validate a specific element-type combination: SELECT 'Exists' FROM dual WHERE EXISTS (SELECT 1 FROM igs_pr_sta_type_ele WHERE stat_type = '&TYPE' AND s_stat_element = '&ELEMENT');

Related Objects

The IGS_PR_STA_TYPE_ELE table maintains critical referential integrity with several other objects. Its primary parent table is IGS_PR_STAT_TYPE, which defines the valid statistic types via a foreign key on the STAT_TYPE column. A significant child relationship exists with the IGS_PS_AWD_HNR_BASE table, where the S_STAT_ELEMENT and STAT_TYPE columns are referenced as a composite foreign key. This link is crucial, as it ties the definition of statistic elements to their practical application in award and honors base calculations within the Student System.