Skip to main content
Skip table of contents

PSSIS_Student_Transportation (ver5.0.0)

This view provides Transportation information related to Students.

Column NameInitial VersionData TypeDescription

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.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.