--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