Results for “cohort_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PR_COHORT is a table within the Oracle E-Business Suite IGS – Student System product, which is documented as obsolete in release ETRM 12.1.1 and 12.2.2. The table stores Class Rank Cohort definitions used by the Student System to group students for rank, statistics, and academic progress calculations. A cohort represents a named grouping — for example, an entry term year, a program intake, or a student population — against which rank and statistical rules are applied.

Based on the foreign key topology, the object is classified heuristically as satellite-leaning in a Data Vault model. Its primary key is a business key (COHORT_NAME) rather than a generated surrogate, and it carries descriptive attributes together with references to two parent entities: IGS_PR_STAT_TYPE (statistics type) and IGS_RU_RULE (ranking rule). This structure suggests modeling IGS_PR_COHORT as a satellite or reference entity attached to those parents, with IGS_PR_COHORT_INST operating as a dependent child table.

Key Information Stored

The documented physical schema in ETRM 12.1.1 lists 16 columns. The most operationally significant are:

• COHORT_NAME — the primary key column of IGS_PR_COHORT_PK and also the sole unique index (IGS_PR_COHORT_U1). It is the business identifier of the cohort and the natural join column to dependent tables.
• DESCRIPTION — the descriptive label for the cohort.
• ORG_UNIT_CD — the organizational unit under which the cohort is defined, enabling institutional partitioning of rank calculations.
• STAT_TYPE — foreign key to IGS_PR_STAT_TYPE, defining the class of statistics or ranking the cohort applies to.
• TIMEFRAME — the period over which the cohort is evaluated.
• DFLT_DISPLAY_TYPE — the default presentation mode for cohort results.
• DENSE_RANK_IND — controls whether ranking is computed using dense rank semantics.
• INCL_ON_TRANSCRIPT_IND — indicates whether the cohort ranking appears on student transcripts.
• INCL_ON_STUD_ACAD_HIST_IND — indicates whether the ranking is surfaced on the student academic history.
• RULE_SEQUENCE_NUMBER — foreign key to IGS_RU_RULE, tying the cohort to its ranking rule definition.
• CLOSED_IND — flags the cohort as inactive and prevents further use.
• The audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS WHO columns capturing row-level change history.

The table is documented as not implemented in the reference database, and its documented status is obsolete, so its columns reflect the historical schema rather than an active production deployment.

Common Use Cases and Queries

Typical reporting scenarios include listing active cohorts, retrieving cohorts for a specific statistics type, and joining cohorts to their ranking rules and dependent instances. Representative patterns:

• List open cohorts with descriptions: SELECT COHORT_NAME, DESCRIPTION FROM IGS_PR_COHORT WHERE CLOSED_IND = 'N';
• Join to statistics type: SELECT c.COHORT_NAME, s.* FROM IGS_PR_COHORT c, IGS_PR_STAT_TYPE s WHERE c.STAT_TYPE = s.STAT_TYPE;
• Join to ranking rules: SELECT c.COHORT_NAME, r.* FROM IGS_PR_COHORT c, IGS_RU_RULE r WHERE c.RULE_SEQUENCE_NUMBER = r.RULE_SEQUENCE_NUMBER;
• Retrieve dependent cohort instances: SELECT i.* FROM IGS_PR_COHORT_INST i WHERE i.COHORT_NAME = :cohort_name;

Analysts migrating or auditing legacy Student System data should treat results cautiously given the obsolete product status.

Related Objects

• IGS_PR_STAT_TYPE — parent of IGS_PR_COHORT via STAT_TYPE.
• IGS_RU_RULE — parent of IGS_PR_COHORT via RULE_SEQUENCE_NUMBER.
• IGS_PR_COHORT_INST — child of IGS_PR_COHORT via COHORT_NAME.
• IGS_PR_COHORT_PK / IGS_PR_COHORT_U1 — the primary key constraint and unique index on COHORT_NAME.