Transportation, 120 (ver3.6.1)
Transportation information such as the type of transportation and its related information that the student uses, such as For Bus types: Route Number, Bus Number, etc.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Address | 3.6.1 | CLOB | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
ArrivalTime | 3.6.1 | Date | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
BusNumber | 3.6.1 | Varchar(79) | Bus number provided for this record by the school, which the student uses. |
ContactNumber | 3.6.1 | Varchar(79) | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DepartureTime | 3.6.1 | Date | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
Description | 3.6.1 | Varchar(79) | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
Distance | 3.6.1 | Float | The distance that the student travels on the way to or from school. Choose either Miles or Kilometers. |
DistanceIndicator | 3.6.1 | Varchar(79) | Used for conversion purposes only. M= Miles, K=Kilometers. See Distance. |
DriverName | 3.6.1 | Varchar(305) | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
EndDate | 3.6.1 | Date | The date that the student will stop using this form of transportation. |
Friday | 3.6.1 | Number(10,0) | Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
FromTo | 3.6.1 | Varchar(79) | Indicates the direction of the transportation: From = From School, To = To school. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
LinkingCode | 3.6.1 | Varchar(3) | Use the indicator to link bus routes that share commonalities. For example, you can link a student's AM and PM bus route for reporting purposes. NL=Not Linked, otherwise a Letter, such as Y, which links two records together. |
Monday | 3.6.1 | Number(10,0) | Flag indicating whether the student uses this form of transportation on this day. 1= yes. |
RouteNumber | 3.6.1 | Varchar(79) | The route number if the student uses transportation provided by the school. |
Saturday | 3.6.1 | Number(10,0) | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SpecialInstructions | 3.6.1 | CLOB | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
StartDate | 3.6.1 | Date | The date that the student will begin using this form of transportation. |
StopNumber | 3.6.1 | Varchar(79) | The bus stop number if the student uses transportation provided by the school. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Sunday | 3.6.1 | Number(10,0) | No longer used by the application.This field may still be referenced on reports and/or custom pages. |
Thursday | 3.6.1 | Number(10,0) | Flag indicating whether the student uses this form of transportation on this day. 1 = Yes. |
Tuesday | 3.6.1 | Number(10,0) | Flag indicating whether the student uses this form of transportation on this day. 1 = Yes. |
Type | 3.6.1 | Varchar(79) | The indicated mean of transportation. |
Wednesday | 3.6.1 | Number(10,0) | Flag indicating whether the student uses this form of transportation on this day. 1= yes. |