Search Results igs_da_req_stdnts




Overview
Explore in AI Chat

Overview

The IGS_DA_REQ_STDNTS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for the Degree Audit functionality. It serves as the central repository for identifying the specific students associated with a given Degree Audit request. In the context of EBS 12.1.1 and 12.2.2, a Degree Audit is a critical process that evaluates a student's academic progress against the requirements of a program or degree. This table links a batch request (BATCH_ID) to one or more students (PERSON_ID), establishing the foundational relationship upon which all audit input data is gathered and all output results are generated. It is a transactional table that enables both batch and individual student audit processing.

Key Information Stored

The table's primary purpose is to map students to audit requests. Its most critical columns, as inferred from the foreign key relationships, are BATCH_ID and PERSON_ID. The BATCH_ID links the record to the parent request in the IGS_DA_RQST table, while PERSON_ID identifies the student within the system. The table also includes a surrogate primary key, IGS_DA_REQ_STDNTS_ID. Furthermore, it stores codes for specific program scenarios within an audit, notably WIF_PROGRAM_CODE (What-If program) and SPECIAL_PROGRAM_CODE, which are foreign keys to the IGS_PS_COURSE table. This allows the audit to be run against standard, proposed, or special program paths for the student.

Common Use Cases and Queries

This table is essential for any process involving the execution or reporting of Degree Audits. Common use cases include identifying all students processed in a particular audit batch, troubleshooting audit results for a specific student, and generating lists of students who have had audits run against alternative programs. A fundamental query pattern involves joining to the main request table and person/student tables to provide context.

  • List Students in a Batch: SELECT person_id FROM igs_da_req_stdnts WHERE batch_id = :p_batch_id;
  • Find Audit Requests for a Student: SELECT rqst.* FROM igs_da_rqst rqst JOIN igs_da_req_stdnts std ON rqst.batch_id = std.batch_id WHERE std.person_id = :p_person_id;
  • Audit Reporting Context: Most reports on audit output (e.g., IGS_DA_OUT_STDNT, IGS_DA_OUT_PRG) will join through this table using both BATCH_ID and PERSON_ID to connect results to the specific student and request.

Related Objects

The IGS_DA_REQ_STDNTS table is a central hub with extensive relationships, primarily as the referenced table in foreign keys from numerous Degree Audit input and output tables. This design ensures data integrity by tying all audit details to a valid student-request combination.

All related output tables join on the composite key of BATCH_ID and PERSON_ID, demonstrating this table's role as the definitive source for valid student-and-request combinations within the Degree Audit subsystem.