Record Layout for SCAC Data - Daily Distribution File

The SCAC Data – Daily Distribution File is available on a calendar year subscription basis transmitted either by email or sFTP (push or pull). To subscribe/purchase the SCAC Daily Distribution Service, go to scaccode.com, select Purchase Data Products, and then SCAC Data – Daily Distribution Service. Your subscription is available for delivery by email or SFTP (push or pull).

See the following for more information:

• Things to Know
• Record Layout
• Explanation of MCN Field
• Abbreviations and Primary Types of Operation
• Abbreviations and Definitions

Things to Know

• The data is generated and delivered using an extended ASCII character set encoded using UTF-8 to allow for correct foreign company names and addresses. If your database, development tools, or system does not support this extended ASCII character set, you must replace or remove the extended characters prior to importing the data. If you attempt to import the data without UTF-8 support or replace the extended ASCII character set, the fixed file format may “blow out”, since certain extended ASCII characters may be improperly translated into two characters instead of one.
• NMFTA does not recommend stripping or replacing extended characters since your data will not reflect the proper company names and addresses as we have on record, and make programmatic matches more difficult between systems. The recommended solution is to use a database and/or development tools that are capable of supporting the UTF-8 character set.
• Each file has a header record containing the file date (YYYY-MM-DD) and a trailer record containing a summary of the NEW, REN, MOD, and EXP (cancels) plus a grand total of all the records contained in the file.
  • NEW means that a new SCAC has been assigned.
  • REN means that a SCAC that was previously cancelled has been reactivated for the same company.
  • MOD means that either one or more of the following fields have been changed: Company Name, Address, City, State, Zip, MCN, U.S. DOT Number.
  • EXP means that the SCAC has been deactivated.

Please note the following: A SCAC that has been expired for more than three years may be reassigned to another company. A SCAC that has been canceled is available for reassignment after a 90-day waiting period. The status of each record can be determined by the value in field 259, Transaction ID.

Record Layout

Null is a valid value in all fields except SCAC, Company Name, Transaction Date, Transaction ID.

Explanation of MCN Field

In the majority of instances, the docket number of the entity will appear in this field. This indicates that the entity holds authority formerly issued by the Interstate Commerce Commission (ICC) or Federal Motor Carrier Safety Administration (FMCSA). If no docket number is shown, the authority is pending.

When an abbreviation is used in this column, in lieu of a number, the company's primary type of operation is explained below:

Abbreviations and Primary Types of Operation

Abbreviations and Definitions