User Tools

Site Tools


student:fitnessgram_export_2018

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

student:fitnessgram_export_2018 [2018/10/09 14:10] (current)
jstanford created
Line 1: Line 1:
 +======FitnessGram Export======
  
 +The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2018_001.csv). ​
 +
 +If the district is submitting a district-wide FitnessGram file, copy each campus extract into one file, and remove the campus ID from the name (e.g., FG_Extract_2018.csv). Save the exported document as a .csv file.
 +
 +^Column^Type^Max Length^Valid Values^Description^
 +|School ID*|Alphanumeric|50| |CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001)|
 +|Student ID*|Alphanumeric|30| |Student’s **Texas Unique Student ID** from Registration.|
 +|Student First Name*|Alphanumeric|100| | |
 +|Student Last Name*|Alphanumeric|100| | |
 +|Student Middle Initial|Alphanumeric|1| | |
 +|Student Nickname|Alphanumeric|9| |Student’s **Nickname** from Registration.|
 +|Student Birth Date*|Date| |MM/​DD/​YYYY| |
 +|Student Grade*|Alphanumeric| |K-12|Single,​ alphanumeric characters for grade levels K-9, or two digits for grade levels 10-12|
 +|Student Gender*|Alphanumeric|1|m,​ f, M, F| |
 +|Student Ethnicity Code| | | |Blank|
 +|Student User Name*|Alphanumeric|50| |Same Student ID as in second column|
 +|Student Password*|Alphanumeric|50| |Created using student’s name and date of birth (FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203)). If no middle name, the initial is omitted from the password.|
 +|Student Report Email|Alphanumeric|254| |The student’s **E-mail** from Registration. If email address is not included, those student and parent reports cannot be sent.|
 +|Parent Report Email 1|Alphanumeric|100| |The **E-mail** of the student’s priority 1 contact from Registration. If email address is not included, thosee student and parent reports cannot be sent.|
 +|Parent Report Email 2|Alphanumeric|100| |Blank|
 +|Student Address 1|Alphanumeric|300| |Blank|
 +|Student Address 2|Alphanumeric|300| |Blank|
 +|Student Address 3|Alphanumeric|300| |Blank|
 +|Student City|Alphanumeric|100| |Requested by TEA|
 +|Student State|Alphanumeric|100| |Requested by TEA|
 +|Student Zip|Alphanumeric|20| |Requested by TEA|
 +|Student Print Body Comp|Alphanumeric|1|y,​ n, Y, N|Default is Y. You can change it within the application or file.|
 +|Student Print Report in Spanish?​|Alphanumeric|1|y,​ n, Y, N|If student’s priority 1 contact has //Spanish// selected for **Language** in Registration,​ this column is Y.|
 +|Student Permanent Exemption Code|Alphanumeric|50| |Blank|
 +|Student is Active?​|Alphanumeric|1|Y,​ N|Default is Y. You can change it within the application or file.|
 +|Class Name*|Alphanumeric|50| |DistrictID + CampusID + CourseTitle + CourseNumber + SectionNumber + BeginPeriod + InstructorID|
 +|Class ID*|Alphanumeric|50| |DistrictID + CampusID + ServiceID + CourseNumber + SectionNumber + BeginPeriod + CourseSemester + YY (last two digits of the school year)|
 +|Class Description|Alphanumeric|300| |Course title.|
 +|Class Start Date*|Date| |MM/​DD/​YYYY|Start date for the course.|
 +|Class End Date*|Date| |MM/​DD/​YYYY|The last day of the semester.|
 +|Instructor ID*|Alphanumeric|50| |Unique number assigned to instructor by TEA (TX Unique Staff ID).|
 +|Instructor First Name*|Alphanumeric|100| | |
 +|Instructor Last Name*|Alphanumeric|100| | |
 +|Instructor Middle Initial|Alphanumeric|1| | |
 +|Instructor Nickname|Alphanumeric|100| | |
 +|Instructor User Name*|Alphanumeric|254| |Instructor’s email address. For security purposes this is the official school email address.|
 +|Instructor Password*|Alphanumeric|50| |Created by combining instructor’s date of birth and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB))|
 +|Instructor Email*|Alphanumeric|254| |Instructor’s work email address|
 +|Instructor Address 1|Alphanumeric|300| |Blank|
 +|Instructor Address 2|Alphanumeric|300| |Blank|
 +|Instructor Address 3|Alphanumeric|300| |Blank|
 +|Instructor City|Alphanumeric|100| |Blank|
 +|Instructor State|Alphanumeric|100| |Blank|
 +|Instructor Zip|Alphanumeric|20| |Blank|
 +|Instructor is Active?​|Alphanumeric|1|Y,​ N|Default is Y. You can change it within the application or file.|
 +
 +*Required
 +
 +Notes:
 +  * Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use TxEIS Business, columns for staff information are blank.
 +  * Do not use commas in the data fields; commas will cause the import to fail. If there is a comma in an email field, the email field will be blank when it is exported.
 +  * Do not enter blank spaces in fields that will be empty.
 +  * Do not insert blank rows into the file.
student/fitnessgram_export_2018.txt · Last modified: 2018/10/09 14:10 by jstanford

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.