Data Pipeline Interchanges - Staff

Overview

The staff interchange is a set of three files which contain all staff data for a school year. The staff profile contains the staff demographics and educational background, the staff assignment contains the current assignment data for all staff and the NEW staff evaluation contains the current year evaluation data for all licensed personnel. This information is used in the following snapshots: Human Resources, Special Education December Count, Teacher Student Data Link, and the NEW Staff Evaluation Snapshot.

The NEW Staff Evaluation file will open April 2023 as well as the NEW Staff Evaluation Snapshot to collect the 2022-2023 evaluation data for all staff. More information will come soon on this collection and process, including training in April 2023.

Deadlines

2022-2023

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

File Layout and Definitions

2023-2024

• 2023-2024 Staff Profile File Layout and Definitions (PDF) (updated 3/31/2023)
• 2023-2024 Staff Assignment File Layout and Definitions (PDF) (posted 3/30/2023) 

2022-2023

• 2022-2023 Staff Profile File Layout and Definitions (PDF) (updated 9/9/2022)
• 2022-2023 Staff Assignment File Layout and Definitions (PDF) (updated 11/8/2022) 
• 2022-2023 Staff Evaluation File Layout and Definitions (PDF) (updated 3/31/2023)

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

2022-2023

• 2022-2023 Staff Profile Business Rules and Guidance (XLS) (updated 1/13/2023)
• 2022-2023 Staff Assignment Business Rules and Guidance (XLS) (updated 10/4/2022)

Templates

2022-2023

• Staff Profile Template (XLS) (updated 11/11/2022)
• Staff Assignment Template (XLS) (updated 10/25/2022)
• Staff Evaluation Template (XLS) (updated 3/10/2023)

Trainings

• 2022-2023 Staff Interchange/Human Resources Training (PPTX) (posted 10/27/2022)
• 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

• District of Residence Codes (XLSX) (posted 10/24/2016)
• Educator Evaluation System Support and Review (link)
• ESSA In-Field Crosswalk (XLS) (updated 7/23/2020)
• Exporting Staff Evaluation File from COPMS in RANDA (posted 5/24/2023)
• Memo Regarding 191 Reporting For Charters (DOCX) (posted 1/28/2015)
• 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) (updated 1/23/2018)
• Staff Interchange Process and Steps (updated 7/23/2019)
• Staff Reporting During COVID Guidance (PDF) (posted 12/16/2020)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)
• 2022-2023 Staff Interchange Summary of Updates (PDF) (posted 10/13/2022)
• 2021-2022 Staff Interchange Summary of Updates (PDF)  (posted 3/31/2021)

Contact: Dawna Gudka at gudka_d@cde.state.co.us