PRISM Data Flow

1
PRISM Data Flow Timelinessfor Law Enforcement

• Updated February 2009

2
PRISM Data Types

• Carrier Census Data
• Motor Carriers Information
• Vehicle Registration Data
• IRP Vehicle Registration Information

3
PRISM Carrier Census Data
MCMIS Database
Authoritative Source
MCMIS authoritative source of PRISM Carrier
Census Data
4
PRISM Carrier Census Data
MCMIS Database
Authoritative Source
MCMIS UpdateMonday Thursday _at_
Midnight Saturday _at_ 800 am
Key Enforcement Data
USDOT NumberCarrier NameTargeted IndicatorOOSO
Status
SAFER - PRISM

• MCMIS sends data to SAFER-PRISM database
  nightly

• Several different sources to access key data

5
PRISM Carrier Census Data
MCMIS Database
Authoritative Source
OOSO Status
MCMIS UpdateMonday Thursday _at_
Midnight Saturday _at_ 800 am
Key Enforcement Data
USDOT NumberCarrier NameTargeted IndicatorOOSO
Status
SAFER - PRISM
SAFER FTP Site
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
After MCMIS Update(Real-time for OOSO Status)
After MCMIS Update
After MCMIS Update
States download from SAFER FTP _at_ 800 am
After MCMIS Update
Monthly SafeStat Calc.Weekly SAFER Calc. Ad-hoc
Client Refresh
6
Query Central (Carrier)
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
Query Central website can be accessed via FMCSA
COMPASS Portal, with NO need for VPN or UAS.
Query Central Carrier Search
Query Central Carrier Data Results
7
Query Central (Carrier)
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
Query Central Carrier OOS Descriptions
8
Query Central (Carrier)
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
Query Central Carrier PRISM Summary
9
NLETS
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
MSG FROM NLETS 8098ACR.AVLIC0000.    TODEST IA0
7710B5MRI0069282.TXT                   CARRIE
R IS UNDER FEDERAL OOSO - UNSAT/UNFIT DOT/507290.
NAM/STAR Z TRUCK LLC.ADR/7902
ENGLEWOOD.CITY/YAKIMA.ST/WA.ZIP/98908.CAR TARG-H
IST IND/T.MCSIP STEP/55.MCSIP Date/12312008 PAGE/0
1 OF/01.200901181200/200901181200T175 19MESSA
GE FROM NLTS069295
PRISM ACQ (Carrier) NLETS responses include
messages for OOSO, and provide the reason
NLETS Carrier Status Request (ACQ) Response
Message
10
SAFER Website
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
SAFER Company Snapshot Results
SAFER Company Snapshot Search
11
SAFER Website
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
SAFER Company Snapshot OOS Details Results
12
PRISM Web Services
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
XML responses can be displayed within State
systems.
PRISM Web Services Carrier Inquiry
13
CVIEW T0031
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
Query Central(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
Example of Nebraska CVIEW using T0031 Data for
Carrier OOS Status
14
ISS Inspection Selection System
Data Availability
Freshest Data
Stalest Data
NLETSCarrier Inquiry(ad-hoc)
SAFER Website(ad-hoc)
CVIEWT0031(batch)
PRISM Web Services(ad-hoc)
ISS(batch)
Query Central(ad-hoc)
ISS Users still need to confirm with other
sources about status of OOSO, since the ISS data
is not updated in real-time such as QC.
ISS Carrier Search Results Screen
15
PRISM Vehicle Registration Data
State Vehicle Registration Office
Authoritative Source
State Vehicle Registration Office - authoritative
source of PRISM Vehicle Registration Data
16
PRISM Vehicle Registration Data
State Vehicle Registration Office
Authoritative Source
Daily Vehicle Record Uploads PRISM PVF -
500am CVIEW XML - Throughout the day or evening
batch upload. (dependent on State process)
Key Enforcement Data
VIN, State/PlateRegistration Expire
Date,Carrier Resp. for Safety
SAFER - PRISM

• State Vehicle Registration Office sends data to
  SAFER-PRISM database daily

• Several different sources to access vehicle data

17
PRISM Vehicle Registration Data
State Vehicle Registration Office
Authoritative Source
Daily Vehicle Record Uploads PRISM PVF -
500am CVIEW XML - Throughout the day or evening
batch upload. (dependent on State process)
Key Enforcement Data
VIN, State/PlateRegistration Expire
Date,Carrier Resp. for Safety
SAFER - PRISM
PRISMSFTP Site
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
After Daily Vehicle Record Uploads
States download from PRISM SFTP _at_ 600am
Real-Time or batch file access direct from
State Office
States download from PRISM SFTP _at_ 600am
After Daily Vehicle Record Uploads
After Daily Vehicle Record Uploads
18
NLETS Vehicle Registration
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
Example of South Carolina NLETS Vehicle
Registration Queries
19
Query Central (Vehicle)
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
Query Central Vehicle Search
Query Central PRISM Vehicle Information Summary
20
Query Central (Vehicle)
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
Query Central Carrier Data Results
Query Central Carrier PRISM Summary
21
NLETS Vehicle Target Status
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
PRISM AVQ (Vehicle) NLETS responses include
messages for OOSO, and provide the reason
MSG FROM NLETS 3639AVR.AVLIC0000.    TODEST IA07
710B5MRI0055497.TXT                     CARRIE
R IS UNDER FEDERAL OOSO UNSAT/UNFIT DOT/106714
2.NAM/CALIBER OILFIELD SERVICE INC ADR/1067 E
500 S CITY/VERNALST/UT.ZIP/84078.CAR TARG-HIST IN
D/T.MCSIP STEP/55.MCSIP DATE/12212008.VMA/FRHT.VY
R/87.VIN/1FV9YCY93HP309134.LIC/152708.JUR/UT.REG 
EFF DATE/11062008.REG EXP DATE/06302009.PAGE/01 O
F/01.
NLETS Vehicle Status Request (AVQ) Response
Message
22
PRISM Web Services
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
XML responses can be displayed within State
systems.
PRISM Web Services Targeted Vehicle Inquiry
23
PRISM Target File
Data Availability
Freshest Data
Stalest Data
Query Central (ad-hoc)
CVIEWT0041P(batch)
NLETS Vehicle Inquiry(ad-hoc)
NLETS Vehicle Registration(ad-hoc)
PRISM Web Services (ad-hoc)
PRISM Target File(batch)
Example of Nebraska CVIEW using PRISM Target File
for Vehicle Validation