Search Results minor_unit_set1

Overview

IGS_DA_WIFFTR_V is a reporting view in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to obtain the values that have been chosen for Major, Minor, and Track options within "explore program details" — a mechanism in the IGS prospect/admissions data model that captures what programs, majors, minors, and tracks an applicant or prospect has expressed interest in exploring before formal enrollment.

Within the ETRM metadata for release 12.2.2, the view is classified under an obsolete area of the IGS schema. The metadata explicitly records "Not implemented in this database" for the DBA implementation section, meaning the view is not deployed in every environment and may exist only where the relevant prospect/admissions functionality has been licensed and installed. The view is not a transactional object; it is a read-only presentation layer intended for enquiry screens, self-service pages, or downstream extracts that must display the complete set of chosen major, minor, and track attributes in a single flattened row.

Because the view is specific to the "explore" workflow, it is not part of core curriculum or enrollment processing. Its role is confined to reporting and integration surfaces where a denormalized, one-row-per-program-choice representation is more convenient than joining the underlying requirement tables manually.

Underlying Base Objects

The view is defined over six IGS tables, none of which are documented as referenced base objects in the ETRM metadata. The view text shows:

• IGS_DA_REQ_WIFPRGS PR — the program request header, supplying PROGRAM_CODE, PROGRAM_VERSION, and BATCH_ID.
• IGS_DA_REQ_WIFMJRS MJ — the major request rows, supplying MAJOR_SEQ_NUM and the major unit set, version, catalog, organization unit, calendar type, and calendar instance sequence.
• IGS_DA_REQ_WIFMNRS MN1, MN2, MN3 — three aliases of the same minor request table, each filtered to a distinct minor sequence (1, 2, and 3 respectively) to yield up to three minor selections per row.
• IGS_DA_REQ_WIFTRCKS TR — the track request rows, supplying TRACK_SEQ_NUM and the corresponding track unit set, version, catalog, organization unit, calendar type, and calendar instance sequence.

The join is driven from PR to MJ on BATCH_ID, then outer-joined to the three minor aliases and to the track table on BATCH_ID and MAJOR_SEQ_NUM. The minor aliases are additionally pinned by MINOR_SEQ_NUM (+) = 1, 2, and 3, so each output row represents one major option with its associated minors and track. The full definition is a UNION of two such SELECT statements, which combines the major-driven path with a track-driven path; the excerpt truncates the second branch, and the column aliases in the union's second half (MINOR_VERSION1, MINOR_CATALOG1, ORG_UNIT_MINOR1, MINOR_CAL_TYPE1, and so on) indicate that the two branches are aligned positionally.

Key Columns

• BATCH_ID — the batch identifier that ties the program, major, minor, and track requests together; it is the primary correlation key across all six base tables.
• PROGRAM_CODE, PROGRAM_VERSION — identify the program of study associated with the explore request.
• MAJOR_SEQ_NUM — the sequence number of the chosen major within the batch. This is the column most directly associated with the user search term "major_seq_num" and is the pivot for both the major-to-minor and major-to-track joins.
• MINOR_SEQ_NUM / TRACK_SEQ_NUM — sequence identifiers for minor and track selections. The view's design fixes minor sequences at 1, 2, and 3, so these values are effectively positional rather than open-ended.
• MAJOR_UNIT_SET, MAJOR_VERSION, MAJOR_CATALOG, ORG_UNIT_MAJOR, MAJOR_CAL_TYPE, MAJOR_CI_SEQ_NUM — the full descriptive identity of the major, including the academic calendar and calendar instance under which it is offered.
• MINOR_UNIT_SET1/2/3, MINOR_VERSION, MINOR_CATALOG, ORG_UNIT_MINOR, MINOR_CAL_TYPE, MINOR_CI_SEQ_NUM — the equivalent attributes for up to three minors, denormalized into numbered column groups.
• TRACK_UNIT_SET, TRACK_OPTION_VERSION, TRACK_OPTION_CATALOG, ORG_UNIT_TRACK, TRACK_CAL_TYPE, TRACK_CI_SEQ_NUM — the track option's descriptive attributes.

Common Use Cases and Queries

The view is used when a report or integration must present an applicant's explored major, minor, and track choices as a single flattened record rather than reconstructing the joins from the IGS_DA_REQ_WIF% tables directly.

• Program enquiry screens. Displaying the major and associated minors/tracks captured for a prospect's explore request.
• Admissions extracts. Feeding applicant interest data into downstream CRM or data-warehouse staging tables.
• Data validation. Verifying that major sequence numbers and minor sequence positions were recorded correctly during data entry.

A representative query filters on the batch and major sequence:

SELECT program_code, major_seq_num, minor_unit_set1, minor_unit_set2, minor_unit_set3, track_unit_set FROM igs_da_wifftr_v WHERE batch_id = :p_batch_id AND major_seq_num = :p_major_seq_num;

Because the view is marked obsolete and not implemented universally, callers should confirm its presence in the target environment before relying on it, and should expect it to be absent from environments where the IGS prospect/explore functionality was never installed.