Data Pipeline Interchanges - Teacher/Student Data Link

Overview

The Teacher Student Data Link Interchange (TSDL) file is minimized from 3 previous files (Statewide Standard Course Codes, Course Instructor and Course Enrollment files) into one file.   The TSDL file captures data that link students in grades 6 through 12 to courses and instructors (if available) for the reported school year. CDE relies on the TSDL data for the following reporting requirements: student course participation and achievement report, migrant student tracking/reporting, educator preparation program outcomes, and prepopulating the Office of Civil Rights (OCR) report.

Deadlines

• The 2020-2021 Teacher Student Data Link Snapshot Deadline Date: August 13, 2021
• 2020-2021 Teacher Student Data Link Timeline (PDF) (posted 10/01/2020)

File Layouts and Definitions

2020-2021

• 2020-2021 File Layout and Definitions (PDF) (posted 04/06/2020)

2019-2020

• 2019-2020 Course Enrollment File Layout and Definitions (PDF) (updated 08/14/2019)
• 2019-2020 Course Instructor File Layout and Definitions (PDF) (updated 08/14/2019)

Business Rules

• 2019-2020 Business Rules Course Enrollment (XLS) (updated 08/14/2019)
• 2019-2020 Business Rules Course Instructor (XLS) (updated 08/14/2019)

Template

• 2020-2021 TSDL Upload File (XLS) (updated September 2020)

Training

Coming Soon

Additional Resources 

• TSDL FAQs 2020-2021 (DOC) (posted 10/01/2020)
• Teacher Student Data Link Authority (PDF) (posted 08/14/2019)
• TSDL Process Guide (updated 9/29/2020)
• Migrant Regional Contact Information (updated 8/30/2019) 
• Civil Rights Data collection (CRDC) data requirements for TSDL

Contact: Annette Severson at severson_a@cde.state.co.us