Delete Metric
Are you sure you want to delete this?
Metric
- Topic
- DataMart
- Category
- Students Services
- Link
- Title
- Special Population/Group Student Count
- Definition
- Student Type
- Display
- Data Source
- 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'
- Denominator
- Value Type
- Notes
- Political Context
- Intent
- Collection Guidance