Search Results igs_ad_unit_sets_v

Overview

IGS_AD_UNIT_SETS_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product. It is classified as a VALID database object and functions as a denormalized reporting layer over the IGS admissions unit set data model. The view joins the transactional unit set assignment table, IGS_AD_UNIT_SETS, to the unit set definition table, IGS_EN_UNIT_SET, so that consumers can retrieve admissions-related unit set assignments together with descriptive information in a single query.

In the EBS 12.1.1 and 12.2.2 architectures, views of this type serve as the supported interface for reporting, concurrent programs, and integration extracts. Rather than requiring developers to reconstruct the join between the unit set assignment and its definition, the view exposes a stable, pre-joined result set. It is typically consumed by admissions reporting, applicant records, and operational data extracts. Because it returns a ROW_ID column derived from the underlying base table, it is also suitable for use in treat-as-rows style operations supported by EBS frameworks.

Underlying Base Objects

Although the ETRM metadata records no separately documented referenced base objects, the view definition embedded in the object record identifies two base tables. The primary table is IGS_AD_UNIT_SETS, aliased AUS, which supplies the admission-specific assignment rows. The lookup table is IGS_EN_UNIT_SET, aliased EUS, which supplies the descriptive title and the unit set version definition.

The join is performed on two columns that together form the natural key of the unit set definition: UNIT_SET_CD and VERSION_NUMBER. This composite join means the view returns the unit set title only when a matching definition exists for both the code and the version recorded on the assignment. Consequently, rows in IGS_AD_UNIT_SETS that reference an undefined or unversioned unit set code will not be returned, and the view behaves as an inner join rather than an outer join. The ROW_ID column is generated from AUS.ROWID, anchoring the view to the IGS_AD_UNIT_SETS physical row.

Key Columns

• ROW_ID — The ROWID of the underlying IGS_AD_UNIT_SETS row; useful for row-level identification and treat-as-rows processing.
• UNIT_SET_ID — The unique identifier of the admissions unit set assignment record.
• PERSON_ID — The party identifier of the applicant or person associated with the unit set.
• ADMISSION_APPL_NUMBER — The admission application number linking the record to a specific application.
• NOMINATED_COURSE_CD — The course code nominated or selected in the application context.
• SEQUENCE_NUMBER — Ordering attribute for multiple unit sets within the same application.
• UNIT_SET_CD — The code identifying the unit set.
• VERSION_NUMBER — The version of the unit set definition used for the join.
• TITLE — The descriptive title sourced from IGS_EN_UNIT_SET; the principal denormalized attribute provided by the view.
• RANK — The ranking or priority assigned to the unit set in the admissions context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns inherited from IGS_AD_UNIT_SETS.

Common Use Cases and Queries

Typical usage centers on retrieving an applicant's unit sets with readable titles. The view removes the need to hand-code the code-and-version join, and it supports filters on person, application, nominated course, or unit set. A representative query follows.

• List all unit sets for a person: SELECT unit_set_cd, version_number, title, rank FROM igs_ad_unit_sets_v WHERE person_id = :p_person_id ORDER BY sequence_number;
• Locate unit sets for an application: SELECT admission_appl_number, unit_set_cd, title FROM igs_ad_unit_sets_v WHERE admission_appl_number = :p_appl_number;
• Report by nominated course: SELECT nominated_course_cd, unit_set_cd, title, COUNT(*) FROM igs_ad_unit_sets_v GROUP BY nominated_course_cd, unit_set_cd, title;
• Audit recently changed assignments: SELECT unit_set_id, unit_set_cd, title, last_updated_by, last_update_date FROM igs_ad_unit_sets_v WHERE last_update_date >= :p_since;

Because the view is an inner join, users should confirm that a valid IGS_EN_UNIT_SET definition exists for the code and version before relying on the TITLE column. When unit sets appear in IGS_AD_UNIT_SETS but are absent from this view, the missing version definition is the usual cause.