|The ADJ CODE (Adjustment Code) column displays the internal OP Code that is converted from the EOB to an OP archived_transaction.|
A sample image of this SQL report run in the Database Viewer is shown below:
This includes only insurance-side adjustments.
To highlight and copy the code below to your clipboard, simply click the Copy button.
select round(sum(adjustment),2) as total_adjusted, adj_code, descript from ( select trnsxno, patno, adjustment, date1, cptcode, adj_code, descript from archive_transactions at1 left outer join (select * from code_table where group_id = 1) ct on ct.code_id = at1.adj_code where at1.adj_code >0 and at1.date1 between :startdate and :enddate and at1.archive_flag = 1 order by adj_code ) group by adj_code, descript