prism data flow timeliness for law enforcement l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
PRISM Data Flow & Timeliness for Law Enforcement PowerPoint Presentation
Download Presentation
PRISM Data Flow & Timeliness for Law Enforcement

Loading in 2 Seconds...

play fullscreen
1 / 23

PRISM Data Flow & Timeliness for Law Enforcement - PowerPoint PPT Presentation


  • 138 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'PRISM Data Flow & Timeliness for Law Enforcement' - maj


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
prism data types
PRISM Data Types
  • Carrier Census Data
    • Motor Carriers Information
  • Vehicle Registration Data
    • IRP Vehicle Registration Information
slide3

PRISM Carrier Census Data

MCMIS Database

Authoritative

Source

MCMIS– authoritative source of PRISM Carrier Census Data

slide4

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
prism carrier census data
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

slide6

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

slide7

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

slide8

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

slide9

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

slide10

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

slide11

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

slide12

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

slide13

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

slide14

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

slide15

PRISM Vehicle Registration Data

State Vehicle Registration Office

Authoritative

Source

State Vehicle Registration Office - authoritative source of PRISM Vehicle Registration Data

slide16

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
prism vehicle registration data
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

nlets vehicle registration
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

query central vehicle
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

query central vehicle20
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

nlets vehicle target status
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

slide22

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

slide23

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