english-prescribing-data-epd

Assignee

This comment has been assigned to an administrator for review and, where required, response.

Inhaler quantity units #12

Open ra.croker opened this discussion · 6 comments
ra.croker commented 1 year ago

Hi

Are you able to describe how to identify where inhaler quantities are shown as doses, rather than packs please?

e.g. WockAIR 160micrograms/dose / 4.5micrograms/dose dry powder inhaler (0302000K0BJAAAM) shows up as dose quantities, i.e. multiples of 60, whereas WockAIR 320micrograms/dose / 9micrograms/dose dry powder inhaler (0302000K0BJABAU) appears as quantities of packs, i.e. multiples of 60. They both appear to only have one pack size.

You can see the differences in the table:

BNF_CODE PRACTICE_CODE PCO_NAME BNF_DESCRIPTION QUANTITY ACTUAL_COST 0302000K0BJAAAM H82065 NHS SUSSEX ICB - 70F WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJABAU H82042 NHS SUSSEX ICB - 70F WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 2 36.11369 0302000K0BJAAAM C83031 NHS LINCOLNSHIRE ICB - 71E WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJABAU N81010 NHS CHESHIRE AND MERSEYSIDE ICB - 27D WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 1 18.06305 0302000K0BJABAU Y07386 NHS DEVON ICB - 15N WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 1 18.06305 0302000K0BJAAAM B85037 NHS WEST YORKSHIRE ICB - X2C4Y WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJAAAM C81056 NHS DERBY AND DERBYSHIRE ICB - 15M WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 90.31523 0302000K0BJAAAM N81040 NHS CHESHIRE AND MERSEYSIDE ICB - 27D WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 54.18914 0302000K0BJAAAM P92605 NHS GREATER MANCHESTER ICB - 02H WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 240 36.11369 0302000K0BJABAU M83650 NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 1 18.06305 0302000K0BJAAAM E82074 NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0 WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJABAU D83012 NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0 WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 2 72.22738 0302000K0BJAAAM N81008 NHS CHESHIRE AND MERSEYSIDE ICB - 27D WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 240 216.6821 0302000K0BJAAAM L85061 NHS SOMERSET ICB - 11X WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 71.07924 0302000K0BJABAU D82073 NHS NORFOLK AND WAVENEY ICB - 26A WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 2 72.22738 0302000K0BJAAAM K83020 NHS NORTHAMPTONSHIRE ICB - 78H WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJAAAM G81040 NHS SUSSEX ICB - 97R WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJABAU J81033 NHS DORSET ICB - 11J WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 4 72.21498 0302000K0BJABAU B87015 NHS WEST YORKSHIRE ICB - 03R WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 1 18.06305 0302000K0BJAAAM D82008 NHS NORFOLK AND WAVENEY ICB - 26A WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 54.18914 0302000K0BJAAAM N81068 NHS CHESHIRE AND MERSEYSIDE ICB - 27D WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 198.6935 0302000K0BJABAU C83014 NHS LINCOLNSHIRE ICB - 71E WockAIR 320micrograms/dose / 9micrograms/dose dry pdr inh 2 36.11369 0302000K0BJAAAM L85035 NHS SOMERSET ICB - 11X WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 240 36.11369 0302000K0BJAAAM C81006 NHS DERBY AND DERBYSHIRE ICB - 15M WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 60 9.13772 0302000K0BJAAAM D82051 NHS NORFOLK AND WAVENEY ICB - 26A WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJAAAM P87020 NHS GREATER MANCHESTER ICB - 01G WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305 0302000K0BJAAAM C81662 NHS DERBY AND DERBYSHIRE ICB - 15M WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 54.18914 0302000K0BJAAAM B81039 NHS HUMBER AND NORTH YORKSHIRE ICB - 03H WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 36.12609 0302000K0BJAAAM C87013 NHS SOUTH YORKSHIRE ICB - 03L WockAIR 160micrograms/dose / 4.5micrograms/dose dry pdr inh 120 18.06305

Most inhalers show as packs, but a few (like this and Breezhalers) show as "puffs". It makes quantity calculations really challenging, and it would be good to understand the reasoning why.

Thanks!

Gravatar
Owner
dataservicessupport commented 6 months ago

@ra.croker Thank you for your comment and please accept my sincere apologies for the delay in a response.

Your comment, unfortunately, may have been made during a period wherein we were struggling with our dataset activity notifications - an issue we believe is now long resolved by our suppliers.

If your query is still requiring a response, please do let me know and I will ensure that a prompt response is provided as a matter of urgency.

Again, please accept my apologies.

Kindest regards, Kate Data and Insight Analyst

Gravatar
ra.croker commented 6 months ago

Yes please, there appears to still be the same issue.

I note I made an error in the original message, which should say:

WockAIR 160micrograms/dose / 4.5micrograms/dose dry powder inhaler (0302000K0BJAAAM) shows up as dose quantities, i.e. multiples of 60, whereas WockAIR 320micrograms/dose / 9micrograms/dose dry powder inhaler (0302000K0BJABAU) appears as quantities of packs, i.e. multiples of 1. They both appear to only have one pack size.

Gravatar
ra.croker commented 6 months ago

Yes please, there appears to still be the same issue.

I note I made an error in the original message, which should say:

WockAIR 160micrograms/dose / 4.5micrograms/dose dry powder inhaler (0302000K0BJAAAM) shows up as dose quantities, i.e. multiples of 60, whereas WockAIR 320micrograms/dose / 9micrograms/dose dry powder inhaler (0302000K0BJABAU) appears as quantities of packs, i.e. multiples of 1. They both appear to only have one pack size.

Gravatar
ra.croker commented 6 months ago

Yes please, there appears to still be the same issue.

I note I made an error in the original message, which should say:

WockAIR 160micrograms/dose / 4.5micrograms/dose dry powder inhaler (0302000K0BJAAAM) shows up as dose quantities, i.e. multiples of 60, whereas WockAIR 320micrograms/dose / 9micrograms/dose dry powder inhaler (0302000K0BJABAU) appears as quantities of packs, i.e. multiples of 1. They both appear to only have one pack size.

Gravatar
jokir commented 6 months ago

This is due to how the pack sizes are held within our drug database (either a special container or non-special container) and how the EPD shows the quantities prescribed.

For inhalers that are special containers such as WockAIR 320micrograms/dose / 9micrograms/dose dry powder inhaler even though the pack size is 60 dose the EPD will show this as the number of inhalers. So 60 dose becomes a quantity of 1, 120 dose becomes a quantity of 2 etc.

For WockAIR 160micrograms/dose / 4.5micrograms/dose dry powder inhaler the pack size is 120 dose (non special container) made up of 2 x 60 special container sub-packs. In this scenario the EPD will show the number of doses and not the number of inhalers as the pack size itself is not a special container. So 1 inhaler is shown as a quantity of 120 dose.

This will still be the case if an inhaler strength has two packs that follow the scenario above - so a special container pack and a non special container pack made up of special containers will follow the logic above.

Gravatar
Owner
dataservicessupport commented 6 months ago

@ra.croker Please see the above response from a fellow Data and Insight Analyst here at Data Services within the NHSBSA.

I'm hoping that this answers your query but please do let me know if you require any further assistance.

Again, I do apologise for the delay with all of this.

Best wishes, Kate Data and Insight Analyst