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.

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 10/31/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

2024-2025

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

2023-2024

• 2023-2024 Staff Evaluation Interchange Business Rules (posted 6/6/2024)

Templates

2024-2025

• 2024-2025 Staff Profile Template (XLS) (posted 10/09/2024)
• 2024-2025 Staff Assignment Template (XLS) (posted 10/09/2024)

2023-2024

• 2023-2024 Staff Evaluation Template (XLS) (updated 3/18/2024)

Trainings

• 2024-2025 Staff Interchange/Human Resources Training (Recording) (posted 10/30/2024) 
  • 2024-2025 Staff Interchange/Human Resources Training (PPT)
• 2023-2024 Staff Evaluation Snapshot Training (PPT) (posted 6/6/2024)
  • 2023-2024 Staff Evaluation Snapshot Training (Recording)

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 (XLS) (updated 7/23/2020)
• Exporting Staff Evaluation File from COPMS in RANDA (PDF) (posted 5/24/2023)
• Memo Regarding 191 Reporting For Charters (DOC) (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