Metric Definition Dictionary
434S (W): Number of AA or AS Degrees (Not for Transfer) Awarded
Count of AA or AS Degrees (not for transfer) 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
COCI file used by MIS for SCFF to determine if AA or AS is for transfer
Count of awards for 122SW students enrolled in the selected year in the district:
Associate degree at the selected college
SP02 in (A, S)
AND not flagged as an associate degree for transfer (AA-T or AS-T) in the 12-13-19 COCI ADT file at the selected college
WHERE [AAT_AST Column NOT IN (A,S) AND
ControlNumber found in ControlNumber Column]
OR [ControlNumber NOT found in ControlNumber Column]]
AND at the selected college
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)