UM_COHORT_TBL - Student Cohort

Body

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

Details

Details

Article ID: 158870
Created
Fri 5/10/24 4:27 AM
Modified
Thu 10/31/24 9:39 AM
Applies To
Faculty
Staff
Community

Related Articles

Related Articles (2)

Batch Cohort Upload Process Detail
This document provides the detailed steps to perform the batch cohort upload process.
Handling Retroactive Withdrawals in Cohort Table
This document details the steps for handling retroactive withdrawals in Cohort Tables.

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)