Help finding report

For users or potential users.

Help finding report

Postby speeples » Wed Jun 12, 2019 8:31 am


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 :)
Posts: 9
Joined: Tue Feb 05, 2019 1:27 pm

Re: Help finding report

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

Try this.

/*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,
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;
Tom Zaccaria
Posts: 265
Joined: Mon Feb 25, 2008 4:09 am

Re: Help finding report

Postby speeples » Thu Jun 13, 2019 5:13 am

Thank you :)
Posts: 9
Joined: Tue Feb 05, 2019 1:27 pm

Return to Main Forum

Who is online

Users browsing this forum: No registered users and 11 guests