Metric Details

Category: Outcomes
Title: Program Awards
Location: https://datamart.cccco.edu/Outcomes/Program_Awards.aspx
PseudoCode: SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, SB00 STUDENT-IDENTIFIER, GI03 TERM-IDENTIFIER, SP01 STUDENT-PROGRAM-TOP-CODE, SP02 STUDENT-PROGRAM-AWARD, SP03 STUDENT-PROGRAM-AWARD-EARNED, SP04 STUDENT-PROGRAM-CONTROL-NUMBER, '' as CDCP_STATUS FROM program awards data --set CDCP_STATUS using COCI program data SET CDCP_STATUS = COCI program data CDCP_TYPE FROM above results and COCI program data --set ADT awards using COCI program data SET AWARD = 'U' FROM above results and COCI program data WHERE SP02 STUDENT-PROGRAM-AWARD IN ('A','S') AND COCI program data AAT_AST = 'A' SET AWARD = 'V' FROM above results and COCI program data WHERE SP02 STUDENT-PROGRAM-AWARD IN ('A','S') AND COCI program data AAT_AST = 'S' --aggregate SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, GI03 TERM-IDENTIFIER, AWARD, SP01 STUDENT-PROGRAM-TOP-CODE, CDCP_STATUS, COUNT(*) FROM above results
Selection Criteria: FROM program awards data WHERE SP02 STUDENT-PROGRAM-AWARD IN ('A','S') AND COCI program data AAT_AST = 'S'