Results for “as_course_cd”

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

Overview

IGS_AV_STND_ALT_UNIT is a Student System (IGS) table in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that records the alternate academic units available in place of a specified precluded standard unit. In the Oracle Student System curriculum model, standard units define the combinations of a student's programme, course, and unit version that are considered equivalent or interchangeable for progression, registration, and completion rules. When one standard unit cannot be taken — for example because it is unavailable in a given term — IGS_AV_STND_ALT_UNIT identifies the sanctioned substitutes the institution will accept.

The table is owned by the IGS schema and is classified VALID in the ETRM dictionary. Applying Data Vault modelling heuristics to the documented foreign-key structure classifies this object as a link: it captures a many-to-many association between a standard unit and an alternate unit version rather than holding descriptive attributes about either party. The physical implementation in 12.1.1 exposes 15 documented columns.

Key Information Stored

The primary key of the table is IGS_AV_STND_ALT_UNIT_PK, composed of AV_STND_UNIT_ID, ALT_UNIT_CD, and ALT_VERSION_NUMBER. AV_STND_UNIT_ID is a surrogate identifier pointing to the parent record in IGS_AV_STND_UNIT_ALL; it should not be confused with the natural business keys of the referenced unit.

The business-key candidates are captured by the unique index IGS_AV_STND_ALT_UNIT_U1, which mirrors the composite primary key on (AV_STND_UNIT_ID, ALT_UNIT_CD, ALT_VERSION_NUMBER). This guarantees that a given alternate unit version is not registered more than once against the same standard unit.

• AV_STND_UNIT_ID — foreign key to IGS_AV_STND_UNIT_ALL, identifying the precluded standard unit.
• ALT_UNIT_CD and ALT_VERSION_NUMBER — foreign key pairing to IGS_PS_UNIT_VER_ALL, identifying the acceptable alternate unit and its version.
• UNIT_CD and VERSION_NUMBER — denormalised unit/version references carried on the record for the standard unit context.
• OPTIONAL_IND — indicates whether the alternate unit is optional rather than mandatory within the alternate set.
• PERSON_ID — links the alternate-unit definition to the person context where a student-specific or staff-authored record applies.
• AS_COURSE_CD and AS_VERSION_NUMBER — identify the associated course version under which the alternate is valid.
• S_ADV_STND_TYPE — the standard/advancement type code governing the rule.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard WHO-column traceability.

Common Use Cases and Queries

The principal use case is alternate-unit substitution checking during enrolment and programme progression. A registrar or student self-service flow can query the table to determine which units may stand in for an unavailable standard unit.

• List the alternates defined for a standard unit:
  SELECT ALT_UNIT_CD, ALT_VERSION_NUMBER, OPTIONAL_IND FROM IGS_AV_STND_ALT_UNIT WHERE AV_STND_UNIT_ID = :p_id;
• Resolve alternate unit descriptions by joining to IGS_PS_UNIT_VER_ALL on ALT_UNIT_CD and ALT_VERSION_NUMBER.
• Reconcile the parent standard unit via a join to IGS_AV_STND_UNIT_ALL on AV_STND_UNIT_ID.
• Report optional versus mandatory alternates for curriculum-review extracts.

Related Objects

Two foreign keys define the core dependencies of this table, and reporting generally requires both joins.

• IGS_AV_STND_UNIT_ALL — the parent standard-unit table; joined via AV_STND_UNIT_ID.
• IGS_PS_UNIT_VER_ALL — the alternate unit version reference; joined via ALT_UNIT_CD and ALT_VERSION_NUMBER.

Because the record is a link, callers should treat IGS_AV_STND_ALT_UNIT as a resolution table, resolved through these two parents rather than queried in isolation.