FMCSA Logo MCMIS Catalog

« Table Of Contents
Overview
Record Layout
Data Element Definitions
Glossary of Terms [New Window]
Violation Categories
State Abbreviations [New Window] 		Inspection File - RECORD LAYOUT

 Inspection Table | Carrier Table | Driver Table | Unit Table | Violation Table | Violation Shipper Table | Hazmat Table | Special Studies Table

INSPECTION TABLE
Field(s) Data Element Length Type Contents
INSPECTION_ID INSPECTION ID 8 N  
DOT_NUMBER USDOT NUMBER 8 N  
REPORT_STATE REPORT STATE 2 A/N (See Appendix A [Opens in New Window] )
REPORT_NUMBER REPORT NUMBER 10 A/N SS######## where SS is State code or US for Federal Inspections.
INSP_DATE INSPECTION DATE 8 Date YYYYMMDD
INSP_START_TIME START TIME 4 A/N Military HHMM
INSP_END_TIME END TIME 4 A/N Military HHMM
REGISTRATION_DATE REGISTRATION DATE 8 Date YYYYMMDD
REGION REGION 2 A/A  
CI_STATUS_CODE STATUS CODE 1 A/N U, T, C, N, H, I, P, or X
SAFETY_INSPECTOR_KEY SAFETY INSPECTOR KEY 6 N/A  
LOCATION LOCATION 6 A/N 1-5, 9  
LOCATION_DESC LOCATION DESCRIPTION 30 A/N  
COUNTY_CODE_STATE COUNTY CODE STATE 2 A/N (See Appendix A [Opens in New Window] )
COUNTY_CODE COUNTY CODE 3 A/N FIPS
INSP_LEVEL_ID INSPECTION LEVEL ID 8 N 1, 2, 3, 4, 5, or 99
SERVICE_CENTER SERVICE CENTER 2 A/N  
CENSUS_SOURCE_ID CENSUS SOURCE ID 8 N 1, 2, 3, 4, or 5
INSP_FACILITY INSPECTION FACILITY 1 A/N  
SHIPPER_NAME SHIPPER NAME 120 A/N  
SHIPPING_PAPER_NUMBER SHIPPING PAPER NUMBER 15 A/N  
CARGO_TANK CARGO TANK 3 A/N  
**HAZMAT_INSP_TYPE HAZMAT INSPECTION TYPE 1 A/N  
HAZMAT_PLACARD_REQ HAZMAT PLACARD REQUIRED 1 A/N Y, N, Null
ASPEN_VERSION_NUMBER ASPEN VERSION NUMBER 5 A/N  
SNET_VERSION_NUMBER SNET VERSION NUMBER 2 A/N  
SNET_SEARCH_DATE SNET SEARCH DATE 8 N  
ALCOHOL_CONTROL_SUB ALCOHOL/CONTROL SUBSTANCE CHECK 1 A/N Y, N, Null
DRUG_INTRDCTN_SEARCH DRUG INTERDICTION SEARCH 1 A/N Y, N, Null
DRUG_INTRDCTN_ARRESTS DRUG INTERDICTION ARREST 2 A/N  
SIZE_WEIGHT_ENF SIZE WEIGHT ENFORCEMENT 1 A/N Y, N, Null
TRAFFIC_ENF TRAFFIC ENFORCEMENT 1 A/N Y, N, Null
LOCAL_ENF_JURISDICTION LOCAL ENFORCEMENT JURISDICTION 1 A/N Y, N, Null
INSP_CONFIDENCE_LEVEL INSPECTOR CONFIDENCE LEVEL 1 A/N  
PEN_CEN_MATCH PEN CEN MATCH 1 A/N B, I, N, P, Q, Y, or Null
PENFIELD2 PEN FIELD 2 1 A/N O, or Null
PENFIELD3 PENFIELD 3 1 A/N 0-9, E, N, or Null
FINAL_STATUS_DATE FINAL STATUS DATE 8 Date YYYYMMDD
POST_ACC_IND POST ACCIDENT INDICATOR 1 A/N Y, N, Null
GROSS_COMB_VEH_WT GROSS COMBINED VEHICLE WEIGHT 6 A/N  
DEFECT_VER DEFECT VERIFICATION 1 A/N (Field no longer used)
OOS_DEFECT_VER OUT OF SERVICE DEFECT VERIFICATION 1 A/N  
**TOTAL_HAZMAT_SENT TOTAL HAZMAT SENT 1 N  
VIOL_NOT_SENT VIOLATIONS NOT SENT 2 N  
OOS_NOT_SENT OUT OF SERVICE NOT SENT 2 N  
VIOL_TOTAL TOTAL VIOLATIONS 3 N  
OOS_TOTAL TOTAL OUT-OF-SERVICE VIOLATIONS 3 N  
DRIVER_VIOL_TOTAL TOTAL DRIVER VIOLATIONS 3 N  
DRIVER_OOS_TOTAL TOTAL DRIVER OUT-OF-SERVICE 3 N  
VEHICLE_VIOL_TOTAL TOTAL VEHICLE VIOLATIONS 3 N  
VEHICLE_OOS_TOTAL TOTAL VEHICLE OUT-OF-SERVICE 3 N  
HAZMAT_VIOL_TOTAL HAZMAT VIOLATIONS TOTAL 3 N  
HAZMAT_OOS_TOTAL HAZMAT OUT OF SERVICE TOTAL 3 N  
SNET_SEQUENCE_ID SAFETYNET SEQUENCE ID 10 N  
ORIG_REPORT_STATE ORIGINAL REPORT STATE 2 A/N  
ORIG_REPORT_NUMBER ORIGINAL REPORT NUMBER 10 A/N  
ORIG_REPORT_DATE ORIGINAL INSPECTION DATE 8 Date YYYYMMDD
ORIG_REPORT_TIME ORIGINAL START TIME 4 A/N  
TRANSACTION_CODE TRANSACTION CODE 1 A/N  
TRANSACTION_DATE TRANSACTION DATE 8 Date YYYYMMDD
UPLOAD_DATE UPLOAD DATE 8 Date YYYYMMDD
UPLOAD_FIRST_BYTE UPLOAD CENSUS FIRST BYTE 1 A/N  
UPLOAD_DOT_NUMBER UPLOAD CENSUS NUMBER 8 A/N  
UPLOAD_SEARCH_INDICATOR UPLOAD SEARCH INDICATOR 1 A/N  
CENSUS_SEARCH_DATE CENSUS SEARCH DATE 8 Date YYYYMMDD
MCMIS_ADD_DATE MCMIS ADD DATE 8 Date YYYYMMDD
CHANGE_BY_USER CHANGE BY USER 30 A/N  
CHANGE_DATE CHANGE DATE 8 Date YYYYMMDD
CHANGE_BY_APPL CHANGE BY APPLICATION 61 A/N  
SNET_INPUT_DATE SAFETYNET INPUT DATE 8 Date  
SOURCE_OFFICE SOURCE OFFICE 7 A/N  

CARRIER TABLE || Top
Field(s) Data Element Length Type Contents
INSP_CARRIER_ID CARRIER ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
INSP_CARRIER_NAME CARRIER NAME 120 A/N  
INSP_CARRIER_STREET CARRIER STREET 50 A/N  
INSP_CARRIER_CITY CARRIER CITY 25 A/N  
INSP_CARRIER_STATE CARRIER STATE 2 A/N  
INSP_CARRIER_ZIP_CODE CARRIER ZIP 10 A/N  
INSP_COLONIA COLONIA 2 A/N  
PREFIX PREFIX 2 A/N  
DOCKET_NUMBER DOCKET NUMBER 8 N  
INSP_INTERSTATE INTERSTATE 1 A/N  
INSP_CARRIER_STATE_ID CARRIER STATE ID 12 A/N  

*DRIVER TABLE || Top
Field(s) Data Element Length Type Contents
INSP_DRIVER_ID DRIVER ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
DRIVER_TYPE DRIVER TYPE 1 A/N P=Primary, S=Secondary
DRIVER_LAST_NAME DRIVER/LAST NAME 20 A  
DRIVER_FIRST_NAME DRIVER/FIRST NAME 20 A  
DRIVER _MI DRIVER/MIDDLE INITIAL 1 A  
DRIVER_DATE_OF_BIRTH DRIVER/DATE OF BIRTH 8 A CCYYMMDD
DRIVER_LICENSE_STATE DRIVER/LICENSE STATE 2 A (See Appendix A [Opens in New Window] )
DRIVER_LICENSE_NUMBER DRIVER/LICENSE NUMBER 25 A  

INSPECTION UNIT TABLE || Top
Field(s) Data Element Length Type Contents
INSP_UNIT_ID UNIT ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
INSP_UNIT_TYPE_ID UNIT TYPE 8 N 1-14
INSP_UNIT_NUMBER UNIT NUMBER 1 N  
INSP_UNIT_MAKE UNIT MAKE 10 A/N  
INSP_UNIT_COMPANY UNIT COMPANY 15 A/N  
INSP_UNIT_LICENSE UNIT LICENSE 12 A/N  
INSP_UNIT_LICENSE_STATE UNIT LICENSE STATE 2 A/N  
INSP_UNIT_VEHICLE_ID_NUMBER UNIT VEHICLE ID NUMBER 17 A/N  
INSP_UNIT_DECAL DECAL ISSUED 1 A/N Y,N
INSP_UNIT_DECAL_NUMBER UNIT DECAL NUMBER 8 A/N  

INSPECTION VIOLATION TABLE || Top
Field(s) Data Element Length Type Contents
INSP_VIOLATION_ID VIOLATION ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
SEQ_NO VIOLATION SEQUENCE NUMBER 3 N  
PART_NO VIOLATION CODE PART NUMBER 3 A/N  
PART_NO_SECTION VIOLATION CODE SECTION NUMBER 40 A/N  
INSP_VIOL_UNIT VIOLATION UNIT 1 A/N  
INSP_UNIT_ID UNIT ID 8 N 1-13
INSP_VIOLATION_CATEGORY_ID VIOLATION CATEGORY ID 8 N  
OUT_OF_SERVICE_INDICATOR OUT OF SERVICE INDICATOR 1 A/N  
DEFECT_VERIFICATION_ID DEFECT VERIFICATION ID 8 N 1, 2, 3, 4, or 99
CITATION_NUMBER CITATION NUMBER 15 A/N  

INSPECTION VIOLATION SHIPPER TABLE || Top
Field(s) Data Element Length Type Contents
INSP_VIOL_SHIPPER_ID SHIPPER ID 8 N  
INSP_VIOLATION_ID INSPECTION VIOLATION ID 8 N  
SHIPPER_NAME SHIPPER NAME 120 A/N  
SHIPPER_STREET SHIPPER STREET ADDRESS 50 A/N  
SHIPPER_CITY SHIPPER CITY 25 A/N  
SHIPPER_STATE SHIPPER STATE 2 A/N (See Appendix A [Opens in New Window] )
SHIPPER_ZIP_CODE SHIPPER ZIP CODE 10 A/N  
SHIPPER_FIRST_BYTE SHIPPER CENSUS 1st BYTE 1 A/N  
SHIPPER_DOT_NUMBER SHIPPER USDOT NUMBER 8 N  
PART_NO SHIPPER VIOLATION PART # 3 A/N  
PART_NO_SECTION SHIPPER VIOLATION CODE SECTION NUMBER 40 A/N  

**INSPECTION HAZMAT TABLE || Top
Field(s) Data Element Length Type Contents
INSP_HAZMAT_ID HAZMAT ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
INSP_HAZMAT_MATERIAL_ID HAZMAT MATERIAL ID 8 N  
REPORTED_QUANTITY REPORTED QUANTITY 1 A/N  
WASTE WASTE 1 A/N  

INSPECTION SPECIAL STUDIES TABLE || Top
Field(s) Data Element Length Type Contents
INSP_STUDY_ID STUDY ID 8 N  
INSPECTION_ID INSPECTION ID 8 N  
STUDY STUDY 40 A/N  
SEQ_NO SEQUENCE NUMBER 3 N  
Fields marked with an asterisk (*) will not be published in your [Crash File, Census File, etc.]. Due to privacy regulations, these fields are not disseminated to the general public.
Fields marked with double asterisks (**) will not appear in your [Census File, Inspection file, etc.] For security reasons, these fields are not released to the general public. | Top

FMCSA Logo U.S. DOT Home | FMCSA Home | Accessibility | Feedback | Privacy Policy
United States Department of Transportation
(All links here open in a new window)

September 8, 2008