Search Results igs_da_req_wifmnrs_pk

Overview

IGS_DA_REQ_WIFMNRS is a transactional table in the Oracle E-Business Suite Student System (IGS) product family. It stores the What-If Minor selections associated with a degree audit request submitted for a student. When an advisor or student runs a "What-If" degree audit to project progress against an alternative program configuration, the minor components of that hypothetical scenario are persisted in this table. The metadata explicitly constrains the scope of the data: records are only permitted for Single Request Types and never for Batch Request Types, which means the table functions as a per-student, on-demand audit artifact rather than a bulk-processing staging structure.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure identifies this object as standalone. In practice, this suggests the table can be modeled as an isolated satellite or a link-free entity that hangs off the parent degree audit request, rather than participating in a broad hub-and-link web. The absence of outgoing foreign keys reinforces that the table is a dependent detail record whose lifecycle is anchored to its request header.

Key Information Stored

The table comprises 16 documented columns. The surrogate primary key is defined by the constraint IGS_DA_REQ_WIFMNRS_PK on the column PRIMARY_SEQ_NUM, which uniquely identifies each What-If minor row regardless of its parent request. This surrogate is distinct from the documented business-key candidates:

• PRIMARY_SEQ_NUM — surrogate primary key (IGS_DA_REQ_WIFMNRS_PK and unique index U1).
• BATCH_ID — identifier of the originating degree audit request context; part of the U2 unique key.
• PROGRAM_CODE — the academic program against which the What-If scenario is evaluated; part of U2.
• MINOR_SEQ_NUM — sequence number ordering the minor within the request; part of U2.
• MAJOR_SEQ_NUM — sequence number ordering the associated major; part of U2.
• MINOR_UNIT_SET, MINOR_VERSION, MINOR_CATALOG, MINOR_CAL_TYPE, MINOR_CI_SEQ_NUM — the full calendar/catalog context that identifies the specific minor version being tested.
• ORG_UNIT_MINOR — the organizational unit (typically the department or school) offering the minor.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns tracking record provenance.

The composite unique index IGS_DA_REQ_WIFMNRS_U2 (BATCH_ID, PROGRAM_CODE, MINOR_SEQ_NUM, MAJOR_SEQ_NUM) enforces that a given major/minor combination appears at most once per program within a request.

Common Use Cases and Queries

Typical use cases include reconstructing a What-If audit run for audit trail purposes, validating which minors were evaluated for a student, and reporting on demand for alternative minor scenarios. A representative query retrieves all What-If minors for a given request:

• SELECT MINOR_SEQ_NUM, MAJOR_SEQ_NUM, PROGRAM_CODE, MINOR_VERSION, MINOR_CATALOG, ORG_UNIT_MINOR FROM IGS_DA_REQ_WIFMNRS WHERE BATCH_ID = :p_batch_id ORDER BY MAJOR_SEQ_NUM, MINOR_SEQ_NUM;
• A reporting join on PROGRAM_CODE and MINOR_CATALOG against the catalog version tables to resolve minor titles; and a count query grouped by ORG_UNIT_MINOR to profile the distribution of requested minor evaluations.

Because the table is restricted to Single Request Types, downstream reports should not expect rows generated by batch degree audit processes.

Related Objects

The table is referenced by its parent degree audit request structures through the BATCH_ID and PROGRAM_CODE columns, and depends on catalog/version definition tables to resolve the minor identifiers:

• IGS_DA_REQ_WIFMNRS_PK / U1 / U2 — the primary and unique constraints that govern row identity.
• The degree audit request header (referenced via BATCH_ID) that owns each What-If minor selection.
• Program definition tables joined on PROGRAM_CODE for program descriptions.
• Minor catalog and version tables joined on MINOR_CATALOG, MINOR_VERSION, MINOR_CAL_TYPE and MINOR_CI_SEQ_NUM.
• Organizational unit tables joined on ORG_UNIT_MINOR to resolve the offering department.

These relationships confirm the table's role as a leaf-level, single-request-scoped detail object within the IGS Degree Audit subsystem.