The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
SELECT paymentmethod, payerdesc, type, [date] = case when type = 'c' then dos else posted end, pfirst+' '+plast as patientname, LTRIM( case when type = 'a' then payerdesc when type = 'p' then payerdesc when type = 'c' then ISNULL(cpt, '') +' - '+ ISNULL(left(cptdesc,100),'') end ) as description, amount, 'Medical Oncology' as physicianid, coalesce(cg.encountercode, '') as practclaimid, case when type = 'c' then 0 else 1 end as priority, left(cptdesc,100) as cptdesc, cpt as cpt, (SELECT sum(amount) from txn where t.chargegroupid = txn.chargegroupid and t.accountid = txn.accountid) as balance, (SELECT min(dos) from txn where t.chargegroupid = txn.chargegroupid and t.accountid = txn.accountid and type = 'c') as firstdos FROM txn t LEFT JOIN chargegroup cg on t.chargegroupid = cg.id WHERE t.accountid = 9949388 AND (cg.status1 not in ('rt','hd','rp','fc') or cg.status1 is null) AND cg.id in ( SELECT chargegroupid from txn where accountid = 9949388 GROUP BY chargegroupid having max(txn.created) > DATEADD(DAY, -365, GETDATE()) ) AND reversedref is null
Join the community of 500,000 technology professionals and ask your questions.