Search Results igs_as_gpc_pe_id_grp_v




Overview
Explore in AI Chat

Overview

The view IGS_AS_GPC_PE_ID_GRP_V belongs to the IGS – Student System product family in Oracle E-Business Suite. In Oracle EBS 12.1.1 and 12.2.2 this product is classified as Obsolete, meaning it is no longer actively developed or supported by Oracle, though its database objects may remain in upgraded instances. The view presents grading period information associated with a person identification group. Specifically, it joins a grading period assignment record to its parent person ID group and resolves the grading period code to a user-facing meaning.

Its role is primarily reporting and integration: it flattens the relationship between grading period definitions and the person ID groups they apply to, exposing both the coded value and its descriptive meaning in a single row set. The ETRM metadata notes that the view is not implemented in this database, indicating it is documented for reference only and may not exist in every environment.

Underlying Base Objects

The view text references three base objects:

The join conditions are: GPG.GRADING_PERIOD_CD = LKUP.LOOKUP_CODE and GPG.GROUP_ID = PIDG.GROUP_ID. Documented ETRM metadata lists no referenced base objects and no owner, so the relationship above is derived directly from the published view SQL.

Key Columns

  • ROW_ID – the ROWID of the underlying IGS_AS_GPC_PE_ID_GRP row; useful as a unique row identifier.
  • GPC_PE_GRP_ID – primary key of the grading period / person ID group assignment.
  • GRADING_PERIOD_CD – the coded grading period value stored in the base table.
  • GRADING_PERIOD – the decoded lookup meaning for AS_GRADING_PERIOD; this is the human-readable description.
  • GROUP_ID – identifier of the person ID group.
  • GROUP_CD – short code of the person ID group.
  • GROUP_DESCRIPTION – the descriptive name of the person ID group, sourced from IGS_PE_PERSID_GROUP_V.DESCRIPTION.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard Oracle WHO audit columns.

Common Use Cases and Queries

A frequent use case is retrieving groups by their descriptive text, which matches the search term group_description. For example:

SELECT GROUP_ID, GROUP_CD, GROUP_DESCRIPTION, GRADING_PERIOD_CD, GRADING_PERIOD
FROM IGS_AS_GPC_PE_ID_GRP_V
WHERE UPPER(GROUP_DESCRIPTION) LIKE UPPER('%&group_description%');

Because the view is flagged obsolete and not implemented in all databases, any integration or report depending on it should first verify its existence in the target instance and be prepared for its absence in future environments.