Search Results igs_av_unt_ref_cds

Overview

The IGS_AV_UNT_REF_CDS table is a data object within the Oracle E-Business Suite Student System (IGS), specifically designed to manage advanced standing or credit transfer processes. Its primary role is to store the associations between awarded advanced standing units and standardized reference codes. This linkage provides a structured method for categorizing and reporting on the basis or type of credit granted, such as recognizing prior learning from specific external institutions or programs. The provided metadata explicitly notes this module as "Obsolete," indicating it is part of a legacy Student System architecture that may have been superseded in later implementations or by alternative modules like Oracle Student Management.

Key Information Stored

The table's structure centers on creating and maintaining the relationship between an advanced standing unit record and a reference code. The primary key, AVU_REFERENCE_CD_ID, uniquely identifies each association record. The table's foreign keys reveal its core data columns: AV_STND_UNIT_ID links to the specific advanced standing unit (IGS_AV_STND_UNIT_ALL), REFERENCE_CODE_ID links to the actual reference code definition (IGS_GE_REF_CD), and PERSON_ID combined with APPLIED_COURSE_CD links to the student's program attempt record (IGS_EN_STDNT_PS_ATT_ALL). This design ensures that every reference code association is tied to a specific unit award for a particular student in a given course of study.

Common Use Cases and Queries

A primary use case is generating audit or compliance reports detailing the rationale for advanced standing awards across a student population. Administrators can query this table to list all credit transfers categorized under a specific reference code, such as "Articulation Agreement with College X." A typical reporting query would join the student, unit, and reference code tables. For troubleshooting or data validation, a DBA might run a query to identify orphaned records where the foreign key relationships are broken, which is particularly relevant given the module's obsolete status.

• Sample Query: SELECT s.student_number, au.unit_cd, rc.reference_cd_description FROM igs_av_unt_ref_cds urc JOIN igs_av_stnd_unit_all au ON urc.av_stnd_unit_id = au.av_stnd_unit_id JOIN igs_ge_ref_cd rc ON urc.reference_code_id = rc.reference_code_id WHERE rc.reference_cd_type = 'CREDIT_TRANSFER_TYPE';

Related Objects

The IGS_AV_UNT_REF_CDS table is a junction table with defined foreign key relationships to three core tables in the legacy Student System, as documented in the metadata.

• IGS_AV_STND_UNIT_ALL: Linked via the AV_STND_UNIT_ID column. This is the parent table for the awarded advanced standing unit details.
• IGS_GE_REF_CD: Linked via the REFERENCE_CODE_ID column. This table stores the master list of generic reference codes and their descriptions.
• IGS_EN_STDNT_PS_ATT_ALL: Linked via the composite foreign key of PERSON_ID and APPLIED_COURSE_CD. This table contains the student's program attempt record, providing the context of the course for which the advanced standing was applied.

The primary key constraint IGS_AV_UNT_REF_CDS_PK enforces uniqueness on the AVU_REFERENCE_CD_ID column. Crucially, the metadata states this table is "Not implemented in this database," suggesting it may exist in the data dictionary but not be populated or actively used in a given instance.