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 2023-2024 Teacher Student Data Link Interchange opens November 30, 2023.  The TSDL Snapshot deadline is August 30^th 2024. 
• 2023-2024 Teacher Student Data Link Timeline (posted 10/16/2023)

File Layouts and Definitions

2023-2024

• 2023-2024 File Layout and Definitions (updated 03/31/2023)

2024-2025

• 2024-2025 File Layout and Definitions (updated 04/01/2024)

Business Rules

• 2023-2024 Teacher Student Data Link Business Rules

Template

• Teacher Student Data Link File Upload Template

Training

• Updated training coming soon.

Additional Resources

• SCED Code Finder
• SCED Codes Version 11 (XLSX) (updated 11/02/2023)
• Migrant Regional Contact Information (updated 8/30/2019) 
• Migrant Student Cognos List Guide (Word) (updated 6/26/2024)

Contact: Peter Hoffman - Teacher Student Data Link Collection Lead