« Table Of Contents
Overview
Record Layout
Data Element Definitions
Reason For Add/Change
State Abbreviations
[New Window]
|
Census File - DATA ELEMENT DEFINITIONS
|
CENSUS MASTER TABLE | HAZMAT TABLE
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, 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 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, 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 DATA
|
The name used to identify the entity. The following data elements are included:
- LEGAL NAME. (NAME) [ FIELD LENGTH 120 ] This is the legal name of the entity.
- "DOING BUSINESS AS" NAME (NAME_DBA) [ FIELD LENGTH 120 ] This may be a trade name under which the entity does business. Any name identifying the entity other than the legal name.
|
FEDERAL TAX ID DATA
|
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.
- EIN NUMBER. (EIN_NUMBER) [ FIELD LENGTH 9 ] The Employee Identification number used by the federal government to identify businesses/individuals.
- SSN NUMBER. (SSN_NUMBER) [ FIELD LENGTH 9 ] The Social Security number used by the federal government to identify businesses/individuals.
|
DUN & BRADSTREET NUMBER (DBNUM)
|
[ FIELD LENGTH 9 ] This is the corporate registration number given by Dun & Bradstreet.
|
PHYSICAL ADDRESS DATA
|
Refers to the physical location of the entity principal office.
The following data elements are included:
- NATIONALITY. (PHY_NATN) [ FIELD LENGTH 2 ] General geographic location of the principal office. (US = United States and Territories, CD = Canadian Territories; MX = Mexican States; SA = Central and South American Nations)
- FMCSA REGION. (REG) FHWA/FMCSA Region in which the principal office resides. The following is a list of FMCSA Regions and the States assigned to each Region:
* Region 01: CT, ME, MA, NH, NY, NJ, RI, VT, PR and VI
* Region 03: DE, DC, MD, PA, VA and WV
* Region 04: AL, GA, FL, MS, NC, SC, TN and KY
* Region 05: IL, IN, MI, OH, MN and WI
* Region 06: AR, LA, NM, OK and TX
* Region 07: IA, KS, MO and NE
* Region 08: CO, MT, ND, SD, UT and WY
* Region 09: AZ, CA, NV, HI, GU and AS
* Region 10: AK, ID, OR and WA
- STREET. (PHY_STR) [ MAX FIELD LENGTH 50 ] Identifies the street address where the entity’s principal office is physically located.
- CITY. (PHY_CITY) [ MAX FIELD LENGTH 25 ] Identifies the city where the entity’s principal place of business is located.
- COUNTY CODE. (PHY_CNTY) [ FIELD LENGTH 3 ] Federally assigned number for a specific county within a State.
- STATE. (PHY_ST) [ FIELD LENGTH 2 ] Identifies the State where the principal place of business is located. Two-letter postal abbreviation for the State. See Appendix A for State abbreviations.
- ZIP CODE. (PHY_ZIP) [ FIELD LENGTH 10 ] Zip code which corresponds to the street address of the principal place of business (Any valid U.S. or Canadian zip code or CANADA; MEXICO or CENTRA). Example 37815-0310. If the expanded zip code is known, the field will contain the dash (-). Some Canadian and Mexican addresses contain the word CANADA or MEXICO as part of the zip code and Central American countries' zip codes contain CENTRA.
- UNDELIVERABLE PHYSICAL ADDRESS
- TELEPHONE (AREA CODE, NUMBER). (TEL_NUM) [ FIELD LENGTH 13 ] The entity’s telephone number at the principal place of business.
- CELL PHONE NUMBER (CELL_NUM) [ FIELD LENGTH 13 ] The entity's cell phone number.
- FAX PHONE (AREA CODE, NUMBER). (FAX_NUM) [ FIELD LENGTH 13 ] The entity’s fax number at the principal place of business.
|
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 DATA
|
Used when an entity receives mail at a location other than its principal place of business. The following data elements are included:
- NATIONALITY. (MAI_NATN) [ FIELD LENGTH 2 ] General geographic location of the entity's principal office. (US = United States and Territories, CD = Canadian Territories; MX = Mexican States; SA = Central and South American Nations)
- STREET. (MAI_STR) [ MAX FIELD LENGTH 50 ] Identifies the street used in the mailing address.
- CITY. (MAI_CITY) [ MAX FIELD LENGTH 25 ] Identifies the city used in the mailing address.
- COUNTY CODE. (MAI_CNTY) [ FIELD LENGTH 3 ] Federally assigned number for a specific county within a State.
- STATE. (MAI_ST) [ FIELD LENGTH 2 ] Identifies the State used in the mailing address. Two-letter abbreviation for the State. See Appendix A for State abbreviations.
- ZIP CODE. (MAI_ZIP) [ FIELD LENGTH 10 ] Zip code which corresponds to the street address of the entity’s mailing address. (Any valid U.S. or Canadian zip code or CANADA; MEXICO or CENTRA). Example 37815-0310. If the expanded zip code is known the field will contain the dash (-). Some Canadian and Mexican addresses contain the word CANADA or MEXICO as part of the zip code and Central American countries' zip codes contain CENTRA.
- UNDELIVERABLE MAILING ADDRESS
|
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):
- A = Authorized-For-Hire. A commercial entity whose primary business activity is the transportation of property/passengers by motor vehicle for compensation.
- B = Exempt-For-Hire. A for-hire entity transporting commodities or conducting operations not subject to economic regulation by the Interstate Commerce Commission.
- C = Private (property). An entity whose highway transportation activities are incidental to, and in furtherance of, its primary business activity.
- D = Private/Passenger Business. A private entity engaged in the interstate transportation of passengers which is provided in the furtherance of a commercial enterprise and is not available to the public at large.
- E = Private/Passenger Non-Business. A private entity involved in the interstate transportation of passengers that does not otherwise meet the definition of a private entity transporting passengers (business) (e.g., church buses).
- F = Migrant. An entity who transports in interstate or foreign commerce at any one time, three or more migrant workers to or from their employment (refers to "contract carrier by motor vehicle").
- G = U.S. Mail. A entity which transports U.S. Mail.
- H = Federal Govt. Transportation of property or passengers by a U.S. Federal Government agency.
- I = State Govt. Transportation of property or passengers by a U.S. State Government agency.
- J = Local Govt. Transportation of property or passengers by a local municipality.
- K = Indian Tribe. Transportation of property or passengers by an Indian tribal government.
- L = Other Classification. An entity which does not fall into one of the classifications above.
- Other Defined. (CLASSDEF) Column [ FIELD LENGTH 50 ] Identifies other classification.
|
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:
TYPE
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.
|
HAZMAT INDICATOR (HM_IND)
|
[ FIELD LENGTH 1 ] Indicates whether the entity transports hazardous materials or not. Y=Yes, N=No.
|
# EQUIPMENT UNITS DATA
|
[ MAX FIELD LENGTH 5 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 compacity.
[ MAX FIELD LENGTH 5 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 compacity.
[ MAX FIELD LENGTH 5 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 compacity.
[ MAX FIELD LENGTH 6 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.
CODE |
POWER UNITS |
CODE |
POWER UNITS |
A | 1 | N | 45-55 |
B | 2-3 | O | 56-75 |
C | 4-6 | P | 76-100 |
D | 7-8 | Q | 101-200 |
E | 9-11 | R | 201-300 |
F | 12-14 | S | 301-400 |
G | 15-17 | T | 401-550 |
H | 18-20 | U | 551-999 |
I | 21-23 | V | 1000-2000 |
J | 24-28 | W | 2001-3000 |
K | 29-32 | X | 3001-4000 |
L | 33-38 | Y | 4001-5000 |
M | 39-44 | Z | OVER 5000 |
|
DRIVER DATA
|
[ COLUMN 816-863 ] Data related to drivers employed by the entity. The following data elements are included:
- # DRIVERS/INTERSTATE/WITHIN 100 MILE RADIUS.(INTERLT100) [MAX FIELD LENGTH 5] Identifies the number of drivers hired by the entity to drive interstate within 100 mile radius.
- # DRIVERS/INTERSTATE/BEYOND 100 MILE RADIUS. (INTERGT100) [MAX FIELD LENGTH 5] Identifies the number of drivers hired by the entity to drive interstate beyond 100 mile radius.
- # DRIVERS/INTERSTATE/TOTAL. (INTER_DRS) [MAX FIELD LENGTH 6] Identifies the number of drivers hired by the entity to drive interstate.
- # DRIVERS/INTRASTATE/WITHIN 100 MILE RADIUS. (INTRALT100) [MAX FIELD LENGTH 5] Identifies the number of drivers hired by the entity to drive intrastate within 100 mile radius.
- # DRIVERS/INTRASTATE/BEYOND 100 MILE RADIUS. (INTRAGT100) [MAX FIELD LENGTH 5] Identifies the number of drivers hired by the entity to drive intrastate beyond 100 mile radius.
- # DRIVERS/INTRASTATE/TOTAL. (INTRA_DRS) [MAX FIELD LENGTH 6] Total number of drivers hired to drive intrastate.
- # DRIVERS/AVERAGE NUMBER TRIP LEASED DRIVERS PER MONTH. (AVG_TLD) [MAX FIELD LENGTH 5] Indicates the average number of drivers leased per month for specific trips.
- # DRIVERS/GRAND TOTAL/INTERSTATE/INTRASTATE. (TOT_DRS) [MAX FIELD LENGTH 6] Total number of drivers hired to drive interstate and intrastate.
- # DRIVERS/COMMERCIAL WITH DRIVERS LICENSE. (CDL_DRS) [MAX FIELD LENGTH 5] Indicates number of drivers with a Commercial Driver's License employed by the entity.
|
SAFETY/ EDUCATIONAL CONTACT/COMPLIANCE REVIEW DATA
|
Contains data regarding a federally-conducted or State-conducted review of a carrier's/shipper’s compliance with the Federal Motor Carrier Safety and Hazardous Material Regulations. 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:
- LATEST REVIEW TYPE. (REVTYPE) [FIELD LENGTH 1] This is the type of review conducted. (C=Compliance Review, H=Shipper Review, N=Non-Ratable Review, A=Safety Audit, S=Safety Review, E=Educational Contact Review, U=Historical Audit Record, B=Automatic Safety Assessment Program Review, F=CTFR Only, G=CR and CTFR, I=Carrier Inactivate, J=CR and SECURITY CONTACT REVIEW, or Null.)
- LATEST REVIEW DOCUMENT NUMBER. (REVDOCNUM) [ FIELD LENGTH 8 ] Number assigned by MCMIS to a Review after it has been added to MCMIS.
- LATEST REVIEW DATE. (REVDATE) [ FIELD LENGTH 8 ] The date the Review was completed by a Safety Investigator.
- RECORDABLE ACCIDENT RATE. (ACC_RATE) [ FIELD LENGTH 6 ] The rate is computed from data taken from the latest Review. Total Recordable Accidents multiplied by 1,000,000 miles divided by the mileage.
- PREVENTABLE RECORDABLE ACCIDENT RATE. (REPPREVRAT) [ FIELD LENGTH 6 ] The rate is computed from data taken from the latest Safety/ Compliance/Educational Contact Review. Total Preventable/ Recordable Accidents multiplied by 1,000,000 miles divided by the mileage.
* A record that contains 000.000 as the accident rate has two possible meanings:
(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).
- Motor carriers rated before 1986 were assigned safety ratings based on previous procedures used to determine the carriers compliance with the FMCSR such as a Safety Management Audit, or a Re-investigation conducted on the carriers operation,
- Beginning in October 1986, motor carriers were assigned a safety rating based on a
Safety Review or a Compliance Review. A Safety Review is an overview of a motor carrier's
knowledge of the FMCSR. This covers all major areas of the Safety Regulations. Much of
the rating is based on an interview with management. The main purpose is to educate a
carrier about the FMCSR. A Compliance Review is a statistical sampling or audit of required records to determine a motor carrier's compliance with the FMCSR. An in-depth review of the motor carrier's records is made to check different categories of drivers, vehicles and trip. This review may be limited to specific problems and may include a detailed investigation of a problem area. The compliance status determination is based on FMCSR violations discovered during the review.
- Any of the following codes may be found in this field:
* S = Satisfactory; Records indicate no evidence of substantial non-compliance with safety requirements.
* C = Conditional; Records indicate that the carrier was out of compliance with one or more safety requirements.
* U = Unsatisfactory; Records indicate evidence of substantial noncompliance with safety requirements.
* No code - field blank. No Safety/Compliance Review has been conducted on the Motor Carrier.
- EFFECTIVE DATE. (RATEDATE) [ FIELD LENGTH 8 ] The date the Safety/Compliance Review was input into MCMIS thus generating a safety rating (Century, Year, Month, Day).
|
MEXICAN NEIGHBORHOOD PHYSICAL/ MAILING ADDRESS
|
[ MAX FIELD LENGTH 25 per field ] (PHY_BARRIO, MAI_BARRIO) Applies only to Mexican 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)
MCSIP STEP (MCSIPSTEP) [ FIELD LENGTH 2 ] Motor Carrier Safety Improvement Process
MCSIP DATE (MCSIPDATE) [ FIELD LENGTH 8 ]
SAFETY STATUS INDICATOR (SFTYIND) [ FIELD LENGTH 5 ] Safestat allows the relative weight for each
SEA to be adjusted for the purpose of calculating an overall indicator. Since accident
history is the most important measure of safety, SafeStat places double emphasis upon the
ACC-SEA in calculating an overall SafeStat indicator. Motor Carriers that are identified
as being within the worst 25% of the ranked population within an individual SEA are deemed
an unacceptable performer for that SEA.
SAFETY STATUS INDICATOR DATE (SFTYDATE) [ FIELD LENGTH 8 ]
|
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 (MCS150MILAGEYEAR)
|
[ 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 first company representative.
|
COMPANY_REP2
|
[ FIELD LENGTH 70 ] Name and title of second company representative.
|
HAZMAT TABLE | Top
CENSUS-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.
|
HAZMAT OPERATIONS/ CARRIER(HM_CRR)
|
[ FIELD LENGTH 1 ] Identifies entity as a carrier engaged in the transportation of hazardous materials.
|
HAZMAT OPERATIONS/ SHIPPER (HM_SHP)
|
[ FIELD LENGTH 1 ] Identifies entity as a shipper engaged in the transportation of hazardous materials.
|
PLACARD (PLACARD)
|
[ FIELD LENGTH 1 ] Indicates whether carrier needs HazMat placards. (Y=Yes or N=No)
|
HAZARDOUS MATERIALS CARRIED/ SHIPPED
|
[ FIELD LENGTH 1, MAX FIELD LENGTH 82 ] (HM_A_CAR† - HM_OO_CAR / HM_A_SHP† -HM_OO_SHP)
Identifies the type of hazardous material transported or shipped by the entity and whether bulk (B),
non-bulk (N), or all (A). Note: The conversion of the Hazardous Materials Data elements of
the new Census File to the old is as follows: Bulk (B) = Tank (T), Non-Bulk (N) = Package (P),
and All (A) = Both (B).
|
|