Amazing Charts User Board
Most Recent Posts
backing up question
by AaronWay
Yesterday at 11:08 PM
Dragon Medical
by AmazingDave
05/22/17 05:52 PM
Gotoassist does not work
by Bert
05/16/17 04:52 PM
[BREAKING NEWS] Large-scale Cyber-attack [UPDATED 5/14/17]
by Bert
05/16/17 04:51 PM
Locum Tenens
by AnneMarie
05/15/17 04:36 PM
Help with replacing Server Hard Dirve
by Bert
05/14/17 08:15 PM
NCQA PCMH prevalidation for AC
by Raj1
05/14/17 05:23 AM
Sprucing up the office
by JamesNT
05/13/17 01:20 AM
Secure Direct Email Addresses
by Ted
05/11/17 09:59 PM
Appointment reminders - AC? Updox?
by Rando
05/10/17 01:01 PM
Still recruiting
by dgrauman
05/09/17 09:24 AM
Consent to disclose health information
by Bert
05/07/17 01:39 AM
Manual Verification Required
by Indy
05/05/17 06:35 PM
If you read nothing else about MIPS/MACRA please read this
by SybridMD1
05/05/17 04:09 PM
Amazing Charts and Updox Reminders
by NeuroDawg
05/04/17 05:57 PM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2163
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: 931
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 (), 4 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11078
JBS 2448
Sandeep 2181
Wendell365 2163
Leslie 2002
ryanjo 1982
Wayne 1889
Steven 1716
hockeyref 1669
Indy 1640
Newest Members
KID1234, dojo, sunflowermedical, Kay730, ibiguj
4350 Registered Users
Forum Stats
4350 Members
16 Forums
7744 Topics
69807 Posts

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