| Electronic
Prescribing and Financial Information for Practices (ePFIP)
Identifying High Cost Drugs.
Within ePFIP there is the facility to export data to Excel to enable you to
identify the prescribing of High Cost drugs, and also the prescribing of
proprietary items when generic versions are available.
After you log into ePFIP select PDPI under ‘Documents You Can View’.
This will then bring up the screen ‘PDPI Data Selector’. The fields and options within the Data Selector should be set as:-
Select Period: Select the relevant month you wish to identify.
Select Prescriber: This should be left at Practice level.
Select Chapter: This should be left as All Chapters
Select Level: Click on the arrow at the right hand side , scroll down and select Presentation.
Prescribing Type: Select Total
Prescribing or Dispensing: Select Catalogue of Prescribing
Type of Catalogue: Select Full Detailed
Order by: Select Prescriber
Then click on ‘Submit’
After the report has run select Search from the pale blue toolbar at the top of the screen.
This will open the search panel on the left of the screen.
Click on each data item in the report that you want to be exported to Excel. For example, Drug, Items
and NIC. As each field is clicked it will appear in the search panel on the left of the screen.
Click the ‘Search Now’ button and, when the search is complete, the search panel will show a list
of all the selected data items – in this case, every row in the report.
NOTE: The proprietary items with generic equivalents are identified by (GFA) after each item.
If you want to limit the search to return just those items, enter *GFA* in the Drug search field before
clicking the ‘Search Now’ button. The list returned in the search panel will now just include drugs
with the characters GFA in the name.
From the list box entitled ‘Download search results as’ at the bottom of the search panel, select
‘MS Excel file’ and click the ‘Go’ button.
If asked whether you want to open or save the file, select ‘Open’ and Excel will be launched with
the data successfully exported from PDPI with the correct column headings.
You can now manipulate the data in Excel to identify the highest costing items
NOTE
For further information on exporting PDPI data to Excel, click on the
‘Export PDPI Data to Excel’ link within the Helpful Hints section of the Application Help.
|