Search Results s_course_group_type

Overview

APPS.IGS_PS_GRP_TYPE_V is an Oracle E-Business Suite seeded database view belonging to the Student Systems / Higher Education product family (the IGS schema prefix denotes the Student Information / Academic Records model). It exposes the definitions of course group types used within academic program structures, and its most visible role is to present the meaning of each course group type code by joining the base entity table to the Oracle lookups repository. Because the view resolves lookup codes into their meaning values at query time, it allows forms, reports, concurrent programs, and external integrations to display human-readable course group type descriptions without performing an explicit lookup join. In Oracle EBS 12.1.1 and 12.2.2 this object is consumed largely for validation and presentation of course group type reference data.

Underlying Base Objects

The view is defined over two objects documented in its view text:

• IGS_PS_GRP_TYPE — the principal base table holding course group type definitions, including the internal identifier column S_COURSE_GROUP_TYPE and descriptive attributes.
• IGS_LOOKUPS_VIEW — the standard Oracle lookups view, filtered to LOOKUP_TYPE = 'COURSE_GROUP_TYPE'.

The join condition is IGS_LOOKUPS_VIEW.LOOKUP_CODE = IGS_PS_GRP_TYPE.S_COURSE_GROUP_TYPE. This means a row from IGS_PS_GRP_TYPE appears in the view only when a matching lookup code exists in the COURSE_GROUP_TYPE lookup type; rows whose lookup code is missing from the lookups table are silently excluded. The ROWID of the base table is surfaced as ROW_ID, preserving row-level addressability for tooling that relies on it. Note that the ETRM metadata lists no additional referenced base objects beyond these two, and no owner column is populated in the supplied metadata.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_PS_GRP_TYPE row.
• S_COURSE_GROUP_TYPE — the system-assigned course group type code; the join key to the lookups view.
• MEANING — the displayable description of the lookup code, sourced from IGS_LOOKUPS_VIEW.
• COURSE_GROUP_TYPE — the course group type attribute carried on the base table.
• DESCRIPTION — free-text description of the course group type.
• CLOSED_IND — indicator of whether the course group type is closed for new use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO audit columns, passed through unchanged from the base table.

Common Use Cases and Queries

Typical scenarios include populating a course group type list of values, validating a user-supplied group type code, and producing program or course catalogue reports that require readable type descriptions. Because CLOSED_IND is exposed, active-only queries are straightforward.

• List all active course group types with their meanings:

  SELECT S_COURSE_GROUP_TYPE, MEANING, DESCRIPTION
  FROM   APPS.IGS_PS_GRP_TYPE_V
  WHERE  NVL(CLOSED_IND, 'N') = 'N';

• Resolve a specific code to its meaning:

  SELECT MEANING
  FROM   APPS.IGS_PS_GRP_TYPE_V
  WHERE  S_COURSE_GROUP_TYPE = :p_code;

• Audit recently maintained records:

  SELECT S_COURSE_GROUP_TYPE, MEANING, LAST_UPDATED_BY, LAST_UPDATE_DATE
  FROM   APPS.IGS_PS_GRP_TYPE_V
  WHERE  LAST_UPDATE_DATE >= SYSDATE - 30
  ORDER  BY LAST_UPDATE_DATE DESC;

In 12.2.2 the view remains a read-only presentation layer; data maintenance must target IGS_PS_GRP_TYPE, not the view.