Tool Search: Fitnessgram Extract
The Fitnessgram Extract reports fitness data for students in grades 3-12 that have an active enrollment on the extract date and were enrolled in the course(s) selected in the extract editor at any time during the reporting period.
Fitnessgram Extract Editor
Report Logic
- Fitnessgram Extract reports all students in grades 3-12 that have an active enrollment on the extract date and were enrolled in the course(s) selected in the extract editor at any time during the reporting period.
- If a student was enrolled in multiple applicable courses during the reporting period, one record reports for each course in which they were actively enrolled. For example, if a student was enrolled in a PE course in the fall and another in the spring and the report is for the entire year, the student will have two records--one for each course. Also, if the student dropped a three term course in term 1, only one record reports.
- Non-instructional courses are NOT excluded.
- Courses with the State Report Exclude option selected on the Courses tab (Scheduling > Courses > Course) do NOT report.
The following types of students Do Not report:
- Students marked as Exempt (Student Information > Enrollment > Physical Fitness Exempt).
- Students marked as State Exclude or are in a grade/school/calendar marked as Exclude.
- Students who do not have a state ID.
Report Editor
The following defines the options available on the Fitnessgram Extract editor.
Field | Description |
|---|---|
| Effective Date | The Effective Date determines which students report. All students in grades 3-12 that have an active enrollment on the date selected in this field and are enrolled in the course(s) selected in the State Code field report. |
| Filter By | This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools. |
| Ad Hoc Filter | Select an Ad Hoc filter to limit report results to those that meet filter requirements. |
Format | Selection determines how the report generates. Options are CSV or HTML. Use the HTML format for data review prior to sending to the state. |
| State Code | This field allows you to choose which courses to report. Options include the following:
|
Select Calendars | Selection indicates from which school year and school teacher data is pulled. Multiple calendars may be selected. The calendar chosen in the Campus toolbar is automatically selected in the extract editor. |
Report Generation | The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance. |
Report Layout
| Element | Description | Location |
SchoolID *Required | The District ID in front of the Campus State School Number and separated by a dash. For example 101912-101912001. Alphanumeric, 50 characters | School & District Settings > District > District Information > State District Number AND School & District Settings > Schools > School Information > State School Number Not dynamically stored |
StudentID *Required | The student's unique state ID assigned by the Texas Education Agency. Alphanumeric, 30 characters | Census > People > Demographics > Student Unique State ID Student.stateID |
StudentFirstName *Required | The student's first name.
| Census > People > Demographics Identity.firstName |
StudentLastName *Required | The student's last name.
| Census > People > Demographics Identity.lastName |
StudentMiddleInitial | The student's middle initial.
| Census > People > Demographics Identity.middleName |
StudentNickName | The student's nickname. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Nickname Identity.alias |
StudentBirthdate *Required | The student's birth date. Date field, 10 characters MM/DD/YYYY | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
StudentGrade *Required | The grade in which the student is enrolled. Alphanumeric, 2 characters | Student Information > General > Enrollments Tab > General Enrollment Information > Grade Enrollment.grade |
StudentGender *Required | The student's gender. Reports M or F.
| Census > People > Demographics Identity.gender |
| StudentEthnicityCode | This field reports blank. | N/A |
StudentUsername *Required | The student's unique state ID assigned by the Texas Education Agency. Alphanumeric, 30 characters | Census > People > Demographics > Student Unique State ID Student.stateID |
StudentPassword *Required | Reports the first letter of the student's first name, the first letter of the student's middle name, the first letter of the student's last name, and then the student's birthdate (mmddyy) with no spaces in between. For example, ABC010203. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > First Name; Middle Name; Last Name; Birth Date Not dynamically stored |
StudentReportEmail | The student's email address. Alphanumeric, 254 characters | Census > People > Demographics > Personal Contact Information Contact.email |
ParentReportEmail1 | The parent or guardian's email address. Alphanumeric, 100 characters | Census > People > Demographics > Household > Members > Email Contact.email OR Contact.secondaryEmail |
ParentReportEmail2 | The parent or guardian's second email address. Alphanumeric, 100 characters | Census > People > Demographics > Household > Members > Email Contact.email OR Contact.secondaryEmail |
| StudentAddress1 | This field reports blank. | N/A |
| StudentAddress2 | This field reports blank. | N/A |
| StudentAddress3 | This field reports blank. | N/A |
StudentCity *Required | The city from the student's primary address. Alphanumeric, 100 characters | Census > People > Demographics > Personal Contact Information Address.city |
StudentState *Required | The state from the student's primary address.. Alphanumeric, 100 characters | Census > People > Demographics > Personal Contact Information Address.state |
StudentZip *Required | The zip code from the student's primary address. Alphanumeric, 20 characters | Census > People > Demographics > Personal Contact Information Address.zip |
StudentPrintBodyComp *Required | This field always reports Y but can be manually updated. Alphanumeric, 1 character | Not dynamically stored |
| StudentPrint ReportInSpanish | By default, the report is printed in English. If the student needs their report in Spanish, you may manually change the N to a Y. Alphanumeric, 1 character | Not dynamically stored |
| StudentPermanent ExemptionCode | This field reports blank. | N/A |
StudentIsActive *Required | Indicates whether the student has an active enrollment as of the date of the extract. This field always reports Y. Alphanumeric,1 character | Not dynamically stored |
ClassName *Required | The name of the class: CourseName + SectionID + End Term Identifier. Alphanumeric, 50 characters | Scheduling > Courses > Course > Course Editor > Name Scheduling > Courses > Section > SectionID Course.name CourseSection.sectionNumber |
ClassID *Required | A unique ID for the class: Campus ID + Service ID from the course + Course ID + Section Number + End Term Number + 2-digit End Year Alphanumeric, 50 characters | Not dynamically stored |
| ClassDescription | This field reports blank. | N/A |
ClassStartDate *Required | The Course Section begin date. Date field, 10 characters MM/DD/YYYY | System Administration > Calendar > Calendar > Terms > Term Detail > Start Date Term.startDate |
ClassEndDate *Required | The Course Section end date. Date field, 10 characters MM/DD/YYYY | System Administration > Calendar > Calendar > Terms > Term Detail > End Term.endDate |
TeacherID *Required | The unique number assigned to a teacher by the Texas Education Agency. Alphanumeric, 50 characters | Census > People > Demographics > Staff Unique State ID Individual.staffStateID |
TeacherFirstName *Required | The teacher's first name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > First Name Identity.firstName |
TeacherLastName *Required | The teacher's last name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
TeacherMiddleInitial | The middle initial of the teacher's middle name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName |
TeacherNickName | The teacher's nickname. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Nickname Identity.alias |
TeacherUserName *Required | The official school email address for the teacher. Alphanumeric, 254 characters | Census > People > Demographics > Personal Contact Information > Email Contact.email |
TeacherPassword *Required | The teacher's birthdate (month and year only) + the first letter of the first name + the first letter of the last name. Alphanumeric, 50 characters | Not dynamically stored |
TeacherEmail *Required | The teacher's official school email address. Alphanumeric, 254 characters | Census > People > Demographics > Personal Contact Information Contact.email |
| TeacherAddress1 | This field reports blank. | N/A |
| TeacherAddress2 | This field reports blank. | N/A |
| TeacherAddress3 | This field reports blank. | N/A |
TeacherCity | The city from the school address. Alphanumeric, 100 characters | System Administration > Resources > School City School.city |
TeacherState | The state from the school address. Alphanumeric, 100 characters | System Administration > Resources > School State School.state |
TeacherZip | The zip code from the school address. Alphanumeric, 20 characters | System Administration > Resources > School Zip School.zip |
TeacherIsActive *Required | Indicates whether the teacher has an active district employment as of the date selected on the extract editor. This field reports Y or N. Alphanumeric,1 character | Not dynamically stored |
