Data Pipeline Interchanges - Teacher/Student Data Link

Overview

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 2021-2022 Teacher Student Data Link Interchange will open October 20, 2021.  The TSDL Snapshot deadline is August 12^th 2022. 
• 2021-2022 Teacher Student Data Link Timeline (PDF) (posted 10/13/2021)

File Layouts and Definitions

2021-2022

• 2021-2022 File Layout and Definitions (PDF) (updated 8/16/2021)
• 2022-2022 File Layout and Definitions (PDF) (updated 03/30/2022)

Business Rules

• 2021-2022 Business Rules TSDL Upload (XLS) (posted 10/14/2021)
• 2022-2023 Business Rules TSDL Upload (XLSX) (posted 03/30/2022)

Template

• TSDL Upload File (XLS) (posted 03/30/2022)

Training

• TSDL Cognos Reports (PPTX) (posted 06/28/2021)
• 2021-2022 TSDL Training Slides (PPTX) (updated 02/17/2022)

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)
• SCED Code Finder
• SCED Codes Version 8 (updated 02/26/2021)
• SCED Codes Crosswalk (Prior Codes to Current Code) (updated 02/26/2021)
• Migrant Regional Contact Information (updated 8/30/2019) 
• Migrant Student Cognos List Guide (PDF) (posted 2/25/2022)
• Civil Rights Data collection (CRDC) data requirements for TSDL

Contact: Peter Hoffman at hoffman_p@cde.state.co.us