# CMS HCRIS Hospital gross patient revenue by payer

`medicare_silver.hospital_cost_report_payer_revenue` · Medicare Advantage, Part D, Medicaid · status live · 91,827 rows

Revision-bound public gross Medicare, Medicaid, Other, and total patient revenue derived from documented Form 2552-10 D-3, D Part V, S-10, and G-2 cells using a pinned American Hospital Directory formula version.

**Grain.** One row per CMS report record, with an explicit latest-record flag per exact (CCN, fiscal-year-end).

| column | type | meaning |
|---|---|---|
| source_fiscal_year | int |  |
| rpt_rec_num | bigint |  |
| ccn | string |  |
| report_status | int |  |
| fy_begin | date |  |
| fy_end | date |  |
| fiscal_year | int |  |
| report_period_days | int |  |
| date_processed | date |  |
| date_created | date |  |
| is_profile_selected | boolean |  |
| formula_version | string |  |
| formula_source_url | string |  |
| revenue_basis | string |  |
| medicare_d3_routine_revenue | double |  |
| medicare_d3_ancillary_revenue | double |  |
| medicare_d_part_v_revenue | double |  |
| medicare_formula_cell_count | int |  |
| medicaid_formula_cell_count | int |  |
| medicaid_worksheet_code | string |  |
| gross_medicare_patient_revenue | double |  |
| gross_medicaid_patient_revenue | double |  |
| gross_other_patient_revenue | double |  |
| gross_total_patient_revenue | double |  |
| gross_inpatient_patient_revenue | double |  |
| gross_outpatient_patient_revenue | double |  |
| g2_reported_total_patient_revenue | double |  |
| payer_revenue_available | boolean |  |
| 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.hospital_cost_report_payer_revenue WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.hospital_cost_report_payer_revenue")` first.