1 / 25

PRISM Data Flow & Timeliness

PRISM Data Flow & Timeliness. FMCSA - PRISM Technical Support Last Updated: 1-31-2008. PRISM Data Types. Carrier Census Data Information about Motor Carriers Vehicle Registration Data IRP Vehicle Registration Information. PRISM Carrier Census Data. MCMIS Database. Authoritative Source.

daniel_millan
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 FMCSA - PRISM Technical Support Last Updated: 1-31-2008

  2. PRISM Data Types • Carrier Census Data • Information about Motor Carriers • Vehicle Registration Data • IRP Vehicle Registration Information

  3. PRISM Carrier Census Data MCMIS Database Authoritative Source • The MCMIS database is the 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 ISS Score SAFER - PRISM • Data is sent from MCMIS to the SAFER-PRISM database via MCMIS Updates. • Once the data is in the SAFER-PRISM database, there are 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 ISS Score SAFER - PRISM SAFER FTP Site PRISMSFTP Site Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) After MCMIS Update(Real-time for OOSO Status) After MCMIS Update After MCMIS Update After MCMIS Update States download from SAFER FTP @ 8:00 am States download from PRISM SFTP @ 8:00 pm 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) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) Query Central Carrier Data Results Query Central Carrier Search

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

  8. NLETS Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) NLETS Carrier Status Request (ACQ) Response Message

  9. SAFER Website Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) SAFER Company Snapshot Results SAFER Company Snapshot Search

  10. SAFER Website - (Cont.) Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) SAFER Company Snapshot OOS Details Results

  11. SAFER Web Services Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) PRISM Web Services Client for SAFER T0031 Query PRISM Web Services Results for SAFER T0031 Query

  12. CVIEW T0031 Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) SAFER FTP Site with available CVIEW T0031 Zip Files SAFER T0031 – XML Data File

  13. CVIEW T0031 Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) Example of Nebraska CVIEW using T0031 Data for Carrier OOS Status

  14. PRISM Census File Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) PRISM Daily Census File on SFTP Server PRISM Daily Census File – AFF Text File Data

  15. ISS – Inspection Selection System Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) SAFER Web Services(ad-hoc) CVIEWT0031(batch) PRISM Census File(batch) ISS(batch) ISS Carrier Search Results with Out-of-Service Notification ISS Carrier Search Results Screen

  16. PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source • The State Vehicle Registration Office is the authoritative source of PRISM Vehicle Registration Data.

  17. PRISM Vehicle Registration Data State Vehicle Registration Office Authoritative Source Daily Vehicle Record Uploads PRISM PVF - 5:00amCVIEW 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 Updates. • Once the data is in the SAFER-PRISM database, there are several different sources to access key data.

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

  19. NLETS Vehicle Registration Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) Example of South Carolina NLETS Vehicle Registration Queries

  20. Query Central (Vehicle) Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) Query Central Vehicle Search Query Central PRISM Vehicle Information Summary

  21. Query Central (Vehicle) Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) Query Central Carrier Information Summary Query Central Carrier PRISM Summary

  22. NLETS Vehicle Target Status Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Status Request (AVQ) Response Message

  23. CVIEW T0041P Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) PRISM SFTP Server with available CVIEW T0041P File PRISM CVIEW T0041P – XML Data File

  24. PRISM Target File Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) CVIEWT0041P(batch) PRISM SFTP Server with available PRISM Target File PRISM Daily Target File – AFF Text File Data

  25. PRISM Target File Data Availability Freshest Data Stalest Data NLETS Vehicle Registration(ad-hoc) CVIEWT0041P(batch) PRISM Target File(batch) Query Central (ad-hoc) NLETS Vehicle Target Status(ad-hoc) Example of Nebraska CVIEW using PRISM Target File for Vehicle Validation

More Related