(File Name: AuthHist.txt) # Name Field Values/Comments Length 1 USDOT Number Text 8 Official FMCSA registration number for all interstate motor carriers. 2 Operating Authority Registration VARCHAR OperatingAuthorityType Type 128 3 Operating Authority Registration VARCHAR OperatingAuthorityTypeStatus Status 128 Active Revoked Suspended Expired Commercial Zone Provisional – Commercial Zone Permanent – MX Long Haul Provisional – MX Long Haul Permanent – NNA Provisional – NNA Permanent (CVSA Decal) – NNA Permanent – 4 Operating Authority Registration Date OperatingAuthorityTypeStatusDate Status Date
(File Name: AuthHist.txt) # Name Field Length Values/Comments 1 USDOT Number Text 8 Official FMCSA registration number for all interstate motor carriers. 2 Operating Authority Registration Type VARCHAR 128 OperatingAuthorityType 3 Operating Authority Registration Status VARCHAR 128 OperatingAuthorityTypeStatus Active Revoked Suspended Expired Commercial Zone – Provisional Commercial Zone – Permanent MX Long Haul – Provisional MX Long Haul – Permanent NNA – Provisional NNA – Permanent (CVSA Decal) NNA – Permanent 4 Operating Authority Registration Status Date Date OperatingAuthorityTypeStatusDate