Search Results igs_da_rqst




Overview
Explore in AI Chat

Overview

The IGS_DA_RQST table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for the Degree Audit functionality. As the parent table for storing all degree audit requests, it serves as the primary transactional record for initiating and tracking the process of evaluating a student's academic progress against program requirements. Its role is central to the operational workflow of degree auditing, acting as the anchor point from which related batch processing, student details, and audit features are managed. The table's validity across both EBS 12.1.1 and 12.2.2 versions confirms its established and consistent role in the application architecture.

Key Information Stored

The table's primary key is the BATCH_ID, which uniquely identifies each distinct degree audit request batch. According to the provided foreign key relationships, other critical columns include REQUEST_TYPE_ID, which links to the IGS_DA_CNFG_REQ_TYP table to define the nature of the audit request. The PERSON_ID column establishes a relationship with the HZ_PARTIES table, identifying the individual student for whom a single audit is requested. For batch operations involving multiple students, the PERSON_ID_GROUP_ID column links to the IGS_PE_PERSID_GROUP_ALL table, which defines the specific group of persons. The structure indicates that a single request batch can be associated with either an individual student or a predefined group.

Common Use Cases and Queries

This table is primarily accessed for generating audit reports, monitoring batch request statuses, and troubleshooting the degree audit process. A common reporting use case involves joining IGS_DA_RQST with related detail tables to get a comprehensive view of a request. For example, to list all audit requests for a specific student, one might query: SELECT rqst.BATCH_ID, rqst.REQUEST_TYPE_ID FROM IGS.IGS_DA_RQST rqst WHERE rqst.PERSON_ID = <STUDENT_PARTY_ID>;. For batch processing analysis, administrators may join IGS_DA_RQST with IGS_DA_REQ_STDNTS to correlate the batch header with its detailed list of students. Another critical use case is data validation, ensuring that request batches have corresponding configuration and student data by checking the integrity of its foreign key relationships.

Related Objects

The IGS_DA_RQST table has extensive relationships within the Degree Audit subsystem. It is the parent table referenced by several key child tables that store specific request details: IGS_DA_REQ_STDNTS (for student lists), IGS_DA_REQ_FTRS (for audit features), IGS_DA_REQ_WIF (for "What-If" analyses), and IGS_DA_REQ_WIFPRGS (for "What-If" program details). Its primary key, BATCH_ID, is a foreign key in these tables. Furthermore, it references master data tables: IGS_DA_CNFG_REQ_TYP for request type configuration, HZ_PARTIES for student party information, and IGS_PE_PERSID_GROUP_ALL for student groups. The IGS_DA_REQ_BATCH table also references IGS_DA_RQST, suggesting a potential hierarchical or status-tracking relationship within the batch request lifecycle.