Amazing Charts User Board
Most Recent Posts
new user questions
by Nephros
Today at 12:45 AM
Quick text program
by Sunil
06/20/17 12:32 AM
Templates for welcome to Medicare and annual Medicare exam
by [email protected]
06/19/17 06:51 PM
Adding copays to bills before uploading superbill batch
by kurt
06/17/17 12:05 AM
How to download old version
by Indy
06/13/17 02:27 PM
Installation Problem
by Bert
06/13/17 02:10 AM
Windows10 update to Creators v1072 incompatible with AC v8.2.5?
by kurt
06/12/17 08:33 PM
Patient Electronic Access
by starbug
06/09/17 11:28 PM
PCMH Reporting /No Shows
by AlleyC
06/09/17 03:19 PM
Records release report
by [email protected]
06/08/17 01:26 PM
inactivating patients
by [email protected]
06/07/17 01:24 PM
How to design a vaccine report that included administration dates?
by [email protected]
06/06/17 02:53 PM
I do not want to General Messages/Adden to print when I print OV Notes
by [email protected]
06/02/17 08:22 PM
Read Only Database
by NeuroDawg
06/02/17 03:27 PM
how to turn off automated formulary checks
by [email protected]
06/01/17 02:18 PM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2165
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: 933
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 (), 1 Guest and 23 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11092
JBS 2449
Sandeep 2185
Wendell365 2165
Leslie 2002
ryanjo 1987
Wayne 1889
Steven 1716
hockeyref 1669
Indy 1645
Newest Members
deis70, Shamus, Oleksandr, Babs, Yadira M
4362 Registered Users
Forum Stats
4362 Members
16 Forums
7756 Topics
69882 Posts

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