Search Results program_group_description

Overview

The view IGSFV_HIGH_EDU_PRG_GRP_MEMBERS belongs to the Oracle E-Business Suite product family IGS – Student System, which is flagged as obsolete in Release 12.1.1 and 12.2.2. It is a "full view" whose documented purpose is to describe the programs that are members of a program grouping. In other words, it presents the membership relationship between an individual program (identified by a program code and version number) and the program group to which that program belongs, together with descriptive attributes of both the program and the group.

Within the Higher Education and Student System data model, this view serves as a denormalized reporting and integration layer. Rather than requiring callers to join the underlying membership, version, and group tables manually, the view exposes a flattened result set that pairs each program-group membership with the program title and the group description. This makes it convenient for operational reports, extracts, and interfaces that need to list which programs constitute a given grouping, or conversely, which groupings a specific program participates in.

Because the view is documented as "not implemented in this database" in the ETRM metadata, practical availability depends on whether the corresponding IGS product components have been installed in a given environment. In configurations where the Student System modules are not deployed, the view will not exist and queries against it will fail.

Underlying Base Objects

The view text joins three base tables:

• IGS_PS_GRP_MBR (aliased GRM) – the program group membership table, supplying the program code, version number, program group code, and audit columns.
• IGS_PS_VER_ALL (aliased VE) – the program version view, supplying the program title (VE.TITLE).
• IGS_PS_GRP_ALL (aliased GRA) – the program group view, supplying the group description (GRA.DESCRIPTION).

The join predicates tie membership rows to the corresponding program version on COURSE_CD and VERSION_NUMBER, and to the program group on COURSE_GROUP_CD. The view is defined WITH READ ONLY, so it cannot be used as the target of DML. The ETRM metadata records no additional referenced base objects beyond those shown in the view text.

Key Columns

• PROGRAM_CODE – the code of the member program (GRM.COURSE_CD), a primary identifying key for the program.
• PROGRAM_VERSION_NUMBER – the version of the program (GRM.VERSION_NUMBER), distinguishing revisions of the same program code.
• PROGRAM_GROUP_CODE – the code of the program grouping (GRM.COURSE_GROUP_CD) to which the program belongs.
• PROGRAM_TITLE – the descriptive title of the program (VE.TITLE); this is the column that the user search term "program_title" most directly targets.
• PROGRAM_GROUP_DESCRIPTION – the description of the program group (GRA.DESCRIPTION).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – standard Oracle audit columns sourced from the membership table.

Common Use Cases and Queries

Typical uses include reporting the composition of program groups, validating group membership during data migration, and driving downstream interfaces that need program titles alongside group codes. Because the view is read-only, it is suited to SELECT-only reporting and extraction.

List all programs within a specific group:

• SELECT program_code, program_version_number, program_title FROM igsfv_high_edu_prg_grp_members WHERE program_group_code = :group_code;

Find the groupings to which a program belongs:

• SELECT program_group_code, program_group_description FROM igsfv_high_edu_prg_grp_members WHERE program_code = :program_code;

Search by program title, matching the user's search term:

• SELECT program_code, program_title, program_group_code FROM igsfv_high_edu_prg_grp_members WHERE UPPER(program_title) LIKE UPPER('%' || :title_fragment || '%');

Audit recent changes to group membership:

• SELECT program_group_code, program_code, last_updated_by, last_update_date FROM igsfv_high_edu_prg_grp_members ORDER BY last_update_date DESC;