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, and 11th grade alternative assessment.

Deadlines

The 2016-2017 Student Interchange is now open in Data Pipeline for uploads.

File Layout and Definitions

2016-2017

Note: Changes for the 2016-2017 school year are highlighted in yellow within the documents. The 2016-2017 file layouts are still subject to change prior to the opening of the collections in Data Pipeline.

2016-2017 Student Interchange File Layout and Definitions-Student Demographics (PDF) (Updated:9/6/2016)
2016-2017 Student Interchange File Layout and Definitions-Student School Association (PDF) (Updated:9/6/2016)
2016-2017 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF) Not required for Student October (Updated: 9/6/2016)

2015-2016

Note: Changes for the 2015-2016 school year are highlighted in yellow within the documents

2015-2016 Student Interchange File Layout and Definitions-Student Demographics (PDF) (Updated: 4/14/2016)
2015-2016 Student Interchange File Layout and Definitions-Student School Association (PDF) (Updated: 10/8/15)
2015-2016 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF) Not required for Student October (Updated: 3/17/15)

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)
- Guide to keeping leading zeros in excel