Classic View: TX State Reporting > Fitnessgram Extract
Search Terms: Fitnessgram
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.
Example 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 | System Admin > Resources > District Information > State District Number AND Sys Admin > Resources > School > State School Number Database: 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 Database: Student.stateID |
StudentFirstName Required | The student's first name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > First Name Database: Identity.firstName |
StudentLastName Required | The student's last name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Last Name Database: Identity.lastName |
StudentMiddleInitial Optional | The student's middle initial. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Middle Name Database: Identity.middleName |
StudentNickName Optional | The student's nickname. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Nickname Database: Identity.alias |
StudentBirthdate Required | The student's birth date. Date field, 10 characters MM/DD/YYYY | Census > People > Demographics > Person Information > Birth Date Database: Identity.birthDate |
StudentGrade Required | The grade in which the student is enrolled. Alphanumeric, 2 characters | Student Information > General > Enrollments Tab > General Enrollment Information > Grade Database: Enrollment.grade |
StudentGender Required | The student's gender. Reports M or F. Alphanumeric, 1 character | Census > People > Identifies > Identity Information > Gender Database: 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 Database: 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, 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 Database: Not dynamically stored |
StudentReportEmail Optional | The student's email address. Alphanumeric, 254 characters | Census > People > Demographics > Personal Contact Information Database: Contact.email |
ParentReportEmail1 Optional | The parent or guardian's email address. Alphanumeric, 100 characters | Census > People > Demographics > Household > Members > Email Database: Contact.email OR Contact.secondaryEmail |
ParentReportEmail2 Optional | The parent or guardian's second email address. Alphanumeric, 100 characters | Census > People > Demographics > Household > Members > Email Database: 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 Database: Address.city |
StudentState Required | The state from the student's primary address.. Alphanumeric, 100 characters | Census > People > Demographics > Personal Contact Information Database: Address.state |
StudentZip Required | The zip code from the student's primary address. Alphanumeric, 20 characters | Census > People > Demographics > Personal Contact Information Database: 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 Database: Term.startDate |
ClassEndDate Required | The Course Section end date. Date field, 10 characters MM/DD/YYYY | System Administration > Calendar > Calendar > Terms > Term Detail > End Database: 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 Database: Individual.staffStateID |
TeacherFirstName Required | The teacher's first name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > First Name Database: Identity.firstName |
TeacherLastName Required | The teacher's last name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Last Name Database: Identity.lastName |
TeacherMiddleInitial Optional | The middle initial of the teacher's middle name. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Middle Name Database: Identity.middleName |
TeacherNickName Optional | The teacher's nickname. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Nickname Database: Identity.alias |
TeacherUserName Required | The official school email address for the teacher. Alphanumeric, 254 characters | Census > People > Demographics > Personal Contact Information > Email Database: 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 Database: Contact.email |
| TeacherAddress1 | This field reports blank. | N/A |
| TeacherAddress2 | This field reports blank. | N/A |
| TeacherAddress3 | This field reports blank. | N/A |
TeacherCity Optional | The city from the school address. Alphanumeric, 100 characters | System Administration > Resources > School City Database: School.city |
TeacherState Optional | The state from the school address. Alphanumeric, 100 characters | System Administration > Resources > School State Database: School.state |
TeacherZip Optional | The zip code from the school address. Alphanumeric, 20 characters | System Administration > Resources > School Zip Database: 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 |
