Search Results igs_pr_cohort_inst




Overview
Explore in AI Chat

Overview

The IGS_PR_COHORT_INST table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as the primary repository for storing instances of class rank cohorts. In the context of academic administration, a cohort is a defined group of students, and a cohort instance represents the specific occurrence of that group within a particular academic load calendar period. This table is essential for tracking and managing student rankings and comparative performance within these defined groups over time, supporting advanced academic reporting and analysis.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each cohort instance. The critical columns are:

  • COHORT_NAME: Identifies the specific cohort definition to which this instance belongs.
  • LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER: Together, these columns specify the academic calendar instance (e.g., a specific semester or term) for which this cohort instance is loaded and active. This temporal linkage is fundamental for historical tracking.
This key structure ensures that a given cohort (e.g., "Engineering Honors 2023") can have distinct instances for different academic periods, allowing for longitudinal analysis of the group's performance.

Common Use Cases and Queries

This table is central to operations involving class rank reporting and cohort-based analytics. A primary use case is generating rank lists for a specific student group within a given term. For example, an administrator might query to list all active cohort instances for the current academic load calendar to prepare for rank calculation batch processes. A typical reporting query would join this table to the cohort definition (IGS_PR_COHORT) and the calendar instance (IGS_CA_INST_ALL) to provide descriptive context. Furthermore, the table serves as the parent for detailed student ranking data stored in the related IGS_PR_COHINST_RANK table, making it the starting point for any drill-down into individual student ranks within their cohort instance.

Related Objects

The IGS_PR_COHORT_INST table exists within a defined relational schema, as evidenced by its foreign key constraints. Key documented relationships include:

  • Parent Table (IGS_PR_COHORT): The COHORT_NAME column references IGS_PR_COHORT.COHORT_NAME, ensuring every instance is linked to a valid cohort definition.
  • Parent Table (IGS_CA_INST_ALL): The LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER columns reference the corresponding columns in IGS_CA_INST_ALL, tethering the cohort instance to a valid academic calendar period.
  • Child Table (IGS_PR_COHINST_RANK): The table is referenced as a parent by IGS_PR_COHINST_RANK via its primary key columns (COHORT_NAME, LOAD_CAL_TYPE, LOAD_CI_SEQUENCE_NUMBER). This is a critical relationship where the actual student rank data for a specific cohort instance is stored.
These relationships enforce data integrity and are essential for constructing accurate joins in reports and interfaces.