Edit - MetricsWebApp

Topic

Category

Title

Location

Definition

Student Type

Display

Statutory Reference

Link

Data Source

PseudoCode

Step 1
SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER,
SB00 STUDENT-IDENTIFIER,
GI03 TERM-IDENTIFIER,
CB01 COURSE-DEPARTMENT-NUMBER,
XB00 SECTION-IDENTIFIER,
CB00 COURSE-CONTROL-NUMBER,
SX04 ENROLLMENT-GRADE,
SX03 ENROLLMENT-UNITS-EARNED,
SXD2 ENROLLMENT-CREDIT-STATUS,
SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS
FROM term enrollment data
WHERE SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0.0
AND SX03 ENROLLMENT-UNITS-EARNED > 0.00
AND SX03 ENROLLMENT-UNITS-EARNED < 75.00
AND LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','D','P')
AND SXD2 ENROLLMENT-CREDIT-STATUS IN ('D','T','C','S')
UNION
SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER,
SB00 STUDENT-IDENTIFIER,
GI03 TERM-IDENTIFIER,
CB01 COURSE-DEPARTMENT-NUMBER,
XB00 SECTION-IDENTIFIER,
CB00 COURSE-CONTROL-NUMBER,
SX04 ENROLLMENT-GRADE,
SX03 ENROLLMENT-UNITS-EARNED,
SXD2 ENROLLMENT-CREDIT-STATUS,
SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS
FROM term enrollment data
WHERE SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0.0
AND (SX03 ENROLLMENT-UNITS-EARNED = 0.00
OR SX03 ENROLLMENT-UNITS-EARNED > 74.99)
AND LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','D','F','I','N','W','P','X')
AND SX04 ENROLLMENT-GRADE <> 'IP'
AND SXD2 ENROLLMENT-CREDIT-STATUS IN ('D','T','C','S')

Step 2
--collapse enrollment records by course, credit status, grade, and student demographics

SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER,
SB00 STUDENT-IDENTIFIER,
GI03 TERM-IDENTIFIER,
CB01 COURSE-DEPARTMENT-NUMBER,
XB00 SECTION-IDENTIFIER,
CB00 COURSE-CONTROL-NUMBER,
SXD2 ENROLLMENT-CREDIT-STATUS,
SX04 ENROLLMENT-GRADE,
SB04 STUDENT-GENDER,
STD1 STUDENT-AGE-AT-TERM,
derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE),
COUNT(*)
FROM results above and term data

Step 3
--apply success criteria

LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','P')
OR LEFT(SX04 ENROLLMENT-GRADE,2) IN ('IA','IB','IC')
OR SX04 ENROLLMENT-GRADE = 'IPP'

Step 4
--apply retention criteria

SX04 ENROLLMENT-GRADE NOT IN ('W ','DR ','XX ')

Selection Criteria

Denominator

Value Type

Notes

Political Context

Intent

Collection Guidance

Authoritative Source

Edit Metric

Metric