Search Results igs_pr_cohinst_rank




Overview
Explore in AI Chat

Overview

The IGS_PR_COHINST_RANK table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. As indicated by its description, its primary function is to store Class Rank Cohort Instance Rank data. This table is designed to hold calculated ranking information for students within specific academic cohorts, which are defined groups of students (e.g., a graduating class) tracked over a particular load calendar instance. Notably, the ETRM metadata explicitly classifies the IGS - Student System as "Obsolete" and states this specific table is "Not implemented in this database." This indicates the table was part of a legacy or planned functionality that was not deployed in standard EBS 12.1.1 or 12.2.2 instances, though its structure remains defined in the data dictionary.

Key Information Stored

The table's composite primary key defines the granularity of the rank data it was intended to store. Each record would uniquely identify a student's rank within a specific cohort instance for a given program of study. The key columns are PERSON_ID, which identifies the student; COURSE_CD, which identifies the academic program; and the trio of COHORT_NAME, LOAD_CAL_TYPE, and LOAD_CI_SEQUENCE_NUMBER, which together uniquely identify a specific instance of a cohort (e.g., the "Fall 2023" instance of the "2025 Graduating Class" cohort). While the ETRM excerpt does not list non-key columns, the table's purpose suggests it would contain at least one column for the calculated rank value, potentially alongside other metrics like percentile or ranking calculation date.

Common Use Cases and Queries

Given its "not implemented" status, this table would not be actively used in standard production operations for reporting or processes. Its design, however, reveals its intended analytical purpose. In a hypothetical implemented scenario, it would support academic reporting and student advisement by enabling queries to determine a student's standing relative to their peers in a defined group. A typical query would join to student and cohort tables to retrieve rank information. For example, a sample SQL pattern to retrieve a student's cohort rank might have been: SELECT rank_value FROM igs_pr_cohinst_rank WHERE person_id = :p_student_id AND cohort_name = :p_cohort AND load_ci_sequence_number = :p_sequence;. Use cases would include generating class rank for honor rolls, identifying students for targeted academic support, or providing data for accreditation reports.

Related Objects

Based on the provided foreign key relationship data, IGS_PR_COHINST_RANK is designed to have integrity dependencies on two core student system tables:

  • IGS_PR_COHORT_INST: The table references this via the columns COHORT_NAME, LOAD_CAL_TYPE, and LOAD_CI_SEQUENCE_NUMBER. This relationship ensures that a rank record is associated with a valid, existing cohort instance.
  • IGS_EN_STDNT_PS_ATT_ALL: The table references this via the columns PERSON_ID and COURSE_CD. This critical relationship ties the ranking data to a specific student's program attempt, ensuring the rank is for a valid student enrollment in a specific course (program).
The primary key IGS_PR_COHINST_RANK_PK enforces uniqueness for this combination of student, program, and cohort instance.