Search Results igs_da_cnfg_ftr_pk

Overview

The IGS_DA_CNFG_FTR table is a configuration entity within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function was to store system configuration data governing which specific features were permitted to be used on the request screen during the degree audit process. A degree audit is a critical academic function that evaluates a student's completed coursework against their program requirements. This table acted as a junction, linking a request type configuration to the specific features allowed for that type, thereby controlling user interface options and available functionalities for different audit scenarios.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique combination of a request type and a feature code. The key columns are:

• REQUEST_TYPE_ID: A foreign key column that uniquely identifies a specific degree audit request type configuration as defined in the IGS_DA_CNFG_REQ_TYP table. This dictates the context or category of the audit.
• FEATURE_CODE: A foreign key column that stores a code representing a specific configurable feature or option. This code references valid values maintained in the IGS_DA_FTR_VAL_MAP table, which likely contains the human-readable name and description of the feature.

The presence of a row in this table for a given REQUEST_TYPE_ID and FEATURE_CODE signifies that the particular feature is enabled for that request type.

Common Use Cases and Queries

This table was central to administering the degree audit interface. A common administrative use case would be querying or modifying the set of features available for a specific audit request type, such as an "Unofficial Audit" versus an "Official Graduation Audit." A typical reporting query would join this table to its referenced dictionaries to produce a readable list of enabled features. For example:

SELECT req.REQUEST_TYPE_NAME, map.FEATURE_MEANING, map.DESCRIPTION
FROM IGS_DA_CNFG_FTR ftr
JOIN IGS_DA_CNFG_REQ_TYP req ON ftr.REQUEST_TYPE_ID = req.REQUEST_TYPE_ID
JOIN IGS_DA_FTR_VAL_MAP map ON ftr.FEATURE_CODE = map.FEATURE_CODE
WHERE req.REQUEST_TYPE_NAME = 'Unofficial Audit'
ORDER BY map.FEATURE_MEANING;

This query would list all features configured for the 'Unofficial Audit' request type. Conversely, an INSERT or DELETE operation on this table would be used to grant or revoke access to a feature for a given request type.

Related Objects

The IGS_DA_CNFG_FTR table has defined foreign key relationships with two parent tables, which are essential for understanding its data integrity and context:

• IGS_DA_CNFG_REQ_TYP: This is the primary parent table for the REQUEST_TYPE_ID column. It defines the valid degree audit request types (e.g., "What-If," "Program Completion") for which features can be configured. The relationship ensures that a feature cannot be assigned to a non-existent request type.
• IGS_DA_FTR_VAL_MAP: This is the primary parent table for the FEATURE_CODE column. It serves as a value set or lookup table, defining the universe of valid feature codes along with their descriptions. The relationship ensures that only predefined features can be enabled in the configuration.

The table's primary key, IGS_DA_CNFG_FTR_PK, on (REQUEST_TYPE_ID, FEATURE_CODE), enforces the business rule that a specific feature can only be added once to a given request type configuration.