Monthly Days Taught (MDT)

Introduction

This file is used to submit the number of days taught per grade level for the current reporting period to MSIS. This report must be submitted to the state and approved before submitting the Monthly Student Data extract. Submit one MDT per school per reporting period. This file should be submitted first for monthly reports. Once you have a Success, you do not have to submit this file again until the next reporting period.

Report Input

For help with navigation and running the report, seeHow to Find and Generate a Report.

Field	Description
Reporting Segment or Begin and Ending Date	Do one of the following: Choose the reporting segment with the appropriate date range from the pop-up menu. Enter a begin and ending date for the report date range.
Reporting Period	Choose the appropriate reporting period from the pop-up menu.
Starts at 1.0 Increment by 10 for each modified Transaction	Enter 1, 2, or 3 to indicate by what value the transactions should be incremented.
File ID (3 digit number)	Enter the three-digit File ID number.
Report using	Choose one of the following from the pop-up menu: Current School – Include only the current school in the report. Alternate School Number – Include all schools with the alternate school number that may be entered below.
Enter School Number	Enter the school number for either the current school or for the alternate schools to be included in the report.
MS Grade Codes to Include	Enter a comma-delimited list of Special/Secondary Grade Codes to include in the report. For example: 52,54

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

The records in this report are sorted by the student’s last name.

Item #	Data Element	Description	[Table]FieldName
1	Version	The value to increment by entered at report runtime.	N/A
2	DTG	The date and time that the report completed, in the format MM-DD-YYYY and hh;mm;ss.	N/A
3	DISTRICT	The district number.	[Prefs]Value [Prefs]Name=districtnumber
4	SCHOOL	The school number, based on the selection at report runtime.	[Schools]School_Number
5	PERIOD	The reporting period selected at report runtime.	N/A
6	T_VERSION	The value to increment by entered at report runtime.	N/A
7	TRACK_ID	This value is a combination of the district number, school number, current date, and the File ID entered at report runtime.	[Prefs]Value [Prefs]Name=districtnumber [Schools]School_Number
GRADEDAYS
8	GRADE	The grade level being analyzed for days taught. Each grade level taught at the current school during the report date range is included on a separate line. Additional records are included for each Special/Secondary Grade Code assigned to a student. The report determines the grade levels to report based on student records, not the grade level range assigned to the school. If the student’s grade level is -1 (preschool), then the student’s grade level is reported as 62. If the student’s grade level is 0 (kindergarten), then the student’s grade level is reported as 64. If the student’s grade level is neither -1 nor 0, then the student’s grade level is reported.	[Students]Grade_Level
9	DAYSTAUGHT	The number of days taught for the grade level during the report date range. The report runs a membership calculation (ADM) for the students enrolled in the school during the report date range. Note: The value must be less than or equal to the number of days within the reporting period. For reporting month 01, the maximum number of days is 66 and for month 09, the maximum number of days is 45. For months 2 through 8, the maximum number of days is 27. For month 10 the maximum number of days is 60.	[Students]EntryDate [Students]ExitDate

Back to Top