Search Results primary_program_rank




Overview
Explore in AI Chat

Overview

The view APPS.IGSBV_HIGH_ED_PROG_VERSIONS is a read-only database object in the Oracle EBS Student System (IGS) schema set, exposing higher education program version records for reporting and integration purposes. It presents a consolidated, denormalized projection of program (course) version data, drawing from the underlying program version entity and aliasing native Student System columns into business-friendly names. Because the view is defined WITH READ ONLY, it is intended strictly for query and extraction workloads rather than transactional DML.

The user's search term, supp_exam_perm_indicator, corresponds to a column in this view: the native column SUPP_EXAM_PERMITTED_IND is aliased to SUPP_EXAM_PERM_INDICATOR. This indicator denotes whether a supplementary examination is permitted for the program version, making it relevant in academic policy, examination eligibility, and regulatory reporting contexts.

Underlying Base Objects

The view text documents a single base object: IGS_PS_VER_ALL. This is the all-version program (course) entity in the Student System, encompassing all version records including those that may be excluded by status-filtered synonyms or views. All columns projected by IGSBV_HIGH_ED_PROG_VERSIONS are sourced from this object; no additional joins, unions, or subqueries are present in the documented definition. The _ALL suffix indicates that the view does not restrict by record status or version state, so callers should apply their own filtering predicates where only active, current, or approved versions are required.

The metadata lists referenced base objects as "none documented," which is consistent with the source excerpt showing only IGS_PS_VER_ALL; the absence of documented joins means the mapping is a straight column-alias projection.

Key Columns

Common Use Cases and Queries

Typical usage includes academic catalog reporting, supplementary examination eligibility checks, intermission policy analysis, and credit load validation. A representative query for supplementary exam eligibility is:

SELECT program_code, version_number, title,
       supp_exam_perm_indicator, program_status
  FROM apps.igsbv_high_ed_prog_versions
 WHERE supp_exam_perm_indicator = 'Y';

Because the view reads from IGS_PS_VER_ALL, callers needing only currently effective versions should add predicates on start_date and end_date, or filter on program_status. Audit-driven extracts typically select last_update_date and last_updated_by for incremental loads. The read-only nature guarantees that integration jobs cannot inadvertently modify base program data through this interface.