2008 NIC VACMAN NIPVAC

Slide 1
VACMAN AND NIPVAC:  Centralized Distribution
March 18, 2008

Slide 2
Overview
4	VMBIP SYSTEMS ARCHITECTURE
4	CENTRALIZED DISTRIBUTION STATISTICS
4	ISSUE SUMMARY
4	IMPROVEMENT INITIATIVES
4	SUMMARY

Slide 3
A high-level architecture of the VMBIP environment, including CDC and McKesson IT systems
VMBIP 

Systems Architecture

Grantee Systems
Keys into VACMAN

CDC Systems
CDC Firewall
SDN File Transfer
	Siteminder
	Authorization Authentication
	SDN Secured Data Network SDN@cdc.gov 
	DPS Distributed Processing Service
SDN Service
Fileserver
NIPVAC
EDI

Manufacturers Systems
Manufacturer’s Processing Server

CDC Systems
EDI
NIPVAC
Fileserver – information goes two ways.  This is the path of the first way.
Extract, Transform, and Load (ETL informatica)
Data Warehouse
Extract, Transform, and Load
Data Mart
Reporting System (Business Objectives and Crystal)
Vaccine Order Reports
Other Reports
Distribution Data Reports
Fileserver – this is the path of the second way
SDN Server
CDC Firewall

McKesson Systems
McKesson (TecSys)
McKesson SAP
Business Intelligence

CDC Systems
CDC Firewall

Grantee Systems
VACMAN

Slide 4
CENTRALIZED DISTRIBUTION AS OF:  March 17, 2008
4	GRANTEES STILL TO TRANSITION:  19
4	VACMAN/NIPVAC STATS 
–	ORDERS PROCESSED – 871,282
–	ORDER RECEIPTS PROCESSED – 861,768
–	ORDERS CANCELLED – 4,436
–	SHIPMENTS CANCELLED FROM MCKESSON – 1,491
–	REPLENISHMENT ORDERS – 2,605
Data Source: NIPVAC

Slide 5
VACMAN/NIPVAC—WHAT CAN HAPPEN?
4	SENDING ORDERS
–	GRANTEE DOESN’T COMPLETE ALL 4 STEPS TO SEND ORDERS
–	PACKAGE DOESN’T CONTAIN ORDERS
–	PACKAGE IS INVALID
	-- CORRUPT DATA
            -- USER SENDS WRONG PACKAGE    
4	PROVIDER ORDERS
–	HELD AT CDC
–	REJECTED
–	DUPLICATES

Slide 6
VACMAN/NIPVAC—WHAT CAN HAPPEN? (continued)
4	RECEIPT INFORMATION
–	TAKES A WHILE TO COME BACK FROM MCKESSON
–	GRANTEE CAN PUT RECEIPTS FILE IN THE WRONG FOLDER
–	CDC GETS RECEIPT FILE; GRANTEE DOES NOT
   -- NIGHTLY PROCESS ON MAINFRAME FAILED
   -- NIGHTLY PROCESS ON SERVER FAILED
   -- FILE CORRUPTION OCCURS DURING FTP
   -- MCKESSON SENDS AFTER 5:30 P.M.

Slide 7
ISSUES SUMMARY
A Very Random Sample 10/09/07 – 3/5/08

Source: Grantee
Issue Type: Upload Error
Number of Occurrences: 3

Source: Grantee
Issue Type: Download Error
Number of Occurrences: 5

Source: Grantee
Issue Type: Data Corruption Error
Number of Occurrences: 5*
* One unconfirmed.  Data Source: Email to Software Project Manager

Source: Grantee
Issue Type: Local Network and Admin Rights
Number of Occurrences: 2

Source: CDC
Issue Type: VACMAN Bug
Number of Occurrences: 4

Source: CDC
Issue Type: Rejected Orders
Number of Occurrences: 1

Source: CDC
Issue Type: Funding Issues
Number of Occurrences: 4

Source: CDC
Issue Type: Order Tracking
Number of Occurrences: 4

Source: McKesson
Issue Type: Over Shipment
Number of Occurrences: 1

Source: McKesson
Issue Type: Order Processing
Number of Occurrences: 1

Source: McKesson
Issue Type: Order Tracking
Number of Occurrences: 1

Slide 8
IMPROVEMENT INITIATIVES
4	ORDER ID TRACKING – VACMAN HELP DESK INITIATES CONTACT WITH GRANTEE
4	REJECTED ORDERS – EMAIL TO VSAB
4	RECEIPTS OUTSTANDING > 21 DAYS
4	FUNDING THRESHOLD REPORT TO RAM TEAM
–	QUARTERLY PROJECTIONS VICE ANNUAL PROJECTIONS
4	MULTIPLE RECEIPT SCREEN IN VACMAN
4	PHIN-MS
4	ALLOCATION MANAGEMENT

Slide 9
Summary
4	VMBIP SYSTEMS ARCHITECTURE
4	VACMAN/NIPVAC STATISTICS
4	VACMAN/NIPVAC—WHAT CAN HAPPEN
4	ISSUE SUMMARY
4	IMPROVEMENT INITATIVES

This document can be found on the CDC website at:
http://www.cdc.gov/vaccines/programs/vmbip/downloads/nic/08-nic-vacman-nipvac.rtf