MCMIS Catalog and Documentation

Inspection File - Record Layout

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


Note: Fields in Place Since 2014. Last Updated: 2014
INSPECTION TABLE
Field(s) Data Element Len Typ 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 A/N 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 A/N YYYYMMDD
REGION REGION 2 A/N  
CI_STATUS_CODE STATUS CODE 1 A/N U, T, C, N, H, I, P, or X
SAFETY_INSPECTOR_KEY SAFETY INSPECTOR KEY 6 A/N  
LOCATION LOCATION 6 A/N 1-5, 9  
LOCATION_DESC LOCATION DESCRIPTION 30 A/N  
COUNTY_CODE_STATE COUNTY CODE STATE 2 A/N FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
COUNTY_CODE COUNTY CODE 3 A/N FIPS PUB 6-4 (See County Code State [Opens in New Window] )
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/CONTROLLED 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 0, or Null
PENFIELD3 PEN FIELD 3 1 A/N 0-9, E, N, or Null
FINAL_STATUS_DATE FINAL STATUS DATE 8 A/N 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 FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
ORIG_REPORT_NUMBER ORIGINAL REPORT NUMBER 10 A/N  
ORIG_REPORT_DATE ORIGINAL INSPECTION DATE 8 A/N YYYYMMDD
ORIG_REPORT_TIME ORIGINAL START TIME 4 A/N  
TRANSACTION_CODE TRANSACTION CODE 1 A/N  
TRANSACTION_DATE TRANSACTION DATE 8 A/N YYYYMMDD
UPLOAD_DATE UPLOAD DATE 8 A/N 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 A/N YYYYMMDD
MCMIS_ADD_DATE MCMIS ADD DATE 8 A/N YYYYMMDD
CHANGE_BY_USER CHANGE BY USER 30 A/N  
CHANGE_DATE CHANGE DATE 8 A/N YYYYMMDD
CHANGE_BY_APPL CHANGE BY APPLICATION 61 A/N  
SNET_INPUT_DATE SAFETYNET INPUT DATE 8 A/N  
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 FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
INSP_CARRIER_ZIP_CODE CARRIER ZIP 10 A/N  
INSP_COLONIA COLONIA 25 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 YYYYMMDD
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 (See Appendix A [Opens in New Window] )
INSP_UNIT_VEHICLE_ID_NUMBER UNIT VEHICLE ID NUMBER 17 A/N  
INSP_UNIT_DECAL DECAL ISSUED 1 A/N "Y" or "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 (1-40) (See Appendix C [Opens in New Window] )
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 1stBYTE 1 A/N  
SHIPPER_DOT_NUMBER SHIPPER USDOT NUMBER 8 N  
PART_NO SHIPPER VIOLATION CODE PART NUMBER 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  


Last Updated: May 25, 2016
INSPECTION VIOLATION CITATION TABLE || Top
Field(s) Data Element Length Type Contents
INSP_VIOL_CITATION INSPECTION_ID 8 N  
INSP_VIOL_CITATION VIOSEQNUM 8 N  
INSP_VIOL_CITATION ADJSEQ 8 N  
INSP_VIOL_CITATION CITATIONRESULT 8 N  


Last Updated: May 25, 2016
INSPECTION CITATION CODE TABLE || Top
Field(s) Data Element Length Type Contents
INSP_CITATION_CODE CITATION_CODE 8 N  
INSP_CITATION_CODE CITATION_RESULT 100 A/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 disseminated to the general public. | Top