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 2026-2027 reporting year fy must be = 36

 fy Num 2 ## 7
SF0020

Cycle – The reporting cycle for which the data is submitted:  
    7 = June 15th  

 cycle Num 1 # 7
SF0030

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 Num 7 ####### 7
SF0040

SSN, Student – The nine-digit Social Security number of the student.  If a student’s SSN cannot be obtained, then the ADE assigned number as required by Arkansas Code Ann. 6-18-208 should be used. This number should remain the same throughout the student’s school career.

 ssn Num 9 ######### 7
SF0050

State Reporting ID – The unique 10-digit Triand identifier generated for the student by the state.

 SF0050 Num 10 ########## 7
SF0060

Grade Level – The grade level in which the student is currently enrolled: 
    03 = 3rd Grade         08 = 8th Grade
    04 = 4th Grade         09 = 9th Grade
    05 = 5th Grade         10 = 10th Grade
    06 = 6th Grade         11 = 11th Grade
    07 = 7th Grade         12 = 12th Grade    

 grade Alphanum 2 ## 7

Fitness Results
SF0100
Cardio-Respiratory Endurance Completed
   1 - (3rd Grade) Half mile run
   2 - (4th grade and up) One mile run
 cr_endur_completed Alpha 1 Y/N 7
SF0110

Cardio-Respiratory Endurance Time

 cr_endur_timed DateTime 5 ##:## 7
SF0120

Flexibility Test Type
   1 - V-sit and Reach 
   2 - Back Saver Sit and Reach

 flex_type Num 2 ## 7
SF0130

Fexibility Score

 flex_score Num 2 ## 7
SF0140

Muscular Strength Test Type
   1 - 90 degree push up
   2 - Pull up
   3 - Flexed Arm Hang

 ms_score Num 2 ## 7
SF0160

Muscular Endurance Test Type
   1 - Partial sit up count

 ms_type Num 1 # 7
SF0170

Muscular Endurance Score

 me_score Alpha 2 ## 7
No change Added Modified Deleted

Back to List