Search Results igs_en_stdnt_ps_intm_v




Overview
Explore in AI Chat

Overview

IGS_EN_STDNT_PS_INTM_V is an APPS-owned database view in the Oracle E-Business Suite Student System (IGS) product family. It exposes consolidated information about student intermissions—approved periods during which a student temporarily suspends study—together with the associated intermission type, institution, and approver details. Because the view joins the core intermission table with reference and party data, it presents a reporting-ready result set that avoids repeating common lookups in downstream queries. In Oracle EBS 12.1.1 and 12.2.2 the view retains a VALID status and continues to be used by Student System forms, concurrent programs, and custom reports that need to display or extract intermission records.

The view is particularly relevant to searches involving the identifier "approver_name," because it exposes both APPROVER_ID (the party identifier) and the resolved APPROVER_NAME taken from HZ_PARTIES. This allows report authors to display the human-readable name of the person who approved a student's intermission without writing an additional join.

Underlying Base Objects

The view is defined over four objects, combined with outer joins so that missing reference data does not suppress the intermission row:

The outer-join conditions ensure that an intermission is still returned when no matching intermission type, approver party, or institution record exists, which is important for audit and exception reporting.

Key Columns

The view surfaces a broad set of columns. Notable ones include:

Common Use Cases and Queries

Typical scenarios include reporting approved intermissions by institution, auditing who approved each record, and extracting intermission data for integration with external student systems.

Listing intermissions with approver names:

  • SELECT person_id, course_cd, intermission_type, approved, approver_name, start_dt, end_dt FROM igs_en_stdnt_ps_intm_v WHERE approved = 'Y';

Filtering by approver:

  • SELECT person_id, course_cd, approver_number, approver_name FROM igs_en_stdnt_ps_intm_v WHERE approver_name = :p_name;

Reporting intermissions within a date range for an institution:

  • SELECT institution_name, intermission_type, description, person_id, start_dt, end_dt FROM igs_en_stdnt_ps_intm_v WHERE start_dt BETWEEN :from_date AND :to_date;