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 [2018/10/09 20:27] – jstanford | student:fitnessgram_export [2022/03/03 21:47] – apape | ||
---|---|---|---|
Line 1: | Line 1: | ||
======FitnessGram Export====== | ======FitnessGram Export====== | ||
+ | |||
+ | **NOTE: In a future release, menu item // | ||
+ | Currently, this is not a FitnessGram Export, this is a 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 (6-digit County District Number |
- | |B|StudentID | + | |B|School Name*|Alphanumeric|75| |Name of school.| |
- | |C|StudentFirstName | + | |C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ //Example: 3/1/2021 or 03/01/2021//| |
- | |D|StudentLastName *|Alphanumeric|100| | | | + | |D|StudentGrade*|Alphanumeric|10|3-12|Single, alphanumeric characters for grade levels |
- | |E|StudentMiddleInitial|Alphanumeric|1| | | | + | |E|StudentGender*|Alphanumeric|1|m, |
- | |F|StudentNickName|Alphanumeric|9| |Student’s **Nickname** from Registration.| | + | |F|Height|Numeric| | |Expressed in inches.| |
- | |G|StudentBirthdate *|Date| |MM/DD/YYYY| | | + | |G|Weight|Numeric| | |Expressed |
- | |H|StudentGrade *|Alphanumeric| |K-12|Single, alphanumeric characters for grade levels | + | |H|Skinfold Tricep|Numeric| | | | |
- | |I|StudentGender *|Alphanumeric|1|m, | + | |I|Skinfold Calf|Numeric| | | | |
- | |J|StudentEthnicityCode| | | |Blank| | + | |J|1 Mile Run (Minutes)|Numeric| | | | |
- | |K|StudentUserName *|Alphanumeric|50| |Same Student ID as in second column| | + | |K|1 Mile Run (Seconds)|Numeric| |0-59| | |
- | |L|Student Password*|Alphanumeric|50| |Created using student’s name and date of birth (FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203)). If no middle name, the initial is omitted from the password.| | + | |L|PACER Laps|Numeric| |0-300| | |
- | |M|StudentReportEmail|Alphanumeric|254| |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| | | | | | + | |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|100| |The **E-mail** of the student’s priority 1 contact from Registration. If email address is not included, thosee student and parent reports cannot be sent.| | + | |P|Curl Up|Numeric| | 0-75| | |
- | |Q|ParentReportEmail2|Alphanumeric|100| |Blank| | + | |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, | + | |R|Push Up|Numeric| |0-99 | | |
- | |S|StudentPermanentExemptionCode|Alphanumeric|50| |Blank| | + | |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|50| |DistrictID + CampusID + CourseTitle + CourseNumber + SectionNumber + BeginPeriod + InstructorID| | + | |U|Back Saver Sit & Reach-Left|Numeric| | 0-12|Expressed in inches.| |
- | |V|ClassID *|Alphanumeric|50| |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|300| |Course title.| | + | |W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes| |
- | |X|ClassStartDate *|Date| |MM/DD/YYYY|Start date for the course.| | + | |X|Shoulder Stretch-Right|Numeric| |1 or 2 |1 = No; 2 = Yes| |
- | |Y|ClassEndDate *|Date| |MM/DD/YYYY|The last day of the semester.| | + | |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|100| | | | + | |AA|IsAsian|Alphanumeric| |
- | |AB|TeacherLastName *|Alphanumeric|100| | | | + | |AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected| |
- | |AC|TeacherMiddleInitial|Alphanumeric|1| | + | |AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected| |
- | |AD|TeacherNickName|Alphanumeric|100| | | | + | |AD|IsWhite|Alphanumeric| |
- | |AE|TeacherUserName*|Alphanumeric|254| |Instructor’s email address. For security purposes this is the official school email address.| | + | |
- | |AF|TeacherPassword *|Alphanumeric|50| |Created by combining instructor’s date of birth and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB))| | + | |
- | |AG|TeacherEmail *|Alphanumeric|254| |Instructor’s work email address| | + | |
- | |AH|TeacherIsActive|Alphanumeric|1|Y, N|Default is Y. You can change it within the application | + | |
- | |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 |
* 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. |