Student Physical Fitness Test (PFT) File Layout

1

County Code

Administration > Registration Setup > Building > Building Definition: State Equivalency Code field on Preferences panel--First 2 characters (Reg_building.state_code_equiv)

1-2

Alpha - 2 Char

 Required
county code from the school CDS code

2

School District Code

Administration > Registration Setup > Building > Building Definition: State Equivalency Code field on Preferences panel--characters 3-7 (Reg_building.state_code_equiv)

3-7

Numeric - 5 Char

 Required
school district code from the school CDS code.

3

School Code

Administration > Registration Setup > Building > Building Definition: State Equivalency Code field on Preferences panel--characters 8-14 (Reg_building.state_code_equiv)

8-14

Alpha -7 Char

 Required
school code from the school CDS code

4

Charter School Number

Administration > Registration Setup > Building District Defined > CA Institution: Charter School field (Building user defined page -> page_number = 200, field number 8)

15-18

Alpha -
4 Char

Required
0000 for dependent charter
schools and public schools.
For independent charter school, enter the 4-digit charter school Number.

5

Grade

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal (Reg_entry_with.grade)

79-80

Alpha -
2 Char

 Required
Grade 05, 07, or 09

6

Student Last Name

Registration > Entry & Reports > Student Demographic > Registration: Last Name (reg.last_name)

21-31

Alpha -
11 Char

7

Student First Name

Registration > Entry & Reports > Student Demographic > Registration: First Name (Reg.first_name)

32-40

Alpha -
9 Char

8

Student Middle Initial

Registration > Entry & Reports > Student Demographic > Registration: Middle Name (Reg.middle_name)

41

Alpha -
1 Char

9

Date of Birth (month)

Registration > Entry & Reports > Student Demographic > Registration: Birth Date (Reg.birthdate)

42-43

Numeric – 2 Char

01-12

10

Date of Birth (day)

Registration > Entry & Reports > Student Demographic > Registration: Birth Date (Reg.birthdate)

43-44

Numeric – 2 char

01-31

11

Date of Birth (Year)

Registration > Entry & Reports > Student Demographic > Registration: Birth Date (Reg.birthdate)

45-48

Numeric -4 Char

Must be a valid year, given grade of student

12

Gender

Registration > Entry & Reports > Student Demographic > Registration: Gender field (reg.gender)

89

Alpha -
1 Char

M or F

13

SSID Statewide Student ID

Registration > Entry & Reports > Student Demographic > Personal: State ID field (reg_personal.state_report_id)

14

Hispanic/Latino Ethnicity

Registration > Entry & Reports > Student Demographic > Personal: Hispanic/Latino Ethnicity (Reg_personal.hispanic )

60

Numeric -
1 Char

Y = Yes, N = No

15

Race - Black or African
American

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '600' then Y else blank.)

61

Alpha – 1 char

Y = Yes, Blank

16

Race - American Indian
or Alaska Native

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '100' then Y else blank.)

62

Alpha – 1 char

Y = Yes, Blank

17

Race - Chinese

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '201' then Y else blank.)

63

Alpha – 1 char

Y = Yes, Blank

18

Race - Japanese

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '202' then Y else blank.)

64

Alpha – 1 char

Y = Yes, Blank

19

Race - Korean

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '203' then Y else blank.)

65

Alpha – 1 char

Y = Yes, Blank

20

Race - Vietnamese

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '204' then Y else blank.)

66

Alpha – 1 char

Y = Yes, Blank

21

Race - Asian Indian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '205' then Y else blank.)

67

Alpha – 1 char

Y = Yes, Blank

22

Race - Laotian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '206' then Y else blank.)

68

Alpha – 1 char

Y = Yes, Blank

23

Race - Cambodian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '207' then Y else blank.)

69

Alpha – 1 char

Y = Yes, Blank

24

Race - Hmong

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '208' then Y else blank.)

70

Alpha – 1 char

Y = Yes, Blank

25

Race - Other Asian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '299' then Y else blank.)

71

Alpha – 1 char

Y = Yes, Blank

26

Race - Filipino

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '400' then Y else blank.)

72

Alpha – 1 char

Y = Yes, Blank

27

Race - Native Hawaiian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '301' then Y else blank.)

73

Alpha – 1 char

Y = Yes, Blank

28

Race - Guamanian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '302' then Y else blank.)

74

Alpha – 1 char

Y = Yes, Blank

29

Race - Samoan

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '303' then Y else blank.)

75

Alpha – 1 char

Y = Yes, Blank

30

Race - Tahitian

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '304' then Y else blank.)

76

Alpha – 1 char

Y = Yes, Blank

31

Race - Other Pacific
Islander

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '399' then Y else blank.)

77

Alpha – 1 char

Y = Yes, Blank

32

Race - White

Registration > Entry & Reports > Student Demographic > Personal: Race (If regtb_ethnicity.state_code_equiv for reg_ethnicity.ethnic_code = '700' then Y else blank.)

78

Alpha – 1 char

Y = Yes, Blank

33

Parent/Guardian Highest
Educational Level

Registration > Entry & Reports > Student Demographic > Contacts>General panel: Education Level (Get the regtb_educ_level.state_code_equiv where reg_stu_contact. contact_id = reg_stu_contact. contact_id and reg_stu_contact. contact_type = 'G')

79-80

Alpha – 2 char

10 – 15

34

NSLP (National School
Lunch Program –
identified as eligible)

Registration > Entry & Reports > Student Demographic > Programs: CALNC – National School Lunch Program (Reg_programs.program_value where program_id = 'CALNC' and field_number = 2)

81

Alpha – 1 char

Y = Yes, N = No

35

PFT Start Date (month)

Test Scores > All > Student > Test History by Student: Test Date (LTDB_STU_TEST.Test_Date)

82-83

Numeric – 2 char

01-12

36

PFT Start Date (day)

Test Scores > All > Student > Test History by Student: Test Date (LTDB_STU_TEST.Test_Date)

84-85

Numeric – 2 char

01-31

37

PFT Start Date (year)

Test Scores > All > Student > Test History by Student: Test Date (LTDB_STU_TEST.Test_Date)

86-89

Numeric – 4 char

Must be a valid year

38

Participation Level

Check whether student has scores in all the six fitness areas. The fitness area are

1. Aerobic Capacity
2. Body Composition
3. Abdominal Strength and Endurance
4. Trunk Extensor Strength and Flexibility
5. Upper Body Strength and Endurance
6. Flexibility
   
   If student has scores for all 6 fitness then the value should be "1".
   If student has scores for 1, 2, 3, 4 or 5 fitness, then the value should be "2"
   If the student has no scores, then the value should be "3"

90

Numeric – 1 char

1, 2, or 3

39

Reason for Participation
Level

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'IncompReas' and score_code = 'Reason'

91

Numeric- 1 char

1, 2, 3, 4, or Blank

40

Height
(feet)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'HeightF'

92-93

Numeric – 2 char

03 – 07

41

Height
(inches)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'HeightI'

94-95

Numeric – 2 char

00 – 11

42

Weight (pounds)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'Weight'

96-98

Numeric -
3 Char

(030 – 400)

Aerobic Capacity

43

One-Mile Run2 (minutes)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'MileRunM'

99-100

Numeric -
2 Char

(03 – 59)

44

One-Mile Run2 (seconds)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'MileRunS'

101-102

Numeric -
2 Char

(00 – 59).

45

20m PACER3 (number of laps)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'Pacer'

103-105

Numeric-3Char

(001 – 190)

46

Walk Test2 (minutes)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'WalkTestM'

106-107

Numeric -
2 Char

(03 – 59).

47

Walk Test2 (seconds)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'WalkTestS'

108-109

Numeric -
2 Char

(00 – 59)

48

Heart Rate (# beats per minute)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AerobicCap' and score_code = 'HeartRate'

110-112

Numeric -
3 Char

(030 – 250) per min

Body Composition

49

Skinfold Measurement
Triceps (millimeters)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'TricepMeas'

113-114

Numeric -
2 Char

(01 – 40)

50

Skinfold Measurements Calf (millimeters)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'CalfMeas'

115-116

Numeric -
2 Char

(01 – 40)

51

Bioelectric Impedance
Analyzer
(percent body fat)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'BodyComp' and score_code = 'PercBodFat'

117-120

Alpha -
4 Char

(00.1 – 99.9)

Abdominal Strength and Endurance

52

Abdominal Strength
Curl-Ups (number completed)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'AbdomStren' and score_code = 'CurlUps'

121-122

Numeric – 2 Char

(01 – 75 ) (Max = 75)

Trunk Extensor Strength and Flexibility

53

Trunk Lift
(# inches)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'TrunkStren' and score_code = 'TrunkLift'

123-124

Numeric – 2 Char

(00 – 12) (Max = 12)

Upper Body Strength and Endurance

54

Push-Ups (number completed)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'UpperBod' and score_code = 'PushUps'

125-126

Numeric – 2 Char

01 – 75 (Max = 75)

55

Modified Pull-Ups (number
completed)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'UpperBod' and score_code = 'MPullUps'

127-128

Numeric – 2 Char

01 – 75 (Max = 75)

56

Flexed Arm Hang (seconds)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'UpperBod' and score_code = 'FlxArmHang'

129-130

Numeric – 2 Char

00 – 90 (Max = 90)

Flexibility

57

Sit and Reach -
Left (# of inches)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'Flexibil' and score_code = 'SNRLeft'

131-132

Numeric – 2 Char

00 – 12 (Max = 12)

58

Sit and Reach -
Right (# of inches)

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'Flexibil' and score_code = 'SNRRight'

133-134

Numeric – 2 Char

00 – 12 (Max = 12)

59

Shoulder Stretch -
Left

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'Flexibil' and score_code = 'ShdrStrL'

135

Alpha – 1 Char

Y = Yes, N = No

60

Shoulder Stretch - Right

LTDB_STU_SUBTEST.score where Test = 'PhysicalFitnessTest' and subtest = 'Flexibil' and score_code = 'ShdrStrR'

136

Alpha – 1 Char

Y = Yes, N = No