Search Results igs_da_req_wif_pk

Overview

The IGS_DA_REQ_WIF table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a transactional repository for storing the specific academic program and unit set details associated with a student's "what-if" analysis request. This type of analysis allows students or advisors to model potential academic scenarios, such as changing a major or adding a minor, to understand the impact on degree progress and requirements. The table's role is to persist the parameters of each modeled scenario, linking them to a parent request batch for processing and reporting within the Degree Audit framework.

Key Information Stored

The table's structure is designed to capture the essential components of an academic plan for evaluation. Its primary key is a composite of BATCH_ID and WIF_ID, ensuring unique identification of each scenario within a request batch. Critical columns include BATCH_ID, which links to the parent request header in IGS_DA_RQST, and WIF_ID, a sequence identifier for multiple scenarios. The academic content is defined by PROGRAM_CODE (linking to IGS_PS_COURSE for the program of study) and columns for CATALOG_CAL_TYPE and CATALOG_CI_SEQ_NUM (linking to IGS_CA_INST_ALL to specify the academic catalog year under which the program rules should be evaluated). This catalog linkage is crucial for applying the correct version of graduation requirements.

Common Use Cases and Queries

The primary use case is supporting the backend processing of degree audit what-if scenarios. When a user submits a request, data is inserted into this table. Common operational and reporting queries involve joining to related tables to analyze scenarios. For instance, to list all what-if scenarios for a specific request batch, one might use: SELECT wif_id, program_code, catalog_cal_type FROM igs_da_req_wif WHERE batch_id = :batch_id ORDER BY wif_id;. For a comprehensive audit report showing student details alongside their modeled scenarios, a join to IGS_DA_REQ_STDNTS and student tables would be necessary. System processes use this table's data to trigger the degree audit engine, which evaluates the proposed program against completed and planned coursework.

Related Objects

IGS_DA_REQ_WIF is centrally connected to several key tables via foreign key constraints, forming the core of the what-if request structure. Its primary relationship is with IGS_DA_RQST (via BATCH_ID), which holds the overarching request metadata. It also has a direct foreign key relationship with IGS_DA_REQ_STDNTS, linking each scenario to the specific students for whom it was generated. For academic context, it references IGS_PS_COURSE to validate the program code and IGS_CA_INST_ALL to define the governing catalog calendar instance. These relationships ensure referential integrity and enable the assembly of complete what-if analysis records.