1 / 23

PRISM Data Flow & Timeliness for Law Enforcement

PRISM Data Flow & Timeliness for Law Enforcement. 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.

maj
Download Presentation

PRISM Data Flow & Timeliness for Law Enforcement

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 & 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 @ Midnight Saturday @ 8:00 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 @ Midnight Saturday @ 8:00 am Key Enforcement Data USDOT NumberCarrier NameTargeted IndicatorOOSO Status SAFER - PRISM 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) CVIEWT0031(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 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) CVIEWT0031(batch) 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 Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) CVIEWT0031(batch) ISS(batch) Query Central Carrier OOS Descriptions

  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) CVIEWT0031(batch) ISS(batch) Query Central Carrier PRISM Summary

  9. NLETS Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) CVIEWT0031(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 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 Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) CVIEWT0031(batch) ISS(batch) SAFER Company Snapshot Results SAFER Company Snapshot Search

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

  12. PRISM Web Services Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) CVIEWT0031(batch) ISS(batch) XML responses can be displayed within State systems. PRISM Web Services Carrier Inquiry

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

  14. ISS – Inspection Selection System Data Availability Freshest Data Stalest Data Query Central(ad-hoc) NLETSCarrier Inquiry(ad-hoc) SAFER Website(ad-hoc) PRISM Web Services(ad-hoc) CVIEWT0031(batch) ISS(batch) 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 - 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 • 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 - 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

  18. NLETS Vehicle Registration 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) Example of South Carolina NLETS Vehicle Registration Queries

  19. Query Central (Vehicle) 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) Query Central Vehicle Search Query Central PRISM Vehicle Information Summary

  20. Query Central (Vehicle) 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) 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) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) PRISM AVQ (Vehicle) NLETS responses include messages for OOSO, and 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. NLETS Vehicle Status Request (AVQ) Response Message

  22. PRISM Web Services 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) 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) NLETS Vehicle Inquiry(ad-hoc) PRISM Web Services (ad-hoc) CVIEWT0041P(batch) NLETS Vehicle Registration(ad-hoc) PRISM Target File(batch) Example of Nebraska CVIEW using PRISM Target File for Vehicle Validation

More Related