udi & enterprise data systems: how to begin the approach · slide 1 udi & enterprise data...

www.UDIconference.com

UDI & Enterprise Data Systems:

How to Begin the Approach

December 2, 2010

Corwin Hee, Covidien

Barbara Zenner, Baxter

Michael Sarachman, Johnson & Johnson Health Care Systems Inc.


UDI example

Mfg Reorder Code UOM QOM GTIN

9255 EA 1 10884521021914

9255 CT 25 20884521021911

9255 CA 100 30884521021918


Tracking product

from warehouse to patient


Distributor

Manufacturer Hospital

Case

Case BX

BX

Case Case


External

trade

Internal

use


Nested Relationships

Product reorder code

ERP

Financial Logistics Manufacturing

Regulatory Packaging Marketing

CRM Other

initiatives



ERP



CRM Other

initiatives

Product reorder

code

MMIS

Financial Logistics

Regulatory Patient

Systems

EHR Other

initiatives

Product reorder

code

ERP

Financial Logistics


CRM Other

initiatives

Distributor


6715 CA

OXIMAX CA

ABSTACK10 BX

3583006715 RL MKGOM21900 BX 1497882166 BX

K57128 EA

N495878 EA

U68103 EA


Internal Divisional Issues

Manufacturer

Division “A” Division “B” Division “C”


ERP



CRM Other

initiatives


ERP



CRM Other

initiatives


ERP



CRM Other

initiatives


EXAMPLE

Barbara Zenner


Requirements to consider

Each level of packaging requires a unique 14 digit GTIN

0 0085412 00000 8

2 0085412 00000 4

5 0085412 00000 6

1 Each

Pack of 1 Each

Case of 10 Each

6 0085412 00000 9

Case of 10 Packs of 1 Each


Unique Item Level

Unique Item Level Unique Item Level

Complexity in your DataWarehouses

The Item is often stored at a case level not an actual item level which forces duplication of GTIN at the each.

0 0085412 00000 8

2 0085412 00000 4

5 0085412 00000 6

1 Each

Pack of 1 Each

Case of 10 Each

6 0085412 00000 9



Example The Exact same Each is sold in two slightly different case configurations.

Description Lactated Ringer

Pack Factor 1 Bag

GTIN 0 030338630702 3

Unit of Sale NO


Item #: 6E2322

Pack Factor 20 Each

GTIN 5 030338630702 8

Inserts 1/Case

Unit of Sale YES


Item #: 6E2322B

Pack Factor 40 Each

GTIN 6 030338630702 5

Inserts 40/Case

Unit of Sale YES


Importance of identifying internal work tables

(ex:UCC 128 table work)

Unique Item Level

6 0085412 00000 9


Unique Item Level

2 0085412 00000 4

Pack of 1 Each

0 0085412 00000 8

1 Each


Michael Sarachman

JOHNSON & JOHNSON

HEALTH CARE SYSTEMS INC.


Identification Approach

• Utilize GS1 GTIN Allocation Rules for Healthcare as initial guideline

• Develop exception rules based on key criteria

– Identification • Form, fit and function

– Consistent Units of Measure

– Product traceability


Product Configuration

Description Vicryl Suture Vicryl Suture

Dispenser Box

Vicryl Suture

Dispenser Box

Vicryl Suture

Dispenser Box

E-Pack

Procedure Kit

Sales Code J765 J765D J765Z J765D 8689E

Package Envelope Box of 12

Sutures

Box of 36

Sutures

Box w/ Multi-

Lingual Label

Procedure Kit

UOM EA BX BX BX KT

GTIN 1 0705031 04283 4 3 0705031 04283 8 3 0705031 04284 5 3 0705031 01937 3 1 0705031 01905 8

Unit of Sale NO YES YES YES YES

• Product EACH is sold in multiple package configurations and languages

• Product may also be sold as a kit component


Finished Product Sold As a

Component • Finished products sold to different customers

– Provider for clinical use

– 3rd party to be included as part of a kit

511HR

Single Sterile

1 0705036 00059 4

511HR

Box of 6 STERILE

2 0705036 00059 1

511HR

Bulk-Packaged

NON-STERILE

1 0705036 00140 9

http://www.google.com/imgres?imgurl=http://www.medgadget.com/archives/img/345312hyh.jpg&imgrefurl=http://medgadget.com/archives/2010/03/endopath_xcel_trocar_with_optiview_keeps_the_lens_clean_for_superior_visualization.html&usg=__7Lvww8MmZoMsbmKTOBRzjnMG5wY=&h=436&w=133&sz=17&hl=en&start=8&zoom=1&tbnid=Wnh8vofq5rVGmM:&tbnh=126&tbnw=38&prev=/images?q=ethicon+endo-surgery+trocar&um=1&hl=en&sa=N&tbs=isch:1&um=1&itbs=1


CLOSING THOUGHTS


What can we learn from retail?

UPC Internal numbers


North Star Approach

UDI

Universal External Identifier for all products


Lawson Item Number Example

Lawson Item: 10024

UOM: EA

UOM: SP

UOM: CS

Distributor Item: 12345

UOM: SP

Manufacturer Item: 345678

Manufacturer Item: 345678

UOM: CS

Medical device, generic product

GTIN: 71234567890071 GTIN: 12345678901070 GTIN: 52345678901075


Translate internal to external



ERP



CRM Other

initiatives

Product reorder

code

MMIS

Financial Logistics

Regulatory Patient

Systems

EHR Other

initiatives

Product reorder

code

ERP

Financial Logistics


CRM Other

initiatives

Distributor


6715 CA

OXIMAX CA

ABSTACK10 BX

3583006715 RL MKGOM21900 BX 1497882166 BX

K57128 EA

N495878 EA

U68103 EA UDI


Key Recommendations

1. Prepare for a multi-lingual world

2. Anticipate downstream impacts

3. Remember “internal” vs. “external”

4. Focus on translation o Shortest route to success

o Minimal internal disruption

5. Is evolution right for you?


спасибо спасибо

спасибо

udi & enterprise data systems: how to begin the approach · slide 1 udi & enterprise data...

Documents