Results for “prog_grp_type_closed_indicator”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGSFV_HIGH_EDU_PRG_GRP_TYPES belongs to the IGS – Student System product family, which is flagged as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2 documentation. It is a full database view whose stated purpose is to describe the available types of program groups that can be defined on the system. In the Higher Education data model, program group types provide the classification framework used to aggregate academic programs into logical groupings, and this view exposes that classification vocabulary together with its active/closed status. The view plays a supporting role in reporting and integration: downstream student system modules, enrollment processes, and academic structure reporting reference these group type definitions to validate, filter, or categorize program group records. Because the product is obsolete and the object is documented as "Not implemented in this database" in the reference environment, the view should be treated as a legacy definitional object — useful for understanding the underlying data model, but not guaranteed to exist in every EBS instance.

Underlying Base Objects

The view definition selects entirely from a single base table, IGS_PS_GRP_TYPE, with the query issued WITH READ ONLY. This restriction prevents DML through the view, confirming that it is intended strictly for query and reporting purposes. No other base tables or objects are documented as referenced, and the ETRM metadata notes "none documented" under referenced base objects beyond this table. The naming convention follows the IGS pattern: the IGSFV_ prefix designates a "full view" (as opposed to a "validation" or partial view), and the base table IGS_PS_GRP_TYPE stores the physical rows. Because no joins, unions, or computed columns beyond direct projections appear in the view text, the view is best understood as a thin, renamed projection layer over the base table, offering more descriptive column aliases for consumers.

Key Columns

The view renames several base table columns to present a clearer reporting interface. The principal columns exposed are:

• PROGRAM_GROUP_TYPE — derived from GR.COURSE_GROUP_TYPE; the code identifying the program group type.
• PROGRAM_GROUP_TYPE_DESCRIPTION — derived from GR.DESCRIPTION; the human-readable description of the type.
• PROG_GRP_TYPE_CLOSED_INDICATOR — derived from GR.CLOSED_IND; the indicator matching the user's search term, signalling whether the program group type is closed and therefore unavailable for new assignments.
• _LA:SYS_PROG_GROUP_TYPE_DESC — a language/lookup attribute pointing at IGS_LOOKUP_VALUES using the COURSE_GROUP_TYPE lookup type, enabling derived meaning values.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns tracking row provenance and change history.

Common Use Cases and Queries

Typical usage centers on validating or listing available program group types, particularly filtering by the closed indicator. A representative query returning only open types is:

SELECT program_group_type,
       program_group_type_description,
       prog_grp_type_closed_indicator
FROM   igsfv_high_edu_prg_grp_types
WHERE  prog_grp_type_closed_indicator = 'N'
ORDER BY program_group_type;

A second scenario joins the view to student program group data to exclude retired classifications from reporting, or to audit which types have been administratively closed. Because the view is read-only and projects a single table, it is also useful as a lookup source in integrations and extract routines. Given the obsolete status of the IGS module and the "not implemented" note, DBAs should verify object existence before relying on this view in any 12.1.1 or 12.2.2 deployment.