> For the complete documentation index, see [llms.txt](https://docs.dataplex-consulting.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/expanded-home-health-value-based-purchasing-hhvbp-model-agency-data.md).

# Expanded Home Health Value-Based Purchasing (HHVBP) Model - Agency Data

Agency-level data on Expanded HHVBP performance metrics, achievement and improvement points, measure weights, total performance scores, payment year, and…

Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md) › Home health services

Dataplex delivers this CMS feed as the analysis-ready table `DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN` on Snowflake and Databricks: two snapshot releases spanning 2025–2025, aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

## Key facts

|                    |                                                                        |
| ------------------ | ---------------------------------------------------------------------- |
| **Snowflake**      | `DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN`     |
| **Databricks**     | `cms_dwv.expanded_home_health_value_based_purchasing_hhvbp_model_agen` |
| **Cadence**        | Annual                                                                 |
| **Update pattern** | Full-refresh; each file replaces the prior snapshot                    |
| **CMS published**  | 2025-12-01                                                             |
| **Loaded**         | 2026-09-28                                                             |
| **Columns**        | 253 data + 6 lineage                                                   |
| **Identifiers**    | CCN                                                                    |
| **File versions**  | 2                                                                      |
| **License**        | CMS public data (U.S. Government work)                                 |
| **Platforms**      | Snowflake Marketplace · Databricks Delta Sharing                       |

Included in the CMS Data Feeds Dataset, [start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset).

{% hint style="success" %}
**Current**: CMS last published this feed on 2025-12-01. Coverage runs through 2025-12-01. Next CMS release expected \~Dec 2026.
{% endhint %}

{% hint style="info" %}
**Full-refresh feed**: each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.
{% endhint %}

## Sample queries

{% tabs %}
{% tab title="Snowflake" %}

```sql
-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;
```

{% endtab %}

{% tab title="Databricks" %}

```sql
-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM cms_dwv.expanded_home_health_value_based_purchasing_hhvbp_model_agen
WHERE file_id IN (
  SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;
```

{% endtab %}
{% endtabs %}

## About this feed

> Agency-level data on Expanded HHVBP performance metrics, achievement and improvement points, measure weights, total performance scores, payment year, and adjusted payment percentages.
>
> *Source: CMS feed metadata*

**Keywords:** home health, home health value-based purchasing, HHVBP, quality, performance, total performance score, adjusted payment percentage, agency-level **Theme:** Home health services

## Coverage timeline

2025 🟩

1 of 1 years with snapshot releases, no gaps.

## Release history

| Reporting period          | CMS published | Loaded     | Latest file |
| ------------------------- | ------------- | ---------- | ----------- |
| Snapshot as of 2025-12-01 | 2025-12-01    | 2026-09-28 | ✓           |
| Snapshot as of 2025-12-01 | 2025-12-01    | 2026-09-27 |             |

## Data dictionary

<details>

<summary>📋 <strong>253 data columns + 6 lineage columns</strong></summary>

**Data columns**

| Column                                                          | Type   | Description                                                                   |
| --------------------------------------------------------------- | ------ | ----------------------------------------------------------------------------- |
| `DATA_PERIOD`                                                   | TEXT   | Data snapshot period from BATCH\_LOG                                          |
| `CMS_CERTIFICATION_NUMBER_CCN`                                  | TEXT   | Source column: CMS Certification Number (CCN)                                 |
| `STATE`                                                         | TEXT   | Source column: State                                                          |
| `PROVIDER_NAME`                                                 | TEXT   | Source column: Provider Name                                                  |
| `PROVIDER_ADDRESS`                                              | TEXT   | Source column: Provider Address                                               |
| `NATIONWIDE_COHORT`                                             | TEXT   | Source column: Nationwide Cohort                                              |
| `FOOTNOTE_NATIONWIDE_COHORT`                                    | TEXT   | Source column: Footnote Nationwide Cohort                                     |
| `DISCHARGED_TO_COMMUNITY_PY_HHA_DATA_PERIOD`                    | TEXT   | Source column: Discharged to Community: PY HHA Data Period                    |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_PY_HHA_DATA_PERIOD`           | TEXT   | Source column: Footnote Discharged to Community: PY HHA Data Period           |
| `ORAL_MEDICATIONS_PY_HHA_DATA_PERIOD`                           | TEXT   | Source column: Oral Medications: PY HHA Data Period                           |
| `FOOTNOTE_ORAL_MEDICATIONS_PY_HHA_DATA_PERIOD`                  | TEXT   | Source column: Footnote Oral Medications: PY HHA Data Period                  |
| `DYSPNEA_PY_HHA_DATA_PERIOD`                                    | TEXT   | Source column: Dyspnea: PY HHA Data Period                                    |
| `FOOTNOTE_DYSPNEA_PY_HHA_DATA_PERIOD`                           | TEXT   | Source column: Footnote Dyspnea: PY HHA Data Period                           |
| `TNC_MOBILITY_PY_HHA_DATA_PERIOD`                               | TEXT   | Source column: TNC Mobility: PY HHA Data Period                               |
| `FOOTNOTE_TNC_MOBILITY_PY_HHA_DATA_PERIOD`                      | TEXT   | Source column: Footnote TNC Mobility: PY HHA Data Period                      |
| `TNC_SELF_CARE_PY_HHA_DATA_PERIOD`                              | TEXT   | Source column: TNC Self-Care: PY HHA Data Period                              |
| `FOOTNOTE_TNC_SELF_CARE_PY_HHA_DATA_PERIOD`                     | TEXT   | Source column: Footnote TNC Self-Care: PY HHA Data Period                     |
| `ACH_PY_HHA_DATA_PERIOD`                                        | TEXT   | Source column: ACH: PY HHA Data Period                                        |
| `FOOTNOTE_ACH_PY_HHA_DATA_PERIOD`                               | TEXT   | Source column: Footnote ACH: PY HHA Data Period                               |
| `ED_USE_PY_HHA_DATA_PERIOD`                                     | TEXT   | Source column: ED Use: PY HHA Data Period                                     |
| `FOOTNOTE_ED_USE_PY_HHA_DATA_PERIOD`                            | TEXT   | Source column: Footnote ED Use: PY HHA Data Period                            |
| `CARE_OF_PATIENTS_PY_HHA_DATA_PERIOD`                           | TEXT   | Source column: Care of Patients: PY HHA Data Period                           |
| `FOOTNOTE_CARE_OF_PATIENTS_PY_HHA_DATA_PERIOD`                  | TEXT   | Source column: Footnote Care of Patients: PY HHA Data Period                  |
| `COMMUNICATION_PY_HHA_DATA_PERIOD`                              | TEXT   | Source column: Communication: PY HHA Data Period                              |
| `FOOTNOTE_COMMUNICATION_PY_HHA_DATA_PERIOD`                     | TEXT   | Source column: Footnote Communication: PY HHA Data Period                     |
| `SPECIFIC_CARE_ISSUES_PY_HHA_DATA_PERIOD`                       | TEXT   | Source column: Specific Care Issues: PY HHA Data Period                       |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_PY_HHA_DATA_PERIOD`              | TEXT   | Source column: Footnote Specific Care Issues: PY HHA Data Period              |
| `OVERALL_RATING_PY_HHA_DATA_PERIOD`                             | TEXT   | Source column: Overall Rating: PY HHA Data Period                             |
| `FOOTNOTE_OVERALL_RATING_PY_HHA_DATA_PERIOD`                    | TEXT   | Source column: Footnote Overall Rating: PY HHA Data Period                    |
| `WILLINGNESS_TO_RECOMMEND_PY_HHA_DATA_PERIOD`                   | TEXT   | Source column: Willingness to Recommend: PY HHA Data Period                   |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_PY_HHA_DATA_PERIOD`          | TEXT   | Source column: Footnote Willingness to Recommend: PY HHA Data Period          |
| `DISCHARGED_TO_COMMUNITY_PY_HHA_MEASURE_VALUE`                  | NUMBER | Source column: Discharged to Community: PY HHA Measure Value                  |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_PY_HHA_MEASURE_VALUE`         | TEXT   | Source column: Footnote Discharged to Community: PY HHA Measure Value         |
| `DYSPNEA_PY_HHA_MEASURE_VALUE`                                  | NUMBER | Source column: Dyspnea: PY HHA Measure Value                                  |
| `FOOTNOTE_DYSPNEA_PY_HHA_MEASURE_VALUE`                         | TEXT   | Source column: Footnote Dyspnea: PY HHA Measure Value                         |
| `ORAL_MEDICATIONS_PY_HHA_MEASURE_VALUE`                         | NUMBER | Source column: Oral Medications: PY HHA Measure Value                         |
| `FOOTNOTE_ORAL_MEDICATIONS_PY_HHA_MEASURE_VALUE`                | TEXT   | Source column: Footnote Oral Medications: PY HHA Measure Value                |
| `TNC_MOBILITY_PY_HHA_MEASURE_VALUE`                             | NUMBER | Source column: TNC Mobility: PY HHA Measure Value                             |
| `FOOTNOTE_TNC_MOBILITY_PY_HHA_MEASURE_VALUE`                    | TEXT   | Source column: Footnote TNC Mobility: PY HHA Measure Value                    |
| `TNC_SELF_CARE_PY_HHA_MEASURE_VALUE`                            | NUMBER | Source column: TNC Self-Care: PY HHA Measure Value                            |
| `FOOTNOTE_TNC_SELF_CARE_PY_HHA_MEASURE_VALUE`                   | TEXT   | Source column: Footnote TNC Self-Care: PY HHA Measure Value                   |
| `ACH_PY_HHA_MEASURE_VALUE`                                      | NUMBER | Source column: ACH: PY HHA Measure Value                                      |
| `FOOTNOTE_ACH_PY_HHA_MEASURE_VALUE`                             | TEXT   | Source column: Footnote ACH: PY HHA Measure Value                             |
| `ED_USE_PY_HHA_MEASURE_VALUE`                                   | NUMBER | Source column: ED Use: PY HHA Measure Value                                   |
| `FOOTNOTE_ED_USE_PY_HHA_MEASURE_VALUE`                          | TEXT   | Source column: Footnote ED Use: PY HHA Measure Value                          |
| `CARE_OF_PATIENTS_PY_HHA_MEASURE_VALUE`                         | NUMBER | Source column: Care of Patients: PY HHA Measure Value                         |
| `FOOTNOTE_CARE_OF_PATIENTS_PY_HHA_MEASURE_VALUE`                | TEXT   | Source column: Footnote Care of Patients: PY HHA Measure Value                |
| `COMMUNICATION_PY_HHA_MEASURE_VALUE`                            | NUMBER | Source column: Communication: PY HHA Measure Value                            |
| `FOOTNOTE_COMMUNICATION_PY_HHA_MEASURE_VALUE`                   | TEXT   | Source column: Footnote Communication: PY HHA Measure Value                   |
| `SPECIFIC_CARE_ISSUES_PY_HHA_MEASURE_VALUE`                     | NUMBER | Source column: Specific Care Issues: PY HHA Measure Value                     |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_PY_HHA_MEASURE_VALUE`            | TEXT   | Source column: Footnote Specific Care Issues: PY HHA Measure Value            |
| `OVERALL_RATING_PY_HHA_MEASURE_VALUE`                           | NUMBER | Source column: Overall Rating: PY HHA Measure Value                           |
| `FOOTNOTE_OVERALL_RATING_PY_HHA_MEASURE_VALUE`                  | TEXT   | Source column: Footnote Overall Rating: PY HHA Measure Value                  |
| `WILLINGNESS_TO_RECOMMEND_PY_HHA_MEASURE_VALUE`                 | NUMBER | Source column: Willingness to Recommend: PY HHA Measure Value                 |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_PY_HHA_MEASURE_VALUE`        | TEXT   | Source column: Footnote Willingness to Recommend: PY HHA Measure Value        |
| `DISCHARGED_TO_COMMUNITY_HHA_ACHIEVEMENT_POINTS`                | NUMBER | Source column: Discharged to Community: HHA Achievement Points                |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_ACHIEVEMENT_POINTS`       | TEXT   | Source column: Footnote Discharged to Community: HHA Achievement Points       |
| `DYSPNEA_HHA_ACHIEVEMENT_POINTS`                                | NUMBER | Source column: Dyspnea: HHA Achievement Points                                |
| `FOOTNOTE_DYSPNEA_HHA_ACHIEVEMENT_POINTS`                       | TEXT   | Source column: Footnote Dyspnea: HHA Achievement Points                       |
| `ORAL_MEDICATIONS_HHA_ACHIEVEMENT_POINTS`                       | NUMBER | Source column: Oral Medications: HHA Achievement Points                       |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_ACHIEVEMENT_POINTS`              | TEXT   | Source column: Footnote Oral Medications: HHA Achievement Points              |
| `TNC_MOBILITY_HHA_ACHIEVEMENT_POINTS`                           | NUMBER | Source column: TNC Mobility: HHA Achievement Points                           |
| `FOOTNOTE_TNC_MOBILITY_HHA_ACHIEVEMENT_POINTS`                  | TEXT   | Source column: Footnote TNC Mobility: HHA Achievement Points                  |
| `TNC_SELF_CARE_HHA_ACHIEVEMENT_POINTS`                          | NUMBER | Source column: TNC Self-Care: HHA Achievement Points                          |
| `FOOTNOTE_TNC_SELF_CARE_HHA_ACHIEVEMENT_POINTS`                 | TEXT   | Source column: Footnote TNC Self-Care: HHA Achievement Points                 |
| `ACH_HHA_ACHIEVEMENT_POINTS`                                    | NUMBER | Source column: ACH: HHA Achievement Points                                    |
| `FOOTNOTE_ACH_HHA_ACHIEVEMENT_POINTS`                           | TEXT   | Source column: Footnote ACH: HHA Achievement Points                           |
| `ED_USE_HHA_ACHIEVEMENT_POINTS`                                 | NUMBER | Source column: ED Use: HHA Achievement Points                                 |
| `FOOTNOTE_ED_USE_HHA_ACHIEVEMENT_POINTS`                        | TEXT   | Source column: Footnote ED Use: HHA Achievement Points                        |
| `CARE_OF_PATIENTS_HHA_ACHIEVEMENT_POINTS`                       | NUMBER | Source column: Care of Patients: HHA Achievement Points                       |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_ACHIEVEMENT_POINTS`              | TEXT   | Source column: Footnote Care of Patients: HHA Achievement Points              |
| `COMMUNICATION_HHA_ACHIEVEMENT_POINTS`                          | NUMBER | Source column: Communication: HHA Achievement Points                          |
| `FOOTNOTE_COMMUNICATION_HHA_ACHIEVEMENT_POINTS`                 | TEXT   | Source column: Footnote Communication: HHA Achievement Points                 |
| `SPECIFIC_CARE_ISSUES_HHA_ACHIEVEMENT_POINTS`                   | NUMBER | Source column: Specific Care Issues: HHA Achievement Points                   |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_ACHIEVEMENT_POINTS`          | TEXT   | Source column: Footnote Specific Care Issues: HHA Achievement Points          |
| `OVERALL_RATING_HHA_ACHIEVEMENT_POINTS`                         | NUMBER | Source column: Overall Rating: HHA Achievement Points                         |
| `FOOTNOTE_OVERALL_RATING_HHA_ACHIEVEMENT_POINTS`                | TEXT   | Source column: Footnote Overall Rating: HHA Achievement Points                |
| `WILLINGNESS_TO_RECOMMEND_HHA_ACHIEVEMENT_POINTS`               | NUMBER | Source column: Willingness to Recommend: HHA Achievement Points               |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_ACHIEVEMENT_POINTS`      | TEXT   | Source column: Footnote Willingness to Recommend: HHA Achievement Points      |
| `DISCHARGED_TO_COMMUNITY_HHA_BASELINE_YEAR`                     | TEXT   | Source column: Discharged to Community: HHA Baseline Year                     |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_BASELINE_YEAR`            | TEXT   | Source column: Footnote Discharged to Community: HHA Baseline Year            |
| `ORAL_MEDICATIONS_HHA_BASELINE_YEAR`                            | TEXT   | Source column: Oral Medications: HHA Baseline Year                            |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_BASELINE_YEAR`                   | TEXT   | Source column: Footnote Oral Medications: HHA Baseline Year                   |
| `DYSPNEA_HHA_BASELINE_YEAR`                                     | TEXT   | Source column: Dyspnea: HHA Baseline Year                                     |
| `FOOTNOTE_DYSPNEA_HHA_BASELINE_YEAR`                            | TEXT   | Source column: Footnote Dyspnea: HHA Baseline Year                            |
| `TNC_MOBILITY_HHA_BASELINE_YEAR`                                | TEXT   | Source column: TNC Mobility: HHA Baseline Year                                |
| `FOOTNOTE_TNC_MOBILITY_HHA_BASELINE_YEAR`                       | TEXT   | Source column: Footnote TNC Mobility: HHA Baseline Year                       |
| `TNC_SELF_CARE_HHA_BASELINE_YEAR`                               | TEXT   | Source column: TNC Self-Care: HHA Baseline Year                               |
| `FOOTNOTE_TNC_SELF_CARE_HHA_BASELINE_YEAR`                      | TEXT   | Source column: Footnote TNC Self-Care: HHA Baseline Year                      |
| `ACH_HHA_BASELINE_YEAR`                                         | TEXT   | Source column: ACH: HHA Baseline Year                                         |
| `FOOTNOTE_ACH_HHA_BASELINE_YEAR`                                | TEXT   | Source column: Footnote ACH: HHA Baseline Year                                |
| `ED_USE_HHA_BASELINE_YEAR`                                      | TEXT   | Source column: ED Use: HHA Baseline Year                                      |
| `FOOTNOTE_ED_USE_HHA_BASELINE_YEAR`                             | TEXT   | Source column: Footnote ED Use: HHA Baseline Year                             |
| `CARE_OF_PATIENTS_HHA_BASELINE_YEAR`                            | TEXT   | Source column: Care of Patients: HHA Baseline Year                            |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_BASELINE_YEAR`                   | TEXT   | Source column: Footnote Care of Patients: HHA Baseline Year                   |
| `COMMUNICATION_HHA_BASELINE_YEAR`                               | TEXT   | Source column: Communication: HHA Baseline Year                               |
| `FOOTNOTE_COMMUNICATION_HHA_BASELINE_YEAR`                      | TEXT   | Source column: Footnote Communication: HHA Baseline Year                      |
| `SPECIFIC_CARE_ISSUES_HHA_BASELINE_YEAR`                        | TEXT   | Source column: Specific Care Issues: HHA Baseline Year                        |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_BASELINE_YEAR`               | TEXT   | Source column: Footnote Specific Care Issues: HHA Baseline Year               |
| `OVERALL_RATING_HHA_BASELINE_YEAR`                              | TEXT   | Source column: Overall Rating: HHA Baseline Year                              |
| `FOOTNOTE_OVERALL_RATING_HHA_BASELINE_YEAR`                     | TEXT   | Source column: Footnote Overall Rating: HHA Baseline Year                     |
| `WILLINGNESS_TO_RECOMMEND_HHA_BASELINE_YEAR`                    | TEXT   | Source column: Willingness to Recommend: HHA Baseline Year                    |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_BASELINE_YEAR`           | TEXT   | Source column: Footnote Willingness to Recommend: HHA Baseline Year           |
| `DISCHARGED_TO_COMMUNITY_HHA_IMPROVEMENT_THRESHOLD`             | NUMBER | Source column: Discharged to Community: HHA Improvement Threshold             |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_IMPROVEMENT_THRESHOLD`    | TEXT   | Source column: Footnote Discharged to Community: HHA Improvement Threshold    |
| `DYSPNEA_HHA_IMPROVEMENT_THRESHOLD`                             | NUMBER | Source column: Dyspnea: HHA Improvement Threshold                             |
| `FOOTNOTE_DYSPNEA_HHA_IMPROVEMENT_THRESHOLD`                    | TEXT   | Source column: Footnote Dyspnea: HHA Improvement Threshold                    |
| `ORAL_MEDICATIONS_HHA_IMPROVEMENT_THRESHOLD`                    | NUMBER | Source column: Oral Medications: HHA Improvement Threshold                    |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_IMPROVEMENT_THRESHOLD`           | TEXT   | Source column: Footnote Oral Medications: HHA Improvement Threshold           |
| `TNC_MOBILITY_HHA_IMPROVEMENT_THRESHOLD`                        | NUMBER | Source column: TNC Mobility: HHA Improvement Threshold                        |
| `FOOTNOTE_TNC_MOBILITY_HHA_IMPROVEMENT_THRESHOLD`               | TEXT   | Source column: Footnote TNC Mobility: HHA Improvement Threshold               |
| `TNC_SELF_CARE_HHA_IMPROVEMENT_THRESHOLD`                       | NUMBER | Source column: TNC Self-Care: HHA Improvement Threshold                       |
| `FOOTNOTE_TNC_SELF_CARE_HHA_IMPROVEMENT_THRESHOLD`              | TEXT   | Source column: Footnote TNC Self-Care: HHA Improvement Threshold              |
| `ACH_HHA_IMPROVEMENT_THRESHOLD`                                 | NUMBER | Source column: ACH: HHA Improvement Threshold                                 |
| `FOOTNOTE_ACH_HHA_IMPROVEMENT_THRESHOLD`                        | TEXT   | Source column: Footnote ACH: HHA Improvement Threshold                        |
| `ED_USE_HHA_IMPROVEMENT_THRESHOLD`                              | NUMBER | Source column: ED Use: HHA Improvement Threshold                              |
| `FOOTNOTE_ED_USE_HHA_IMPROVEMENT_THRESHOLD`                     | TEXT   | Source column: Footnote ED Use: HHA Improvement Threshold                     |
| `CARE_OF_PATIENTS_HHA_IMPROVEMENT_THRESHOLD`                    | NUMBER | Source column: Care of Patients: HHA Improvement Threshold                    |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_IMPROVEMENT_THRESHOLD`           | TEXT   | Source column: Footnote Care of Patients: HHA Improvement Threshold           |
| `COMMUNICATION_HHA_IMPROVEMENT_THRESHOLD`                       | NUMBER | Source column: Communication: HHA Improvement Threshold                       |
| `FOOTNOTE_COMMUNICATION_HHA_IMPROVEMENT_THRESHOLD`              | TEXT   | Source column: Footnote Communication: HHA Improvement Threshold              |
| `SPECIFIC_CARE_ISSUES_HHA_IMPROVEMENT_THRESHOLD`                | NUMBER | Source column: Specific Care Issues: HHA Improvement Threshold                |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_IMPROVEMENT_THRESHOLD`       | TEXT   | Source column: Footnote Specific Care Issues: HHA Improvement Threshold       |
| `OVERALL_RATING_HHA_IMPROVEMENT_THRESHOLD`                      | NUMBER | Source column: Overall Rating: HHA Improvement Threshold                      |
| `FOOTNOTE_OVERALL_RATING_HHA_IMPROVEMENT_THRESHOLD`             | TEXT   | Source column: Footnote Overall Rating: HHA Improvement Threshold             |
| `WILLINGNESS_TO_RECOMMEND_HHA_IMPROVEMENT_THRESHOLD`            | NUMBER | Source column: Willingness to Recommend: HHA Improvement Threshold            |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_IMPROVEMENT_THRESHOLD`   | TEXT   | Source column: Footnote Willingness to Recommend: HHA Improvement Threshold   |
| `DISCHARGED_TO_COMMUNITY_HHA_IMPROVEMENT_POINTS`                | NUMBER | Source column: Discharged to Community: HHA Improvement Points                |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_IMPROVEMENT_POINTS`       | TEXT   | Source column: Footnote Discharged to Community: HHA Improvement Points       |
| `DYSPNEA_HHA_IMPROVEMENT_POINTS`                                | NUMBER | Source column: Dyspnea: HHA Improvement Points                                |
| `FOOTNOTE_DYSPNEA_HHA_IMPROVEMENT_POINTS`                       | TEXT   | Source column: Footnote Dyspnea: HHA Improvement Points                       |
| `ORAL_MEDICATIONS_HHA_IMPROVEMENT_POINTS`                       | NUMBER | Source column: Oral Medications: HHA Improvement Points                       |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_IMPROVEMENT_POINTS`              | TEXT   | Source column: Footnote Oral Medications: HHA Improvement Points              |
| `TNC_MOBILITY_HHA_IMPROVEMENT_POINTS`                           | NUMBER | Source column: TNC Mobility: HHA Improvement Points                           |
| `FOOTNOTE_TNC_MOBILITY_HHA_IMPROVEMENT_POINTS`                  | TEXT   | Source column: Footnote TNC Mobility: HHA Improvement Points                  |
| `TNC_SELF_CARE_HHA_IMPROVEMENT_POINTS`                          | NUMBER | Source column: TNC Self-Care: HHA Improvement Points                          |
| `FOOTNOTE_TNC_SELF_CARE_HHA_IMPROVEMENT_POINTS`                 | TEXT   | Source column: Footnote TNC Self-Care: HHA Improvement Points                 |
| `ACH_HHA_IMPROVEMENT_POINTS`                                    | NUMBER | Source column: ACH: HHA Improvement Points                                    |
| `FOOTNOTE_ACH_HHA_IMPROVEMENT_POINTS`                           | TEXT   | Source column: Footnote ACH: HHA Improvement Points                           |
| `ED_USE_HHA_IMPROVEMENT_POINTS`                                 | NUMBER | Source column: ED Use: HHA Improvement Points                                 |
| `FOOTNOTE_ED_USE_HHA_IMPROVEMENT_POINTS`                        | TEXT   | Source column: Footnote ED Use: HHA Improvement Points                        |
| `CARE_OF_PATIENTS_HHA_IMPROVEMENT_POINTS`                       | NUMBER | Source column: Care of Patients: HHA Improvement Points                       |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_IMPROVEMENT_POINTS`              | TEXT   | Source column: Footnote Care of Patients: HHA Improvement Points              |
| `COMMUNICATION_HHA_IMPROVEMENT_POINTS`                          | NUMBER | Source column: Communication: HHA Improvement Points                          |
| `FOOTNOTE_COMMUNICATION_HHA_IMPROVEMENT_POINTS`                 | TEXT   | Source column: Footnote Communication: HHA Improvement Points                 |
| `SPECIFIC_CARE_ISSUES_HHA_IMPROVEMENT_POINTS`                   | NUMBER | Source column: Specific Care Issues: HHA Improvement Points                   |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_IMPROVEMENT_POINTS`          | TEXT   | Source column: Footnote Specific Care Issues: HHA Improvement Points          |
| `OVERALL_RATING_HHA_IMPROVEMENT_POINTS`                         | NUMBER | Source column: Overall Rating: HHA Improvement Points                         |
| `FOOTNOTE_OVERALL_RATING_HHA_IMPROVEMENT_POINTS`                | TEXT   | Source column: Footnote Overall Rating: HHA Improvement Points                |
| `WILLINGNESS_TO_RECOMMEND_HHA_IMPROVEMENT_POINTS`               | NUMBER | Source column: Willingness to Recommend: HHA Improvement Points               |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_IMPROVEMENT_POINTS`      | TEXT   | Source column: Footnote Willingness to Recommend: HHA Improvement Points      |
| `DISCHARGED_TO_COMMUNITY_HHA_CARE_POINTS`                       | NUMBER | Source column: Discharged to Community: HHA Care Points                       |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_CARE_POINTS`              | TEXT   | Source column: Footnote Discharged to Community: HHA Care Points              |
| `DYSPNEA_HHA_CARE_POINTS`                                       | NUMBER | Source column: Dyspnea: HHA Care Points                                       |
| `FOOTNOTE_DYSPNEA_HHA_CARE_POINTS`                              | TEXT   | Source column: Footnote Dyspnea: HHA Care Points                              |
| `ORAL_MEDICATIONS_HHA_CARE_POINTS`                              | NUMBER | Source column: Oral Medications: HHA Care Points                              |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_CARE_POINTS`                     | TEXT   | Source column: Footnote Oral Medications: HHA Care Points                     |
| `TNC_MOBILITY_HHA_CARE_POINTS`                                  | NUMBER | Source column: TNC Mobility: HHA Care Points                                  |
| `FOOTNOTE_TNC_MOBILITY_HHA_CARE_POINTS`                         | TEXT   | Source column: Footnote TNC Mobility: HHA Care Points                         |
| `TNC_SELF_CARE_HHA_CARE_POINTS`                                 | NUMBER | Source column: TNC Self-Care: HHA Care Points                                 |
| `FOOTNOTE_TNC_SELF_CARE_HHA_CARE_POINTS`                        | TEXT   | Source column: Footnote TNC Self-Care: HHA Care Points                        |
| `ACH_HHA_CARE_POINTS`                                           | NUMBER | Source column: ACH: HHA Care Points                                           |
| `FOOTNOTE_ACH_HHA_CARE_POINTS`                                  | TEXT   | Source column: Footnote ACH: HHA Care Points                                  |
| `ED_USE_HHA_CARE_POINTS`                                        | NUMBER | Source column: ED Use: HHA Care Points                                        |
| `FOOTNOTE_ED_USE_HHA_CARE_POINTS`                               | TEXT   | Source column: Footnote ED Use: HHA Care Points                               |
| `CARE_OF_PATIENTS_HHA_CARE_POINTS`                              | NUMBER | Source column: Care of Patients: HHA Care Points                              |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_CARE_POINTS`                     | TEXT   | Source column: Footnote Care of Patients: HHA Care Points                     |
| `COMMUNICATION_HHA_CARE_POINTS`                                 | NUMBER | Source column: Communication: HHA Care Points                                 |
| `FOOTNOTE_COMMUNICATION_HHA_CARE_POINTS`                        | TEXT   | Source column: Footnote Communication: HHA Care Points                        |
| `SPECIFIC_CARE_ISSUES_HHA_CARE_POINTS`                          | NUMBER | Source column: Specific Care Issues: HHA Care Points                          |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_CARE_POINTS`                 | TEXT   | Source column: Footnote Specific Care Issues: HHA Care Points                 |
| `OVERALL_RATING_HHA_CARE_POINTS`                                | NUMBER | Source column: Overall Rating: HHA Care Points                                |
| `FOOTNOTE_OVERALL_RATING_HHA_CARE_POINTS`                       | TEXT   | Source column: Footnote Overall Rating: HHA Care Points                       |
| `WILLINGNESS_TO_RECOMMEND_HHA_CARE_POINTS`                      | NUMBER | Source column: Willingness to Recommend: HHA Care Points                      |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_CARE_POINTS`             | TEXT   | Source column: Footnote Willingness to Recommend: HHA Care Points             |
| `DISCHARGED_TO_COMMUNITY_INCLUDED_IN_TPS`                       | TEXT   | Source column: Discharged to Community: Included in TPS                       |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_INCLUDED_IN_TPS`              | TEXT   | Source column: Footnote Discharged to Community: Included in TPS              |
| `DYSPNEA_INCLUDED_IN_TPS`                                       | TEXT   | Source column: Dyspnea: Included in TPS                                       |
| `FOOTNOTE_DYSPNEA_INCLUDED_IN_TPS`                              | TEXT   | Source column: Footnote Dyspnea: Included in TPS                              |
| `ORAL_MEDICATIONS_INCLUDED_IN_TPS`                              | TEXT   | Source column: Oral Medications: Included in TPS                              |
| `FOOTNOTE_ORAL_MEDICATIONS_INCLUDED_IN_TPS`                     | TEXT   | Source column: Footnote Oral Medications: Included in TPS                     |
| `TNC_MOBILITY_INCLUDED_IN_TPS`                                  | TEXT   | Source column: TNC Mobility: Included in TPS                                  |
| `FOOTNOTE_TNC_MOBILITY_INCLUDED_IN_TPS`                         | TEXT   | Source column: Footnote TNC Mobility: Included in TPS                         |
| `TNC_SELF_CARE_INCLUDED_IN_TPS`                                 | TEXT   | Source column: TNC Self-Care: Included in TPS                                 |
| `FOOTNOTE_TNC_SELF_CARE_INCLUDED_IN_TPS`                        | TEXT   | Source column: Footnote TNC Self-Care: Included in TPS                        |
| `ACH_INCLUDED_IN_TPS`                                           | TEXT   | Source column: ACH: Included in TPS                                           |
| `FOOTNOTE_ACH_INCLUDED_IN_TPS`                                  | TEXT   | Source column: Footnote ACH: Included in TPS                                  |
| `ED_USE_INCLUDED_IN_TPS`                                        | TEXT   | Source column: ED Use: Included in TPS                                        |
| `FOOTNOTE_ED_USE_INCLUDED_IN_TPS`                               | TEXT   | Source column: Footnote ED Use: Included in TPS                               |
| `CARE_OF_PATIENTS_INCLUDED_IN_TPS`                              | TEXT   | Source column: Care of Patients: Included in TPS                              |
| `FOOTNOTE_CARE_OF_PATIENTS_INCLUDED_IN_TPS`                     | TEXT   | Source column: Footnote Care of Patients: Included in TPS                     |
| `COMMUNICATION_INCLUDED_IN_TPS`                                 | TEXT   | Source column: Communication: Included in TPS                                 |
| `FOOTNOTE_COMMUNICATION_INCLUDED_IN_TPS`                        | TEXT   | Source column: Footnote Communication: Included in TPS                        |
| `SPECIFIC_CARE_ISSUES_INCLUDED_IN_TPS`                          | TEXT   | Source column: Specific Care Issues: Included in TPS                          |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_INCLUDED_IN_TPS`                 | TEXT   | Source column: Footnote Specific Care Issues: Included in TPS                 |
| `OVERALL_RATING_INCLUDED_IN_TPS`                                | TEXT   | Source column: Overall Rating: Included in TPS                                |
| `FOOTNOTE_OVERALL_RATING_INCLUDED_IN_TPS`                       | TEXT   | Source column: Footnote Overall Rating: Included in TPS                       |
| `WILLINGNESS_TO_RECOMMEND_INCLUDED_IN_TPS`                      | TEXT   | Source column: Willingness to Recommend: Included in TPS                      |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_INCLUDED_IN_TPS`             | TEXT   | Source column: Footnote Willingness to Recommend: Included in TPS             |
| `DISCHARGED_TO_COMMUNITY_MEASURE_WEIGHT`                        | NUMBER | Source column: Discharged to Community: Measure Weight                        |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_MEASURE_WEIGHT`               | TEXT   | Source column: Footnote Discharged to Community: Measure Weight               |
| `DYSPNEA_MEASURE_WEIGHT`                                        | NUMBER | Source column: Dyspnea: Measure Weight                                        |
| `FOOTNOTE_DYSPNEA_MEASURE_WEIGHT`                               | TEXT   | Source column: Footnote Dyspnea: Measure Weight                               |
| `ORAL_MEDICATIONS_MEASURE_WEIGHT`                               | NUMBER | Source column: Oral Medications: Measure Weight                               |
| `FOOTNOTE_ORAL_MEDICATIONS_MEASURE_WEIGHT`                      | TEXT   | Source column: Footnote Oral Medications: Measure Weight                      |
| `TNC_MOBILITY_MEASURE_WEIGHT`                                   | NUMBER | Source column: TNC Mobility: Measure Weight                                   |
| `FOOTNOTE_TNC_MOBILITY_MEASURE_WEIGHT`                          | TEXT   | Source column: Footnote TNC Mobility: Measure Weight                          |
| `TNC_SELF_CARE_MEASURE_WEIGHT`                                  | NUMBER | Source column: TNC Self-Care: Measure Weight                                  |
| `FOOTNOTE_TNC_SELF_CARE_MEASURE_WEIGHT`                         | TEXT   | Source column: Footnote TNC Self-Care: Measure Weight                         |
| `ACH_MEASURE_WEIGHT`                                            | NUMBER | Source column: ACH: Measure Weight                                            |
| `FOOTNOTE_ACH_MEASURE_WEIGHT`                                   | TEXT   | Source column: Footnote ACH: Measure Weight                                   |
| `ED_USE_MEASURE_WEIGHT`                                         | NUMBER | Source column: ED Use: Measure Weight                                         |
| `FOOTNOTE_ED_USE_MEASURE_WEIGHT`                                | TEXT   | Source column: Footnote ED Use: Measure Weight                                |
| `CARE_OF_PATIENTS_MEASURE_WEIGHT`                               | NUMBER | Source column: Care of Patients: Measure Weight                               |
| `FOOTNOTE_CARE_OF_PATIENTS_MEASURE_WEIGHT`                      | TEXT   | Source column: Footnote Care of Patients: Measure Weight                      |
| `COMMUNICATION_MEASURE_WEIGHT`                                  | NUMBER | Source column: Communication: Measure Weight                                  |
| `FOOTNOTE_COMMUNICATION_MEASURE_WEIGHT`                         | TEXT   | Source column: Footnote Communication: Measure Weight                         |
| `SPECIFIC_CARE_ISSUES_MEASURE_WEIGHT`                           | NUMBER | Source column: Specific Care Issues: Measure Weight                           |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_MEASURE_WEIGHT`                  | TEXT   | Source column: Footnote Specific Care Issues: Measure Weight                  |
| `OVERALL_RATING_MEASURE_WEIGHT`                                 | NUMBER | Source column: Overall Rating: Measure Weight                                 |
| `FOOTNOTE_OVERALL_RATING_MEASURE_WEIGHT`                        | TEXT   | Source column: Footnote Overall Rating: Measure Weight                        |
| `WILLINGNESS_TO_RECOMMEND_MEASURE_WEIGHT`                       | NUMBER | Source column: Willingness to Recommend: Measure Weight                       |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_MEASURE_WEIGHT`              | TEXT   | Source column: Footnote Willingness to Recommend: Measure Weight              |
| `DISCHARGED_TO_COMMUNITY_HHA_WEIGHTED_MEASURE_POINTS`           | NUMBER | Source column: Discharged to Community: HHA Weighted Measure Points           |
| `FOOTNOTE_DISCHARGED_TO_COMMUNITY_HHA_WEIGHTED_MEASURE_POINTS`  | TEXT   | Source column: Footnote Discharged to Community: HHA Weighted Measure Points  |
| `DYSPNEA_HHA_WEIGHTED_MEASURE_POINTS`                           | NUMBER | Source column: Dyspnea: HHA Weighted Measure Points                           |
| `FOOTNOTE_DYSPNEA_HHA_WEIGHTED_MEASURE_POINTS`                  | TEXT   | Source column: Footnote Dyspnea: HHA Weighted Measure Points                  |
| `ORAL_MEDICATIONS_HHA_WEIGHTED_MEASURE_POINTS`                  | NUMBER | Source column: Oral Medications: HHA Weighted Measure Points                  |
| `FOOTNOTE_ORAL_MEDICATIONS_HHA_WEIGHTED_MEASURE_POINTS`         | TEXT   | Source column: Footnote Oral Medications: HHA Weighted Measure Points         |
| `TNC_MOBILITY_HHA_WEIGHTED_MEASURE_POINTS`                      | NUMBER | Source column: TNC Mobility: HHA Weighted Measure Points                      |
| `FOOTNOTE_TNC_MOBILITY_HHA_WEIGHTED_MEASURE_POINTS`             | TEXT   | Source column: Footnote TNC Mobility: HHA Weighted Measure Points             |
| `TNC_SELF_CARE_HHA_WEIGHTED_MEASURE_POINTS`                     | NUMBER | Source column: TNC Self-Care: HHA Weighted Measure Points                     |
| `FOOTNOTE_TNC_SELF_CARE_HHA_WEIGHTED_MEASURE_POINTS`            | TEXT   | Source column: Footnote TNC Self-Care: HHA Weighted Measure Points            |
| `ACH_HHA_WEIGHTED_MEASURE_POINTS`                               | NUMBER | Source column: ACH: HHA Weighted Measure Points                               |
| `FOOTNOTE_ACH_HHA_WEIGHTED_MEASURE_POINTS`                      | TEXT   | Source column: Footnote ACH: HHA Weighted Measure Points                      |
| `ED_USE_HHA_WEIGHTED_MEASURE_POINTS`                            | NUMBER | Source column: ED Use: HHA Weighted Measure Points                            |
| `FOOTNOTE_ED_USE_HHA_WEIGHTED_MEASURE_POINTS`                   | TEXT   | Source column: Footnote ED Use: HHA Weighted Measure Points                   |
| `CARE_OF_PATIENTS_HHA_WEIGHTED_MEASURE_POINTS`                  | NUMBER | Source column: Care of Patients: HHA Weighted Measure Points                  |
| `FOOTNOTE_CARE_OF_PATIENTS_HHA_WEIGHTED_MEASURE_POINTS`         | TEXT   | Source column: Footnote Care of Patients: HHA Weighted Measure Points         |
| `COMMUNICATION_HHA_WEIGHTED_MEASURE_POINTS`                     | NUMBER | Source column: Communication: HHA Weighted Measure Points                     |
| `FOOTNOTE_COMMUNICATION_HHA_WEIGHTED_MEASURE_POINTS`            | TEXT   | Source column: Footnote Communication: HHA Weighted Measure Points            |
| `SPECIFIC_CARE_ISSUES_HHA_WEIGHTED_MEASURE_POINTS`              | NUMBER | Source column: Specific Care Issues: HHA Weighted Measure Points              |
| `FOOTNOTE_SPECIFIC_CARE_ISSUES_HHA_WEIGHTED_MEASURE_POINTS`     | TEXT   | Source column: Footnote Specific Care Issues: HHA Weighted Measure Points     |
| `OVERALL_RATING_HHA_WEIGHTED_MEASURE_POINTS`                    | NUMBER | Source column: Overall Rating: HHA Weighted Measure Points                    |
| `FOOTNOTE_OVERALL_RATING_HHA_WEIGHTED_MEASURE_POINTS`           | TEXT   | Source column: Footnote Overall Rating: HHA Weighted Measure Points           |
| `WILLINGNESS_TO_RECOMMEND_HHA_WEIGHTED_MEASURE_POINTS`          | NUMBER | Source column: Willingness to Recommend: HHA Weighted Measure Points          |
| `FOOTNOTE_WILLINGNESS_TO_RECOMMEND_HHA_WEIGHTED_MEASURE_POINTS` | TEXT   | Source column: Footnote Willingness to Recommend: HHA Weighted Measure Points |
| `TOTAL_PERFORMANCE_SCORE_TPS`                                   | NUMBER | Source column: Total Performance Score (TPS)                                  |
| `FOOTNOTE_TOTAL_PERFORMANCE_SCORE_TPS`                          | TEXT   | Source column: Footnote Total Performance Score (TPS)                         |
| `PAYMENT_YEAR`                                                  | NUMBER | Source column: Payment Year                                                   |
| `FOOTNOTE_PAYMENT_YEAR`                                         | TEXT   | Source column: Footnote Payment Year                                          |
| `ADJUSTED_PAYMENT_PERCENTAGE_APP`                               | NUMBER | Source column: Adjusted Payment Percentage (APP)                              |
| `FOOTNOTE_ADJUSTED_PAYMENT_PERCENTAGE_APP`                      | TEXT   | Source column: Footnote Adjusted Payment Percentage (APP)                     |

**Lineage columns** (present on every feed table)

| Column         | Type           | Description                                 |
| -------------- | -------------- | ------------------------------------------- |
| `ROW_ID`       | TEXT           | Unique row ID for this table (PK)           |
| `FILE_ID`      | TEXT           | Source file; joins to `FEEDS_FILES.ID` (FK) |
| `FILE_FEED_ID` | TEXT           | Parent feed; joins to `FEEDS.ID` (FK)       |
| `FILE_NAME`    | TEXT           | Source file name as published by CMS        |
| `ROWNUM`       | NUMBER         | Row number within the source file           |
| `CREATED_AT`   | TIMESTAMP\_NTZ | Timestamp when the record was loaded        |

</details>

## Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The `FILE_ID` column joins to the `FEEDS_FILES` catalog table, and `FILE_FEED_ID` joins to the `FEEDS` master table:

```mermaid
erDiagram
    FEEDS ||--o{ FEEDS_FILES : "ID = FEED_ID"
    FEEDS ||--o{ EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN : "ID = FILE_FEED_ID"
    FEEDS_FILES ||--o{ EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN : "ID = FILE_ID"

    FEEDS {
        text ID PK
        text TITLE
        text VIEW_NAME
        text ACCURAL_PERIODICITY
    }
    FEEDS_FILES {
        text ID PK
        text FEED_ID FK
        date TEMPORAL_START
        date TEMPORAL_END
        date CMS_FEED_MODIFIED
        number IS_LATEST
    }
    EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN {
        text ROW_ID PK
        text FILE_ID FK
        text FILE_FEED_ID FK
        text DATA_PERIOD
        text CMS_CERTIFICATION_NUMBER_CCN
        text STATE
        text PROVIDER_NAME
        number remaining_249_data_columns
    }
```

Trace any row back to its source file and reporting period:

{% tabs %}
{% tab title="Snowflake" %}

```sql
SELECT d.DATA_PERIOD, d.CMS_CERTIFICATION_NUMBER_CCN, d.STATE,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;
```

{% endtab %}

{% tab title="Databricks" %}

```sql
SELECT d.data_period, d.cms_certification_number_ccn, d.state,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.expanded_home_health_value_based_purchasing_hhvbp_model_agen d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id;
```

{% endtab %}
{% endtabs %}

## Source & provenance

Published by the **Centers for Medicare & Medicaid Services** (bureau 009:38).

* [Official CMS documentation](https://data.cms.gov/provider-data/sites/default/files/data_dictionaries/home_health/HHS_Data_Dictionary.pdf)
* [56d7 4994](https://data.cms.gov/provider-data/dataset/56d7-4994)

## Frequently asked questions

### How often is Expanded Home Health Value-Based Purchasing (HHVBP) Model - Agency Data updated?

Annually. CMS last published this feed on 2025-12-01, and Dataplex loaded it to the warehouse on 2026-09-28. New releases are added automatically when CMS publishes them.

### What years does Expanded Home Health Value-Based Purchasing (HHVBP) Model - Agency Data cover?

2025 through 2025.

### How many records are in Expanded Home Health Value-Based Purchasing (HHVBP) Model - Agency Data?

Count the current snapshot yourself once the share is mounted:

{% tabs %}
{% tab title="Snowflake" %}

```sql
SELECT COUNT(*)
FROM DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;
```

{% endtab %}

{% tab title="Databricks" %}

```sql
SELECT COUNT(*)
FROM cms_dwv.expanded_home_health_value_based_purchasing_hhvbp_model_agen d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id
WHERE ff.is_latest = 1;
```

{% endtab %}
{% endtabs %}

### How do I get Expanded Home Health Value-Based Purchasing (HHVBP) Model - Agency Data data?

It's included in the CMS Data Feeds Dataset on the [Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) (free trial available) and via [Databricks Delta Sharing](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00). Once mounted, query `DWV.EXPANDED_HOME_HEALTH_VALUE_BASED_PURCHASING_HHVBP_MODEL_AGEN` directly; no pipeline setup required.

## Related feeds

{% content-ref url="/pages/zMHRQgOC22JmN3FJoe80" %}
[Expanded Home Health Value-Based Purchasing (HHVBP) Model - Cohort Data](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/expanded-home-health-value-based-purchasing-hhvbp-model-cohort-data.md)
{% endcontent-ref %}

{% content-ref url="/pages/O1Hcf6hXrSOgNXb6jC8t" %}
[Home Health Care Agencies](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/home-health-care-agencies.md)
{% endcontent-ref %}

{% content-ref url="/pages/3mQaYtsNjEf56QH9Uj0M" %}
[Home Health Care - Zip Codes](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/home-health-care-zip-codes.md)
{% endcontent-ref %}

{% content-ref url="/pages/iE58w911vCca5O1SHdad" %}
[Nursing Homes Including Rehab Services - Provider Information](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-provider-information.md)
{% endcontent-ref %}

{% content-ref url="/pages/tU6uuheRUajExC8lzQbp" %}
[Hospice - Provider Data](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/hospice-provider-data.md)
{% endcontent-ref %}

## Get this feed

1. [Start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) or purchase via [Databricks](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00)
2. Mount the share; the database and `DWV` schema appear in your account immediately
3. Run the [sample query](#sample-queries) above; no ETL, no pipeline maintenance

Questions about this feed? Contact us at <notifications@dataplex-consulting.com>.

***

Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset.md); 280+ feeds · 245B+ records · updated daily. [Back to the full catalog →](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md#expanded-home-health-value-based-purchasing-hhvbp-model-agency-data)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/expanded-home-health-value-based-purchasing-hhvbp-model-agency-data.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.