MCMIS Catalog: Census File - Data Element Definitions
Data Element Definitions
Data Element | Definition | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
STATUS (ACT_STAT) |
[ FIELD LENGTH 1 ] Refers to the status of the record in MCMIS. An Active status means the entity is currently in business and subject to the FMCSR, the HMR, or is an intrastate non-HM carrier issued a USDOT number by selected states. An Inactive status means the entity is no longer in business or is no longer subject to the FMCSR or the HMR. (A = Active, I = Inactive) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ENTITY TYPE (CARSHP) |
[ FIELD LENGTH 4 ] Refers to the type of operation in which the entity is engaged. It identifies the entity as a carrier, a hazardous materials shipper, a broker, a freight forwarder, a cargo tank facility, or a registrant. C = Carrier, S = Shipper, B = Broker, R = Registrant (entity who registers vehicles but is not a carrier), F = Freight Forwarder, T = Cargo Tank. Companies with multiple operations will have multiple letters. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USDOT NUMBER (CENSUS_NUM) |
[ FIELD LENGTH 8 ] This is the number assigned by MCMIS to a census record. It is sometimes referred to as the USDOT number. Each entity should have only one active census number. The census number has no internal coded structure. Numbers are issued sequentially as entities are added to the system. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NAME | The name used to identify the entity. The following data elements are included:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FEDERAL TAX ID | FEDERAL TAX ID DATA will not be published in your File Extract. Due to privacy regulations, these fields are not disseminated to the general public.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DUN & BRADSTREET NUMBER (DBNUM) |
[ FIELD LENGTH 9 ] This is the corporate registration number given by Dun & Bradstreet. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PHYSICAL ADDRESS | Refers to the physical location of the entity's principal office. The following data elements are included:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NOTIFY FLAG (NOTIFY_FLAG) |
[ FIELD LENGTH 1 ] The Notify Flag is set to 'Y' when a company is newly added to MCMIS or is re-activated. The letter program picks up all census entries where this flag is 'Y' and processes them. It generates the appropriate type of notification letter and resets the flag to 'N'. (May be blank.) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NOTIFY DATE (NOTIFY_DATE) |
[ FIELD LENGTH 8 ] Contains the date the Notify Flag was set. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MAILING ADDRESS | Used when an entity receives mail at a location other than its principal place of business. The following data elements are included:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OFFICER IN CHARGE (OIC) CODE (OIC) |
[ FIELD LENGTH 2 ] The code representing the FMCSA Officer-in-Charge having jurisdiction over the entity. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAFETY INVESTIGATOR TERRITORY CODE (TERR) |
[ FIELD LENGTH 2 ] Code assigned to the territory (State or County for which an OIC has responsibility) in which the entity's principal business is domiciled. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ICC DOCKET NUMBERS | [FIELD LENGTH 2, FIELD LENGTH 6] (ICCDOCKET1, ICC1), (ICCDOCKET2, ICC2), (ICCDOCKET3, ICC3), Federally-assigned Interstate Commerce Commission entity's identification number. Space allotted for three Docket Number Prefixes (usually MC, MX, or FF) and three ICC Docket Numbers. The terms MC number or MX number have replaced the term ICC number in general usage. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CLASSIFICATION (CLASS) |
[ MAX FIELD LENGTH 12 ] Identifies the type of entity. MCMIS recognizes the following classifications for entity type (NOTE: An entity can have more than one type of classification. A letter will appear in all those fields representing classifications that apply):
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CARRIER/SHIPPER OPERATION | [ MAX FIELD LENGTH 6 ] (CRRINTER*, CRRHMINTRA*, CRRINTRA*, SHPINTER*, SHPINTRA, VEHICLE_REGISTRANT*) Identifies the carrier as being engaged in interstate, intrastate hazardous material or intrastate non-hazardous material transport activities. In cases of shippers, it identifies the shipper as being engaged in interstate or intrastate shipping activities. Also allows for indication of Vehicle Registrants. A letter will appear in all those fields representing operations that apply. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BUSINESS ORGANIZATION (ORG) |
[ FIELD LENGTH 1 ] Identifies the type of legal structure used by the entity. 1 = Individual, 2 = Partnership, 3 = Corporation. From reviews only. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CARGO CLASSIFICATIONS | [ MAX FIELD LENGTH 30 ] Identifies the type of cargo transported by the entity. MCMIS recognizes the following cargo types. (NOTE: An entity can transport more than one type of cargo). The letter "X" will appear in all those fields representing cargo that apply: A. General Freight (GENFREIGHT) B. Household Goods (HOUSEHOLD) C. Metal: Sheets, Coils, Rolls (METALSHEET) D. Motor Vehicles (MOTORVEH) E. Driveaway/Towaway (DRIVETOW) F. Logs, Poles, Beams, Lumber (LOGPOLE) G. Building Materials (BLDGMAT) H. Mobile Homes (MOBILEHOME) I. Machinery, Large Objects (MACHLRG) J. Fresh Produce (PRODUCE) K. Liquids/Gases (LIQGAS) L. Intermodal Containers (INTERMODAL) M. Passengers (PASSENGERS) N. Oilfield Equipment (OILFIELD) O. Livestock (LIVESTOCK) P. Grain, Feed, Hay (GRAINFEED) Q. Coal, Coke (COALCOKE) R. Meat (MEAT) S. Garbage, Refuse, Trash (GARBAGE) T. U.S. Mail (USMAIL) U. Chemicals (CHEM) V. Commodities Dry Bulk (DRYBULK) W. Refrigerated Food (COLDFOOD) X. Beverages (BEVERAGES) Y. Paper Products (PAPERPROD) Z. Utility (UTILITY) AA. Farm Supplies (FARMSUPP) BB. Construction (CONSTRUCT) CC. Water - Well (WATERWELL) DD. Other (CARGOOTHR) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CARGO CLASSIFICATION OTHER DEFINED(OTHERCARGO) | [ MAX FIELD LENGTH 50 ] Identifies the type of cargo when ''Other'' is selected as cargo classification. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
# EQUIPMENT UNITS | [ MAX FIELD LENGTH 8 per field ] (OWNTRUCK, OWNTRACT, OWNTRAIL, OWNHMTRAIL, OWNHMTRUCK, OWNCOACH, OWNSCHOOL_1_8, OWNSCHOOL_9_15, OWNSCHOOL_16, OWNBUS_16, OWNVAN_1_8, OWNVAN_9_15, OWNLIMO_1_8, OWNLIMO_9_15, OWNLIMO_16) Identifies the number of Trucks, Tractors, Trailers, Hazardous Materials Cargo Trailers, Hazardous Material Tank Trucks, Motor Coaches, School Buses, Mini-bus/Vans, and Limousines owned by the entity. Passenger vehicles are further broken down by passenger capacity. [ MAX FIELD LENGTH 8 per field ] (TRMTRUCK, TRMTRACT, TRMTRAIL, TRMHMTRAIL, TRMHMTRUCK, TRMCOACH, TRMSCHOOL_1_8, TRMSCHOOL_9_15, TRMSCHOOL_16, TRMBUS_16, TRMVAN_1_8, TRMVAN_9_15, TRMLIMO_1_8, TRMLIMO_9_15, TRMLIMO_16) Identifies the number of Trucks, Tractors, Trailers, Hazardous Materials Cargo Trailers, Hazardous Material Tank Trucks, Motor Coaches, School Buses, Mini-bus/Vans, and Limousines term leased by the entity. Passenger vehicles are further broken down by passenger capacity. [ MAX FIELD LENGTH 8 per field ] (TRPTRUCK, TRPTRACT, TRPTRAIL, TRPHMTRAIL, TRPHMTRUCK, TRPCOACH, TRPSCHOOL_1_8, TRPSCHOOL_9_15, TRPSCHOOL_16, TRPBUS_16, TRPVAN_1_8, TRPVAN_9_15, TRPLIMO_1_8, TRPLIMO_9_15, TRPLIMO_16) Identifies the number of Trucks, Tractors, Trailers, Hazardous Materials Cargo Trailers, Hazardous Material Tank Trucks, Motor Coaches, School Buses, Mini-bus/Vans, and Limousines trip leased by the entity. Passenger vehicles are further broken down by passenger capacity. [ MAX FIELD LENGTH 8 per field ] (TOT_TRUCKS, TOT_BUSES, TOT_PWR) Lists the total number of Trucks, Buses, and Power Units, respectively. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FLEET SIZE CODE (FLEETSIZE) |
[ FIELD LENGTH 1 ] Total number of power units used by the entity. MCMIS totals the entries from the Census Equipment data elements -- Trucks, Truck Tractors, HM Cargo Tank Trucks, Motor Coaches, School Buses, Mini Bus/Vans and Limousines. Numbers of power units are represented by a letter of the alphabet.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DRIVER | [ COLUMN 816-863 ] Data related to drivers employed by the entity. The following data elements are included:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAFETY/EDUCATIONAL CONTACT/COMPLIANCE REVIEW | Contains data regarding a federally-conducted or state-conducted review of a carrier's/shipper's compliance with the Federal Motor Carrier Safety Regulations (FMCSR) and Hazardous Material Regulations (HMR). These reviews result in the carrier receiving a Federal safety rating of Satisfactory, Unsatisfactory or Conditional. A safety rating is generated by MCMIS after the Review has been added to the MCMIS Review File. The following data elements are included:
(1) No mileage data is available to compute the accident rate or (2) mileage data exist and the actual accident rate is 000.000. * If the record contains 999.999 this indicates that the accident rate is greater than 10.0. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MCS-150 MILEAGE CALENDAR YEAR (MLG150) |
[ FIELD LENGTH 10 ] The number of miles reported by the entity on the form MCS-150. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
REVIEW MILEAGE (MILETOT) |
[ FIELD LENGTH 10 ] The number of miles reported on the motor carrier/shipper from the most current Review. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAFETY RATING (RATING) |
[ FIELD LENGTH 1 ] This is a measure of the carrier's compliance with the Federal Motor Carrier Safety Regulations (FMCSR).
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MEXICAN NEIGHBORHOOD PHYSICAL/MAILING ADDRESS | [ MAX FIELD LENGTH 25 per field ] (PHY_BARRIO, MAI_BARRIO) Applies only to Mexican domiciled entities. This is the neighborhood name in which the physical or mailing address is located. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PERFORMANCE & REGISTRATION INFORMATION SYSTEM MANAGEMENT (PRISM) | [ COLUMN 975-997 ] (Previously called CVIS)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LATEST CHANGE/USER ID (USERID) | [ FIELD LENGTH 30 ] This is the User ID of the person that made the last change to the record. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
+POINTER NUMBER/PRIMARY RECORD(POINTNUM) | [ FIELD LENGTH 9 ] This field is used as a pointer to the record that is now the primary record. The pointer number is actually the USDOT number of the primary record. (P = Primary, S = Secondary) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
REASON CODE | [ FIELD LENGTH 3 per field ] (ADDCODE, UPD_REAS, DELCODE) See Reason For Add/Change [Opens in New Window] for list of reasons/codes for adding or changing census information. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MCS-150 MILEAGE YEAR (MCS150MILEAGEYEAR) | [ FIELD LENGTH 8 ] The year of the mileage entered on the MCS-150 form. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATE RECORD ADDED (ADDDATE) |
[ FIELD LENGTH 8 ] Date record was added to MCMIS. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATE OF LAST UPDATE (CHNGDATE) |
[ FIELD LENGTH 8 ] Date of last change to record. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATE DELETED (DELDATE) |
[ FIELD LENGTH 8 ] Date the record was inactivated. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TOTAL CARS (TOT_CARS) |
[ FIELD LENGTH 6 ] Indicates the total number of automobiles used by intrastate entities as commercial vehicles (i.e., courier services, small package delivery, etc.). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VERSION (VERSION) |
[ FIELD LENGTH 6 ] Census file version number. The version number is used to match the current version of the documentation with the current version of the Census File. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATE CREATED (CREATEDATE) |
[ FIELD LENGTH 8 ] Date the file was created for the requester. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ADD USER ID (ADDUSERID) |
[ FIELD LENGTH 10 ] This is the user ID of the person who added the first record. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DELETE USER ID (DELUSERID) |
[ FIELD LENGTH 10 ] This is the User ID of the person who last deleted the record. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MCS-150 DATE | [ FIELD LENGTH 8 ] The date that the last MCS-150 was filed. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
REC-UPDATED-FLAG (RECORD UPDATEDFLAG) |
[ FIELD LENGTH 1 ] Indicates if any updates have been made to the record. 1 = MCS-150 was updated, 2 = MCS-150 was not updated, 3 = Not applicable to MCS-150. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EMAIL-ADDRESS | [ MAX FIELD LENGTH 80 ] The e-mail address of the carrier. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USDOT_REVOKED_FLAG | [ FIELD LENGTH 1 ] This flag indicates whether a USDOT (New Entrant Registration) has been revoked. Y = revoked, N = not revoked | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USDOT_REVOKED_NUMBER | [ FIELD LENGTH 8 ] This field contains the USDOT number that has been revoked. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
COMPANY_REP1 | [ FIELD LENGTH 70 ] Name and title of the first company representative. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
COMPANY_REP2 | [ FIELD LENGTH 70 ] Name and title of the second company representative. |
Last updated: Thursday, January 4, 2024