student:fitnessgram_export
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
FitnessGram Export
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.
| Column | Type | Max Length | Valid Values | Description | |
|---|---|---|---|---|---|
| A | SchoolID * | Alphanumeric | 50 | CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001) | |
| B | StudentID * | Alphanumeric | 50 | Must be unique in the district. Ensure student IDs remain consistent year to tear to avoid duplication. | |
| C | StudentFirstName * | Alphanumeric | 35 | ||
| D | StudentLastName * | Alphanumeric | 35 | ||
| E | StudentMiddleInitial | Alphanumeric | 35 | ||
| F | StudentNickName | Alphanumeric | 35 | Student’s Nickname from Registration. | |
| G | StudentBirthdate * | Date | 10 | MM/DD/YYYY | Include forward slash marks. |
| 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. |
| I | StudentGender * | Alphanumeric | 1 | m, f, M, F | |
| J | StudentEthnicityCode | Numeric | 100 | Must correspond to an EthnicityID in FitnessGram (three-digit federal code). | |
| K | StudentUserName * | Alphanumeric | 60 | Must be unique in district. StudentID is often used. | |
| L | Student Password* | Alphanumeric | 100 | If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203). | |
| 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. | |
| N | Student SSO ID | Alphanumeric | 35 | Only used for districts using single sign on. | |
| O | StudentPrintBodyComp | Alphanumeric | 1 | y, n, Y, N | |
| 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. | |
| Q | ParentReportEmail2 | Alphanumeric | 128 | ||
| 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. |
| S | StudentPermanentExemptionCode | Alphanumeric | 1 | Must correspond to an ExemptionID in FitnessGram. | |
| T | StudentIsActive | Alphanumeric | 1 | Y, N | Default is Y. You can change it within the application or file. |
| 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) | |
| 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). | |
| W | ClassDescription | Alphanumeric | 255 | ||
| X | ClassStartDate * | Date | 10 | MM/DD/YYYY | Start date for the course. Include forward slash marks. |
| Y | ClassEndDate * | Date | 10 | MM/DD/YYYY | The last day of the semester. Include forward slash marks. |
| Z | TeacherID * | Alphanumeric | 50 | Unique number assigned to instructor by TEA (TX Unique Staff ID). | |
| AA | TeacherFirstName * | Alphanumeric | 35 | ||
| AB | TeacherLastName * | Alphanumeric | 35 | ||
| AC | TeacherMiddleInitial | Alphanumeric | 35 | ||
| AD | TeacherNickName | Alphanumeric | 35 | ||
| 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
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 enter blank spaces in fields that will be empty.
- Do not insert blank rows into the file.
student/fitnessgram_export.1623697155.txt.gz · Last modified: 2021/06/14 13:59 (external edit)