What kinds of searches might users want to do against dm+d?

[inglesp]

In order to build a really useful dm+d search feature (which could then be used to drive the analyse page) it would good to gather information about the kinds of searches users might want to do.

@richiecroker, @brianmackenna, and others: can you add below any specific queries or classes of query that you think users would be interested in?

Additionally, are there any measures whose numerator or denominator would be better expressed as the BNF codes of drugs matching a dm+d query?

[richiecroker]

Not strictly a search, but one comment I had from a member of the team yesterday was the wish to show prices in a column of current prices when showing a list of AMPPs/VMPPs. Whether that's just a separate price list checker I don't know (based at only one level), but that was feedback I had.

[inglesp]

@brianmackenna and @richiecroker, I'm returning to this. So far I have from the measures:

• Find all presentations with at least one AMP which can only be prescribed in hospitals
• Find all presentations with at least one VMP with a form route of "paste.dental" / "pressurizedinhalation.inhalation" / etc

These are both of the class:

• Find all presentations with at least one dm+d object that has a certain property.

Can you think of any other examples of queries you might want to do?

[brianmackenna]

• Using more that one dm+d object. For example I want to find all the inhalers manufactured by Chiesi.
• Finding things that have changed. For example I wan to find all the presentations that have changed price by x% in the last year

Is that helpful/kind of thing you want? Might be easier to chat through.

[inglesp]

Exactly the kind of thing I want, yes. Are you around to chat at 9:30?

[brianmackenna]

I know the name of one AMP but I want to see if there are other AMPs of that product. For example I know Ralvo but I want to see what else is available.

This logic would generally apply to stock shortages. I've ran out of x can i just prescribe or procure identical stock from another manufacturer.

[brianmackenna]

2008

[sebbacon]

• I want to know all VMPs for which there is exactly one AMP, so I can identify single-supplier generics (e.g. per https://github.com/ebmdatalab/price-per-dose/issues/23)
• https://github.com/ebmdatalab/openprescribing/issues/1726 has a few unusual use-cases:
  • Try filtering out AMPPs without GTINs
  • Try filtering out AMPPs without prices or with prices a long time in the past
• Our GBG view needs to know all VMPs with only one PPU

[brianmackenna]

2384 example of a route query

In the US-UK paper comparison we also want to identify all "branded medicines" with no generic competition. In order to do this we could construct a list of using all VMPs where there is only a single AMP. This should work but in this case the logic falls down as the originator licenses their brand name to be manufactured by another supplier. Thinking about it perhaps we could use some logic involving the name of the AMPs as well..........

[sebbacon]

1726 referenced above also addresses the manufacturer question

[inglesp]

Relatedly, we'd like to be able to do something like this in notebooks:

measure = Measure(
  title="Intravenous Antibiotics",
  numerator_type="items",
  numerator_drugs= {
    "bnf_code": "starts_with 05",
    "form_route": "intraveneous"
  },
  denominator_type="list_size",
)
measure.top_n_percentiles(5, 'practice')
# => returns DF with top 5 percentiles of practices
measure.plot_deciles('CCG')
# => plots deciles chart for CCGs
measure.plot_map('computer_system')
# => plots map breaking down by computer system

[brianmackenna]

A user has requested GTIN search function.

Potentially we could add it to dm+d advanced browser.

[brianmackenna]

Actual suggestions from a user. To return to after COVID.

• Search products by Drug Tariff category – i.e. Category A, M and C, Part IXA, IXB, IXC, reagents/ACBS etc (by VMP, VMPP, AMP and AMPP) • This may prove difficult due to third party agreements, but it would be fantastic if OpenPrescribe could find a way to try and link product PIP codes to the dm+d products and also allow searching of drug by PIP code • Search for drugs with multiple pack sizes i.e. set a rule to allow identification of all products available in packs for 28 and 30, or 56 and 60 etc • Search function to allow identification of list of all new products added to dm+d by date (for e.g. list of new products added weekly and monthly) • Search function to allow identification of recently discontinued products (weekly or monthly list of recently discontinued products). To add rules/group under advanced search parameters for AMPs, VMPPs and AMPPs to include products which meet: o Broken bulk criteria o Discount not deducted eligibility o Special container status (including subpacks) • To add rules/group to identify products (AMPs, VMPPs and AMPPs) which have had recent price changes (particularly for non-Tariff lines) i.e. search by date of price validity • Include eMC or MHRA link in AMP where available to be able to view relevant SPC and/or PIL • Display product SNOMED code when searching product by drug name • Link latest prescribing and dispensing information of products (based on PCA and/or ePACT) within search results to view latest prescribing trends of products • Allow search of all products which attract multiple patient charges and dispensing fee • Due to large range of products available, simplify ways of searching for certain appliances such as elastic hosiery, lymphoedema garments, catheters for e.g. by enabling options to exclude or include items from the results as part of initial search query. User can then expand or narrow down the search criteria to one that fits the description best – Class 2 or below knee etc.

[brianmackenna]

Just been a discussion amongst practice pharmacists that it can be hard to know which medicines they can and can't claim "personally administered" fees for. This is when a patient comes to the practice and a medicine is administered in the practice e.g. injections. Typically a practice will buy the medicine in themselves and they can claim an additional fee from BSA>

Also see this consultancy thing on practices missing out on income. There is a field at AMPP level that it would be good to search by in the advanced search function.