Call Us Today
1.877.838.9273

AVImark Forum::Shared Information Searches::Annual Exams without vaccines

Home

AVImark Forum

Shared Information Searches

Annual Exams without vaccines

AVImark Forum :: Shared Information Searches

Board Index

Latest Posts

Welcome Guest

Subject :Annual Exams without vaccines.. 01-20-2012 05:31:56

Herm1234

User

Joined: 04-29-2011 11:52:21
Posts: 22
Location:

Our reminders are set up for an OEX (annual examination) as well as a VFANN (annual feline vaccines) and VCANN (annual canine vaccines). I am looking help on a search for those with overdue OEX only, but do not contain VCANN or VFANN. I have tried it many different ways and it has not been successful. This so far is the best one, but I know that I have patients in this list that contain the VCANN/VFANN code.

search [Client] code 'TEST1' name 'oex,no vfann,no vcann'
category 'Reminders' (
[Client-Codes] does not equal 'I' and
[Patient-Codes] does not equal 'D,I' and
[Patient Reminder-Code] equals 'oex' and
[Patient Reminder] does not exist in (
[Patient Reminder-Code] equals 'VCANN,VFANN'
)
) report (
[Client-Full Name],
[Patient-Name]
) sort by (0 ascending)

Thank you in advance for your help.
KC

IP Logged

Subject :Re:Annual Exams without vaccines.. 01-26-2012 06:33:00

Information Search Ideas

Advanced User

Joined: 10-11-2010 09:14:32
Posts: 72
Location:

Hi KC

Please try the following searches. The date ranges can be changed on the search criteria tab. Both searches report the following, sorted by the client's account number, followed by the patient's name:

Client's Account Number
Client's Full Name
Patient's Name

The first search (green):
Looks at any OverDue OEX during the time period entered, where the patient doesn't have a VCANN or VFANN due at all.

search [Client] code 'M$BB0714' name 'OverDue OEX Not VCANN VFANN'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'd,i,m,h' and
[Patient] exists in (
[Patient Reminder-Appropriate] equals 'Appropriate' and
[Patient Reminder-Due] is between '12-01-11' '12-31-11' and
[Patient Reminder-Code] equals 'OEX'
) and
[Patient] does not exist in (
[Patient Reminder-Appropriate] equals 'Appropriate' and
[Patient Reminder-Code] equals 'VCANN,VFANN'
)
) report (
[Client-Account],
[Client-Full Name] width 30,
[Patient-Name]
) sort by (0 ascending, 2 ascending)

The second search (red):
Looks at any OverDue OEX during the time period entered, where the patient also has a VCANN or VFANN due during another time entered.

search [Client] code 'M$BB0715' name 'OverDue OEX While VCANN VFANN Due Another Time'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'd,i,m,h' and
[Patient] exists in (
[Patient Reminder-Appropriate] equals 'Appropriate' and
[Patient Reminder-Due] is between '12-01-11' '12-31-11' and
[Patient Reminder-Code] equals 'OEX'
) and
[Patient] does not exist in (
[Patient Reminder-Appropriate] equals 'Appropriate' and
[Patient Reminder-Code] equals 'VCANN,VFANN' and
[Patient Reminder-Due] is between '07-01-11' '07-31-11'
)
) report (
[Client-Account],
[Client-Full Name] width 30,
[Patient-Name]
) sort by (0 ascending, 2 ascending)

IP Logged


	Page #

" I could be a salesperson for AVImark - the company is great, technical support staff is super - I love the software - if you need to refer new potential users to happy clients....have them call me! "

Angee Baker

Chat Hours:
Monday - Friday
8am - 5pm CST

Mss rewards

Sign up for a year of AVImark technical support and get additional discounts when you use these other services. Click Here to Learn More