MI Teacher Student Data Link (TSDL) Validation
Introduction
This will create the MI Teacher Student Data Link (TSDL) Validation report. Use this to display the same TSDL submission data that is submitted to the state in the MI Teacher Student Data Link (TSDL) export file. 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 CC record in which they were enrolled based on the to and from dates used on the report.
- The Date Enrolled in the student's CC record is less than the last day of the term for the section. ([CC]DateEnrolled<[Terms]LastDay).
- The Date Left in the student's CC record is after the first day of the term for the section. ([CC]DateLeft>[Terms]FirstDay).
- The Exclude from TSDL report is not selected ([S_MI_SSF_TSDL_X]excludeTSDL, [S_MI_CC_TSDL_X]excludeTSDL, [S_MI_SCH_TSDL_X]excludeTSDL, [S_MI_CRS_TSDL_X]excludeTSDL, [S_MI_SEC_TSDL_X]excludeTSDL).
- The course teacher has a PIC number ([S_MI_SSF_TSDL_X]repPIC), unless the course SCED 6 Subject Area Code is 00 ([S_MI_CRS_TSDL_X]SCEDsubjectCode), or the Course Type is 07 ([S_MI_CRS_TSDL_X]courseType).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Current Selection Students | Select whether to run the export file for the selected number of students or for all students. |
Report Errors for Correction | Select whether to display errors needing correction in the report. |
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 (general collection only) |
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. |
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. | [CC]SectionID |
5 | Student | This contains the student name. | [Students]LastFirst |
6 | Course# | This contains the course number. | [Courses]Course_Number |
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. The courses identified as 23012 receive a CS status. If a student completes a course with a Subject Area Code 23 and Course Identifier Code 012, then the course receives a Completion Status CS. | Calculated |
19 | PIC 1 | This contains the PIC number associated with the record. | [S_MI_SSF_TSDL_X]repPIC |
20 | PIC 2 | This contains the PIC number associated with the record. | [S_MI_SSF_TSDL_X]coTeacher1 |
21 | PIC 3 | This contains the PIC number associated with the record. | [S_MI_SSF_TSDL_X]coTeacher2 |
22 | Method | This contains the code that represents the Virtual Delivery method of the course. | [S_MI_CC_TSDL_X]virtualDelivery [S_MI_CC_TSDL_X]virtualDelivery [S_MI_SEC_TSDL_X]virtualDelivery |
23 | Mentor 1 | This contains the mentor teacher PIC number associated with the record. | [S_MI_SEC_TSDL_X]mentorTeacher1 |
24 | Mentor 2 | This contains the mentor teacher PIC number associated with the record. | [S_MI_SEC_TSDL_X]mentorTeacher2 |
25 | Mentor 3 | This contains the mentor teacher PIC number associated with the record. | [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. | N/A |
28 | Rule# | This contains the CEPI business rule number. | N/A |