Absence Export for HB410 Truancy/Chronic-OH 1

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: Select Multiple Schools – Includes all student records associated with the schools selected that meet the selection criteria. Use the control key to select more than one school for the report. All Schools (default) – Includes all student records on the PowerSchool server that meet the selection criteria.
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: The Selected [number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. 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. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

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