Special Programs District of Columbia
Special Programs District of Columbia
Breadcrumbs

DL Subclass I Advanced

The Subclass I Advanced report shows data about when services begin, how plans are created, and whether timelines are being followed. It helps schools understand how well they are meeting the needs of students with disabilities.

Submission requirements

  • Includes students who are between the ages of three and five as of the current school year.

  • Counts students who have an active or recently active IEP plan during the reporting period.

  • Includes students who were enrolled in the reporting district (not in non-public placements) between:

    • September 15 of the start of the school year, and

    • June 30 of the end of the school year.

Enrollment and Plan Requirements

  • The student’s enrollment dates must overlap with the dates of their IEP plan.

  • Students who exited the district before their IEP meeting date are excluded from the report.

  • Students with IEPs that were only amended during the school year are omitted.

Additional Notes

  • Both active and deactivated student records are included.

  • Duplicate deactivated profiles are excluded when reports are consolidated.

Generate report

  1. From the Reporting menu, choose Advanced report.

  2. Click Data Reporting, then click Subclass I Advanced.

  3. Click Process Schedule. Give a name for the report to be generated.

  4. For the field Report Parameters, select a “Year Range Selection” using the drop-down.

  5. For the field Processing Method, use the drop-down to select Process Now In Foreground.

  6. Click Process Now.

  • To review the latest data, click Unprocess and repeat steps 3 to 5.

  • Click the student count to display the student details, including eligibility data. The columns here are customizable. User can add columns or fields using the Customize Columns For This Drilldown option.

Student Counts for KPIs

Data Element

Description

Data Source

Database Field Name

Number of children counting toward Subclass I

“Count of distinct USIs” having a 1 in the “Subclass I {month}” metric.

  • {COUNT-ALL[Rules:SubclassIStudentSep]=SubCLSep}

  • {COUNT-ALL[Rules:SubclassIStudentOct]=SubCLOct}

  • {COUNT-ALL[Rules:SubclassIStudentNov]=SubCLNov}

  • {COUNT-ALL[Rules:SubclassIStudentDec]=SubCLDec}

  • {COUNT-ALL[Rules:SubclassIStudentJan]=SubCLJan}

  • {COUNT-ALL[Rules:SubclassIStudentFeb]=SubCLFeb}

  • {COUNT-ALL[Rules:SubclassIStudentMar]=SubCLMar}

  • {COUNT-ALL[Rules:SubclassIStudentApr]=SubCLApr}

  • {COUNT-ALL[Rules:SubclassIStudentMay]=SubCLMay}

  • {COUNT-ALL[Rules:SubclassIStudentJun]=SubCLJun}

  • SubCLSep

  • SubCLOct

  • SubCLNov

  • SubCLDec

  • SubCLJan

  • SubCLFeb

  • SubCLMar

  • SubCLApr

  • SubCLMay

  • SubCLJun

Total Enrollment

Total enrollments in the class for the specific month in the computed academic year.

  • {MAX(EnrollmentOnSep)[Rules: MonthOfSep]=GenEdEnrollmentSep}

  • {MAX(EnrollmentOnOct)[Rules: MonthOfOct]=GenEdEnrollmentOct}

  • {MAX(EnrollmentOnNov)[Rules: MonthOfNov]=GenEdEnrollmentNov}

  • {MAX(EnrollmentOnDec)[Rules: MonthOfDec]=GenEdEnrollmentDec}

  • {MAX(EnrollmentOnJan)[Rules: MonthOfJan]=GenEdEnrollmentJan}

  • {MAX(EnrollmentOnFeb)[Rules: MonthOfFeb]=GenEdEnrollmentFeb}

  • {MAX(EnrollmentOnMar)[Rules: MonthOfMar]=GenEdEnrollmentMar}

  • {MAX(EnrollmentOnApr)[Rules: MonthOfApr]=GenEdEnrollmentApr}

  • {MAX(EnrollmentOnMay)[Rules: MonthOfMay]=GenEdEnrollmentMay}

  • {MAX(EnrollmentOnJun)[Rules: MonthOfJun]=GenEdEnrollmentJun}

  • GenEdEnrollmentSep

  • GenEdEnrollmentOct

  • GenEdEnrollmentNov

  • GenEdEnrollmentDec

  • GenEdEnrollmentJan

  • GenEdEnrollmentFeb

  • GenEdEnrollmentMar

  • GenEdEnrollmentApr

  • GenEdEnrollmentMay

  • GenEdEnrollmentJun

Percent of children counting toward Subclass I

Calculated based on the previous two fields.

  • The report will have 10 columns for this field.

    • One for each month.

    • Starting from September through June.

  • The value is shown as a percentage rounded to one decimal point.

    • For example: 29.7%.

  • {#EVAL IIF(GenEdEnrollmentSep<>0,(SubCLSep/ GenEdEnrollmentSep)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentOct<>0,(SubCLOct/ GenEdEnrollmentOct)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentNov<>0,(SubCLNov/ GenEdEnrollmentNov)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentDec<>0,(SubCLDec/ GenEdEnrollmentDec)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentJan<>0,(SubCLJan/ GenEdEnrollmentJan)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentFeb<>0,(SubCLFeb/ GenEdEnrollmentFeb)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentMar<>0,(SubCLMar/ GenEdEnrollmentMar)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentApr<>0,(SubCLApr/ GenEdEnrollmentApr)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentMay<>0,(SubCLMay/ GenEdEnrollmentMay)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentJun<>0,(SubCLJun/ GenEdEnrollmentJun)*100, 0): 0.#} %

Not a database value.

Drill-down report field description and criteria

Data Element

Description

Data Source

Database Field Name

Reporting Year

The system shows the reporting year for the Actual Eligibility Due Date or the Projected Eligibility Due Date available in Referrals Part B.

The reporting year is defined as July 1 to June 30, with FFY19 covering the period from July 1, 2019, to June 30, 2020.

N/A (Calculated report field)

N/A (Calculated report field)

Number of children counting toward Subclass I

‘Count of distinct USIs’ having a 1 in the ‘Subclass I {month}’ metric.

When this field is used as the drill-down parameter, the following columns are displayed:

  • USI

  • Last Name

  • First Name

  • Attending School

  • {COUNT-ALL[Rules:SubclassIStudentSep]=SubCLSep}

  • {COUNT-ALL[Rules:SubclassIStudentOct]=SubCLOct}

  • {COUNT-ALL[Rules:SubclassIStudentNov]=SubCLNov}

  • {COUNT-ALL[Rules:SubclassIStudentDec]=SubCLDec}

  • {COUNT-ALL[Rules:SubclassIStudentJan]=SubCLJan}

  • {COUNT-ALL[Rules:SubclassIStudentFeb]=SubCLFeb}

  • {COUNT-ALL[Rules:SubclassIStudentMar]=SubCLMar}

  • {COUNT-ALL[Rules:SubclassIStudentApr]=SubCLApr}

  • {COUNT-ALL[Rules:SubclassIStudentMay]=SubCLMay}

  • {COUNT-ALL[Rules:SubclassIStudentJun]=SubCLJun}

  • SubCLSep

  • SubCLOct

  • SubCLNov

  • SubCLDec

  • SubCLJan

  • SubCLFeb

  • SubCLMar

  • SubCLApr

  • SubCLMay

  • SubCLJun

Total Enrollment

Total enrollments in the class for the specific month in the computed academic year.

When this field is used as the drill-down parameter, the following columns are displayed:

  • ID

  • Month

  • Year

  • Enrollment

  • Enrollment on <Month>

    • So, when September is selected, it would display for September.

    • When October is selected, it would display for October and so on for all respective months.

  • {MAX(EnrollmentOnSep)[Rules: MonthOfSep]=GenEdEnrollmentSep}

  • {MAX(EnrollmentOnOct)[Rules: MonthOfOct]=GenEdEnrollmentOct}

  • {MAX(EnrollmentOnNov)[Rules: MonthOfNov]=GenEdEnrollmentNov}

  • {MAX(EnrollmentOnDec)[Rules: MonthOfDec]=GenEdEnrollmentDec}

  • {MAX(EnrollmentOnJan)[Rules: MonthOfJan]=GenEdEnrollmentJan}

  • {MAX(EnrollmentOnFeb)[Rules: MonthOfFeb]=GenEdEnrollmentFeb}

  • {MAX(EnrollmentOnMar)[Rules: MonthOfMar]=GenEdEnrollmentMar}

  • {MAX(EnrollmentOnApr)[Rules: MonthOfApr]=GenEdEnrollmentApr}

  • {MAX(EnrollmentOnMay)[Rules: MonthOfMay]=GenEdEnrollmentMay}

  • {MAX(EnrollmentOnJun)[Rules: MonthOfJun]=GenEdEnrollmentJun}

  • GenEdEnrollmentSep

  • GenEdEnrollmentOct

  • GenEdEnrollmentNov

  • GenEdEnrollmentDec

  • GenEdEnrollmentJan

  • GenEdEnrollmentFeb

  • GenEdEnrollmentMar

  • GenEdEnrollmentApr

  • GenEdEnrollmentMay

  • GenEdEnrollmentJun

Percent of children counting toward Subclass I

Calculated based on the previous two fields.

  • The report will have 10 columns for this field.

    • One for each month.

    • Starting from September through June.

  • The value is show as a percentage rounded to one decimal point.

    • For example: 29.7%

This field just displays the percentage values and cannot be sorted further into other columns and fields.

  • {#EVAL IIF(GenEdEnrollmentSep<>0,(SubCLSep/ GenEdEnrollmentSep)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentOct<>0,(SubCLOct/ GenEdEnrollmentOct)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentNov<>0,(SubCLNov/ GenEdEnrollmentNov)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentDec<>0,(SubCLDec/ GenEdEnrollmentDec)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentJan<>0,(SubCLJan/ GenEdEnrollmentJan)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentFeb<>0,(SubCLFeb/ GenEdEnrollmentFeb)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentMar<>0,(SubCLMar/ GenEdEnrollmentMar)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentApr<>0,(SubCLApr/ GenEdEnrollmentApr)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentMay<>0,(SubCLMay/ GenEdEnrollmentMay)*100, 0): 0.#} %

  • {#EVAL IIF(GenEdEnrollmentJun<>0,(SubCLJun/ GenEdEnrollmentJun)*100, 0): 0.#} %

Not a database value.