Database Schema for Handbook 2026-2027

Back to List
View Source Document for Table 'Student Fitness'

Presidential Student Fitness Test (SF)

[Student Fitness]

ID Element Name Type Size Values Cycle

Key
SF0010

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

 FY Num 2 Table 7
SF0020

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

7 = June 1st

 cycle Num 1 1-9 7
SF0030

LEA, District/Coop - 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:


6001000
60 = Pulaski County
   01 = Little Rock School District
      000 = N/A (zeroes for district)

 LEA Alphanum 7 9999999 7
SF0040

Student SSN

 fitness_ssn Alpha 9 ######### 7
SF0050

Unique Student ID

 uniq_stu_id Alpha 10 ########## 7
SF0060

Grade

 fitness_grade Alphanum 2 ## 7

Fitness Results
SF0100

Cardio-Respiratory Endurance Completed


(Ages 5-9) 20m Suttle Run, untimed
(3rd Grade) Half mile run
(4th grade and up) One mile run

 cr_endur_completed Alpha 1 Y/N 7
SF0110

Cardio-Respiratory Endurance Time

 flex_score Num 5 ##:## 7
SF0120

Flexibility Test Type

V-sit and Reach 
Back Saver Sit and Reach

 flex_type Num 1 # 7
SF0130

Fexibility Score

 flex_score Num 2 ## 7
SF0140

Muscular Strength Test Type

90 degree push up
Pull up
Flexed Arm Hang

 ms_type Num 1 # 7
SF0150

Muscular Strength Score

 ms_score Num 2 ## 7
SF0160

Muscular Endurance Test Type

Partial sit up count

 me_type Num 1 # 7
SF0170

Muscular Endurance Score

 me_score Num 2 ## 7
No change Added Modified Deleted

Back to List