www.oniqua.com data quality and standardization initiatives within government rob dixon senior...

www.oniqua.com

Data Quality And Standardization Initiatives Within Government

Rob DixonSenior Consultant

2Driving Asset Performance 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.


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.


PACS XII Meeting

MASTER DATA AND ITS RELATIONSHIP cont…

Purchasing

Warehousing

Finance

Production

Inventory

DesignSUPPLY

CATALOG

User

Planning


PACS XII Meeting

The enterprise maturity model

The aim is to move up the enterprise maturity model through data quality improvements.


PACS XII Meeting

Root Causes of Poor Data Quality


PACS XII Meeting

From this…

1. 3/4” BOLT, 6IN LONG UNC GRADE 5 W/NUT AND WASHER2. 3/4” UNC X 6” HEX HEAD UNC BOLT3. 3/4” UNC X 6” ZINC PLATED HEX HEAD UNC SCREW4. 3/4” X 6” HEX HEAD UNC GRADE 5 BOLT5. 3/4” X 6” HEX HEAD UNC GRADE 5 SCEW ZINC FINISH6. 6”IN LONG BOLT GRADE 5 3/4”UNC7. GRADE 5 BOLT BLACK .375” X 6.0” UNF C/W NUT AND WASHER8. GRADE 5 SCREW BLACK .375” X 6.0” UNF C/W NUT AND WASHER9. HEX BOLT 3/4 X 5-1/2IN UNC GRADE 510. HEX HEAD BOLT UNC 3/4IN X 6IN LG WITH NUT AND WASHER GDE 511. HEX SCREW 3/4 X 5-1/2IN UNC GRADE 512. HEXAGON HEAD BOLT 3/4”UNC X 6” LONG TO GRADE 5 W/NUT AND WASHER13. UNC BOLT 3/8IN X 6 IN C/NUT AND WASHER BLACK GRADE 514. UNC SCREW 3/8IN X 6 IN C/NUT AND WASHER BLACK GRADE 5

…correcting content and layout…:7. BOLT, .375” UNF X 6.0” GRADE 5 C/W NUT AND WASHER BLACK9. BOLT, 3/4 UNC X 5-1/2IN HEX HEAD GRADE 52. BOLT, 3/4” UNC X 6” HEX HEAD4. BOLT, 3/4” UNC X 6” HEX HEAD GRADE 56. BOLT, 3/4” UNC X 6” LONG GRADE 5 1. BOLT, 3/4” UNC, 6IN LONG GRADE 5 W/NUT AND WASHER12. BOLT, 3/4” UNC X 6” LONG HEXAGON HEAD TO GRADE 5 WITH NUT AND WASHER10. BOLT, 3/4IN UNC X 6IN LG HEX HEAD GDE 5 WITH NUT AND WASHER13. BOLT, 3/8IN UNC X 6IN GRADE 5 C/NUT AND WASHER BLACK8. SCREW, .375” UNF X 6.0” GRADE 5 C/W NUT AND WASHER BLACK11. SCREW, 3/4 UNC X 5-1/2IN HEX GRADE 53. SCREW, 3/4” UNC X 6” HEX HEAD ZINC PLATED5. SCREW, 3/4” UNC X 6” HEX HEAD GRADE 5 ZINC FINISH14. SCREW, 3/8IN UNC X 6IN GRADE 5 C/NUT AND WASHER BLACK

Data quality improvement:


PACS XII Meeting

…through Standards and Encoding Rules…


PACS XII Meeting

…to this...

9. BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 56. BOLT, MACHINE; 3/4” UNC X 6” GDE 51. BOLT, MACHINE; 3/4” UNC X 6” GDE 5 W/NUT AND WASHER2. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD4. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 510. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER12. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER13. BOLT, MACHINE; 3/8” UNC X 6” GDE 5 W/NUT AND WASHER BLACK14. BOLT, MACHINE; 3/8” UNC X 6” GDE 5 W/NUT AND WASHER BLACK7. BOLT, MACHINE; 3/8” UNF X 6” GDE 5 W/NUT AND WASHER BLACK8. BOLT, MACHINE; 3/8” UNF X 6” GDE 5 W/NUT AND WASHER BLACK11. SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 53. SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD ZINC PLATED5. SCREW, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 ZINC PLATED


PACS XII Meeting

... and then this…

9. BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5 W/NUT AND WASHER12. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER14. BOLT, MACHINE; 3/8” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK8. BOLT, MACHINE; 3/8” UNF X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK11. SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 55. 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.


... and eventually to this.

9. BOLT, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 5 W/NUT AND WASHER12. BOLT, MACHINE; 3/4” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER14. BOLT, MACHINE; 3/8” UNC X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK8. BOLT, MACHINE; 3/8” UNF X 6” HEX HEAD GDE 5 W/NUT AND WASHER BLACK11. SCREW, MACHINE; 3/4” UNC X 5-1/2” HEX HEAD GDE 55. 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.


PACS XII Meeting

NSW HEALTH

A daunting task.


PACS XII Meeting

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

During the late 90s NSW Health Commissioned an extensive review of their supply chain management...


PACS XII Meeting

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.

NSW Health heads down e-procurement pathArticle: itnews - Dec 15, 2008 2:39 PM


PACS XII Meeting


PACS XII Meeting

QUESTIONS?

Thank you.

www.oniqua.com data quality and standardization initiatives within government rob dixon senior...

Documents

hex head unc grade

hex grade

long unc grade

hex head unc bolt

hex head bolt unc

hex head grade

hex bolt

long bolt grade