Search Results igs_da_req_ftrs




Overview
Explore in AI Chat

Overview

The IGS_DA_REQ_FTRS table is a core configuration table within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a control table for the Degree Audit module, specifically governing which features are permitted to be displayed and used on the Degree Audit Request Screen. Its role is to store the valid feature-to-request mapping, ensuring that only pre-configured and authorized features are available to users when submitting a degree audit request. This table is essential for maintaining the integrity and consistency of the degree audit request process by enforcing a controlled set of operational parameters.

Key Information Stored

The table stores a mapping between a degree audit batch configuration and the specific features enabled for it. The primary data elements are defined by its composite primary key. The BATCH_ID column links to a specific degree audit request batch configuration. The FEATURE_CODE column stores the unique identifier for a configurable feature, such as a specific reporting option, inclusion rule, or display parameter. Together, these columns define a single rule permitting a specific feature for a specific request batch. The table's structure is minimal, serving purely as a junction to enforce these business rules.

Common Use Cases and Queries

A primary use case is validating user selections on the request screen. The application queries this table to populate available feature checkboxes or list of values (LOVs). System administrators use it during setup to define which features are active for different audit types. Common reporting queries involve listing all features enabled for a particular batch or identifying which batches have a specific feature turned on. A typical SQL pattern retrieves active features for a known batch:

  • SELECT feature_code FROM igs.igs_da_req_ftrs WHERE batch_id = :p_batch_id;

Conversely, to audit configuration, one might join to the IGS_DA_RQST table to get batch details:

  • SELECT r.batch_id, r.batch_name, f.feature_code FROM igs.igs_da_rqst r, igs.igs_da_req_ftrs f WHERE r.batch_id = f.batch_id ORDER BY r.batch_id;

Related Objects

IGS_DA_REQ_FTRS has defined foreign key relationships central to its function. It is a child of the IGS_DA_RQST table via the BATCH_ID column, which holds the master configuration for a degree audit request batch. It is also a child of the IGS_DA_FTR_VAL_MAP table via the FEATURE_CODE column, which likely serves as the master validation table for all available feature codes and their possible values within the Degree Audit module. These relationships ensure referential integrity, guaranteeing that entries in IGS_DA_REQ_FTRS correspond to valid, existing batch configurations and feature definitions elsewhere in the system.