Fitnessgram Extract

Contents

Introduction

Oklahoma State Fitnessgram Extract provides data relationships between teachers/classes/students (each with unique IDs) to be imported into the FITNESSGRAM® program, including student demographic information to calculate the results. This contains student records taking Physical Education classes based on the requirements provided Human Kinetics for the Oklahoma Department of Health (DOH).

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] tables based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student must be active in the current school year.
The student must be enrolled in a Physical Education course. The course must have an Alternate Course Number:

3320 (for grades 9-12)
1363 (for grades K-8)

Report Input

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

Field

Description

Current Selection Students

Select the students to include in the report:

The Selected [number] Students Only.
All Students

Note: If running the report for a single student, or group of students, select the students prior to running report.

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.

Note: Asterisk (*) indicates a required field value.

Item #	Data Element	Description	[Table]FieldName
1	SchoolID *	Accredited County, District, and Site code concatenated.	Derived from Prefs and Schools tables. Using District Number and School Number
2	StudentID *	Student Testing Number (10 digits length)	[Students]State_StudentNumber
3	StudentFirstName *	Student's First Name. Commas not allowed.	[Students]First_Name
4	StudentLastName *	Student's Last Name. Commas not allowed.	[Students]Last_Name
5	StudentMiddleInitial	Student's middle name initial only.	[Students]Middle_Name (Initial only)
6	StudentNickName	Student’s nick name.	Extract as blank
7	StudentBirthdate *	Student’s birthdate in mm/dd/yyyy format.	[Students]DOB
8	StudentGrade *	Modify the GradeLevel_Code so that it doesn't have any leading zeros.	[Students]Grade_Level
9	StudentGender *	Student’s Gender	[Students] Gender
10	StudentEthnicityCode	Race Codes have to be mapped to Federal three digit race code within Fitnessgram.	Derived from: [Students]FedEthnicity or [StudentRace]RaceCode or [Students]Ethnicity
11	StudentUsername *	Use the same Student ID that is used in column 2.	[Students] State_StudentNumber
12	StudentPassword *	Student’s password. Derived: FirstInitial + MiddleInitial + LastInitial + Birthdate (YYYYMMDD)	[Students] First Initial + Middle Initial + Last Initial + DOB (YYYYMMDD) Concantenated with no hyphens or slashes.
13	StudentReportEmail	Student’s email address.	[PSM_StudentContact] Email
14	ParentReportEmail1	Parent’s first email address. Note: Only the first email is extracted.	[Students]GuardianEmail
15	ParentReportEmail2	Parent’s second email address.	Extract as blank
16	StudentAddress1	Street part of the student’s mailing address. Commas not allowed. Note: Special characters are removed.	[Students]Street
17	StudentAddress2	Additional parts of street address.	Extract as blank
18	StudentAddress3	Additional parts of street address.	Extract as blank
19	StudentCity	City part of the student’s mailing address. Note: Special characters are removed.	[Students]City
20	StudentState	State part of the student’s mailing address. Note: Special characters are removed.	[Students]State
21	StudentZip	Zip code of the student’s mailing address.	[Students]Zip
22	StudentPrintBodyComp	Print body composition for student.	Always set to Y.
23	StudentPrintReportInSpanish	Print report in Spanish. When blank report prints by default in English.	Extract as blank
24	StudentPermanentExemptionCode	Place holder. This field will be blank.	Extract as blank
25	StudentIsActive?	Evaluating student’s activity in the district on the date of the extract. Defaults to Y.	Always set to Y.
26	ClassName *	A unique class name easily identified by Teacher. Commas not allowed.	Derived from CC record CourseName + (Course.Section)
27	Class ID *	Class ID must be unique per Class state wide, for the school year.	Derived from CC record GUID that contains the SectionInfo/RefID of the Section Enrollment (CC record) from the SIFRefIDs table.
28	ClassDescription	Class description. This is not visible to the Teacher in the Class Listing. Commas not allowed.	Derived from CC record Course.Section + Term ID + Year + SchoolNumber + CourseName separated by dashes.
29	ClassStartDate *	Course start date. Not student’s start date.	[Terms]FirstDay
30	ClassEndDate *	Course end date. Not student’s end date.	[Terms]LastDay
31	TeacherID *	Unique number assigned to a Teacher by the Oklahoma Department of Education. Note: Do not use the teacher's SSN, or locally assigned ID.	[Users]SIF_StatePrId
32	TeacherFirstName *	Class teacher’s first name. Commas not allowed.	[Users]First_name
33	TeacherLastName *	Class teacher’s last name. Commas not allowed.	[Users]Last_name
34	TeacherMiddleInitial	Class teacher’s middle name initial.	[Users]Middle_Name (Initial Only)
35	TeacherNickName	Class teacher’s nick name.	Extract as blank
36	TeacherUserName *	Teacher’s unique login credential.	[Users]Email_Addr
37	TeacherPassword *	Teacher’s unique password credential.	[Users]Password
38	TeacherEmail	Teacher’s official school email account.	[Users]Email_Addr
39	TeacherAddress1	Street part of school’s mailing address.	Extract as blank
40	TeacherAddress2	Additional parts of street address.	Extract as blank
41	TeacherAddress3	Additional parts of street address.	Extract as blank
42	TeacherCity	City part of school’s mailing address.	Extract as blank
43	TeacherState	State part of school’s mailing address.	Extract as blank
44	TeacherZip	Zip part of school’s mailing address.	Extract as blank
45	TeacherIsActive?	Evaluating teacher’s activity in the district on the date of the extract. Defaults to Y.	Always set to Y.

Back to Top