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

2021-2022

• Staff Interchange Opens: Wednesday, September 1, 2021
• 2021-2022 Human Resources Timeline (PDF) (updated 09/03/21)
• 2021-2022 Special Education December Count Timeline (PDF) (posted 07/15/21)

File Layout and Definitions

2021-2022

• 2021-2022 Staff Profile File Layout and Definitions (PDF) (updated 07/13/2021)
• 2021-2022 Staff Assignment File Layout and Definitions (PDF) (posted 03/31/2021)

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) (posted 09/03/2021)
• 2021-2022 Staff Assignment Business Rules and Guidance (XLS) (posted 09/03/2021)

Templates

2021-2022

• Staff Profile Template (XLS) (posted 09/03/2021)
• Staff Assignment Template (XLS) (posted 09/03/2021)

Trainings

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

Additional Resources

• Staff Reporting During COVID Guidance (PDF) (posted 12/16/2020)
• ESSA In-Field Crosswalk (XLS) (updated 07/23/20)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)
• 2021-2022 Staff Interchange Summary of Updates (PDF)  (posted 03/31/2021)
• Staff Interchange Process and Steps (updated 07/23/2019)
• Personnel Form 2021-2022 (DOC) (updated 10/07/2021)
• 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