Importing Data for Existing Records - Historical Marks

Field	Required	Type	Sample Values	Notes
Lookup_Hist_Student_Mark_Id	Yes if other Lookup_*** fields are not populated	Lookup	"12345"	Must match an existing Historical Student Mark Id in the system.
Lookup_Student_Id	Yes if Lookup_Hist_Student_Mark_Id is not populated	Lookup	"123"	Must match an existing Student Id in the system.
Lookup_Student_Last_Name	Yes if Lookup_Hist_Student_Mark_Id and Lookup_Student_Id is not populated	Lookup	"John"	Must match an existing Student Last Name in the system.
Lookup_Student_First_Name	Yes if Lookup_Hist_Student_Mark_Id and Lookup_Student_Id is not populated	Lookup	"Doe"	Must match an existing Student First Name in the system.
Lookup_Birthdate	Yes if Lookup_Hist_Student_Mark_Id and Lookup_Student_Id is not populated	Lookup	"2000/01/01"	Must match an existing Student Birthdate in the system.
Lookup_School_Year	Yes if Lookup_Hist_Student_Mark_Id is not populated	Lookup	"2000/2001"	Must match an existing School Year in the system.
Lookup_Grade_Level_Id	Yes if Lookup_Hist_Student_Mark_Id and Lookup_Student_Id is not populated	Lookup	"123"	Must match an existing Grade Level Id in the system.
Lookup_Grade_Level_Code	Yes if Lookup_Hist_Student_Mark_Id and Lookup_Student_Id is not populated	Lookup	"11"	Must match an existing Grade Level Code in the system.
Lookup_Course_Name	Yes if Lookup_Hist_Student_Mark_Id is not populated	Lookup	"Algebra I"	Must match an existing Course Name in the system.
Lookup_External_Course	Yes if Lookup_Hist_Student_Mark_Id is not populated	Lookup	"0"	1 indicates the course was taken at another school. 0 indicates the course is taken at the school.
Lookup_School_Name	Yes if Lookup_Hist_Student_Mark_Id is not populated	Lookup	"Providence School"	Name of the school an external course is taken
Hist_Student_Mark_Id	Yes, if this field needs to be updated	Identifier	"12345"
School_Year	Yes, if this field needs to be updated	Boolean	"1"	1 = Next Year, 0 = This Year.
Student_Id	Yes, if this field needs to be updated	Identifier	"12345"	Must match an existing student ID in the system
Grade_Level_Id	Yes, if this field needs to be updated	Identifier	"1"
Course_Name	Yes, if this field needs to be updated	Text	"Algebra I"
External_Course School_Name	Yes, if this field needs to be updated	Text	"Providence School"
Short_Course_Name	Yes, if this field needs to be updated	Text	"MATH101"
Number_of_Semesters	Yes, if this field needs to be updated	Integer	"2"	Possible values include 1, 2, 3, or 4
Credits_Per_Semester	Yes, if this field needs to be updated	Decimal	"0"
Include_In_GPA	Yes, if this field needs to be updated	Boolean	"1"	1 indicates grades are included in gpa. 0 indicates grades are not included in gpa.
GPA_Weight	Yes, if this field needs to be updated	Decimal	"0.5"
Attribute1	Yes, if this field needs to be updated	Text
Attribute2	Yes, if this field needs to be updated	Text
Attribute3	Yes, if this field needs to be updated	Text
Class_Rank_Type	Yes, if this field needs to be updated	Datasource Data	"AP Only"	Source is based on Course "Class Rank" types
Hist_Transcript_Course_Name	Yes, if this field needs to be updated	Text		An alternative course name which may be shown depending on the transcript setup
Course_Type3	Yes, if this field needs to be updated	Datasource Data
Department_Id	Yes, if this field needs to be updated	Identifier	"5"	The department id helps determine which school division the record is for
Teacher_Last_Name	Yes, if this field needs to be updated	Text	"Smith"	Does not need to match a teacher name with your school
Teacher_First_Name	Yes, if this field needs to be updated	Text	"Jane"	Does not need to match a teacher name with your school
First_Mark	Yes, if this field needs to be updated	Text	"A"
Second_Mark	Yes, if this field needs to be updated	Text	"95"
Third_Mark	Yes, if this field needs to be updated	Text	"P"
Final_Mark	Yes, if this field needs to be updated	Text	"A"
First_Effort	Yes, if this field needs to be updated	Text
Second_Effort	Yes, if this field needs to be updated	Text
Third_Effort	Yes, if this field needs to be updated	Text
Fourth_Effort	Yes, if this field needs to be updated	Text
First_Quarter	Yes, if this field needs to be updated	Text
Second_Quarter	Yes, if this field needs to be updated	Text
Third_Quarter	Yes, if this field needs to be updated	Text
Fourth_Quarter	Yes, if this field needs to be updated	Text
First_Exam	Yes, if this field needs to be updated	Text
Second_Exam	Yes, if this field needs to be updated	Text
Third_Exam	Yes, if this field needs to be updated	Text
First_Final_Exam	Yes, if this field needs to be updated	Text
Second_Final_Exam	Yes, if this field needs to be updated	Text
Third_Final_Exam	Yes, if this field needs to be updated	Text
BC_Trax_Grad_Req	Yes, if this field needs to be updated	Datasource Data	"F"	F meets Fine Arts, A meets Applied Skills, B meets both requirements
BC_Trax_School_Percent	Yes, if this field needs to be updated	Decimal	"95"
BC_Trax_Exam_Percent	Yes, if this field needs to be updated	Decimal	"95"
BC_Trax_Examinable_Course	Yes, if this field needs to be updated	Boolean	"1"	1 indicates that the course is an examinable course, 0 indicates the opposite
BC_Trax_Electronic_Exam	Yes, if this field needs to be updated	Boolean	"1"	1 indicates that the student takes the electronic exam, 0 indicates the opposite
BC_Trax_Course_Code	Yes, if this field needs to be updated	Text	"EN"
BC_Trax_Course_Level	Yes, if this field needs to be updated	Text	"10"
BC_Trax_Course_Type	Yes, if this field needs to be updated	Datasource Data	"E"	E means equivalency and C means challenge
BC_Trax_Month	Yes, if this field needs to be updated	Datasource Data	"6"	Must be a value 1-12 or blank
BC_Trax_Proc_Spec_Case	Yes, if this field needs to be updated	Datasource Data	"D"	R means Rewrite, D means Deferral
BC_Trax_Related_Code	Yes, if this field needs to be updated	Text	"YSSC"
BC_Trax_Related_Level	Yes, if this field needs to be updated	Text	"11B"
BC_Trax_to_Write	Yes, if this field needs to be updated	Boolean	"1"	1 indicates the student opted to write the optional exam, 0 indicates the opposite
Course_Start_Date	Yes, if this field needs to be updated	Date	"2000/09/01"
Course_End_Date	Yes, if this field needs to be updated	Date	"2000/12/01"
Course_Type_Level_Id	Yes, if this field needs to be updated	Identifier	"6"	Course Type Levels are typically used for Graduation Requirements or Prerequisites
Lookup_Course_Type_Level_Id	Yes, if this field needs to be updated	Lookup	"6"	Used to look up the couse_type_level_id
Lookup_Course_Type	Yes, if this field needs to be updated	Lookup	"Math"	Used to look up the couse_type_level_id
Lookup_Course_Level	Yes, if this field needs to be updated	Lookup	"105"	Used to look up the couse_type_level_id

Note: Typically, only First_Mark, Second_Mark, Third_Mark, and/or Final_Mark are showing on transcripts. Other marks are retained only for data mining purposes.
Note: Only one record per student may have the same School_Year, Grade_Level_Id, Course_Name, External_Course, School_Name
Note: Attributes 1-3 and Course_Type3 are used to store custom data
Note: For BC fields, see the TRAX Specification for British Columbia reporting requirements.