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 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 Staff Evaluation Snapshot.

The Staff Evaluation file will open April 2023 as well as the 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

2024-2025

• Staff Interchange Opens: September 4^th, 2024
• 2024-2025 Human Resources Timeline (PDF) (posted 8/27/2024)
• 2024-2025 Special Education December Count Timeline (PDF) (posted 8/27/2024)

2023-2024 

• 2023-2024 Staff Evaluation Snapshot Timeline (PDF) (posted 5/7/2023)

File Layout and Definitions

2024-2025

• 2024-2025 Staff Interchange - Staff Profile File Layout and Definitions (posted 5/21/2024)
• 2024-2025 Staff Interchange - Staff Assignment File Layout and Definitions (updated 8/27/2024)
• 2024-2025 Staff Interchange - Staff Evaluation File Layout and Definitions (posted 5/21/2024)

2023-2024​

• 2023-2024 Staff Evaluation File Layout and Definitions (PDF)​   (updated 3/21/2024)

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 (XLSX) (posted 10/5/2023) 
• 2023-2024 Staff Assignment Business Rules (XLSX) (posted 10/5/2023)
• 2023-2024 Staff Evaluation Interchange Business Rules (posted 6/6/2024)

Templates

2023-2024

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

Trainings

• 2023-2024 Staff Interchange/Human Resources Training (PPTX) (Recording) (posted 11/2/2023)
• 2023-2024 Staff Evaluation Snapshot Training (PPTX) (Recording) (posted 6/6/2024)

Additional Resources

• 2023-2024 Staff Interchange Summary of Updates (PDF) (posted 10/05/2023)
• Educator Evaluation System Support and Review (PDF)
• ESSA In-Field Crosswalk (XLSX) (updated 7/23/2020)
• Exporting Staff Evaluation File from COPMS in RANDA (PDF) (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)
• Teacher Qualifications Under ESSA (Link) (10/17/2017)

For Human Resources questions, contact HumanResourcesData@cde.state.co.us.

For Special Education December Count questions, contact SpedDecCount@cde.state.co.us  

For Staff Evaluation questions, contact StaffEvaluation@cde.state.co.us