ED ADM Report
Introduction
This report provides information about Average Daily Membership (ADM) for Economically Disadvantaged students from grade levels K-12 enrolled in the school during the reporting period. The reporting period selected at report runtime must be mapped to a reporting segment via Start Page, School Setup, Reporting Segments. In-session school days must have the In Sess checkbox selected via Start Page, School Setup, Calendar Setup.
This report is part of the Tennessee Investment in Student Achievement (TISA) Validation and the report is available under the TISA Validation Reports section on the State Reporting tab.
The ADM is calculated for students classified under the following categories:
J: Direct Certified Economically Disadvantaged
FOS01: Foster Care
H: Homeless
I: Migrant
U: Runaway
Selection Criteria
Selection criteria determine which data ED 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 from the [Students] and [Reenrollments] tables based on the following criteria:
The student must be enrolled in the school during the reporting period selected at report runtime.
The student must have a grade level of 0 (K), 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12.
Attendance is only calculated for sections in which the student is enrolled that are not marked Exclude from Attendance.
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
Note: The All Schools option is only available when running the report from the District Office. |
Report Period | Select the reporting period from the drop-down list that contains the following values:
|
Reporting Type | Select from the following options:
|
Report Output for School Summary
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 Year | The school year for which the report is being generated. | [Prefs]SelectedYear |
2 | Geographic District | The district number. | |
3 | Combo Code | The concatenated value of the district number and School Number. | N/A |
4 | District Number | The number of the district. | [Prefs]Value [Prefs]Name=districtnumber |
5 | District Name | The name of the district. | [Prefs]Value [Prefs]Name=districtname |
6 | School Number | The school number. If the report is run for the district, then this field is left blank. | [Schools]School_Number |
7 | School Name | The name of the school. If the report is run for the district, then this field is left blank. | [Schools]Name |
8 | Concentrated Poverty | Indicates if the Concentrated Poverty option is selected as part of district setup. Valid values:
| |
9 | Charter | Indicates whether the school is a charter school. Valid values:
| |
10 | Grade Assignment | The grade for which the ADM calculation has been performed. | [S_TN_SEC_X]GradeLevelGroup |
11 | ED-1 | The ADM of the first reporting period for all students at the selected schools. | Calculated Value |
12 | ED-2 | The ADM of the second reporting period for all students at the selected schools. | Calculated Value |
13 | ED-3 | The ADM of the third reporting period for all students at the selected schools. | Calculated Value |
14 | ED-4 | The ADM of the fourth reporting period for all students at the selected schools. | Calculated Value |
15 | ED-5 | The ADM of the fifth reporting period for all students at the selected schools. | Calculated Value |
16 | ED-6 | The ADM of the Sixth reporting period for all students at the selected schools. | Calculated Value |
17 | ED-7 | The ADM of the Seventh reporting period for all students at the selected schools. | Calculated Value |
18 | ED-8 | The ADM of the Eighth reporting period for all students at the selected schools. | Calculated Value |
19 | ED-9 | The ADM of the Ninth reporting period for all students at the selected schools. | Calculated Value |
20 | ED All Period Avg (1 - 1) | The average ADM for the reporting period. | Calculated Value |
Report Output for Student Report
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 | Geographic LEA | The district number. | [Pref] |
2 | Combo Code | The concatenated value of the district number and school Number. | N/A |
3 | School Year | The current school year. | [Prefs]SelectedYear |
4 | Student Key | The student number assigned by the district. | [Students]State_StudentNumber |
5 | District Number | The number of the district. | [Prefs]Value [Prefs]Name=districtnumber |
6 | District Name | The name of the district. | [Prefs]Value [Prefs]Name=districtname |
7 | School Number | The school number. If the report is run for the district, then this field is left blank. | [Schools]School_Number |
8 | School Name | The name of the school. If the report is run for the district, then this field is left blank. | [Schools]Name |
8 | ADM Grade | The grade for which the ADM calculation has been performed. | [S_TN_SEC_X]GradeLevelGroup |
9 | SC Begin Date | The date on which the student was classified under one of the economically disadvantaged categories. | min([S_TN_STU_STUCLASSIFICATION_C]BeginDate) |
10 | SC End Date | The date on which the student was removed from the classified economically disadvantaged category. | max([S_TN_STU_STUCLASSIFICATION_C]EndDate) |
11 | 1 | The ADM of the first reporting period. | Calculated Value |
12 | 2 | The ADM of the second reporting period. | Calculated Value |
13 | 3 | The ADM of the third reporting period. | Calculated Value |
14 | 4 | The ADM of the fourth reporting period. | Calculated Value |
15 | 5 | The ADM of the fifth reporting period. | Calculated Value |
16 | 6 | The ADM of the Sixth reporting period. | Calculated Value |
17 | 7 | The ADM of the Seventh reporting period. | Calculated Value |
18 | 8 | The ADM of the Eighth reporting period. | Calculated Value |
19 | 9 | The ADM of the Ninth reporting period. | Calculated Value |
20 | Average (1-9) | The average ADM for the reporting period. | Calculated Value |