Data Pipeline Interchanges - Staff

Overview

The staff interchange is a set of two files which contain all staff data for a school year. The staff interchange contains the staff demographics, background and current assignment(s) data. This information is used in following snapshots: Human Resources, Special Education December Count and the Teacher Student Data Link.

Deadlines

2019-2020

• Staff Interchange Opens: Wednesday, September 4, 2019
• 2019-2020 Human Resources Timeline (PDF) (posted 08/13/19)
• 2019-2020 Special Education December Count Timeline (PDF) (posted 08/13/19)

File Layout and Definitions

2019-2020

• 2019-2020 Staff Profile File Layout and Definitions (PDF) (posted 03/21/2019)
• 2019-2020 Staff Assignment File Layout and Definitions (PDF) (posted 03/21/2019)

2020-2021

• 2020-2021 Staff Profile File Layout and Definitions (PDF) (updated 05/20/2020)
• 2020-2021 Staff Assignment File Layout and Definitions (PDF) (updated 04/27/2020)

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

2019-2020

• 2019-2020 Staff Profile Business Rules and Guidance (XLS) (updated 07/23/2019)
• 2019-2020 Staff Assignment Business Rules and Guidance (XLS) (updated 07/23/2019)

Templates

2019-2020

• Staff Profile Template (XLS) (updated 07/23/2019)
• Staff Assignment Template (XLS) (updated 07/23/2019)

Trainings

• Educator Effectiveness Field Updates Webinar Recording (posted 06/13/2019)
• 2019-2020 Staff Interchange Training (PPTX) Webinar Recording (posted 09/11/2019)

Additional Resources

2019-2020 Resources

• ESSA In-Field Crosswalk (XLS) (posted 09/11/19)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)
• 2019-2020 Staff Interchange Summary of Updates (PDF) (posted 05/20/2019)
• Staff Interchange Process and Steps (updated 07/23/2019)
• Personnel Form 2019-2020 (DOC) (updated 07/23/2019)

General Resources

• Purchase Service Staff Information Sheet (PDF) (updated 12/21/2018)
• Special Education December Count Staff Code Tables (XLS)
• Educator Evaluation System Support and Review (link)
• Memo Regarding 191 Reporting For Charters (DOCX)
• District of Residence Codes (XLSX) (added 10/24/2016)

Contact: Annette Severson at severson_a@cde.state.co.us