This is an old revision of the document!
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 | ||
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 or file. |
AI | Teacher SSO ID | Alphanumeric | 35 | Only used for districts using single sign on |
*Required
Notes: