Search Results igs_pr_cohort




Overview
Explore in AI Chat

Overview

The IGS_PR_COHORT table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. It functions as a master definition table for storing class rank cohort configurations. A cohort, in this academic context, represents a defined group of students used for comparative ranking and statistical analysis, such as calculating class percentiles or honors designations. The table's role is to establish the parameters and rules that govern how a specific student population is grouped for these performance evaluations, serving as a critical reference for the system's progression and ranking engines.

Key Information Stored

The table stores the defining attributes for each cohort. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its essential components. The COHORT_NAME column serves as the unique identifier (primary key) for the cohort definition. The table links to IGS_PR_STAT_TYPE via the STAT_TYPE column, indicating the type of statistic or ranking (e.g., GPA percentile, class rank) for which the cohort is used. Furthermore, its relationship with IGS_RU_RULE through the RULE_SEQUENCE_NUMBER column is significant, implying that complex business rules (likely defining cohort membership criteria like enrollment dates, program, or course load) are attached to the cohort definition.

Common Use Cases and Queries

This table is central to generating academic standing reports, honors lists, and dean's list calculations. Administrators might query it to audit or list all active cohort definitions. A common reporting pattern involves joining the cohort definition with its rule details and the student instances assigned to it. A typical query to retrieve basic cohort setup information would be:

  • SELECT cohort_name, stat_type FROM igs_pr_cohort WHERE rule_sequence_number = [specific_rule];

For operational reporting, a join to the related instance table (IGS_PR_COHORT_INST) is necessary to see which specific students belong to a cohort for a given evaluation period. The primary use case is the batch process that populates student instances into cohorts based on the defined rules for subsequent ranking calculations.

Related Objects

The IGS_PR_COHORT table has defined relationships with several other key EBS objects, as per the provided metadata:

  • IGS_PR_STAT_TYPE: Linked via foreign key column IGS_PR_COHORT.STAT_TYPE. This table defines the valid statistical types for ranking.
  • IGS_RU_RULE: Linked via foreign key column IGS_PR_COHORT.RULE_SEQUENCE_NUMBER. This table stores the rule that determines cohort membership.
  • IGS_PR_COHORT_INST: This table holds the individual student members assigned to a cohort definition. It references IGS_PR_COHORT via the foreign key column IGS_PR_COHORT_INST.COHORT_NAME.