Data Pipeline Interchanges - Special Education IEP

Overview

The Special Education IEP Interchange is a set of three files which contain Special Education and CEIS data for the school year: Special Education Child, Special Education Participation, and Coordinated Early Intervening Services.  

The Special Education Child File contains data related to the student’s demographic information. The Special Education Participation file contains data related to the student’s participation in special education. The Coordinated Early Intervening Services File contains information on students receiving CEIS funded by federal dollars.

This information is used to make up the following snapshots: Special Education December Count, Special Education End-of-Year and Special Education Discipline.

File Layout and Definitions

2023-2024

• 2023-2024 Special Education Child File Layout and Definitions (PDF) (posted 03/30/2023)
• 2023-2024 Special Education Participation File Layout and Definitions (PDF) (updated 06/13/2023)
• 2023-2024 Coordinated Early Intervening Services (CEIS) File Layout and Definitions (PDF) (posted 03/30/2023)

Business Rules

2023-2024

• 2023-2024 Special Ed Child File Business Rules (XLS) (updated 11/21/2023)
• 2023-2024 Special Ed Participation File Business Rules (XLS) (updated 11/21/2023)
• 2023-2024 CEIS File Business Rules (XLS) (posted 10/02/2023)

File Formatting

• Pipeline only accepts file extensions of: csv txt xls xlsx
• You need a header row (in first row)
• Pipeline only accepts field delimiters of: , | ~
• Include leading zeros (0) for required fields (for instance 01 or 02 for gender)

Templates

2023-2024

• 2023-2024 Special Education Child File Template (XLS) (posted 10/02/2023) 
• 2023-2024 Special Education Participation File Template (XLS) (posted 10/02/2023)
• 2023-2024 Coordinated Early Intervening Services (CEIS) File Template (XLS) (posted 10/02/2023)

Trainings

• 2023-2024 Special Education IEP Interchange Training (PPTX) (posted 10/30/2023)
• Overview of Paths 1, 2, and 3 Training Video (MP4) (posted 04/15/2021)
• Tuition Contract Reporting in the Participation File Training Video (MP4) (posted 10/20/2021)
• Parentally Placed in Private School Training Video (MP4) (posted 04/05/2022)
• Overview of Caseload Match- December Count Snapshot Training Video (MP4) (posted 10/20/2021)
• Educational Orphans and Students in Detention Centers Training Video (MP4) (posted 04/15/2021)
• Pupils Attendance Information Codes Training Video (MP4) (11/23/2020)
• Educational Environment Codes Training Video  (MP4) (posted 12/07/2020)

Additional Resources

• Online Learning and Education Environments (posted 07/20/2020)
• Reasons for Delay (DOC) (updated 04/06/2022)
• Detention Center Students-December Count Guidance (DOCX)(updated 10/29/2020)
• Educational Orphans Guidance (DOCX) (posted 05/21/2019)
• 2022-2023 Sped IEP Interchange Summary of Changes (DOCX) (posted 03/29/2022)
• 2023-2024 Sped IEP Interchange Summary of Changes (DOCX) (updated 06/09/2023)
• Special Education December Count Grant Codes (XLS) (updated 10/18/2021)
• Save CSV Leading Zeros (DOCX)
• Grade to Age Table (PDF)
• Pupils Attendance Information Code Flow Chart
• Pupils Attendance Information Codes (PDF)
• December Count Educational Environments (updated 03/04/2020)
• Allowable Approved Facility Schools and Other Agency Codes

Contact: SpedEndOfYear@cde.state.co.us