Tyler Versatrans, a complete school transportation software suite, is designed to help you efficiently and cost-effectively manage your day-to-day transportation needs — so you can safely transport students to and from their educational programs on time and on budget. The Versatrans Zap includes student, address, and status data so that districts can easily create transportation assignments within Versatrans. The Zap can be configured to extract this information on a scheduled basis, ensuring that your data remains synchronized between the two products. This lesson provides the Business Rules for the Verstrans zap.
Before you Begin
Need a refresher on installing a Zap? Visit to Pre-Built Export Zaps learn more.
Business Rules
Versatrans.csv
The output will be in comma-delimited format with no double quotes and no headers as requested by the vendor.
Filters available are Grade Level, School Type, and School.
Options available are Health Information, Use School Code instead of Location Code, Include Pre-registered Students, and Anticipated Enrollment Before.
Anticipated Enrollment Before must be in MM/DD/YYYY format and need updates as per the requirement of the district as this date will be static.
If a non-date format is entered or a text is entered, the filter will be ignored. Since we do not have an option to force date format, care must be taken while entering this information.
| Field | Explanation | Notes |
|---|---|---|
| Student ID | Self-explanatory | |
| Last Name | Self-explanatory | |
| First Name | Self-explanatory | |
| Middle Name/Initial | Self-explanatory | |
| Grade | If the GURU Source Year is the current year, pull the student's current grade level. If the GURU Source Year is the next year, pull the student's scheduling grade level. |
|
| School Building Number | If the GURU Source Year is set to the current year: 1. If the Use School Code instead of Location Code setting is on, pull the enrolled building's School Code if available. 2. If the Use School Code instead of Location Code setting is off, pull the enrolled building's location code if available. 3. If none of the above can be found, pull the enrolled building's eSD primary key. If the GURU Source Year is set to the next year: 1. If the Use School Code instead of Location Code setting is on, pull the scheduling building's School Code if available. 2. If the Use School Code instead of Location Code setting is off, pull the scheduling building's Location Code if available. 3. If none of the above can be found, pull the scheduling building's eSD primary key. |
|
| Home House Number | Household's residental street number and street suffix | |
| Home Street | Household's residental street name | |
| Home Apartment Number | Household's residental apartment number | |
| City | Household's residental city | |
| State | Household's residental state | |
| Zip Code | Household's residental zip code | |
| Date of Birth | Self-explanatory | |
| Home Phone Number | Household's phone number | |
| Emergency Phone 1 | First home phone of first priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 2 | First home phone of second priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 3 | First home phone of third priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 1 | First and last name of first priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 2 | First and last name of second priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 3 | First and last name of third priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Gender | Self-explanatory | |
| Medical Data | Contains the student's allergies and active medical conditions depending on what is selected in the Zap | |
| School Name | If the GURU Source Year is the current year, pull the student's current building name. If the GURU Source Year is the next year, pull the student's scheduling building name. |
|
| Emergency Contact 1 Relationship | Student's relationship to first priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 2 Relationship | Student's relationship to second priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 3 Relationship | Student's relationship to third priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 1 Cell Phone | First cell phone of first priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 2 Cell Phone | First cell phone of second priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 3 Cell Phone | First cell phone of third priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 1 Work Phone | First work phone of first priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 2 Work Phone | First work phone of second priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 3 Work Phone | First work phone of third priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 4 | First home phone of fourth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 5 | First home phone of fifth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 6 | First home phone of first priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 7 | First home phone of second priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Phone 8 | First home phone of third priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 4 | First and last name of fourth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 5 | First and last name of fifth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 6 | First and last name of first priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 7 | First and last name of second priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 8 | First and last name of third priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 4 Relationship | Student's relationship to fourth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 5 Relationship | Student's relationship to fifth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 6 Relationship | Student's relationship to first priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 7 Relationship | Student's relationship to second priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 8 Relationship | Student's relationship to third priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 4 Cell Phone | First cell phone of fourth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 5 Cell Phone | First cell phone of fifth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 6 Cell Phone | First cell phone of first priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 7 Cell Phone | First cell phone of second priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 8 Cell Phone | First cell phone of third priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 4 Work Phone | First work phone of fourth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 5 Work Phone | First work phone of fifth priority custodial guardian | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 6 Work Phone | First work phone of first priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 7 Work Phone | First work phone of second priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Emergency Contact 8 Work Phone | First work phone of third priority emergency contact | Priority is not a numeric value but derived based on the highest priority |
| Home Language | Household's language | |
| Student Dominant Language | Self-explanatory | |
| Scheduling School | Student's scheduling school if available and GURU Source Year is set to the current year, else leave blank | |
| Scheduling Grade | Student's scheduling grade if available and GURU Source Year is set to the current year, else leave blank | |
| Pre-reg | Show Y if the student is pre-registered, else show N. Pre-registered students will only be included in the file if the zap setting Include Pre-registered Students is on. If a Anticipated Enrollment Before date is provided in the zap and the Include Pre-registered Students flag is on, pre-registered students with an anticipated enrollment date on or before the date entered in the box will be pulled |