TMITS

TailorMade Info Technology Solutions Ltd

Tel/Fax: +44 (0)1359 242146 ~ Email: Solutions@tailormadeit.co.uk


Vision 3 Searches - Screen Shots

Lited below are popular screen shots of popular searches

Immunisations

Examination Findings

Cytology Searches

Contraception

Medication Searches

Registration Searches

Consultation Searches

General Searches

Immunisations

No MMR vaccine for patient aged between 5y and 18y

No MMR

No MMR Booster

No MMR Booster

Patients 28 weeks pregnant (Whooping Cough vaccine)

Pregnant with No DTPAPIPV

DTAPIPV with No Claim Code

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

Examination Findings

Last recorded alcohol entry was drinker in last 15 months

Last recorded alcohol entry was drinker in last 15 months

Last BMI equal to and greater than 30

Last BMI equal to and greater than 30

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

NO BMI after April
Weight Exclude

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

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

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

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

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

Cytology Searches

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

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 

Contraception

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

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

Medication Searches

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

Patients on or taking anticoagulant medication

On Repeat Medication

On Anti Coag Repeat

Taken medication in last year

Taken anti coag in last year

Taken specific medication in last year

Specific anti coag

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, as 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.

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

Outstanding Medication Reviews with No Repeat Medication

Med Reviews

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 

Registration Searches

Medical records not received by TP

MR not received by TP

Medical records not sent to TP after 2 weeks

Medical Records 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.

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

Active patients with NO NHS Number

Active patients with NO NHS number

Consultation Searches

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!

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

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

Add patient address details to a report

Click to view a video tutorial on how to export and merge patient address details in Microsoft Excel

Patient Address Details

Back to Top