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 the following snapshots: Human Resources, Special Education December Count and the Teacher Student Data Link.

Deadlines

2022-2023

• Staff Interchange Opens: Wednesday, September 1, 2022
• 2022-2023 Human Resources Timeline (PDF) (posted 6/6/2022)

2021-2022

• 2021-2022 Special Education December Count Timeline (PDF) (posted 7/15/2021)

File Layout and Definitions

2022-2023

• 2022-2023 Staff Profile File Layout and Definitions (PDF) (updated 7/27/2022)
• 2022-2023 Staff Assignment File Layout and Definitions (PDF) (updated 8/10/2022) 

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

2021-2022

• 2021-2022 Staff Profile Business Rules and Guidance (XLS) (updated 11/4/2021)
• 2021-2022 Staff Assignment Business Rules and Guidance (XLS) (updated 11/4/2021)

Templates

2021-2022

• Staff Profile Template (XLS) (posted 9/3/2021)
• Staff Assignment Template (XLS) (posted 9/3/2021)

Trainings

• 2020-2021 Staff Interchange Training (PPTX) (posted 8/25/2020)
• Educator Effectiveness Field Updates Webinar Recording (posted 6/13/2019)
• 2019-2020 Staff Interchange Training (PPTX) Webinar Recording (posted 9/11/2019)

Additional Resources

• Staff Reporting During COVID Guidance (PDF) (posted 12/16/2020)
• ESSA In-Field Crosswalk (XLS) (updated 7/23/2020)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)
• 2021-2022 Staff Interchange Summary of Updates (PDF)  (posted 3/31/2021)
• Staff Interchange Process and Steps (updated 7/23/2019)
• Personnel Form 2022-2023 (PDF) (updated 7/27/2022)
• 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: Dawna Gudka at gudka_d@cde.state.co.us