Skip to main content
Skip table of contents

Physical Fitness Student File

Contents

Introduction

Public school students in grade levels five, seven, and nine are required to take the Physical Fitness Testing (PFT), whether or not they are enrolled in a physical education class or participate in a block schedule. Students include those enrolled in elementary, high, and unified school districts, county offices of education, and charter schools. School districts should also test all students in alternate programs, including, but not limited to, continuation schools, independent study, community day schools, county community schools, and nonpublic schools. Students who are physically unable to take the entire test are to be given as much of the test as conditions permit.

Beginning in 2009, student scores will be based on the student's age on the date when the first test is administered to the student. Therefore, the first day of testing must be added to each student's record.

Note: The Physical Fitness Test is TAB delimited. As a result, it can be opened in a text editor or in Excel as a delimited file.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects which student records to use based on the following criteria:

  • The student must not be excluded from state reporting.
  • The student must be enrolled in a school included in the report.
  • The student must be enrolled in one of the following grade levels: 5, 7, or 9.
  • The student's school enrollment Entry Date must occur on or before the report end date.
  • The student's school enrollment Exit Date must occur after the report start date.
  • The school enrollment Exit Date must occur after the Entry Date.

Back to top

Report Input

This report is run at the School and District level.

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

If run at the district level, choose one of the following from the pop-up menu:

  • Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
  • Current School Only – Includes all records associated with the current school that meet the selection criteria.
  • District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to Include

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 runningreport.

Begin Date and Ending Date

Enter the start and end dates for the report.

Processing Options

Choose a time to run the report from the pop-up menu:

  • In Background Now (Recommended) – Execute the report immediately in the background.
  • ASAP – Execute the report in the order it is received in the Report Queue.
  • At Night – Execute the report during the next evening.
  • On Weekend – Execute the report during the next weekend.
  • On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Back to top

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.

Note: If no value is entered for a particular aspect of the physical fitness test, the report extracts blank, rather than zero. A zero indicates that an attempt was completed with a score of zero.

Report Output Format: The report output format for this report is a fixed length and caret delimited.

Item #

Data Element

Description

[Table]FieldName

1

County Code

The county number. The first two digits of the district number are reported.

[Prefs]Value

[Prefs]Name=districtnumber

2

District Code

The district number.

[Prefs]Value

[Prefs]Name=districtnumber

3

School Code

The school number.

[S_CA_SCH_X]StateSchoolNumber

4

Charter School Number

The charter school number, if applicable. If not applicable, the value 0000 is reported.

[S_CA_SCH_X]CharterSchoolNumber

5

Grade

The grade level of the student.

Valid values: 05, 07, or 09

Note: For  school year is 23-24 or higher, grade level mapped to LTK will be displayed. 

[Students]Grade_Level

[S_CA_STU_PhysicalFitness_C]GradeLevel

6

Last Name

The student’s last name.

[Students]Last_Name

7

First Name

The student’s first name.

[Students]First_Name

8

Middle Name

The student’s middle name.

[Students]Middle_Name

9

Date of Birth (month)

The student’s month of birth.

[Students]DOB

10

Date of Birth (day)

The student’s day of birth.

[Students]DOB

11

Date of Birth (year)

The student’s year of birth.

[Students]DOB

12

Gender

The student’s gender.

Valid values: M or F.

[Students]Gender

13

Statewide Student ID (SSID)

The state assigned student identification number.

If the student’s state student number is blank, then their locally assigned number is extracted.

[Students]State_StudentNumber

[Students]Student_Number

14

Hispanic or Latino?

The student’s ethnicity.

Valid value: Y or N

[Students]Fedethnicity

15

Race – Black or African American

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 600

16

Race – American Indian or Alaska Native

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 100

17

Race – Chinese

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 201

18

Race – Japanese

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 202

19

Race – Korean

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 203

20

Race – Vietnamese

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 204

21

Race – Asian Indian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 205

22

Race – Laotian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 206

23

Race – Cambodian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 207

24

Race – Hmong

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 208

25

Race – Other Asian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 299

26

Race – Filipino

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 400

27

Race – Native Hawaiian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 301

28

Race – Guamanian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 302

29

Race – Samoan

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 303

30

Race – Tahitian

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 304

31

Race – Other Pacific Islander

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 399

32

Race – White

The student’s race.

Valid values: Y or blank

[StudentRace]Racecd = 700

33

Parent/Guardian Highest Education Level

The highest education level of the student’s parents.

Valid values:

  • 10 – Graduate school/post graduate training
  • 11 – College graduate
  • 12 – Some college (include AA degree)
  • 13 – High school graduate
  • 14 – Not a high school graduate
  • 15 – Decline to state or unknown

[S_CA_STU_X]ParentEd

34

NLSP (National School Lunch Program – identified as eligible)

The student’s NSLP eligibility.

The student is eligible if they have an active 175, 181, or 182 program membership code on the test date.

Valid values: Y or N

[S_CA_STU_CALPADSPrograms_C]ProgramCode = 175, 181, or 182

35

PFT Start Date (month)

The month during which the physical fitness test took place.

Note: The date is only extracted if the student completed, or partially completed the test.

[S_CA_STU_PhysicalFitness_C]TestDate

36

PFT Start Date (day)

The day on which the physical fitness test took place.

Note: The date is only extracted if the student completed, or partially completed the test.

[S_CA_STU_PhysicalFitness_C]TestDate

37

PFT Start Date (year)

The year during which the physical fitness test took place.

Note: The date is only extracted if the student completed, or partially completed the test.

[S_CA_STU_PhysicalFitness_C]TestDate

38

Filler

No longer collected.

N/A

39

Filler

No longer collected.

N/A

40

Height (Feet)

The height, in feet, of the student.

This value is extract if the student’s Body Mass Index (BMI) is selected on the Physical Fitness Test student page.

Valid values: 03 – 07

[S_CA_STU_PhysicalFitness_C]BMIfeet

41

Height (Inches)

The height, in inches (in addition to feet), of the student.

This value is extracted if the Body Mass Index (BMI) of the student is selected on the Physical Fitness Test student page.

Valid values: 01 - 11

[S_CA_STU_PhysicalFitness_C]BMIinches

42

Weight (Pounds)

The weight, in pounds, of the student.

This value is extracted if the Body Mass Index (BMI) of the student is selected on the Physical Fitness Test student page.

Valid values: 001 – 400

[S_CA_STU_PhysicalFitness_C]BMIpounds

43

Aerobic Capacity – Mile Run Minutes

The number of minutes taken to complete running one mile.

This value is extracted if Mile Run is selected on the Physical Fitness Test student page.

Valid values: 03 - 59

[S_CA_STU_PhysicalFitness_C]MileRunMin

44

Aerobic Capacity – Mile Run Seconds

The number of seconds (in addition to minutes) taken to complete running one mile.

This value is extracted if Mile Run is selected on the Physical Fitness Test student page.

Valid values: 00 - 59

[S_CA_STU_PhysicalFitness_C]MileRunSec

45

Aerobic Capacity – Pacer

The number of laps completed by the student.

This value is extracted if PACER is selected on the Physical Fitness Test student page.

Valid values: 001 - 190

[S_CA_STU_PhysicalFitness_C]Laps

46

Aerobic Capacity – Walk Test Minutes

The number of minutes taken to complete a walk test.

This value is extracted if Walk Test is selected on the Physical Fitness Test student page.

Valid values: 03 - 59

[S_CA_STU_PhysicalFitness_C]WalkTestMin

47

Aerobic Capacity – Walk Test Seconds

The number of seconds (in addition to minutes) taken to complete a walk test.

This value is extracted if Walk Test is selected on the Physical Fitness Test student page.

Valid values: 030 - 250

[S_CA_STU_PhysicalFitness_C]WalkTestSec

48

Aerobic Capacity – Heart Rate

The heart rate of the student after the walk test.

This value is extracted if Walk Test is selected on the Physical Fitness Test student page.

Valid values: 030 - 250

[S_CA_STU_PhysicalFitness_C]HeartRateBeats

49

Body Composition – Skinfold Measurement - Triceps

The measurement, in millimeters, of the student’s triceps.

This value is extracted if Skinfold Measurement is selected on the Physical Fitness Test student page.

Valid values: 01 - 40

[S_CA_STU_PhysicalFitness_C]TricepsMM

50

Body Composition – Skinfold Measurement – Calf

The measurement, in millimeters, of the student’s calf.

This value is extracted if Skinfold Measurement is selected on the Physical Fitness Test student page.

Valid values: 01 - 40

[S_CA_STU_PhysicalFitness_C]CalfMM

51

Body Composition – Bioelectric Impedance / Automated Skinfold Calipers - % Body Fat

The percentage body fat of the student.

Extracted in the format 0.00.

This value is extracted if Bioeletric Impedance / Automated Skinfold Calipers is selected on the Physical Fitness Test student page.

Valid values: 00.1 – 99.9

[S_CA_STU_PhysicalFitness_C]BodyFat

52

Abdominal Strength – Curl-ups

The number of curl-ups completed by the student.

This value is extracted if Curl-ups is selected on the Physical Fitness Test student page.

Valid values: 01 – 75 (Max = 75)

[S_CA_STU_PhysicalFitness_C]CurlUps

53

Trunk Strength – Trunk Lift

The number of inches the student completed in the trunk lift exercise.

This value is extracted if Trunk Lift is selected on the Physical Fitness Test student page.

Valid values: 00 – 12 (Max = 12)

[S_CA_STU_PhysicalFitness_C]TrunkLift

54

Upper Body Strength – Push-Ups

The number of push-ups completed by the student.

This value is extracted if Push-Ups is selected on the Physical Fitness Test student page.

Valid values: 01 – 75 (Max = 75)

[S_CA_STU_PhysicalFitness_C]PushUps

55

Upper Body Strength – Modified Pull-ups

The number of pull-ups completed by the student.

This value is extracted if Modified Pull-ups is selected on the Physical Fitness Test student page.

Valid values: 01 – 75 (Max = 75)

[S_CA_STU_PhysicalFitness_C]PullUps

56

Upper Body Strength – Flexed Arm Hang

The number of seconds that the student sustained an arm hang.

This value is extracted if Flexed Arm Hang is selected on the Physical Fitness Test student page.

Valid values: 00 – 90 (Max – 90)

[S_CA_STU_PhysicalFitness_C]ArmHangSec

57

Flexibility – Sit and Reach Left

The number of inches that the student could reach to the left while sitting.

This value is extracted if Sit and Reach is selected on the Physical Fitness Test student page.

Valid values: 01 – 12 (Max = 12)

[S_CA_STU_PhysicalFitness_C]SitReachLeft

58

Flexibility – Sit and Reach Right

The number of inches that the student could reach to the right while sitting.

This value is extracted if Sit and Reach is selected on the Physical Fitness Test student page.

Valid values: 01 – 12 (Max = 12)

[S_CA_STU_PhysicalFitness_C]SitReachRight

59

Flexibility – Shoulder Stretch Left

The number of inches that the student could stretch their shoulder to the left.

This value is extracted if Shoulder Stretch is selected on the Physical Fitness Test student page.

Valid values: Y, N, or blank

[S_CA_STU_PhysicalFitness_C]StretchLeft

60

Flexibility – Shoulder Stretch Right

The number of inches that the student could stretch their shoulder to the right.

This value is extracted if Shoulder Stretch is selected on the Physical Fitness Test student page.

Valid values: Y, N, or blank

[S_CA_STU_PhysicalFitness_C]StretchRight

Back to top

Warnings

The following warnings may occur when the Physical Fitness Testing report is run using delimiters.

Warning

Resolution

WARNING! Physical Fitness Testing Results not found.  Please enter Physical Fitness Testing Information for this student and grade.

The student does not have any Physical Fitness Testing records.

Create a Physical Fitness Testing record for the student on the Physical Fitness Testing page.

WARNING! Too Many Results found.  Please ensure that there is only 1 Physical Fitness Testing data entry for this student and grade.

The student has more than one Physical Fitness Testing record for one of the following grade levels: 5, 7, or 9.

Delete extraneous records by navigating to the Physical Fitness Testing page, selecting the record and click Delete at the bottom of the page.

Date column contains “????????”

The test date for a Physical Fitness Testing record is invalid.

Correct the date for the record on the Physical Fitness Testing page.

Reason Code column contains “??”

If Yes is selected for the field Incomplete Data on the Physical Fitness Testing page, a value must be selected for Reason for Incomplete Data. If a reason is not selected, the warning will occur.

Choose a reason for incomplete data for the Physical Fitness Testing record.

Back to top


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.