School bus routing software including GPS fleet tracking, routing logistics, fleet maintenance, and field trip management for pupil transportation. The Routefinder Plus Zap includes student, guardian, address, and status data so that districts can easily create transportation assignments within Transfinder. The Zap can be configured to extract this information on a scheduled basis, ensuring that your data remains synchronized between the two products.
Before You Begin
This particular output uses the | (pipe) character as the delimiter based on the requirement and request of the third party vendor. When view the data in an Excel sheet please follow the following steps:
- Open a blank Excel.
- Highlight the Excel and make the entire Excel sheet formatted as text.
- Copy the contents of the document (using note pad) and then paste it into excel, the highlight the first column ONLY - Not the entire excel sheet.
- Then select Data > Text to Columns and chose the delimiters as Other and enter | (pipe) character as show below and click on Next and the complete the transformation. It will provide the proper formatted excel view. (second image)
Business Rules
Routefinder Plus
Field | Explanation | Notes |
ID Number | Self-explanatory | |
Last Name | Self-explanatory | |
First Name | Self-explanatory | |
Middle Name | Self-explanatory | |
Current Grade Level | Student's current grade if GURU's Source Year is set to current year, or student's scheduling grade if GURU's Source Year is set to next year | |
Next Year Grade Level if Indicated | Student's scheduling grade if GURU's Source Year is set to current year and the scheduling grade is not the same as the current grade | |
Current School | Student's current school's name if GURU's Source Year is set to current year, or name of student's scheduling school if GURU's Source Year is set to next year | |
Current School Code | Student's current school's code if GURU's Source Year is set to current year, or name of student's scheduling school if GURU's Source Year is set to next year | |
School of Attendance | Value from Student's user defined field "TR-School of Attendance" | |
Next Year School of Attendance | Value from Student's user defined field "TR-Next Year School of Attendance" | |
Next Year School if indicated | Student's scheduling school's name if GURU's Source Year is set to current year and the scheduling school and grade is not the same as the current school and grade | |
Next Year School Code | Student's scheduling school's code if GURU's Source Year is set to current year and the scheduling school and grade is not the same as the current school and grade | |
Family ID | Primary key of the student's household | |
Residence Street Number | Household's residential street number and street suffix | |
Residence Street Name | Household's residential street name | |
Residence Address Line 2 | Household's residential apartment number | |
Residence Address | Combination of the household's residential street number, street suffix, street name, and apartment number. Append "Apt. " before the apartment number if one exists. | |
Residence City | Household's residential city name | |
Residence State | Household's residential state | |
Residence Zip | Household's residential zip | |
Mailing Address Line 1 | Household's mailing P.O. Box if it exists, else the household's mailing street number, street suffix and street name | |
Mailing Address Line 2 | Household's mailing apartment number | |
Mailing City | Household's mailing city name | |
Mailing State | Household's mailing state | |
Mailing Zip | Household's mailing zip | |
Gender | Self-explanatory | |
Date of Birth | Self-explanatory | |
Primary Guardian First Name | First name of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Last Name | Last name of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Person ID | Primary key of the People record tied to the first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Relationship | Student's relationship to the first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Home Phone | First phone with the type "Home Phone" or "Home Cell" of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Cell Phone | First phone with the type "Cell Phone", "Home Cell" or "Work Cell" of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Work Phone | First phone with the type "Work Phone" or "Work Cell" of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Email Address | The primary email of first priority guardian with the custodial and correspondence flag on; if guardian does not have an email flagged as the primary email, use the first encountered email instead | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Address Line 1 | Mailing PO Box of the first priority guardian with the custodial and correspondence flag on if it exists, else use their mailing street number, street suffix and street name | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Address Line 2 | Mailing apartment number of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian City | Mailing city name of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian State | Mailing state of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Primary Guardian Zip | Mailing zip of first priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian First Name | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Last Name | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Person ID | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Relationship | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Home Phone | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Cell Phone | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Work Phone | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Email Address | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Address Line 1 | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Address Line 2 | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian City | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian State | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Second Guardian Zip | Same logic as the "Primary Guardian" field but from the second priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian First Name | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Last Name | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Person ID | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Relationship | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Home Phone | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Cell Phone | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Work Phone | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Email Address | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Address Line 1 | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Address Line 2 | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian City | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian State | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Third Guardian Zip | Same logic as the "Primary Guardian" field but from the third priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian First Name | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Last Name | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Person ID | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Relationship | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Home Phone | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Cell Phone | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Work Phone | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Email Address | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Address Line 1 | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Address Line 2 | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian City | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian State | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fourth Guardian Zip | Same logic as the "Primary Guardian" field but from the fourth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian First Name | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Last Name | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Person ID | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Relationship | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Home Phone | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Cell Phone | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Work Phone | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Email Address | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Address Line 1 | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Address Line 2 | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian City | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian State | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
Fifth Guardian Zip | Same logic as the "Primary Guardian" field but from the fifth priority guardian with the custodial and correspondence flag on | Priority is not a numeric value but derived based on the highest priority |
First EC First Name | First name of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Last Name | Last name of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Person ID | Primary key of the People record tied to the first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Relationship | Student's relationship to the first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Home Phone | First phone with the type "Home Phone" or "Home Cell" of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Cell Phone | First phone with the type "Cell Phone", "Home Cell" or "Work Cell" of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Work Phone | First phone with the type "Work Phone" or "Work Cell" of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Email Address | First encountered email of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Address Line 1 | Mailing PO Box of the first priority emergency contact if the exact same person does not also exist as the student's guardian if it exists, else use their mailing street number, street suffix and street name | Priority is not a numeric value but derived based on the highest priority |
First EC Address Line 2 | Mailing apartment number of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC City | Mailing city name of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC State | Mailing state of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
First EC Zip | Mailing zip of first priority emergency contact if the exact same person does not also exist as the student's guardian | Priority is not a numeric value but derived based on the highest priority |
Second EC First Name | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Last Name | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Person ID | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Relationship | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Home Phone | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Cell Phone | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Work Phone | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Email Address | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Address Line 1 | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Address Line 2 | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC City | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC State | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Second EC Zip | Same logic as the "First EC" field but from the second priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC First Name | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Last Name | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Person ID | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Relationship | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Home Phone | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Cell Phone | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Work Phone | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Email Address | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Address Line 1 | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Address Line 2 | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC City | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC State | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Third EC Zip | Same logic as the "First EC" field but from the third priority emergency contact instead | Priority is not a numeric value but derived based on the highest priority |
Student Allergy | All of the student's allergies if the zap is set up to include them | |
If Special ED | Y if the student has an active Special Education code of "SE", else N | |
If English Language Learner | Y if the student has an active Student Status code of "0231", else N | |
If Homeless | Y if the student has an active Student Status code of "HML", "8262" or "8272", else N | |
If Pre-registered | Y if the student is pre-registered, else N | |
Start Date if Pre-registered | Student's anticipated enrollment date if the student is pre-registered | |
Geographical Code | Household's Geo Code | |
Student Medical Condition | All of the student's active medical conditions if the zap is set up to include them | |
LearningCode | Student's current learning code. If the student has more than one current learning code, only one of them is included in the export | |
Hispanic Indicator | Y if the student is Hispanic, else N | |
Ethnicity | 4 if the student is Hispanic 1 if the student's race is American Indian/Alaska Native 2 if the student's race is Asian 3 if the student's race is Black 5 if the student's race if White 6 if the student's race is Native Hawaiian/Other Pacific Islander 7 if the student's race is Multiracial |
|
Household Language | Household's language | |
Student Dominant Language | Student's language | |
Home Room | Student's homeroom | |
Home Room Teacher | Student's homeroom teacher | |
Home Room Class | Student's homeroom class | |
Counselor | Self-explanatory | |
Advisor | Self-explanatory | |
Cohort | Student's cohort exported as "#### Cohort" | |
Projected Graduation Year | Self-explanatory | |
Tuition District | Self-explanatory | |
Home School | Self-explanatory | |
If Wheel Chair Required | Y if the student's user defined field "TR-If Wheel Chair Required" is checked on, else N | |
If Matron Required | Y if the student's user defined field "TR-If Matron Required" is checked on, else N | |
If Air Condition Required | Y if the student's user defined field "TR-If Air Condition Required" is checked on, else N | |
If Required to Transport Door to Door | Y if the student's user defined field "TR-If Required to Transport Door to Door" is checked on, else N | |
If Aide Required | Y if the student's user defined field "TR-If Aide Required" is checked on, else N | |
If Nurse Required | Y if the student's user defined field "TR-If Nurse Required" is checked on, else N | |
If Car Seat Required Pre-k | Y if the student's user defined field "TR-If Car Seat Required Pre-k" is checked on, else N | |
If Lower Step Required | Y if the student's user defined field "TR-If Lower Step Required" is checked on, else N | |
If Safety Vest Required | Y if the student's user defined field "TR-If Safety Vest Required" is checked on, else N | |
If Translation Required | Y if the student's user defined field "TR-If Translation Required" is checked on, else N | |
Dual Transportation School | Value of the student's user defined field "TR-Dual Transportation School" | |
Alternate Pick Up location Days | All the days that are checked on in the student's user defined field "TR-Alternate Pick Up location Days", separated with semicolons | |
Alternate Pick Up location | Value of the student's user defined field "TR-Alternate Pick Up location" | |
If Mini Bus Required | Y if the student's user defined field "TR-If Mini Bus Required" is checked on, else N | |
If Individual Transportation Required | Y if the student's user defined field "TR-If Individual Transportation Required" is checked on, else N | |
School Abbreviation | Student's current school's Abbreviation if GURU's Source Year is set to current year, or student's scheduling school's Abbreviation if GURU's Source Year is set to next year | |
Location Code | Student's current school's Location Code if GURU's Source Year is set to current year, or student's scheduling school's Location Code if GURU's Source Year is set to next year |