Delete Metric
Are you sure you want to delete this?
Metric
- Topic
- DataMart
- Category
- Outcomes
- Link
- Title
- Program Awards
- Definition
- Student Type
- Display
- Data Source
- 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'
- Denominator
- Value Type
- Notes
- Political Context
- Intent
- Collection Guidance