Tool Search: HB410 Student Truancy
The HB410 Student Truancy extract reports students who meet thresholds of truancy or excessive absence as defined by HB 410.
HB410 Student Truancy Extract
Report Logic
Students must be enrolled in the selected calendar to report. Enrollments marked as No Show or State Exclude, and those in Calendars or Grade Levels marked as State Exclude are not reported. Courses marked as State Exclude are also not reported. Additionally, attendance events with a code of OS: Out-of-School Suspension or those in non-instructional periods are not included in calculations.
If a Date Range is entered in the extract editor, only students whose Absence Truancy Date (see below) is on or within the Date Range are reported.
Absence Thresholds
A record is reported each time a students meets the following criteria (depending on the Compare Truancy Records option selected in the editor). Absences for all of a student's enrollments are combined into a single district-wide count. Absence status with a State Code of OS are not included in threshold counts. Periods must be marked as instructional to be included in threshold calculations.
- Habitual Truant (Absences with a State Code of OH are not included in the Habitual Truant count.)
- HT30: Student has 30 of more hours of unexcused or unknown consecutive absences.
- HT42: Student has 42 or more hours of unexcused or unknown absences within a single month.
- HT72: Student has 72 or more hours of unexcused or unknown absences total.
- Excessive Absences (Absences with a State Code of M: Medical are not included in this count unless Include Medical Absences is marked.)
- EA38: Student has 38 or more hours of excused, unexcused, or unknown absences within a single month.
- EA65: Student has 65 or more hours of excused, unexcused, or unknown absences total.
One record a month may report for the EA38 and HT42 thresholds and one record a year may report for the EA65 and HT70 thresholds. A record reports for the HT30 threshold for each instance of 30 consecutive hours. Count for consecutive absences resets each time the student attends school.
Generating the Extract
- If desired, enter a Date Range in mmddyy format or by clicking the calendar icon and selecting dates. If a Date Range is entered, only students whose Absence Truancy Date (see below) is on or within the Date Range are reported.
- Select an Absence Threshold to generate the report for one of the thresholds described in the Report Logic above.
- Select an Enrollment Service Type to limit the enrollments that contribute to calculations to only those with the type(s) selected.
- Select an option for Compare Truancy Records if desired:
- No option: runs the report with the selected thresholds only.
- All Records: runs the report with the selected thresholds and reports all thresholds met and all truancy records for the student.
- Differences only: reports instances where a threshold was met but no record exists or a record exists without a matching threshold.
- Select the Format. For submission to the State, select the State Format (CSV). To review data prior to submission, use HTML format.
- Indicate if the extract should Include Protected ID Info. If this checkbox is marked, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.
- Mark the Include Medical Absences to include absences flagged as medical in calculations.
- Select an Ad hoc Filter to limit records reported to only those included in the filter.
- Select Calendar(s) to report.
- Click the Generate Extract button to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting an extract to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Extract Layout
If the Include Protected ID Info checkbox is marked in the extract editor, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.
Element Name | Description & Format | Campus Location |
|---|---|---|
| Sort Type | Currently reports as blank. | N/A |
| Fiscal Year | Reports the End Year of the calendar. Numeric | System Administration > Calendar > Calendar > End Year Calendar.endYear |
| Building IRN | Reports the state-assigned Information Retrieval Number of the building. Numeric | System Administration > Resources > District Info > Number District.number |
| EMIS Student ID | The district-assigned, local identification number of the student. Alphanumeric | Census > People > Demographics > Local Student Number Person.studentNumber |
| Date Type | Reports the type of record being reported. Options are HT30, HT42, HT72, EA38, or EA65 - see logic for options in the Report Logic section above. Alphanumeric | Calculated, not dynamically stored |
| Absence Truancy Date | The date of the absence that met the threshold for truant or excessive absence criteria. Date field | Calculated, not dynamically stored |
| Last Name | The last name of the student. Alphabetic | Census > People > Demographics > Last Name Identity.lastName |
| First Name | The first name of the student. Alphabetic | Census > People > Demographics > First Name Identity.firstName |
| Middle Name | The middle name of the student. Alphabetic | Census > People > Demographics > Middle Name Identity.middleName |
| Grade Level | The Grade in which the student is enrolled. Alphanumeric | Student Information > General > Enrollments > Grade Enrollment.grade |
| Service Type | The type of the student's enrollment Alphanumeric | Student Information > General > Enrollments > Service Type Enrollment.serviceType |
| Calculated Truancy Type | The type of truancy calculated using student attendance data. Reports HT30, HT42, HT72, EA38, or EA65. Alphanumeric | Calculated, not dynamically stored |
| Calculated Truancy Date | The date the truancy threshold was met, calculated based on student attendance data. Date field | Calculated, not dynamically stored |
| Truancy Record Type | Displays the record type stored in the database. Alphanumeric | N/A |
| Truancy Record Date | Displays the record date stored in the database. Date field | N/A |
