Results for “gpc_cls_stndg_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_AS_GPC_CLS_STNDG table is a core configuration object within the Oracle E-Business Suite Student System (IGS) product family. It stores grading period cohort class standing details, meaning it defines the valid combinations of grading periods and class standings that the academic scheduling and grading engines recognize when evaluating a student's academic progression. In the IGS module, class standing (such as freshman, sophomore, junior, senior, or institution-defined equivalents) is used to sequence course enrollment, enforce prerequisite rules, and drive grade processing behavior. By binding class standing values to specific grading periods, this table enables an institution to vary the class-standing definitions that apply within distinct academic terms or reporting windows.

From a dimensional modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries a single foreign key to the class standing reference (proration) table, and its business key (grading period plus class standing) behaves like a descriptive attribute attached to an existing academic entity rather than an independent hub or a many-to-many link. Analysts building a Data Vault or star schema should treat it as a satellite hanging off the class-standing dimension, with the grading period acting as a degenerate attribute.

Key Information Stored

The table is documented with eight physical columns. The most operationally significant are:

• GPC_CLS_STNDG_ID — the surrogate primary key, populated from the sequence backing IGS_AS_GPC_CLS_STNDG_PK. This is the unique technical identifier for each row.
• GRADING_PERIOD_CD — the grading period (academic term or reporting window) to which the class standing definition applies. This column participates in the business key unique index IGS_AS_GPC_CLS_STNDG_U2.
• CLASS_STANDING — the class standing code, which is also a foreign key to IGS_PR_CLASS_STD and the second component of the unique index IGS_AS_GPC_CLS_STNDG_U2.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS "WHO" audit columns tracking row creation and modification.

Two unique indexes exist: IGS_AS_GPC_CLS_STNDG_U1 enforces uniqueness on the surrogate GPC_CLS_STNDG_ID, while IGS_AS_GPC_CLS_STNDG_U2 enforces uniqueness on the natural business key pair (GRADING_PERIOD_CD, CLASS_STANDING). The latter is the candidate business key that guarantees a given grading period cannot map to the same class standing twice.

Common Use Cases and Queries

Typical use cases include validating that a class standing is defined for a grading period before enrollment, producing term-by-term class standing reference lists for reporting, and reconciling class standing configurations across academic years.

A sample lookup query joining to the class standing reference table:

• SELECT g.GRADING_PERIOD_CD, g.CLASS_STANDING, c.DESCRIPTION FROM IGS_AS_GPC_CLS_STNDG g, IGS_PR_CLASS_STD c WHERE g.CLASS_STANDING = c.CLASS_STANDING AND g.GRADING_PERIOD_CD = :period;

A configuration completeness query to find grading periods that have class standing records defined:

• SELECT GRADING_PERIOD_CD, COUNT(*) FROM IGS_AS_GPC_CLS_STNDG GROUP BY GRADING_PERIOD_CD ORDER BY GRADING_PERIOD_CD;

Because the WHO columns are present, change-tracking reports can filter on LAST_UPDATE_DATE to audit recent configuration changes.

Related Objects

The following objects are most significant to this table:

• IGS_PR_CLASS_STD — the class standing reference table. The foreign key IGS_AS_GPC_CLS_STNDG.CLASS_STANDING references it, providing the descriptive definition of each standing code.
• IGS_AS_GPC_CLS_STNDG_PK / _U1 / _U2 — the primary key constraint and unique indexes that enforce row identity and business-key integrity.
• Grading period tables in the IGS academic calendar (referenced by GRADING_PERIOD_CD) — while not documented as a declared foreign key here, the code links semantically to grading period definitions used throughout IGS.
• Enrollment and prerequisite processing entities in the IGS academic scheduling area, which consume class standing rules during course registration.
• Grade processing and academic standing routines that read these cohort definitions when evaluating student progression each term.