Results for “igs_av_unt_ref_cds”

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

Overview

IGS_AV_UNT_REF_CDS is a table in the IGS (Student System) product of Oracle E-Business Suite, present in both the 12.1.1 and 12.2.2 releases. It resides in the IGS schema and holds the reference codes that have been associated with an advanced standing unit. In institutional terms, this table records the external or internal referencing values — for example, prior-learning bodies, articulation agreements, or awarding organizations — that justify or qualify a unit of advanced standing granted to a student.

Analytically, the recorded foreign-key structure (three outbound references and a single-column surrogate primary key) suggests classifying this object as a link table in a Data Vault modelling sense. It resolves a many-to-many style association between an advanced standing unit, a reference code, and the student/application context rather than storing descriptive attributes about any one of them.

Key Information Stored

The table comprises eleven documented columns. The most operationally significant are:

• AVU_REFERENCE_CD_ID — the surrogate primary key, enforced by the constraint IGS_AV_UNT_REF_CDS_PK. This is the unique identifier for each reference-code association record.
• AV_STND_UNIT_ID — foreign key to IGS_AV_STND_UNIT_ALL, identifying the advanced standing unit to which the reference code applies.
• REFERENCE_CODE_ID — foreign key to IGS_GE_REF_CD, pointing to the reference code definition used in the association.
• PERSON_ID — foreign key to IGS_EN_STDNT_PS_ATT_ALL, tying the record to the student person and application/attempt context.
• APPLIED_COURSE_CD — the applied course code associated with the advanced standing unit and reference code.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording insert and update provenance.
• DELETED_DATE — the soft-delete indicator used to logically retire a record without physical removal.

Business-key candidates are typically the combination of AV_STND_UNIT_ID, REFERENCE_CODE_ID, and APPLIED_COURSE_CD, though the documented metadata designates only AVU_REFERENCE_CD_ID as the enforced unique key.

Common Use Cases and Queries

Typical reporting needs include listing all reference codes attached to a given advanced standing unit, tracing which reference body supports a student's advanced standing, and auditing associations that have been soft-deleted.

A standard join pattern follows the foreign keys:

• Join IGS_AV_UNT_REF_CDS.AV_STND_UNIT_ID to IGS_AV_STND_UNIT_ALL to obtain the unit definition.
• Join REFERENCE_CODE_ID to IGS_GE_REF_CD to resolve the code description.
• Join PERSON_ID to IGS_EN_STDNT_PS_ATT_ALL to retrieve student application details.

A representative query selects the reference code description and applied course code for a specific student, restricting on DELETED_DATE IS NULL to exclude retired rows. Administrators also query this table to validate that every advanced standing unit carries at least one supporting reference code, and to reconcile reference-code usage across articulation agreements.

Related Objects

The most significant related objects are those referenced by the documented foreign keys and those that depend on this table:

• IGS_AV_STND_UNIT_ALL — the parent advanced standing unit table, joined on AV_STND_UNIT_ID.
• IGS_GE_REF_CD — the reference code definition table, joined on REFERENCE_CODE_ID.
• IGS_EN_STDNT_PS_ATT_ALL — the student person/application attempt table, joined on PERSON_ID.
• IGS_AV_UNT_REF_CDS_PK — the primary key constraint enforcing uniqueness of AVU_REFERENCE_CD_ID.
• The IGS advanced standing unit and reference code maintenance forms and concurrent programs that read and write these associations.

These relationships make IGS_AV_UNT_REF_CDS a supporting associative entity within the broader advanced standing and student records model of the IGS Student System.