Physical Fitness Student File
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.
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:
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.
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:
|
Specific Date/Time | Pick a date using the date picker (the format mm/dd/yyyyor mm-dd-yyyy) 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. |
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:
| [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 |
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. |