# DM+D AMP/VMP filtering when prescribing **URL:** \ **Category:** Electronic Prescription Service (EPS)\ **Created:** [23 August 2024 09:12 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826 "2024-08-23T09:12:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![mustafa.nawaz](https://avatars.discourse-cdn.com/v4/letter/m/c2a13f/32.png) [@mustafa.nawaz](https://developer.community.nhs.uk/u/mustafa.nawaz)\ **Post date:** [23 August 2024 09:12 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/1 "2024-08-23T09:12:22Z")
Question on the _f\_lookup\_VirProdPresStatInfoType_ table from the DM+D which provides the following categories for a VMP item: - 0001|Valid as a prescribable product - 0002|Invalid to prescribe in NHS primary care - 0003|Not prescribable as a VMP but AMP prescribable - 0004|Never Valid To Prescribe As A VMP - 0005|Not Recommended To Prescribe As A VMP - 0009|Caution - AMP level prescribing advised We’re recommended to filter out all items except those that fall into 0001 and 0009 by the DM+D guide. Should this also be inferred for AMP items by joining the VMP table on VPID? Or can VMP items such as dermol wash be prescribed at an AMP level where the VMP is classed as 0004? ![image](https://europe1.discourse-cdn.com/nhsdigitaldeveloper/original/1X/aa7a9f85c2c0b454712af68d0552f996faa55335.png) ---
**Author:** ![jen.redman](https://avatars.discourse-cdn.com/v4/letter/j/e495f1/32.png) [@jen.redman](https://developer.community.nhs.uk/u/jen.redman)\ **Post date:** [23 August 2024 12:07 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/2 "2024-08-23T12:07:39Z")
Thank you for your query. I will check this with our DM&D colleagues at NHS England and get back to you shortly. ---
**Author:** ![jen.redman](https://avatars.discourse-cdn.com/v4/letter/j/e495f1/32.png) [@jen.redman](https://developer.community.nhs.uk/u/jen.redman)\ **Post date:** [2 September 2024 09:13 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/3 "2024-09-02T09:13:20Z")
Hello - just an update to say apologies for the delay we’ve had quite a few people off on leave due to the bank holiday weekend last week and it’s peak school holiday period. We’ll get back to you with a response soon. ---
**Author:** ![bill.lush](https://dub1.discourse-cdn.com/nhsdigitaldeveloper/user_avatar/developer.community.nhs.uk/bill.lush/32/409_2.png) [@bill.lush](https://developer.community.nhs.uk/u/bill.lush)\ **Post date:** [3 September 2024 16:09 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/4 "2024-09-03T16:09:30Z")
I am assuming you are referring to the [dm+d Implementation Guide (Primary Care)](https://nhsengland.kahootz.com/gf2.ti/f/762498/205305413.1/PDF/-/dm_d%20Implementation%20Guide%20_Primary%20Care_%20v6.0%20_002_.pdf). The guide indeed advises that a prescribing status (PRES\_STATCD) should be either 1 or 9, but this is from an intermediate table that is called “dmd\_product”. “dmd\_product” is an amalgamation of VMP and AMP data, see section “6.0 Generating a Primary Care Products Entity (dmd\_product)”, of the above document (page 44), on how to create the intermediate table “dmd\_product”. A quick summary: the first pseudo code section is a union statement of which the first section is returning the AMPs this code forces the PRES\_STATCD to be 1, even though the VMP has a different code, therefore if you implement this section your AMPs of “Dermol …” will be returned in the picking list as they will have a prescribing status (PRES\_STATCD) of 1. If you are having any further issues, please message back. ---
**Author:** ![mustafa.nawaz](https://avatars.discourse-cdn.com/v4/letter/m/c2a13f/32.png) [@mustafa.nawaz](https://developer.community.nhs.uk/u/mustafa.nawaz)\ **Post date:** [4 September 2024 08:51 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/5 "2024-09-04T08:51:09Z")
That clarifies a lot. Thank you. ---
**Author:** ![bill.lush](https://dub1.discourse-cdn.com/nhsdigitaldeveloper/user_avatar/developer.community.nhs.uk/bill.lush/32/409_2.png) [@bill.lush](https://developer.community.nhs.uk/u/bill.lush)\ **Post date:** [4 September 2024 10:00 UTC](https://developer.community.nhs.uk/t/dm-d-amp-vmp-filtering-when-prescribing/1826/6 "2024-09-04T10:00:18Z")
Glad to hear that helped 🙂 . An alternative method of getting support on the implementation of terminologies is to contact [information.standards@nhs.net](mailto:information.standards@nhs.net).