Ardens has created searches to support practices in identifying a percentage of patients living in deprived areas. This may be of use to priortise patient care, during COVID19.
To locate the searches, navigate to the Population Reporting module > Ardens Searches > 1.12 LTC Reviews - Risk Strat > Deprivation searches - Townsend score folder.
The searches and reports in this folder are based on the Townsend score.
Step 1 - Identifying the Percentage of Deprived Patients
Select the 'Townsend score report (shows Townsend score for all patients)' and click on the Run option on the EMIS ribbon (alternatively, right click on the search and click on Run). This will return all patients recorded with a Townsend score.
The next step is to further identify the specific patients (depending on percentage) and we will do this by exporting the results to a CSV file. Once the report called 'Townsend score report (shows Townsend score for all patients)' has been run, ensure it is highlighted and then click on the View Results option on the EMIS ribbon.
The results will display in EMIS. Select the Export button on the EMIS ribbon, followed by the CSV option and choose to 'Exclude report header'.
Choose a suitable location to Save the report on your computer.
Once exported, open the saved file using Microsoft Excel or other suitable spreadsheet application.
Decide on the percentage of patients you require; in this example we will use 20% of the population (e.g. population of 15,000 patients, roughly 3000 patients).
Once you are aware of the number of patients, scroll down the spreadsheet until you reach this point.
Please note the above screenshot contains test data only
Make note of the Townsend Score, in this case it is -3.84.
Step 2 - Editing the Search to Include Specific Townsend Score Patients
Access EMIS and return to the Deprivation searches folder. This time select the 'Townsend score below (number to be completed)' search. Once selected, click on the Edit option on the EMIS ribbon (alternatively, right click on the search and click on Edit). The search editor will open.
Double click on Rule 1 to edit the rule. Once in the Feature Builder screen, double click on Townsend Score. Change this to the score have you noted in step 1.
Click OK and Save and Run to view the results.
To identify the QOF conditions which the most deprived patients have, View Results of the 'Most deprived patients with QOF conditions' report.
Export the report to a CSV file to easily view the conditions for each patient.
If you require any further assistance on the process above, please contact Ardens support on: support-emis@ardens.org.uk