Amazing Charts User Board
Most Recent Posts
Installation Problem
by koby
46 minutes 18 seconds ago
AC Amazing Backup Service
by Bert
Today at 02:08 AM
Billing companies update with AC integration
by pierre
Yesterday at 11:17 PM
APP for iPhone - AC OnCall
by Indy
09/18/17 10:44 PM
Is anyone using patient online appointment self scheduling app?
by endo1
09/18/17 06:11 PM
IMPORT ITEMS/CATEGORIES
by [email protected]
09/18/17 02:00 PM
Editing ICD-10 codes
by Tomastoria
09/17/17 10:22 PM
New Wish List
by Qaiser
09/16/17 05:53 PM
MOC points, Up To Date and Pri-Med
by jimmie
09/16/17 05:12 PM
Harris
by Bert
09/16/17 02:32 AM
Dragon Medical One in the Cloud
by jimmie
09/15/17 05:28 PM
CVS no longer active on eprescrition
by Bert
09/14/17 02:26 PM
Still recruiting
by dgrauman
09/12/17 06:51 AM
Employee Staff Personal Use of Office Computers Facebook Cell Phones
by Bert
09/05/17 01:22 AM
disappearing notes
by Indy
08/31/17 09:39 PM
Topic Options
#70983 - 03/22/17 05:51 PM report for patients without telephone number
Wendell365 Offline
Member

Registered: 11/09/05
Posts: 2177
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: 944
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 (), 6 Guests and 53 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Bert 11161
JBS 2466
Sandeep 2191
Wendell365 2177
Leslie 2002
ryanjo 1990
Wayne 1889
Steven 1716
Indy 1680
hockeyref 1669
Newest Members
Reed, vinodb, LIP, SEH, archana narayan
4395 Registered Users
Forum Stats
4395 Members
16 Forums
7800 Topics
70262 Posts

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