Interfaces

User Tools

Site Tools

Trace:
student:fitnessgram_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
Next revisionBoth sides next revision
student:fitnessgram_export [2018/10/09 20:48] – jstanfordstudent:fitnessgram_export [2022/03/03 22:05] – apape
Line 1: Line 1:
 ======FitnessGram Export====== ======FitnessGram Export======
 +
 +<WRAP round intro> **NOTE**: In a future release, //Registration > FitnessGram Export// will be renamed //Registration > PFAI Export//.\\
 +
 +Please be aware that this utility exports information as a PFAI Export, not as a FitnessGram Export.</WRAP>
 +
  
 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 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.+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.
 \\   \\  
 ^ ^Column^Type^Max Length^Valid Values^Description^ ^ ^Column^Type^Max Length^Valid Values^Description^
-|A|SchoolID *|Alphanumeric|50| |CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001)| +|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//)| 
-|B|StudentID *|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|StudentFirstName *|Alphanumeric|35| | | +|C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ //Example: 3/1/2021 or 03/01/2021//| 
-|D|StudentLastName *|Alphanumeric|35| | | +|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|StudentMiddleInitial|Alphanumeric|35| | | +|E|StudentGender*|Alphanumeric|1|m, f, M, F| | 
-|F|StudentNickName|Alphanumeric|35| |Student’s **Nickname** from Registration.| +|F|Height|Numeric| | |Expressed in inches.| 
-|G|StudentBirthdate *|Date|10|MM/DD/YYYY|Include forward slash marks.| +|G|Weight|Numeric| | |Expressed in pounds.| 
-|H|StudentGrade *|Alphanumeric|10|K-13|Single, alphanumeric characters for grade levels K-9, or two digits for grade levels 10-12. Any PK or early development grades must be reported as K only. Adult or post-high school levels must be reported as 13.| +|H|Skinfold Tricep|Numeric| | | | 
-|I|StudentGender *|Alphanumeric|1|m, f, M, F| | +|I|Skinfold Calf|Numeric| | | | 
-|J|StudentEthnicityCode|Numeric|100| |Must correspond to an EthnicityID in FitnessGram (three-digit federal code).| +|J|1 Mile Run (Minutes)|Numeric| | | | 
-|K|StudentUserName *|Alphanumeric|60| |Must be unique in district. StudentID is often used.| +|K|1 Mile Run (Seconds)|Numeric| |0-59| | 
-|L|Student Password*|Alphanumeric|100| |If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203).| +|L|PACER Laps|Numeric| |0-300| | 
-|M|StudentReportEmail|Alphanumeric|128| |The student’s **E-mail** from Registration. If email address is not included, those student and parent reports cannot be sent.| +|M|1 Mile Walk (Minutes)|Numeric| | | | 
-|N|Student SSO ID|Alphanumeric|35| |Only used for districts using single sign on.| +|N|1 Mile Walk (Seconds)|Numeric| | 0-59| | 
-|O|StudentPrintBodyComp|Alphanumeric|1|y, n, Y, N| | +|O|1 Mile Walk Heart Rate|Numeric| | | | 
-|P|ParentReportEmail1|Alphanumeric|128| |The **E-mail** of the student’s priority 1 contact from Registration. If email address is not included, those student and parent reports cannot be sent.| +|P|Curl Up|Numeric| | 0-75| | 
-|Q|ParentReportEmail2|Alphanumeric|128| | | +|Q|Trunk Lift|Numeric| |0-12|Expressed in inches.| 
-|R|StudentPrintReportInSpanish|Alphanumeric|1|y, n, Y, N|If student’s priority 1 contact has //Spanish// selected for **Language** in Registration, this column is Y.| +|R|Push Up|Numeric| |0-99 | | 
-|S|StudentPermanentExemptionCode|Alphanumeric|1| |Must correspond to an ExemptionID in FitnessGram.| +|S|Modified Pull Up|Numeric| | 0-999| | 
-|T|StudentIsActive|Alphanumeric|1|Y, N|Default is Y. You can change it within the application or file.| +|T|Flexed Arm Hang|Numeric| | 0-999|Expressed in seconds| 
-|U|ClassName *|Alphanumeric|100| |Add physical education classes. Must be unique by teacher and easily identified by teachers (e.g., CourseTitle + SectionNumber + SemesterIdentifier + YY (last two digits of the school year)| +|U|Back Saver Sit & Reach-Left|Numeric| | 0-12|Expressed in inches.| 
-|V|ClassID *|Alphanumeric|100| |Must be unique in district (e.g., DistrictID + CampusID + ServiceID + CourseNumber + SectionNumber + BeginPeriod + CourseSemester + YY (last two digits of the school year).| +|V|Back Saver Sit & Reach-Right|Numeric| |0-12|Expressed in inches.| 
-|W|ClassDescription|Alphanumeric|255| | | +|W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes| 
-|X|ClassStartDate *|Date|10|MM/DD/YYYY|Start date for the course. Include forward slash marks.| +|X|Shoulder Stretch-Right|Numeric| |1 or 2 |1 = No; 2 = Yes| 
-|Y|ClassEndDate *|Date|10|MM/DD/YYYY|The last day of the semester. Include forward slash marks.| +|Y|IsHispanicLatino|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected| 
-|Z|TeacherID *|Alphanumeric|50| |Unique number assigned to instructor by TEA (TX Unique Staff ID).| +|Z|IsAmericanIndianAlaskaNative|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected| 
-|AA|TeacherFirstName *|Alphanumeric|35| | | +|AA|IsAsian|Alphanumeric|  | 1, 0, or blank| 1 = Yes; 0 or blank = Not Selected| 
-|AB|TeacherLastName *|Alphanumeric|35| | | +|AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected| 
-|AC|TeacherMiddleInitial|Alphanumeric|35| | | +|AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected| 
-|AD|TeacherNickName|Alphanumeric|35| | | +|AD|IsWhite|Alphanumeric|  |1, 0, or blank|1 = Yes; 0 or blank = Not Selected| 
-|AE|TeacherUserName*|Alphanumeric|60| |Must be unique in district. Teacher’s email address is recommended. For security purposes this is the official school email address.| +
-|AF|TeacherPassword *|Alphanumeric|100| |If password is not available, recommend combining instructor’s birthdate and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB))| +
-|AG|TeacherEmail *|Alphanumeric|128| |Instructor’s work email address.| +
-|AH|TeacherIsActive|Alphanumeric|1|Y, N|Default is Y. You can change it within the application or file.| +
-|AI|Teacher SSO ID|Alphanumeric|35| |Only used for districts using single sign on.|+
  
 *Required *Required
  
 Notes: Notes:
-  * Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use TxEIS 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 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/fitnessgram_export.txt · Last modified: 2022/07/26 13:02 by apape

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.