PRISM Data Flow Timeliness Last Updated February

PRISM Data Flow & Timeliness Last Updated: February 2009

PRISM Data Types • Carrier Census Data – Motor Carriers Information • Vehicle Registration Data – IRP Vehicle Registration Information

PRISM Carrier Census Data MCMIS Database Authoritative Source MCMIS – authoritative source of PRISM Carrier Census Data 3

PRISM Carrier Census Data MCMIS Database MCMIS Update Monday – Thursday @ Midnight Saturday @ 8: 00 am Authoritative Source Key Enforcement Data SAFER - PRISM USDOT Number Carrier Name Targeted Indicator OOSO Status • Data sent from MCMIS to SAFER-PRISM database via nightly MCMIS Updates • Several different sources to access key data 4

PRISM Carrier Census Data Authoritative Source MCMIS Database OOSO Status MCMIS Update Key Enforcement Data Monday – Thursday @ Midnight Saturday @ 8: 00 am USDOT Number Carrier Name Targeted Indicator OOSO Status SAFER - PRISM SFTP Site SAFER FTP Site Data Availability Freshest Data Stalest Data Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services (ad-hoc) After MCMIS Update (Real-time for OOSO Status) After MCMIS Update PRISM Census File CVIEW T 0031 (batch) States download from PRISM SFTP @ 6: 00 am States download from SAFER FTP @ 8: 00 am ISS (batch) Monthly Safe. Stat Calc. Weekly SAFER Calc. Ad-hoc Client Refresh

Query Central (Carrier) Data Availability Freshest Data Stalest Data Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) Query Central website can be accessed via FMCSA COMPASS Portal, without the need of VPN or UAS. 6

Query Central (Carrier) Data Availability Freshest Data Stalest Data Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) 7

Query Central (Carrier) Data Availability Freshest Data Stalest Data Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch)

NLETS Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) MSG FROM NLETS 8098 ACR. AVLIC 0000. TO: DEST IA 07710 B 5 *MRI 0069282. TXT PRISM ACR (Carrier) NLETS responses include messages for OOSO, and also provide the reason. CARRIER IS UNDER FEDERAL OOSO - UNSAT/UNFIT DOT/507290. NAM/STAR Z TRUCK LLC. ADR/7902 ENGLEWOOD. CITY/YAKIMA. ST/WA. ZIP/98908. CAR TARG‑HIST IND/T. MCSIP STEP/55. MCSIP Date/12312008 PAGE/01 OF/01. ; 200901181200/200901181200 T 175 19 MESSAGE FROM NLTS 069295 ISS (batch)

SAFER Website Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch)

SAFER Website

PRISM Web Services Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) PRISM Web Services uses XML data to transfer query responses to the State.

PRISM Web Services Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) PRISM States receive the XML formatted response and can then display the Carrier’s data within their local applications.

PRISM Census File Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) PRISM States download daily Census File Updates from the PRISM SFTP Server Flat File Data Format

CVIEW T 0031 Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS (batch) CVISN States download daily T 0031 File Updates from the SAFER FTP Server XML File Data Format

CVIEW T 0031 This is an example screenshot of how Nebraska uses the CVIEW T 0031 data in its IRP System.

ISS – Inspection Selection System Query Central NLETS Carrier Inquiry SAFER Website PRISM Web Services PRISM Census File CVIEW T 0031 (ad-hoc) (batch) ISS Users still need to confirm with other sources about the status of the OOSO, since the ISS data is not updated in real-time such as QC.

PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source State Vehicle Registration Office - authoritative source of PRISM Vehicle Registration Data 19

PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source Daily Vehicle Record Uploads Key Enforcement Data PRISM PVF - 5: 00 am CVIEW XML - Throughout the day or evening batch upload. (dependent on State process) SAFER - PRISM VIN, State/Plate Registration Expire Date, Carrier Resp. for Safety • Data is sent from the State Vehicle Registration Office to the SAFER-PRISM database via Daily Uploads • Several different sources to access vehicle data 20

PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source Daily Vehicle Record Uploads Key Enforcement Data PRISM PVF - 5: 00 am CVIEW XML - Throughout the day or evening batch upload. (dependent on State process) SAFER - PRISM VIN, State/Plate Registration Expire Date, Carrier Resp. for Safety PRISM SFTP Site Data Availability Freshest Data NLETS Vehicle Registration (ad-hoc) Real-Time or batch file access direct from State Office Stalest Data Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) After Daily Vehicle Record Uploads States download from PRISM SFTP @ 6: 00 am After Daily Vehicle Record Uploads

NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) Example of South Carolina NLETS Vehicle Registration Queries

Query Central (Vehicle) NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch)

Query Central (Vehicle)

NLETS Vehicle Target Status NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) MSG FROM NLETS 3639 AVR. AVLIC 0000. TO: DEST IA 07710 B 5 *MRI 0055497. TXT PRISM AVR (Vehicle) NLETS responses include messages for OOSO, and also provide the reason. CARRIER IS UNDER FEDERAL OOSO – UNSAT/UNFIT DOT/1067142. NAM/CALIBER OILFIELD SERVICE INC ADR/1067 E 500 S CITY/VERNALST/UT. ZIP/84078. CAR TARG‑HIST IND/T. MCSIP STEP/55. MCSIP DATE/12212008. VMA/FRHT. VYR/87. VIN/1 FV 9 YCY 93 HP 309134. LIC/152708. JUR/UT. REG EFF DATE/11062008. REG EXP DATE/06302009. PAGE/01 OF/01.

PRISM Web Services NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) Web Services uses XML data to transfer query responses to the State

PRISM Web Services NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) XML responses can be displayed within State systems.

CVIEW T 0041 P NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) States download T 0041 P file from SFTP Server XML Data Format 30

PRISM Target File NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) States download daily Target File from the PRISM SFTP Server Flat File Data Format 31

PRISM Target File NLETS Vehicle Registration (ad-hoc) Query Central NLETS Vehicle Inquiry PRISM Web Services CVIEW T 0041 P PRISM Target File (ad-hoc) (batch) Example screenshot of Nebraska’s IRP System with PRISM Target File data