Transcript Data Quality And Standardization Initiatives Within Government

Data Quality And Standardization
Initiatives Within Government
Rob Dixon
Senior Consultant
www.oniqua.com
PACS XII Meeting
 Data Quality – what is it?
– The degree to which our data correlates with factual information based
on accuracy, consistency, currency and completeness

Four Measures are –
• Accuracy – the measure or degree of agreement between a value (or
set of values) and reality. The data is correct for what is being
represented
• Consistency - the data passes all system edits for acceptability (e.g.
format, length, positions)
• Currency – The data is up to date and the age of the data is
appropriate for the task at hand.
• Completeness – The measured data that should have values in them,
in fact do so. Input would be based on customer/system needs.
Driving Asset Performance
2
www.oniqua.com
PACS XII Meeting
MASTER DATA AND ITS RELATIONSHIP
Once data is shared it becomes an enterprise asset.
It does not solely belong to the owners of the data or the
authoritative sources. It also belongs to the users of the
data. This includes the surgeon in theater, the supply point
that orders the item, and the procurement and financial
personnel.
Driving Asset Performance
3
www.oniqua.com
PACS XII Meeting
MASTER DATA AND ITS RELATIONSHIP cont…
User
Planning
Production
SUPPLY
CATALOG
Finance
Purchasing
Design
Inventory
Warehousing
Driving Asset Performance
4
www.oniqua.com
PACS XII Meeting
The enterprise maturity model
The aim is to move up the enterprise maturity model through data quality improvements.
Driving Asset Performance
5
www.oniqua.com
PACS XII Meeting
Root Causes of Poor Data Quality
Driving Asset Performance
6
www.oniqua.com
PACS XII Meeting
Data quality improvement:
From this…
…correcting content and layout…:
7.
1.
9.
2.
2.
3.
4.
6.
5.
1.
6.
12.
7.
10.
8.
13.
9.
8.
10.
11.
11.
3.
12.
5.
13.
14.
14.
BOLT,
.375”6IN
UNFLONG
X 6.0”UNC
GRADE
5 C/W5 NUT
AND
WASHER
BLACK
3/4”
BOLT,
GRADE
W/NUT
AND
WASHER
BOLT,
3/4 X
UNC
X 5-1/2IN
HEAD
3/4”
UNC
6” HEX
HEADHEX
UNC
BOLTGRADE 5
BOLT,
3/4”XUNC
X 6”PLATED
HEX HEAD
3/4”
UNC
6” ZINC
HEX HEAD UNC SCREW
BOLT,
3/4”
UNC
X 6” HEX
GRADE
5
3/4”
X 6”
HEX
HEAD
UNC HEAD
GRADE
5 BOLT
BOLT,
3/4”
UNC
X 6” LONG
GRADE55SCEW ZINC FINISH
3/4”
X 6”
HEX
HEAD
UNC GRADE
BOLT,
3/4” UNC,
LONG5GRADE
5 W/NUT AND WASHER
6”IN
LONG
BOLT6IN
GRADE
3/4”UNC
BOLT, 3/4”
UNC XBLACK
6” LONG
HEXAGON
HEAD
GRADE
5 WITH NUT AND WASHER
GRADE
5 BOLT
.375”
X 6.0” UNF
C/WTO
NUT
AND WASHER
BOLT, 3/4IN
UNC X BLACK
6IN LG .375”
HEX HEAD
WITH
NUT
AND
WASHER
GRADE
5 SCREW
X 6.0” GDE
UNF 5C/W
NUT
AND
WASHER
BOLT,
3/8IN 3/4
UNCX X
6IN GRADE
5 C/NUT5AND WASHER BLACK
HEX BOLT
5-1/2IN
UNC GRADE
SCREW,
.375”BOLT
UNF UNC
X 6.0”3/4IN
GRADE
5 C/W
BLACKGDE 5
HEX HEAD
X 6IN
LG NUT
WITHAND
NUTWASHER
AND WASHER
SCREW,
3/4 UNC
GRADE
5 5
HEX SCREW
3/4XX5-1/2IN
5-1/2INHEX
UNC
GRADE
SCREW,
3/4”HEAD
UNC XBOLT
6” HEX
HEAD X
ZINC
PLATED
HEXAGON
3/4”UNC
6” LONG
TO GRADE 5 W/NUT AND WASHER
SCREW,
3/4”3/8IN
UNC X
HEX
HEAD
GRADE
5 ZINC
FINISH
UNC BOLT
X 6”
6 IN
C/NUT
AND
WASHER
BLACK
GRADE 5
SCREW,
3/8IN UNC
GRADE
C/NUT
AND WASHER
UNC SCREW
3/8INXX6IN
6 IN
C/NUT5AND
WASHER
BLACKBLACK
GRADE 5
Driving Asset Performance
7
www.oniqua.com
PACS XII Meeting
…through Standards and Encoding Rules…
Driving Asset Performance
8
www.oniqua.com
PACS XII Meeting
…to this...
9.
6.
1.
2.
4.
10.
12.
13.
14.
7.
8.
11.
3.
5.
BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5
BOLT, MACHINE; 3/4” UNC X 6” GDE 5
BOLT, MACHINE; 3/4” UNC X 6” GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/8” UNC X 6” GDE 5 W/NUT AND WASHER BLACK
BOLT, MACHINE; 3/8” UNC X 6” GDE 5 W/NUT AND WASHER BLACK
BOLT, MACHINE; 3/8” UNF X 6” GDE 5 W/NUT AND WASHER BLACK
BOLT, MACHINE; 3/8” UNF X 6” GDE 5 W/NUT AND WASHER BLACK
SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5
SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD ZINC PLATED
SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 ZINC PLATED
Driving Asset Performance
9
www.oniqua.com
PACS XII Meeting
... and then this…
9.
12.
14.
8.
11.
5.
•
BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/8” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK
BOLT, MACHINE; 3/8” UNF X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK
SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5
SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 ZINC PLATED
Inventory reduction:- From 14 Stock Numbers (SKUs) to 6 by
removing duplications. A further reduction is now possible
through rationalization.
Driving Asset Performance
10
www.oniqua.com
... and eventually to this.
9.
12.
14.
8.
11.
5.
•
BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER
BOLT, MACHINE; 3/8” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK
BOLT, MACHINE; 3/8” UNF X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK
SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5
SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 ZINC PLATED
This potential
Inventory
reduction:is true across
From 14
your
Stock
whole
Numbers
inventory.
(SKUs) to 6 by
removing duplications. A further reduction is now possible
through rationalization.
Driving Asset Performance
11
www.oniqua.com
PACS XII Meeting
NSW HEALTH
A daunting task.
Driving Asset Performance
12
www.oniqua.com
PACS XII Meeting
During the late 90s
NSW
Health Commissioned
an extensive review of
their supply chain NOTICE: DISBANDMENT OF THE HEALTH PEAK PURCHASING COUNCIL (HPPC)
management...
The last twelve years the HPPC has taken a pivotal role in the system wide supply chain reform process.
However, notwithstanding these achievements, the amalgamation of AHS, the introduction of new
corporate governance arrangements and the move towards implementing statewide shared corporate
services, necessitated change. This includes the disbandment of the HPPC with the relevant consultative
bodies set-up as part of the Shared Corporate Services Program.
The functions and resources of the former HPPC Secretariat were transitioned into Health Support Services.
Exceptions are functions transitioned into the Asset and Contract Services Branch, i.e. renewal of state
Contracts
For further information about the NSW Health Shared Corporate Services Program please click here
Driving Asset Performance
13
www.oniqua.com
PACS XII Meeting
NSW Health heads down e-procurement path
Article: itnews - Dec 15, 2008 2:39 PM
The NSW Department of Health will implement a new e-procurement hub to standardise its purchasing processes.
The hub is based on Gentran Integration Suite (GIS), an SOA-based platform developed by Sterling Commerce.
Sterling Commerce won the tender as part of a consortium that also includes Fusion Management and e-Centric Innovations.
With the design stage already having commenced, testing and user acceptance is scheduled for February 2009. The system is
due to go live in March 2009.
It replaces a previously manual system, Sterling Commerce said in a statement.
The new system will keep track of some 30,000 internal items and potentially millions of vendor items purchased annually across
the state.
Specifically, it will supply the department with the capability to maintain internal data for each product, while enabling receipt and
management of vendor data via an on-line interface to the National Product Catalogue (NPC), an online data pool managed by
GS1 Australia and administered to NSW Health by the National E-Health Transition Authority (NEHTA).
The NPC allows institutions in all States and Territories to obtain essential information about the medicines, medical devices and
healthcare products they use, from one electronic source. It also holds information about non-medical products, such as office
supplies and food items.
Vendors not using the NPC will be able to add their term data directly into a web entry page. This form will enable one by one
entry of term and pricing data or new items, changes to existing items and deletion of items, Sterling Commerce said.
All new vendor data will be maintained in the vendor catalogue and updated automatically when additions or changes are
submitted, the company said.
NSW Health users will be able to directly log-in to the catalogue, receive and manage contract data from NSW Commerce, and
publish files to other systems, including the NSW Health Oracle ERP system and the Department of Commerce Smartbuy
application, it added.
Driving Asset Performance
14
www.oniqua.com
PACS XII Meeting
Driving Asset Performance
15
www.oniqua.com
PACS XII Meeting
Driving Asset Performance
16
www.oniqua.com
PACS XII Meeting
Driving Asset Performance
17
www.oniqua.com
PACS XII Meeting
Driving Asset Performance
18
www.oniqua.com
PACS XII Meeting
Driving Asset Performance
19
www.oniqua.com
PACS XII Meeting
QUESTIONS?
Thank you.
Driving Asset Performance
20
www.oniqua.com