# CMS Federal IDR QPA and offers

`medicare_silver.fact_idr_qpa_offer` · Insurer negotiated rates · status live · 11,346,219 rows

The official QPA and Offers tab, separated from determination line items because its publisher grain and historical identifiers differ. Carries service, geography/POS, QPA, provider/plan/prevailing offers, selected/default indicators, raw-value/status, and M-2 lineage.

**Grain.** One row per published QPA/offer observation (year, quarter, row_seq); early workbooks do not expose dispute/DLI identifiers on this tab.

| column | type | meaning |
|---|---|---|
| year | int |  |
| quarter | int |  |
| row_seq | bigint |  |
| service_code | string |  |
| type_of_service_code | string |  |
| service_code_modifiers | string |  |
| place_of_service_code | string |  |
| geographical_region | string |  |
| air_ambulance_pickup_location | string |  |
| offer_selected_from | string |  |
| default_decision | string |  |
| initiating_party | string |  |
| dispute_line_item_type | string |  |
| certified_idr_entity | string |  |
| qpa | double |  |
| qpa_source_value | string |  |
| qpa_status | string |  |
| provider_offer | double |  |
| provider_offer_source_value | string |  |
| provider_offer_status | string |  |
| health_plan_offer | double |  |
| health_plan_offer_source_value | string |  |
| health_plan_offer_status | string |  |
| prevailing_offer | double |  |
| prevailing_offer_source_value | string |  |
| prevailing_offer_status | string |  |
| cost_sharing_amount | double |  |
| cost_sharing_amount_source_value | string |  |
| cost_sharing_amount_status | string |  |
| initial_payment_amount | double |  |
| initial_payment_amount_source_value | string |  |
| initial_payment_amount_status | string |  |
| year_of_service | int |  |
| year_of_service_source_value | string |  |
| year_of_service_status | string |  |
| source_member | string |  |
| source_row_number | bigint |  |
| source_member_crc32 | string |  |
| quality_flags | string |  |
| is_analytics_eligible | boolean |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_idr_qpa_offer WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_idr_qpa_offer")` first.