Search Results applied_course_cd

Overview

The IGS_AV_UNT_REF_CDS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Integrated Global Systems) or student system modules. It functions as a junction table that manages the association between Advanced Standing Units and institution-defined reference codes. An Advanced Standing Unit typically represents credit granted for prior learning or experience. This table's primary role is to store which specific reference codes, such as those for accreditation bodies, course equivalencies, or internal classifications, have been linked to a particular unit of advanced standing. This linkage is crucial for tracking, reporting, and auditing the basis upon which academic credit is awarded.

Key Information Stored

The table stores transactional and relational data critical for maintaining the integrity of advanced standing records. The primary key is the system-generated AVU_REFERENCE_CD_ID. The core foreign keys are PERSON_ID, linking to HZ_PARTIES for the student; AV_STND_UNIT_ID, identifying the specific unit of advanced standing; and REFERENCE_CODE_ID, pointing to the institution's defined code. A critical functional column is APPLIED_COURSE_CD, a VARCHAR2 field that specifies the academic program code under which the reference code association is saved. This ensures the context of the credit award is preserved, as a unit may be assessed differently across multiple programs. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and a DELETED_DATE for soft-delete functionality are also present.

Common Use Cases and Queries

A primary use case is generating reports on advanced standing awards for audit or accreditation purposes, showing all reference codes justifying the credit granted. Administrators may query this table to review or modify the justifications linked to a student's specific unit of credit. The non-unique index on APPLIED_COURSE_CD and PERSON_ID (IGS_AV_UNT_REF_CDS_N2) indicates common query patterns for finding all reference code associations for a student within a specific program. A typical reporting query would join to related tables like HZ_PARTIES for student details and the reference code master table.

SELECT  iaurc.person_id,
        iaurc.applied_course_cd,
        iaurc.av_stnd_unit_id,
        iaurc.reference_code_id
FROM igs.igs_av_unt_ref_cds iaurc
WHERE iaurc.deleted_date IS NULL
AND iaurc.person_id = :student_id
AND iaurc.applied_course_cd = :program_code;

Related Objects

Based on the dependency information, this table is central to the Advanced Standing functionality. It is referenced by the APPS synonym IGS_AV_UNT_REF_CDS, which is the standard access point for all EBS application code. While the provided metadata does not list explicit foreign key constraints, the column definitions imply critical relationships. The PERSON_ID column is a foreign key to HZ_PARTIES (the Trading Community Architecture foundation for persons and organizations). The AV_STND_UNIT_ID references the master advanced standing unit table, and REFERENCE_CODE_ID points to the institution's reference code definition table. Queries against IGS_AV_UNT_REF_CDS are typically joined with these tables to resolve IDs into meaningful names and descriptions for reporting and user interfaces.