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, and Student Biographical Data.

Deadlines

The 2017-2018 and 2016-2017 Student Interchanges are open for uploads. Please make sure you select the correct school year when uploading student interchange files.

File Layout and Definitions

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: 3/20/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)

2016-2017

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

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)

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