About

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

You must have payer Contracts loaded in OP.  See Insurance Contracts

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

Copy

select  ins_carrier_code, ins_carrier.ins_fullname,  ins_contract_detail.hcpcs, mod1, ins_contract_detail.effective_date, ins_contract_detail.payment_amount from ins_contract_detail
inner  join ins_carrier_contract on ins_carrier_contract.ins_contract_id = ins_contract_detail.ins_contract_id
inner join ins_carrier on ins_carrier_contract.ins_carrier_id = ins_carrier.carrier_id
where ins_carrier.archive_flag <> 1
order by ins_carrier_code, hcpcs