Amazing Charts User Board
Most Recent Posts
Updating AC
by Bert
12:16 AM
Practice Fusion Joins The Rest: Time To Start Paying
by JamesNT
11:25 PM
E-Rx with Exostar, as Verizon will no longer support Controlled E-Rx
by Bert
02/24/18 10:53 PM
Reports and searching addendums
by EyeGuy
02/24/18 09:35 PM
AC becomes unresponsive
by koby
02/24/18 07:04 PM
MIPS/MACRA attestation
by SoCalFP
02/24/18 08:01 AM
Preventing Scheduling with a Physician who doesn't take insurance
by Wendell365
02/23/18 11:24 PM
User preferences
by Tomastoria
02/23/18 12:43 AM
Free Up Space
by koby
02/22/18 10:01 PM
AC in the cloud vs. server based
by jimmie
02/22/18 06:07 AM
Archiving old patients from AC data base
by JamesNT
02/21/18 05:14 PM
Printing growths charts
by Boondoc
02/21/18 12:28 AM
MACRA/MIPS requirements for 2018
by Tiffany
02/20/18 04:15 PM
AC access slow, aka server is slow
by Bert
02/19/18 03:26 AM
Labs and Diagnostics.
by Dru
02/18/18 07:15 PM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2196
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: 984
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 (), 5 Guests and 43 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11334
JBS 2513
Sandeep 2210
Wendell365 2196
ryanjo 2005
Leslie 2002
Wayne 1889
Indy 1744
Steven 1718
hockeyref 1673
Newest Members
taz, Cronus, DanARS, lajohnston, JessieARS
4444 Registered Users
Forum Stats
4444 Members
16 Forums
7911 Topics
71115 Posts

Max Online: 186 @ 11/25/17 05:44 AM