This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
student:fitnessgram_export [2022/02/21 18:02] – apape | student:fitnessgram_export [2022/03/03 21:31] – apape | ||
---|---|---|---|
Line 1: | Line 1: | ||
======FitnessGram Export====== | ======FitnessGram Export====== | ||
+ | |||
+ | ==== In a future release, FitnessGram Export will be renamed to PFAI Export==== | ||
+ | |||
The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).\\ | 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 | + | If the district is submitting a district-wide |
\\ | \\ | ||
^ ^Column^Type^Max Length^Valid Values^Description^ | ^ ^Column^Type^Max Length^Valid Values^Description^ | ||
- | |A|SchoolID *|Alphanumeric|50| |CountyDistrictID-CountyDistrictID | + | |A|SchoolID *|Alphanumeric|9|Only use whole numbers. Do not use hyphens. A leading zero is required if applicable to the School ID. |CountyDistrict+CampusNumber |
- | |B|School Name*|Alphanumeric|50| |Must be unique in the district. Ensure student IDs remain consistent year to tear to avoid duplication.| | + | |B|School Name*|Alphanumeric|75| |Name of school.| |
- | |C|Test Date*|Alphanumeric|35| |mm/dd/yyyy or m/dd/yyyy| | + | |C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ |
- | |D|StudentGrade*|Alphanumeric|10|3-12|Single, | + | |D|StudentGrade*|Alphanumeric|10|3-12|Single, |
|E|StudentGender*|Alphanumeric|1|m, | |E|StudentGender*|Alphanumeric|1|m, | ||
|F|Height|Numeric| | |Expressed in inches.| | |F|Height|Numeric| | |Expressed in inches.| | ||
|G|Weight|Numeric| | |Expressed in pounds.| | |G|Weight|Numeric| | |Expressed in pounds.| | ||
- | |H|Skinfold Tricep|Numeric| | |If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203).| | + | |H|Skinfold Tricep|Numeric| | | | |
- | |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.| | + | |I|Skinfold Calf|Numeric| | | | |
- | |J|1 Mile Run (Minutes)|Numeric| | |Only used for districts using single sign on.| | + | |J|1 Mile Run (Minutes)|Numeric| | | | |
|K|1 Mile Run (Seconds)|Numeric| |0-59| | | |K|1 Mile Run (Seconds)|Numeric| |0-59| | | ||
|L|PACER Laps|Numeric| |0-300| | | |L|PACER Laps|Numeric| |0-300| | | ||
Line 29: | Line 32: | ||
|W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes| | |W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes| | ||
|X|Shoulder Stretch-Right|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| | + | |Y|IsHispanicLatino|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected| |
- | |Z|IsAmericanIndianAlaskaNative|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = No| | + | |Z|IsAmericanIndianAlaskaNative|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected| |
- | |AA|IsAsian|Alphanumeric| | + | |AA|IsAsian|Alphanumeric| |
- | |AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = No | | + | |AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected| |
- | |AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = No | | + | |AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected| |
- | |AD|IsWhite|Alphanumeric| | + | |AD|IsWhite|Alphanumeric| |