Search Results major_catalog

Overview

APPS.IGS_DA_WIFFTR_V is a reporting view in the Oracle E-Business Suite Higher Education / Student System (IGS) product family, owned by the APPS schema. The IGS_DA_ prefix identifies it as part of the admissions "DA" (data administration / decision assignment) set of objects, and the _V suffix confirms it is a view rather than a base table. In Oracle EBS 12.1.1 and 12.2.2 this view presents "waiting-list / wish-list programme filter" data — the programme, major, minor, and track selections captured against a batch. It denormalises one row per programme/major/track combination, pivoting up to three minor records horizontally, and exposes the tracked minor_version and related catalog/campus attributes. It is consumed by concurrent programs, inline reports, and external integrations that need a single flat row per programme-track-minor combination rather than the normalised child rows.

Underlying Base Objects

The ETRM metadata records no documented base objects, but the view text identifies four underlying IGS tables joined together:

• IGS_DA_REQ_WIFPRGS pr — programme-level wish/filter rows; supplies batch_id, program_code, program_version.
• IGS_DA_REQ_WIFMJRS mj — major sequence rows; supplies major_seq_num, major_unit_set, major_version, major_catalog, org_unit_major, major_cal_type, major_ci_seq_num.
• IGS_DA_REQ_WIFMNRS mn1/mn2/mn3 — minor sequence rows, self-joined three times with minor_seq_num = 1, 2 and 3, using outer joins so a programme-track with fewer than three minors still returns rows.
• IGS_DA_REQ_WIFTRCKS tr — track/option rows; supplies track_seq_num, track_unit_set, track_option_version, track_option_catalog, org_unit_track, track_cal_type, track_ci_seq_num.

All joins are outer, keyed on batch_id and major_seq_num. The view is a UNION of two SELECT statements; the first aliases the minor columns as minor_unit_set1/2/3 without a numeric suffix on minor_version, while the second applies suffixes such as minor_version1, minor_catalog1 and minor_ci_seq_num1 to disambiguate the three minor aliases.

Key Columns

• batch_id — identifies the admissions batch to which all rows belong; primary grouping key.
• program_code / program_version — the programme applied for.
• major_seq_num, major_unit_set, major_version, major_catalog, org_unit_major, major_cal_type, major_ci_seq_num — the major selection.
• track_seq_num, track_unit_set, track_option_version, track_option_catalog, org_unit_track, track_cal_type, track_ci_seq_num — the track/option selection.
• minor_unit_set1..3, minor_version, minor_catalog, org_unit_minor, minor_cal_type, minor_ci_seq_num — the up-to-three minor selections, where minor_version is the version label of the referenced minor.

Common Use Cases and Queries

Typical scenarios include validating that every major has a matching minor, feeding admissions extract files, and reporting on programme/track/minor combinations. A minimal query retrieving rows for a batch, filtered on minor_version, is:

• SELECT batch_id, program_code, major_seq_num, track_seq_num, minor_unit_set1, minor_version, minor_catalog FROM apps.igs_da_wifftr_v WHERE batch_id = :p_batch_id AND minor_version IS NOT NULL;
• SELECT program_code, COUNT(*) FROM apps.igs_da_wifftr_v WHERE batch_id = :p_batch_id GROUP BY program_code; — programme-level tally of selections.

Because the view outer-joins and UNIONs, treat null minors as legitimately absent rather than data errors, and confirm the expected minor_version format for the release in use.