Search Results igsbv_high_edu_prg_groups

Overview

The view IGSBV_HIGH_EDU_PRG_GROUPS belongs to the IGS — Student System product family, a legacy module that Oracle classifies as obsolete. It is a base view whose declared purpose is to describe a grouping of programs used for a variety of purposes within the Student System. In Oracle EBS Release 12.1.1 and 12.2.2, this view functions as a denormalized reporting layer over the underlying program-group table, presenting friendly business names in place of the terse column names used by the base entity.

The view is most relevant to institutions that implemented the pre-12.0 higher-education student model and subsequently upgraded. Because the object is documented as not implemented in this database within the ETRM 12.2.2 metadata, it should be treated as a compatibility or historical artifact rather than an actively maintained interface. The presence of a PROGRAM_CLOSED_INDICATOR column explains why the view surfaces in searches for the term "program_closed_indicator": the identifier is an alias applied to the base column CLOSED_IND, letting report authors query a descriptively named field without knowing the underlying naming convention.

Underlying Base Objects

The view text identifies a single referenced object: the table IGS_PS_GRP_ALL, aliased as GR in the defining query. The view is defined with the WITH READ ONLY clause, so no DML can be performed against it; it is strictly a query construct.

The join is trivial — there is no join at all. Every column is projected directly from the one base table, with only column aliasing applied. The documented metadata records no additional referenced base objects, confirming that the view does not traverse to organization, calendar, or program-version entities. For institutions on R12.1.1 or 12.2.2 where the legacy IGS schema has been removed or migrated, the object will not exist; queries that reference it must be redirected to the successor tables of the Student System replacement model or removed entirely.

Key Columns

• PROGRAM_GROUP_CODE — aliased from COURSE_GROUP_CD; the unique code identifying the program group.
• PROGRAM_GROUP_DESCRIPTION — aliased from DESCRIPTION; the descriptive text for the group.
• RESP_ORG_UNIT_CODE — aliased from RESPONSIBLE_ORG_UNIT_CD; the organization unit accountable for the group.
• RESP_ORG_UNIT_START_DATE — aliased from RESPONSIBLE_OU_START_DT; the date from which the owning organization unit became responsible.
• PROGRAM_GROUP_TYPE — aliased from COURSE_GROUP_TYPE; classifies the purpose or category of the group.
• PROGRAM_CLOSED_INDICATOR — aliased from CLOSED_IND; indicates whether the program group is closed to further use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS audit columns inherited from the base table.

Common Use Cases and Queries

Typical usage is reporting on open program groups and their owning organizations. A common filter is on the closed indicator, which is precisely the term that led to this object being located.

SELECT program_group_code,
       program_group_description,
       resp_org_unit_code,
       program_group_type
FROM   igsbv_high_edu_prg_groups
WHERE  program_closed_indicator = 'N'
ORDER  BY program_group_code;

A second scenario groups active programs by responsible organization unit for planning or accreditation reporting:

SELECT resp_org_unit_code,
       program_group_type,
       COUNT(*) group_count
FROM   igsbv_high_edu_prg_groups
WHERE  program_closed_indicator = 'N'
GROUP  BY resp_org_unit_code, program_group_type;

Because the view is read-only and unimplemented in current ETRM environments, these queries are best used as migration references — mapping the legacy column semantics onto replacement Student System tables — rather than as production reporting statements on a live R12.1.1 or 12.2.2 instance.