Search Results igs_ps_grp_type_v

Overview

IGS_PS_GRP_TYPE_V is a validation view belonging to the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to expose course group type definitions in a form that joins the base entity table to the Oracle Applications lookup infrastructure, so that consumers receive both the stored lookup code and its translatable, user-facing meaning. The view materializes the semantic link between IGS_PS_GRP_TYPE.S_COURSE_GROUP_TYPE and the seeded lookup type COURSE_GROUP_TYPE maintained through IGS_LOOKUPS_VIEW. This pattern is characteristic of IGS reference and validation views, which are typically bound to descriptive flexfields, list-of-values definitions, and concurrent program parameters rather than being queried directly by end users. ETRM documentation for 12.2.2 records no implemented database instance and no documented referenced base objects, indicating the view is a reference artifact rather than an actively deployed object in the documented environment.

Underlying Base Objects

The view text is defined over two sources:

• IGS_PS_GRP_TYPE — the base table holding course group type records, including the lookup code, description, open/closed indicator, and standard WHO audit columns.
• IGS_LOOKUPS_VIEW — the IGS lookup view supplying the MEANING value for each lookup code.

The join is an inner equi-join on lookup code, filtered to the lookup type COURSE_GROUP_TYPE. Because the view depends on a lookup view rather than the underlying FND_LOOKUP_VALUES table directly, the meaning returned is subject to the language and security context defined for that lookup view. ETRM documentation lists no additional referenced base objects, so the dependency chain terminates at these two sources.

Key Columns

• ROW_ID — the ROWID of the base table row, enabling row-level identification and updates through the view.
• S_COURSE_GROUP_TYPE — the stored lookup code on IGS_PS_GRP_TYPE, serving as the join key to the lookup view.
• MEANING — the translated description of the lookup code from IGS_LOOKUPS_VIEW; this is the display value presented to users.
• COURSE_GROUP_TYPE — the descriptive attribute on the base table, distinct from the stored lookup code.
• DESCRIPTION — free-text description of the group type record.
• CLOSED_IND — indicates whether the group type is closed to new use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include populating list-of-values definitions, resolving codes to meanings in reports, and validating course group type values in integrations.

To list all active course group types with their meanings:

SELECT course_group_type, meaning
FROM   igs_ps_grp_type_v
WHERE  NVL(closed_ind,'N') = 'N'
ORDER BY meaning;

To translate a stored code in a reporting join:

SELECT v.s_course_group_type, v.meaning
FROM   igs_ps_grp_type_v v
WHERE  v.s_course_group_type = :p_code;

Because the view keys on the course group type lookup, it should not be treated as a general lookup replacement; queries targeting other lookup types must use IGS_LOOKUPS_VIEW directly. All production queries should account for the view's absence from the documented implementation database.