Search Results igs_as_gpc_pe_id_grp




Overview
Explore in AI Chat

Overview

The IGS_AS_GPC_PE_ID_GRP table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Student System (IGS) module. It functions as a junction or association table that links specific grading period cohorts with defined groups of person identifiers. Its primary role is to manage and define which sets of students (person ID groups) are associated with particular grading periods, enabling structured and group-based processing of academic assessments, grade calculations, and cohort reporting within the institutional framework.

Key Information Stored

The table stores the association records using a combination of system-generated and business key columns. The primary system identifier is the GPC_PE_GRP_ID, a unique key managed by a sequence. The critical business keys are GRADING_PERIOD_CD, which identifies the specific academic grading timeframe, and GROUP_ID, which is a foreign key referencing a specific person identifier group. Together, the GRADING_PERIOD_CD and GROUP_ID form a unique constraint (IGS_AS_GPC_PE_ID_GRP_UK), ensuring that a given group is not assigned to the same grading period more than once.

Common Use Cases and Queries

This table is central to operations that require batch processing of student grades or reporting by cohort within a defined grading period. A common use case is generating a list of all students eligible for grade submission or review for a specific grading period cohort. Administrators may also use it to validate or modify cohort assignments. A typical reporting query would join this table to the person ID group and person detail tables to extract the student list.

  • Sample Query: To retrieve all person IDs associated with a grading period 'FINAL_2024':
    SELECT pg.person_id FROM igs_as_gpc_pe_id_grp gpc JOIN igs_pe_persid_group_all pg ON gpc.group_id = pg.group_id WHERE gpc.grading_period_cd = 'FINAL_2024';
  • Administrative Use: Adding or removing a predefined student group from a grading period cohort for administrative adjustments.

Related Objects

The table maintains a direct and critical foreign key relationship with the Person ID Group master table, which defines the actual members of the student group.

  • IGS_PE_PERSID_GROUP_ALL: This is the primary related table. The GROUP_ID column in IGS_AS_GPC_PE_ID_GRP references the GROUP_ID in IGS_PE_PERSID_GROUP_ALL. This relationship is essential for resolving the abstract group reference to the concrete list of person identifiers (students).

While not explicitly listed in the provided metadata, this table is logically a child of a grading period cohort master table (likely keyed by GRADING_PERIOD_CD) and would be frequently joined to it in application logic and reports to provide full context for the cohort-group associations.