Call Us Today
1.877.838.9273

AVImark Forum::Shared Information Searches::Active Patients with No Reminders

Home

AVImark Forum

Shared Information Searches

Active Patients with No Reminders

AVImark Forum :: Shared Information Searches

Board Index

Latest Posts

Welcome Guest

Subject :Active Patients with No Reminders.. 02-23-2011 09:52:17

Information Search Ideas

Advanced User

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

The following search looks at active clients and then reports all active patients that have no reminders.
Active clients are defined as not having an I action code.
(I=Inactive)
Active patients are defined as not having I,D,H, or M action codes.
(I=Inactive,D=Deceased,H=Suspended Reminders,M=Moved)

The following information is reported.
This information can be modified on the report criteria tab.
It is sorted by account number then patient name.

Client Account Number
Client Full Name
Patient Name
Patient Species
Patient Birthday

search [Client] code 'M$BB262' name 'Active Patients with No Reminders'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'i,d,m,h' and
[Patient] does not exist in (
[Patient Reminder-Appropriate] equals 'Appropriate'
)
) report (
[Client-Account],
[Client-Full Name] width 30,
[Patient-Name],
[Patient-Species Code] caption 'Species' width 10,
[Patient-Birthday]
) sort by (0 ascending, 2 ascending)

IP Logged

Subject :Re:Active Patients with No Reminders.. 11-21-2011 02:47:06

Herm1234

User

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

I am not sure what the condition ([Patient] does not exist in (
[Patient Reminder-Appropriate] equals 'Appropriate' means. This seems to be the key part in the search that I am not doing right and thus not getting the right results.

IP Logged

Subject :Re:Active Patients with No Reminders.. 11-21-2011 03:23:37

Information Search Ideas

Advanced User

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

The following condition looks at all patients who have reminders and excludes them from the search results:

[Patient] does not exist in (
[Patient Reminder-Appropriate] equals 'Appropriate'
)

You can copy the code from the original posting (green information only) and then in your AVImark, go to:

Work with information search
Cancel
View
Code editor (erase any information in this window)
Paste the original green code information in this window
Ok
Save this search

When asked to add this search to your database, say yes and then try running the search once more

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