Tool Search: ADE Audit Report
The ADE Audit Report allows State Edition users to audit ADE report data. The report provides enrollment totals and differences aligned with the ADE reports.
ADE Audit Report Editor
Report Logic
- Students will only report if they have a Start Status of E1, E8, E9, E11, or R2.
- Students withdrawn from School A and enrolled in School B on the same day are only counted on the new/active enrollment record.
- Students enrolled and withdrawn from School A on the same day are not counted (no show).
- Students with multiple applicable enrollments are counted for each active enrollment.
- Students are NOT included if
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as Exclude; or
- their Calendar of enrollment is marked as Exclude.
- To run the report, users must select a Year and District in the toolbar.
Report Editor
| Field | Description |
|---|---|
| Format | Indicates how the report generates:
|
| Filter By |
|
| Select Calendars | Allows you to select which Calendar(s) should be included in the report. Calendars can be sorted by active year, school, or year. |
Generate Extract | The report appears in a separate window in the designated format. |
| Submit to Batch | This process allows larger reports to be generated in the background without disrupting the use of Campus. See the Batch Queue article for more information about submitting a report to the batch queue. |
Report Layout
| Element | Logic | Location |
|---|---|---|
| District Number | The district number associated with the chosen calendar. Numeric | School & District Settings > District > District Information > State District Number District.number |
| District | The district name associated with the chosen calendar. Alphanumeric | School & District Settings > District > District Information > Name District.name |
| School Name | The name of the school. Alphanumeric | School & District Settings > Schools > School Information > Name School.name |
| School Number | The school number for the school included in the report. Numeric | School & District Settings > Schools > School Information > State School Number School.number |
| School Calendar | The calendar name. Alphanumeric | School & District Settings > Schools > School Information > Name School.name |
| Track | A numeric character indicating the track. Alphanumeric | Scheduling & Courses > Calendar Setup > Calendar Information > Track Calendar.track |
| QTR 4 Prior Year | The total enrollment count per quarter, school, calendar, and track for quarter 4 of the previous school year if the selected Calendar is for the 17/18 school year or later. A dash "-" reports if the selected Calendar is for the 16/17 school year or earlier. Numeric | Calculated |
| QTR 1 Jul-Sept | The total enrollment count per quarter, school, calendar, and track for quarter 1 of the current school year. Numeric | Calculated |
| % Diff | The difference from the previous quarter per quarter, school, calendar, and track. If there are no countable students in the population, 0 reports. Numeric | Calculated |
| QTR 2 Oct-Dec | The total enrollment count per quarter, school, calendar, and track for quarter 2 of the current school year. Numeric | Calculated |
| % Diff | The difference from the previous quarter per quarter, school, calendar, and track. Numeric | Calculated |
| QTR 3 Jan-Mar | The total enrollment count per quarter, school, calendar, and track for quarter 3 of the current school year. Numeric | Calculated |
| % Diff | The difference from the previous quarter per quarter, school, calendar, and track. Numeric | Calculated |
| QTR 4 Apr-Jun | The total enrollment count per quarter, school, calendar, and track for quarter 4 of the current school year. Numeric | Calculated |
| % Diff | The difference from the previous quarter per quarter, school, calendar, and track. Numeric | Calculated |
| District Enrollment Count | The total enrollment count per quarter by district. Numeric | Calculated |
| District % Difference | The difference from the previous quarter by district. Numeric | Calculated |
| School Enrollment Count | The total enrollment count per quarter by school. Numeric | Calculated |
| School % Difference | The difference from the previous quarter by the school. Numeric | Calculated |
