# HHS risk adjustment transfers by issuer, one report revision per benefit year and appendix (current view)

`medicare_semantic.vw_aca_risk_adjustment_transfer_current_v1` · Insurer negotiated rates · status partial · 14,415 rows

The read surface over medicare_silver.fact_aca_risk_adjustment_transfer_history that cannot double count: per benefit year and appendix it keeps the highest cms_vintage_sequence, then the latest asserted_at (the BY2024 revision wins over the June 30 original). Same columns as the history table.

**Grain.** One amount cell of the current revision: (benefit_year, source_appendix, sheet_name, source_row_number, source_column_number). 14,415 rows BY2021-BY2025; BY2024 = 2,850 C + 57 D, the July 23, 2025 revision only (Athena af6735d5, 2026-10-13).

| column | type | meaning |
|---|---|---|
| benefit_year | int |  |
| source_appendix | string |  |
| sheet_name | string |  |
| source_row_number | bigint |  |
| source_column_number | int |  |
| column_header_raw | string |  |
| hios_issuer_id | string |  |
| issuer_name | string |  |
| state_code | string |  |
| program_component | string |  |
| market_risk_pool | string |  |
| amount_usd | double |  |
| amount_raw | string |  |
| amount_status | string |  |
| ordered_header_json | string |  |
| header_sha256 | string |  |
| column_count | int |  |
| raw_values_json | string |  |
| raw_row_sha256 | string |  |
| artifact_id | string |  |
| source_file_bytes | bigint |  |
| final_source_url | string |  |
| expected_artifact_rows | bigint |  |
| publisher_modified_at | string |  |
| publisher_etag | string |  |
| report_title | string |  |
| report_url | string |  |
| report_revision_label | string |  |
| 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_semantic.vw_aca_risk_adjustment_transfer_current_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_aca_risk_adjustment_transfer_current_v1")` first.