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 7 months 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 2 weeks 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 days 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 days 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 days 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 5 days 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 5 days 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