# Presentation: 113873

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

-   The MCMIS database is the authoritative source of PRISM Carrier Census Data.

*Authoritative *
*Source*

## PRISM Carrier Census Data

- MCMIS Database

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

*Authoritative *
*Source*

**Key Enforcement Data**

**MCMIS Update**Monday – Thursday @ Midnight
- Saturday @ 8:00 am

- SAFER - PRISM

- USDOT NumberCarrier NameTargeted IndicatorOOSO Status
- ISS Score

## PRISM Carrier Census Data

**Query **
**Central***(ad-hoc)*

- MCMIS Database

**Key Enforcement Data**

**MCMIS Update**Monday – Thursday @ Midnight
- Saturday @ 8:00 am

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

- SAFER - PRISM

**ISS***(batch)*

*Authoritative *
*Source*

**OOSO ****Status**

- USDOT NumberCarrier NameTargeted IndicatorOOSO Status
- ISS Score

- After
- MCMIS Update*(Real-time for **OOSO Status)*

- After
- MCMIS
- Update

- After
- MCMIS
- Update

- Monthly SafeStat Calc.Weekly SAFER Calc.
- Ad-hoc Client Refresh

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**PRISM****SFTP Site**

** ****SAFER **
**FTP Site**

- States download
- from PRISM
- SFTP @ 8:00 pm

- States download
- from SAFER
- FTP @ 8:00 am

**SAFER**
**Web Services***(ad-hoc)*

- After
- MCMIS
- Update

## Query Central (Carrier)

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**NLETS****Carrier Inquiry***(ad-hoc)*

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*Query Central Carrier Search*

*Query Central Carrier Data Results*

## Query Central (Carrier) – (Cont.)

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**NLETS****Carrier Inquiry***(ad-hoc)*

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*Query Central Carrier PRISM Summary*

## NLETS

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

***Data Availability***

*** ******Freshest Data***

***Stalest Data***

*NLETS Carrier Status Request (ACQ) Response Message *

## SAFER Website

**NLETS****Carrier Inquiry***(ad-hoc)*

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*SAFER Company Snapshot Search*

*SAFER Company Snapshot Results*

## SAFER Website - (Cont.)

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*SAFER Company Snapshot OOS Details Results*

## SAFER Web Services

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*PRISM Web Services Client *
*for SAFER T0031 Query*

*PRISM Web Services Results *
*for SAFER T0031 Query*

## CVIEW T0031

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*SAFER FTP Site with available *
*CVIEW T0031 Zip Files*

*SAFER T0031 – XML Data File*

## CVIEW T0031

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*Example of Nebraska CVIEW using T0031 Data for Carrier OOS Status*

## PRISM Census File

**NLETS****Carrier Inquiry***(ad-hoc)*

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*PRISM Daily Census File on SFTP Server*

*PRISM Daily Census File – AFF Text File Data*

## ISS – Inspection Selection System

**Query **
**Central***(ad-hoc)*

**SAFER **
**Website***(ad-hoc)*

**CVIEW****T0031***(batch)*

**PRISM **
**Census File***(batch)*

**ISS***(batch)*

**SAFER**
**Web Services***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*ISS Carrier Search Results Screen*

*ISS Carrier Search Results with Out-of-Service Notification*

## PRISM Vehicle Registration Data

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

- State Vehicle Registration Office

*Authoritative *
*Source*

## PRISM Vehicle Registration Data

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

- State Vehicle Registration Office

**Key Enforcement Data**

- SAFER - PRISM

*Authoritative *
*Source*

- VIN, State/PlateRegistration Expire Date,Carrier Resp. for Safety

**Daily Vehicle **
**Record Uploads**
- PRISM PVF - 5:00amCVIEW XML - Throughout the day or evening batch upload. (dependent on State process)

## PRISM Vehicle Registration Data

- State Vehicle Registration Office

**Key Enforcement Data**

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

- SAFER - PRISM

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

*** ******Freshest Data***

***Stalest Data***

*Authoritative *
*Source*

- VIN, State/PlateRegistration Expire Date,Carrier Resp. for Safety

- After
- Daily Vehicle
- Record Uploads

- States download
- from PRISM
- SFTP @ 5:00am

**Daily Vehicle **
**Record Uploads**
- PRISM PVF - 5:00amCVIEW XML - Throughout the day or evening batch upload. (dependent on State process)

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

***Data Availability***

- Real-Time or
- batch file access
- direct from State Office

**PRISM****SFTP Site**

- States download
- from PRISM SFTP @ 5:00am

- After
- Daily Vehicle
- Record Uploads

## NLETS Vehicle Registration

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

*Example of South Carolina NLETS Vehicle Registration Queries*

## Query  Central (Vehicle)

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*Query Central Vehicle Search*

*Query Central PRISM Vehicle Information Summary*

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

## Query  Central (Vehicle)

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*Query Central Carrier Information Summary*

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

*Query Central Carrier PRISM Summary*

## NLETS Vehicle Target Status

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

*NLETS Vehicle Status Request (AVQ) Response Message *

## CVIEW T0041P

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*PRISM SFTP Server with available *
*CVIEW T0041P File*

*PRISM CVIEW T0041P – XML Data File*

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

## PRISM Target File

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

*PRISM SFTP Server with available *
*PRISM Target File*

*PRISM Daily Target File – AFF Text File Data*

**Query **
**Central**
*(ad-hoc)*

**CVIEW****T0041P***(batch)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

## PRISM Target File

*** ******Freshest Data***

***Stalest Data***

***Data Availability***

**Query **
**Central**
*(ad-hoc)*

**PRISM **
**Target File***(batch)*

**NLETS **
**Vehicle **
**Target Status***(ad-hoc)*

**NLETS**
**Vehicle ****Registration***(ad-hoc)*

*Example of Nebraska CVIEW using PRISM Target File for Vehicle Validation*

**CVIEW****T0041P***(batch)*