Breaks down credits applied to services in a date range groups by insurance payor.
Select
payorname,
payornum,
credtype,
count(distinct cre_jnum) as "Number",
sum(crsplamt) as "Paid"
From
sos.rv_creditsplits
Where
srv_date between '2001-01-01' and '2001-01-31'
and payortype = 'I'
and systranflag not in ('TT','TF')
group by
credtype,
payornum,
payorname
Breaks down credits applied to services in a date range by type and groups by payor type.
Select
payortype,
Credtype,
count(distinct cre_jnum) as "Number",
sum(crsplamt) as "Paid"
From
sos.rv_creditsplits
Where
srv_date between '2001-01-01' and '2001-01-31'
and systranflag not in ('TT','TF')
group by
credtype,
payortype
SELECT
sum(chgsplamt) as "totalcharge",
defcode as "POS",
year(trandate) as "year"
FROM
sos.rv_charges a join sos.poscodes b on a.poscodenum=b.poscodenum
GROUP BY POS,year
SELECT
year(c.trandate) as YEAR,
defcode as POS,
sum(crsplamt) as "TOTAL PAID"
FROM
sos.jcrsplits a
join sos.jcredits b
join sos.journal c
join sos.rv_charges d on a.chgsplnum=d.chgsplnum
join sos.poscodes e on d.poscodenum=e.poscodenum
WHERE
b.credtype <> 'Adjustment'
GROUP BY year,pos
ORDER BY year,pos
SELECT
b.lucode as Code,
b.remark as Description,
SUM(a.amount) as Charges
FROM
sos.rv_charges a JOIN sos.lookups b ON a.sortcode=b.lunum
WHERE
trandate between '1999-01-01' and TODAY()
GROUP BY b.lucode,b.remark
Simple Software Designs, LLC, dba Synergistic Office Solutions