UM_COHORT_TBL - Student Cohort

This table defines the descriptions of UM_COHORT_CODE per institution.
The UM_COHORT_CODE is widely used in UM_STDNT_COHORT - Student Cohort table.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

The most common UM_COHORT_CODE is 'RETENTION'.

How to Create Cohort Definition

A user must have either the S_SR_COHORT_SUPERUSER or S_SR_SUPERUSER security role to manage this data.
Log in to CSPRD: Navigator> University of Maine System > Set Up UMS > Records and Enrollment > Cohort Table.

  1. Click Add a New Value.
  2. Enter an Institution, Academic Career, and Cohort Code. Click Add. 
  3. Enter an Effective Date of 01/01/1901.
  4. Enter a Short Description and a Description. Click Save. 
Key Record.Fieldname Format XLAT Heading Text
Key ACAD_CAREER - Academic Career Char4   Career
  DESCR - Description Char30   Descr
  DESCRSHORT - Short Description Char10   Short Desc
Key EFFDT - Effective Date Date   Eff Date
  EFF_STATUS - Status as of Effective Date Char1 N Status
Key INSTITUTION - Academic Institution Char5   Institution
Key UM_COHORT_CODE - Cohort Code Char10   Cohort
  UM_COHORT_EFFDT - Assign if Enrolled on or after Char1 N Effective Date
Submit an Inquiry or Request to DARTS Print Article

Related Articles (2)

This document provides the detailed steps to perform the batch cohort upload process.
This document details the steps for handling retroactive withdrawals in Cohort Tables.

Related Services / Offerings (1)

Submit an inquiry about UMS Data (except Data Governance)