This is an old revision of the document!
The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).
If the district is submitting a district-wide FitnessGram file, copy each campus extract into one file, and remove the campus ID from the name (e.g., FG_Extract_2019.csv). Save the exported document as a .csv file.
Column | Type | Max Length | Valid Values | Description | |
---|---|---|---|---|---|
A | SchoolID * | Alphanumeric | 50 | CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001) | |
B | School Name* | Alphanumeric | 50 | Must be unique in the district. Ensure student IDs remain consistent year to tear to avoid duplication. | |
C | Test Date* | Alphanumeric | 35 | mm/dd/yyyy or m/dd/yyyy | |
D | StudentGrade* | Alphanumeric | 10 | 3-12 | |
E | StudentGender* | Alphanumeric | 1 | m, f, M, F | |
F | Height | Numeric | Expressed in inches. | ||
G | Weight | Numeric | Expressed in pounds. | ||
H | Skinfold Tricep | Numeric | If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203). | ||
I | Skinfold Calf | Numeric | The student’s E-mail from Registration. If email address is not included, those student and parent reports cannot be sent. | ||
J | 1 Mile Run (Minutes) | Numeric | Only used for districts using single sign on. | ||
K | 1 Mile Run (Seconds) | Numeric | 0-59 | ||
L | PACER Laps | Numeric | 0-300 | ||
M | 1 Mile Walk (Minutes) | Numeric | |||
N | 1 Mile Walk (Seconds) | Numeric | 0-59 | ||
O | 1 Mile Walk Heart Rate | Numeric | |||
P | Curl Up | Numeric | 0-75 | ||
Q | Trunk Lift | Numeric | 0-12 | Expressed in inches. | |
R | Push Up | Numeric | 0-99 | ||
S | Modified Pull Up | Numeric | |||
T | Flexed Arm Hang | Numeric | 0-999 | Expressed in seconds | |
U | Back Saver Sit & Reach-Left | Numeric | 0-999 | Expressed in inches. | |
V | Back Saver Sit & Reach-Right | Numeric | 0-12 | Expressed in inches. | |
W | Shoulder Stretch-Left | Numeric | 1 or 2 | 1 = No; 2 = Yes | |
X | Shoulder Stretch-Right | Numeric | 1 or 2 | 1 = No; 2 = Yes | |
Y | IsHispanicLatino | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No | |
Z | IsAmericanIndianAlaskaNative | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No | |
AA | IsAsian | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No | |
AB | IsBlackAfricanAmerican | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No | |
AC | IsNativeHawaiianOtherPacificIslander | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No | |
AD | IsWhite | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = No |
*Required
Notes: