Overview
The student interchange is a set of four files which contain student information for a school year. The student interchange contains student demographics, student enrollment records, post-secondary information, advanced course completion data, and graduation guidelines data. This information is used in the following collections: Pupil Enrollment (Student October) Count, Special Education December Count, Special Education Discipline, Student End of Year, and Student Biographical Data.
Deadlines
The 2018-2019 Student Interchange files are open for uploads.
File Layout and Definitions
2019-2020
Note: Changes for the 2019-2020 school year are highlighted in yellow within the documents.
- 2019-2020 Student Interchange File Layout and Definitions-Student Demographic (PDF) (updated 4/1/2019)
- 2019-2020 Student Interchange File Layout and Definitions-Student School Association (PDF) (updated 4/11/2019)
- 2019-2020 Student Interchange File Layout and Definitions - Advanced Course Completion (PDF) Not required for Student October (Updated: 3/27/2019)
- 2019-2020 Student Interchange File Layout and Definitions - Graduation Guidelines (PDF) (Updated: 4/9/2019)
- Beginning in the 2020-2021 school year, the Graduation Guidelines interchange file will be a required data collection. Districts are encouraged to collect and report Graduation Guidelines data as soon as possible in preparation for the upcoming required collection. Graduation Guidelines data is not required for October Count.
2018-2019
Note: Changes for the 2018-2019 school year are highlighted in yellow within the documents.
- 2018-2019 Student Interchange File Layout and Definitions - Student Demographics (PDF) (Updated: 4/2/2018)
- 2018-2019 Student Interchange File Layout and Definitions - Student School Association (PDF) (Updated: 6/25/2018)
- 2018-2019 Student Interchange File Layout and Definitions - Advanced Course Completion (PDF) Not required for Student October (Updated: 4/2/2018)
- 2018-2019 Student Interchange File Layout and Definitions - Graduation Guidelines (PDF) (Updated: 4/2/2018)
- Beginning in the 2020-2021 school year, the Graduation Guidelines interchange file will be a required data collection. Districts are encouraged to collect and report Graduation Guidelines data as soon as possible in preparation for the upcoming required collection. Graduation Guidelines data is not required for October Count.
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)
Business Rules
2018-2019
- 2018 - 2019 Student Demographics Business Rules (XLSX) (Updated 05/07/2019)
- 2018 - 2019 Student School Association Business Rules (XLSX) (Updated 05/07/2019)
- 2018 - 2019 Student Advanced Course Completion Business Rules (XLSX) (Updated 05/07/2019)
- 2018 - 2019 Graduation Guidelines Business Rules (XLSX) (Added 05/07/2019)
Templates
2018-2019
- 2018-2019 Student Demographics Template (XLS)
- 2018-2019 Student School Association Template (XLS)
- 2018-2019 Student Advanced Course Completion Template (XLS)
- Exception Request Template and Instructions (XLSX)
Trainings
- Steps to upload files in Data Pipeline (PDF)
- 2017-18 English Learner Changes Presentation (PDF) (Updated: 6/1/2017)
Additional Resources
Contact Genevieve Hale at hale_g@cde.state.co.us
