Metric Details

Category: Courses/Calendar
Title: Transfer Volume
Location: https://datamart.cccco.edu/Outcomes/Student_Transfer_Volume.aspx
PseudoCode: --find students earliest enrollment date at 4 year institution SELECT SSN, MIN(DATE_OF_XFER) FROM XFER_BUCKET WHERE TFR_IN_INST_TYPE = '4' GROUP BY SSN --when there are multiple records for a date order by segment priority ISP, OOS, UC, CSU SELECT SSN, XFER_DATE, MAX(SEGMENT PRIORITY) FROM above results and segment priority SELECT SSN, XFER_DATE, SEGMENT FROM above results WHERE SEGMENT = max priority segment
Selection Criteria: (The table below needs documentation.) FROM XFER_BUCKET