MI MSDS Attendance Component Data
Introduction
This will create the MI MSDS Attendance Component Data report. Use this to display the same attendance component data (days attended/days enrolled) that is submitted with state submissions. The report allows users to retrieve records where students have absent days greater than or equal to an amount specified.
This report should be run for the current school year and should not be run to retrieve historical (previous years) attendance component data.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records based on the following criteria:
- The student had an active enrollment between the date entered in the First Day of School parameter and the date entered in the Date To or Count Date parameter of the report.
- The student had absent days greater than or equal to the amount entered in the report parameters.
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. |
First Day of School | Enter the date of the first day of school. |
Date To or Count Date | Enter the date to or count date. |
Select schools to export. | Select which schools to export if applicable. |
Absent days greater than or equal to | Enter the number of absent days greater than or equal to. Use this to pull only those students that have a total number of absent days greater than or equal to the value entered. |
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.
Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
1 | School Name | This contains the name of the school where the student was enrolled as of the Count Date entered in the report parameters. | [Schools]Name [Students]SchoolID [ReEnrollments]SchoolID |
2 | Student# | This contains the PowerSchool student ID for the student. | [Students]Student_Number |
3 | Student | This contains the student's name. | [Students]LastFirst |
4 | Grade Level | This contains the student's grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
5 | Possible | This contains the number of days that the student was determined to be eligible to be in attendance. | Calculated |
6 | Attended | This contains the number of days the student was actually in attendance. | Calculated |
7 | Absent | This contains the number of days the student was considered absent. | Calculated |