About
See what contracted/expected payments you have from each of your payers.
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.
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