Search Results igs_as_gpc_cls_stndg




Overview
Explore in AI Chat

Overview

The table IGS_AS_GPC_CLS_STNDG is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a junction table that establishes and stores the relationship between grading period cohorts and class standings. Its primary role is to define which class standing values are valid and applicable for specific grading periods within the academic structure. This table is essential for enforcing data integrity in processes related to student progression, academic standing, and cohort-based reporting, ensuring that class standing assignments are contextually relevant to the defined grading timeframe.

Key Information Stored

The table's structure centers on a unique combination of identifiers and a surrogate key. The primary data points stored are:

  • GPC_CLS_STNDG_ID: A unique system-generated identifier serving as the primary key for the record.
  • GRADING_PERIOD_CD: The code identifying a specific grading period or cohort.
  • CLASS_STANDING: The code representing a specific class standing (e.g., Freshman, Sophomore). This column is a foreign key referencing the IGS_PR_CLASS_STD table.

The unique key constraint (IGS_AS_GPC_CLS_STNDG_UK) on GRADING_PERIOD_CD and CLASS_STANDING ensures that a given class standing can only be associated with a specific grading period once, preventing duplicate mappings.

Common Use Cases and Queries

This table is primarily used in administrative and reporting contexts where student academic status must be evaluated relative to a grading cohort. A common use case is validating a student's class standing during enrollment or grade processing for a given term. It also supports cohort analysis reports that track the progression of student groups defined by their entry period. A typical query would join this table to the class standing master table to retrieve valid standings for reporting.

Sample Query: To list all valid class standings for a specific grading period, along with their descriptions: 

SELECT gpc.GRADING_PERIOD_CD, gpc.CLASS_STANDING, cs.DESCRIPTION
FROM IGS.IGS_AS_GPC_CLS_STNDG gpc
JOIN IGS.IGS_PR_CLASS_STD cs ON gpc.CLASS_STANDING = cs.CLASS_STANDING
WHERE gpc.GRADING_PERIOD_CD = '&GRADING_PERIOD';

Related Objects

IGS_AS_GPC_CLS_STNDG has defined relationships with other key tables in the Student System, primarily through foreign key constraints:

  • IGS_PR_CLASS_STD (Foreign Key): This is the master table for class standing codes. The CLASS_STANDING column in IGS_AS_GPC_CLS_STNDG references IGS_PR_CLASS_STD.CLASS_STANDING, ensuring that only predefined, valid class standings can be linked to a grading period cohort.

While not explicitly listed in the provided metadata, this table is logically central to the grading period cohort (GPC) functionality and would be referenced by other student assessment and progression tables to maintain referential integrity for cohort-based standing rules.