Search Results class_standing_desc




Overview
Explore in AI Chat

Overview

IGS_AS_GPC_CLS_STNDG_V is a reporting and integration view owned by the APPS schema within the IGS — Student System product family of Oracle E-Business Suite. Its documented purpose is to present Class Standing Information, exposing grade-related class standing assignments in a denormalized, human-readable form. The view is validated and available in both Oracle EBS 12.1.1 and 12.2.2, the two release levels most commonly deployed for the Student System module. Unlike transactional entry forms, the view is oriented toward inbound and outbound data exchange, ad hoc reporting, and lookups where a coded value must be resolved to its descriptive text.

The principal reason this object is significant is the convenience column CLASS_STANDING_DESC. Applications and reports frequently require the descriptive label rather than the internal CLASS_STANDING code; this view performs that join at the database layer, sparing the caller from constructing the lookup manually. This makes the view a natural candidate for value sets, LOV definitions, and interface staging tables used during student records migration.

Underlying Base Objects

The view is defined over exactly two base tables, joined on the class standing code:

  • IGS_AS_GPC_CLS_STNDG CLS — the primary table holding grading period class standing assignments, including the surrogate key GPC_CLS_STNDG_ID and the GRADING_PERIOD_CD and CLASS_STANDING codes. It contributes all auditing columns.
  • IGS_PR_CLASS_STD STD — the class standing reference table supplying the DESCRIPTION value that is aliased as CLASS_STANDING_DESC.

The join predicate is stated as CLS.CLASS_STANDING = STD.CLASS_STANDING, making the relationship an inner join. Consequently, any class standing assignment whose code has no corresponding row in the IGS_PR_CLASS_STD reference table will be excluded from the view result set. The ROWID of the primary table is surfaced as ROW_ID, which supports updatable-view behavior for certain client-side tooling.

Key Columns

  • ROW_ID — the row identifier of the IGS_AS_GPC_CLS_STNDG record, exposed as the underlying ROWID.
  • GPC_CLS_STNDG_ID — the system-generated primary key for the class standing assignment.
  • GRADING_PERIOD_CD — the grading period to which the standing applies, typically an academic period or term identifier.
  • CLASS_STANDING — the coded class standing value stored on the assignment record and used as the join key.
  • CLASS_STANDING_DESC — the descriptive text retrieved from IGS_PR_CLASS_STD; this is the column users search for by that name.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS who-column audit set, carried through from the base assignment table.

Common Use Cases and Queries

The most common requirement is retrieving the descriptive label for a given grading period or class standing code. A representative query follows:

  • List all standings for a grading period: SELECT gpc_cls_stndg_id, grading_period_cd, class_standing, class_standing_desc FROM igs_as_gpc_cls_stndg_v WHERE grading_period_cd = :p_period ORDER BY class_standing;
  • Resolve a single code to text: SELECT class_standing_desc FROM igs_as_gpc_cls_stndg_v WHERE class_standing = :p_code AND ROWNUM = 1;
  • Feed an interface or LOV: SELECT class_standing, class_standing_desc FROM igs_as_gpc_cls_stndg_v ORDER BY class_standing_desc;

Because the view performs an inner join, callers building inbound interfaces should validate class standing codes against IGS_PR_CLASS_STD beforehand; otherwise, valid assignment rows may be silently omitted from the view. Where the raw assignment is required regardless of description availability, the base table IGS_AS_GPC_CLS_STNDG should be queried directly. All access should be granted through the APPS schema, honoring the application's standard security and synonym conventions.