TailorMade IT Solutons Ltd

 
 

Vision 3 Searches Support

Listed below are some examples of how to build a Search within Vision

Quick jump Index

How do I...

GP2GP repeat medication that needs inactivating

These exposes the active repeat medication sent via GP2GP, which are hidden behind the repeat inactive filter and are shown as bowties. If you do not inactivate these repeats QOF will see them as active and require a medication review and that you should link them to a problem.

GP2GP RX

Medical records not received by TP

MR not received by TP

Medical records not sent to TP after 2 weeks

MR Not Sent to TP

Patients on the FP69 List

These patients will be removed within 6 months unless you select status: "Patient should remain on list" from the registration record.

FP69s

If you export the search as a tab separated file, then open the patient.txt file in this FP69 Excel spreadsheet - This will display the list of FP69 patients in date order after pressing Ctrl+Shift+F.

Patients whole repeat list that can be inactivated

Improve you QOF figures with this search, which will find all those patients whereby none of their repeat medication has been issued in the last 15 months.

Which means that you won’t have to do any medication reviews for any of these patients and it will immediately increase your QOF indicator percentage figure and leave you with an accurate list of patients who do need a medication review.

It will require two searches to be built:

  1. Exclude patients who have had an repeat issued in the last 15 months
  2. Only show active repeats , authorised over 6 months ago.

Note: you cannot not use active repeats and exclude in the same search and the authorised element doesn’t include patients’ that have just been put on a repeat in the last 6 months and are just awaiting their 1st issue.

1st Search

Repeat not issued in last 15 months 

2nd Search

Active repeats not issued in last 15 months 

Click this link to download a complete set of instructions on how to build the search and carry out the task.

Active Patients that have a Transferred out date

This search is quite important as if you have any of these patients they may not be picked up by the QOF audits.

If you do have any patients list from this search, please contact the helpline and ask them to remove the transferred out date.

Active patients that have a transferred out date

Find if the wrong Consultation Type has been recorded against Medication Reviews

Find if the wrong Consultation Type has been recorded against Medication Reviews

Last BMI equal to and greater than 30

Last BMI equal to and greater than 30

back to top

Last recorded alcohol entry was drinker in last 15 months

Last recorded alcohol entry was drinker in last 15 months

back to top

In last 18 months find any BP >= 150/90 (show only up to 3 that match) and those patients not on the hypertensive register.

In last 18 months find any BP >= 150/90 (show only up to 3 that match) and those patients not on the hypertensive register.

Do not exclude those without a BP register 

back to top

Performed cytology results in last 9 months, not yet back from the lab

Performed cytology results in last 9 months, not yet back from the lab

back to top

No consultation recorded in last 3 years

Patients must be 18 years old or over, not registered within the last 3 years and currently permanent.
Exclude patients seen in last 3 years recorded under any other consultation type except Administration.

No consultation recorded in last 3 years
Do not exclude patient with no consultations recorded

Face to Face consultations in last year

Consultations in last year

This search is exported as a tab separated search, which is then opened in Microsoft Excel so that you can count them all up in a Pivot Table.

Click here to view a video on how this is done!

Last BP >150/90 and Cholesterol >5 and NOT on Statin medication

Note: Report details are set to "Latest 1 before match" for BP and Cholesterol
This means that only the last recorded entries must match the search criteria

Not on Statin Medication with BP >150/90 and Chol >5
Do NOT exclude patients not on any repeat medication

 

In Last 3 recorded BPs there were one or more >150/90

BP >150/90

back to top

Females >16y with IUD fitted or checked in last Quarter

Females >16y with IUD fitted or checked in last Quarter

back to top

Female patients aged between 20 and 64 years with no smear EVER recorded

Female patients aged between 20 and 64 years with no smear EVER recorded 

back to top

Children aged between 4m and 12 months given DTaP/IPV/Hib stage 2 with no stage 3

Children aged between 4m and 12 months given DTaP/IPV/Hib stage 2 with no stage 3 
Exclude those who haven't had any imm recorded

back to top

Patient on Methotrexate repeat medication and no FBC done in last 6 months

Patient on Methotrexate repeat medication and no FBC done in last 6 months 
Do not exclude those who have not had any FBC recorded

back to top

Total number of contraceptives issued in last year

Please note that the Report Output is set to COUNT; which will show the total amount of issues

Total number of contraceptives issued in last year 

Patients older than 16y with No BMI recorded after April 20??

NO BMI after April
Weight Exclude

Active patients with NO NHS Number

Active patients with NO NHS number

Patients aged 35y to 74y with NO BP recorded ever

Patients aged 35y to 74y with NO BP recorded ever
BP Exclude

Patients aged 35y to 74y with NO BP recorded in last 5 years

Patients aged 35y to 74y with NO BP recorded in last 5 years
BP Exclude

back to top


     

Site search only Google Search