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
| Back to List