| Student_Id |
Yes, unless lookup fields are used to identify the student |
Identifier |
"123" |
|
| Lookup_Student_First_Name |
No, unless Student_Id is not provided |
Lookup |
"John" |
Must match an existing student first name in the system |
| Lookup_Student_Last_Name |
No, unless Student_Id is not provided |
Lookup |
"Doe" |
Must match an existing student last name in the system |
| Lookup_Birthdate |
No, unless Student_Id is not provided |
Lookup |
"2004/01/01" |
Must match an existing student birthdate in the system |
| Bus_Route_Id |
Yes, unless lookup fields are used to determine the bus route |
Identifier |
"123" |
|
| Lookup_Bus_Route_Name |
No, unless Bus_Route_Id is not provided |
Lookup |
"Morning Route" |
Must match an existing bus route name in the system |
| Lookup_Bus_Route_Category |
No, unless Bus_Route_Id is not provided |
Lookup |
"Primary" |
Must match an existing bus route category in the system |
| Bus_Route_Stop_Id |
Yes, unless lookup fields are used to identify the bus route stop |
Identifier |
"123" |
|
| Lookup_Bus_Route_Stop_Name |
No, unless Bus_Route_Stop_Id is not provided. |
Lookup |
"Main Street" |
Must match an existing bus route stop name in the system |
| From_Date |
Yes |
Date |
"2024/01/01" |
|
| To_Date |
Yes |
Date |
"2024/06/01" |
Must be greater than or equal to From_Date |
| Day_Of_Week |
No |
Datasource Data |
"2" |
Specifies the day of the week (1 for Monday to 7 for Sunday) |
| Academic_Year |
Yes |
Datasource Data |
"20242025" |
Must match an existing academic year in the system |