Call Us Today
1.877.838.9273

• How to Buy
• Contact Us
• Member Login

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 # 5101520253050100All

Mss rewards