Search Results igs_da_req_wifprgs




Overview
Explore in AI Chat

Overview

The table IGS_DA_REQ_WIFPRGS is a data storage object within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is documented as obsolete. Its specific function is to store "What-If" program information associated with a student's degree audit request. A "What-If" analysis allows academic advisors or students to model how completed and planned coursework would apply to different academic programs or majors. As per its description, this table is designed to hold informational data exclusively for single, ad-hoc degree audit requests and is not intended for use in batch request processing. The metadata explicitly states this table is "Not implemented in this database," indicating it may be a legacy definition not physically instantiated in standard deployments of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure centers on linking a degree audit request to specific academic program codes being evaluated in a What-If scenario. The primary key is a composite of BATCH_ID and PROGRAM_CODE. The BATCH_ID column serves as the foreign key linking back to the parent degree audit request record in the IGS_DA_RQST table. The PROGRAM_CODE column stores the identifier for the academic program being analyzed in the "What-If" simulation. This minimal structure suggests the table acts as a junction, listing all programs under consideration for a given audit request.

Common Use Cases and Queries

The primary use case is supporting the degree audit "What-If" functionality within the Student System. When a user runs a single audit to test progress against alternative programs, this table would log those program selections. Given its informational and single-request nature, common interactions would involve INSERT operations during request creation and SELECT operations for review or reporting. A typical query to retrieve all What-If programs for a specific audit request would be:

  • SELECT PROGRAM_CODE FROM IGS_DA_REQ_WIFPRGS WHERE BATCH_ID = :request_id;

Due to the table's noted non-implementation status, direct operational use or customization in active EBS instances is unlikely. Any reporting on What-If scenarios would need to rely on alternative, implemented tables or views.

Related Objects

IGS_DA_REQ_WIFPRGS has defined relationships with other degree audit tables. Its primary foreign key dependency is on IGS_DA_RQST (Degree Audit Request table) via the BATCH_ID column. Furthermore, it is referenced as a parent table by IGS_DA_REQ_WIFMJRS (Degree Audit Request What-If Majors), which uses a composite foreign key on (BATCH_ID, PROGRAM_CODE). This relationship indicates a hierarchy where a What-If program can have multiple specific majors associated with it for a given audit request. The tight coupling with these tables underscores its role in the broader, now-obsolete, degree audit request data model.