Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'school'

School (SC)

[school]

ID Element Name Type Size Values Cycle

Key

SC0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

fy Num 2 Table 1,2,3,4,5,6,7,8,9
SC0020

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

1 = September 30th
2 = October 15th
3 = November 15th
4 = December 15th
5 = February 15th
6 = April 15th
7 = June 15th
8 = July 31st
9 = August 31st

cycle Num 2 Table 1,2,3,4,5,6,7,8,9
SC0030

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:

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

General

SC0072

School Web Address - Web address used to communicate with public.

web_addr Alpha 40 1,2,3,4,5,6,7,8,9

Address, Mailing – The street name and building number or PO box where mail is received.

SC0080

Address - School mailing address

mail_addr Alpha 30 1,2,3,4,5,6,7,8,9
SC0090

City - School mailing address city

mail_city Alpha 20 1,2,3,4,5,6,7,8,9
SC0100

State - School mailing address state

mail_state Alpha 2 AR 1,2,3,4,5,6,7,8,9
SC0110

Zip - School mailing address zip code

mail_zip Num 5 1,2,3,4,5,6,7,8,9
SC0120

Zip-4School mailing address extended zip code

mail_zip4 Num 4 1,2,3,4,5,6,7,8,9

Address, Shipping – The street name and building number where packages of freight are received.

SC0130

Address - School shipping address

ship_addr Alpha 30 1,2,3,4,5,6,7,8,9
SC0140

City - School shipping address city

ship_city Alpha 20 1,2,3,4,5,6,7,8,9
SC0150

State - School shipping address state

ship_state Alpha 2 AR 1,2,3,4,5,6,7,8,9
SC0160

Zip - School shipping address zip code

ship_zip Num 5 1,2,3,4,5,6,7,8,9
SC0170

Zip-4School shipping address extended zip code

ship_zip4 Num 4 1,2,3,4,5,6,7,8,9

Phone Number, Office – The phone number at the school administrative office including the area code, prefix, suffix, and extension.

SC0180

Area Code - School telephone area code

phone_area Alpha 3 1,2,3,4,5,6,7,8,9
SC0190

Prefix - School telephone prefix

phone_prefix Alpha 3 1,2,3,4,5,6,7,8,9
SC0200

Suffix - School telephone suffix

phone_suffix Alpha 4 1,2,3,4,5,6,7,8,9
SC0210

Extension - School telephone extension

phone_ext Alpha 5 1,2,3,4,5,6,7,8,9

Phone Number, FAX – The FAX number at the school where incoming correspondence will be received.

SC0220

Area Code - School fax area code

fax_area Alpha 3 1,2,3,4,5,6,7,8,9
SC0230

Prefix - School fax prefix

fax_prefix Alpha 3 1,2,3,4,5,6,7,8,9
SC0240

Suffix - School fax suffix

fax_suffix Alpha 4 1,2,3,4,5,6,7,8,9
SC0250

Extension - School fax extension

fax_ext Alpha 5 1,2,3,4,5,6,7,8,9

School Designations

SC0350

Accreditation, North Central - Indicates whether the school participates in the North Central Accreditation Program.

accred_ncentral Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0352

Block Schedule - The school is on a block schedule when subjects are not normally scheduled every day for the entire year. Block schedule examples include: A-B days, 4-4, etc.

block_schedule Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0353

Minutes Per Day - The number of minutes in the school day.

minutes_day Num 4 7
SC0355

Periods Per Day - The number of periods in the school day.

N= School day not scheduled by periods
1=One period per day
2=Two periods per day
3=Three periods per day
4=Four periods per day
5=Five periods per day
6=Six periods per day
7=Seven periods per day
8=Eight periods per day
9=Nine periods per day
0=Other

prds_per_day Alpha 1 Table 1,2,3,4,5,6,7,8,9
SC0360

School, Magnet - Elementary or secondary school program within the public education system that offers exemplary learning environments or courses that are not available within the regular school curriculum. The programs are designed to attract voluntary students from all parts of a school district without reference to the usual attendance zone rules.

magnet Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0370

School, Alternative - Educational program at all levels within or outside the formal education system that provides innovative and flexible instruction, curriculums, grading systems, learning environment, degree requirements, or other alternatives to the ordinary system of instruction. Any school may have an alternative education program, however the school must be a LEA unto itself to classify as an alternative school.

alternative Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0372

School, Year Round - A year round school is defined as a school that has a normal school calendar that includes planned student attendance days outside the regular late August to early June time frame used for traditional nine month schools for regular instructional days.

sch_yrround Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0374

School, 4 Day - A four-day school is a school that does not traditionally schedule instructional days for five consecutive days but achieves the required instructional hours normally required in a week in less than five days.

sch_4day Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0376

School, Night - A night school is a school that schedules the majority of instructional time in the evening or after 3:30 p.m.

sch_night Alpha 1 Y/N 1,2,3,4,5,6,7,8,9

Service Learning – A project guided by a school staff member that engages students in addressing a need within their school or community. The activities must be curriculum integrated and must include four components:


• Planning with student
• Demonstration or performance of the activity
• Reflection of the activity, and Recognition of students

SC0378

Service Learning Project/Course - Does your school currently have a service learning projectcourse?

serv_learn Alpha 1 Y/N 4
SC0379

Service Learning Past - Has your school had a service-learning projectcourse in the past?

serv_proj Alpha 1 Y/N 4
SC0380

School-Wide Character Education Program - Character education taught throughout the entire school. Does your school have a school-wide character education program?

sch_wide Alpha 1 Y/N 4
SC0381

Receiving Title I Funds Status – Indicates whether the school is receiving title I funds

title_I Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0382

School, Federal Programs Status -

SW = SCHOOLWIDE (A school that has been approved by the ADE to provide Title I services on a school wide rather than a targeted assistance basis. A school must have at least 40% of their students identified as low income.)
TA = TARGET ASSISTED (A school that provides Title I services to identified students eligible for the services.)
NA = Not Applicable

sch_fedpgm Alpha 2 Table 1,2,3,4,5,6,7,8,9
SC0385

Level - A code indicating the range of grades taught in a school:

2 = Elementary School
3 = MiddleJunior School
4 = Secondary School

level Num 1 Table 1,2,3,4,5,6,7,8,9
SC0390

Site Use Code - A code used to describe the primary use of the school campus:

01= KindergartenPre-School
02= Primary or Upper Elementary
03= Middle School
04= Junior High School
05= Senior High School
06= K-12 Comprehensive School
07= Other (i.e. administration, bus garage, athletics, etc.)

site_use Num 2 Table 1,2,3,4,5,6,7,8,9

Current Floor Plans and Emergency Contact Information – Arkansas public schools are required to provide current floor plans and pertinent emergency contact information to appropriate first responders. This information shall be updated annually and when substantial building modifications or changes are made. (A.C.A. § 6-15-1303 )

Annual Update shall be given to appropriate first responders by the return of students to campus and reported October 15th (Cycle 2).

Updated Submission shall be given to appropriate first responders upon substantial building modifications or changes and should be completed by the occupancy of students in the new or modified building and reported in the next cycle (Cycle 3-7).

SC0395

Floor Plan Annual Submission – Updated floor plans and emergency contact information has been given to appropriate first responders (Yes/No).

A.C.A. § 6-15-1303 - requirement for schools to provide current floor plans and updated emergency contact information to local emergency responders

floor_plan_annual Alpha 1 Y/N 2
SC0396

Floor Plan Updated Information – Upon substantial building modifications or changes, updated floor plans and emergency contact information has been given to appropriate first responders (Yes/No/Not Applicable).

floor_plan_updated Alpha 2 Y/N/NA 3,4,5,6,7
SC0490

Hours, Staff Development - The number of hours teachers are scheduled for staff development based on Standard  4-G.1.

staffdev_hous Num 3 1,2
SC0560

Book Volumes - The number of printed, non-printed and electronic media items within the school's library media center.  Based on Standard 2-D.1.

lib_volumes Num 9 1,2

Quarter Calendar

SC0640

Quarter # Begin Date - Date designated as the first school day of the quarter.

qtr1_beg Date 8 MMDDYYYY 3
SC0650

Quarter # End Date - Date designated as the last school day of the quarter.

qtr1_end Date 8 MMDDYYYY 3
SC0660

Quarter # Number of Days - Number of school days contained in the quarter.

qtr1_days Num 2 MMDDYYYY 3
SC0670

Quarter #2, Begin Date - Date designated as the first school day of the quarter.

qtr2_beg Date 8 MMDDYYYY 5
SC0680

Quarter #2, End Date - Date designated as the last school day of the quarter.

qtr2_end Date 8 MMDDYYYY 5
SC0690

Quarter #2, Number of Days - Number of school days contained in the quarter.

qtr2_days Num 2 5
SC0700

Quarter #3, Begin Date - Date designated as the first school day of the quarter.

qtr3_beg Date 8 MMDDYYYY 6
SC0710

Quarter #3, End Date - Date designated as the last school day of the quarter.

qtr3_end Date 8 MMDDYYYY 6
SC0720

Quarter #3, Number of Days - Number of school days contained in the quarter.

qtr3_days Num 2 6
SC0730

Quarter #4, Begin Date - Date designated as the first school day of the quarter.

qtr4_beg Date 8 MMDDYYYY 7
SC0740

Quarter #4, End Date - Date designated as the last school day of the quarter.

qtr4_end Date 8 MMDDYYYY 7
SC0750

Quarter #4, Number of Days - Number of school days contained in the quarter.

qtr4_days Num 2 7

Tri-Annual Fire Drill

SC0760

Fire Marshall - Is there a School Fire Marshal Program currently in operation in each school?

firedr_marshpgm Alpha 1 Y/N 1
SC0770

Evacuation Plan - Is there an adequate evacuation plan with a diagram posted inside each classroom of the school.

firedr_evplan Alpha 1 Y/N 1
SC0780

Building Check - Are all buildings checked for hazards before being locked at the end of the day and at night after activities.

firedr_bldgck Alpha 1 Y/N 1

Early Childhood – Indicate the number of preschool classrooms and which programs utilize the classrooms.

SC0800

Preschool Classroom Count - Does your school provide classroom space for children below Kindergarten age on either a school campus or property for one or more of the following? If yes, what is the total number of classroom programs on campus or property?

presch_clsrm Num 3 2
SC0815

Head Start - A child development program that serve children from birth to age 5 and their families.

head_start Alpha 1 Y/N 2
SC0820

Arkansas Better Chance (ABC) - A state funded public pre-kindergarten for at risk children from birth to 5 years of age.

abc Alpha 1 Y/N 2
SC0825

Home Based - Home based programs such as Parents as teachers (PAT) Home Instruction for Parents of Preschool Youngsters (HIPPY).

hippy Alpha 1 Y/N 2
SC0830

Private Preschool - Profit/Non-profit programs.

priv_presch Alpha 1 Y/N 2
SC0835

District Funds - District funds a four (4) year old program

dist_fund Alpha 1 Y/N 2
SC0840

Early Childhood Special Education - Students receiving special education services by primary disability.

early_child_sped Alpha 1 Y/N 2
SC0845

Youngest Age Range - Enter the youngest age of the children served in the pre-school classroom.

B - Birth
1 - 1 year
2 - 2 year
3 - 3 year
4 - 4 year
5 - 5 year
N = Not applicable
young_presch Alpha 1 Table 2
SC0850

Oldest Age Range - Enter the oldest age of the children served in the pre-school classroom.

B - Birth
1 - 1 year
2 - 2 year
3 - 3 year
4 - 4 year
5 - 5 year
N = Not applicable
old_presch Alpha 1 Table 2

Out-of-School Program

SC0860

Before School - Scheduled academictutoring period prior to the beginning of a school day.

before_sch Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0865

After School - Scheduled academictutoring period following dismissal of the regular school day.

after_sch_prg Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0870

Weekends - Scheduled academictutoringenrichment time on Saturday or Sunday.

wk_end_prg Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0874

Summer School Count - Count of students who have attended summer school program in the current school year.  (End of this academic year)

sum_sch_count Num 5 ##### 9
SC0875

Summer Program - Scheduled academictutoring time following or prior to the academic school year.

sum_sch_prg Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0876

Breakfast Program - Does this school have a breakfast program at NO Cost to the students?

breakfast_prg Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0877

Lunch Program - Does this school have a lunch program at NO Cost to the students?

lunch_prg Alpha 1 Y/N 1,2,3,4,5,6,7,8,9
SC0878

Academic Programs - Please list this school’s academic programs for the students.

academic_prg Alpha 255 1,2,3,4,5,6,7,8,9
SC0879

Enrichment Programs - Please list this school’s enrichment programs for the students.

enrichment_prg Alpha 255 1,2,3,4,5,6,7,8,9

Safe Schools – Safe schools are those where students, staff members and visitors feel safe and welcome and have the opportunity to learn, teach, work and engage in activities without being threatened, intimidated, bullied, harassed, or made the victim of crime.

SC0880

Safe Schools - Has the school had a federal or state gun-free school violation as stated in the U.S. C. Federal Gun Free School Act (18 USC 922 (q) andor Arkansas Criminal Code Annotated State Gun Free School Act (Ark. Code Ann. 6-21-608) or has the school had at least one criminal offense or one violent criminal offense on school property this year as stated in (Cited Codes* for violent criminal offense means homicide (Ark. Code Ann. § 5-10-101 et seq), rape (Ark. Code Ann. § 5-14-101 et. seq.), robbery (Ark. Code Ann. § 5-12-101 et. seq.) andor aggravated assault (Ark. Code Ann. § 5-13-201-203 et. seq.)

safe_sch Alpha 1 Y/N 7

Persistently Dangerous Schools - Counts for different types of threats.

SC0881

Count, Aggravated Assault - Violations to the Safe School Environment

AggravatedAssaultCount Num 5 ## 7
SC0882

Count, Guns - Violations to the Sae School Environment

GunsOnCampusCount Num 5 ## 7
SC0883

Count, Homicide - Violations to the Safe School Environment

HomicideCount Num 5 ## 7
SC0884

Count, Rape - Violations to the Safe School Environment

RapeCount Num 5 ## 7
SC0885

Count, Robbery - Violations to the Safe School Environment

RobberyCount Num 5 ## 7
SC0886

Count, Assault in the first degree - Violations to the Safe School Environment

AssaultFirstCount Num 5 ## 7
SC0887

Count, Battery in the first or second degree - Violations to the Safe School Environment

BatteryCount Num 5 ## 7

Defibrillator – Act 496 of 2009 requires each school campus to have an automated external defibrillator and appropriate school personnel be adequately trained on or before May 31, 2011 and after this date these personnel be adequately trained on an ongoing basis.

SC0890

Defibrillator, Day - The number of times the defibrillator was used during the regular school day to save a life.

during_day Num 2 ## 5
SC0895

Defibrillator, Outside - The number of times the defibrillator was used outside of the regular school day to save a life

outside_day Num 2 ## 5
SC0900

Defibrillator, Students - The number of times the defibrillator was used to save a student.

stud_defib Num 2 ## 5
SC0910

Defibrillator, Faculty - The number of times the defibrillator was used to save faculty or staff.

staff_difib Num 2 ## 5
SC0915

Contact Person Position Title - The position andor title of the person responsible for overseeing the use of the defibrillator.

contac_title Alpha 15 5
SC0920

First Name - Defibrillator contact first name

contac_fname Alpha 20 5
SC0925

Middle Name - Defibrillator contact middle name

contac_mname Alpha 15 5
SC0930

Last Name - Defibrillator contact last name

contac_lname Alpha 25 5
SC0935

Contact Suffix - The formal name extension period if applicable. (Jr., III)

contac_suffix Alpha 3 5
SC0940

Trained Faculty - The number faculty members trained to use the defibrillator.

num_train Num 2 ## 5
SC0945

Defibrillator Fund - Was the defibrillator purchased with Tobacco Excise Tax fund?

defib_fund Alpha 1 Y/N 5
SC0946

Defibrillator Count - The number of defibrillators readily available for public use.

defib_count Num 2 ## 5
SC0947

Opioid Overdose Rescue Kit Count - The number of opioid overdose rescue kits available for public use. (Only required for High Schools)

opioid_kit_count Num 2 ## 5

Nursing Assistance Acuity Levels

SC0955

Nursing Assistance Acuity Level # 1 - Level 1: No healthcare concerns identified. The student’s physical and/or social-emotional condition is stable and sees the Nurse at least once a year for screening and occasionally as needed.

na_acuity_1 Num 6 ## 2
SC0965

Nursing Assistance Acuity Level # 2 - Level 2: Health concerns require an Individualized Healthcare Plan (IHP). The student’s physical and/or social-emotional condition is currently uncomplicated and predictable. Occasional monitoring varies from biweekly to annually. Example of a level 2 ADHD, dental disease, feeding tube

na_acuity_2 Num 6 ## 2
SC0975

Nursing Assistance Acuity Level # 3 - Level 3: Medically Complex: The medically complex student has a complex and/or unstable physical and/or social-emotional condition that requires daily treatments and close monitoring by a professional registered nurse. Example of level 3 cancer, pregnancy, moderate to severe asthma

na_acuity_3 Num 6 ## 2
SC0985

Nursing Assistance Acuity Level # 4 - Level 4: Medically Fragile: Students with complex health care needs in this category face daily the possibility of a life-threatening emergency requiring the skill and judgment of a professional nurse. An individual health care plan of nursing care developed by a registered nurse must be complete, current, and available at all times to personnel in contact with these children. Example of level 4 would be severe seizures, tracheostomy with suctioning

na_acuity_4 Num 6 ## 2
SC0995

Nursing Assistance Acuity Level # 5 - Level 5 - Nursing Dependent: Nursing dependent students require 24 hours/day, frequently one-to-one, skilled nursing care for survival. Many are dependent on technological devices for breathing, and/or for continuous nursing assessment and intervention. Example of level 5 is student on a respirator.

na_acuity_5 Num 6 ## 2
SC1000

School Start Time (Military) - Time that the school day starts - expressed in military time (Format: 0800 is equal to 08:00 a.m.).

school_start_time Num 4 ## 1,2,3,4,5,6,7,8,9
SC1010

School End Time (Military) - Time that the school day ends in military time (Format: 1515 is equal to 03:15 p.m.).

school_end_time Num 4 ## 1,2,3,4,5,6,7,8,9

Act 641 of 2019

SC1020

Grade 05 Act 641 - Indicates if grade 05 is following an elementary model or middle school model.

01 - Elementary
02 - Secondary
03 - Not Applicable

05level_selection Alpha 2 Table 1,2,3,4,5,6,7,8,9
SC1025

Grade 06 Act 641 - Indicates if grade 06 is following an elementary model or middle school model.

01 - Elementary
02 - Secondary
03 - Not Applicable

06level_selection Alpha 2 Table 1,2,3,4,5,6,7,8,9

School Safety - Arkansas School Safety Commission Recomendation

SC1050

Perimeter Doors Secured - Are the perimeter doors of the school secured?

perimiter_doors Alpha 1 Y/N 3,4,5,6,7
SC1051

 

Interior Doors Secured - Are the interior doors of the school secured?

interior_doors Alpha 1 Y/N 3,4,5,6,7
SC1052

 

Staff Wearing Badges - Are the staff wearing badges?

staff_badges Alpha 1 Y/N 3,4,5,6,7
SC1053

 Visitor Security - Are there provisions for ensuring visitor security?

visitor_security Alpha 1 Y/N 3,4,5,6,7
SC1054

Drills Completed - Are the drills completed?

 

drills_complete Alpha 1 Y/N 3,4,5,6,7

School Meal Counts
Collected in Cycles 1 (July/Aug.), 2 (Sept.), 3 (Oct.), 4 (Nov.), 5 (Dec./Jan.), 6 (Feb./March), 7 (April/May) and 8 (June)

SC1060

Number of days served - Number of days breakfast and/or lunch were served.  (Non-summer programs)

meals_days Num 5 ##### 1,2,3,4,5,6,7,8
SC1065

Student Breakfast - Free - Count of breakfast served to students at no charge

bfast_free_cnt Num 5 ##### 1,2,3,4,5,6,7,8
SC1070

Student Breakfast – Reduced – Count of breakfast served to students at reduced
price

bfast_red_cnt Num 5 ##### 1,2,3,4,5,6,7,8
SC1075

Student Breakfast - Full Price – Count of breakfast served to students at full price.

bfast_full_cnt Num 5 ##### 1,2,3,4,5,6,7,8
SC1080

Student Lunch – Free - Count of lunch served to students at no charge

lunch_free_cnt Num 5 ##### 1,2,3,4,6,5,7,8
SC1085

Student Lunch – Reduced – Count of lunch served to students at reduced price.

lunch_red_cnt Num 5 ##### 1,2,3,4,5,6,7,8
SC1090

Student Lunch - Full Price – Count of lunch served to students at full price

lunch_full_cnt Num 5 ##### 1,2,3,4,5,6,7,8
SC1095

Non-Student Meals – Count of meals served to non students

nonst_meal_cnt Num 5 ##### 1,2,3,4,5,6,7,8
No change Added Modified Deleted

Back to List