Delete Metric
Are you sure you want to delete this?
Metric
-
Topic
-
DataMart
-
Category
-
Students/Headcounts
-
Link
-
-
Title
-
Enrollment Status
-
Definition
-
-
Student Type
-
-
Display
-
-
Data Source
-
-
Location
-
https://datamart.cccco.edu/Students/Enrollment_Status.aspx
-
PseudoCode
-
SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER,
GI03 TERM-IDENTIFIER
SB00 STUDENT-IDENTIFIER,
SB04 STUDENT-GENDER,
STD1 STUDENT-AGE-AT-TERM,
derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE),
SB11 STUDENT-EDUCATION-STATUS,
SB15 STUDENT-ENROLLMENT-STATUS,
STD4 STUDENT-ACADEMIC-LEVEL,
STD6 STUDENT-DAY-EVENING-CLASS-CODE-2,
SUM(SXD3 ENROLLMENT-UNITS-ATTEMPTED)
FROM term enrollment data
WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F')
GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER,
GI03 TERM-IDENTIFIER,
SB00 STUDENT-IDENTIFIER,
SB04 STUDENT-GENDER,
STD1 STUDENT-AGE-AT-TERM,
derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE),
SB11 STUDENT-EDUCATION-STATUS,
SB15 STUDENT-ENROLLMENT-STATUS,
STD4 STUDENT-ACADEMIC-LEVEL,
STD6 STUDENT-DAY-EVENING-CLASS-CODE-2
-
Selection Criteria
-
FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F') GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER,
-
Denominator
-
-
Value Type
-
-
Notes
-
-
Political Context
-
-
Intent
-
-
Collection Guidance
-