Metric Details

Category: Students Services
Title: Special Population/Group Student Count
Location: https://datamart.cccco.edu/Services/Special_Pop_Count.aspx
PseudoCode: SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, SB00 STUDENT-IDENTIFIER, GI03 TERM-IDENTIFIER, SXD2 ENROLLMENT-CREDIT-STATUS, CASE WHEN SXD4 TOTAL-HOURS < 2000 THEN SXD4 TOTAL-HOURS ELSE 0 END FROM term student data, term enrollment data, term section data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','D','E','F','G') AND SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0 AND XB01 SECTION-ACCOUNTING-METHOD <> 'O'
Selection Criteria: CASE WHEN SXD4 TOTAL-HOURS < 2000 THEN SXD4 TOTAL-HOURS ELSE 0 END FROM term student data, term enrollment data, term section data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','D','E','F','G') AND SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0 AND XB01 SECTION-ACCOUNTING-METHOD <> 'O'