Metric Definition Dictionary
420S (W): Number of Chancellor’s Office Approved Credit or Noncredit Certificates Awarded
Count of Chancellor’s Office-approved credit or noncredit certificates awarded in the selected year on the selected TOP code for students and who were enrolled in the district in the selected year where and when the student earned the award
Value Type
Count of Awards
Data Source(s)
Chancellor's Office Management Information System
Excludes certificates that require less than 6 units (SP02 = O) or less than 48 contact hours (SP02 = G)
Count of awards for 122SW students enrolled in the selected year in the district:
EITHER Chancellor’s Office approved credit certificate at the selected college
SP02 IN (B, L, T, F, M, N)
OR Chancellor’s Office approved noncredit certificate at the selected college
OR SP02 IN (H, I, J, K, P, Q, R)
AND awarded on a valid TOP code
AND CB03 is a valid TOP code in the Taxonomy of Programs manual
AND in the selected year
WHERE GI03 is within the selected year
AND with a record in the Student Enrollment Data Elements (SX) file in the selected year on any valid TOP code in the district
AND [Has a value in the Student Enrollment Data Elements (SX) file
WHERE GI03 is within the selected year in the district AND
CB03 is any valid TOP code in the Taxonomy of Programs manual]
AND an award for a given student is defined as a unique combination of Award Type, DateOfAward, RecordId, and ProgramCode
AND unique (SP02, SP03, RecordId, SP04)