Data Quality And Standardization Initiatives Within Government

1
Data Quality And Standardization Initiatives
Within Government
Rob Dixon Senior Consultant
2
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.

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

4
PACS XII Meeting
MASTER DATA AND ITS RELATIONSHIP cont
SUPPLY CATALOG
5
PACS XII Meeting
The enterprise maturity model
The aim is to move up the enterprise maturity
model through data quality improvements.
6
PACS XII Meeting
Root Causes of Poor Data Quality
7
PACS XII Meeting
Data quality improvement
From this
correcting content and layout
7. BOLT, .375 UNF X 6.0 GRADE 5 C/W NUT AND
WASHER BLACK 9. BOLT, 3/4 UNC X 5-1/2IN HEX
HEAD GRADE 5 2. BOLT, 3/4 UNC X 6 HEX
HEAD 4. BOLT, 3/4 UNC X 6 HEX HEAD GRADE
5 6. BOLT, 3/4 UNC X 6 LONG GRADE 5 1.
BOLT, 3/4 UNC, 6IN LONG GRADE 5 W/NUT AND
WASHER 12. BOLT, 3/4 UNC X 6 LONG HEXAGON
HEAD TO GRADE 5 WITH NUT AND WASHER 10. BOLT,
3/4IN UNC X 6IN LG HEX HEAD GDE 5 WITH NUT AND
WASHER 13. BOLT, 3/8IN UNC X 6IN GRADE 5 C/NUT
AND WASHER BLACK 8. SCREW, .375 UNF X 6.0
GRADE 5 C/W NUT AND WASHER BLACK 11. SCREW, 3/4
UNC X 5-1/2IN HEX GRADE 5 3. SCREW, 3/4 UNC
X 6 HEX HEAD ZINC PLATED 5. SCREW, 3/4 UNC
X 6 HEX HEAD GRADE 5 ZINC FINISH 14. SCREW,
3/8IN UNC X 6IN GRADE 5 C/NUT AND WASHER BLACK
1. 3/4 BOLT, 6IN LONG UNC GRADE 5 W/NUT AND
WASHER 2. 3/4 UNC X 6 HEX HEAD UNC BOLT 3.
3/4 UNC X 6 ZINC PLATED HEX HEAD UNC SCREW 4.
3/4 X 6 HEX HEAD UNC GRADE 5 BOLT 5. 3/4
X 6 HEX HEAD UNC GRADE 5 SCEW ZINC FINISH 6.
6IN LONG BOLT GRADE 5 3/4UNC 7. GRADE 5 BOLT
BLACK .375 X 6.0 UNF C/W NUT AND WASHER 8.
GRADE 5 SCREW BLACK .375 X 6.0 UNF C/W NUT AND
WASHER 9. HEX BOLT 3/4 X 5-1/2IN UNC GRADE
5 10. HEX HEAD BOLT UNC 3/4IN X 6IN LG WITH NUT
AND WASHER GDE 5 11. HEX SCREW 3/4 X 5-1/2IN
UNC GRADE 5 12. HEXAGON HEAD BOLT 3/4UNC X 6
LONG TO GRADE 5 W/NUT AND WASHER 13. UNC BOLT
3/8IN X 6 IN C/NUT AND WASHER BLACK GRADE 5 14.
UNC SCREW 3/8IN X 6 IN C/NUT AND WASHER BLACK
GRADE 5
8
PACS XII Meeting
through Standards and Encoding Rules
9
PACS XII Meeting
to this...
9. BOLT, MACHINE 3/4 UNC X 5-1/2 HEX HEAD GDE
5 6. BOLT, MACHINE 3/4 UNC X 6 GDE 5 1. BOLT,
MACHINE 3/4 UNC X 6 GDE 5 W/NUT AND
WASHER 2. BOLT, MACHINE 3/4 UNC X 6 HEX
HEAD 4. BOLT, MACHINE 3/4 UNC X 6 HEX HEAD GDE
5 10. BOLT, MACHINE 3/4 UNC X 6 HEX HEAD GDE 5
W/NUT AND WASHER 12. BOLT, MACHINE 3/4 UNC X 6
HEX HEAD GDE 5 W/NUT AND WASHER 13. BOLT,
MACHINE 3/8 UNC X 6 GDE 5 W/NUT AND WASHER
BLACK 14. BOLT, MACHINE 3/8 UNC X 6 GDE 5
W/NUT AND WASHER BLACK 7. BOLT, MACHINE 3/8 UNF
X 6 GDE 5 W/NUT AND WASHER BLACK 8. BOLT,
MACHINE 3/8 UNF X 6 GDE 5 W/NUT AND WASHER
BLACK 11. SCREW, MACHINE 3/4 UNC X 5-1/2 HEX
HEAD GDE 5 3. SCREW, MACHINE 3/4 UNC X 6 HEX
HEAD ZINC PLATED 5. SCREW, MACHINE 3/4 UNC X 6
HEX HEAD GDE 5 ZINC PLATED
10
PACS XII Meeting
... and then this
9. BOLT, MACHINE 3/4 UNC X 5-1/2 HEX HEAD GDE
5 W/NUT AND WASHER 12. BOLT, MACHINE 3/4 UNC X
6 HEX HEAD GDE 5 W/NUT AND WASHER 14. BOLT,
MACHINE 3/8 UNC X 6 HEX HEAD GDE 5 W/NUT AND
WASHER BLACK 8. BOLT, MACHINE 3/8 UNF X 6 HEX
HEAD GDE 5 W/NUT AND WASHER BLACK 11. SCREW,
MACHINE 3/4 UNC X 5-1/2 HEX HEAD GDE
5 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.

11
... and eventually to this.
9. BOLT, MACHINE 3/4 UNC X 5-1/2 HEX HEAD GDE
5 W/NUT AND WASHER 12. BOLT, MACHINE 3/4 UNC X
6 HEX HEAD GDE 5 W/NUT AND WASHER 14. BOLT,
MACHINE 3/8 UNC X 6 HEX HEAD GDE 5 W/NUT AND
WASHER BLACK 8. BOLT, MACHINE 3/8 UNF X 6 HEX
HEAD GDE 5 W/NUT AND WASHER BLACK 11. SCREW,
MACHINE 3/4 UNC X 5-1/2 HEX HEAD GDE
5 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.

• This potential is true across your whole
  inventory.

12
PACS XII Meeting
NSW HEALTH
A daunting task.
13
PACS XII Meeting
During the late 90s NSW Health Commissioned an
extensive review of their supply chain
management...
NOTICE DISBANDMENT OF THE HEALTH PEAK PURCHASING
COUNCIL (HPPC) 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
14
PACS XII Meeting
NSW Health heads down e-procurement path Article
itnews - Dec 15, 2008 239 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.

15
PACS XII Meeting
16
PACS XII Meeting
17
PACS XII Meeting
18
PACS XII Meeting
19
PACS XII Meeting
20
PACS XII Meeting
QUESTIONS?
Thank you.