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 / 20

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


  • 151 Views
  • Uploaded on

PRISM Data Flow & Timeliness for Law Enforcement. FMCSA - PRISM Technical Support Last Updated: 1-29-2008. PRISM Data Types. Carrier Census Data Information about Motor Carriers Vehicle Registration Data IRP Vehicle Registration Information. PRISM Carrier Census Data. MCMIS Database.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.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 flow timeliness for law enforcement
PRISM Data Flow & Timelinessfor Law Enforcement

FMCSA - PRISM Technical Support

Last Updated: 1-29-2008

prism data types
PRISM Data Types
  • Carrier Census Data
    • Information about Motor Carriers
  • Vehicle Registration Data
    • IRP Vehicle Registration Information
slide3

PRISM Carrier Census Data

MCMIS Database

Authoritative

Source

  • The MCMIS database is the 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

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.
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

ISS Score

SAFER - PRISM

SAFER

FTP Site

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

After

MCMIS Update(Real-time for OOSO Status)

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)

CVIEWT0031(batch)

ISS(batch)

Query Central Carrier Data Results

Query Central Carrier Search

slide7

Query Central (Carrier) – (Cont.)

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

Query Central Carrier PRISM Summary

slide8

NLETS

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

NLETS Carrier Status Request (ACQ) Response Message

slide9

SAFER Website

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

SAFER Company Snapshot Results

SAFER Company Snapshot Search

slide10

SAFER Website - (Cont.)

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

SAFER Company Snapshot OOS Details Results

slide11

CVIEW T0031

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

Example of Nebraska CVIEW using T0031 Data for Carrier OOS Status

slide12

ISS – Inspection Selection System

Data Availability

Freshest Data

Stalest Data

Query

Central(ad-hoc)

NLETSCarrier Inquiry(ad-hoc)

SAFER

Website(ad-hoc)

CVIEWT0031(batch)

ISS(batch)

ISS Carrier Search Results with Out-of-Service Notification

ISS Carrier Search Results Screen

slide13

PRISM Vehicle Registration Data

State Vehicle Registration Office

Authoritative

Source

  • The State Vehicle Registration Office is the authoritative source of PRISM Vehicle Registration Data.
slide14

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

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

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

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

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

slide20

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