Creating and Managing a Retention Cohort Group

This document details the steps to execute in order to upload cohorts and manage cohorts for retention and graduation rates. 

Detailed Information

Table of Contents

• Step One: Creating a Retention Cohort File
• Step Two: Uploading Retention Cohort
• Step Three: Checking Data
• Step Four: Manually Managing Cohort Data

The Institutional Research Office on each campus populates the cohort of each fall and spring term with students who are enrolled on the census date. For the fall term, students admitted in the preceding summer term who are enrolled on the fall census date are included in the fall cohort. A student's membership in a cohort group is maintained in the UM_STDNT_COHORT table. For complementary purposes, additional types of cohorts can be set up using the UM_STDNT_COHORT table; however, this document details the retention cohort only. Each IR Office can choose either 1) to create own csv file and upload or 2) to use automated process.

If your office chose to use csv file, go to Step One. If automated process, go to Step Two.

Step One: Creating a Retention Cohort File 

A .csv format file should be created in order to upload the cohort. The file should contain these three fields:

• EMPLID
• Cohort Term (Fall or Spring. Summer should be included in Fall. e.g., 1910)
• Admit Type 
  • FYR- First time
  • TRF- Transfer
  • GRD- Graduate

Institutions need to be sure that the cohort data loaded on Admit Type follows the IPEDS Definitions:

First-time student (undergraduate): A student who has no prior postsecondary experience (except as noted in this definition) attending any institution for the first time at the undergraduate level. This includes students enrolled in academic or occupational programs. It also includes students enrolled in the fall term who attended college for the first time in the prior summer term, and students who entered with advanced standing (college credits or postsecondary formal award earned before graduation from high school).

Transfer-In Student: A degree/certificate-seeking undergraduate student entering the IPEDS reporting institution for the first time but known to have previously enrolled at a different postsecondary institution (not as a high school student). The student may transfer with or without credit. For systems of coordinated institutions (multi-campus system), students are to be identified as transfer-in students upon entering an institution from another institution within the same coordinated system.

Using this uploaded cohort information (EMPLID, Cohort Term, and Admit Type), and student's full or part-time status (calculated by combining the cohort information with student semester credit hours on census day), retention can be reported to IPEDS for full time and part time cohorts, and for First-Year and Transfer cohorts. 

Return to the Top

Step Two: Uploading Retention Cohort

1. Log in to MaineStreet CSPRD and go to: University of Maine System > Records and Enrollment > Batch Processing > Assign Cohorts
2. If you don’t have a Run Control ID, create one by clicking “Add a New Value”
3. If you are attaching your own csv file, check below. If you are using the automated process, go to #4.

• Select your institution & academic career
• Cohort code should be “RETENTION”.
• Effective Date should be census day.
• Pick “Add to Previous Data” for the box for "If student is in the Cohort".
• Check the box for “Load from File”.
• Attach file by clicking the paper clip icon and choose file
• Go to step #5.

4. If you are using the automated process, check below:

• Select your institution and Academic Career
• Cohort code should be “RETENTION”.
• Effective Date should be census day.
• Enter the From Term and the To Term

5. Click “Run” and click “OK” on the next screen.
6. Go to “Process Monitor” and wait till the Run Status changes to “Success” (You might need to click “Refresh” a few times.)

Return to the Top

Step Three: Checking Data

1. Run the query, UMS_DTS_COHORT_COUNT, in CSPRD to check the count of IDs uploaded. If you would like to get a list of EMPLID, run UMS_DTS_COHORT_EMPLID.

2. Run the query, UMS_DTS_COHORT_VALIDATION, in CSPRD to check for errors.         
   Error type:

• Acad_career does not match with Admit_type  (e.g., Acad_career=UGRD & admit_type=GRD)
• More than one ID within the same cohort term

Return to the Top

Step Four: Manually Managing Cohort Data

Log in to MaineStreet CSPRD and go to: University of Maine System > Records and Enrollment > Add/Maintain Student Cohort

Add a student to a Cohort

1. Click Add a New Value.
2. Enter an EMPLID, Institution, Career, and Cohort Code. Click Add. The Cohort Code should be RETENTION.
3. Enter an Effective Date.
4. Check the Manual Override checkbox. Doing so indicates that this data was entered manually as opposed to having been entered via the batch process.
5. Enter the Cohort Term.
6. The Cohort Type is derived automatically from the Admit Type listed on the admissions application associated with the student's degree-seeking program. You may override this value.
7. If applicable, check the Enrolled in Summer Term and enter the Summer Term.
8. If applicable, check the Exclude from Cohort and enter the Reason.
9. The enrollment status detail will display the student's enrollment status and load at various points throughout the student's Cohort Term.
10. The ID of the user adding the data is captured along with the date of the action.

Delete a student from a Cohort

1. Log in to MaineStreet CSPRD and go to: University of Maine System > Records and Enrollment > Add/Maintain Student Cohort. Find the student
   
2. Click the delete icon
   

Edit a Student's Cohort Assignment

1. Log in to MaineStreet CSPRD and go to: University of Maine System > Records and Enrollment > Add/Maintain Student Cohort. Find the student
2. Check the box for "Manual Override". Doing so indicates that this data was entered manually as opposed to having been entered via the batch process.
    
3. Make the necessary changes to the student's cohort assignment. The ID of the user adding the data is captured along with the date of the action.

Add a new row for existing students

1. Log in to MaineStreet CSPRD and go to: University of Maine System > Records and Enrollment > Add/Maintain Student Cohort. Find the student
2. Click the "+" icon to add a new row. 
   
3. Check the box for "Manual Override". Enter the data and Save it.

Return to the Top

Environment

• Campus Solutions/MaineStreet  CSPRD