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 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, Student Biographical Data for assessments, and 11th grade alternative assessment.

File Layout and Definitions:

2013-2014

• 2013-2014 Student Interchange File Layout and Definitions-Student Demographics (PDF)
• 2013-2014 Student Interchange File Layout and Definitions-Student School Association (PDF)
• 2013-2014 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF)

2014-2015

• 2014-2015 Student Interchange File Layout and Definitions-Student Demographics (PDF)
• 2014-2015 Student Interchange File Layout and Definitions-Student School Association (PDF)
• 2014-2015 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF)  Not required for Student October
  

Known Defects

• Student Profile Known Defects (PDF)

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:

2013-2014

• 2013-2014 Student Interchange Business Rules-Student Demographics (XLS)
• 2013-2014 Student Interchange Business Rules-Student School Association (XLS)
• 2013-2014 Student Interchange Business Rules-Advanced Course Completion (XLS)

2014-2015

• 2014-2015 Student Interchange Business Rules-Student Demographics (XLS)
• 2014-2015 Student Interchange Business Rules-Student School Association (XLS)
• 2014-2015 Student Interchange Business Rules-Advanced Course Completion (XLS)

Templates:

• 2013-2014 Student Demographics Template (XLS)
• 2014-2015 Student Demographics Template (XLS)

• Student School Association Template (XLS)
• Advanced Course Completion Template (XLS)
• Exception Request Template and Instructions (XLSX)

Trainings:

• Steps to upload files in Data Pipeline (PDF)
• Tagging Student Profile Interchanges

Additional Resources:

 Student Profile FAQs (XLSX)

 Contact: Kevin Smith at Smith_Kevin@cde.state.co.us or Annie Matula at matula_a@cde.state.co.us