Locations

Name: Locations

Type: Application

Modules: InfoServer-Map, Shared-Gnr, Web-PassWeb, Common-GUI, Common-Tps, Complaints-Ancillary, Info-Tps, Legacy-Shared, Map-AddrMatch, Cmn-Ancillary, Test-Compression, OPS-Dispatch, Pass-Lib, Pass-Booking, Pass-Schedule

Description: Master List of Points of interests and their addresses for assigning pick-up, drop-off, stops, polygons, etc.

Field Documentation
LocId Numeric identifier of a location.
LocName Name of the location.
LocType Numeric identifier of the location type (from the LocationTypes table).
LoadTime Time in seconds required to load a passenger at the location.
UnloadTime Time in seconds required to unload a passenger at the location.
Comments Comments about the record.
SiteName Name of the location address.
StreetNum Numeric value of the street number of the location's address.
StreetNo Alphanumeric value of the street number of the location's address.
OnStreet Street name of the location's address.
AtStreet Cross-street or intersection closest to the location's address.
Unit Unit number of the location's address.
City City of the location's address.
State State of the location's address.
ZipCode Zip code or postal code of the location's address.
AddressSummary UK use only.
ZoneCode UK use only.
MapPage Page number that the locatation of the event is on (e.g., page 12 of Perlys Maps).
Phone Phone number of the location.
Lon Longitude coordinate of the location address.
Lat Latitude coordinate of the location address.
GeoStatus Numeric value of the geocoding status for the longitude and latitude of the location address.
CellArea Map cell number (from map database mapGRID.CellNo).
SICode Deprecated.
EmplCode Deprecated.
ContactFirstName First name of the contact at the location.
ContactLastName Last name of the contact at the location.
ContactMiddleInit Middle intial of the contact at the location.
JurisPolyId Numeric identifier of the polygon where the location is found (from the Polygon table in MmsMap.dbd).
CreBy Username that created the location record.
CreDate Date the location record was created.
CreTime Time the location record was created. Value is in seconds from midnight.
ModBy Username that last modified this location record.
ModDate Date this location record was last modified.
ModTime Time this location record was last modified. Value is in seconds from midnight.
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
Soundex Soundex encoded location name for use in the IVR.
MultipleLoadFactor Value used to calculate the time it takes to load multiple clients at a specific location.
AuthorizationNo Authorization number for the location edit.
PictureFile File path of the picture displaying the location.
VehicleTypeExclusions Vehicle types to be excluded at this location.
DateIntervalId Numeric identifier of the date interval record that specifies the dates when the location is valid (e.g., Weekends, Holidays, Weekdays) (from the DateIntervals table).
AccessibilityInfo Comma-delimited string of AccessibilityAbbrs (from the AccessibilityTypes table).
StopId Numeric identifier of the stop where the clients are picked up or dropped off to get to this location (from the Stops table).
Alert Flag that indicates whether the client has any alerts.
InActive Flag that indicates whether a location is active (0 = active, 1 = inactive).
RestrictedAccess Specifies whether a location is restricted or not in its accessability.
ResourceSite A site that can be used for resources.