Search Results igs_da_out_prg




Overview
Explore in AI Chat

Overview

The IGS_DA_OUT_PRG table is a core data repository within the Oracle E-Business Suite Student System (IGS) module, specifically designed for the Degree Audit functionality. It serves as the primary storage entity for processed degree audit results pertaining to a student's academic program. When a degree audit request is submitted and processed by the system, the detailed outcome for each of the student's declared or requested academic programs is persisted in this table. Its role is critical for maintaining a historical and current record of audit evaluations, enabling reporting, transcript generation, and academic advising within the EBS ecosystem for versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each program record within the context of a specific audit request for a student. The key columns are BATCH_ID, which links to the originating degree audit request batch; PERSON_ID, identifying the student; and PROG_SEQ_NUM, a sequence number differentiating between multiple programs associated with the same audit request. While the provided metadata does not list all column details, the table logically stores the evaluated status of program requirements, such as completion progress, remaining credits, and overall program standing based on the audit rules engine. The foreign key relationship to IGS_DA_REQ_STDNTS ensures data integrity by tethering each program result to a valid student audit request.

Common Use Cases and Queries

This table is central to post-audit reporting and inquiry. A common use case is generating a detailed degree audit report for an advisor or student, which would join IGS_DA_OUT_PRG with related detail tables (like IGS_DA_OUT_PRG_CGRY for categories) to list all requirements. Another scenario involves identifying students who have completed a specific program requirement by analyzing the stored audit results. A typical reporting query would follow this pattern:

  • SELECT prg.* FROM igs.igs_da_out_prg prg JOIN igs.igs_da_req_stdnts req ON prg.batch_id = req.batch_id AND prg.person_id = req.person_id WHERE req.request_date > SYSDATE - 30;

This retrieves all program-level audit results from requests made in the last 30 days, forming the basis for compliance or trend analysis.

Related Objects

IGS_DA_OUT_PRG sits at the center of a hierarchy of degree audit output tables. It is a child of the IGS_DA_REQ_STDNTS table, which stores the header-level request information. Crucially, it acts as a parent to several detail tables that store granular audit results, as documented by the foreign key relationships. These include:

  • IGS_DA_OUT_PRG_CGRY: Stores results for specific requirement categories (e.g., Major, General Education) within a program. Joins via BATCH_ID, PERSON_ID, and PROGRAM_SEQ_NUM.
  • IGS_DA_OUT_PRG_REF: Likely stores referenced or exception data related to the program audit. Joins via the same key columns.
  • IGS_DA_OUT_PRG_USET: Presumably stores results for unit sets or sub-plans within the program. Joins via BATCH_ID, PERSON_ID, and PROGRAM_SEQ_NUM.

This structure allows the system to decompose a full degree audit result from the program level down to individual requirements.