PATH: KY State Reporting > IDEA December 1 Count Extract

Search Term: IDEA Dec 1 Count Extract

The IDEA December 1 Child Count Extract is a report of students who have disabilities as defined under Part B of the Individuals with Disabilities Education Act, as amended in 2004 (IDEA-B 2004). This report is a total count of all students receiving special education and related services and provides count, LRE, race and other data to meet specific data requirements as contained in Section 618 of the IDEA-B 2004.

Kentucky State Edition users can run this report against schools in multiple districts.

Screenshot of the IDEA Dec 1 Count extract editor. Image 1: IDEA Dec 1 Count Extract Editor

The December 1 Child Count is submitted to the Kentucky Department of Education, which in turn submits the state aggregated data as well as local district and school level data to the United States Department of Education Office of Special Education Programs as required under IDEA-B 2004.

In addition, this count is used by the Kentucky Department of Education to determine the amount of the Exceptional Child Add-on to the Supporting Education Excellence in Kentucky (SEEK) funding formula for local districts.

This report is due to KDE on December 15th. Data should be submitted using the Secure File Transfer (DoSE Upload) Web Application.

Selection Criteria

Report logic only considers Special Ed plans and does not consider PLP plans. Special Education settings and preferences are no longer controlled through the Enrollments tab. Special Ed settings and preferences should be made through the IEP Enrollment editor on the IEP.

Click here to expand...

The following must be true in order for a student to report in the IDEA December 1 Count Extract:

The student has an active enrollment as of the Effective Date of the reporting year.
- The student’s enrollment cannot be in a Calendar or Grade Level that is excluded from state report.
  - Logic will include students whose Enrollments are marked as “Exclude”
- If the Effective Date falls on a Saturday or Sunday, enrollment records are compared to the date of the previous Friday instead.
- Include students with an ‘N’, ‘P’ or ‘S’ enrollment type within any included calendar. If students have multiple enrollments in included calendars report from the following hierarchy:
  1. Special Ed (N) enrollment
  2. Primary (P) enrollment
  3. Secondary (S) enrollment
The student's active enrollment as of the Effective Date does not have the No Show checkbox marked.
The student has an active IEP with a date range which overlaps the Effective Date entered on the extract editor.
The Valid IEP must have an enrollment status of Active, Active Referred or Inactive selected in the IEP enrollment editor.
- When the IEP has an enrollment status of Inactive, the enrollment end date must be after the Effective Date of the reporting year.
The Valid IEP must be locked.
The Valid IEP must have a Special Ed Setting (LRE) selected on the enrollment editor.
The start date for the Valid IEP must be on or before the Effective Date of the reporting year.
The start date for the IEP must be after the Effective Date of the previous year.
The start date for the Valid IEP must be earlier than the calendar end date.
The end date for the current IEP must be on or after the Effective Date of the reporting year.
The student must have a valid Evaluation Document.
- This document must meet the following date criteria:
  - The evaluation document that is used by the report and warning must have a Date of Eligibility Determination that is not more than 3 years minus 1 day prior to the Effective Date of the reporting year.
- The Date of Eligibility Determination of the evaluation document must not be later than the Effective Date of the reporting year.
- If two evaluation documents exist which both meet the date criteria, this is a training issue. The report will pull the evaluation document with the most recent Date of Eligibility Determination.
- The KYESR is not used as a valid Evaluation document. Only CSR (Conference Summary Review) documents (of any type) or KY Evaluation documents will be considered valid Evaluation documents.
- The evaluation document must be locked in the Documents editor.
The valid evaluation document must be locked.
The valid evaluation document must have a Date of Eligibility Determination that is not more than 3 years minus 1 day prior to the Effective Date of the reporting year.
The Date of Eligibility Determination must be on or before the Effective Date of the reporting year.
The student must have a Reevaluation Due Date on or after the Effective Date of the reporting year.
- The student's Reevaluation Date will always be 3 years minus one day from the Date of Eligibility Determination of the most recent valid evaluation document (CSR) unless:
  - The student has a primary disability of 15: Developmentally Delayed and the student's Date of Eligibility Determination on the valid evaluation document of the reporting year is after their 6th birthday. If this is the case, the student's Reevaluation Date is the student's 9th birthday minus 1 day.
If the student has a disability of 15: Developmentally Delayed and is greater than 8 years old on December 1st of the reporting year, the student is not included in the report.
If the IEP is marked 'Inactive', the student will still report if:
- The student has an IEP End Date that is after the Effective Date of the reporting year.
- The student meets all other criteria mentioned above.
Exclude students younger than 3 or older than 21 as of the Effective Date.

Additional Reporting Logic

Students will pull once per district in the final list. If a student has multiple valid enrollment records in the same district on the count date, the Primary enrollment is pulled.
If multiple secondary enrollments exist in the same district, but no primary enrollment exists, then the following occurs:
- The enrollment with the latest start date is identified.
- If start dates match, the open-ended enrollment is selected over an ended enrollment.
- If no open-ended enrollments exists, the enrollment with the latest end date is selected.
- If all of the above criteria does not identify a single enrollment record, the enrollment with the most recent creation date is selected.

Generating the December 1 Count Report

Enter the Effective Date. Only data as of this date is reported.
This field defaults to Dec 1st of the school year selected in the Year field in the Campus toolbar. If Dec 1st falls on a Saturday or Sunday, the reported effective date is the Friday directly before 12/01.
Select the Extract Type.
- Student Count - This extract type will generate the December 1 extract without running data validations. Users who generate the Student Count report in Batch Mode will need to run the Validation Report separately.
- Validation Report - This extract type will generate and present a series of data validations prior to generating the December 1 extract.
Select the Format of the report. The State Format (CSV) should be selected if the report is being sent to the Department of Education. Use the HTML format to review data prior to submission to the state.
Select which Grade(s) will report data OR
Select an Ad Hoc Filter.
Select the Calendars to be included in the extract. Calendars can be viewed by active year, by school or by year. The calendar selection will be defaulted to the school selected in the Campus toolbar.

Select one of the following options:

Option	Description
Generate Extract	Generate and view the report immediately.
Submit to Batch	Generates the report within the batch queue. Users can view and access the report (as well as historically batch queued December 1 reports) in the Batch Queue List editor at the bottom of the extract editor.

Screenshot of an example of the IDEA December 1 Count extract.

Image 2: IDEA December 1 Count Extract

Student Count Data Elements

Element Name	Description	Type, Format and Length	Campus Database	Campus Interface
Report Date	The date the report was run against. This will be the Effective Date entered on the extract editor.	Date DD/MM/YY	N/A	N/A
District Number	Displays district number.	Numeric, 3 digits XXX	District.number	System Administration > Resources > District > Number
School Number	Displays school number.	Numeric, 3 digits XXX	School.number	System Administration > Resources > School > Number
SSID	Student's state identification number.	Numeric, 15 digits	Person. studentNumber	Census > People > Demographics > Student Number
Last Name	Student's legal last name.	Alphanumeric, 40 characters	Identity.lastName	Census > People > Demographics > Last Name
First Name	Student's legal first name.	Alphanumeric, 35 characters	Identity.firstName	Census > People > Demographics > First Name
Date of Birth	Student's birth date.	Alphanumeric, 10 digits MM/DD/YYYY	Identity.birthDate	Census > People > Demographics > Birth Date
Disability	Primary disability assigned to the student.	Alphanumeric, 2 characters	PlanState.disability1	Student Information > General > Enrollments > Special Education > Primary Disability
Gender	Student's identified gender.	Alphabetic, 2 characters M or F	Identity.gender	Census > People > Demographics > Gender
Race/Ethnicity	Student's race/ethnicity.	Alphanumeric, 2 characters	Identity. raceEthnicityFed	Census > People > Demographics > Race/Ethinicity
English Proficiency	Student's designation of being proficient in the English language. A student will report an English Proficiency value of EL if they meet the following criteria: The student has an EL record with a Program Status = EL (Student Information > Program Participation > EL > EL > Program Status) The student must have at least one EL Service with a date range which overlaps the Effective Date entered on the extract editor (Student Information > Program Participation > EL > EL Services). The student must have at least one Instructional EL Accommodation within a date range which overlaps the Effective Date entered on the extract editor. Students who have a Program Status = EL but do not meet all of the criteria mentioned above will report a value of NEL. A value of NEL is reported If the student has an EL Program Status = “Not EL”, "Pending", "Exited EL ", or “NULL”.	Alphanumeric, 4 characters	lep.programStatus	Student Information > Program Participation > English Learners (EL) > EL
Placement	Assigned special education setting.	Alphanumeric, 2 characters	PlanState. specialEdSetting	Student Information > General > Enrollments > Special Education Fields > Setting
Age	Age of student, calculated from the birthdate of the student to the Effective Date entered on the extract editor.	Numeric, 2 characters	Not dynamically stored	Census > People > Demographics > Birth Date (Age)
Status	Students with a special education status of A or AR.	Alphanumeric, 2 characters	PlanState. specialEdStatus	Student Information > General > Enrollments > Special Education Fields > Status
IEP Start Date	Start date of the IEP.	Date field, 10 characters MM/DD/YYYY	Plan.startDate	Student Information > Special Education > Documents > IEP > Start Date
IEP End Date	End date of IEP.	Date field, 10 characters MM/DD/YYYY	Plan.endDate	Student Information > Special Education > Documents > IEP > End Date
Reevaluation Date	The student's Special Ed Reevaulation Date. The student must have a Reevaluation Due Date on or after the Effective Date of the active reporting year. The student's Reevaluation Due Date will always be 3 years minus 1 day from the Date of Eligibility Determination of the evaluation document unless the student has a Primary Disability = Developmental Delayed and the student's Date of Eligibility Determination on the document of the reporting year is after the student's 6th birthday. Then the student's Reevaluation Date is the student's 9th birthday minus 1 day. After the first Evaluation, subsequent evaluations must be marked as Reevaluation Plan in the ARC Header in order to be used in the calculation.	Date field, 10 characters MM/DD/YYYY	Not dynamically stored	Student Information > Special Education > Documents > Evaluation
State Grade	Student's grade level.	Numeric, 2 digits XX	Enrollment.grade	Student Information > General > Enrollments > Grade
Alternate Assessment	Indicates if the student is eligible. A value of Y is reported if the student has a valid IEP which indicates they are eligible to take an Alternate Assessment in the Alternate Assessment Participation Guidelines Editor. Otherwise, a value of N is reported. For students with a legacy IEP, the following two criteria must me met: The Student has been determined eligible for participation in the Alternate Assessment Program checkbox must be marked in the Alternate Assessment Participation Guidelines Editor. The Dimension A or Dimension B checkbox must be marked in the Alternate Assessment Participation Guidelines Editor. For students whose IEP is the 2018 print format and later, the following criteria must be met: The Yes. All participation Criteria #1-#4 are answered Yes, the student is eligible to participate in the KY Alternate Assessment checkbox is marked in the Alternate Assessment Participation Guidelines Editor.	Alpha Y or N	SEPAlternateAssessment. eligible SEPAlternateAssessment. particpationGuidelines SEPAlternateAssessment. dimension	Student Information > Special Ed > Documents > IEP Editor > Alternate Assessment Participation Guidelines Editor

Understanding the Validation Report

An Error Report will generate before the final extract is generated. This error report will display warning and error groups. Students appearing in these five groups will display in the extract fields. The error report will only generate when run against the active school year.

Error 1

Error 1: The following records have a Reevaluation Due Date on or before the Effective Date, they will not be included in the report.

This warning excludes students who have a disability status of 15 (Developmentally Delayed) if those students have turned 9 on or before December 1 of the reporting year.

This warning displays students whose Reevaluation Due Date is prior to the Effective Date of the active reporting year. For example, if the Effective Date of the report is 12/1/08, students whose reevaluation due date is 11/30/08 or less and still have a Special Education status of A or AR will appear in this group.

Logic looks at the most recent locked CSR when calculating the Reevaluation Date.

Fields displayed: districtNumber, schoolNumber, SSID, lastName, firstName, reevaluationDate

Screenshot of an example of Error 1.

Image 3: Error 1 Example

Error 2

Error 2: The following students are not between the ages of 3 and 21 as of the Effective Date, they will not be included on the report.

This error exists because Kentucky policy does not allow the inclusion of students under the age of 3 or over the age of 21 for this report.

Fields displayed: districtNumber, schoolNumber, SSID, lastName, firstName,birthDate

Error 3

Error 3: The following records have an IEP End Date before the Effective Date of the current year, they will not be included on the report.

The error reports active sped students whose IEP End date is before the Effective Date of the reporting year.

For example, if the Effective Date on the report is 12/1/08, students whose IEP end date is 11/30/08 or less and still have a special education status of A or AR will appear in this group.

Screenshot of an example of Error 3.

Image 4: Error 3 Example

Error 4

Error 4: The following records have an IEP End Date and Reevaluation Due Date within the prior year; they will not be included in the report.

This error reports students who have an IEP End Date prior to the Effective Date of the reporting year and failed to meet reevaluation date criteria. These students are not included on the report.

This error reports active sped students whose IEP End Date and Reevaluation Due Date is prior to the Effective Date of the reporting year.
IEPs where the IEP End Date is on or After the Effective Date -1 year and the IEP Start Date is After the Effective Date - 2 years.
If the student has a disability of 15 (developmentally delayed) and is greater than 8 years old on the Effective Date of the reporting year, the student will not pull on the error.

Screenshot of an example of Error 4.

Image 5: Error 4 Example

Error 5

Error 5: The following students have a disability of Developmentally Delayed (15) and have turned 9 on or before December 1st of the reporting year. These students will not be included on the report.

This warning displays students who have turned 9 years old on or before December 1 of the reporting year and who have a Primary Disability of Developmentally Delayed (15).

Student must turn 9 on or before the 12/01 Effective Date OR the 12/01 AFTER the Effective Date when Effective Date ≠ 12/01. The error will trigger for students who are still 8 as of the report Effective Date if they turn 9 on or before 12/01 of the reporting year.

Screenshot of an example of Error 5.

Image 6: Error 5 Example

Error 6

Error 6: The following records are missing required information. These students are missing either a Placement Setting or a Primary Disability assignment and will not be included in the report.

This warning displays student records missing a Placement Setting or Primary Disability assignment.

Screenshot of an example of Error 6.

Image 7: Error 6 Example

Error 7

Critical Error 7: Inappropriate LRE Setting/Placement based on Student Age

This warning displays preschool students, age 5 or less, whose placement code begins with 6 (e.g., 6A, 6B) and students who are 6 or older whose placement code begins with 3 (e.g., 3A, 3B).

The student must turn 5 years old on or before the 12/01 Effective Date OR 12/01 after the Effective Date if the Effective Date does not equal 12/01.
Logic only includes students whose Special Ed Setting code in their IEP begins with a 3 and who turn 6 on the 12/01 Effective Date OR 12/01 after the Effective Date if the Effective Date does not equal 12/01.
Logic only includes students enrolled in state grade levels 97, 98, or 99 whose Special Ed Setting code in their IEP begins with a 6 and who DO NOT turn 6 until after the 12/01 Effective Date OR 12/01 after the Effective Date if the Effective Date does not equal 12/01.

Error 8

Critical Error 8: Preschool Student Age 6 or Older

This warning displays students, included in the report, who have overlapping primary enrollments as of the report effective date.

The warning reports students who have overlapping Primary enrollments as of the Effective Date.
- The warning will only be able to determine if there are overlapping primary enrollments within the calendars selected in the Extract Editor.
- Effective Date determined by the Extract Editor will report in the Error

Warning 1

Warning 1: Overlapping Primary Enrollments on Effective Date Decision Tree

The warning will only be able to determine if there are overlapping primary enrollments within the calendars selected in the Extract Editor.

Effective Date determined by the Extract Editor will report in the Error

IDEA December 1 Count Extract (Kentucky)