Amazing Charts User Board
Most Recent Posts
AC incredibly slow (intermittently) for past week
by KrisM
Today at 02:30 PM
Faxing solutions
by Bert
Today at 02:14 AM
Pharmacy refill requests
by Bert
Yesterday at 01:16 AM
Closing script writer
by Bert
Yesterday at 01:07 AM
VIS and workflow
by Bert
Yesterday at 12:38 AM
Crashing
by Bert
07/24/17 11:53 PM
Texting patients and doctors
by AlleyC
07/24/17 05:39 PM
Exporting Encounter Problem
by Wendell365
07/22/17 07:31 PM
Installation Problem
by Bert
07/21/17 09:27 PM
Printing Address Labels
by Bert
07/21/17 12:06 AM
Updox Workflow
by Sunil
07/17/17 10:57 PM
Transferring entire patient chart to Physician leaving the practice
by Bert
07/17/17 06:13 PM
Virtualization Licensing Common Mistakes
by JamesNT
07/17/17 02:09 AM
Closing a Practice - Records Retention Question
by Bert
07/16/17 11:52 PM
Off topic: Physician personal finance blog
by Rando
07/13/17 04:05 AM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2172
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
Member of the Amazing Charts Clinician Advisory Board
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: 938
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 (), 3 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11138
JBS 2455
Sandeep 2188
Wendell365 2172
Leslie 2002
ryanjo 1988
Wayne 1889
Steven 1716
hockeyref 1669
Indy 1648
Newest Members
eNvAnc, 1964, Cupcake, Rat1215, bhuri
4375 Registered Users
Forum Stats
4375 Members
16 Forums
7774 Topics
70024 Posts

Max Online: 160 @ 10/14/15 08:53 PM