Search Results dsp_version_number




Overview
Explore in AI Chat

Overview

IGS_AS_SU_STMPTOUT_MID is a reporting-oriented database view in the Oracle EBS Student System (IGS) product family. The name and adjacent objects associate it with the Student Transfer/Outcome extract or "stamp out" process, which surfaces student grade, outcome, and enrollment context for downstream reporting and integration. The "MID" suffix indicates it is an intermediate staging view, typically populated during a multi-step program that transforms raw academic outcome records into a flattened, presentation-ready result set.

The view is documented as not implemented in the reference database, and it belongs to the IGS - Student System (Obsolete) module. This designation reflects that the Student System was superseded by Oracle Student Cloud and the older IGS schema is no longer actively supported in current releases. Consequently, the view exists primarily as a legacy artifact and appears in EBS 12.1.1 and 12.2.2 installations that still carry the historical IGS schema. When a user searches for the column name dsp_context_block_name, the result points directly to this view, where that column is an aliased attribute rather than an underlying base column.

Underlying Base Objects

The view text joins a primary outcome table to several supporting person, enrollment, course, unit, and lookup objects:

The documentation lists no referenced base objects, so the join integrity and cardinality must be inferred from the SELECT statement itself. Note the person join uses an OR condition with a null-safe fallback, and the lookup join on sex is present.

Key Columns

Common Use Cases and Queries

The view is typically queried in academic reporting extracts, grade validation reports, and reconciliation between outcome records and person demographics. A basic query retrieving finalized outcomes for a student:

  • SELECT person_number, dsp_context_block_name, course_cd, unit_cd, grade, outcome_dt FROM igs_as_su_stmptout_mid WHERE finalised_outcome_ind = 'Y';
  • Filtering by calendar instance and course to support a cohort extract: WHERE cal_type = :cal AND ci_sequence_number = :seq.
  • Joining back to IGS_AS_SU_STMPTOUT on ROW_ID to reconcile staged values against the source table.

Because the object is obsolete and not implemented in current databases, these queries should be treated as migration or historical-audit aids rather than targets for new development.