Providers

Name: Providers

Type: Ancillary, Application

Modules: Booking, Scheduling, Faring

Description: Main table for provider information. Contacts and conditions

Field Documentation
ProviderId Numeric identifier of the provider.
ProviderName Name of the provider (e.g., CNIB).
Description Description of the provider (e.g., Canadian National Institute for the Blind).
FAX Fax number of the provider.
ContactFirstName First name of the contact person at the provider.
ContactLastName Last name of the contact person at the provider.
ContactMiddleInit Middle intial of the contact person at the provider.
SiteName Name of the provider's building.
StreetNum Numeric street number of the provider's address.
StreetNo String value of the street number of the provider's address.
OnStreet Street name of the provider's address.
AtStreet Cross-street or intersection closest to the provider's address.
Unit Unit number of the provider's address.
City City of the provider's address.
State State of the provider's address.
ZipCode Zip code or postal code of the provider's address.
AddressSummary UK use only.
ZoneCode UK use only.
MapPage Mapping book page number on which the provider address can be found (e.g., page 10 of Perlys Maps).
Phone Phone number of the provider.
Lon Longitude coordinate of the provider's address.
Lat Latitude coordinate of the provider's address.
GeoStatus Numeric value of the geocoding status for the longitude and latitude of the provider's address.
Comments Comments about the record.
ContractStart Start date of the current contract with the provider.
ContractEnd End date of the current contract with the provider.
SecGroupName Security group name assigned to the provider for workstation user security.
ServiceAreaRule Paraservice area rule (from the ParaServiceAreaRules table).
PolyId Numeric identifier of the polygon in which the address of the provider is located (from the Polygons table in MmsMap.dbd).
TimeToRespond Deprecated.
OutputDirectory Internal use only.
CommunicationCode Internal use only.
CalculationMethod Calculation method of the provider (0 = uses a SpaceType in the CostingPassType table for a specific PassType and a flat rate for all others, 1 = uses the sum of all passenger rates, 2 = uses the most expensive passenger rate).
CostingPassType Passenger type to calculate on when CalculationMethod = 0.
FareTypeId Numeric identifier of the fare type to associate with a provider (from the FareTypes table).
ProviderCode Short code (i.e., abbreviation) assigned to the provider.
ProviderShortName Shortened version of the provider name.
ProviderTradingName Actual, full name of the provider.
ProviderLicenseNumber License number of the provider.
ProviderLicenseType License type issued by a governmental body and used by the provider.
EnquiryPhone Phone number of the provider used for enquiries.
TransportationModes String of valid transportation modes (from the TransportationModes table).
RegistrationNumber Registration number issued by a governmental body and used by the provider.
AccountNo Numeric account number used to bill trips by the provider.
UserDate1 Client supplementary data.
UserDate2 Client supplementary data.
UserDate3 Client supplementary data.
UserDate4 Client supplementary data.
UserDate5 Client supplementary data.
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserDouble3 Client supplementary data.
UserDouble4 Client supplementary data.
UserDouble5 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserLong3 Client supplementary data.
UserLong4 Client supplementary data.
UserLong5 Client supplementary data.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
InActive Flag that indicates the provider is inactive and cannot be used to transport clients.
EMailAddress E-mail address of the provider.
Penalty Adds a small amount to the fare so that the provider is less likely to be selected when scheduling trips.
NationalOperatorCode Numerical identifier of the National Operator Code for the provider.
LicenseExpiryDate Provider's license expiry date.
IsTNC Flag that indicates whether the provider is a Transportation Network Company provider.
PrepaidReq Flag that indicates whether the scheduling process will use this provider only for prepaid bookings.
AllowedSpaceTypes Comma-separated string of space types allowed for passengers (from the SpaceTypes table).