Search Results igs_da_out_prg_ref




Overview
Explore in AI Chat

Overview

The IGS_DA_OUT_PRG_REF table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the Degree Audit functionality in releases 12.1.1 and 12.2.2. It serves as a transactional repository for outgoing reference information pertaining to academic programs identified for students during a degree audit request processing cycle. Its primary role is to store detailed, coded references associated with programs that have been evaluated, enabling the system to output a comprehensive audit trail and results. This table is integral to the batch-oriented degree audit engine, ensuring that each program reference is persistently linked to its parent audit request and program record for reporting and interface purposes.

Key Information Stored

The table's structure is designed to uniquely identify and categorize program references within the context of a specific audit. The primary key is a composite of five columns, ensuring uniqueness for each reference record. The critical columns include BATCH_ID, PERSON_ID, and PROGRAM_SEQ_NUM, which together foreign-key to the parent IGS_DA_OUT_PRG table, anchoring the reference to a specific program for a specific student in a specific audit batch. The PROGRAM_REF_CODE_TYPE and PROGRAM_REF_CODE columns define the classification and actual value of the reference code itself. Typical data stored in these reference codes could include identifiers linking to external systems, internal categorization codes, or standardized program identifiers used for articulation, accreditation, or reporting.

Common Use Cases and Queries

This table is primarily accessed for generating detailed degree audit reports, troubleshooting audit results, and interfacing program data with external systems. A common use case involves extracting all reference information for programs audited in a particular batch for a set of students. A typical reporting query would join this table to its parent to provide context.

Sample SQL Pattern:
SELECT prg.person_id,
prg.program_cd,
ref.program_ref_code_type,
ref.program_ref_code
FROM igs_da_out_prg_ref ref,
igs_da_out_prg prg
WHERE ref.batch_id = :p_batch_id
AND ref.person_id = prg.person_id
AND ref.batch_id = prg.batch_id
AND ref.program_seq_num = prg.program_seq_num
ORDER BY ref.person_id, ref.program_ref_code_type;

This pattern is fundamental for data extracts, custom report building, and validating the references attached to audited programs before results are published.

Related Objects

The IGS_DA_OUT_PRG_REF table maintains a strict child relationship with a key parent table in the Degree Audit output schema. The documented foreign key relationship is essential for data integrity and query construction.

  • Primary Parent Table: IGS_DA_OUT_PRG
  • Relationship: The IGS_DA_OUT_PRG_REF table references the IGS_DA_OUT_PRG table via a foreign key constraint. The join is performed on the composite key consisting of BATCH_ID, PERSON_ID, and PROGRAM_SEQ_NUM columns. This ensures every program reference record is explicitly tied to a single, specific program outcome record generated by the degree audit engine for a student.

As a child table, IGS_DA_OUT_PRG_REF is typically accessed in conjunction with IGS_DA_OUT_PRG and the root header table IGS_DA_OUT_BATCH to provide a complete hierarchical view of a degree audit's results, from the batch header down to individual program references.