Fitnessgram

Contents

Introduction

Use the Fitnessgram report to extract the data to upload to the Fitnessgram 10 Program. The 83^rd Texas Legislature provided funding for all districts to use this third party software to reporting their physical fitness results to the state. Vendors were requested to create an extract that will upload student information from the student information system to Fitnessgram 10. This is PowerSchool report TX46.

Selection Criteria

Selection criteria determine which database records are used in the report. For Fitnessgram, student enrollment records are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

Student Selection

The report selects which student records to use based on the following criteria:

The student must be active.
The student must be actively enrolled in a section(s) for the year/term selected where the course AAR Subject Category = PE, or must be enrolled in a course or sectionwhich is flagged as "Include in Fitness Assessment". The student will have multiple records if they are enrolled in multiple PE classes.
The student must not be enrolled at a campus that is Excluded from State Reporting.

Report Input

Each of the available run options and data fields for the report are described below.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Students	Select All Students to run the extract for all active students enrolled in a PE class. Select the xx Students Only if the students have been selected prior to running the extract and you want to run the extract only for those students.
School Year	Choose the school year for the student enrollment data you want to include on the report. This value is used to determine certain naming conventions within the extract.
School Term	Select the terms to use in selecting PE classes. All Terms – the extract includes all students actively enrolled in any PE section for the school year selected. First Semester – the extract includes all students actively enrolled in any PE section that has duration of all year or first semester. (TermID ends in 00 or 01) Second Semester – the extract includes all students actively enrolled in any PE section that has duration of all year or second semester. (TermID ends in 00 or 02) Note: If the PE sections have duration of quarters and/or six-weeks, you will need to use the All Terms option.
Grades	Select all of the grade levels to include in the extract. The default is all grades selected.
Exclude Records Missing Required Fields	Choose Yes or No to indicate whether to exclude records from the output if one or more of the required fields (Student Unique ID, Teacher Unique ID, and Teacher Email) is NULL. The default value is No.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output: Fitnessgram Report

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

If there are no records for the selected group, the output will include a message "None of the selected students are enrolled in a PE section for the term or grade selected".

Filename:

The file must be a comma delimited (.csv) file with a filename in the following format: FG 1- Extract yyyy.csv where yyyy is the spring part of the school year (i.e. 2018 for 2017-2018).

All fields that are noted must be included (some as blank) and are separated by a comma.

Item #	Data Element	Description	[Table]FieldName
1	SchoolID	The county district number – County District Campus Number. Logic based on the TEDS School Name field is added for districts with non-standard School Number setups as already implemented in the EdOrg Interchange.	[Schools]Alternate_School_Number [Schools]School_Number
2	StudentID	The Texas unique student ID.	[Students]State_StudentNumber
3	StudentFirstName	The student's first name. The obsolete Texas Name Override fields are replaced by the core Legal Name fields.	[S_TX_STU_X]E0703 [Students]First_Name
4	StudentLastName	The student's last name.	[S_TX_STU_X]E0705 [Students]Last_Name
5	StudentMiddleInitial	The student's middle initial.	[S_TX_STU_X]E0704 [Students]Middle_Name
6	StudentNickName	This field is output as Student First Name or Users First Name.	N/A
7	StudentBirthdate	The student's date of birth.	[Students]DOB
8	StudentGrade	The student's current grade level.	[S_TX_STU_X]State_Grade_Level [Students]Grade_Level
9	StudentGender	The student's gender.	[Students]Gender
10	StudentEthnicityCode	Always output as blank.	N/A
11	StudentUsername	The local Student Number.	[Students]State_StudentNumber
12	StudentPassword	The student' password. If the password is not available, the recommended password format is: First Name + Middle Initial + Last Name + DOB in MDDYY format + !	[Students]Student_Web_Password
13	StudentReportEmail	The student's email, if populated; otherwise, blank.	[PSM_StudentContact]Email
14	SSO ID	Always output as blank.	N/A
15	StudentPrintBodyComp	Hard coded to Y.	Always Y.
16	ParentReportEmail1	The parent or guardian's email address. If multiple emails are entered separated by a comma, this field will extract the first email. Parent Report Email and Email 2 : Updated to source from Student Contacts using the following hierarchy. Custody Flag Lives with Flag Legal Guardian relationship Mother relationship Father relationship If none of the above, the top two contacts in priority order	[Students]GuardianEmail
17	ParentReportEmail2	The parent or guardian's email address. If multiple emails are entered separated by a comma, this field will extract the second email. If there is only one, this field is blank.	[Students]GuardianEmail
18	StudentPrintReportinSpanish	Leave blank.	N/A
19	StudentPermanentExemptionCode	Leave blank.	N/A
20	StudentIsActive	Hard coded to Y.	Always Y.
21	ClassName	The class name. Format: Course Name, Sec #, Exp #, Term and Year such as PE 5_Sec 2_Exp 4A_YR_24	[Courses]Course_Name [Sections]Course_Number [Terms]ID
22	ClassID	The class ID. Format: County District Campus Number + Service ID + Unique Class ID + Term ID + YY where YY is the spring part of the year (i.e. 18 for 2018-2019). Note: Updated to use the Ed-Fi Section Identifier (E1056 - Calculated) from sections, or the override (if populated).	[Schools]Alternate_School_Number [Schools]School_Number [CoursesCoreFields]Alt_Course_Number [S_TX_SEC_X]E1056_ClassID_Override [Terms]ID
23	ClassDescription	Leave blank.	N/A
24	ClassStartDate	The first date that the section meets.	Derived from [Sections]TermID
25	ClassEndDate	The last date that the section meets.	Derived from [Sections]TermID
26	TeacherID	The Texas unique staff ID.	[Users]SIF_StatePrid
27	TeacherFirstName	The first name of the teacher on the section. The obsolete Texas Name Override fields are replaced by the core Legal Name fields.	[Users]First_Name
28	TeacherLastName	The last name of the teacher on the section.	[Users]Last_Name
29	TeacherMiddleInitial	The middle initial of the teacher on the section. Leave blank if blank.	[Users]Middle_Name
30	TeacherNickName	This field is output as Student First Name or Users First Name.	N/A
31	TeacherUserName	The teacher's user name.	[Users]Email_Address
32	TeacherPassword	The teacher's password, output as First Name + Middle Initial + Last Name + DOB in MDDYY format + !	Derived from: [Users]First_Name [Users]Last_Name [Userscorefields]DOB
33	TeacherEmail	The teacher's school email address.	[Users]Email_Address
34	TeacherIsActive	Hard coded to Y.	Always Y
35	TeacherSSOID	Always reported as blank.	N/A