Search Results igsbv_high_edu_prg_grp_types

Overview

IGSBV_HIGH_EDU_PRG_GRP_TYPES is a base view within the Oracle E-Business Suite IGS — Student System product family. As documented in the ETRM repository for EBS 12.2.2, the view describes the available types of program groups that can be defined on the system. It functions as a read-only, denormalized presentation layer over the course of program-group-type configuration data, exposing the code, description, and status attributes required by concurrent programs, Oracle Forms, and downstream reporting or integration routines. The IGS Student System product line is flagged as obsolete in the ETRM metadata, meaning the object persists for backward compatibility with existing customer implementations but is not extended in newer releases.

The view is not implemented in the reference ETRM database (an explicit "Not implemented in this database" note appears in the metadata), which is typical of legacy IGS objects whose runtime presence depends on whether the Student System module was licensed and installed. The definitive column and text definitions remain authoritative for environments where IGS is deployed.

Underlying Base Objects

The view text reveals that IGSBV_HIGH_EDU_PRG_GRP_TYPES is defined over a single base table, IGS_PS_GRP_TYPE, aliased as GR. The metadata further specifies that the view was created WITH READ ONLY, confirming that no DML is permitted through the view. No additional joins or referenced base objects are documented, making the view a straightforward projection of course-group-type rows into a program-group-type context. This naming convention (course-group vs. program-group) reflects the historical IGS data model in which the underlying IGS_PS_GRP_TYPE table stored group-type classifications later surfaced under program-group terminology.

Key Columns

• PROGRAM_GROUP_TYPE — Sourced from GR.COURSE_GROUP_TYPE. The unique code identifying the program group type.
• PROGRAM_GROUP_TYPE_DESCRIPTION — Sourced from GR.DESCRIPTION. The human-readable description of the group type.
• PROG_GRP_TYPE_CLOSED_INDICATOR — Sourced from GR.CLOSED_IND. Indicates whether the group type is closed (typically Y/N).
• _LA:SYS_PROG_GROUP_TYPE_DESC — A descriptive-flexfield column whose definition references S_COURSE_GROUP_TYPE against the IGS_LOOKUP_VALUES table on COURSE_GROUP_TYPE using the MEANING column. It supplies the localized or lookup-derived description.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard Oracle EBS WHO-column audit attributes recording row creation and last modification.

Common Use Cases and Queries

Because the view is read-only and configuration-oriented, it is typically used in validation reports, setup listings, and integrations that must enumerate valid program group types before assigning them to programs or academic groupings. A representative query retrieves the active types:

SELECT PROGRAM_GROUP_TYPE, PROGRAM_GROUP_TYPE_DESCRIPTION FROM IGSBV_HIGH_EDU_PRG_GRP_TYPES WHERE PROG_GRP_TYPE_CLOSED_INDICATOR = 'N';

A second pattern joins the view to program-group assignment tables to validate referential integrity, while a third extracts all rows with audit timestamps for a setup audit report:

SELECT PROGRAM_GROUP_TYPE, PROGRAM_GROUP_TYPE_DESCRIPTION, CLOSED_IND, LAST_UPDATE_DATE FROM IGSBV_HIGH_EDU_PRG_GRP_TYPES ORDER BY PROGRAM_GROUP_TYPE;

Given the obsolete status of the IGS module, consumers should verify object existence before deploying dependent logic.