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

2023-2024 

• Staff Interchange Opens: Friday, September 1, 2023
• 2023-2024 Human Resources Timeline (PDF) (posted 8/16/2023)
• 2023-2024 Special Education December Count Timeline (PDF) (posted 8/30/2023)

2022-2023

• Staff Interchange Opens: Wednesday, September 1, 2022 
• 2022-2023 Staff Evaluation Timeline (posted 5/04/2023)

File Layout and Definitions

2023-2024

• 2023-2024 Staff Profile File Layout and Definitions (PDF) (updated 12/06/2023)
• 2023-2024 Staff Assignment File Layout and Definitions (PDF) (updated 11/21/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

2023-2024

• 2023-2024 Staff Profile Business Rules (XLS) (posted 10/05/2023) 
• 2023-2024 Staff Assignment Business Rules (XLS) (posted 10/05/2023)

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)
• 2022-2023 Staff Evaluation Interchange Business Rules and Guidance (PDF) (posted 7/21/2023)

Templates

2023-2024

• 2023-2024 Staff Profile Template (XLSX) (posted 9/18/2023)
• 2023-2024 Staff Assignment Template (XLSX) (posted 9/18/2023)

2022-2023

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

Trainings

• 2023-2024 Staff Interchange/Human Resources Training (Recording) (PPT) (posted 11/02/2023)
• 2022-2023 Staff Interchange/Human Resources Training (PPTX) (posted 10/27/2022)
• Educator Effectiveness Field Updates Webinar Recording (posted 6/13/2019)

Additional Resources

• 2023-2024 Staff Interchange Summary of Updates (PDF) (posted 10/05/2023)
• 2022-2023 Staff Interchange Summary of Updates (PDF) (posted 10/13/2022)
• 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 (PDF) (updated 10/05/2023)
• Purchase Service Staff Information Sheet (PDF) (updated 12/21/2018)
• Staff Interchange Process and Steps (updated 7/23/2019)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)

Contact: HumanResourcesData@cde.state.co.us