Search Results igs_av_stnd_alt_unit

Overview

The table IGS_AV_STND_ALT_UNIT is a core data structure within the Oracle E-Business Suite Student System (IGS) for managing academic standards and prerequisites. It functions as a junction table that defines permissible alternative units for a specified precluded unit within a student's academic program or study plan. Its primary role is to enforce and record substitution rules, ensuring that when a standard unit is unavailable or precluded, the system can validate an approved alternate unit for credit. This supports flexible academic progression and advanced standing configurations in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores the relationship between a precluded unit and its valid substitutes. The primary key is a composite of three columns, which uniquely identifies each alternative unit record. The AV_STND_UNIT_ID column is a foreign key linking back to the primary precluded unit definition in the IGS_AV_STND_UNIT_ALL table. The ALT_UNIT_CD and ALT_VERSION_NUMBER columns together form a foreign key relationship to the IGS_PS_UNIT_VER_ALL table, precisely identifying the specific unit code and version number that can serve as the approved alternative. This structure ensures referential integrity for all substitution rules.

Common Use Cases and Queries

A primary use case is during the unit enrollment or advanced standing application process, where the system checks if a student's requested unit substitution is valid. Administrators may also query this table to audit or report on the configured substitution rules for a program. A typical query would join to the unit version tables to retrieve meaningful descriptions. For example, to list all alternate units for a specific precluded standard unit ID:

• SELECT alt.alt_unit_code, alt.alt_version_number, uv.unit_name FROM igs_av_stnd_alt_unit alt, igs_ps_unit_ver_all uv WHERE alt.av_stnd_unit_id = :p_stnd_unit_id AND alt.alt_unit_cd = uv.unit_cd AND alt.alt_version_number = uv.version_number;

Another common pattern is validating a proposed substitution by checking for the existence of a record matching the standard unit ID, proposed alternate code, and version.

Related Objects

The table maintains defined foreign key relationships with two critical tables in the Student System schema, as documented in the ETRM metadata:

• IGS_AV_STND_UNIT_ALL: This is the parent table for the precluded unit definition. The relationship is enforced via the column IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID, which references IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID.
• IGS_PS_UNIT_VER_ALL: This table stores the master details of all unit versions. The relationship is a composite foreign key where IGS_AV_STND_ALT_UNIT.ALT_UNIT_CD and IGS_AV_STND_ALT_UNIT.ALT_VERSION_NUMBER reference the corresponding columns in IGS_PS_UNIT_VER_ALL, ensuring the alternate unit is a valid, active offering.