Search Results igs_da_cnfg_stat

Overview

The IGS_DA_CNFG_STAT table is a configuration entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a junction table that defines the permissible statistical types for a given Grade Point Average (GPA) calculation request type. Its primary role is to enforce and manage the relationship between a configured GPA request and the specific academic statistics, such as term GPA or cumulative GPA, that can be calculated for it. This table is essential for ensuring that GPA calculations are performed according to institutional rules and that only valid, pre-defined statistic types are processed for each type of request.

Key Information Stored

The table's structure is relatively simple, centering on a composite primary key that defines the core relationship. The key columns are REQUEST_TYPE_ID and STAT_TYPE. The REQUEST_TYPE_ID column is a foreign key that links to a specific GPA calculation request configuration defined in the IGS_DA_CNFG_REQ_TYP table. The STAT_TYPE column is a foreign key that links to a valid statistical type code (e.g., 'TERM', 'CUMULATIVE') defined in the IGS_PR_STAT_TYPE table. Together, each row in IGS_DA_CNFG_STAT explicitly authorizes one statistic type for use with one request type, forming the basis for the GPA calculation engine's validation logic.

Common Use Cases and Queries

A primary use case is the validation step during the submission or scheduling of a GPA calculation process. The system will reference this table to confirm that the requested statistic type is allowed for the chosen request type. For reporting and administrative purposes, common queries involve listing all configured statistics for a request type or identifying which request types utilize a specific statistic. A typical SQL pattern would be a join to the related tables for descriptive information:

• SELECT rqt.meaning AS request_type, stt.stat_type AS stat_code FROM igs.igs_da_cnfg_stat cs JOIN igs.igs_da_cnfg_req_typ rqt ON cs.request_type_id = rqt.request_type_id JOIN igs.igs_pr_stat_type stt ON cs.stat_type = stt.stat_type WHERE rqt.request_type = 'PROBATION_CHECK';

This query would return all statistic types configured for a request type coded as 'PROBATION_CHECK'.

Related Objects

The IGS_DA_CNFG_STAT table is centrally connected to two key master tables via foreign key constraints, as documented in the provided metadata.

• IGS_DA_CNFG_REQ_TYP: This table defines the types of GPA calculation requests (e.g., for academic standing, honors calculation). IGS_DA_CNFG_STAT references it via the REQUEST_TYPE_ID column. This relationship ensures every statistic configuration is tied to a valid, existing request type.
• IGS_PR_STAT_TYPE: This table is a code lookup for the different kinds of academic statistics the system can calculate. IGS_DA_CNFG_STAT references it via the STAT_TYPE column. This relationship ensures that only institutionally defined statistic codes are used in the configuration.

The table's primary key, IGS_DA_CNFG_STAT_PK, enforces uniqueness on the combination of REQUEST_TYPE_ID and STAT_TYPE, preventing duplicate configurations.