| Student_Id |
Yes, unless lookup fields are used to identify the student |
Identifier |
"123" |
Must match an existing student ID in the system. |
| Lookup_Student_First_Name |
No, unless Student_Id is not specified |
Lookup |
"John" |
Must match an existing student first name in the system. |
| Lookup_Student_Last_Name |
No, unless Student_Id is not specified |
Lookup |
"Doe" |
Must match an existing student last name in the system. |
| Lookup_Student_Birthdate |
No, unless Student_Id is not specified |
Lookup |
"2005/01/15" |
Must match an existing student birthdate in the system. |
| Course_Id |
Yes, unless lookup fields are used to identify the student course |
Identifier |
"67890" |
Must match an existing course ID in the system. |
| Lookup_Course_Name |
No, unless Course_Id is not specified |
Lookup |
"Mathematics" |
Must match an existing course name in the system. |
| Section |
Yes |
Datasource Data |
"01" |
Must match an existing section in the system |
| Marking_Period |
Yes |
Datasource Data |
"1" |
Must match an existing marking period in the system |
| Mark_Type_Id |
Yes, unless lookup fields are used to identify the mark type |
Identifier |
"1" |
Must match an existing mark type ID in the system. |
| Lookup_Mark_Score_Heading_Name |
No, unless Mark_Type_Id is not specified |
Lookup |
"Midterm" |
Must match an existing mark score heading name in the system. |
| Lookup_Mark_Score_Heading_Notes |
No, unless Mark_Type_Id is not specified |
Lookup |
"Quarter 1 grades" |
Must match an existing mark score heading notes in the system. |
| Lookup_Mark_Score_Name |
No, unless Mark_Type_Id is not specified |
Lookup |
"Final Exam" |
Must match an existing mark score name in the system. |
| Reported_Mark_Score |
No |
Decimal |
"95.00" |
|
| Average_Mark_Score |
No |
Decimal |
"90.50" |
|