PATH: KY State Reporting > Funding Gap Audit
The Funding Gap Audit 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. Time scheduled includes Virtual and Performance Based course minutes. This report is for auditing purposes only and is not submitted to the state.
Image 1: Funding Gap Audit Editor
Tool and Calendar Rights
PATH: System Administration > User Security > Users > Tool Rights, Calendar Rights
In order to generate the report, users must have at least R(ead) tool rights to the Funding Gap Audit and at least read-only calendar rights for the calendar(s) selected in the Campus toolbar.
| Tool Rights | Calendar Rights |
|---|---|
|
|
Report Logic and Selection Criteria
Logic identifies students without a enough time scheduled to generate a full day's attendance on a per day basis
- 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 if the student has insufficient Virtual or Performance Based course minutes scheduled (if these minutes do not make up the schedule gap).
Reported students are identified and report 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 students who are enrolled but have 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 generate in the background when the system is able to process the request. Users can access the extract by clicking the Get the report link in the Batch Queue List. Users can also access the extract 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 | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
School | The school the student is enrolled in and reporting data. | Text | School.name | System Administration > Resources > School > Name |
Last Name | The last name of the reporting student. | Text | Identity.lastName | Census > People > Last Name |
| First Name | The first name of the reporting student. | Text | Identity.firstName | Census > People > First Name |
| Grade | The grade level of the reporting student. | XX, 2 digits Leading zero is not displayed | GradeLevel.stateGrade | Census > People > Enrollments > Grade OR Student Information > General > Enrollments > Grade |
| 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%) | Numeric, 2 digits | KYAttDailySummary | Student Information > General > Attendance |
| 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. | Numeric, 2 digits | Calculated | Schedule > Course > Type = V or P Schedule > Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Periods > Period Schedule |
| 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. | Date field, DD/MMM/YYYY | Calculated | 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. | Date field, DD/MMM/YYYY | Calculated | 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. | Text | N/A | Student Information > General > Attendance Group > PAR: Partial Day |
| Active SpEd | Indicates if the student had an active and locked IEP during the reporting range. | Text | Calculated Logic checks to see if the student has a locked, active IEP record but not a particular field. | Student Information > Special Ed > Documents Student Information > Special Ed > Documents > IEP > Education Plan > Start Date & End Date |
| 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. | Text | Calculated | 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. | Text | Calculated | N/A |
