Metric Definition Dictionary
122C (1,2,3,4,6): General Admit Student Cohort
All students who enrolled as first-time in higher education general admit credit students in at least one primary term of the selected year with a minimal credit enrollment at the selected college who are tracked for one, two, three, four and six years from first term of enrollment
Value Type
Unduplicated Count of Students
Data Source(s)
Chancellor's Office Management Information System
A student could be included as part of the first-time cohort at more than one college if the student's first-time general admit enrollment is in the same term with 0.5 credit units at each college
This definition does NOT include students who may have been enrolled in the selected year or any time prior as a special student as long as the student enrolls as a first-time in higher ed general admit credit student in any term of the year
If a student is a first-time general admit credit student in Spring 2020 (or later) and has "EW" for all credit courses in that term, then the student is included in the SAll Student Cohort since colleges differed in how they applied EW enrollments in Spring 2020 (or later) due to the pandemic
However, if a student is a first-time general admit credit student in any other term besides Spring 2020 and has "EW" for all credit courses in that term, then the student is not included in the SAll Student Cohort
Students who receive "MW" in all courses in their first general admit credit term are not included in the Cohort
Min(GI03) for First Term of General Admit Enrollment
Student who met the following criteria:
Student appears as a first-time general admit credit student in the system in the selected year at the selected college requiring enrollment in a primary term if first general admit term is not a primary term in the selected year
WHERE [GI03 = Min(GI03) in the system at the selected college
AND IF Min(GI03) IS IN (5YY, 1YY, 6YY)
THEN GI03 must also be IN (7YY, 3YY, 8YY, 2YY, 4YY)
AND SXD2 IN (T, D, S)
AND STD7 in (A, B, C, D, E)
AND SB11 NOT IN 10000, 21000]
AND has a minimal credit enrollment in the system at the selected college
AND [SXD3 >=0.5 units at the selected college in the selected year]
AND where the student did not earn an Excused Withdrawal or Military Withdrawal in ALL credit courses in their first term as long as their first term was not Spring 2020 or a term in academic year 2020-21, 2021-22, 2022-23, or 2023-24
WHERE EITHER [MIN(GI03) NOT IN (203, 204, 205, 206, 207, 208, 211, 212, 213, 214, 215, 216, 217, 218, 221, 222, 223, 224, 225, 226, 227, 228, 231, 232, 234, 244)
Count (SX04) IS NOT EQUAL TO count (SX04) IN (EW, MW) in the first term at the selected college
OR if first term for student is Spring 2020, Fall 2020, Winter 2021 (for quarter schools) Spring 2021, Fall 2021, Winter 2022 (for quarter schools), Spring 2022 terms, Fall 2022, Winter 2023 (for quarter schools) Spring 2023, Fall 2023, Winter 2024 (for quarter schools) or Spring 2024, then include students with Excused Withdrawals in all credit courses and only exclude students with Military Withdrawals in all credit courses
OR MIN(GI03) IS IN (203, 204, 205, 206, 207, 208, 211, 212, 213, 214, 215, 216, 217, 218, 221, 222, 223, 224, 225, 226, 227, 228, 231, 232, 234, 244)
Count (SX04) IS NOT EQUAL TO count (SX04) IN (MW) in the Spring 2020, Fall 2020, Winter 2021 (for quarter schools), Spring 2021, Fall 2021, Winter 2022 (for quarter schools), Spring 2022, Fall 2022, Winter 2023 (for quarter schools), Spring 2023, Fall 2023, Winter 2024 (for quarter schools), and Spring 2024 terms at the selected college]
AND in the selected year
WHERE GI03 is within the selected year
AND never had a valid course enrollment at any postsecondary institution except CA community colleges while the student was 18 or older
WHERE [segment IS IN (CSU, UC, ISP, OOS)
AND tfr_in_inst_type IS IN (2, 4)]
AND when the student was 18 or older
AND (Oct. 15th in the selected year - SB03) ≥ 18 years
AND at any time up to and including the selected year
WHERE GI03 is any time up to and including the selected year]
AND students will be tracked from the calculated first term of entry with preceding summer term enrollment treated like fall term enrollment for 1, 2, 3, 4, or 6 years