MI Teacher Student Data Link (TSDL) Validation - New
Introduction
This will create the MI Teacher Student Data Link (TSDL) validation report for the MI Teacher Student Data Link (TSDL) - New report. The report will list error messages for those records that may need correction or verification.
Selection Criteria
Student Selection
Student records are selected based on the following criteria:
- The student is in Grade 0-12 or Grade 14. ([Students]Grade_Level)
- If the student is Grade 14 the Education Setting should be 14. ([S_MI_STU_GC_X]educSetting)
- The student's Education Setting cannot be 20, or 30. ([S_MI_STU_GC_X]educSetting)
- The student is enrolled in one or more courses in the course selection.
The student age limit of 21 is no longer applicable.
Course Selection
Course records are selected based on the following criteria:
- The student has a section enrollment (CC record) in which they were enrolled based on the to and from dates used on the report or the Historical Grade that does not have a corresponding section enrollment (CC record) has a Course ID identified in the Michigan State Reporting section of the Historical Grade.
- The Date Enrolled in the student's section enrollment (CC record) is less than the last day of the term for the section. ([CC]DateEnrolled<[Terms]LastDay) or the Historical Grade that does not have a corresponding section enrollment (CC record) has a Term ID that has been defined in the Final Grades/Reporting Terms Setup.
- The Date Left in the student's section enrollmnet (CC record) is after the first day of the term for the section. ([CC]DateLeft>[Terms]FirstDay) or the Historical Grade that does not have a corresponding section enrollment (CC record) has a Term ID that has been defined in the Final Grades/Reporting Terms Setup.
- The Exclude from TSDL report is not selected for the Teacher([S_MI_SSF_TSDL_X]excludeTSDL, or the section enrollment (CC record) [S_MI_CC_TSDL_X]excludeTSDL (Student > All Enrollments page), or School [S_MI_SCH_TSDL_X]excludeTSDL, or Course[S_MI_CRS_TSDL_X]excludeTSDL, Setion[S_MI_SEC_TSDL_X]excludeTSDL).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Current Selection Students | Select whether to run the export file for the selected number of students or for all students. |
| Report output file | Select 'Submission file' to create the TSDL XML file to upload to MSDS or select 'Error report' to generate a CSV file with the state error codes. |
Collection | Select whether to run the export file for migrant students or general students. |
| Limit to Virtual, DE, EMC, AP, IB students | Select to limit the general collections to students in virtual, DE, EMC, AP, and IB courses (Applies only to General Collection) The TSDL file must now include all students who have been identified in a General Collection, this option is left in place to help districts troubleshoot this group of students and to keep the code in place in case the state decides to revert back to the old rule of reporting only this group of students. |
| Include Grade 30 | Select whether to run the export file with the Grade 30 students (Yes) or to exclude the Grade 30 students (No). |
Elementary Ungraded Withdrawal | Select the value for the export file to use for elementary students that were withdrawn from a section and were also ungraded. |
Entity Type Code | Select the entity type code. |
Entity Code | Enter the entity code. |
Reporting District's State Assigned 5-digit District Number | Enter the reporting district's state-assigned, 5-digit district number. |
First Day of School | Enter the date of the first day of school. |
Date From | Enter the date from (start date) for the date range. |
Date To | Enter the date to (end date) for the date range. |
Select schools to export. | Select which schools to export if applicable. Schools that have been Exclude from Teacher Student Data Link reporting in School Info will not appear in list of schools to select. |
Exclude Classes Days | Exclude student section enrollments where their enrollment in the section was less than the value entered. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName |
1 | School | This contains the school name for the associated record. | [Schools]Name |
2 | Teacher | This contains the teacher name. | [Users]LastFirst |
3 | Course | This contains the course name. | [Courses]Course_Name |
4 | Section ID | This contains the section ID number. | [Sections]SectionID or [StoredGrades]SectionID or 'SG' + [StoredGrades]DCID |
5 | Student | This contains the student name. | [Students]LastFirst |
6 | LocalCourseID | This contains a combination of the course number, store code, whether the record was pulled from the CC table (CC) or the student's historical grades (HG), sectionID, expression (will be blank if there is only a historical grade and no CC record) and [Sections]Schoolid (will be blank if there is only a historical grade and no CC record). The Schoolid is populated from the Sections table to allow remote enrollments to populate in a student's record, as a student's CC table schoolid and Students table schoolid are not the same in such cases. This combination was developed to help allow for more than one store code in a term (i.e. a year-long section that needs to report a Semester 1 and Semester 2 Grade). Additionally this combination can assist in troubleshooting issues with student records to identify exactly which section, term and grade are in error. | Courses without a Historical Grade: [Courses]Course_Number ‘-‘ ([StoredGrades]StoreCode,[Termbins]StoreCode) ‘-CC-‘ [CC]SectionID ‘-‘ [Sections]expression '-' [Sections]Schoolid OR Courses with a Historical Grade: ([S_MI_SGR_TSDL_X]CourseID_TSDL,[Courses]Course_Number) ‘-‘ ([StoredGrades]StoreCode,[Termbins]StoreCode) ‘-SG-‘ [CC]SectionID ‘-‘ ([Sections]expression,'') ‘-‘ ([Sections]schoolid,'') |
7 | Section# | This contains the section number. | [Sections]Section_Number |
8 | Student# | This contains the student number. | [Students]Student_Number |
9 | Grade Level | This contains the grade level. | [Students]Grade_Level |
10 | Migrant | This identifies if the student is migrant. | [S_MI_STU_GC_X]flagMigrant |
11 | Out Level | This identifies if the student is out of grade level. | [S_MI_STU_GC_X]flagOutOfLevel |
12 | Date In | This contains the date the student entered the section. | [CC]DateEnrolled |
13 | Date Out | This contains the date the student exited the section. | [CC]DateLeft |
14 | SCED Subject | This contains the two-digit Subject Area Code. Refer to the following link for additional information: | [S_MI_CRS_TSDL_X]SCEDsubjectCode |
15 | SCED Course | This contains the three-digit Course Identifier Code. Refer to the following link for additional information: | [S_MI_CRS_TSDL_X]SCEDcourseCode |
16 | Course Type | This contains the code that best represents the level and rigor of the course. | [S_MI_CRS_TSDL_X]courseType |
17 | Credits | This contains the number of credits earned. | [StoredGrades]EarnedCrHrs |
18 | Grade | This contains the course grade earned. | [StoredGrades]Grade |
19 | Status | This contains the completion status. If the student is in Grade 14 and the course is identified with a Subject Area Code 23 and Course Identifier Code 012 without a historical grade (stored grades), the course will receive a CS status. | Completion Status [S_MI_SGR_TSDL_X]completionStatus of the Michigan State Reporting section if the Course ID in the student's Historical Grades in the Michigan State Reporting section has been populated. Or [S_MI_CC_TSDL_X]completionStatus if a Completion Status has been selected in the student's ALL Enrollment > Edit Course. Or Calculated based on the associated grade scale of the section. This will pull from the Completion Status if the students [CC]DateLeft was > the [Terms]LastDay of that section or from the Withdraw Status if the student's [CC]DateLeft is <= the [Terms]LastDay of that section. |
19 | PIC 1 | This contains the PIC number associated with the record. | [S_MI_SGR_TSDL_X]repPIC1 or [S_MI_SSF_TSDL_X]repPIC |
20 | PIC 2 | This contains the PIC number associated with the record. | [S_MI_SGR_TSDL_X]repPIC2 or [S_MI_CC_TSDL_X]repPIC2 or [S_MI_SEC_TSDL_X]coTeacher1 |
21 | PIC 3 | This contains the PIC number associated with the record. | [S_MI_SGR_TSDL_X]repPIC3 or [S_MI_CC_TSDL_X]repPIC3 or [S_MI_SEC_TSDL_X]coTeacher2 |
22 | Method | This contains the code that represents the Virtual Delivery method of the course. | [S_MI_SGR_TSDL_X]virtualDelivery [S_MI_CC_TSDL_X]virtualDelivery [S_MI_SEC_TSDL_X]virtualDelivery [S_MI_CRS_TSDL_X]virtualDelivery |
23 | Mentor 1 | This contains the mentor teacher PIC number associated with the record. | [S_MI_SGR_TSDL_X]vmPIC1 or [S_MI_SEC_TSDL_X]mentorTeacher1 |
24 | Mentor 2 | This contains the mentor teacher PIC number associated with the record. | [S_MI_SGR_TSDL_X]vmPIC2 or [S_MI_SEC_TSDL_X]or mentorTeacher2 |
25 | Mentor 3 | This contains the mentor teacher PIC number associated with the record. | [S_MI_SGR_TSDL_X]vmPIC3 or [S_MI_SEC_TSDL_X]mentorTeacher3 |
26 | College Credit | This contains the number of college credits earned. | [S_MI_SGR_TSDL_X]collegeCredits [S_MI_CC_TSDL_X]collegeCredits [S_MI_SEC_TSDL_X]collegeCredits [S_MI_CRS_TSDL_X]collegeCredits |
27 | Message | This contains the error or verification message for the record, this matches the CEPI error description. | N/A |
28 | Rule# | This contains the CEPI business rule number. | N/A |