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_2018_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_2018.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 | 30 | Student’s Texas Unique Student ID from Registration. | |
| C | StudentFirstName * | Alphanumeric | 100 | ||
| D | StudentLastName * | Alphanumeric | 100 | ||
| E | StudentMiddleInitial | Alphanumeric | 1 | ||
| F | StudentNickName | Alphanumeric | 9 | Student’s Nickname from Registration. | |
| G | StudentBirthdate * | Date | MM/DD/YYYY | ||
| H | StudentGrade * | Alphanumeric | K-12 | Single, alphanumeric characters for grade levels K-9, or two digits for grade levels 10-12 | |
| I | StudentGender * | Alphanumeric | 1 | m, f, M, F | |
| J | StudentEthnicityCode | Blank | |||
| K | StudentUserName * | Alphanumeric | 50 | Same Student ID as in second column | |
| 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. | |
| 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. | |
| N | Student SSO ID | ||||
| O | StudentPrintBodyComp | Alphanumeric | 1 | y, n, Y, N | |
| 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. | |
| Q | ParentReportEmail2 | Alphanumeric | 100 | Blank | |
| 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 | 50 | Blank | |
| T | StudentIsActive | Alphanumeric | 1 | Y, N | Default is Y. You can change it within the application or file. |
| U | ClassName * | Alphanumeric | 50 | DistrictID + CampusID + CourseTitle + CourseNumber + SectionNumber + BeginPeriod + InstructorID | |
| V | ClassID * | Alphanumeric | 50 | DistrictID + CampusID + ServiceID + CourseNumber + SectionNumber + BeginPeriod + CourseSemester + YY (last two digits of the school year) | |
| W | ClassDescription | Alphanumeric | 300 | Course title. | |
| X | ClassStartDate * | Date | MM/DD/YYYY | Start date for the course. | |
| Y | ClassEndDate * | Date | MM/DD/YYYY | The last day of the semester. | |
| Z | TeacherID * | Alphanumeric | 50 | Unique number assigned to instructor by TEA (TX Unique Staff ID). | |
| AA | TeacherFirstName* | Alphanumeric | 100 | ||
| AB | TeacherLastName* | Alphanumeric | 100 | ||
| AC | TeacherMiddleInitial | Alphanumeric | 1 | ||
| AD | TeacherNickName | Alphanumeric | 100 | ||
| Instructor User Name* | Alphanumeric | 254 | Instructor’s email address. For security purposes this is the official school email address. | ||
| Instructor Password* | Alphanumeric | 50 | Created by combining instructor’s date of birth and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB)) | ||
| Instructor Email* | Alphanumeric | 254 | Instructor’s work email address | ||
| Instructor Address 1 | Alphanumeric | 300 | Blank | ||
| Instructor Address 2 | Alphanumeric | 300 | Blank | ||
| Instructor Address 3 | Alphanumeric | 300 | Blank | ||
| Instructor City | Alphanumeric | 100 | Blank | ||
| Instructor State | Alphanumeric | 100 | Blank | ||
| Instructor Zip | Alphanumeric | 20 | Blank | ||
| Instructor is Active? | Alphanumeric | 1 | Y, N | Default is Y. You can change it within the application or file. |
*Required
Notes:
- Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use TxEIS 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.1539116395.txt.gz · Last modified: 2018/10/09 15:19 (external edit)