PSSIS_Student_Transportation (ver5.0.0)
This view provides Transportation information related to Students.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Start_Date | 5.0.0 | Date | [From Transportation] The date that the student will begin using this form of transportation. |
End_Date | 5.0.0 | Date | [From Transportation] The date that the student will stop using this form of transportation. |
FromTo | 5.0.0 | String79 | [From Transportation] Indicates the direction of the transportation: From = From School, To= To school. |
Monday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Tuesday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Wednesday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Thursday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Friday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Saturday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Sunday | 5.0.0 | Longint | [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
Transportation_Type | 5.0.0 | String79 | [From Transportation] The indicated mean of transportation |
Route_Number | 5.0.0 | String79 | [From Transportation] The route number if the student uses transportation provided by the school. |
Bus_Number | 5.0.0 | String79 | [From Transportation]Bus number provided for this record by the school, which the student uses. |
Departure_Time | 5.0.0 | Longint | [From Transportation] Student's departure time. |
Arrival_Time | 5.0.0 | Longint | [From Transportation] Student's arrival time. |
Driver_Name | 5.0.0 | String79 | [From Transportation] (Bus) Driver full name. |
Student_Emergency_ Phone | 5.0.0 | String30 | [From Students] Emergency contact phone number. |
Alert_Medical | 5.0.0 | Text | [From Students] Medical emergency contact phone number. |
Alert_Guardian | 5.0.0 | Text | [From Students] Emergency contact full name. |
Trans_Special_Instructions | 5.0.0 | Text | [From Transportation] Any special transportation information. |