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

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