Help finding report

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

Help finding report

Post by speeples » Wed Jun 12, 2019 8:31 am

Hello,

I was wondering if someone could point me in the right direction to a report....I need a list of all subscribers that have Metlife dental insurance. I need an easy way to get their email and address so I can send them a letter.

Thanks :)

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

Re: Help finding report

Post by Tom Zaccaria » Thu Jun 13, 2019 3:05 am

Try this.
drtmz

/*449 List of active patients (not subscribers) with primary insurance plan listed,
Carrier Names and group names are cutoff for space consideration
Check RAW button to show both PatNum and Patient Name*/
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.email
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))
AND CarrierName like '%MetLife%'
ORDER BY c.CarrierName, GroupName, p.LName;

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

Re: Help finding report

Post by speeples » Thu Jun 13, 2019 5:13 am

Thank you :)

Post Reply