data dialogue discovery - bbts · unit age at transfusion (days) pilot - aneg. pre-pilot - aneg....

31
Data ... Dialogue .... Discovery ..... Account for Blood Dr Karen Bailie SNBTS, Glasgow BBTS 2017

Upload: others

Post on 21-Mar-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Data ...Dialogue ....Discovery .....

Account for Blood

Dr Karen BailieSNBTS, Glasgow

BBTS 2017

Page 2: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

AfBSnapshot

STEDData Mart

ACaDMeData Mart

AfB Data Mart

Blood Bank Systems

Patient file Stock file

Stock PositionReports

Clinical Context Reports

Transfusion Activity Reports

Stock Management

Reports

InputProcessingOutput

AfBRoutine, up-to-date national data on the supply & use of blood components(2009 to date)

ACaDMeNHSS hospital episode data provide the clinical context in which blood components are used.

Linkage By rules for date & clinical priority; updated monthly (after ACaDMe load)

AfB Data Flows

Similar Data:Netherlands (2010)Scandinavia (2012)

Page 3: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

AfB OutputsMetrics• Patients & procedures

• Transfused patients & procedures

• Units transfused

• Units fated

Comparisons• By Consultant responsible for care

• By hospital (type) / Health Board

• Temporal

Routine reports• Stock transactions

• Surgical blood use

• Age & gender specific blood use

• Blood use by other clinical group

Ad hoc data• NHSS Clinical teams

• SNBTS management info e.g. HEV/HCV

• BBT research & audit programme

Page 4: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Using AfB data to understand patterns of blood use

Transfusion Epidemiology

Page 5: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Temporal Trends in Blood Use

05,000

10,00015,00020,00025,00030,000

Num

ber o

f uni

ts /

patie

nts

Year

Platelets

Booked in

Units transfused

Patientstraansfused

05,000

10,00015,00020,00025,00030,000

Num

ber o

f uni

ts /

patie

nts

Year

FFP

Booked in

Units transfused

Patientstraansfused

0500

1,0001,5002,0002,5003,0003,5004,000

Num

ber o

f uni

ts /

patie

nts

Year

Cryoprecipitate

Booked in

Units transfused

Patients traansfused

0

50,000

100,000

150,000

200,000

250,000

Num

ber o

f uni

ts /

patie

nts

Year

Red cells

Booked in

Units transfused

Patientstransfused

Page 6: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Transfusion Rates by Age & Gender(2016 data)

0

20

40

60

80

100

120

140

160

180

200

0 - 45 - 9 10 -14

15 -19

20 -24

25 -29

30 -34

35 -39

40 -44

45 -49

50 -54

55 -59

60 -64

65 -69

70 -74

75 -79

80 -84

85 -89

90+

Uni

ts tr

ansf

used

per

100

0 po

pula

tion

Age band (years)

RBCs

MaleFemale

0

2

4

6

8

10

12

14

16

0 - 45 - 9 10 -14

15 -19

20 -24

25 -29

30 -34

35 -39

40 -44

45 -49

50 -54

55 -59

60 -64

65 -69

70 -74

75 -79

80 -84

85 -89

90+

Uni

ts tr

ansf

used

per

100

0 po

pula

tion

Age band (years)

Platelets

MaleFemale

0

2

4

6

8

10

12

0 - 45 - 9 10 -14

15 -19

20 -24

25 -29

30 -34

35 -39

40 -44

45 -49

50 -54

55 -59

60 -64

65 -69

70 -74

75 -79

80 -84

85 -89

90+

Uni

ts tr

ansf

used

per

100

0 po

pula

tion

Age band (years)

FFPMale

Female

Component All UnitsTransfused

Units transfused with missing data

% units with missing data

RBCs 136131 2459 1.8%

Platelets 21034 707 3.3%

FFP 14460 643 4.3%

Cryo 2197 258 10.5%

Page 7: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Transfusion Rates by Age & Gender

Red Cell Transfusion Rates▼over time greater in older

age groups

Red Cell Transfusion RatesMales > Females

Page 8: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Red Cell Use by Clinical Setting

‘Other’ includes:•Radiology•Psychiatry•Dental•GP

Page 9: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Red Cell Use by Primary Diagnosis(ICD10 Chapter)

CancerHaematology

GastrointestinalInjuries

Circulatory

Page 10: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Red Cell Use by Primary Diagnosis(ICD10 Chapter)

Respiratory“Other”

GenitourinaryMusculoskeletal

Obstetrics

Page 11: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Red Cell Use: The future?

0

20000

40000

60000

80000

100000

120000

140000

160000

180000

200000

2009 2010 2011 2012 2013 2014 2015 2016 2024 2029 2034 2039

Unitsper Annum

Year

Red Cell Units Transfused: Actual (2009-16) & Predicted based on demographic change

Assumes no change to current drivers of clinical use (rates):•Disease incidence & prevalence•Transfusion triggers•Blood conservation•Anaemia management •New treatments•New surgical techniques•Eligible patients

Actual RBC use

Predicted RBC use

?

Page 12: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Using AfB data to inform clinical transfusion practice

Hospital Transfusion Committees

Page 13: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Adult Group O D neg RBC

2009 2010 2011 2012 2013 2014 2015 2016Units booked in (all groups) 182900 191011 179704 176967 171183 161379 154615 145029O Neg Units Booked in 22129 23706 22658 22615 23294 21410 20353 19737O Neg Units Transfused 19918 21871 21455 21664 21408 19050 18287 17762

0

50000

100000

150000

200000

250000

Number of Units

Red Cell Demand from Hospital Blood Banks

All groups: ▼20.5%O Neg: ▼10.8%O Neg Tx: ▼10.8%

Page 14: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Group O Rh(D) Red Cell Use

Page 15: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Group O Rh(D) Red Cell Use

Correlation coefficient R2

% O neg units outdated 0.498 0.247% O neg units not transfused 0.599 0.358% O neg units cross-grouped 0.838 0.696

Each point represents the data for an individual blood bank over a quarter year

Page 16: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Group O Rh(D) ‘Cross grouping’

Reason for Cross Group Number of units

Proportion of units

Proportion with O Rh(D) positive recipient

Emergency transfusion 181 21% 50%

Serological 129 15% 44%

ABO Availability 48 6% 0

Short date (≤5 days to exp) 368 43% 86%

Unknown 131 15% 84%

Total 857 100% 67%

• National Scottish audit (2012) • Adult red cell units cross grouped in 2 months (October & November)• KPI for cross-grouping reduction set in 2014• Local re-audit

Page 17: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Surgical Blood Use Dashboard

Pre-filtered for Health Board

Select Hospital

Select blood component

Filter-responsive graphs

Hover-over pop-up details box

6 year trends

Top-10 display

Scroll down to view more

Select procedure

Standard STED measures

National hospital type comparisons

Latest financial year data table

Page 18: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Reviewing the MSBOS• Actual blood use per patient by surgical

procedure– % patients transfused; no. of units transfused

• Individual Hospital / Health Board data• Compare with current MSBOS • Inform & agree change – mostly reduction

– Cross match to Group & Save– Group & save to no sample

Page 19: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Using AfB data to assess demand and monitor new policy impact

Policy Impact

Page 20: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Confirmatory Group PolicyPotential impact on demand for O, D negative blood?Base data: 2015 activity; Historical data: 2009-2015

• Red cell units issued on first sample (i.e. No historical sample in dataset)– All recipient groups: 18.3%– Non-O D negative recipients: 16.6%

• Red cell units transfused on first sample:– All recipient groups: 14.5%– Non-O D negative recipients:13.1%

• ‘Urgency’ of transfusion: – Within 1 hour of sample receipt: 0.9% transfusions (all recipient groups)– Within 2 hours of sample receipt: 2.3% transfusions (all recipient groups) – Within 6 hours of issue: 18% transfusions (all recipient groups)

• In practice - none - yet!– Efficiency vs urgency influences turnaround time– Returns to stock – Use of units that would otherwise have time expired– Use of units that would otherwise have been cross-grouped

Additional 15,000 units per annum

Page 21: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Confirmatory Group Policy

2013 2014 2015 2016Implemented 12191 11354 11071 10857Not Implemented 11103 10056 9282 8880

0

2000

4000

6000

8000

10000

12000

14000

Number of O Neg units booked in

O Neg demand: 2nd sample policy vs no policy

16 Blood Banks

0 Blood Banks

2 Blood Banks

Page 22: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Using AfB data to measure and improve supply chain performance

Innovate UK Knowledge Transfer Partnership

Page 23: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

The blood supply chainTransfusion

Manufacturing

P&T

Raw Material supplierDonor

Services

DeliveryFinished goods

Units returned to blood bank

Units reserved to patient

Donor Patient

Demand

Central stock

Dispatch

Hospital stock

Order placed

Clinical order

Patient demand: Transfusion requirement

Whole blood donation

Supply

SNBTS

A good supply chain aligns all their activities to fulfil the requirements of the end customer …. Patients (& clinicians)• Over supply is wasteful• Under supply impairs quality of care with potential for

adverse patient outcomes

Collection quantity

Demand signal moves backwards with each level responding to a signal generated from the preceding downstream level

Page 24: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

We measure bullwhip using the classic amplification ratio (AR):

𝐴𝐴𝐴𝐴𝐵𝐵/𝐴𝐴 = 𝐶𝐶𝐶𝐶𝐶𝐶𝐵𝐵𝐶𝐶𝐶𝐶𝐶𝐶𝐴𝐴

CoV = Coefficient of variationA,B = supply chain echelons where A is closest to the end consumer

transfused booked In donatedAR Ratios 1.75 1.26 CoV 28.3% 49.5% 62.6%

StDev 46.8 89.4 117.9

Avg units pd 165 181 188

AR > 1 indicates presence of Bullwhip

Bullwhip in the blood supply chain The bullwhip effect occurs when the demand signals in the supply chain are amplified as they move backwards through the supply chain

• Inventory swings• Surplus expedited

deliveries• Surplus inventory

TIMEX• Older age of blood at

transfusion• Pressure on upstream

supply chain activities

Impact

Page 25: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Bullwhip in the blood supply chain

Bullwhip ratios between supply chain echelons for different RBC components

Present in all blood groups except for ABNEG

Most amplification is introduced by hospital blood banks

Ampl

ifica

tion

Dam

peni

ng

Page 26: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Causes of Bullwhip in the Blood Supply Chain

02468

101214161820

No.

of u

nits

Demand amplification ONEG RBC at Hospital A

transfusedbooked in

Causes of Bullwhip

Price fluctuations/ promotions

Order ‘Just in case’

Different experiences/ comfortable stock

level

Not sure how many units will

be returned

Over-reaction to clinical orders demand signal

Page 27: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

An Inventory Replenishment PilotAim: To determine the impact of a data driven inventory replenishment model on blood bank ordering volatility and the bullwhip effect

Case StudyBlood bank at a large acute hospitalInventory control policy: Target Stock Level/Order up to with Cycle Safety StockPolicy was tested on 5 high volume, fast moving RBC components:

ANEG RBC APOS RBC BPOS RBC

ONEG RBC OPOS RBC

Page 28: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Impact on Ordering & BullwhipPRE PILOT ANEG APOS BPOS ONEG OPOS

Average order size 1.25 6.93 1.73 2.88 9.93No. of positive order days 15 32 18 21 38

Av. interval between orders 3.7 1.8 3.1 2.7 1.5CoV order size 1.74 1.14 1.85 1.65 1.03

PILOT ANEG APOS BPOS ONEG OPOSAverage order size 1.93 5.86 1.88 2.73 8.34

No. of positive order days 18 52 22 22 52Av. interval between orders 3.1 1.1 2.5 2.5 1.1

CoV order size 2.17 1.11 1.83 1.58 0.88% Change CoV order size +25% -3% -11% -4% -14%

Less volatile ordering

Smaller, more frequent ordering

Reduction in BullwhipANEG APOS BPOS ONEG OPOS

Pre Pilot Bullwhip Ratio 1.48 1.83 1.89 1.84 1.96Pilot Bullwhip Ratio 1.64 1.70 1.51 1.20 1.59

AR Change +0.16 -0.13 -0.38 -0.64 -0.37% AR Change +10.6% -7.09% -19.8% -35.0% -19.2%

If all blood banks adopted measures to reduce order volatility, then the cumulative effect would smooth the aggregate demand signal thus reducing pressure on blood processing and collection activities, and improve the match between supply and demand.......

Page 29: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

0%

2%

4%

6%

8%

10%

12%

14%

8 9 10 11 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 35

% o

f uni

ts

Unit age at transfusion (days)

Pilot - ANEG

Pre-Pilot - ANEG

Pilot: 18.71Pre pilot: 24.08

Impact on component age at transfusion & deliveries• More regular use of scheduled deliveries, and 50% reduction in use of

costly ad hoc deliveries of RBC components• Average component age at transfusion revealed a reduction in age of

between 0.7 days (APOS) to 7.2 days (BPOS)

5.37 day reduction

Page 30: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Data, Dialogue, Discovery...

Page 31: Data Dialogue Discovery - BBTS · Unit age at transfusion (days) Pilot - ANEG. Pre-Pilot - ANEG. Pilot: 18.71. Pre pilot: 24.08. Impact on component age at transfusion & deliveries

Acknowledgements

• Dr Katherine Forrester Transfusion Researcher, SNBTS

• BBT teams throughout Scotland

• Siu Cheng & Dr Christine Rutherford KTP Project Team, Heriot Watt University

• Innovate UK (KTP 9479)