MCMIS Catalog: Inspection File - Record Layout
Record Layout
Inspection Table | Carrier Table | Unit Table | Violation Table | Special Studies 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 |
| 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_PLACARD_REQ | HAZMAT PLACARD REQUIRED | 1 | A/N | Y, N, Null |
| 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 | |
| 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 |
| SNET_INPUT_DATE | SAFETYNET INPUT DATE | 8 | A/N | |
| SOURCE_OFFICE | SOURCE OFFICE | 7 | A/N |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | CHALLENGEID | 8 | N | |
| INSP_VIOL_CITATION | CHALLENGEID | 8 | N | |
| INSP_VIOL_CITATION | CITATIONRESULT | 8 | N | |
| INSP_VIOL_CITATION | RESULTDATE | 8 | A/N | YYYYMMDD |
| INSP_VIOL_CITATION | COMMENTS | 512 | A/N | |
| INSP_VIOL_CITATION | CHANGESOURCE | 8 | N | |
| INSP_VIOL_CITATION | UPLOADDATE | 8 | A/N | YYYYMMDD |
| INSP_VIOL_CITATION | ADDDATE | 8 | A/N | YYYYMMDD |
| INSP_VIOL_CITATION | ADDUSER | 30 | A/N |
| Field(s) | Data Element | Length | Type | Contents |
|---|---|---|---|---|
| INSP_CITATION_CODE | CITATION_CODE | 8 | N | |
| INSP_CITATION_CODE | CITATION_RESULT | 100 | A/N | |
| INSP_CITATION_CODE | CHANGE_BY_USER | 30 | A/N | |
| INSP_CITATION_CODE | CHANGE_DATE | 8 | A/N | YYYYMMDD |
| | Top |
Last updated: Monday, August 28, 2023