Search Results igs_da_req_wif




Overview
Explore in AI Chat

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.

  • Table: IGS_DA_REQ_WIF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_WIF,  object_name:IGS_DA_REQ_WIF,  status:VALID,  product: IGS - Student System ,  description: This table holds program and unit set details for a what-if request ,  implementation_dba_data: IGS.IGS_DA_REQ_WIF , 

  • View: IGS_DA_XML_SUBPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_SUBPROGRAM_V,  object_name:IGS_DA_XML_SUBPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element SubProgramType (child of AcademicProgram). Returns the Major(s), Minor(s), and Track(s) of the Academic Program. ,  implementation_dba_data: APPS.IGS_DA_XML_SUBPROGRAM_V , 

  • Table: IGS_DA_RQST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_RQST,  object_name:IGS_DA_RQST,  status:VALID,  product: IGS - Student System ,  description: Parent table for storage of all Degree Audit Requests made. ,  implementation_dba_data: IGS.IGS_DA_RQST , 

  • View: IGS_DA_REQ_WIF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_REQ_WIF_V,  object_name:IGS_DA_REQ_WIF_V,  status:VALID,  product: IGS - Student System ,  description: View over Degree Audit What-if Request ,  implementation_dba_data: APPS.IGS_DA_REQ_WIF_V , 

  • Table: IGS_PS_COURSE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_COURSE,  object_name:IGS_PS_COURSE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_COURSE , 

  • Table: IGS_DA_REQ_STDNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_STDNTS,  object_name:IGS_DA_REQ_STDNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for the Students that the Degree Audit Request is for. ,  implementation_dba_data: IGS.IGS_DA_REQ_STDNTS , 

  • View: IGS_DA_XML_ACADEMICPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_ACADEMICPROGRAM_V,  object_name:IGS_DA_XML_ACADEMICPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element AcademicProgramSub view indexed by Degree Program view Provides the provides the DA specified program information "SPA" -- Students Selected Degree Program "WIF" -- What-if Program "SPECIAL" -- Special Program ,  implementation_dba_data: APPS.IGS_DA_XML_ACADEMICPROGRAM_V , 

  • Table: IGS_CA_INST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_INST_ALL,  object_name:IGS_CA_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes an instance of a calendar type ,  implementation_dba_data: IGS.IGS_CA_INST_ALL ,