Delete Metric
Are you sure you want to delete this?
Metric
-
Topic
-
DataMart
-
Category
-
Students/Headcounts
-
Link
-
-
Title
-
Part Time/Full Time (Unit Load) Status
-
Definition
-
-
Student Type
-
-
Display
-
-
Data Source
-
-
Location
-
https://datamart.cccco.edu/Students/Unit_Load_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, ## is this also used for day/evening? 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 IN ('A','B','C','F')
-
Denominator
-
-
Value Type
-
-
Notes
-
-
Political Context
-
-
Intent
-
-
Collection Guidance
-