Search Results igs_da_in_rslt_unts




Overview
Explore in AI Chat

Overview

The IGS_DA_IN_RSLT_UNTS table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the Degree Audit functionality. Its primary role is to serve as an intermediary staging table for processing external degree audit results. When a degree audit request is processed by an external, third-party system, the resulting unit-level details for each student are transmitted back to Oracle EBS and stored in this table. This design facilitates the integration of specialized audit engines with the core student records, enabling the system to capture, review, and potentially apply detailed unit completion information as part of a student's academic progress evaluation.

Key Information Stored

The table stores granular unit information resulting from an external degree audit. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical structure. The primary identifier is the RSLT_UNIT_ID. Each record is explicitly linked to a specific student audit request via the foreign key columns BATCH_ID and PERSON_ID, which reference the IGS_DA_REQ_STDNTS table. Typically, such a table would also contain columns to identify the academic unit (e.g., unit code, version), the student's result or status for that unit (e.g., passed, planned, in-progress), and potentially credit information, applicability toward specific requirements, and a timestamp for the received data.

Common Use Cases and Queries

The primary use case is the post-processing of externally calculated degree audits. Administrators or batch processes query this table to review, validate, and reconcile unit-level audit results before finalizing them in the student's academic record. Common reporting involves listing all resulting units for a specific audit request or identifying units with a particular status across multiple audits. A typical query pattern would join this table to the student request table to provide context.

  • Sample Query: SELECT r.* FROM igs.igs_da_in_rslt_unts r, igs.igs_da_req_stdnts s WHERE r.batch_id = s.batch_id AND r.person_id = s.person_id AND s.request_number = '12345';
  • Reporting Use Case: Generating a detailed report for an advisor showing every unit the external audit engine considered for a student, along with the determined status for each program requirement.

Related Objects

The table maintains a direct and critical foreign key relationship with the IGS_DA_REQ_STDNTS table, which stores the header-level information for each student's degree audit request. This relationship ensures data integrity, tethering every resulting unit record to a specific originating request.

  • Primary Key: IGS_DA_IN_RSLT_UNTS_PK on column RSLT_UNIT_ID.
  • Foreign Key (References): The table IGS_DA_IN_RSLT_UNTS references IGS_DA_REQ_STDNTS using the composite foreign key columns (BATCH_ID, PERSON_ID).

This table is likely referenced by various Degree Audit inquiry forms, reconciliation workflows, and potentially by interfaces that load the finalized audit results into the core student academic history.