Metric Definition Dictionary
401S (W): Number of Locally Issued Certificates Awarded
Count of locally-issued 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
Count of awards for 122SW students enrolled in the selected year in the district:
Locally issued certificate at the selected college
SP02 = E
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)