Tue Apr 30 2002 SNAPSHOT DEFINITION REPORT

TABLE: VSP_REGISTRATION ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

0 VIN VARCHAR2(30) Vehicle Identification Number; a unique

combination of alphanumeric characters affixed to

the vehicle in specific locations and formulated

by the manufacturer.

1 TITLE_NUMBER VARCHAR2(17) A unique set of alphanumeric characters
assigned

to the certificate of title.

2 TITLE_JURISDICTION VARCHAR2(4) Jurisdiction (state or province) Code
(2 char.

alphanumeric) and Country Code (2 char.

alphanumeric) where the vehicle is titled. The

allowable codes will be defined in the FMCSA Code

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

and Subdivision Codes, respectively.

3 TRANSPONDER_NUMBER VARCHAR2(10) Vehicle transponder ID. If first bit =
0, then

32-bit hexadecimal value denoting Transponder

Serial Number assigned by manufacturer. If first

bit = 1, then 36-bit hexadecimal value denoting

Manufacturer ID and Transponder Serial Number

assigned by manufacturer.

4 OWNER_NAME VARCHAR2(55) The name of the titled owner of a vehicle.

Appears on the IRP cab card.

5 UNIT_NUMBER VARCHAR2(5) Owner equipment number (OEN) assigned by the

carrier. Appears on the IRP cab card.

6 MODEL_YEAR VARCHAR2(4) The year assigned to a vehicle by the

manufacturer; usually it is the year in which the

model change occurs. Appears on the IRP cab card.

7 MAKE VARCHAR2(10) The distinctive (coded) name applied to a group

of vehicles by a manufacturer. Appears on the IRP

cab card.

8 TYPE VARCHAR2(2) Vehicle type. The allowable codes will be defined

in the FMCSA Code Directory, Code Table T20,

Commercial Vehicle Type. Appears on the IRP cab

card.

9 MODEL VARCHAR2(3) A code denoting a family of vehicles (within a

make) which has a degree of similarity in

construction, such as body, chassis, etc.

10 FUEL VARCHAR2(2) Type of fuel used to propel a vehicle on public

highways. Appears on the IRP cab card.

11 GVW NUMBER(8,0) Gross Vehicle Weight (GVW). The weight of the

vehicle fully equipped for service, including the

weight of the payload. Appears on the IRP cab

card.

12 UNLADEN_WEIGHT NUMBER(8,0) Unladen weight. The weight of the vehicle
fully

equipped for service, not including the weight of

the payload. Appears on the IRP cab card.

13 NUMBER_OF_AXLES NUMBER(2,0) For trucks, the number of common axles of

rotation of one or more wheels of a commercial

vehicle, whether power driven or freely rotating.

For buses, the number of seats. Appears on the

IRP cab card.

14 NMVTIS_CHECK_FLAG VARCHAR2(3) Intended to indicate whether the
authoritative

source should be checked regarding the vehicle's

National Motor Vehicle Title Information System

(NMVTIS) status. Not used.

15 NMVTIS_CHECK_DATE DATE Intended to indicate date the NMVTIS check
flag

was set. Not used.

16 LICENSE_PLATE_NUMBER VARCHAR2(12) The license plate number on the
vehicle.

17 LICENSE_PLATE_STATE VARCHAR2(2) Jurisdiction (state or province) code
of the

jurisdiction that issued the

LICENSE_PLATE_NUMBER; the allowable subdivision

codes will be defined in the FMCSA Code

Directory, section B.2, Subdivision Codes.

18 IRP_BASE_STATE VARCHAR2(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. Appears on the IRP cab card.

19 LAST_UPDATE_DATE DATE Date of last update - applies to the entire

snapshot.

20 IRP_CHECK_FLAG VARCHAR2(3) Indicates whether the authoritative source
(the

base jurisdiction) should be checked regarding

the vehicle's IRP status.

21 IRP_CHECK_DATE DATE Date the IRP check flag was set.

22 IRP_ACCOUNT_NUMBER VARCHAR2(15) IRP account number associated with
carrier.

Appears on the IRP cab card.

23 REGISTRATION_START_DATE DATE Date the IRP registration is effective.
Appears

on the IRP cab card.

24 REGISTRATION_EXPIRE_DATE DATE Date the IRP registration expires.
Appears on the

IRP cab card.

25 OPERATOR_NAME VARCHAR2(55) The name of the vehicle operator. Appears
on the

IRP cab card.

26 CVIS_DEFAULT_CARRIER VARCHAR2(12) Carrier-specific identifier for the
carrier

responsible for the vehicle safety. 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.

27 DEFAULT_ISSUING_AUTHORITY VARCHAR2(4) Jurisdiction (state or
province) Code (2 char.

alphanumeric) and Country Code (2 char.

alphanumeric) where the vehicle is registered.

The allowable codes will be defined in the FMCSA

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

Codes and Subdivision Codes, respectively.

Required for an intrastate carrier.

28 DEFAULT_TERMINAL_ID VARCHAR2(4) Carrier assigned terminal ID;
applicable in

jurisdictions where carrier safety assessments

are made on a terminal facility basis.

29 CVSA_EXPIRE_DATE DATE Intended to be the date the CVSA certification

will expire. Not currently used.

30 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.

31 CARRIER_FILE_CREATE_DATE DATE Date of the carrier file containing the
data of

the safety carrier to which the vehicle is

assigned. Applies only to vehicle snapshots

received from PRISM Pilot states.

32 VEHICLE_FILE_CREATE_DATE DATE Date the file containing the vehicle
snapshot was

processed by the PRISM Central site. Applies only

to vehicle snapshots received from PRISM Pilot

states.

33 TH_INDICATOR CHAR(1) Flag indicating whether the vehicle is a PRISM

Targeted vehicle (TH_INDICATOR = \"T\"). Applies

only to vehicle snapshots received from PRISM

Pilot states.

34 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.

35 AUTHORITATIVE_SOURCE VARCHAR2(32) Specifies the program from which
the snapshot

originated - either \"IRP\" or \"PRISM\".

36 PRISM_STATE VARCHAR2(2) The state submitting the vehicle snapshot

(usually the same as IRP_BASE_STATE).

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

TABLE: VEHICLE_INSPECTION ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

37 INSPECTION_DATETIME DATE The date and time of the vehicle\'s most
recent

inspection.

38 INSPECTION_LOCATION VARCHAR2(6) Location code for the most recent
vehicle

inspection.

39 INSPECTION_RPTNUM VARCHAR2(16) Report number for the vehicle's most
recent

roadside inspection.

40 INSPECTION_VIN VARCHAR2(30) The VIN of the power unit in the most
recent

inspection received for the vehicle.

41 CARRIER_ID_NUMBER VARCHAR2(12) Carrier ID number for most recent
inspection

report sent to SAFER; unique identification

number for the carrier (e.g., USDOT number for US

carriers).

42 CARRIER_ISSUING_AUTHORITY VARCHAR2(4) Issuing authority for
CARRIER_ID_NUMBER for most

recent inspection. Jurisdiction (state or

province) Code (2 char. alphanumeric) and Country

Code (2 char. alphanumeric); the allowable codes

will be defined in the FMCSA Code Directory,

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

Subdivision Codes, respectively.

43 TERMINAL_ID VARCHAR2(4) Carrier assigned terminal ID for most recent

inspection; applicable in jurisdictions where

carrier safety assessments are made on a terminal

facility basis.

44 CVSA_CERT_FLAG VARCHAR2(3) A flag indicating a vehicle has received a
CVSA

certification. Field is updated only when CVIS

decal is issued. If not issued by most recent

Inspection Report, field is not over-written.

45 INSPECTION_OOS_FLAG VARCHAR2(3) Flag that indicates whether or not
the most

recent inspection resulted in an out-of-service

order. Does not indicate whether or not the

vehicle is currently out of service. \[0, 1, blank\]

46 INSP_SUM_START_DATE DATE Inspection start date.

47 INSP_SUM_END_DATE DATE Inspection end date.

48 INSP_SUM_INSPECTION_TOTAL NUMBER(3,0) Total number of all inspections
present over time

period. Information based only on SAFER

statistics and does not necessarily represent all

statistics for the vehicle.

49 INSP_SUM_HM_INSPS NUMBER(3,0) Total number of inspections with HazMat
present

within the time period. Information based only on

SAFER statistics and does not necessarily

represent all statistics for the vehicle.

50 INSP_SUM_OOS_VEH_INSPS NUMBER(3,0) Total number of out-of-service
vehicle

inspections over the time period. Information

based only on SAFER statistics and does not

necessarily represent all statistics for the

vehicle.

51 INSP_SUM_OOS_ORDER_COUNT NUMBER(3,0) Total number of vehicle
out-of-service orders

over the time period. Information based only on

SAFER statistics and does not necessarily

represent all statistics for the vehicle.

52 INSP_SUM_OOS_VIOL_COUNT NUMBER(6,0) Total number of vehicle
out-of-service violations

over the time period. There may be several

violations per out-of-service order. Information

based only on SAFER statistics and does not

necessarily represent all statistics for the

vehicle.

53 OOS_RPTNUM VARCHAR2(16) Inspection identifier for the most recent

out-of-service order. May have been earlier than

the most recent inspection.

54 OOS_VIN VARCHAR2(30) The VIN of the power unit recorded in the most

recent inspection of the vehicle that placed the

vehicle out of service.

55 OOS_UNTIL VARCHAR2(25) The description of what correction needs to be

made so that the vehicle can be put back in

service.

56 OOS_DATETIME DATE For the most recent OOS order, the date and time

the vehicle was placed out of service.

57 OOS_VERIFY_DATE DATE Intended to be the date the out-of-service

condition was verified as corrected. Currently

not available.

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

TABLE: VEHICLE_IRP_JURIS ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

58 CVIS_DEFAULT_CARRIER VARCHAR2(12) Unique identification number for
the carrier

(e.g., USDOT for US carriers).

59 PRISM_STATE VARCHAR2(2) The state submitting the vehicle snapshot

(usually the same as IRP_BASE_STATE).

60 IRP_JURISDICTION VARCHAR2(4) Jurisdiction (state or province)code and
country

code in which the vehicle is registered to

operate under the IRP. The allowable codes will

be defined in the FMCSA Code Directory, sections

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

respectively. Appears on the IRP cab card.

61 IRP_WEIGHT_CARRIED VARCHAR2(8) Weight that the vehicle is qualified
to carry in

the corresponding jurisdiction, under the IRP.

Appears on IRP cab card.

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

TABLE: VEHICLE_PERMIT ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

62 PERMIT_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.

63 PERMIT_START_DATE DATE The date the permit becomes valid.

64 PERMIT_EXPIRE_DATE DATE The date the permit will expire.

65 PERMIT_TYPE VARCHAR2(3) Permit type - HazMat, OSOW, etc.

66 PERMIT_CARGO_FORMAT VARCHAR2(3) Permitted cargo format.

67 PERMIT_CARGO_LENGTH NUMBER(5,1) Permitted cargo length; the length of
the trailer

or load, whichever is the longer. Largest

horizontal dimension of an object measured when

the object is in the upright position.

68 PERMIT_CARGO_OVERALL_LENGTH NUMBER(5,1) Permitted cargo overall
length; the overall

length of the power unit, trailer, and any front

and rear overhang.

69 PERMIT_CARGO_PROJECT_FRONT NUMBER(5,1) Permitted cargo front
projection; the front end

projection distance from the front bumper of the

power unit to the furthest point extending in the

front.

70 PERMIT_CARGO_PROJECT_REAR NUMBER(5,1) Permitted cargo rear
projection; the distance

from the back of the truck or trailer to the

furthest point extending to the rear.

71 PERMIT_CARGO_TYPE VARCHAR2(3) Permitted cargo type.

72 PERMIT_CARGO_HEIGHT NUMBER(5,1) Permitted cargo height; the highest
point of the

entire permitted vehicle and load. Vertical

dimension of an object measured when the object

is in the upright position.

73 PERMIT_CARGO_WIDTH NUMBER(5,1) Permitted cargo width; the widest
dimension,

including the overhang, mirrors, etc. Shorter

measurement of the two horizontal dimensions

measured with the object in the upright position.

74 PERMIT_CARGO_WEIGHT NUMBER(8,1) Permitted cargo weight; the total
gross weight of

the tractor, trailer, and load.

75 PERMIT_VEHICLE_AXLE_CONFIG VARCHAR2(25) Permitted cargo axle
configuration; configuration

of the vehicle\'s axles as entered for a permit

application.

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

TABLE: VEHICLE_PERMIT_RESTRICTIONS ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

76 PERMIT_NUMBER VARCHAR2(22) Used to link to Vehicle Permit and Vehicle
Permit

Restrictions tables.

77 PERMIT_RESTRICTION VARCHAR2(80) Current restrictions or conditions
placed on the

permit.

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

TABLE: VEHICLE_PERMIT_WEIGHTS ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

78 PERMIT_NUMBER VARCHAR2(22) Used to link Vehicle Permit and Vehicle
Permit

Weights tables.

79 PERMIT_JURISDICTION VARCHAR2(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.

80 PERMIT_WEIGHT_CARRIED NUMBER(8,1) Weight that the vehicle is
permitted to carry in

the corresponding jurisdiction.

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

TABLE: VEHICLE_REASON ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

81 OOS_VIOLATION_REASON VARCHAR2(14) The federal violation code number
for each

out-of-service violation. (Multiple occurrence

table.)

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

TABLE: VEHICLE_ESCREEN ENTITY: VEHICLE

COMMENT: TBD

FNUM FIELD NAME TYPE(LEN) FIELD COMMENT

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

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

code associated with the following information.

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.

83 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\]

84 VEHICLE_ACTION CHAR(3) This code indicates that the carrier chooses
to

have this vehicle participate in electronic

screening in the associated jurisdiction. \[E01 =

participation requested\]

85 VEHICLE_ACTION_DATE DATE Date the carrier elects to participate in

electronic screening in associated jurisdiction.

86 JURISDICTION_ACTION CHAR(3) This code indicates jurisdiction
acceptance or

rejection of the carrier in the program. This

field is optional if the jurisdiction has an open

enrollment policy. \[S28 = approved; S29 =

rejected; S30 = temporary approval; S31 =

temporary rejection\]

87 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.