Tool Search: Funding Gap Audit
The Funding Gap Audit tool identifies students with gaps in their schedules, which result in the student not being scheduled enough time to generate a full day's attendance funding on a per-day basis. The time scheduled includes Virtual and Performance-Based course minutes. This report is for auditing purposes only and is not submitted to the state.
Funding Gap Audit EditorTo generate the report, users must have at least Read tool rights to the Funding Gap Audit and read-only calendar rights for the calendar(s) selected in the Campus toolbar.
Report Logic and Selection Criteria
Logic identifies students without enough time scheduled to generate a full day's attendance per day.
- Logic identifies students with a Possible ADA less than 1.0 for one or more days while actively enrolled in the district.
- Logic then identifies whether the student has insufficient Virtual or Performance-Based course minutes scheduled (if these minutes do not make up the schedule gap).
Students are identified and reported using the following calculations:
- Determine the Cap Maximum
- 1.0 - Possible ADA = Cap Maximum
- For example: 1.0 - .60 = .40
- Determine V/PB Possible ADA
- V/PB / Standard Day = V/PB Possible ADA
- For example: 60 / 400 = .15
- Determine if the student has insufficient V/PB
- V/PM Possible ADA < Cap Maximum
- For example: .15 < .40
Report logic also identifies enrolled students with no instructional time scheduled.
Generate the Funding Gap Audit Report
- Select the Date Range.
OR - Select which School Month(s) will report data.
- Select which Grade(s) will report data
OR - Filter reported student by selecting an Ad Hoc Filter
- Select the report Format.
Select how the report will be generated:
Generate Report The report will generate immediately and display in a new window in the designated format. Submit to Batch Selecting this will send the extract to the Batch Queue, where it will be generated in the background when the system can process the request. Users can access the extract by clicking the Get the report link in the Batch Queue List, via the Batch Queue tool, or by selecting the link within the Process Inbox message that appears once the extract is generated.
Report Layout
Element Name | Description | Location |
|---|---|---|
School | The school the student is enrolled in and reporting data. | School & District Settings > Schools > School Information > Name School.name |
Last Name | The last name of the reporting student. | Census > People > Last Name Identity.lastName |
| First Name | The first name of the reporting student. | Census > People > First Name Identity.firstName |
| Grade | The grade level of the reporting student. | Census > People > Enrollments > Grade OR Student Information > General > Enrollments > Grade GradeLevel.stateGrade |
| Seat Time % | The percentage of time the student is scheduled in traditional attendance courses. Logic reports this as the student's Possible ADA as a percentage (.60 = 60%) | Student Information > General > Attendance KYAttDailySummary |
| V/PB % | The percentage of time a student is scheduled in Virtual and Performance Based Courses. Logic reports this as the student's V/PB Possible ADA. This is calculated as follows: V/PB Minutes / Standard Day = V/PB Possible ADA For example: 60 / 400 = .15 so the V/PB % reported is 15%. If a students have varying V/PB percentages, the lowest is reported. | Schedule > Course > Type = V or P Schedule > Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Periods > Period Schedule Calculated |
| Funding Gap Start Date | The earliest date in the calendar where the student is underfunded. Logic reports the earliest date in the calendar where Possible ADA + V/PB Possible ADA is less than 1. | Calculated |
| Funding Gap End Date | The latest date in the calendar where the student is underfunded. Logic reports the latest date in the calendar where Possible ADA + V/PB Possible ADA is less than 1. | Calculated |
| Partial Day | Indicates the student was in a Partial Day Attendance Group. A student will report a value of 'Yes' if they were in a Partial Day Attendance Group during the reporting date range. | Student Information > General > Attendance Group > PAR: Partial Day |
| Active SpEd | Indicates if the student had an active and locked IEP during the reporting range. | Student Information > Special Ed > Documents Student Information > Special Ed > Documents > IEP > Education Plan > Start Date & End Date Calculated Logic checks to see if the student has a locked, active IEP record but not a particular field. |
| V/PM Period Length | Indicates if the student has virtual or performance-based courses. A value of 'Yes' is reported if the student has an insufficient V/PB %. If the student is fully scheduled, the V/PB Period may need to be lengthened to resolve the funding gap. | N/A |
| Check Funding Eligibility | Indicates if the student may be eligible for full attendance funding. A value of 'Yes' is reported if the student is in a Partial Attendance Group and has an active and locked Special Ed record. | N/A |
