Teacher Student Data Linking (TSDL) Submission

TSDL Prerequisites

If you want the submission to include virtual courses for transfer building students, make sure the MI SDS Download Options district-level page has the Incl Trans Bldg Virt Crs box checked.
Make sure courses have NCES Codes defined, either in the Master Schedule or in the building Course Catalog.
Make sure that you have updated the MI Course page for all courses.
Make sure that the Mark/Completion Crosswalk validation table is accurate.
If you want to override the calculated Course Completion Status for a student's course, update the Completion Status field on the MI Student Course page for the course.
Make sure that the staff required to have a PIC have the Staff State ID field populated. For more information, see the Staff and Course Data Entry section.
Make sure that your elementary students are scheduled. See the Master Schedule Course Information section for more information.
If you need to exclude any student from the submission, use the MI Exclude from Submission Page.
Update marks as appropriate throughout the school year.

Creating the TSDL Files

Select Regulatory > MI SDS Reporting > MI SDS Reporting > SDS Downloads and run the SDS Download using the following recommended prompts to find out if there are any data errors that you need to correct.

Prompt	Value for TSDL File
School Year	Ending year of current school year
Submitting Entity	District
Building List	Select All by clicking Asterisk to select all codes
Submission Type	Teacher Student Data Link
Date of Count	Use the end date for the latest Marking Period with grades you want to report.
Start Date	First Day of School
End Date	Use the end date for the latest Marking Period with grades you want to report.
View Type	Not required for this submission
Absence Codes	Not required for this submission
Run with Student UIC	Select With UIC's
Scan for Data Errors	Checked
Scan for Setup Errors	Checked
Run Download	Checked to populate the download table. When you check this, the Clear Existing box is checked automatically for you and you cannot uncheck it.
Clear Existing	Checked if you want to clear the download table.
Clear Overrides	Checked if you want to overwrite manual changes made to the download table data entered on the download summary page. Unchecked to retain overrides set within the download records.
Log File Type	Select CSV to get an Excel file of errors or PDF to get the errors in a pdf file.

Review the error log (MI SDS Download Log) and fix data as necessary.
Re-run the download using the same prompts as in Step 1 as many times as you need to make sure that all errors are resolved.
Use the SDS Student Summary or SDS Student Download Search pages to view the data that will be sent to the State to spot-check some students and review students that may have exceptions in their data.
Run the download using the prompts above, making sure that you have the Run Download checkbox selected.
Select Regulatory > MI SDS Reporting > MI SDS Reporting > SDS Submission Files to create submission files using the following prompts below.
You will get a file called "MI SDS Teacher Student Data Link….xml". Click on the file and save it to your PC. The file name will include the School Year and the Date/Time you ran the file before the xml extension.
Upload the file to the MSDS website and follow their instructions.

Prompt	Value for TSDL Files
School Year	Ending year of current school year
Submitting Entity	District
Building List	Select All by clicking Asterisk to select all codes
Submission Type	Teacher Student Data Linking
Date of Count	Enter the Count Date that you entered in step 5.
Run with Student UIC	Select With UIC's
Log File Type	Select CSV to get an Excel file of errors or PDF to get the errors in a pdf file.

XML Components Included in the TSDL Submission

Refer to the Michigan Component File Layout document for information about the fields included in a component. For help accessing this file, refer to eSchoolPlus Michigan State Reporting Documentation.

XML Components Included	Required
Personal Core Component	Required
Submitting Entity Component	Required
School Demographics Component	Required
Student Course Component	Required