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	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:

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.

Interfaces

FitnessGram Export

Americans with Disabilities Act (ADA) and Web Accessibility

Interfaces

User Tools

Site Tools

FitnessGram Export

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility