FGRAM Fitness Extract (FitnessGram)

Introduction

The Fitnessgram 10 extract report generates records that include student, teacher, and class information. The output is submitted to Human Kinetics, the student fitness assessment vendor for GA DOE.

The report output has a header record with each data element's FGRAM name.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects records from the [Students] table that meet the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a fitness course (course number starting with 36) between the selected start date and end date.
The reported fitness course must not be taught by a teacher with the generic id '555555555'

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Current Selection Students	Run the report for the current selection of students or all students.
Report Start Date	The start date for the report. Defaults to the first day of the selected term. Note: Format is MM/DD/YYYY
Report End Date	The end date for the report. Defaults to the last day of the selected term. Note: Format is MM/DD/YYYY For PowerSchool to save the results to a location on the server, the File Path and File Suffix must both be valid.
Password	Choose one of the following: Auto Generate – The password for the students are generated automatically in the following format: UPPER 1 Character of First Name UPPER 1 Character of Middle Name if exists. LOWER 1 Character of Last Name FULL birthday in the format of MM/DD/YYYY If the student has a legal name, then the first character of the legal names will be used instead of the preferred name. If only one legal name is available, then the first character of the legal name along with the first characters of the first and middle names from the preferred name will be used. Blank - No password will be extracted in the report. Note: When submitting files without passwords, ensure that you have selected the "Do Not Update Username and Password on Import" option under the District & Schools settings available under the Settings icon on the FitnessGram website.

Back to Top

Report Output

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.

Item #	*Data Element (asterisk indicates a required field)**	Description	[Table]FieldName	Field Type	Field Length
Header		First record of the report output is a header record with FGRAM data element names.
1	SchoolID*	District number followed by a dash then school number. The school number is from the student’s current enrollment. If the alternate school number exists, it is used in place of the school number.	[Prefs]value [Prefs]name=districtnumber – [Students]SchoolID [ReEnrollments]SchoolID	A	Max 50
2	StudentID*	The student’s unique id number.	[Students]State_StudentNumber	A	Max 30
3	Student First Name*	The student’s first name. Note: The legal first name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name	A	Max 100
4	Student Last Name*	The student last name. Note: The legal last name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name	A	Max 100
5	Student Middle Initial	The Student’s middle name. Note: The legal middle name is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name	A	Max 100
6	Student Nick Name	The student’s first name. Note: The legal first name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name	A	Max 100
7	Student Birth Date*	The student’s date of birth, in the format MM/DD/YYYY.	[Students]DOB	Date	10
8	Student Grade*	The student’s grade level. Note: These are single digits for K, and 1-9.	[Students]Grade_Level [Reenrollments]Grade_Level	A	Max 2
9	Student Gender*	The student's gender. Note: The legal gender field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Gender [Students]Gender	A	1
10	Student Ethnicity Code	The student’s ethnicity ID. Note: Per Human Kinetics this field is always blank.	Blank	A	Max 50
11	Student User Name*	The student’s unique user name. Note: GTID is used.	[Students]State_StudentNumber	A	Max 50
12	Student Password*	When blank is chosen as the Password type, then this field will be blank. When Auto Generate is chosen, the password will have the following format: UPPER 1 Character of First Name UPPER 1 Character of Middle Name if exists. LOWER 1 Character of Last Name FULL birthday in the format of MM/DD/YYYY Note: The for the name, if ANY part of the legal name is populated, then only the legal name fields will be used. If only one part of the legal name is populated, this can result in missing characters. Note: When submitting files without passwords, ensure that you have selected the "Do Not Update Username and Password on Import" option under the District & Schools settings available under the Settings icon on the FitnessGram website.	[StudentCoreFields] PSCORE_LEGAL_FIRST_NAME or [Students] First_Name [StudentCoreFields] PSCORE_LEGAL_MIDDLE_NAME or [Students] Middle_Name [StudentCoreFields] PSCORE_LEGAL_LAST_NAME or [Students] Last_Name [Students]DOB	A	Max 50
13	Student Report Email	The email is retrieved from the Student Email field.	[PSM_StudentContact] Email	A	Max 254
14	Student SSO ID		Blank	A	Max 35
15	Student Print Body Comp	Whether to print the student’s body composition on letters (Y or N).	[S_GA_STU_X] FGRAM_ExePrintBodyComp [S_GA_REN_X] FGRAM_ExePrintBodyComp	A	1
16	Parent Report e-mail1	The Student’s parent’s e-mail address. Note: Where there are multiple e-mail addresses, only the first record will be extracted.	[Students] GuardianEmail [GuardianNotificationEmail] Notificationemail [GuardianNotificationEmail] Guardianstudentid = [GuardianStudent] GuardianStudentID [GuardianStudent] GuardianStudentID = [Students] DCID	A	Max 100
17	Parent Report e-mail2		Blank	A	Max 100
18	Student Print Report in Spanish	Whether to print the student’s letter in Spanish (Y or N).	[S_GA_STU_X] FGRAM_PrintRepInSpanish [S_GA_REN_X] FGRAM_PrintRepInSpanish	A	1
19	Student Permanent Exemption Code	The student’s FG9 Exemption ID. Note: No valid values are available at this time – blank is the only option.	[S_GA_STU_X] FGRAM_PermExeCd [S_GA_REN_X] FGRAM_PermExeCd	A	1
20	Student is Active	Only students active when the report is run are selected.	Y	A	1
21	Class Name*	A name for the class, unique across the school and year. Note: Multiple fields are concatenated to create a unique value.	Prefs[value] Prefs[name]=DistrictNumber [Schools] Alternate_School_Number [CC] SchoolID [Sections] Course_Number [Sections] Section_Number [Terms] Abbreviation [Courses] Course_Name	A	Max 50
22	ClassID*	A unique ID generated for each class. This value must be unique across the state and across multiple years. Note: Multiple fields are concatenated to create a unique value. ALT at the end of ClassID indicates student is taking the PE course at a remote school.	Prefs[value] Prefs[name]=districtNumber [Schools]Alternate_School_Number [CC]SchoolID [Sections]Course_Number [Sections]Section_Number [Terms]Abbreviation	A	Max 50
23	Class Description		Blank	A	Max 300
24	Class Start Date*	The first day of the class, in the format MM/DD/YYYY	[Terms]Firstday	Date	10
25	Class End Date*	The last day of the class, in the format MM/DD/YYYY	[Terms]Lastday	Date	10
26	Teacherid*	The unique id for the teacher	[Users]DCID	A	Max 12
27	Teacher First Name*	The teacher’s legal first name if it exists, otherwise the teacher’s first name.	[Teachers]GA__Tch_Legal_First_Name [Users]First_name	A	Max 20
28	Teacher Last Name*	The teacher’s legal last name if it exists, otherwise the teacher’s last name.	[S_GA_USR_X]Tch_Legal_Last_Name [Users]Last_Name	A	Max 20
29	Teacher Middle Initial	The teacher’s legal middle initial if it exists, otherwise the teacher’s middle initial.	[S_GA_USR_X]Tch_Legal_Middle_Name [Users]Middle_Name	A	Max 1
30	Teacher Nick Name	The teacher’s preferred name if it exists.	[Users]PreferredName	A	Max 45
31	Teacher User Name*	The teacher’s login id. This is the teacher’s email address if it exists. Otherwise it is the teacher’s social security number with dashes removed.	[Users]Email_Addr [Users]SSN	A	Max 50
32	Teacher Password*	The password for the teachers are generated automatically in the following format: UPPER 1 Character of First Name UPPER 1 Character of Middle Name if exists. LOWER 1 Character of Last Name FULL birthday in the format of MM/DD/YYYY If the teacher has a legal name, then the first character of the legal names will be used instead of the preferred name. If only one legal name is available, then the first character of the legal name along with the first characters of the first and middle names from the preferred name will be used.	[UsersCoreFields]dob [S_GA_USR_X]Tch_Legal_First_Name [Users]First_Name [S_GA_USR_X]Tch_Legal_Last_Name [Users]Last_Name	A	Max 50
33	Teacher e-mail	The teacher’s e-mail address.	[Users]Email_Addr	A	Max 254
34	Teacher is Active	A flag to show if the teacher is currently active (Y/N).	[SchoolStaff]Status	A	1
35	Teacher SSO ID		Blank	A	Max 35

Back to Top