Search Results igs_as_gpc_unit_sets




Overview
Explore in AI Chat

Overview

The IGS_AS_GPC_UNIT_SETS table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction or association table that stores the specific relationship between Grading Period Cohorts (GPC) and academic Unit Sets. Its primary role is to define which unit sets—groupings of academic units or courses—are applicable to a specific grading period cohort, thereby enabling the structured administration of grading rules and academic progression for defined student groups within specific timeframes. This table is essential for configuring and executing cohort-based grading processes in the Student System.

Key Information Stored

The table's structure is designed to enforce and manage the unique association between a grading period cohort and a unit set. The key columns, as defined by its primary and unique keys, are fundamental to its purpose. The system-generated surrogate key, GPC_UNIT_SET_ID, serves as the primary identifier. The logical business key is a unique combination of GRADING_PERIOD_CD, UNIT_SET_CD, and UNIT_SET_VERSION_NUMBER. This combination ensures that a specific version of a unit set can be linked to only one grading period cohort, maintaining data integrity for academic rule application. The table's foreign key constraints explicitly link it to the IGS_EN_UNIT_SET_ALL table, validating that the UNIT_SET_CD and UNIT_SET_VERSION_NUMBER reference a valid, existing unit set definition within the system.

Common Use Cases and Queries

This table is central to operations involving cohort-based academic administration. A primary use case is the setup and validation of grading periods, where administrators define which sets of academic rules (unit sets) apply to which student cohorts for a given grading cycle. Common reporting and validation queries involve listing all unit sets assigned to a specific grading period cohort or identifying which cohort governs grading for a particular unit set version. A typical SQL pattern for such reporting would be a join between IGS_AS_GPC_UNIT_SETS and IGS_EN_UNIT_SET_ALL to retrieve descriptive unit set names.

SELECT gpus.grading_period_cd,
       gpus.unit_set_cd,
       gpus.unit_set_version_number,
       usa.unit_set_name
FROM igs.igs_as_gpc_unit_sets gpus,
     igs.igs_en_unit_set_all usa
WHERE gpus.unit_set_cd = usa.unit_set_cd
  AND gpus.unit_set_version_number = usa.version_number
  AND gpus.grading_period_cd = :p_grading_period;

This data is critical for batch processes that calculate grades, generate academic transcripts, and enforce progression rules based on a student's assigned cohort and unit set.

Related Objects

  • IGS_EN_UNIT_SET_ALL: This is the primary parent table, as enforced by a foreign key relationship. It contains the master definition of all unit sets, including code, version, name, and status. IGS_AS_GPC_UNIT_SETS references specific rows in this table to establish valid associations.
  • IGS_AS_GRD_PERD_COHORT: While not explicitly listed in the provided metadata, this table (or one with a similar name storing grading period cohort definitions) is implicitly related. The GRADING_PERIOD_CD column in IGS_AS_GPC_UNIT_SETS would typically be a foreign key to such a table, which defines the cohorts available in the system.
  • APIs and Packages: Modules within the Student System responsible for grading, academic progression, and cohort management will contain PL/SQL packages that query, insert, update, and delete records in this table to maintain business logic integrity.