This is an old revision of the document!
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: