Search Results igs_as_gpc_cls_stndg_u2

Overview

The IGS_AS_GPC_CLS_STNDG table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (iGradestar) application. It serves a critical function in the academic assessment and cohort analysis modules by storing the definition of class standings within specific grading period cohorts. The table's primary role is to establish and maintain the valid class standing values (e.g., Freshman, Sophomore, Junior, Senior) that are applicable to defined grading periods, enabling accurate tracking and reporting of student academic progression over time within cohort-based analyses.

Key Information Stored

The table stores a concise set of attributes essential for uniquely identifying and managing class standing definitions. The primary identifier is the system-generated GPC_CLS_STNDG_ID. The logical key is formed by the combination of GRADING_PERIOD_CD and CLASS_STANDING, which is enforced by a unique index (IGS_AS_GPC_CLS_STNDG_U2). This ensures that a specific class standing value can only be defined once per grading period. The CLASS_STANDING column holds the descriptive value, while the GRADING_PERIOD_CD provides the temporal context. The table also includes standard Oracle EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit trail compliance.

Common Use Cases and Queries

This table is central to processes that require validating or reporting on student class standing within a cohort framework. Common use cases include configuring available standings for a grading period during system setup, validating student records during batch processes, and generating cohort progression reports. A typical query to retrieve all defined standings for a specific grading period would be:

• SELECT CLASS_STANDING FROM IGS.IGS_AS_GPC_CLS_STNDG WHERE GRADING_PERIOD_CD = :1 ORDER BY CLASS_STANDING;

For integration or data validation scripts, a common pattern is to look up the unique identifier using the business key:

• SELECT GPC_CLS_STNDG_ID FROM IGS.IGS_AS_GPC_CLS_STNDG WHERE GRADING_PERIOD_CD = :1 AND CLASS_STANDING = :2;

Related Objects

The table's integrity is maintained through defined relationships with other EBS objects. Its primary key, GPC_CLS_STNDG_ID, is defined by the constraint IGS_AS_GPC_CLS_STNDG_PK. A foreign key relationship exists where the CLASS_STANDING column in this table references the IGS_PR_CLASS_STD table, ensuring that the standing value is a valid, pre-defined code in the system. This table is referenced by other objects within the APPS schema, indicating it is a foundational lookup table for cohort and grading functionality. The documented unique indexes, IGS_AS_GPC_CLS_STNDG_U1 (on the ID) and IGS_AS_GPC_CLS_STNDG_U2 (on the code and standing), are critical for performance and data integrity.