Tcore Carrier Watch Types Schema
This schema defines a set of standard type definitions for general use by other DAT CarrierWatch schema.
Published: Feburary, 2010
Version : 1.0.0
Copyright (C) 2010, TransCore LP, All Rights Reserved.
DAT's own carrier identifier
Best available legal business name.
Best available commonly used business name.
DOT Identification Number of the carrier.
DUNS Number, when available.
When available, the Standard Carrier Alpha Code (SCAC) is a unique code used to identify transportation companies.
The best and last available physical address.
The best and last available mailing address.
DOT Profile of the carrier queried.
The last date on which the DOT updated their profile for this carrier.
Indicates whether or not the carrier is still operating or not. If not,
no other data will be provided in this section.
The DOT classification for the type of company this is.
- Carrier
- Shipper
- Registrant
- Carrier & Shipper
Abnormal values may be:
- Intermodal Equipment Provider
- New Entrant Status
Identifies the carrier as being engaged in interstate, intrastate hazardous
material, or intrastate non-hazardous material transport activities.
- Interstate
- Intrastate Only (HM)
- Intrastate Only (Non-HM)
The date the carrier went out of Interstate service. Only provided if the carrier is out of service.
The number of power units operated by the carrier.
The number of drivers employed and contracted by the carrier.
Mileage year from the MCS-150 Registration Form.
Date from the MCS-150 Registration Form.
Mileage from the MCS-150 Registration Form.
Commodities handled by the carrier.
Free form text containing a description of commodities not covered in
the standard DOT commodity list.
Describes a type of insurance carried by this carrier.
An element will be included for each of the insurance types
carried by the carrier (possibly up to 5 types).
Included only if the 'includeDotInsurance' flag is specified.
Describes the mandated insurance coverage filed with the FMSCA.
This will include Primary BIPD insurance for all carriers
(Form BMC-91). It may include excess BIPD insurance if applicable
(Form BMC-91X). Common carriers are also required to file evidence
of cargo coverage (Form BMC-34). If the entity has brokerage
authority, this section will also include details of the broker
bond (Form BMC-84) or trust fund (Form BMC-85).
- BIPD: Bodily Injury and Personal Damage, required for all carriers.
- Cargo: Cargo coverage, required for common carriers.
- Bond: Broker bond.
- Trust: Trust fund.
Brokers must provide evidence of a bond or trust fund. Either is
acceptable. Each element will only be present if the target
carrier also holds brokerage authority under the same MC (docket number).
The last date on which the DOT's insurance records for this carrier were updated.
The DOT insurance records provided by the DOT.
DOT docket prefix and number. (MC, MX, or FF numbers);
Docket Prefix. Not avaliable in the first release.
Docket Number of the company.
The state the carrier is authorized to operate within.
The state's assigned operating code for this carrier.
Provides DOT authority and insurance requirements.
Only included if the DOT Authority is selected for download and the carrier has a known docket number.
The last date on which the DOT updated their authority information for this carrier.
Common authority for the carrier.
Indicates whether or not common authority is pending.
Indicates whether or not common authority may be revoked in the near future.
Contract authority for the carrier.
Indicates whether or not contract authority is pending.
Indicates whether or not contract authority may be revoked in the near future.
Broker authority for the carrier.
Indicates whether or not broker authority is pending.
Indicates whether or not broker authority may be revoked in the near future.
Indicates whether or not the carrier is authorized for freight.
Indicates whether or not the carrier is authorized to carry passengers.
Indicates whether or not the carrier is authorized to carry
household goods.
The amount of BIPD coverage this carrier is required to have.
Indicates whether this carrier is required to file form BMC-34 showing
evidence of cargo coverage.
Indicates whether this carrier is required to file form BMC-84 or 85
showing evidence of a broker bond or equivalent trust fund.
The amount of BIPD coverage on file. Coverage details will be available
in the active/pending insurance section.
Indicates whether this carrier has filed form BMC-34 showing evidence of
cargo coverage.
Indicates whether this carrier has also filed form BMC-84 or 85 showing
evidence of a broker bond or trust fund.
If true, coverage details will be in the active/pending insurance
section.
DOT provided insurance data on the company.
BIPD, Cargo, Trust, or Bond
If insuranceType = BIPD this element indicates whether the following
coverage details are for primary coverage or excess coverage.
For other insurance types, this element will be omitted.
34 = Cargo
91,91X = BIPD
82 = BIPD (Surety Bond)
83 = Cargo (Surety Bond)
84 = Property Brokers Surety Bond
85 = Property Brokers Trust Fund Agreement
The insurance policy number.
Indicates the lower limit of the coverage. Usually zero except for
Excess BIPD insurance.
Indicates the upper limit of the coverage.
Date this insurance policy became effective.
Date this insurance policy was canceled.
The contact information for the insurance carrier.
A unique identifier provided by Volpe.
Insurance company name.
Insurance company contact name.
Insurance company address.
Note that there are instances of incorrect registration data, in which
the postal code is not of the proper format for the designated country
code.
Describes a certification of insurance carried by the carrier.
The last date on which the insurance certificate for this carrier was updated
The maximum coverage limit in the cargo insurance.
Describes cargo coverage carried by the carrier.
Describes an insurance certificate
The type of category this certificate falls under: CARGO, AUTO, GENERAL, WORKERS_COMP, or OTHER.
OTHER may occur multiple times, but the others will occur only once.
The full name provided by the insurance company that describes the type of coverage.
The date on which this policy went into or is going into effect.
The date on which this policy will expire.
The date on which this policy will be canceled.
High or Low.
The confidence level that the DAT will be informed promptly of any changes to this policy by the insurance carrier.
The policy number of the policy.
Issuing insurance agent.
Contact number of the insurance agent.
Fax number of the insurance agent.
The company that is underwriting the policy.
Deprecated. This field is no longer used.
Deprecated. This field is no longer used.
The last date on which this certificate was updated.
Indicates if this certificate represents scheduled autos.
This field is only provided for AUTO coverage categories.
A verbal description of the details on this certificate.
A link to the image of the insurance certificate. Note: In some cases,
DAT may have insurance certificate information but not an
image of the certificate.
Describes the limits on the coverage
Free-form description of a limit on the coverage
Coverage limit (in US or Canadian dollars).
FMCSA Safety Rating of the carrier queried.
Provided when Safety is selected for download.
Date of the most recent FMCSA safety rating.
Most recent FMCSA Rating.
If this element is not included, no safety record was found.
Note: there are a very large number of carriers that do not have a safety
rating. Lack of a safety rating should not be construed as a negative
mark against the carrier.
The date the rating was assigned.
Indicates the type of review that resulted in the most recent rating.
For more detailed information regarding the reviews go to
http://safer.fmcsa.dot.gov/saferhelp.aspx#SafetyRating
The date on which the review occurred.
FMCSA Inspection data on the carrier.
Provided when Safety is selected for download.
Date of the most recent FMCSA inspection data.
Total number of inspections for this carrier in the last 24 months.
May be less than the sum of vehicle, driver, and hazmat inspections.
Vehicle inspections for this carrier in the last 24 months. Levels 1+2+5.
Driver inspections for this carrier in the last 24 months. Levels 1+2+3.
Hazmat inspections for this carrier in the last 24 months.
Levels 1+2+3+4+5 when HazMat is present.
FMCSA Crash data on the carrier.
Provided when Safety is selected for download.
Date of the most recent FMCSA inspection data.
Number of crashes for this carrier in the last 24 months that resulted in
a fatality. May not be provided after CSA2010. May only provide
crashesFatalOrInjury
.
Number of crashes for this carrier in the last 24 months that resulted in
an injury. May not be provided after CSA2010. May only provide
crashesFatalOrInjury
.
Number of crashes for this carrier in the last 24 months that resulted in
an injury or a fatality.
Number of crashes for this carrier in the last 24 months that resulted in
the vehicle being towed.
Number of crashes for this carrier in the last 24 months that involved
hazardous materials.
FMCSA SafeStat on the carrier queried.
A number of these ratings are quite unusual, so they will only be included
when the score is non-zero.
Provided when Safety is selected for download.
The date of the most recent SafeStat update. All numbers provided in
this section are accurate as of this date.
Safestat recalculates SEA Values every month.
Most recent SEA_Driver score for this carrier provided by SafeStat.
Ranges from 0 (best) to 100 (worst). Expect 2 decimal places. A SEA
with a value from 75 to 100 is defined as deficient.
This element will be omitted if the score is 0.
Most recent SEA_Vehicle score for this carrier provided by SafeStat.
Ranges from 0 (best) to 100 (worst). Expect 2 decimal places. A SEA
with a value from 75 to 100 is defined as deficient.
This element will be omitted if the score is 0.
Most current SEA_Management score for this carrier provided by SafeStat.
SEA values range from 0 (best) to 100 (worst). Expect 2 decimal places.
A SEA with a value from 75 to 100 is defined as deficient.
This element will be omitted if the score is 0.
Additional data gathered from the Carrier by DAT.
The date of the most recent update to the extended profile.
Provides general information about the carrier.
This element will be included when selected in the customer's options.
The name of the owner, CEO, or chief officer of the company.
Title of the principal of the company.
Name of the first person you should contact in the company.
Name of the first person you should contact in the company.
Name of the first person you should contact in the company.
Contact email address.
Company website URL.
Year the company was founded.
Indicates that the company is owned by a woman. False if
omitted.
Indicates that the company is owned by a minority. False if
omitted.
Describes the equipment and personnel of the carrier.
This element will be included when selected in the customer's options
The type of satellite tracking the carrier has.
The number of driver teams the company has.
False if omitted.
False if omitted.
False if omitted.
False if omitted.
False if omitted.
False if omitted.
False if omitted.
False if omitted.
Identifies how many of each type of truck a carrier has.
The DAT numeric identifier for this truck.
Textual description of the truck.
The number of this type of truck.
Data on services provided by the carrier.
Provided when Services is selected.
Free form text description of any special services provided.
Indicates if carrier can handle overweight loads. False if ommitted.
Indicates if carrier can handle extra long loads. False if ommitted.
Indicates if carrier can handle extra wide loads. False if ommitted.
Indicates if carrier can handle EDI. False if ommitted.
Indicates if the carrier is a reponsible care carrier. False if omitted.
Indicates if the carrier has garment hanging. False if omitted.
Indicates if the carrier has spotted trailers. False if omitted.
Indicates if the carrier does trailer exchange. False if omitted.
Indicates if the carrier does pallet exchange. False if omitted.
Indicates if the carrier provides drayage service. False if omitted.
Indicates if the carrier has warehousing. False if omitted.
Indicates if the carrier has LTL. False if omitted.
Indicates if the carrier will make multiple stops. False if omitted.
Indicates if the carrier deals with Parcels. False if omitted.
Indicates if the carrier hauls Alcohol. False if omitted.
Indicates if the carrier hauls Cigarettes. False if omitted.
Indicates if the carrier hauls Electronics. False if omitted.
Indicates if the carrier hauls Ammunition or Explosives. False if omitted.
Indicates if the carrier hauls Cosmetics. False if omitted.
Indicates if the carrier hauls Cosmetics. False if omitted.
Indicates if carrier can handle Hazardous Materials.
Identifies areas that the carrier operates within.
Description of a CarrierWatch watch-list entry.
Indicates if the carrier is CSA approved. False if omitted.
Indicates if the carrier is FAST certified. False if omitted.
Indicates if carrier provides service to Mexico. False if ommitted.
The states and provinces that the carrier normally operates in.
The lanes that a carrier normally operates within.
Description of a lane that a carrier normally operates within.
The starting point of the lane.
The ending point of the lane.
Description of an endpoint on a lane. Made up of a state or province and sometimes a metro area.
The state or province of the end point.
If one is specified, the metropolitan area of the end point.
The numeric code reserved for this metropolitan area.
The name describing this metropolitan area.
Information to identify the carrier to be added to the watchlist.
The broker's unique identifier for the carrier. Cannot have |, tabs, or line breaks.
1=watch authority and safety or 2=watch authority, safety and insurance.
Defaults to level of subscription (Basic=1, Full=2).
Customer's notes on the carrier. Cannot have |, tabs, or line breaks.
DOT Identification Number of the carrier.
Any and all phone numbers for the carrier.
The street address of the carrier
The city of the carrier.
The state code of the carrier.
The state code of the carrier.
The person to contact at the carrier's business.
Description of a CarrierWatch watch-list entry.
15 characters - customer's TMS id for the carrier. Cannot have |, tabs, or line breaks.
1=watch authority and safety or 2=watch authority, safety and insurance
Customer's notes on the carrier. Cannot have |, tabs, or line breaks.
Enumerated list of insurance types.
Enumerated list of insurance classes.
Enumerated list of authority statuses (Common Authority, Contract Authority,
etc.
FMCSA Inspections in the last 24 months.
Total number of inspections.
Number of those inspections for which the driver or vehicle was
pulled out of service.
Enumerated list of recognized commodities.
Provides the CSA 2010 Safety Fitness determinations.
The last date on which the Csa 2010 Safety Fitness was updated.
Text describing CSA 2010 intervention activity on the carrier.
This will replace safety ratings and is calculated by FMCSA using the basic scores.
Provides CSA 2010 Basic Measurements
The last date on which the Csa 2010 Basic Measurements was updated.
Insurance/Other BASIC Serious Violation Indicator (true = Serious Violation from investigation within previous 12 months)
Insurance/Other BASIC Indicator (true = Serious Violation within previous 12 months)
The basic carrier safety measurements.
The types of FMCSA measurements: 'Unsafe Driving', 'Fatigued Driving', 'Driver Fitness', 'Controlled Substance and Alcohol',
'Vehicle Maintenance', or 'Cargo Related'. If no data is available for a type, that type will not be provided.
The decimal measurement for the type, with 2 places after the decimal.
The percentile for the type, with 1 place after the decimal.
The number of inspections resulting in violation of the basic.
BASIC Roadside Performance Over Threshold Indicator (Over Intervention Threshold)
BASIC Serious Violation Indicator (Serious Violation within previous 12 months)
BASIC Indicator (Roadside Performance Percentile over threshold and/or Serious Violation within previous 12 months)
Best available phone number corresponding to the address.
Best available toll free phone number corresponding to the address.
Best available Fax number corresponding to the address.
Street refers to a street name, which is an identifying name given to a street.
The street name forms part of the address.
It's a String 0-200 character.
City refers to a city name, which is a relatively large and permanent settlement.
It's a String with 0-50 character.
The DOT does not always supply a state, particularly for carriers located
in Mexico.
North American Postal Codes
- Canada: LNL NLN
- Mexico: NNNNN
- US ZIP: NNNNN(-NNNN)
The DOT does not always supply a postal code, particularly for carriers located
in Mexico.
Based on two-letter ISO 3166 country codes for countries supported by DAT.
This is a 2-character String.
The warning level and messages on a carrier by the broker's warning levels. If no evaluations are
provided, the business is not a carrier and was not evaluated.
A full evaluation for a specific category, containg the rating and any messages explaining issues.
The category (OVERALL, DOT, AUTHORITY, SAFETY, or CSA) that the level and messages are for.
The rating level given the category.
The textual messages identifying any issues.
The different rating levels that may be returned.
Used by brokers to identify the level of scrutiny used when matching a brokers data to a carrier
in the DAT Registry.
Number given when DOT# is matched (default 4).
Number given when docket is matched (default 4).
Number when the intrastate code is matched (default 3).
Number given when the street address is matched (default 3).
Number when the city name is matched (default 0).
Number given when the 2 character state code is matched (default 0).
Number given when postal code is matched (default 1).
Number given when any one of the phone numbers provided is matched (default 2).
The minimum value that sum of all matched values must meet or exceed before any match
is accepted (default 5).
Motor Carrier (MC) number.
The action to be taken when a broker provided carrier can not be matched to a carrier in the DAT Registry.
The failed insert requests that broker's make to add a carrier to their watchlist.
Information to identify the carrier to be added to the watchlist.
The possible reason why this request could not be matched to a carrier.