Amazing Charts User Board
Most Recent Posts
Ask an Updox Guy
by DoctorMel
09:53 PM
Backup Laptop
by AnneMarie
08:56 PM
An added feature under Harris
by AnneMarie
08:52 PM
Quality Payment Program Year 2: MIPS Highlights
by koby
08:36 AM
Medware
by Tomastoria
04:32 AM
Automated Vital Signs
by AmazingDave
11/20/17 08:23 PM
Upgrade to V9.4.4
by SteveH
11/19/17 07:59 PM
Cancer Registry
by DSimpson
11/19/17 03:27 AM
Censorship
by Bill
11/18/17 07:32 PM
Amazing Utilities
by GoBruins
11/17/17 06:29 PM
Problem with opening an Amazing Chart support ticket
by a_ramiz
11/17/17 03:20 PM
controlled substance electronic prescriptions
by jimmie
11/16/17 09:26 PM
Closing a Practice - Records Retention Question
by DManuele
11/16/17 03:44 PM
not sending Rx's to printer
by koby
11/16/17 01:16 PM
Are upgrades and beta testing stagnated due to upgrade procedures?
by Bert
11/15/17 09:50 PM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2184
Loc: Chicago, IL
I am working on PCMH and trying to run a report for patients without a telephone number seen in the last 3 months.

the problem is that the report will not allow = or <> (blank), it requires 10 digits ( % wildcard will not work).

Any ideas?
_________________________
Wendell
Pediatrician in Chicago

The patient's expectation is that you have all the answers, sometimes they just don't like the answer you have for them

Top
#70984 - 03/22/17 06:16 PM Re: report for patients without telephone number [Re: Wendell365]
JamesNT Offline
Member

Registered: 12/30/09
Posts: 956
Loc: North Carolina
Just add a WHERE clause to the query I put in a previous post. Change dates as appropriate.

Code:
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME

SET @StartDate = '1/1/2017'
SET @EndDate = '4/1/2017'

SELECT Demographics.PatientID, [Last] as LastName, [First] as FirstName, Gender, BirthDate, Phone FROM Demographics INNER JOIN 
(SELECT DISTINCT PatientID FROM Billing WHERE DateOfService BETWEEN @StartDate AND @EndDate) as a on Demographics.PatientID = a.PatientID 
WHERE phone is null or phone = ''
ORDER BY LastName



JamesNT
_________________________
James Summerlin
My personal site: http://www.dataintegrationsolutions.net

Top

Moderator:  Indy, JBS, Sandeep 
Shout Box

Who's Online
0 registered (), 8 Guests and 35 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11201
JBS 2483
Sandeep 2192
Wendell365 2184
Leslie 2002
ryanjo 1994
Wayne 1889
Steven 1716
Indy 1710
hockeyref 1669
Newest Members
KATHYS, TM Craft, Mr.Updoxer, carolep, RichieB
4409 Registered Users
Forum Stats
4409 Members
16 Forums
7846 Topics
70551 Posts

Max Online: 172 @ 11/06/17 05:20 PM