Search Results gpc_unit_set_id




Overview
Explore in AI Chat

Overview

The IGS_AS_GPC_UNIT_SETS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by the IGS schema. This table serves a critical function in the academic assessment framework by storing the association between grading period cohorts and academic unit sets. A grading period cohort defines a specific academic period for assessment purposes, while a unit set represents a defined group of academic units or courses. This table effectively maps which unit sets are applicable and assessed within a particular grading period cohort, enabling structured grade calculation and reporting for defined student groups.

Key Information Stored

The table's design centers on uniquely identifying these mappings and tracking their lifecycle. The primary and most critical column is GPC_UNIT_SET_ID, a system-generated unique identifier (NUMBER(15)) acting as the primary key. The business logic of the association is defined by three mandatory columns: GRADING_PERIOD_CD (VARCHAR2(30)), UNIT_SET_CD (VARCHAR2(10)), and UNIT_SET_VERSION_NUMBER (NUMBER). Together, these three columns form a unique alternate key, ensuring that a specific version of a unit set is linked to a grading period code only once. Standard EBS "WHO" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are present for audit and compliance tracking.

Common Use Cases and Queries

This table is essential for processes that generate or validate assessments based on a student's enrolled unit set within a given grading period. Common operational and reporting scenarios include validating assessment batch parameters, generating cohort-based grade reports, and auditing configuration. A fundamental query to retrieve all mappings is:

SELECT GPC_UNIT_SET_ID, GRADING_PERIOD_CD, UNIT_SET_CD, UNIT_SET_VERSION_NUMBER FROM IGS.IGS_AS_GPC_UNIT_SETS ORDER BY GRADING_PERIOD_CD;

To find all unit sets configured for a specific grading period, a query would filter on GRADING_PERIOD_CD. Conversely, to identify all grading periods where a particular unit set (and version) is active, a query would filter on UNIT_SET_CD and UNIT_SET_VERSION_NUMBER. These lookups are typically performed by backend assessment engine programs rather than through direct ad-hoc queries.

Related Objects

Based on the provided metadata, the IGS_AS_GPC_UNIT_SETS table is referenced by an object within the APPS schema named IGS_AS_GPC_UNIT_SETS. This is most likely a public synonym or a view that provides a non-schema-qualified access point to the underlying IGS table, which is a standard EBS practice. The table itself has two unique indexes: IGS_AS_GPC_UNIT_SETS_U1 on GPC_UNIT_SET_ID (primary key) and IGS_AS_GPC_UNIT_SETS_U2 on the composite key (GRADING_PERIOD_CD, UNIT_SET_CD, UNIT_SET_VERSION_NUMBER). While the dependency list shows no outward references from this table, it is logically related to the master tables for Grading Periods and Unit Set definitions within the IGS schema, which hold the detailed descriptions for the codes stored here.