DARTS : Cohort process and UM_RETEN_COHT_VW discussion with IR group

Date

25 Apr 2019

Attendees

• IR group

• DARTS

Goals

• Review of cohort file upload and new retention view

Discussion items

1. Review for Creating and Managing a Retention Cohort Group
   1. Changing the due date for uploading file
      • Fall cohort (including summer entrants) – November 15
      • Spring cohort – March 15
        
        
2. Review for Proposed new retention cohort view- UM_RETEN_COHT_VW

   1. Ethnicity calculation : Which fields do you use?

      calculation for ethnicity (alias A= STUD_EXTRACT) Expand source

      CASE WHEN A.Citizenship_Status = '4' THEN 'Nonresident Alien'
      WHEN A.Ethnic_Group = '3' THEN 'Hispanic/Latino'
      WHEN A.Hisp_Latino = 'Y' THEN 'Hispanic/Latino'
      WHEN A.Um_Multiple_Ethnic = 'Y' THEN  '2 or More Races'
      WHEN A.Ethnic_Group = '1' THEN 'White'
      WHEN A.Ethnic_Group = '2' THEN 'Black/African American'
      WHEN A.Ethnic_Group = '4' THEN 'Asian'
      WHEN A.Ethnic_Group = '5' THEN 'American Indian/Alaska Native'
      WHEN A.Ethnic_Group = '7' THEN 'Native Hawaiian/Pacific Islander'
      WHEN A.Ethnic_Group = '6' THEN 'Unknown'
      ELSE 'Unknown' END

   2. Any additional fields needed?
      
      
   3. Timing for creation : probably in July or August

Action items