Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'safetydrill'

Safety Drill (SD)


ID Element Name Type Size Values Cycle



Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 2,3,5,6,7

Cycle - The reporting cycle for which the data is submitted:

2 = October 15th
3 = November 15th
5 = February 15th
6 = April 15th
7 = June 15th
cycle Num 2 Table 2,3,5,6,7

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix C 2,3,5,6,7

Safety Monthly Data (August - May) -  Arkansas public schools are required to hold monthly safety evacuation drills and we strongly recommend that the teachers take the time at the beginning of school to discuss and explain the expected procedures for the Safety evacuation drills.  The following data set shall be entered for each monthly safety drill.

There will be one active shooter drill during the school year.  It may occur any time during the year; but reported in Cycle 7. (Act 484 of 2013)

There will be three fire drill reporting periods.
1st = November 15th (Cycle 3) will be to report the results of the fire drills and should include any performed August through 31st  of October.
2nd = February 15th (Cycle 5) will be to report the results of fire drills conducted in November through January 31st. 
3rd = June 15th (Cycle 7) will be to report the results of the fire drills conducted in February through May 31st.

There will be three reporting periods for tornado evacuation drills as required by Arkansas Code Annotated § 6-10-121:
1st = October 15th (cycle 2) will be to report the results of the September tornado drill
2rd = February 15th (cycle 5) will be to report the results of the January tornado drill
3rd = April 15th (cycle 6) will be to report the results of the February drill


Type of Safety Drill - There are two types of safety evacuation drills currently being performed by the School Districts. F = Fire Drill T = Tornado Drill

safety_code Alpha 1 Table 2,3,5,6,7

Date of Monthly Safety Drill - The month, day and year the school held its safety evacuation drills. (Must be valid date greater than 08012012.)

safety_date Date 8 MMDDYYYY 2,3,5,6,7

Hour of Monthly Safety Drill - Enter an hour numbered from 0 (midnight) to 23.

safety_hour Num 2 2,3,5,6,7

Safety Drill Evacuation Minutes - Enter a minute numbered from 0 to 59.

safety_min Num 2 2,3,5,6,7

Safety Drill Evacuation Seconds - Enter a second numbered from 0 to 59.

safety_evsec Num 2 2,3,5,6,7
No change Added Modified Deleted

Back to List