Search Results igs_av_stnd_alt_unit_v

Overview

IGS_AV_STND_ALT_UNIT_V is an Oracle E-Business Suite seeded database view owned by the APPS schema within the IGS (Student System) product family. It exposes Advanced Standing alternative unit data, combining the parent advanced standing unit record with any associated alternative unit mappings. The view presents a denormalized, read-only projection that is intended for reporting, inquiry, and integration purposes rather than for direct transactional maintenance. Because it joins a child alternative-unit table to its parent unit table, consumers are spared from reconstructing the relationship manually. In Oracle EBS 12.1.1 and 12.2.2, the view conforms to standard APPS object conventions, carrying the WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus the ROW_ID pseudocolumn, which allows downstream tools and forms to reference rows uniquely. The view is central to functions that determine which alternative units may satisfy an advanced standing requirement, and it surfaces the AS_COURSE_CD and AS_VERSION_NUMBER context for the parent advanced standing unit.

Underlying Base Objects

The view is defined as an equijoin between two Student System base tables:

• IGS_AV_STND_UNIT (alias ASU) — the parent advanced standing unit table, supplying PERSON_ID, AS_COURSE_CD, AS_VERSION_NUMBER, S_ADV_STND_TYPE, UNIT_CD, VERSION_NUMBER, and the primary key AV_STND_UNIT_ID.
• IGS_AV_STND_ALT_UNIT (alias ASAU) — the child alternative unit table, supplying ALT_UNIT_CD, ALT_VERSION_NUMBER, OPTIONAL_IND, AV_STND_UNIT_ID, and the WHO audit columns.

The join predicate is ASU.AV_STND_UNIT_ID = ASAU.AV_STND_UNIT_ID, making the parent table the driving side and the alternative-unit table the detail side. One parent advanced standing unit may therefore yield multiple rows in the view, one for each alternative unit configured against it. The ROW_ID column is derived from ASAU.ROWID, meaning each returned row is addressable at the child-table level. ETRM metadata documents no additional referenced objects beyond these two tables; no synonyms, external tables, or packaged function calls are involved in the view text.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_AV_STND_ALT_UNIT row, useful for unique row identification.
• PERSON_ID — the person (student) to whom the advanced standing unit belongs.
• AS_COURSE_CD — the course code associated with the advanced standing unit; this is the column most frequently targeted when users search for "as_course_cd".
• AS_VERSION_NUMBER — the version of the advanced standing course.
• S_ADV_STND_TYPE — the advanced standing type classification.
• UNIT_CD / VERSION_NUMBER — the parent unit code and version that the advanced standing is defined against.
• ALT_UNIT_CD / ALT_VERSION_NUMBER — the alternative unit code and version that may substitute for or satisfy the parent unit requirement.
• OPTIONAL_IND — indicates whether the alternative unit is optional.
• AV_STND_UNIT_ID — the foreign key linking the alternative unit back to its parent advanced standing unit.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include verifying which alternative units are configured for a given advanced standing unit, auditing optional flags, and integrating advanced standing rules into external systems. A common query filters by course code:

SELECT as_course_cd, unit_cd, alt_unit_cd, optional_ind
FROM   apps.igs_av_stnd_alt_unit_v
WHERE  as_course_cd = :p_course_cd;

To retrieve all alternatives for a specific person:

SELECT person_id, as_course_cd, unit_cd, alt_unit_cd
FROM   apps.igs_av_stnd_alt_unit_v
WHERE  person_id = :p_person_id;

Because the view is read-only and joins two base tables, ensure appropriate IGS grants and MOAC operating unit context are applied when querying from a custom concurrent program or BI Publisher report.