CSV File Download

Contact Customer Service About Any Questions

If you have any questions or would like the CSV File Download enabled for your account, please call (888) 411-9661 between 9:00 AM and 6:00 PM EST Monday through Friday. Access to this feature is disabled by default. It is only available to Carrier411 customers with an active account, and it is not available for trial accounts. This optional add-on feature can be enabled for an additional $49.00 per month. Carrier411 reserves the right to allow access to the CSV File Download feature.


Welcome to the developer documentation for our CSV File Download feature.


If you monitor thousands of carriers, then you know how time-consuming it can be to update records in your transportation software. Consider the consequences if you overlook updating certain carriers. Integration with Carrier411 using our CSV File Download feature can automate the update process, save you valuable time, improve efficiency, and help protect your business from using the wrong carriers.


As an alternative to our more robust Web Services Interface, we can provide access to a comma-separated values (CSV) file that gets created on demand.


Compared to accessing data with our Web Services Interface, our CSV File Download feature provides an easier (but more limited) way to access critical information about all the companies monitored by your Carrier411 account. Carrier411 CSV file data provides the current authority status, insurance, carrier safety ratings and Safety Measurement System (SMS) information for you to integrate with your transportation software. Again, it does this for all the companies being monitored by your Carrier411 account. SafeStat scores are no longer available and have been replaced with SMS BASIC scores.


In simple terms, your server communicates with our server. By scheduling one daily request to our CSV File Download feature, your software system can keep its database up-to-date automatically within a matter of seconds.


You can also obtain information about the companies you monitor that have FreightGuard reports using our FreightGuard Reports CSV File Download. Learn more about our integrated FreightGuard Reporting System.


CSV File Download Change Log

Change Log Description
December 7, 2014 Added FreightGuard Reports CSV File Download to provide information about FreightGuard reports that have been submitted and released for all companies monitored by your account. The FreightGuard Reports CSV File is downloaded separately from the CSV file that provides compliance and safety information about the companies you monitor.

How to Initiate CSV File Download

First, you must have an active Carrier411 account, and the CSV File Download feature must be enabled for your account. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically. CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.


Information about FreightGuard reports can be downloaded separately using our FreightGuard Reports CSV File Download.


URL String

http://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy

Substitute xxx with your Carrier411 username and yyy with your password.

Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default.

Schedule Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST. Schedule this event every Monday through Friday morning. Do not download in the evening or night, because data is updated in the early morning.
Purpose Creates comma-separated values (CSV) file upon request.
Includes data (detailed below) for all the companies monitored by your Carrier411 account.
Errors

Any errors will produce a FaultCode when the URL string is invoked.

FaultCode 1: Username and password not provided.

FaultCode 2: Username not provided.

FaultCode 3: Password not provided.

FaultCode 4: Invalid username or password.

FaultCode 5: Account inactive.

FaultCode 6: Account suspended.

FaultCode 7: Trial accounts cannot download CSV files.

FaultCode 8: CSV file download not activated for account.

Parameters

username -- Carrier411 username (Required).

password -- Carrier411 password (Required).

header -- 1 or 0 (Optional). Include &header=0 for no header row.

oos -- 1 or 0 (Optional). Include &oos=1 for out of service data.

safety -- 1 or 0 (Optional). Include &safety=1 for additional carrier safety rating data.

census -- 1 or 0 (Optional). Include &census=1 for additional census data.

Please refer to the Optional URL Parameters and Possible Values section for more information.


CSV File Fields and Possible Values

The following 56 fields and possible values are contained in the CSV file. View Sample CSV File with Header Row.


1.  DOCKET CHAR 8
This is the motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers.
2.  USDOT NUMERIC 9
This is the USDOT number for the carrier. Values may include 0 or NULL.
3.  LEGALNAME VARCHAR 120
This is the legal name of the company.
4.  DBANAME VARCHAR 60
This is the doing-business-as (dba) name for the company.
5.  ADDRESS VARCHAR 50
This is the business address for the company.
6.  CITY VARCHAR 30
This value is the city for the business address specified in ADDRESS.
7.  STATE CHAR 2
This value is the 2-character state for the business address specified in ADDRESS.
8.  ZIP VARCHAR 10
This value is the zip code for the business address specified in ADDRESS. Most zip codes are 5 digits. Some are zip plus 4. Others are international postal codes.
9.  PHONE VARCHAR 14
This value is the 10-digit business phone number if provided. The value may be NULL.
10.  FAX VARCHAR 14
This value is the 10-digit business fax number if provided. The value may be NULL.
11.  EMAIL VARCHAR 80
Possible Values: NULL or text. This is the company's email address.
12.  TRUCKS VARCHAR 6
Possible Values: NULL or numeric value. This value indicates the total number of "Power Units" operated by the carrier.
13.  COMMON CHAR 1
This value describes the company's common carrier authority status. There are three possible values: "A" for active common authority, "I" for inactive common authority or "N" for no common authority.
14.  CONTRACT CHAR 1
This value describes the company's contract carrier authority status. There are three possible values: "A" for active contract authority, "I" for inactive contract authority or "N" for no contract authority.
15.  BROKER CHAR 1
This value describes the company's broker authority status. There are three possible values: "A" for active broker authority, "I" for inactive broker authority or "N" for no broker authority.
16.  PENDCOMMON CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for common carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
17.  PENDCONTRACT CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for contract carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
18.  PENDBROKER CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for broker authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
19.  REVCOMMON CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its common carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes does not mean they have lost their common carrier authority. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised.
20.  REVCONTRACT CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its contract carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised.
21.  REVBROKER CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its broker authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of the premium being due for its broker bond, and it remains unpaid. However, there are other reasons this warning flag may get raised.
22.  BIPDREQ VARCHAR 10
BIPD is bodily injury property damage, more commonly known as liability insurance. If BIPD is required by the FMCSA, the minimum dollar amount of required coverage will be specified. If required, the minimum amount is usually 750000 ($750,000.00), but it could be higher. It could also be 0 (zero), if BIPD is not required. FMCSA requires companies with contract authority to have BIPD insurance.
23.  BIPDFILED VARCHAR 10
This value indicates the dollar amount of liability insurance on file for the company, as reported to the FMCSA by insurance underwriters. Even though BIPD insurance may not be required, some companies will maintain a BIPD insurance policy.
24.  CARGOREQ CHAR 1
This value indicates whether the FMCSA requires the company to have cargo insurance. There are two possible values: "Y" for yes or "N" for no.
25.  CARGOFILED CHAR 1
This value indicates whether cargo insurance is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no. Even though cargo insurance may not be required, some companies will maintain a cargo insurance policy.
26.  BONDREQ CHAR 1
Possible Values: Y or N. This value indicates whether the FMCSA requires the company to have a bond. There are two possible values: "Y" for yes or "N" for no. FMCSA requires companies with broker authority to maintain a bond.
27.  BONDFILED CHAR 1
Possible Values: Y or N. This value indicates whether a broker bond is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no.
28.  INSAUTHUPDATED DATETIME
This the mm/dd/yyyy date that insurance and authority information about the company was last updated in our database.
29.  RATING CHAR 1
Possible Values: NULL or single letter. This is the carrier safety rating. There are three possible safety ratings: U = Unsatisfactory, C = Conditional, S = Satisfactory. The safety rating was issued on the date specified in RATEDATE.
30.  RATEDATE DATETIME
Possible Values: NULL or date. If the carrier has a carrier safety rating value specified in RATING, this is the date the safety rating was issued formatted as mm/dd/yyyy. If the carrier has no safety rating, the value will be NULL.
31.  INSPTOTAL NUMERIC 9
Possible Values: NULL or number. Total number of inspections for the 24-month measurement period.
32.  DRIVINSPTOTAL NUMERIC 9
Possible Values: NULL or number. Number of driver inspections.
33.  DRIVOOSINSPTOTAL NUMERIC 9
Possible Values: NULL or number. Number of driver inspections with at least one driver out-of-service violation.
34.  VEHINSPTOTAL NUMERIC 9
Possible Values: NULL or number. Number of vehicle inspections.
35.  VEHOOSINSPTOTAL NUMERIC 9
Possible Values: NULL or number. Number of vehicle inspections with at least one vehicle out-of-service violation.
36.  UNSAFEDRIVPCT REAL 4
Possible Values: NULL or number. This value is the unsafe driving BASIC roadside performance percentile (SMS BASIC score for unsafe driving). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
37.  UNSAFEDRIVRDALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the UNSAFEDRIVPCT score is over the threshold.
38.  UNSAFEDRIVSV CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for unsafe driving within the past 12 months.
39.  UNSAFEDRIVBASICALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the UNSAFEDRIVPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
40.  FATIGUEDRIVPCT REAL 4
Possible Values: NULL or number. This value is the fatigued driving (hours of service) BASIC roadside performance percentile (SMS BASIC score for fatigued driving). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. NOTE: In December 2012 the FMCSA changed the name of the "Fatigued Driving" BASIC category to "Hours of Service (HOS) Compliance". Depsite the FMCSA name change for this category, we left the FATIGUEDRIVPCT name unchanged.
41.  FATIGUEDRIVRDALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the FATIGUEDRIVPCT score is over the threshold. NOTE: In December 2012 the FMCSA changed the name of the "Fatigued Driving" BASIC category to "Hours of Service (HOS) Compliance". Depsite the FMCSA name change for this category, we left the FATIGUEDRIVRDALERT name unchanged.
42.  FATIGUEDRIVSV CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for fatigued driving within the past 12 months. NOTE: In December 2012 the FMCSA changed the name of the "Fatigued Driving" BASIC category to "Hours of Service (HOS) Compliance". Depsite the FMCSA name change for this category, we left the FATIGUEDRIVSV name unchanged.
43.  FATIGUEDRIVBASICALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the FATIGUEDRIVPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. NOTE: In December 2012 the FMCSA changed the name of the "Fatigued Driving" BASIC category to "Hours of Service (HOS) Compliance". Depsite the FMCSA name change for this category, we left the FATIGUEDRIVBASICALERT name unchanged.
44.  DRIVFITPCT REAL 4
Possible Values: NULL or number. This value is the driver fitness BASIC roadside performance percentile (SMS BASIC score for driver fitness). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
45.  DRIVFITRDALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the DRIVFITPCT score is over the threshold.
46.  DRIVFITSV CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for driver fitness within the past 12 months.
47.  DRIVFITBASICALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the DRIVFITPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
48.  CONTRSUBSTPCT REAL 4
Possible Values: NULL or number. This value is the controlled substances and alcohol BASIC roadside performance percentile (SMS BASIC score for controlled substances). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
49.  CONTRSUBSTRDALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the CONTRSUBSTPCT score is over the threshold.
50.  CONTRSUBSTSV CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for controlled substances within the past 12 months.
51.  CONTRSUBSTBASICALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the CONTRSUBSTPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
52.  VEHMAINTPCT REAL 4
Possible Values: NULL or number. This value is the vehicle maintenance BASIC roadside performance percentile (SMS BASIC score for vehicle maintenance). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
53.  VEHMAINTRDALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the VEHMAINTPCT score is over the threshold.
54.  VEHMAINTSV CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for vehicle maintenance within the past 12 months.
55.  VEHMAINTBASICALERT CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the VEHMAINTPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
56.  CREATED DATETIME
This the mm/dd/yyyy date that CSV file was created.

Optional URL Parameters and Possible Values

The following fields and possible values are contained in the CSV file depending on whether optional paramaters are included in the URL string.


URL String

http://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy&header=1&oos=1&safety=1&census=1

Substitute xxx with your Carrier411 username and yyy with your password.

Parameters

header -- 1 or 0 (Optional). Include &header=0 for no header row.

oos -- 1 or 0 (Optional). Include &oos=1 for out of service data.

safety -- 1 or 0 (Optional). Include &safety=1 for additional carrier safety rating data.

census -- 1 or 0 (Optional). Include &census=1 for additional census data.


OOSORDER CHAR 1
OOSORDER field is returned when &oos=1 is included in the URL string. Possible Values: Y or N. This value describes whether the carrier has an Out of Service (OOS) Order. There are two possible values: "Y" for yes or "N" for no. When an Out of Service (OOS) Order is issued by the FMCSA, the carrier is ordered to cease all motor vehicle operations regardless of operating authority status. Any carrier that has an Out of Service (OOS) Order should not be used until the FMCSA rescinds the OOS order. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.
OOSORDERDATE DATETIME
OOSORDERDATE field is returned when &oos=1 is included in the URL string. Possible Values: NULL or date. If the carrier has an Out of Service (OOS) Order, this is the out of service "date" formatted as mm/dd/yyyy. The OOS date indicates when our system detected the order and is not necessarily the date the order was issued. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.
SAFETYREVTYPE CHAR 1

SAFETYREVTYPE field is returned when &safety=1 is included in the URL string.

Possible Values: NULL or single letter. This is the type of review conducted.


  • C = Compliance Review
  • N = Non-Ratable Review
  • S = Safety Review
  • E = Educational Contact Review
  • U = Historical Audit Record
  • G = Compliance Review and CTFR
  • H = Shipper Review
  • A = Safety Audit
  • B = Automatic Safety Assessment Program Review
  • F = CTFR
  • I = Carrier Inactive
  • J = Compliance Review and Security Contact Review

This code represents a federally conducted or state conducted review of a carrier's/shipper's compliance with the Federal Motor Carrier Safety and Hazardous Material Regulations. These reviews result in the carrier receiving a Federal safety rating of Satisfactory, Unsatisfactory or Conditional. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.

SAFETYREVDATE DATETIME
SAFETYREVDATE field is returned when &safety=1 is included in the URL string. Possible Values: NULL or date. If the carrier has a safety rating, this is the safety rating "review date" formatted as mm/dd/yyyy. The review date is always earlier than the safety rating date in SAFETYRATEDATE.It is based on the safety review that the carrier is assigned a safety rating. If the carrier has no safety rating, the SAFETYREVDATE value would be NULL because there was no safety review. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.
CENSUSTOTDRS VARCHAR 6
CENSUSTOTDRS field is returned when &census=1 is included in the URL string. Possible Values: NULL or numeric value. This value indicates the total number of "Drivers" working for the carrier.
CENSUSMCS150DATE DATETIME
CENSUSMCS150DATE field is returned when &census=1 is included in the URL string. Possible Values: NULL or Date formatted as mm/dd/yyyy. This is the date the carrier filed its most recent MCS-150 form with the FMCSA. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.
CENSUSMCS150MILEAGEYEAR INTEGER 4
CENSUSMCS150MILEAGEYEAR field is returned when &census=1 is included in the URL string. Possible Values: NULL or 4-digit year. This is the year for reported "Mileage" on the MCS-150 form. Even though there is census data and a year value exists for CENSUSMCS150DATE, this field may be NULL. This value is associated with the "Mileage" indicated in CENSUSMLG150. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.
CENSUSMLG150 INTEGER 4
CENSUSMLG150 field is returned when &census=1 is included in the URL string. Possible Values: NULL or number. This is reported "Mileage" on the MCS-150 form. Even though there is census data and a year value exists for CENSUSMCS150DATE, this field may be NULL. This value is associated with the CENSUSMCS150MILEAGEYEAR value. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file.


FreightGuard Reports CSV File Download

In addition to downloading information about the companies you monitor using the CSV File Download feature (documented above), you can also obtain and maintain information about the companies you monitor that have FreightGuard reports.


The Carrier411 website has an integrated FreightGuard Reporting System that lets members report companies (carriers, brokers, freight forwarders) for performance issues based on a variety of designated criteria:


  • • In-transit agreement modification
  • • Operates under alias
  • • Cancelled after accepting load
  • • Persistent cancelling
  • • Unresolved claim issues
  • • Unethical or deceptive business practices
  • • Repeated pickup or delivery service failures
  • • Fraudulent activity
 
  • • Held load hostage
  • • Operates without bond or trust fund
  • • Brokers freight without broker or FF authority
  • • Payment issues
  • • No show and no call
  • • Unauthorized re-brokering of shipment
  • • Back-solicited shipper
  • • Theft or unjustified loss of freight

FreightGuard report information can be obtained and maintained using the FreightGuard Reports CSV File Download. Information provided in FreightGuard reports are solely the opinions of members and not necessarily the opinions of Carrier411.


The FreightGuard Reports CSV File identifies all companies monitored by your Carrier411 account that have FreightGuard reports. To maintain accurate information in your TMS software database about companies with FreightGuard reports, initiate the FreightGuard Reports CSV File Download one time each day in the morning.


Before you process data returned by the FreightGuard Reports CSV File Download, we suggest you reset or clear all FreightGuard report information in your TMS Software database for all companies that previously had FreightGuard reports; then you can process the data returned by the FreightGuard Reports CSV File Download. Because FreightGuard reports are submitted, released, edited, updated, and deleted every day, clearing any existing FreightGuard report information before processing data returned by the FreightGuard Reports CSV File Download is the only way you can maintain accurate FreightGuard report information.


How to Initiate FreightGuard Reports CSV File Download

You must have an active Carrier411 account, and the CSV File Download feature must be enabled. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically. CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.


URL String

http://www.carrier411.com/createfgcsvfile.cfm?username=xxx&password=yyy

Substitute xxx with your Carrier411 username and yyy with your password.

Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default.

Schedule Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST.
Purpose Creates comma-separated values (CSV) file upon request.
Includes data (detailed below) for all the companies monitored by your Carrier411 account that have FreightGuard reports submitted about them.
Errors

Any errors will produce a FaultCode when the URL string is invoked.

FaultCode 1: Username and password not provided.

FaultCode 2: Username not provided.

FaultCode 3: Password not provided.

FaultCode 4: Invalid username or password.

FaultCode 5: Account inactive.

FaultCode 6: Account suspended.

FaultCode 7: Trial accounts cannot download CSV files.

FaultCode 8: CSV file download not activated for account.

FaultCode 9: No registered companies have FreightGuard reports.

Parameters

username -- Carrier411 username (Required).

password -- Carrier411 password (Required).

header -- 1 or 0 (Optional). Include &header=0 for no header row.


FreightGuard Reports CSV File Fields and Possible Values

The following 35 fields and possible values are contained in the FreightGuard reports CSV file. View Sample FreightGuard Reports CSV File with Header Row.


1.  DOCKET CHAR 8
This is the motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers.
2.  AGREEMENT CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "In-transit agreement modification".
3.  AGREEMENTCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "In-transit agreement modification" based on all FreightGuard reports submitted about company.
4.  ALIAS CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Operates under alias".
5.  ALIASCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Operates under alias" based on all FreightGuard reports submitted about company.
6.  CANCELLED CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Cancelled after accepting load".
7.  CANCELLEDCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Cancelled after accepting load" based on all FreightGuard reports submitted about company.
8.  CANCELLING CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Persistent cancelling".
9.  CANCELLINGCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Persistent cancelling" based on all FreightGuard reports submitted about company.
10.  CLAIMS CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unresolved claim issues".
11.  CLAIMSCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Unresolved claim issues" based on all FreightGuard reports submitted about company.
12.  ETHICS CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unethical or deceptive business practices".
13.  ETHICSCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Unethical or deceptive business practices" based on all FreightGuard reports submitted about company.
14.  FAILURES CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Repeated pickup or delivery service failures".
15.  FAILURESCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Repeated pickup or delivery service failures" based on all FreightGuard reports submitted about company.
16.  FRAUD CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Fraudulent activity".
17.  FRAUDCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Fraudulent activity" based on all FreightGuard reports submitted about company.
18.  HOSTAGE CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Held load hostage".
19.  HOSTAGECOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Held load hostage" based on all FreightGuard reports submitted about company.
20.  NOBOND CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Operates without bond or trust fund".
21.  NOBONDCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Operates without bond or trust fund" based on all FreightGuard reports submitted about company.
22.  NOLICENSE CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Brokers freight without broker or FF authority".
23.  NOLICENSECOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Brokers freight without broker or FF authority" based on all FreightGuard reports submitted about company.
24.  NONPAYMENT CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Payment issues".
25.  NONPAYMENTCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Payment issues" based on all FreightGuard reports submitted about company.
26.  NOSHOW CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "No show and no call".
27.  NOSHOWCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "No show and no call" based on all FreightGuard reports submitted about company.
28.  REBROKER CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unauthorized re-brokering of shipment".
29.  REBROKERCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Unauthorized re-brokering of shipment" based on all FreightGuard reports submitted about company.
30.  REPORTS NUMERIC 9
Possible Values: Numeric value representing total number of FreightGuard reports submitted about company.
31.  SOLICITED CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Back-solicited shipper".
32.  SOLICITEDCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Back-solicited shipper" based on all FreightGuard reports submitted about company.
33.  THEFT CHAR 1
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Theft or unjustified loss of freight".
34.  THEFTCOUNT NUMERIC 9
Possible Values: Numeric value representing total number of times company has been reported for "Theft or unjustified loss of freight" based on all FreightGuard reports submitted about company.
35.  CREATED DATETIME
This the mm/dd/yyyy date that CSV file was created.