# CMS Federal IDR Air Ambulance determinations

`medicare_silver.fact_idr_air_ambulance_determination` · Insurer negotiated rates · status live · 104,383 rows

The official Air Ambulance tab of each Federal IDR PUF, preserved as its own line-item grain with air vehicle, service, party, offer, QPA, raw-value/status, quality, and M-2 lineage fields.

**Grain.** One row per air-ambulance dispute line item (year, quarter, row_seq).

| column | type | meaning |
|---|---|---|
| year | int |  |
| quarter | int |  |
| row_seq | bigint |  |
| dispute_number | string |  |
| dli_number | string |  |
| payment_determination_outcome | string |  |
| default_decision | string |  |
| type_of_dispute | string |  |
| provider_group_name | string |  |
| provider_name | string |  |
| provider_email_domain | string |  |
| provider_npi | string |  |
| health_plan_name | string |  |
| health_plan_email_domain | string |  |
| health_plan_type | string |  |
| dispute_line_item_type | string |  |
| type_of_service_code | string |  |
| service_code | string |  |
| service_code_modifiers | string |  |
| place_of_service_code | string |  |
| item_description | string |  |
| location_of_service | string |  |
| offer_selected_from | string |  |
| initiating_party | string |  |
| certified_idr_entity | string |  |
| air_ambulance_vehicle_type | string |  |
| air_ambulance_vehicle_clinical_capacity_level | string |  |
| time_to_determination_days | double |  |
| time_to_determination_days_source_value | string |  |
| time_to_determination_days_status | string |  |
| idre_compensation | double |  |
| idre_compensation_source_value | string |  |
| idre_compensation_status | string |  |
| provider_offer_pct_qpa | double |  |
| provider_offer_pct_qpa_source_value | string |  |
| provider_offer_pct_qpa_status | string |  |
| health_plan_offer_pct_qpa | double |  |
| health_plan_offer_pct_qpa_source_value | string |  |
| health_plan_offer_pct_qpa_status | string |  |
| prevailing_offer_pct_qpa | double |  |
| prevailing_offer_pct_qpa_source_value | string |  |
| prevailing_offer_pct_qpa_status | string |  |
| qpa_pct_of_median_qpa | double |  |
| qpa_pct_of_median_qpa_source_value | string |  |
| qpa_pct_of_median_qpa_status | string |  |
| provider_offer_pct_median_provider_offer | double |  |
| provider_offer_pct_median_provider_offer_source_value | string |  |
| provider_offer_pct_median_provider_offer_status | string |  |
| health_plan_offer_pct_median_health_plan_offer | double |  |
| health_plan_offer_pct_median_health_plan_offer_source_value | string |  |
| health_plan_offer_pct_median_health_plan_offer_status | string |  |
| prevailing_offer_pct_median_prevailing_offer | double |  |
| prevailing_offer_pct_median_prevailing_offer_source_value | string |  |
| prevailing_offer_pct_median_prevailing_offer_status | string |  |
| date_of_initiation | date |  |
| date_of_initiation_source_value | string |  |
| date_of_initiation_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_air_ambulance_determination WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_idr_air_ambulance_determination")` first.