student:pfai_export
Add this page to your book 
Remove this page from your book 
Manage book (
Help PFAI Export
The extract file name is PFAI_Extract_SchoolYear_CampusID+.csv (e.g., PFAI_Extract_2019_001.csv).
If the district is submitting a district-wide PFAI file, copy each campus extract into one file, and remove the campus ID from the name (e.g., PFAI_Extract_2019.csv). Save the exported document as a .csv file.
| Column | Type | Max Length | Valid Values | Description | |
|---|---|---|---|---|---|
| A | SchoolID * | Alphanumeric | 9 | Only use whole numbers. Do not use hyphens. A leading zero is required if applicable to the School ID. | Identification number of the school. CountyDistrict+CampusNumber (6-digit County District Number + 3-digit Campus Number Example: 001901 + 101) |
| B | School Name* | Alphanumeric | 75 | Name of school. | |
| C | Test Date* | Alphanumeric | Values may contain leading zeroes or not. Example: 3/1/2021 or 03/01/2021 | Make sure the upload file has only the most recent or current test date. | |
| D | StudentGrade* | Alphanumeric | 10 | 3-12 | Single, alphanumeric characters for grade levels 3-9, or two digits for grade levels 10-12. Leading zeros are acceptable (03 or 3) |
| E | StudentGender* | Alphanumeric | 1 | m, f, M, F | Not case-sensitive. |
| F | Height | Numeric | A whole number. | Expressed in inches. | |
| G | Weight | Numeric | A whole number. | Expressed in pounds. | |
| H | Skinfold Tricep | Numeric | A whole number. | ||
| I | Skinfold Calf | Numeric | A whole number. | ||
| J | 1 Mile Run (Minutes) | Numeric | A whole number. | ||
| K | 1 Mile Run (Seconds) | Numeric | A whole number, 0-59. | ||
| L | PACER Laps | Numeric | A whole number, 0-300. | ||
| M | 1 Mile Walk (Minutes) | Numeric | A whole number. | ||
| N | 1 Mile Walk (Seconds) | Numeric | A whole number, 0-59. | ||
| O | 1 Mile Walk Heart Rate | Numeric | A whole number. | ||
| P | Curl Up | Numeric | A whole number, 0-75. | ||
| Q | Trunk Lift | Numeric | A whole number, 0-12. | Expressed in inches. | |
| R | Push Up | Numeric | A whole number, 0-99. | ||
| S | Modified Pull Up | Numeric | A whole number, 0-999. | ||
| T | Flexed Arm Hang | Numeric | A whole number, 0-999. | Expressed in seconds. | |
| U | Back Saver Sit & Reach-Left | Numeric | A whole number, 0-12. | Expressed in inches not to exceed 12. | |
| V | Back Saver Sit & Reach-Right | Numeric | A whole number, 0-12. | Expressed in inches not to exceed 12. | |
| 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 = Not Selected | |
| Z | IsAmericanIndianAlaskaNative | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = Not Selected | |
| AA | IsAsian | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = Not Selected | |
| 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 = Not Selected | |
| AD | IsWhite | Alphanumeric | 1, 0, or blank | 1 = Yes; 0 or blank = Not Selected |
*Required
Notes:
- Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use ASCENDER Business, columns for staff information are blank.
- Do not use commas in the data fields; commas will cause the import to fail. If there is a comma in an email field, the email field will be blank when it is exported.
- Do not use periods in the data fields; periods will cause the import to fail. If there is a period in an email field, the email field will be blank when it is exported.
- Do not enter blank spaces in fields that will be empty.
- Do not insert blank rows into the file.
student/pfai_export.txt · Last modified: 2023/07/31 15:07 by lrosdahl