Negotiated rates for one code at one hospital, by payer and plan
get_payer_ratesRetrieve every published payer, plan, setting, and negotiated rate for a billing code at a selected hospital, plus gross and cash prices.
Instructions
Every published charge for one billing code at one hospital: payer, plan, setting, negotiated rate (or the percentage/algorithm when no dollar figure is published), gross and cash price, with the charge's position in the hospital's source file. The first call downloads the 117 MB charge table once.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | Yes | Billing code as published, e.g. 99213. Use find_codes to get one. | |
| limit | No | ||
| payer | No | Case-insensitive match on payer name, e.g. 'aetna', 'blue cross' | |
| setting | No | ||
| rate_basis | No | How the negotiated rate was published. 'dollar' = contracted dollar amount; 'dollar_from_percent' = a percentage of the hospital's own charge, converted to dollars; 'dollar_percent_unreconciled' = a dollar and a percentage that disagree (the dollar is used); 'algorithm_only', 'percent_only' and 'no_payer' carry no dollar rate. Omit for every basis (each row is labelled). | |
| hospital_id | Yes | nm = Northwestern Memorial Hospital, rush = RUSH University Medical Center, uchicago = The University of Chicago Medical Center |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | Yes | ||
| notes | Yes | ||
| rates | Yes | ||
| returned | Yes | ||
| truncated | Yes | ||
| code_family | Yes | ||
| hospital_id | Yes | ||
| release_tag | Yes | ||
| matched_charges | Yes | Distinct charge rows matching every filter | |
| by_setting_and_basis | Yes | Distinct charges per setting × rate basis before the payer filter and limit; equals compare_code_prices' charge_rows |