| Student_Id |
Yes, if student first/last/birthdate is unspecified |
Identifier |
“12345” |
|
| Student_First_Name |
No |
Lookup |
"John |
|
| Student_Last_Name |
No |
Lookup |
"Doe" |
|
| Birthdate |
No |
Lookup |
"2000/01/01" |
|
| School_Year |
Yes |
Datasource Data |
"2000/2001" |
Courses in the same school year are grouped together on transcripts. Format must be xxxx/yyyy |
| Grade_Level |
No |
Datasource Data |
"11" |
Matches with the integer value in Grade Levels. Note: This grade level is the grade level of the student when they took the course. |
| Grade_Level_Id |
Yes, if grade_level is unspecified |
Identifier |
|
|
| Course_Name |
Yes |
Text |
"Algebra I" |
Does not need to match course names offered by your school. |
| Short_Course_Name |
No |
Text |
"MAT104" |
|
| External_Course |
Yes |
Boolean |
"0 |
1 indicates the course was taken at another school. 0 indicates the course is taken at the school. |
| School_Name |
No |
Text |
|
Name of the school an external course is taken |
| Number_of_Terms |
Yes |
Integer |
"2" |
Possible values include 1, 2, 3, or 4 |
| Credits_Per_Term |
No |
Decimal |
"0.5" |
Value may be 0 or blank. |
| Include_In_GPA |
Yes |
Boolean |
"1" |
1 indicates grades are included in gpa. 0 indicates grades are not included in gpa. |
| Hist_Transcript_Course_Name |
No |
Text |
|
An alternative course name which may be shown depending on the transcript setup |
| Class_Rank_Type |
No |
Datasource Data |
"AP Only" |
Source is based on Course “Class Rank” types |
| Attribute1 |
No |
Text |
|
|
| Attribute2 |
No |
Text |
|
|
| Attribute3 |
No |
Text |
|
|
| Course_Type3 |
No |
Datasource Data |
|
|
| Department_Id |
Yes |
Identifier |
"5" |
The department id helps determine which school division the record is for |
| First_Mark |
No |
Text |
"A" |
|
| Second_Mark |
No |
Text |
"95" |
|
| Third_Mark |
No |
Text |
"P" |
|
| Final_Mark |
No |
Text |
"A" |
|
| Staff_Last_Name |
No |
Text |
"Smith" |
Does not need to match a staff name with your school |
| Staff_First_Name |
No |
Text |
"Jane" |
Does not need to match a staff name with your school |
| First_Effort |
No |
Text |
|
|
| Second_Effort |
No |
Text |
|
|
| Third_Effort |
No |
Text |
|
|
| Fourth_Effort |
No |
Text |
|
|
| First_Quarter |
No |
Text |
|
|
| Second_Quarter |
No |
Text |
|
|
| Third_Quarter |
No |
Text |
|
|
| Fourth_Quarter |
No |
Text |
|
|
| First_Exam |
No |
Text |
|
|
| Second_Exam |
No |
Text |
|
|
| Third_Exam |
No |
Text |
|
|
| First_Final_Exam |
No |
Text |
|
|
| Second_Final_Exam |
No |
Text |
|
|
| Third_Final_Exam |
No |
Text |
|
|
| Course_Id |
No |
Identifier |
|
Leave this field blank unless directed otherwise |
| Section |
No |
Text |
|
Leave this field blank unless directed otherwise |
| BC_Trax_Examinable_Course |
No |
Boolean |
"1" |
1 indicates that the course is an examinable course, 0 indicates the opposite |
| BC_Trax_Electronic_Exam |
No |
Boolean |
"1" |
1 indicates that the student takes the electronic exam, 0 indicates the opposite |
| BC_Trax_Course_Code |
No |
Text |
"EN" |
|
| BC_Trax_Course_Level |
No |
Text |
"10" |
|
| BC_Trax_Course_Type |
No |
Datasource Data |
"E" |
E means equivalency and C means challenge |
| BC_Trax_Month |
No |
Datasource Data |
"6" |
Must be a value 1-12 or blank |
| BC_Trax_Proc_Spec_Case |
No |
Datasource Data |
"D" |
R means Rewrite, D means Deferral |
| BC_Trax_Related_Code |
No |
Text |
“YSSC” |
|
| BC_Trax_Related_Level |
No |
Text |
"11B" |
|
| BC_Trax_to_Write |
No |
Boolean |
"1" |
1 indicates the student opted to write the optional exam, 0 indicates the opposite |
| BC_Trax_School_Percent |
No |
Decimal |
"95" |
|
| BC_Trax_Exam_Percent |
No |
Decimal |
"95" |
|
| BC_Trax_Grad_Req |
No |
Datasource Data |
"F" |
F meets Fine Arts, A meets Applied Skills, B meets both requirements |
| Course_Start_Date |
No |
Date |
"2000/09/01" |
|
| Course_End_Date |
No |
Date |
“2000/12/01” |
|
| Course_Type_Level_Id |
No |
Identifier |
"6" |
Course Type Levels are typically used for Graduation Requirements or Prerequisites |
| Lookup_Course_Type_Level_Id |
No |
Lookup |
"6" |
Used to look up the couse_type_level_id |
| Lookup_Course_Type |
No |
Lookup |
"Math" |
Used to look up the couse_type_level_id |
| Lookup_Course_Level |
No |
Lookup |
"105" |
Used to look up the couse_type_level_id |