This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| student:pfai_export [2023/07/31 14:41] – lrosdahl | student:pfai_export [2023/07/31 15:07] (current) – lrosdahl | ||
|---|---|---|---|
| Line 7: | Line 7: | ||
| |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//)| | |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.| | |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/ | + | |C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ //Example: 3/1/2021 or 03/ |
| |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| |A whole number. |
| - | |G|Weight|Numeric| | |Expressed in pounds.| | + | |G|Weight|Numeric| |A whole number.|Expressed in pounds.| |
| - | |H|Skinfold Tricep|Numeric| | | | | + | |H|Skinfold Tricep|Numeric| | A whole number.| | |
| - | |I|Skinfold Calf|Numeric| | | | | + | |I|Skinfold Calf|Numeric| |A whole number.| | |
| - | |J|1 Mile Run (Minutes)|Numeric| | | | | + | |J|1 Mile Run (Minutes)|Numeric| |A whole number.| | |
| - | |K|1 Mile Run (Seconds)|Numeric| |0-59| | | + | |K|1 Mile Run (Seconds)|Numeric| |A whole number, |
| - | |L|PACER Laps|Numeric| |0-300| | | + | |L|PACER Laps|Numeric| |A whole number, |
| - | |M|1 Mile Walk (Minutes)|Numeric| | | | | + | |M|1 Mile Walk (Minutes)|Numeric| |A whole number.| | |
| - | |N|1 Mile Walk (Seconds)|Numeric| | 0-59| | | + | |N|1 Mile Walk (Seconds)|Numeric| |A whole number, |
| - | |O|1 Mile Walk Heart Rate|Numeric| | | | | + | |O|1 Mile Walk Heart Rate|Numeric| |A whole number. |
| - | |P|Curl Up|Numeric| | 0-75| | | + | |P|Curl Up|Numeric| |A whole number, |
| - | |Q|Trunk Lift|Numeric| |0-12|Expressed in inches.| | + | |Q|Trunk Lift|Numeric| |A whole number, |
| - | |R|Push Up|Numeric| |0-99 | | | + | |R|Push Up|Numeric| |A whole number, |
| - | |S|Modified Pull Up|Numeric| | 0-999| | | + | |S|Modified Pull Up|Numeric| |A whole number, |
| - | |T|Flexed Arm Hang|Numeric| | 0-999|Expressed in seconds| | + | |T|Flexed Arm Hang|Numeric| |A whole number, |
| - | |U|Back Saver Sit & Reach-Left|Numeric| | 0-12|Expressed in inches.| | + | |U|Back Saver Sit & Reach-Left|Numeric| | A whole number, |
| - | |V|Back Saver Sit & Reach-Right|Numeric| |0-12|Expressed in inches.| | + | |V|Back Saver Sit & Reach-Right|Numeric| |A whole number, |
| |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| | ||
| Line 42: | Line 42: | ||
| * Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use ASCENDER Business, columns for staff information are blank. | * 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 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 enter blank spaces in fields that will be empty. | ||
| * Do not insert blank rows into the file. | * Do not insert blank rows into the file. | ||