DISCOVERER
COHORT FACTS BUSINESS AREA
COHORT FACTS FOLDER

Year X Graduation Category Code/Desc (in the underlying IRDB table called COHORT_FACTS this field is RTXX_RETENTION_CATEGORY_CODE)
1	Still Enrolled
2	Awarded Certificate
3	Awarded Associate Degree
4	Awarded Baccalaureate Degree
5 	Other

Year X Retention Category Code/Desc
1	Earned Degree Pursued
2	Enrolled Same College
3	Enrolled Different College
4	Earned Lower Degree
5 	Other

X-Year Outcome Category Code
01	Earned Degree Pursued (or higher) from Same College
02	Earned Degree Pursued (or higher) from Other CUNY College
03	Still Enrolled for Degree Pursued (or higher) at Same College
04	Still Enrolled for Degree Pursued (or higher) at Other CUNY College
05	Earned Lower Degree from Same College
06	Earned Lower Degree from Other CUNY College
07	Still Enrolled for Lower Degree at Same College
08	Still Enrolled for Lower Degree at Other CUNY College
09	Still Enrolled as Non-Degree Student at Same College
10	Still Enrolled as Non-Degree Student at Other CUNY College
11	Other

X=NUMBER OF YEARS FROM ENTRY FOR OUTCOME OF INTEREST

****************************************
*The code below shows how Discoverer 
*Retention Category Code is computed in 
*the Discoverer End-User Layer.
****************************************
Year X Retention Category Code

CASE WHEN "Year 1 Fall - Degree Pursued Level Code" = '1' 
	AND "Year X Degree - Degree Earned Level Code" IN ('1','2','3') 
	AND "Year X Degree - Headcount" = 1 THEN '1' 
     WHEN "Year 1 Fall - Degree Pursued Level Code" = '2' 
     	AND "Year X Degree - Degree Earned Level Code" IN ('2','3') 
     	AND "Year X Degree - Headcount" = 1 THEN '1' 
     WHEN "Year 1 Fall - Degree Pursued Level Code" = '3' 
     	AND "Year X Degree - Degree Earned Level Code" = '3' 
     	AND "Year X Degree - Headcount" = 1 THEN '1' 
     WHEN "Year 1 Fall - College ID" = "Year X+1 Fall - College ID" 
     	AND "Year X+1 Fall - Headcount" = '1' 
     	AND "Year X+1 Fall - Degree Pursued Level Code" <> '9' THEN '2' 
     WHEN "Year 1 Fall - College ID" <> "Year X+1 Fall - College ID" 
     	AND "Year X+1 Fall - Headcount" = 1 
     	AND "Year X+1 Fall - Degree Pursued Level Code" <> '9' THEN '3' 
     WHEN "Year 1 Fall - Degree Pursued Level Code" = '2' 
     	AND "Year X Degree - Degree Earned Level Code" = '1' 
     	AND "Year X Degree - Headcount" = 1 THEN '4' 
     WHEN "Year 1 Fall - Degree Pursued Level Code" = '3' 
     	AND "Year X Degree - Degree Earned Level Code" IN ('1','2') 
     	AND "Year X Degree - Headcount" = 1 THEN '4' 
     ELSE '5' 
END

****************************************
*The code below shows how Discoverer 
*Outcome Category Code is computed in 
*the Discoverer End-User Layer.
****************************************
X-Year Outcome Category Code
	
CASE WHEN 
	("Year X Degree - Degree Earned Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
 		AND ("Year X Degree - College ID" = "Year 1 Fall - College ID" OR "Year X Degree - College ID" = '21'))
	OR ("Year X-1 Degree - Degree Earned Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
 		AND ("Year X-1 Degree - College ID" = "Year 1 Fall - College ID" OR "Year X-1 Degree - College ID" = '21'))
	OR ("Year X-2 Degree - Degree Earned Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
 		AND ("Year X-2 Degree - College ID" = "Year 1 Fall - College ID" OR "Year X-2 Degree - College ID" = '21'))
***ETC. FOR EACH YEAR UNTIL YEAR 1 ****
THEN '01' 
WHEN "Year X Degree - Degree Earned Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X Degree - College ID" <> "Year 1 Fall - College ID" 
THEN '02' 
WHEN "Year X+1 Fall - Degree Pursued Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X+1 Fall - College ID" = "Year 1 Fall - College ID" 
	AND "Year 5 Fall - Degree Pursued Level Code" <> '9' 
THEN '03' 
WHEN "Year X+1 Fall - Degree Pursued Level Code" >= "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X+1 Fall - College ID" <> "Year 1 Fall - College ID" 
	AND "Year X+1 Fall - Degree Pursued Level Code" <> '9' 
THEN '04' 
WHEN "Year X Degree - Degree Earned Level Code" < "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X Degree - College ID" = "Year 1 Fall - College ID" 
THEN '05' 
WHEN "Year X Degree - Degree Earned Level Code" < "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X Degree - College ID" <> "Year 1 Fall - College ID" 
THEN '06' 
WHEN "Year X+1 Fall - Degree Pursued Level Code" < "Year 1 Fall - Degree Pursued Level Code" 
	AND "Year X+1 Fall - College ID" = "Year 1 Fall - College ID" 
THEN '07' WHEN "Year X+1 Fall - Degree Pursued Level Code" < "Year 1 Fall - Degree Pursued Level Code"
	AND "Year X+1 Fall - College ID" <> "Year 1 Fall - College ID" 
THEN '08' 
WHEN "Year X Fall - Degree Pursued Level Code" = '9' 
	AND "Year X+1 Fall - College ID" = "Year 1 Fall - College ID" 
THEN '09' WHEN "Year X+1 Fall - Degree Pursued Level Code" = '9' 
	AND "Year X+1 Fall - College ID" <> "Year 1 Fall - College ID" 
THEN '10'
ELSE '11'
END