Interfaces

User Tools

Site Tools

Trace: • Cafeteria Import • Charter School Waitlist Import • PFAI Export
student:pfai_export

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:pfai_export [2022/03/25 14:50] – apapestudent:pfai_export [2023/07/31 15:07] (current) – lrosdahl
Line 1: Line 1:
 ======PFAI Export====== ======PFAI Export======
  
-The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).\\  \\   +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., FG_Extract_2019.csv). Save the exported document as a .csv file.+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^ ^ ^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. |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/01/2021//|+|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)| |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| | +|E|StudentGender*|Alphanumeric|1|m, f, M, F|Not case-sensitive.| 
-|F|Height|Numeric| | |Expressed in inches.| +|F|Height|Numeric| |A whole number. |Expressed in inches.| 
-|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, 0-59.| | 
-|L|PACER Laps|Numeric| |0-300| | +|L|PACER Laps|Numeric| |A whole number, 0-300.| | 
-|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, 0-59.| | 
-|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, 0-75.| | 
-|Q|Trunk Lift|Numeric| |0-12|Expressed in inches.| +|Q|Trunk Lift|Numeric| |A whole number, 0-12.|Expressed in inches.| 
-|R|Push Up|Numeric| |0-99 | | +|R|Push Up|Numeric| |A whole number, 0-99. | | 
-|S|Modified Pull Up|Numeric| | 0-999| | +|S|Modified Pull Up|Numeric| |A whole number, 0-999.| | 
-|T|Flexed Arm Hang|Numeric| | 0-999|Expressed in seconds| +|T|Flexed Arm Hang|Numeric| |A whole number, 0-999.|Expressed in seconds.| 
-|U|Back Saver Sit & Reach-Left|Numeric| | 0-12|Expressed in inches.| +|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| |0-12|Expressed in inches.|+|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| |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.
student/pfai_export.1648219837.txt.gz · Last modified: 2022/03/25 09:50 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.