Transportation routing, scheduling and monitoring
Standard Data Conversion File Layout
Data should be in any of the following formats:
- ASCII comma delimited
- ASCII tab delimited
- Excel spreadsheet
- MS Word document
- Access database
A clear printed hardcopy report on a laser printer (not recommended) can also be
used if an electronic format is not available. If all the required information
is not available, provide the information you do have.
| Student Information |
| Field Number |
Max Field Length |
Field Description |
| 1 |
1 |
Active/Inactive (A or I) |
| 2 |
20 |
Student ID Number (Alphanumeric) |
| 3 |
50 |
Student Name (Last name first) |
| 4 |
10 |
House Number (Alphanumeric) |
| 5 |
2 |
Prefix |
| 6 |
25 |
Street Name |
| 7 |
5 |
Street Type |
| 8 |
4 |
Suffix |
| 9 |
40 |
Address 2 |
| 10 |
20 |
City |
| 11 |
2 |
State |
| 12 |
10 |
Zip Code (Alphanumeric) |
| 13 |
45 |
Mailing Address |
| 14 |
40 |
Mailing Address 2 |
| 15 |
20 |
Mailing City |
| 16 |
2 |
Mailing State |
| 17 |
10 |
Mailing Zip Code (Alphanumeric) |
| 18 |
25 |
Guardian 1 Name |
| 19 |
25 |
Guardian 2 Name |
| 20 |
18 |
Guardian 1 Home Phone |
| 21 |
18 |
Guardian 2 Home Phone |
| 22 |
18 |
Guardian 1 Work Phone |
| 23 |
18 |
Guardian 2 Work Phone |
| 24 |
10 |
Date of Birth (mm/dd/yyyy) |
| 25 |
2 |
Race |
| 26 |
1 |
Sex |
| 27 |
2 |
Grade |
| 28 |
20 |
Current School Code (Alphanumeric) |
| 29 |
20 |
Previous School Code (Alphanumeric) |
| 30 |
10 |
Entrance Date (mm/dd/yyyy) |
| 31 |
10 |
Exit Date (mm/dd/yyyy) |
| 32 |
No limit |
Special Medical Condition |
| 33 |
No limit |
Comment |
| 34 |
5 |
Home Room |
| 35 |
20 |
Info1 |
| 36 |
20 |
Info2 |
| 37 |
20 |
Info3 |
| 38 |
20 |
Info4 |
| 39 |
18 |
Guardian 1 Cell Phone Number |
| 40 |
18 |
Guardian 2 Cell Phone Number |
| 41 |
18 |
Guardian 1 Pager Number |
| 42 |
18 |
Guardian 2 Pager Number |
| 43 |
50 |
Guardian 1 Email |
| 44 |
50 |
Guardian 2 Email |
|
School Information
|
| Field Number |
Field Maximum Length |
Field Name |
| 1 |
50 |
School Name |
| 2 |
20 |
School Code (Alphanumeric) |
| 3 |
40 |
Location Address |
| 4 |
40 |
Mailing Address (if different) |
| 5 |
18 |
Phone |
| 6 |
18 |
Fax |
| 7 |
18 |
Emergency Phone |
| 8 |
25 |
Contact Person 1 |
| 9 |
25 |
Contact Person 2 |
| 10 |
9 |
Next School (for graduating into) |
| 11 |
10 |
Beginning School Date |
| 12 |
10 |
Ending School Date |
| 13 |
8 |
AM Early Time |
| 14 |
8 |
AM Optimum Time |
| 15 |
8 |
AM Late Time |
| 16 |
8 |
AM Bell Time |
| 17 |
8 |
PM Early Time |
| 18 |
8 |
PM Optimum Time |
| 19 |
8 |
PM Late Time |
| 20 |
8 |
PM Bell Time |
| 21 |
5 |
Walk to School Distance |
| 22 |
5 |
Walk to Stop Distance |
| 23 |
5 |
School Type |
| 24 |
4 |
District Number (New Jersey) |
| 25 |
No Limit |
Grades Serviced |
|
Bus Stop Information
|
Complete list of all unique bus stop descriptions (include
bus stop numbers if used), for example:
101 MAIN ST
BROAD ST X MAIN ST
|
|
Vehicle Information
|
| Field Number |
Field Maximum Length |
Field Name |
| 1 |
4 |
Bus Number |
| 2 |
10 |
Manufacture Date |
| 3 |
4 |
Seating Capacity |
| 4 |
10 |
License |
| 5 |
15 |
Model |
| 6 |
15 |
Make |
| 7 |
20 |
VIN |
|
Any additional Vehicle Information you provide will also be converted.
|
| Driver Information |
| Driver name |
| Any additional Driver Information you provide will also be converted. |