Search Results program_closed_indicator




Overview
Explore in AI Chat

Overview

IGSFV_HIGH_EDU_PRG_GROUPS is a read-only view in the Oracle EBS Student Systems (Student Information / Higher Education) schema, owned by APPS. It presents program group (course group) definitions used within the higher education data model, exposing the group code, description, responsible organizational unit, and a status flag. The view is explicitly defined WITH READ ONLY, confirming it is intended strictly for query, reporting, and integration consumption rather than transactional maintenance. In EBS 12.1.1 and 12.2.2 the view behaves identically; it is a reporting façade over the base group tables, denormalizing the group type description and the responsible party name so that downstream consumers obtain human-readable values without additional joins.

The view is relevant to the search term program_closed_indicator: the underlying column GRA.CLOSED_IND is exposed through the alias PROGRAM_CLOSED_INDICATOR. This column indicates whether a program group is closed to further use.

Underlying Base Objects

The view is defined over three objects:

  • IGS_PS_GRP_ALL (aliased GRA) — the primary base table holding program/course group records, including code, description, type, responsible org unit, and the closed indicator.
  • IGS_PS_GRP_TYPE (aliased GRT) — the group type lookup, supplying the type description.
  • HZ_PARTIES (aliased PA) — the trading community party table, supplying the responsible organization unit name via an outer join on PARTY_NUMBER, filtered to active parties (PA.STATUS(+) = 'A').

The join between GRA and GRT is an inner join on COURSE_GROUP_TYPE, so only groups with a valid type are returned. The join to HZ_PARTIES is an outer join, meaning groups lacking a matching active party still appear, with null party name.

Key Columns

Common Use Cases and Queries

Typical uses include validating which program groups remain open, resolving group type descriptions for reporting, and extracting group-to-organization relationships. A representative query listing open groups is:

  • SELECT PROGRAM_GROUP_CODE, PROGRAM_GROUP_DESCRIPTION, PROGRAM_GROUP_TYPE_DESCRIPTION, RESP_ORG_UNIT_DESCRIPTION FROM APPS.IGSFV_HIGH_EDU_PRG_GROUPS WHERE PROGRAM_CLOSED_INDICATOR = 'N';
  • SELECT PROGRAM_GROUP_CODE, PROGRAM_CLOSED_INDICATOR FROM APPS.IGSFV_HIGH_EDU_PRG_GROUPS ORDER BY PROGRAM_GROUP_CODE;

Because the view is read-only and excludes inactive parties through the outer-join status filter, it is well suited to reporting and interface extracts where only current, active organizational associations should be surfaced.