Predefined Searches

1. Select the search. A warning message displays 'Do you want to run or save XXXX from help.visionhealth.co.uk?':
   
   Note - Message may vary by browser.
2. Select Run. A pop-up message displays 'Please do not change the default location. Files extract to O:\download\vissrch. Do you wish to continue?':

   

3. Select Yes to proceed. The Winzip Self Extractor pop-up displays:

   

4. Select Unzip. On completion a message '1 file(s) unzipped successfully' displays:

   

This search finds all active patients with an active repeat master for one of the gluten free products affected by the Drug Tariff changes introduced in December 2018.

Gluten_free_nonNHS_20181203

• This search is an example of how to search on a class of drugs
• Active patients on a repeat class of drug Antidepressants in the last year
• Sorted by surname

Active Patients on an Antidepressant in the last year

Active Patients Applied and Permanent

• This search is a good example of how to find patients over a certain age
• Active patients over the age 65
• Sorted by date of birth

Active Patients over 65

• Use this search as an example for searching on birth date ranges
• Active patients aged between 50 - 74 years
• Sorted by date of birth

Active Patients between 50-74

• This search is a good example of how to find patients who are under a certain age
• Active patients under 5 years old
• Sorted by date of birth

Active Patients under 5

• Use this search as an example of how to search on consultations
• Active patients with a face to face consultation(s) in the last year
• Sorted by usual GP

Active Patients with a consultation in the last year

• This search is a good example of how to search on a code
• Active patients with a diagnosis of Parkinson's recorded ever
• Sorted by surname

Active Patients with a diagnosis of Parkinsons ever

• Active patients with no consultation recorded in the last 3 years
• Patients must be 18 years old or over, not registered within the last 3 years and currently permanent
• Excludes patients seen in last 3 years recorded under any other consultation type except Administration
• Sorted by surname

Permanent Patients over 18 and no consultation in 3 years

• Use this search as an example of how to find the latest result. It also includes how to exclude patients eg patients not on a statin
• Active patients with latest BP>=150/90 and latest Cholesterol>5 not on a statin
• Sorted by surname

Active Patients with latest BP over 150_90 Chol over 5 and not on a statin

• Active patients with latest BP >= 150/90 in the last 15 months
• Sorted by surname

Active Patients with latest BP over 150_90 in last 15 months

• Active patients with any BP >= 150/90 in the last 15 months, not on the hypertensive register
• Sorted by surname

Active Patients with any BP over 150_90 in last 15 months and not on hypertension register

• Active patients older than 16 years with no BMI recorded after April 2017
• Sorted by surname

Active Patients over 16 with no BMI since 010417

• Active patients with latest Cholesterol >7 in the last year
• Sorted by surname

Active Patients with latest Cholestrol over 7 in the last year

• Active patients with latest BMI >30 in the last 15 months
• Sorted by surname

Active Patients with latest BMI over 30 in last 15 months

This is an ad hoc search which allows you to search for patients who have been seen in a federative setting in the last week.

For your reference, the Read code for this is 9kh0 Attended extended hours clinic – ESA.

FEDsearch

Batch of useful searches, which include:

Registration Searches:

• Date of Birth: Over 65yrs, Under 5yrs, between two ages (50 -74y range)

Medication Searches:

• Active patients on an acute drug Amoxicillin in the last 6 months
• Active patients on a repeat drug Atenolol in the last 3 months
• Active patients on a repeat class of drug Antidepressants in the last year

Code Searches:

• Active patients with a diagnosis of Parkinson's ever
• Active patients that have had a fall in the last year

Examination Finding Searches:

• Active patients with latest BMI >30 in the last 15 months
• Active patients with latest Cholesterol >7 in the last year
• Active patients with latest BP >= 150/90 in the last 15 months
• Active patients older than 16 years with no BMI recorded after April 2017
• Active patients with any BP >= 150/90 in the last 15 months, not on the hypertensive register
• Active patients with latest BP >=150/90 and latest Cholesterol>5, not on a statin

Consultation Searches:

• Active patients with no consultation recorded in the last 3 years
• Patients must be 18 years old or over, not registered within the last 3 years and currently permanent,
• Excludes patients seen in last 3 years recorded under any other consultation type except Administration.
• Active patients with a face to face consultations in the last year

Vision 3 Group of Searches

Once you have downloaded this search, you must edit the search and add Dr Federated User to each entity:

VA_WRITEBACK_V3SDA.exe

This search has been designed to enable you to add medication from Vision Anywhere and then for that medication to be identified and issued as EPS medication in Vision 3:

UNPRINTED_ACUTES