Data Pipeline Interchanges - Student

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 graduation guidelines data. This information is used in the following collections: Student October, Special Education December Count, Special Education Discipline, Student End of Year, and Student Biographical Data.

Deadlines

The 2020-2021 and 2021-2022 Student Interchange files are open for uploads.

File Layout and Definitions

2021-2022

• 2021-2022 Student Interchange File Layout and Definitions - Student Demographic (PDF) (posted 3/22/2021)
• 2021-2022 Student Interchange File Layout and Definitions - Student School Association (PDF) (updated 4/9/2021)
• 2021-2022 Student Interchange File Layout and Definitions - Graduation Guidelines (PDF) (updated 8/17/2021)
  • Beginning in the 2020-2021 school year, the Graduation Guidelines interchange file will be a required data file. 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 Student October.
  • The Graduation Guidelines file is used for the Student End of Year collection. The file serves as a validator to check to make sure any student marked as a graduate (exit type code 90) in Student End of Year also has met Graduation Guidelines (at least one in English and at least one in math). 
  • More information on Graduation Guidelines can be found here.

2020-2021

• 2020-2021 Student Interchange File Layout and Definitions - Student Demographic (PDF) (updated 10/5/2020)
• 2020-2021 Student Interchange File Layout and Definitions - Student School Association (PDF) (updated 10/5/2020)
•  2020-2021 Student Interchange File Layout and Definitions - Advanced Course Completion (updated 10/5/2020)
  • ​The Advanced Course Completion has been removed entirely from the student interchange (2020-2021 and beyond) 
• 2020-2021 Student Interchange File Layout and Definitions - Graduation Guidelines (PDF) (updated 1/19/2021)
  • Beginning in the 2020-2021 school year, the Graduation Guidelines interchange file will be a required data file. 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 Student October.
  • The Graduation Guidelines file is used for the Student End of Year collection. The file serves as a validator to check to make sure any student marked as a graduate (exit type code 90) in Student End of Year also has met Graduation Guidelines (at least one in English and at least one in math). 
  • More information on Graduation Guidelines can be found here.

Business Rules

2021-2022

• 2021-2022 Student Demographic Business Rules (XLSX) (updated 9/24/2021)
• 2021-2022 Student School Association Business Rules (XLSX) (updated 9/24/2021)
• 2021-2022 Graduation Guidelines Business Rules (XLSX) (posted 8/3/2021)

2020-2021

• 2020-2021 Student Demographics Business Rules (XLSX)
• 2020-2021 Student School Association Business Rules (XLSX)
• 2020-2021 Graduation Guidelines Business Rules (XLSX)

Templates

2021-2022

• 2021-2022 Student Demographic Template (XLS)
• 2021-2022 Student School Association Template (XLS)
• 2021-2022 Graduation Guidelines Template (XLS)
• 2021-2022 Exception Request Template and Instructions (XLSX)

2020-2021

• 2020-2021 Student Demographic Template (XLS)
• 2020-2021 Student School Association Template (XLS)
• 2020-2021 Graduation Guidelines Template (XLS)
• 2020-2021 Exception Request Template and Instructions (XLSX)

Additional Resources

• Graduation Guidelines: Accommodation Fields Reporting Guidance (PDF) (posted 3/29/2021)
• Graduation Guidelines Full FAQ (PDF) (posted 3/9/2021)
• Graduation Guidelines Reporting (PPTX) (updated 4/1/2021)
• Graduation Guidelines Short FAQ (PDF) (posted 3/9/2021)
• Guide to Keeping Leading Zeros in Excel (posted 3/17/2021)
• Language Instruction Program Descriptions (PDF) (updated 11/11/2020)
• Special Education Transition Students: Coding Guide (updated 4/26/2021)
• Steps to upload files in Data Pipeline (PDF) (updated 11/17/2020)
• Tagging Interchange Files (PDF) (posted 11/17/2020)

For Student School Association or Student Demographic questions, contact: Brooke Wenzel, wenzel_b@cde.state.co.us
For Graduation Guidelines questions, contact: Reagan Ward, ward_r@cde.state.co.us