student:fitnessgram_export
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
| student:fitnessgram_export [2021/06/14 18:59] – apape | student:fitnessgram_export [2022/03/25 14:58] – removed apape | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ======FitnessGram Export====== | ||
| - | The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_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_2019.csv). Save the exported document as a .csv file. | ||
| - | \\ | ||
| - | ^ ^Column^Type^Max Length^Valid Values^Description^ | ||
| - | |A|SchoolID *|Alphanumeric|50| |CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001)| | ||
| - | |B|StudentID *|Alphanumeric|50| |Must be unique in the district. Ensure student IDs remain consistent year to tear to avoid duplication.| | ||
| - | |C|StudentFirstName *|Alphanumeric|35| | | | ||
| - | |D|StudentLastName *|Alphanumeric|35| | | | ||
| - | |E|StudentMiddleInitial|Alphanumeric|35| | | | ||
| - | |F|StudentNickName|Alphanumeric|35| |Student’s **Nickname** from Registration.| | ||
| - | |G|StudentBirthdate *|Date|10|MM/ | ||
| - | |H|StudentGrade *|Alphanumeric|10|K-13|Single, | ||
| - | |I|StudentGender *|Alphanumeric|1|m, | ||
| - | |J|StudentEthnicityCode|Numeric|100| |Must correspond to an EthnicityID in FitnessGram (three-digit federal code).| | ||
| - | |K|StudentUserName *|Alphanumeric|60| |Must be unique in district. StudentID is often used.| | ||
| - | |L|Student Password*|Alphanumeric|100| |If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203).| | ||
| - | |M|StudentReportEmail|Alphanumeric|128| |The student’s **E-mail** from Registration. If email address is not included, those student and parent reports cannot be sent.| | ||
| - | |N|Student SSO ID|Alphanumeric|35| |Only used for districts using single sign on.| | ||
| - | |O|StudentPrintBodyComp|Alphanumeric|1|y, | ||
| - | |P|ParentReportEmail1|Alphanumeric|128| |The **E-mail** of the student’s priority 1 contact from Registration. If email address is not included, those student and parent reports cannot be sent.| | ||
| - | |Q|ParentReportEmail2|Alphanumeric|128| | | | ||
| - | |R|StudentPrintReportInSpanish|Alphanumeric|1|y, | ||
| - | |S|StudentPermanentExemptionCode|Alphanumeric|1| |Must correspond to an ExemptionID in FitnessGram.| | ||
| - | |T|StudentIsActive|Alphanumeric|1|Y, | ||
| - | |U|ClassName *|Alphanumeric|100| |Add physical education classes. Must be unique by teacher and easily identified by teachers (e.g., CourseTitle + SectionNumber + SemesterIdentifier + YY (last two digits of the school year)| | ||
| - | |V|ClassID *|Alphanumeric|100| |Must be unique in district (e.g., DistrictID + CampusID + ServiceID + CourseNumber + SectionNumber + BeginPeriod + CourseSemester + YY (last two digits of the school year).| | ||
| - | |W|ClassDescription|Alphanumeric|255| | | | ||
| - | |X|ClassStartDate *|Date|10|MM/ | ||
| - | |Y|ClassEndDate *|Date|10|MM/ | ||
| - | |Z|TeacherID *|Alphanumeric|50| |Unique number assigned to instructor by TEA (TX Unique Staff ID).| | ||
| - | |AA|TeacherFirstName *|Alphanumeric|35| | | | ||
| - | |AB|TeacherLastName *|Alphanumeric|35| | | | ||
| - | |AC|TeacherMiddleInitial|Alphanumeric|35| | | | ||
| - | |AD|TeacherNickName|Alphanumeric|35| | | | ||
| - | |AE|TeacherUserName*|Alphanumeric|60| |Must be unique in district. Teacher’s email address is recommended. For security purposes this is the official school email address.| | ||
| - | |AF|TeacherPassword *|Alphanumeric|100| |If password is not available, recommend combining instructor’s birthdate and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB))| | ||
| - | |AG|TeacherEmail *|Alphanumeric|128| |Instructor’s work email address.| | ||
| - | |AH|TeacherIsActive|Alphanumeric|1|Y, | ||
| - | |AI|Teacher SSO ID|Alphanumeric|35| |Only used for districts using single sign on.| | ||
| - | |||
| - | *Required | ||
| - | |||
| - | Notes: | ||
| - | * Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use ASCENDER 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.txt · Last modified: 2022/07/26 13:02 by apape