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 following snapshots: Human Resources, Special Education December Count and the Teacher Student Data Link.
File Layout and Definitions
2017-2018
- 2017-2018 File Layout and Definitions for Staff Profile (PDF) (posted 03/23/2017)
- 2017-2018 File Layout and Definitions for Staff Assignment (PDF) (updated 06/19/2017)
2016-2017
- 2016-2017 File Layout and Definitions for Staff Profile (PDF) (created 3/17/2016)
- 2016-2017 File Layout and Definitions for Staff Assignment (PDF) (updated 09/23/2016)
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
2016-2017
- 2016-2017 Staff Profile Business Rules Not Finalized (updated 08/23/2016)
- 2016-2017 Staff Assignment Business Rules Not Finalized (updated 08/23/2016)
- Staff Assignment Business Rules Guide (added 09/23/2016)
- Staff Profile Business Rules Guide (added 09/23/2016)
Templates
2016-2017
- Staff Profile Template (XLS) (added 08/11/2016)
- Staff Assignment Template (XLS) (added 08/11/2016)
Trainings
- 2016-17 Staff Interchange Updates Training (Recorded Webinar)(added 09/13/2016)
- 2016-17 Staff Interchange Pipeline Steps (Recorded Webinar)(added 09/13/2016)
- Authoritative Source for Staff: 2015-16 Training (pptx/pdf)
- Uploading Staff Interchange Files and Updates: 2015-16 Training (Recorded Webinar)
Additional Resources
- 2017-2018 Staff Interchange Summary of Updates (PDF) (updated 05/08/2017)
- Staff Interchange Process and Steps (added 09/23/2016)
- 2016-17 Staff FAQ Document (added 09/23/2016)
- 2016-17 Summary of Updates (created 4/7/2017)
- 2016-2017 Human Resources Timeline (updated 08/23/2016)
- 2016-2017 Special Education December Count Timeline (PDF) (added 08/22/2016)
- Personnel Form 2016-2017 (DOC) (added 08/23/2016)
- Special Education December Count Staff Code Tables (XLS)
- Educator Evaluation System Support and Review (link)
- Memo Regarding 191 Reporting For Charters (DOCX)
- Staff Exception Instructions and Template (XLS)
- District of Residence Codes (XLSX) (added 10/24/2016)
Contact: Annette Severson at severson_a@cde.state.co.us
