Search Results s_stat_element




Overview
Explore in AI Chat

Overview

The IGS_PR_STA_TYPE_ELE table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the IGS (iGrants) product family. Its primary function is to define the relationship between user-defined statistic types and the underlying system statistic elements. This table acts as a mapping entity, enabling the association of specific, predefined system metrics (elements) with customizable statistic categories (types) for reporting and analytical purposes within the grants management module. Its role is foundational for structuring and organizing statistical data capture and presentation.

Key Information Stored

The table stores a concise set of columns focused on defining the statistic type-element relationship and standard audit information. The core business columns are:

  • STAT_TYPE (VARCHAR2(50)): A mandatory field storing the user-defined code for a category or type of statistic.
  • S_STAT_ELEMENT (VARCHAR2(50)): A mandatory field storing the code for a system-defined statistic element. This is the specific metric being categorized.
  • DISPLAY_ORDER (NUMBER): An optional field intended to control the presentation sequence of elements within a given statistic type. The metadata notes this column is marked as OBSOLETE.
The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for tracking record creation and modifications. The unique index IGS_PR_STA_TYPE_ELE_U1 on STAT_TYPE and S_STAT_ELEMENT enforces that a specific system element can be associated with a given statistic type only once.

Common Use Cases and Queries

This table is primarily queried to understand the composition of statistic types or to retrieve all system elements available for reporting. A common use case is generating a list of all configured mappings for administrative review or for populating LOVs in application forms. The foundational query, as indicated in the metadata, is: SELECT STAT_TYPE, DISPLAY_ORDER, S_STAT_ELEMENT FROM IGS.IGS_PR_STA_TYPE_ELE ORDER BY STAT_TYPE; For operational reporting, this table is typically joined to other statistics-related tables (e.g., tables storing the actual statistic values) using the S_STAT_ELEMENT as a key. Another typical query retrieves all system elements linked to a specific statistic type for validation or display logic: SELECT S_STAT_ELEMENT FROM IGS.IGS_PR_STA_TYPE_ELE WHERE STAT_TYPE = '&STAT_TYPE_CODE';

Related Objects

Based on the provided dependency information, the IGS_PR_STA_TYPE_ELE table is referenced by an object named IGS_PR_STA_TYPE_ELE within the APPS schema. This is most likely a public synonym (APPS.IGS_PR_STA_TYPE_ELE) pointing to the IGS.IGS_PR_STA_TYPE_ELE base table, which is a standard EBS architecture pattern for providing global access. The table does not itself reference other objects, indicating it is a master configuration table. In a complete functional context, the S_STAT_ELEMENT column would logically relate to a definition table for system statistic elements, and the STAT_TYPE would relate to a definition table for statistic types, though these are not listed in the provided metadata excerpt.