Results for “igs_da_out_prg_ref”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_DA_OUT_PRG_REF is a table within the Oracle E-Business Suite IGS (Student System) product family, historically associated with the Degree Audit functionality. Its documented purpose is to store outgoing information about program references for programs identified for students during a Degree Audit Request. In practical terms, it captures the association between a degree audit output batch, a specific student, and the individual program references that were evaluated and returned as part of that audit run. The table belongs to a product designation marked obsolete in the ETRM metadata, and the implementation note states it is not implemented in the current database, meaning it is documented for historical or upgrade reference only.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table functions primarily as a descriptive satellite attached to a parent hub or link, holding attribute detail and contextual codes rather than acting as an independent hub of business entities. The composite primary key and the presence of a parallel unique index reinforce the parent-dependent nature of the records.

Key Information Stored

The table is documented with ten physical columns. The most significant are the following:

• BATCH_ID — Identifies the degree audit output batch to which the program reference belongs. This is the leading column of the primary key and the foreign key that ties the record to the parent output table.
• PERSON_ID — Identifies the student for whom the program reference was collected during the audit request.
• PROGRAM_SEQ_NUM — Sequence number distinguishing multiple programs found for the same student within the batch.
• PROGRAM_REF_CODE_TYPE — Classification of the program reference, indicating the category or context in which the reference applies.
• PROGRAM_REF_CODE — The specific reference code value associated with the program.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each row and when.

The surrogate primary key is IGS_DA_OUT_PRG_REF_PK, composed of BATCH_ID, PERSON_ID, PROGRAM_SEQ_NUM, PROGRAM_REF_CODE_TYPE, and PROGRAM_REF_CODE. The unique index IGS_DA_OUT_PRG_REF_U1 mirrors this same column set, confirming that the composite of these five columns is the business-key candidate for uniqueness. Notably, the table carries no independent surrogate identifier beyond this composite; the business key and primary key are effectively the same.

Common Use Cases and Queries

The primary use case is auditing and reconstructing the program references produced for a given student within a degree audit batch. Reporting queries typically join to the parent output table using the shared composite columns rather than the leading column alone, since the foreign key spans BATCH_ID, PERSON_ID, and PROGRAM_SEQ_NUM.

A representative query pattern retrieves all program references for a batch:

• SELECT * FROM IGS_DA_OUT_PRG_REF WHERE BATCH_ID = :batch_id;
• Joining to the parent table: SELECT a.*, b.* FROM IGS_DA_OUT_PRG_REF a, IGS_DA_OUT_PRG b WHERE a.BATCH_ID = b.BATCH_ID AND a.PERSON_ID = b.PERSON_ID AND a.PROGRAM_SEQ_NUM = b.PROGRAM_SEQ_NUM;

Additional scenarios include filtering by PROGRAM_REF_CODE_TYPE to analyze the distribution of reference categories across a cohort, and grouping by PERSON_ID to count references per student. Because the product is obsolete, these patterns are most relevant to migration, archival analysis, or historical troubleshooting during upgrades.

Related Objects

The dominant relationship is with the parent output table, which owns the referenced keys:

• IGS_DA_OUT_PRG — Parent table; IGS_DA_OUT_PRG_REF.BATCH_ID references IGS_DA_OUT_PRG.BATCH_ID, with PERSON_ID and PROGRAM_SEQ_NUM completing the foreign key relationship.
• IGS_DA_OUT_PRG_REF_PK / IGS_DA_OUT_PRG_REF_U1 — Primary key constraint and unique business-key index on the same five columns.

Additional dependent objects are not enumerated in the supplied metadata; the documented relationship set is limited to the parent IGS_DA_OUT_PRG table. Any Degree Audit concurrent programs or extract views that consumed these references would logically depend on this table, but the ETRM excerpt identifies only the primary and foreign key structures. Given the obsolete status, administrators should treat the table as read-only historical data referenced principally through the parent output table relationship.