Tue Apr 30 2002 SNAPSHOT DEFINITION REPORT

TABLE: CARRIER ENTITY: CARRIER

COMMENT: The CARRIER and related tables store information about
companies that are

responsible for the safety of commercial vehicles.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

0 CARRIER_ID_NUMBER VARCHAR2(12) Carrier-specific identifier
corresponding to the

ID type inter- or intrastate; if carrier is

interstate, must be USDOT number; if carrier is

intrastate and has a USDOT number, must be USDOT

number; for state-specific IDs, the

carrier-specific identifier may include a prefix

to clarify the agency/source of the identifier.

1 ISSUING_AUTHORITY CHAR(4) Issuing authority for identification number;

jurisdiction code. Required for an intrastate

carrier. 2-character country code plus

2-character subdivision code; the allowable

country and subdivision codes will be defined in

the FMCSA Code Directory, sections B.1 and B.2,

Country Codes and Subdivision Codes, respectively.

2 TERMINAL_ID CHAR(4) Carrier assigned terminal ID for most recent

inspection; applicable in jurisdictions where

carrier safety assessments are made on a terminal

facility basis.

3 ICC_NUMBER_1 NUMBER(6,0) Federally-assigned motor carrier
identification

number (ICC docket number) assigned to for-hire

carriers by FMCSA.

4 ICC_NUMBER_2 NUMBER(6,0) Federally-assigned motor carrier
identification

number (ICC docket number) assigned to for-hire

carriers by FMCSA.

5 ICC_NUMBER_3 NUMBER(6,0) Federally-assigned motor carrier
identification

number (ICC docket number) assigned to for-hire

carriers by FMCSA.

6 STATE_CARRIER_ID VARCHAR2(12) Carrier ID number assigned by the state,
often

used in lieu of the USDOT number, for intrastate

carriers. Required for intrastate carriers.

7 TAX_ID_TYPE CHAR(1) Tax ID type: Social Security Number or Employer

ID Number; the SSN and TIN are mutually

exclusive. \[S = SSN; E = Employer ID (MCMIS and

SAFER); blank (if blank, TAX_ID_NUMBER is also

blank)\]

8 TAX_ID_NUMBER VARCHAR2(9) Federal taxpayer\'s ID number; either SSN or
TIN,

as indicated by TAX_ID_TYPE.

9 CARRIER_NAME VARCHAR2(55) This is the legal name of the carrier. May

include organization name or first, middle and

last name of a person.

10 DBA_NAME VARCHAR2(55) Doing Business As name. This may be a trade
name

under which the carrier does business. Any name

identifying the entity other than the legal name.

11 OIC_NUMBER CHAR(2) Code number representing the officer-in-charge

having jurisdiction over the entity. \[00, 0-58\]

12 REGION_CODE CHAR(2) FMCSA code identifying the OMCHS region in which

the carrier's principal place of business is

physically located. \[00-10\]

13 TERRITORY_CODE VARCHAR2(2) FMCSA code identifying the territory
(state or

county for which an OIC has responsibility) in

which the carrier is located.

14 STREET VARCHAR2(30) Identifies the street address where the motor

carrier's principal place of business is

physically located.

15 COLONIA VARCHAR2(25) If applicable, identifies the Mexican
\"colonia\"

where the motor carrier's principal place of

business is physically located.

16 CITY VARCHAR2(25) Identifies the city where the motor carrier's

principal place of business is physically located.

17 STATE CHAR(2) Identifies the jurisdiction (state or province)

where the motor carrier's principal place of

business is physically located. Two-letter

postal abbreviation for the state/province.

18 ZIP_CODE VARCHAR2(10) Zip code which corresponds to the street
address

of the carrier\'s principal place of business (Any

valid U.S. or Canadian zip code or CANADA, MEXICO

or CENTRA). Expanded zip code refers to the last

four digits of the zip code. 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. The first 5

characters will be stored in the ZIPCODE field

and the last character will be stored in the

EXPANDED ZIPCODE field.

19 COUNTY_CODE NUMBER(3,0) Identifies the county where the motor
carrier's

principal place of business is physically

located. (FIPS code within state \[1-999\].) (None

if not US.)

20 COUNTRY CHAR(1) General geographic location of the principal

office. \[A = American; P = American territories;

C = Canadian territories; M = Mexican state; S =

Central American nations\]

21 TELEPHONE_NUMBER VARCHAR2(13) The carrier telephone number at the
principal

place of business. SAFER only contains the main

voice phone number supplied by MCMIS.

22 FAX_NUMBER VARCHAR2(13) The motor carrier's fax number at the
principal

place of business.

23 EMAIL_ADDRESS VARCHAR2(80) The motor carrier's Internet email
address.

24 MAIL_STREET VARCHAR2(30) The mailing address street address for
carriers

whose mailing address is different than their

principal place of business.

25 MAIL_COLONIA VARCHAR2(25) The mailing address Mexican "colonia" for

carriers whose mailing address is different than

their principal place of business.

26 MAIL_CITY VARCHAR2(25) The mailing address city for carriers whose

mailing address is different than their principal

place of business.

27 MAIL_STATE CHAR(2) The mailing address jurisdiction (state or

province) for carriers whose mailing address is

different than their principal place of business.

28 MAIL_ZIP_CODE VARCHAR2(10) The mailing address zip code for carriers
whose

mailing address is different than their principal

place of business. (Any valid U.S. or Canadian

zip code or CANADA, MEXICO or CENTRA). Expanded

zip code refers to the last four digits of the

zip code. 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. The first 5 characters will be stored in

the ZIPCODE field and the last character will be

stored in the EXPANDED ZIPCODE field.

29 MAIL_COUNTY_CODE NUMBER(3,0) The mailing address county for carriers
whose

mailing address is different than their principal

place of business. (FIPS code within state.)

30 BUS CHAR(1) Commercial bus operator (data not currently being

provided).

31 QUANTITY_POWER_UNITS NUMBER(7,0) Identifies the number of trucks,
tractors,

hazardous material tank trucks, motor coaches,

school buses, mini-buses/vans, and limousines

owned, term-leased or trip-leased by the motor

carrier.

32 QUANTITY_MOTOR_COACHES NUMBER(6,0) The number of buses owned,
term-leased, or

leased-by-trip by a carrier.

33 QUANTITY_HAZMAT_TANK_TRAILERS NUMBER(6,0) The number of HazMat tank
trailers owned,

term-leased, or leased-by-trip by a carrier.

34 QUANTITY_HAZMAT_TANK_TRUCKS NUMBER(6,0) The number of HazMat tank
trucks owned,

term-leased, or leased-by-trip by a carrier.

35 QUANTITY_LIMOS NUMBER(6,0) The number of limousines owned,
term-leased, or

leased-by-trip by a carrier.

36 QUANTITY_SCHOOL_BUSES NUMBER(6,0) The number of school buses owned,
term-leased, or

leased-by-trip by a carrier.

37 QUANTITY_TRAILERS NUMBER(6,0) The number of trailers owned,
term-leased, or

leased-by-trip by a carrier. The trailers may or

may not be registered under IRP.

38 QUANTITY_TRUCK_TRACTORS NUMBER(6,0) The number of truck tractors
owned, term-leased,

or leased-by-trip by a carrier.

39 QUANTITY_TRUCKS NUMBER(6,0) The number of straight trucks owned,
term-leased,

or leased-by-trip by a carrier.

40 QUANTITY_VANS NUMBER(6,0) The number of vans owned, term-leased, or

leased-by-trip by a carrier.

41 QUANTITY_CARS NUMBER(6,0) The number of cars owned, term-leased, or

leased-by-trip by a carrier.

42 QUANTITY_DRIVERS NUMBER(5,0) Total number of drivers employed by the
carrier,

both inter- and intrastate.

43 QUANTITY_DRIVERS_CDL NUMBER(5,0) Total number of CDL drivers employed
by the

carrier.

44 QUANTITY_DRIVERS_INTERSTATE NUMBER(5,0) Total number of interstate
drivers employed by

the carrier.

45 QUANTITY_DRIVERS_INTRASTATE NUMBER(5,0) Total number of intrastate
drivers employed by

the carrier.

46 MCMIS_STATUS CHAR(1) Code identifying the status of a carrier in the

Motor Carrier Management Information System -

updated at MCMIS. \[A = active; I = inactive\]

47 MCMIS_REASON_INACTIVATED CHAR(3) The reason that a carrier was made
inactive.

48 MCMIS_TRANSACTION_DATE DATE MCMIS file creation date.

49 MCMIS_STATUS_DATE DATE Date the carrier status was most recently
updated

in MCMIS.

50 FILE_CREATE_DATE DATE Date that MCMIS created the file for a carrier.

51 DATE_ADDED DATE Date the carrier was added to MCMIS and assigned

an identification number.

52 LAST_UPDATE_DATE DATE Date carrier was most recently updated in
MCMIS.

53 LAST_UPDATE_USERID CHAR(8) ID of the staff member who most recently
updated

the carrier in MCMIS.

54 CARRIER_HAZMAT_PLACARDED NUMBER(1,0) A flag indicating that the
HazMat carrier

transports placardable loads. \[0 = false (no); 1

= true (yes); 2 = unknown\]

55 CARRIER_RATEABLE CHAR(1) A flag indicating whether the carrier is
rateable

for safety fitness. Not related to review;

occurs once per carrier. \[0 = false (no); 1 =

true (yes)\]

56 ENTITY_TYPE CHAR(1) Refers to the type of operation in which the

carrier is engaged. \[C = carrier; S = shipper; B

= carrier/shipper; R = registrant\]

57 CARRIER_INTERSTATE CHAR(1) Flag indicating carrier engaged in
interstate

operations. \[0 = false (no); 1 = true (yes)\]

58 CARRIER_INTERSTATE_HM CHAR(1) Obsolete.

59 CARRIER_INTERSTATE_NHM CHAR(1) Obsolete.

60 CARRIER_INTRASTATE_NHM CHAR(1) Flag indicating carrier engaged in
intrastate

non-HazMat operations. \[0 = false (no); 1 = true

(yes)\]

61 CARRIER_INTRASTATE_HM CHAR(1) Flag indicating carrier engaged in
intrastate

HazMat operations. \[0 = false (no); 1 = true

(yes)\]

62 SHIPPER_INTERSTATE CHAR(1) Obsolete.

63 SHIPPER_INTERSTATE_HM CHAR(1) Flag indicating shipper engaged in
interstate

HazMat operations. \[0 = false (no); 1 = true

(yes)\]

64 SHIPPER_INTRASTATE_HM CHAR(1) Flag indicating shipper engaged in
intrastate

HazMat operations. \[0 = false (no); 1 = true

(yes)\]

65 HAZMAT_STATUS CHAR(1) Indicates whether a carrier/shipper is engaged
in

the transport of hazardous materials. \[C =

carrier; S = shipper; B = carrier/shipper; N =

neither; F = shipper/non-HazMat carrier; blank\]

66 PRIOR_DATE DATE The start date of an inspection summary reporting

period.

67 QUANTITY_INSPECTIONS_LAST24 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 24 months.

68 QUANTITY_HAZMAT_PRESENT_LAST24 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 24 months.

69 VEHICLE_INSPECTIONS_LAST24 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 24 months.

70 DRIVER_INSPECTIONS_LAST24 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 24 months.

71 OOS_ALL_TYPES_LAST24 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 24 months resulting in

OOS violations.

72 OOS_VEHICLE_INSPECTIONS_LAST24 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 24 months resulting in OOS

violations.

73 OOS_DRIVER_INSPECTIONS_LAST24 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 24 months resulting in OOS

violations.

74 OOS_HAZMAT_INSPECTIONS_LAST24 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 24 months resulting in OOS

violations.

75 QUANTITY_INSPECTIONS_LAST30 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 30 months.

76 QUANTITY_HAZMAT_PRESENT_LAST30 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 30 months.

77 VEHICLE_INSPECTIONS_LAST30 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 30 months.

78 DRIVER_INSPECTIONS_LAST30 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 30 months.

79 OOS_ALL_TYPES_LAST30 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 30 months resulting in

OOS violations.

80 OOS_VEHICLE_INSPECTIONS_LAST30 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 30 months resulting in OOS

violations.

81 OOS_DRIVER_INSPECTIONS_LAST30 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 30 months resulting in OOS

violations.

82 OOS_HAZMAT_INSPECTIONS_LAST30 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 30 months resulting in OOS

violations.

83 QUANTITY_INSPECTIONS_LAST15 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 15 months.

84 QUANTITY_HAZMAT_PRESENT_LAST15 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 15 months.

85 VEHICLE_INSPECTIONS_LAST15 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 15 months.

86 DRIVER_INSPECTIONS_LAST15 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 15 months.

87 OOS_ALL_TYPES_LAST15 NUMBER(5,0) Total number of all roadside
inspections

conducted within the past 15 months resulting in

OOS violations.

88 OOS_VEHICLE_INSPECTIONS_LAST15 NUMBER(5,0) Number of vehicle roadside
inspections conducted

within the past 15 months resulting in OOS

violations.

89 OOS_DRIVER_INSPECTIONS_LAST15 NUMBER(5,0) Number of driver roadside
inspections conducted

within the past 15 months resulting in OOS

violations.

90 OOS_HAZMAT_INSPECTIONS_LAST15 NUMBER(5,0) Number of HazMat roadside
inspections conducted

within the past 15 months resulting in OOS

violations.

91 VIOLATION_BRAKES NUMBER(6,0) Number of vehicle inspection violations.
SAFER

violation type: Brakes.

92 VIOLATION_LIGHTS NUMBER(6,0) Number of vehicle inspection violations.
SAFER

violation type: Lights.

93 VIOLATION_WHEELS NUMBER(6,0) Number of vehicle inspection violations.
SAFER

violation type: Wheels/Tires.

94 VIOLATION_STEERING NUMBER(6,0) Number of vehicle inspection
violations. SAFER

violation type: Steering.

95 VIOLATION_MEDICAL_CERTIFICATE NUMBER(6,0) Number of driver inspection
violations. SAFER

violation type: Medical Certificate.

96 VIOLATION_LOGS NUMBER(6,0) Number of driver inspection violations.
SAFER

violation type: Logs.

97 VIOLATION_HOURS NUMBER(6,0) Number of driver inspection violations.
SAFER

violation type: Hours.

98 VIOLATION_LICENSE NUMBER(6,0) Number of driver inspection violations.
SAFER

violation type: CDL.

99 VIOLATION_DRUGS NUMBER(6,0) Number of driver inspection violations.
SAFER

violation type: Drug/Alcohol.

100 VIOLATION_TRAFFIC NUMBER(6,0) Number of driver inspection
violations. SAFER

violation type: Traffic.

101 VIOLATION_PAPERS NUMBER(6,0) Number of HazMat inspection violations.
SAFER

violation type: Papers.

102 VIOLATION_PLACARDS NUMBER(6,0) Number of HazMat inspection
violations. SAFER

violation type: Placards.

103 VIOLATION_OP_EMER_RESP NUMBER(6,0) Number of HazMat inspection
violations. SAFER

violation type: OP/Emergency Response.

104 VIOLATION_TANK NUMBER(6,0) Number of HazMat inspection violations.
SAFER

violation type: Cargo Tank.

105 VIOLATION_OTHER NUMBER(6,0) Number of HazMat inspection violations.
SAFER

violation type: Other (than Papers, Placards,

OP/Emergency Response, Cargo Tank).

106 SAFETY_RATING CHAR(1) Measure of the carrier's compliance with the

Federal Motor Carrier Safety Regulations.

Carriers are assigned a safety rating based on a

Safety Review or Compliance Review. The rating is

based on the most recent review only. \[C =

conditional; S = satisfactory; U =

unsatisfactory; blank\]

107 RATING_DATE DATE The date the last Safety/Compliance Review was

input into MCMIS thus generating a safety rating.

108 REVIEW_INVESTIGATOR_CODE CHAR(6) Assigned investigator code for
carrier review.

109 REVIEW_TYPE CHAR(1) Type of the carrier\'s last review. \[C =

compliance review; E = ETA contract; S = safety

review; N; blank\]

110 REVIEW_DATE DATE The date the current compliance review was

conducted.

111 RECORDABLE_CRASHES NUMBER(5,0) Total reportable accidents (over an
implicit

2-year period) recorded during a compliance

review.

112 PREVENTABLE_CRASHES NUMBER(3,0) Total preventable/reportable
accidents over an

implicit 2-year period.

113 MILEAGE NUMBER(10,0) Total fleet operating mileage of a motor
carrier

for 2-year period - collected during review.

114 REVIEW_MEDICAL_CERTIFICATE CHAR(1) Safety review driver violation
indicator of type

Medical Certificate. \[0 = false (no); 1 = true

(yes)\]

115 REVIEW_LOGS CHAR(1) Safety review driver violation indicator of type

Logs. \[0 = false (no); 1 = true (yes)\]

116 REVIEW_HOURS CHAR(1) Safety review driver violation indicator of
type

Hours. \[0 = false (no); 1 = true (yes)\]

117 REVIEW_DRUG_ALCOHOL CHAR(1) Safety review driver violation indicator
of type

Drug/Alcohol. \[0 = false (no); 1 = true (yes)\]

118 REVIEW_LICENSE CHAR(1) Safety review driver violation indicator of
type

CDL\. \[0 = false (no); 1 = true (yes)\]

119 REVIEW_TRAFFIC CHAR(1) Safety review driver violation indicator of
type

Traffic. \[0 = false (no); 1 = true (yes)\]

120 REVIEW_PAPERS CHAR(1) Safety review HazMat violation indicator of
type

Papers. \[0 = false (no); 1 = true (yes)\]

121 REVIEW_PLACARDS CHAR(1) Safety review HazMat violation indicator of
type

Placards. \[0 = false (no); 1 = true (yes)\]

122 REVIEW_CARGO_TANK CHAR(1) Safety review HazMat violation indicator
of type

Cargo Tank. \[0 = false (no); 1 = true (yes)\]

123 REVIEW_OTHER CHAR(1) Safety review HazMat violation indicator of
type

\"Other\". \[0 = false (no); 1 = true (yes)\]

124 PRIOR_ENFORCEMENT_CASES NUMBER(2,0) Number of prior enforcement
cases.

125 FOLLOW_UP_CODE CHAR(1) Follow-up code recommendations. \[F = federal

follow-up recommended; S = state follow-up

recommended; blank\]

126 MCSIP_FLAG CHAR(1) Indicates whether or not carrier is in the MCSIP

program. \[C = carrier in MCSIP; blank = carrier

is NOT in MCSIP\]

127 MCSIP_LEVEL NUMBER(2,0) An indicator of where the carrier is in the

sanctioning process (MCSIP) - PRISM sanction flag.

128 MCSIP_LEVEL_DATE DATE The date the MCSIP level was assigned to the

carrier.

129 MCSIP_ENTRY_DATE DATE Date of entry into the MCSIP program.

130 SAFESTAT_RUN_INDICATOR CHAR(1) SafeStat run number. \[I = ID run; M
= mandatory

run; blank\]

131 SAFESTAT_DATE DATE The date the SafeStat score was assigned to the

carrier.

132 SAFESTAT_ACCIDENT_SEA NUMBER(5,2) SafeStat Accident Safety
Evaluation Area (SEA)

ranking relative to other carriers; contributes

to SafeStat score. \[0-100; 100 is worst\]

133 SAFESTAT_CATEGORY CHAR(1) SafeStat category for carriers based on
the four

SEA rankings. See \"Motor Carrier Safety Fitness

Determination: An Improved Process\" dated

December 1996, by the John A. Volpe National

Transportation Systems Center. \[A-I, A is worst\]

134 SAFESTAT_DRIVER_SEA NUMBER(5,2) SafeStat Driver Safety Evaluation
Area (SEA)

ranking relative to other carriers; contributes

to SafeStat score. \[0-100; 100 is worst\]

135 SAFESTAT_LETTERS NUMBER(2,0) The total number of SafeStat warning
letters sent

to the carrier.

136 SAFESTAT_LETTER_DATE DATE The date the most recent SafeStat warning
letter

was sent.

137 SAFESTAT_MANAGEMENT_SEA NUMBER(5,2) SafeStat Management Safety
Evaluation Area (SEA)

ranking relative to other carriers; contributes

to SafeStat score. \[0-100; 100 is worst\]

138 SAFESTAT_INDICATOR NUMBER(5,2) PRISM SafeStat score assigned to a
carrier

(renamed to \"SafeStat Indicator\"). Score = 2 \*

AccidentSEA + 1.5 \* DriverSEA + VehicleSEA +

ManagementSEA.

139 SAFESTAT_VEHICLE_SEA NUMBER(5,2) SafeStat Vehicle Safety Evaluation
Area (SEA)

ranking relative to other carriers; contributes

to SafeStat score. \[0-100; 100 is worst\]

140 HAZMAT_PASSENGER_SCORE NUMBER(4,1) HazMat passenger rating.

141 HAZMAT_PASSENGER_SCORE_DATE DATE HazMat passenger rating date.

142 SNET_FATAL_ACCIDENTS_LAST24 NUMBER(4,0) Number of accidents with at
least one fatality.

Collected during carrier review. Two-year period.

143 SNET_INJURY_ACCIDENTS_LAST24 NUMBER(4,0) Number of accidents with at
least one injury but

no fatalities. Collected during carrier review.

Two-year period.

144 SNET_TOWAWAY_ACCIDENTS_LAST24 NUMBER(4,0) Number of tow-away
accidents - number of crashes

that did not result in an injury or fatality.

Collected during carrier review. Two-year period.

145 SNET_OTHER_ACCIDENTS_LAST24 NUMBER(4,0) Number of accidents not
otherwise categorized.

Collected during carrier review. Two-year period.

146 SNET_TOTAL_ACCIDENTS_LAST24 NUMBER(4,0) Total number of all
accidents. Collected during

carrier review. Two-year period.

147 SNET_FATAL_ACCIDENTS_LAST15 NUMBER(4,0) Number of accidents with at
least one fatality.

Collected during carrier review. 15-month period.

148 SNET_INJURY_ACCIDENTS_LAST15 NUMBER(4,0) Number of accidents with at
least one injury but

no fatalities. Collected during carrier review.

15-month period.

149 SNET_TOWAWAY_ACCIDENTS_LAST15 NUMBER(4,0) Number of tow-away
accidents -- number of crashes

that did not result in an injury or fatality.

Collected during carrier review. 15-month period.

150 SNET_OTHER_ACCIDENTS_LAST15 NUMBER(4,0) Number of accidents not
otherwise categorized.

Collected during carrier review. 15-month period.

151 SNET_TOTAL_ACCIDENTS_LAST15 NUMBER(4,0) Total number of all
accidents. Collected during

carrier review. 15-month period.

152 SNET_FATAL_ACCIDENTS_LAST30 NUMBER(4,0) Number of accidents with at
least one fatality.

Collected during carrier review. 30-month period.

153 SNET_INJURY_ACCIDENTS_LAST30 NUMBER(4,0) Number of accidents with at
least one injury but

no fatalities. Collected during carrier review.

30-month period.

154 SNET_TOWAWAY_ACCIDENTS_LAST30 NUMBER(4,0) Number of tow-away
accidents - number of crashes

that did not result in an injury or fatality.

Collected during carrier review. 30-month period.

155 SNET_OTHER_ACCIDENTS_LAST30 NUMBER(4,0) Number of accidents not
otherwise categorized.

Collected during carrier review. 30-month period.

156 SNET_TOTAL_ACCIDENTS_LAST30 NUMBER(4,0) Total number of all
accidents. Collected during

carrier review. 30-month period.

157 SCE_SCORE NUMBER(3,0) Selective Compliance Evaluation (SCE) score no

longer used. Use ISS_SCORE.

158 SCE_SCORE_DATE DATE Date of score computation SCE score no longer

used. Use ISS_SCORE_DATE.

159 STATE_DATA VARCHAR2(30) Optional comment provided by the carrier\'s
base

jurisdiction.

160 NAME_ALPHABETIZER VARCHAR2(17) Carrier legal name search key.

161 NAME_ALPHABETIZER2 VARCHAR2(17) Search key based on carrier\'s Doing
Business As

name.

162 ISS_SCORE NUMBER(3,0) The Inspection Selection System (ISS) is a

decision-aid for commercial vehicle roadside

driver/vehicle safety inspections which guides

safety inspectors in selecting vehicles for

inspection. The ISS-2 provides a three-tiered

recommendation as follows: 77-100 = Inspect

(inspection warranted); 50-74 = Optional (may be

worth a look); 1-49 = Pass (no inspection

required). The underlying inspection value is

based on data analysis of the carrier's safety

performance record using the information in the

National MCMIS. This safety algorithm for

assigning the inspection value is based on

SafeStat, which ranks all carriers by their

safety performance in areas of crash history,

inspection history, driver history, and safety

management experience.

163 ISS_SCORE_DATE DATE The date the Inspection Selection System (ISS)

score was computed.

164 ISS_INDICATOR CHAR(1) Inspection Selection System (ISS) indicator.
\[S =

based on SafeStat values; I = insufficient

information available\]

165 DUNS_NUMBER CHAR(9) This is the corporate registration number given

by Dun & Bradstreet.

166 FEDERAL_OP_AUTH_ID VARCHAR2(22) Operating authority number (Single
State

Registration System (SSRS)). Obsolete, replaced

by L&I.

167 FEDERAL_OP_AUTH_STATUS CHAR(3) A flag indicating the status of the
operating

authority. Obsolete, replaced by L&I.

168 FEDERAL_OP_AUTH_ISSUED_DATE DATE The date the operating authority
was issued.

Obsolete, replaced by L&I.

169 FEDERAL_OP_AUTH_RENEW_DATE DATE The date the current operating
authority must be

renewed. Obsolete, replaced by L&I.

170 FEDERAL_OP_AUTH_BASE_STATE CHAR(2) A code (state/province) as
defined by an

appropriate government agency identifying the

base jurisdiction for the operating authority.

Obsolete, replaced by L&I.

171 FEDERAL_OP_AUTH_AGENCY VARCHAR2(35) The name of the agency issuing
the operating

authority. Obsolete, replaced by L&I.

172 HAZMAT_REG_STATUS CHAR(3) Current HazMat status.

173 HAZMAT_REG_STATUS_DATE DATE The date the HazMat registration status
was

assigned.

174 HAZMAT_REG_NUMBER VARCHAR2(10) The HazMat registration number; ID
number

associated with the HazMat authority.

175 HAZMAT_REG_DATE DATE The date the HazMat registration was issued.

176 HAZMAT_REG_BASE_STATE CHAR(2) Jurisdiction (state or province) code
of the base

jurisdiction for the HazMat application as

specified by the appropriate government agency.

The allowable codes will be defined in the FMCSA

Code Directory, section B.2, Subdivision Codes.

177 INSURANCE_TYPE CHAR(3) Obsolete - replaced by L&I. It is meaningless
as

a single \"type\" per carrier. The comparable field

is provided as a repeating field for each

insurance type as LI_INSURANCE_TYPE.

178 INSURANCE_COVERAGE_LEVEL VARCHAR2(50) A description or number that
identifies the plan

or coverage. There is no source for

INSURANCE_COVERAGE_LEVEL.

179 INSURANCE_HAZMAT_LEVEL CHAR(1) The level of HazMat coverage for the
vehicle.

There is no source for INSURANCE_HAZMAT_LEVEL.

180 FUEL_USE_PERMIT_FLAG CHAR(1) The flag indicating if the carrier has
a valid

fuel use permit. There is no source for

FUEL_USE_PERMIT_FLAG.

181 FUEL_USE_PERMIT_DATE DATE The date the fuel use permit status was
assigned.

There is no source for FUEL_USE_PERMIT_DATE.

182 IFTA_REG_STATUS CHAR(3) IFTA check flag. Values indicate check
needed

with the appropriate authoritative source, no

check needed with the appropriate authoritative

source, or no information available. \[S26 = a

check with the appropriate authoritative source

is needed; S27 = no check with the appropriate

authoritative source is needed; U = no

information is available\]

183 IFTA_REG_STATUS_DATE DATE Date the IFTA status was determined.

184 IFTA_REG_LICENSE_NUMBER VARCHAR2(18) IFTA account number for
carrier.

185 IFTA_REG_BASE_STATE CHAR(2) The base jurisdiction specified for an
IFTA

registration.

186 IFTA_REG_ISSUE_DATE DATE The date the taxpayer was registered with
the

base jurisdiction as an IFTA carrier.

187 IFTA_REG_EXPIRE_DATE DATE The date the IFTA registration will
expire.

188 OOS_REPORT_NUMBER CHAR(6) The report number for the carrier\'s last

out-of-service order.

189 OOS_DATETIME DATE The date and time the carrier was last placed

out-of-service.

190 OOS_REASON CHAR(6) The reason (Federal Violation Codes) the carrier

was last placed out-of-service.

191 OOS_STATUS CHAR(3) A code indicating the status of the carrier\'s

last out-of-service order.

192 MCS150_MILEAGE NUMBER(10,0) Carrier MCS-150 mileage.

193 MCS150_MILEAGE_YEAR CHAR(4) Carrier MCS-150 mileage year.

194 MCS150_UPDATE_DATE DATE Date of most recent update to a carrier's
MCS-150

form.

195 MCS150_UPDATE_FLAG CHAR(1) Whether or not the most recent update to
a

carrier's MCS-150 form resulted in changes to the

MCMIS database. Carriers who report "no change"

will have a value of N. \[Y, N or NULL\]

196 TH_DATE DATE The date the vehicle snapshot was first reported

as a targeted vehicle. Applies only to vehicle

snapshots received from PRISM Pilot states.

==========================================================================

TABLE: CARRIER_CARGO ENTITY: CARRIER

COMMENT: The CARRIER_CARGO table stores cargo classifications provided
by the carrier on

the most recent MCS-150 form. Identifies the type of cargo transported
by the

carrier/shipper.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

197 CARGO_CODE VARCHAR2(3) Code identifying the type of cargo a carrier
may

haul - from MCMIS registration form. The

allowable cargo codes will be defined in the

FMCSA Code Directory, Code Table T23, Commercial

Vehicle Operations Commodity Code.

198 CARGO_OTHER_DESC VARCHAR2(16) Cargo hauled by carrier if CARGO_CODE
= Other.

From MCMIS registration form.

==========================================================================

TABLE: CARRIER_CLASS ENTITY: CARRIER

COMMENT: The CARRIER_CLASS table stores the type of motor carrier as
provided by the

carrier on the most recent MCS-150 form.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

199 CLASS_CODE VARCHAR2(3) A code for the different categories of
carrier

operations that are subject to different taxes or

regulations. The allowable operation codes will

be defined in the FMCSA Code Directory, Code

Table T03, Operation Type.

200 CLASS_OTHER_DESC VARCHAR2(10) Description of CLASS_CODE \"Other\".

==========================================================================

TABLE: CARRIER_HAZMAT ENTITY: CARRIER

COMMENT: The CARRIER_HAZMA table stores the types of hazardous materials
the carrier

transports, as reported on the most recent MCS-150 form.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

201 HAZMAT_CODE VARCHAR2(3) A code relating to hazardous material code

qualifier for regulated hazardous materials. The

allowable HazMat codes will be defined in the

FMCSA Code Directory, Code Table T24, Commercial

Vehicle Operations Hazardous Material Code.

202 HAZMAT_CARRIED_SHIPPED CHAR(1) Code used to indicate whether the
hazardous

material is being carried, shipped, or both

carried and shipped by the related carrier.

Specified on the MCS-150 form. \[B = both; C =

carrier; S = shipper\]

203 BULK_NONBULK CHAR(1) Code indicating the format of the hazardous

material. Specified on the MCS-150 form. \[B =

bulk (formerly tank); N = non-bulk (formerly

package); A = all (bulk and non-bulk); blank =

neither (bulk nor non-bulk)\]

==========================================================================

TABLE: CARRIER_PERMIT ENTITY: CARRIER

COMMENT: The CARRIER_PERMIT table stores information pertaining to
permits issued by

states for the operation of the carriers\' vehicles.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

204 PERMIT_ID_NUMBER VARCHAR2(22) The permit number. For a hazardous
materials

permit, this may be the USDOT HazMat Registration

Number for each truck and truck tractor.

205 PERMIT_TYPE CHAR(3) Permit type - HazMat, OSOW, etc.

206 PERMIT_STATUS CHAR(3) Current status of permit.

207 PERMIT_START_DATE DATE The date the permit becomes valid.

208 PERMIT_EXPIRE_DATE DATE The date the permit will expire.

==========================================================================

TABLE: CARRIER_PERMIT_JURISDICTION ENTITY: CARRIER

COMMENT: The CARRIER_PERMIT_JURISDICTION table stores the jurisdictions
(i.e., states)

for which a permit applies.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

209 PERMIT_ID_NUMBER VARCHAR2(22) The permit number. For a hazardous
materials

permit, this may be the USDOT HazMat Registration

Number for each truck and truck tractor.

210 PERMIT_JURISDICTION CHAR(4) Jurisdiction (state or province)code and
country

code in which the vehicle is permitted to

operate. The allowable country and subdivision

codes will be defined in the FMCSA Code

Directory, sections B.1 and B.2, Country Codes

and Subdivision Codes, respectively.

211 PERMIT_WEIGHT_CARRIED NUMBER(8,0) Weight that the vehicle is
permitted to carry in

the corresponding jurisdiction.

==========================================================================

TABLE: CARRIER_STATE_OP_AUTH ENTITY: CARRIER

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

212 STATE_OP_AUTH_ID VARCHAR2(22) A unique identifier for the state
operating

authority.

213 STATE_OP_AUTH_STATUS CHAR(3) A flag indicating if the motor
carrier\'s state

operating authority is up-to-date.

214 STATE_OP_AUTH_ISSUED_DATE DATE The date the state operating
authority was issued

by the issuing agent.

215 STATE_OP_AUTH_RENEW_DATE DATE The date the state operating authority
was

renewed.

216 STATE_OP_AUTH_AGENCY VARCHAR2(35) The name of the agency issuing the
operating

authority.

217 ISSUING_STATE CHAR(4) Country and subdivision code (standard

state/province) as defined by the appropriate

government agency for the jurisdiction to which

the state operating authority pertains. The

allowable country and subdivision codes will be

defined in the FMCSA Code Directory, sections B.1

and B.2, Country Codes and Subdivision Codes,

respectively.

==========================================================================

TABLE: CARRIER_FED_OP_AUTH_JURISD ENTITY: CARRIER

COMMENT: This table is obsolete.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

218 FEDERAL_OP_AUTH_ID VARCHAR2(22) Operating authority number (Single
State

Registration System (SSRS)). Obsolete, replaced

by L&I.

219 FEDERAL_OP_AUTH_JURISDICTION CHAR(4) Valid jurisdictions granted
authority; 48 states

granted automatically. Obsolete, replaced by L&I.

==========================================================================

TABLE: CARRIER_ESCREEN ENTITY: CARRIER

COMMENT: The CARRIER_ESCREEN table stores information provided by a
carrier specifying

in which states he intends to participate in e-screening programs.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

220 JURISDICTION_CODE CHAR(4) Jurisdiction (state or province)code and
country

code. The allowable country and subdivision codes

will be defined in the FMCSA Code Directory,

sections B.1 and B.2, Country Codes and

Subdivision Codes, respectively.

221 ACTIVITY_CODE CHAR(2) This code supports flexible use of the
following

repeating fields. Currently, the only 'activity'

supported is electronic screening enrollment. \[10

= e-screening; E01 = e-screening\]

222 CARRIER_ACTION CHAR(3) Carrier sets this value indicating its
preference

for participation in electronic screening in the

associated jurisdiction. \[E01 = participation

requested\]

223 CARRIER_ACTION_DATE DATE Date carrier elects to participate in
electronic

screening in associated jurisdiction.

224 JURISDICTION_ACTION CHAR(3) Jurisdiction acceptance or rejection of
the

carrier in the electronic screening program. This

field is optional if the jurisdiction has an open

enrollment policy. \[S28 = approved; S29 =

rejected; S30 = temporary approval; S31 =

temporary rejection\]

225 JURISDICTION_ACTION_DATE DATE If specified, the date of the
jurisdiction\'s

decision to accept/reject a carrier\'s request to

participate in electronic screening.

==========================================================================

TABLE: CARRIER_REVIEW ENTITY: CARRIER

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

226 REVIEW_DATE DATE The date the most recent compliance review was

conducted.

227 SAFETY_RATING CHAR(1) Measure of the carrier's compliance with the

Federal Motor Carrier Safety Regulations.

Carriers are assigned a safety rating based on a

Safety Review or Compliance Review. The rating is

based on the most recent review only. \[C =

conditional; S = satisfactory; U =

unsatisfactory; blank\]

228 SAFETY_RATING_FACTOR_1 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 1 =

General knowledge (regulatory). \[C = conditional;

S = satisfactory; U = unsatisfactory; N; blank\]

229 SAFETY_RATING_FACTOR_2 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 2 =

Driver (regulatory). \[C = conditional; S =

satisfactory; U = unsatisfactory; N; blank\]

230 SAFETY_RATING_FACTOR_3 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 3 =

Operational (regulatory). \[C = conditional; S =

satisfactory; U = unsatisfactory; N; blank\]

231 SAFETY_RATING_FACTOR_4 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 4 =

Vehicle (regulatory). \[C = conditional; S =

satisfactory; U = unsatisfactory; N; blank\]

232 SAFETY_RATING_FACTOR_5 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 5 =

HazMat (regulatory). \[C = conditional; S =

satisfactory; U = unsatisfactory; N; blank\]

233 SAFETY_RATING_FACTOR_6 CHAR(1) Element of the safety rating
methodology for the

Safety Fitness Determination Process. Factor 6 =

Accident Rate. \[C = conditional; S =

satisfactory; U = unsatisfactory; N; blank\]

234 RATING_DATE DATE The date the most recent Safety/Compliance Review

was input into MCMIS, thus generating a safety

rating.

235 REVIEW_TYPE CHAR(1) The type of the most recent review. \[C =

compliance review; E = ETA contract; S = safety

review; H = shipper only; A = audit; N\]

236 REVIEW_CITY VARCHAR2(25) City in which the review was conducted.

237 REVIEW_STATE CHAR(2) State in which the review was conducted.

238 REVIEW_INVESTIGATOR_CODE CHAR(6) Assigned investigator code for most
recent

carrier review.

239 REVIEW_REASON_INITIAL_CONTACT NUMBER(1,0) Review reason: initial
contact. \[0 = false (no);

1 = true (yes)\]

240 REVIEW_REASON_COMPLAINT NUMBER(1,0) Review reason: complaint
investigation. \[0 =

false (no); 1 = true (yes)\]

241 REVIEW_REASON_PRIORITY_LIST NUMBER(1,0) Review reason: priority
list. \[0 = false (no); 1

= true (yes)\]

242 REVIEW_REASON_ENF_FOLLOW_UP NUMBER(1,0) Review reason: enforcement
follow-up. \[0 = false

(no); 1 = true (yes)\]

243 REVIEW_REASON_CARRIER_REQUEST NUMBER(1,0) Review reason: carrier
request. \[0 = false (no);

1 = true (yes)\]

244 REVIEW_REASON_NOT_RATED CHAR(1) Review reason: not rated (MCMIS
only). \[C =

intrastate-only HazMat; G = shipper review; I =

mileage not reported; J = minimum parts not

received; M = unsatisfactory rating held\]

245 REVIEW_REASON_OTHER NUMBER(1,0) Review reason: other. \[0 = false
(no); 1 = true

(yes)\]

246 REVIEW_REASON_OTHER_DESC VARCHAR2(20) Description of \"Review Reason
Other\".

247 RECORDABLE_CRASHES NUMBER(5,0) Total reportable accidents (over an
implicit

2-year period) recorded during compliance review.

248 MILEAGE NUMBER(10,0) Total fleet operating mileage of a motor
carrier

for 2-year period - collected during review.

249 VEH_CHECKED_FROM_PROFILE NUMBER(4,0) Number of vehicles included in
review.

250 OOS_VEH_CHECKED_FROM_PROFILE NUMBER(3,0) Number of OOS vehicles to
be verified during

review.

251 VEH_CHECKED_DURING_REVIEW NUMBER(3,0) Number of vehicles inspected
during review.

252 OOS_VEH_CHECKED_DURING_REVIEW NUMBER(3,0) Number of OOS vehicles
inspected during review.

253 PLANNED_ACTION_COMPLIANCE_MON NUMBER(1,0) Planned action: carrier
compliance monitoring. \[0

= false (no); 1 = true (yes)\]

254 PLANNED_ACTION_PROSECUTION NUMBER(1,0) Planned action: prosecution.
\[0 = false (no); 1 =

true (yes)\]

255 PLANNED_ACTION_OOS_ORDER NUMBER(1,0) Planned action: out-of-service
order. \[0 = false

(no); 1 = true (yes)\]

256 PLANNED_ACTION_ADMIN_HANDLING NUMBER(1,0) Planned action:
administrative handling. \[0 =

false (no); 1 = true (yes)\]

257 PLANNED_ACTION_OTHER NUMBER(1,0) Planned action: other action
required.

258 PLANNED_ACTION_OTHER_DESC VARCHAR2(20) Description of \"Planned
Action Other\".

==========================================================================

TABLE: CARRIER_IRP ENTITY: CARRIER

COMMENT: The CARRIER_IRP table stores information about the accounts
established by the

carrier to register vehicles in various states.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

259 IRP_ACCOUNT_NUMBER VARCHAR2(15) Account number associated with
carrier for an IRP

registration.

260 IRP_BASE_STATE CHAR(2) Jurisdiction (state or province) chosen by
the

interstate carrier as the base jurisdiction for

IRP. The allowable subdivision codes will be

defined in the FMCSA Code Directory, section B.2,

Subdivision Codes.

261 IRP_CHECK_FLAG CHAR(3) Indicates whether the authoritative source
(the

base jurisdiction) should be checked regarding

the carrier's IRP status. \[S26 = a check with the

appropriate authoritative source is needed; S27 =

no check with the appropriate authoritative

source is needed; U = no information is available\]

262 IRP_CHECK_DATE DATE Date the IRP check flag was set.

==========================================================================

TABLE: CARRIER_LI_PRIMARY ENTITY: CARRIER

COMMENT: The CARRIER_LI_PRIMARY table stores information on insurance
policies owned by

the carrier in fulfillment of its financial responsibility.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

263 DOCKET_NUMBER NUMBER(6,0) This refers to the number issued by the
FMCSA

granting authority for interstate operations.

264 PREFIX CHAR(2) This refers to the number issued by the FMCSA

granting authority for interstate operations.

The prefix \"MC\" refers to a motor carrier; \"MX\"

refers to a foreign domiciled (Mexico) motor

carrier; \"FF\" refers to a freight forwarder.

265 CANADIAN_ID VARCHAR2(35) Canadian carrier identification number.

266 MEXICAN_RFC VARCHAR2(35) Mexican carrier RFC identification number.

267 MEXICAN_OP_AUTHORITY CHAR(1) Mexican operations authority code
table. \[1 = all

of US; 2 = commercial zone only; blank = not

applicable\]

268 INSURANCE_ENTITY_NAME VARCHAR2(120) Legal name of the insured
entity. Data provided

in L&I system file.

269 INSURANCE_DBA_NAME VARCHAR2(60) Doing-business-as name of the
insured entity.

Data provided in L&I system file.

270 MEXICAN_TERRITORY CHAR(2) Mexican territory code. Data as provided
in L&I

system file. \[01 = Texas Zone; 02 = California

Zone; 03 = Arizona Zone; 04 = United States Zone;

05 = Cameron, Hidalgo, Starr and Willacy

Counties, TX Zone; 06 = Multiple States Zone; 07

= New Mexico Zone; 08 = between points in

California; 09 = between points in Texas; 10 =

between points in California and Arizona; 11 =

between points in the United States; 12 = between

points in Arizona; 00 = unknown\]

271 COMMON_AUTH_STATUS CHAR(1) Authority status of a common carrier
(before

1/1/96, this was defined as a company that

provided for-hire truck transportation to the

general public). Indicates whether status is

active, inactive, or none. Common carriers must

file proof of cargo insurance. Data as provided

in L&I system file. \[A = active; I = inactive; N

= none; U = unknown\]

272 COMMON_AUTH_REASON_INACTIVE CHAR(3) The reason a common carrier's
record was

inactivated. Data as provided in L&I system file.

273 COMMON_AUTH_DATE_INACTIVE DATE The date the common carrier's record
was

inactivated. Data as provided in L&I system file.

274 CONTRACT_AUTH_STATUS CHAR(1) Authority status of a contract carrier
(before

1/1/96, this was defined as a company that

provided for-hire truck transportation to

specific, individual shippers based upon private

contracts). Data as provided in L&I system file.

\[A = active; I = inactive; N = none; U = unknown\]

275 CONTRACT_AUTH_REASON_INACTIVE CHAR(3) The reason a contract
carrier's record was

inactivated. Data as provided in L&I system file.

276 CONTRACT_AUTH_DATE_INACTIVE DATE The date the contract carrier's
record was

inactivated. Data as provided in L&I system file.

277 BROKER_AUTH_STATUS CHAR(1) Authority status of a broker. (A broker
is a

company that arranges for the truck

transportation of cargo belonging to others,

utilizing for-hire carriers to provide the actual

truck transportation. However, the Broker does

not assume responsibility for the cargo and

usually does not take possession of the cargo.

Brokers must register with FHWA by filing a Form

OP-1.) Data as provided in L&I system file. \[A =

active; I = inactive; N = none; U = unknown\]

278 BROKER_AUTH_REASON_INACTIVE CHAR(3) The reason a broker's record was
inactivated.

Data as provided in L&I system file.

279 BROKER_AUTH_DATE_INACTIVE DATE The date the broker's record was
inactivated.

Data as provided in L&I system file.

280 LIABILITY_INSURANCE_AMOUNT NUMBER(10,0) Dollar amount of Liability
Insurance =

LI_LIABILITY_INSURANCE_REQD as received from L&I

system file. Added for symmetry with other

insurance types to make data element a boolean so

data element will be more general.

281 LIABILITY_INSURANCE_REQD CHAR(1) Flag indicating whether the carrier
is required

to file proof of liability insurance. Data as

provided in L&I system file. \[Y = yes; N = no; U

= unknown\]

282 LIABILITY_INSURANCE_STATUS CHAR(1) Flag indicating whether carrier
has filed proof

of liability insurance. Data as provided in L&I

system file. \[0 = not OK; 1 = OK; U = unknown\]

283 LIABILITY_INSURANCE_SUMMARY CHAR(6) Insurance summary status.
Calculated field

requested by FSG for ASPEN. \[\"na\" if

LI_LIABILITY_INSURANCE_REQD = \"N\"; otherwise =

LI_LIABILITY_INSURANCE_STATUS\]

284 CARGO_INSURANCE_REQD CHAR(1) Flag indicating whether the carrier is
required

to file proof of cargo insurance (common carriers

are so required). Data as provided in L&I system

file. \[Y = yes; N = no; U = unknown\]

285 CARGO_INSURANCE_STATUS CHAR(1) Flag indicating whether carrier has
filed proof

of cargo insurance. Data as provided in L&I

system file. \[0 = not OK; 1 = OK; U = unknown\]

286 CARGO_INSURANCE_SUMMARY CHAR(6) Insurance summary status. Calculated
field

requested by FSG for ASPEN. \[\"na\" if

LI_CARGO_INSURANCE_REQD = \"N\"; otherwise =

LI_CARGO_INSURANCE_STATUS\]

287 BOND_TRUST_FUND_REQD CHAR(1) Flag indicating whether the carrier is
required

to file proof of bond insurance. Data as provided

in L&I system file. \[Y = yes; N = no; U = unknown\]

288 BOND_TRUST_FUND_STATUS CHAR(1) Flag indicating whether carrier has
filed proof

of bond insurance. Data as provided in L&I system

file. \[0 = not OK; 1 = OK; U = unknown\]

289 BOND_TRUST_FUND_SUMMARY CHAR(6) Insurance summary status. Calculated
field

requested by FSG for ASPEN. \[\"na\" if

LI_BOND_TRUST_FUND_REQD = \"N\"; otherwise =

LI_BOND_TRUST_FUND_STATUS\]

290 DATA_EFFECTIVE_DATE DATE The date SAFER loaded the data.

==========================================================================

TABLE: CARRIER_LI_DETAIL ENTITY: CARRIER

COMMENT: The CARRIER_LI_DETAIL table stores information pertaining to
the financial

responsibility requirements applicable to the carrier.

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

\-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

291 DOCKET_NUMBER NUMBER(6,0) This refers to the number issued by the
FMCSA

granting authority for interstate operations.

292 PREFIX CHAR(2) This refers to the number issued by the FMCSA

granting authority for interstate operations.

The prefix \"MC\" refers to a motor carrier; \"MX\"

refers to a foreign domiciled (Mexico) motor

carrier; \"FF\" refers to a freight forwarder.

293 INSURANCE_TYPE CHAR(1) Type of coverage: liability, cargo, or bond
trust

fund (Appendix B, MSC-90). \[1, 2, 3, 4\]

294 INSURER VARCHAR2(45) The free-form name of the insurance company.
Data

as provided in L&I system file.

295 POLICY_NUMBER VARCHAR2(25) The account number for the insurance
policy. Data

as provided in L&I system file.

296 POLICY_EFFECTIVE_DATE DATE The effective date of the policy, surety
bond or

trust fund.

297 COVERAGE_LOW_AMOUNT NUMBER(10,0) Amount of minimum liability
coverage.

298 COVERAGE_HIGH_AMOUNT NUMBER(10,0) Amount of maximum liability
coverage.

299 CANCELLATION_EFFECTIVE_DATE DATE Cancellation effective date of the
policy, surety

bond or trust fund.

300 DATA_EFFECTIVE_DATE DATE The date SAFER loaded the data.