Absence Export for HB410 Truancy/Chronic-OH 1
Contents
Introduction
This extract generates a comma separated value (CSV) file that includes student absence data related specifically to Ohio House Bill 410 requirements. It is recommended that users select a group of students prior to running this export.
If "All Students" is selected, students are selected for the report as follows:
- Students who have absences between the report start and end dates
- Students who are enrolled at some point between the report start and report end dates
- Student who are not flagged to be excluded from state reporting
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Schools for which to run?* | Choose one of the following:
|
Report Start Date* | Enter the start date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY |
Report End Date* | Enter the end date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY |
Current Selection Students* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Scheduling | |
Run Now | Select this option to execute the report in the order it is received in the report queue. |
Schedule (available Version 7.1.1.) | Enter the start date and start time for the report.
|
Report Output
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 | Field Type |
1 | SSID | This column contains the student's State Student ID (SSID) | [Students]state_studentnumber
| Alpha-numeric |
2 | Date of Absence | This column contains the data of the absence as MM/DD/YYYY | [S_OH_STU_Truancy_Hours_C]date_absent or [S_OH_STU_Truancy_Meeting_C]date_absent | Date |
3 | Type of Absence | This column contains excused or unexcused expressed as "Excused" or "Unexcused" | Derived from attendance code | Alpha |
| 4 | Absence Time | This column contains the amount of time the student was absent expressed as hours:minutes | [S_OH_STU_Truancy_Hours_C]hours_absent or [S_OH_STU_Truancy_Meeting_C]hours_absent | Numeric |
5 | Excluded from Truancy | This column contains the amount of time that is excluded from the consequences for truancy expressed as hours:minutes. The column contains 0:00 if no time is excluded. The determination for reporting zero or an amount of time is based on [S_OH_ATC_Truancy_X]involuntary_absence being set to true or false. If true, hours:minutes is equal to the Absence Time column; if false the column contains 0:00. | [S_OH_ATC_Truancy_X]involuntary_absence | Numeric |
| 6 | District IRN | This column contains the six digit IRN of the district generating the report. | [S_OH_STU_TRUANCY_Meeting_C]date_absent | Date |
| 7 | Student First Name | This column contains the student’s first name. | [Students]first_name | Alpha |
| 8 | Student Last Name | This column contains the student’s last name. | [Students]last_name | Alpha |
| 10 | Student Grade Level | This column contains the student's grade level. | [Students]grade_level | Numeric |
| 11 | Student District of Residence | This column contains the student's district of residence. In situations where a student is open-enrolled to a second district and cross-enrolled at a JSVD, the IRN listed is that of the educating district, not the resident district. | [Students]district_of_residence [S_OH_STU_FS_X]how_received | Numeric, Alpha |