1 / 32

PRISM Data Flow & Timeliness

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.

jermaine-alford
Download Presentation

PRISM Data Flow & Timeliness

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PRISM Data Flow & Timeliness Last 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 @ Midnight Saturday @ 8:00 am Key Enforcement Data USDOT NumberCarrier NameTargeted IndicatorOOSO Status SAFER - PRISM • Data sent from MCMIS to SAFER-PRISM database via nightly MCMIS Updates • Several different sources to access key data

  5. PRISM Carrier Census Data MCMIS Database Authoritative Source OOSO Status MCMIS UpdateMonday – Thursday @ Midnight Saturday @ 8:00 am Key Enforcement Data USDOT NumberCarrier NameTargeted IndicatorOOSO Status SAFER - PRISM PRISM SFTP Site SAFER FTP Site Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File (batch) CVIEWT0031(batch) ISS(batch) After MCMIS Update(Real-time for OOSO Status) After MCMIS Update After MCMIS Update After MCMIS Update States download from PRISM SFTP @ 6:00 am States download from SAFER FTP @ 8:00 am Monthly SafeStat Calc.Weekly SAFER Calc. Ad-hoc Client Refresh

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

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

  8. Query Central (Carrier) Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(batch)

  9. NLETS Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(batch) MSG FROM NLETS 8098ACR.AVLIC0000.    TO:DEST IA07710B5*MRI0069282.TXT                   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/200901181200T175 19MESSAGE FROM NLTS069295 PRISM ACR (Carrier) NLETS responses include messages for OOSO, and also provide the reason.

  10. SAFER Website Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(batch)

  11. SAFER Website

  12. SAFER Website

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

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

  15. PRISM Census File Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(batch) PRISM States download daily Census File Updates from the PRISM SFTP Server Flat File Data Format

  16. CVIEW T0031 Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(batch) CVISN States download daily T0031 File Updates from the SAFER FTP Server XML File Data Format

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

  18. ISS – Inspection Selection System Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) PRISM Census File(batch) CVIEW T0031 (batch) ISS(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.

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

  20. PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source Daily Vehicle Record Uploads PRISM PVF - 5:00am 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 • Data is sent from the State Vehicle Registration Office to the SAFER-PRISM database via Daily Uploads • Several different sources to access vehicle data

  21. PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source Daily Vehicle Record Uploads PRISM PVF - 5:00am 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) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Real-Time or batch file access direct from State Office After Daily Vehicle Record Uploads States download from PRISM SFTP @ 6:00am States download from PRISM SFTP @ 6:00am After Daily Vehicle Record Uploads After Daily Vehicle Record Uploads

  22. NLETS Vehicle Registration Query Central (ad-hoc) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Example of South Carolina NLETS Vehicle Registration Queries

  23. Query Central (Vehicle) Query Central (ad-hoc) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch)

  24. Query Central (Vehicle)

  25. Query Central (Vehicle)

  26. Query Central (Vehicle)

  27. NLETS Vehicle Target Status Query Central (ad-hoc) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) PRISM AVR (Vehicle) NLETS responses include messages for OOSO, and also provide the reason. MSG FROM NLETS 3639AVR.AVLIC0000.    TO:DEST IA07710B5*MRI0055497.TXT                     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/1FV9YCY93HP309134.LIC/152708.JUR/UT.REG EFF DATE/11062008.REG EXP DATE/06302009.PAGE/01 OF/01.

  28. PRISM Web Services Query Central (ad-hoc) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Web Services uses XML data to transfer query responses to the State

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

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

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

  32. PRISM Target File Query Central (ad-hoc) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Example screenshot of Nebraska’s IRP System with PRISM Target File data

More Related