Overview
The student interchange is a set of three files which contain student information for a school year. The student interchange contains student demographics, student enrollment records, post-secondary information and advanced course completion 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 2017-2018 Student Interchange files are open for uploads.
File Layout and Definitions
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)
- The graduation guidelines file is not required for Student October. The file is also not required for 2018-19 school year, though CDE encourages districts to use the file for students in the 2020-2021 graduation cohort during the Student End of Year collection.
2017-2018
Note: Changes for the 2017-2018 school year are highlighted in yellow within the documents.
- 2017-2018 Student Interchange File Layout and Definitions-Student Demographics (PDF) (Updated: 9/25/2017)
- 2017-2018 Student Interchange File Layout and Definitions-Student School Association (PDF) (Updated: 3/20/2017)
- 2017-2018 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF) Not required for Student October (Updated: 3/20/2017)
- Summary of 2017-2018 Student Interchange File Changes (Updated: 3/20/2017)
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
2017-2018
- 2017-2018 Student Demographics Business Rules (XLSX) (Updated 10/02/2017)
- 2017-2018 Student School Association Business Rules (XLSX) (Updated 02/01/2018)
- 2017-2018 Student Advanced Course Completion Business Rules (XLSX) (Updated 05/18/2018)
Templates
2017-2018
- 2017-2018 Student Demographics Template (XLS)
- 2017-2018 Student School Association Template (XLS)
- 2017-2018 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 Morgan Holmgren at Holmgren_M@cde.state.co.us and Duncan Anderson at Anderson_D@cde.state.co.us
