We looking for a report that will list all sessions that have been billed for each insurance company during a month. For example, the report would list out many sessions have been billed for MVP insurance for the month of October. Please let me know if this is possible.
In the following query, the output is directed to an HTML file that can be viewed in a web browser, or loaded in Excel for additional manipulation.
Select All Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | SELECT DISTINCT pay.payorname, pt.lastname, pt.firstname, pt.id, jou.trandate, srv.srvcode, prv.provcode, jou.amount FROM journal jou JOIN jcharges chg ON jou.jnum = chg.jnum JOIN jchgsplits chs ON chg.jnum = chs.jnum JOIN ptpayors ptp ON chs.ptpayornum = ptp.ptpayornum JOIN payors pay ON ptp.payornum = pay.payornum JOIN patients pt ON jou.ptnum = pt.ptnum JOIN services srv ON chg.servicenum = srv.servicenum JOIN providers prv ON chg.providernum = prv.providernum WHERE pay.payortype = 'I' AND trandate BETWEEN '2011-11-01' AND '2011-11-30' ORDER BY pay.payorname, pt.lastname, pt.firstname, pt.id, jou.trandate ; OUTPUT TO c:\sos\insforperiod.html FORMAT HTML |