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 |