Inactive Pt Report

For users or potential users.
Post Reply
speeples
Posts: 27
Joined: Tue Feb 05, 2019 12:27 pm

Inactive Pt Report

Post by speeples » Wed Mar 20, 2019 1:04 pm

Hello,

I'm looking for a report that gives all our Inactive/Non-pts. I want to make sure we don't have insurances attached to them. We are trying to figure out how many pts we have for each insurance carrier.
Thank you :)

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Inactive Pt Report

Post by Tom Zaccaria » Thu Mar 21, 2019 6:54 am

Try this,
drtmz

SELECT IFNULL(Left(c.CarrierName, 15), 'None') AS CarrierName, Left(GroupName, 15) AS GroupName,
PlanType, p.PatNum, CONCAT(p.LName,', ',p.FName,' ',p.MiddleI) AS PatName, ib.SubscriberId,p.Patstatus
FROM patient p
LEFT JOIN patplan pp ON pp.PatNum=p.PatNum
LEFT JOIN inssub ib ON ib.InsSubNum=pp.InsSubNum
LEFT JOIN insplan ip ON ip.PlanNum=ib.PlanNum
LEFT JOIN carrier c ON c.CarrierNum=ip.CarrierNum
WHERE p.PatStatus<>0 AND (pp.Ordinal=1 OR ISNULL(c.CarrierName))

ORDER BY c.CarrierName, GroupName, p.LName;

speeples
Posts: 27
Joined: Tue Feb 05, 2019 12:27 pm

Re: Inactive Pt Report

Post by speeples » Mon Mar 25, 2019 9:24 am

Thanks! I'll try it.

Post Reply