Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Benefits Data - B19A Inpatient Hospital Acute (VBID/UF)

Inpatient Hospital Acute VBID and UF reduced cost data for B19A packages.

Part of the CMS Data Research Dataset › Plan Benefits

Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__B19A_B1A_INPAT_HOSP on Snowflake and Databricks: coverage from 2020 to 2027 in a single aligned 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.BENEFITS_DATA__B19A_B1A_INPAT_HOSP

Databricks

cms_research_dwv.benefits_data__b19a_b1a_inpat_hosp

Coverage

Apr 2020 – Jan 2027

Rows

685 (total across all reporting periods)

Update pattern

Time-partitioned; each file adds one reporting period

Latest report period

2027-01-01

Loaded

2026-10-04

Columns

302 data + 5 lineage

Identifiers

Contract ID (H-number) · Plan ID

File versions

16

License

CMS public data (U.S. Government work)

Platforms

Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Research Dataset, start a free trial on Snowflake Marketplace.

Partitioned by report period: each file version covers one report period and history is additive. The sample query below returns the latest report period; drop the WHERE clause to query the full history.

Join to the package header. Rows are keyed on BID_ID + PBP_VBID_GROUP_ID, at most one per package, within one release. Match records from the same release on FEEDS_FILES.FILE_REPORT_PERIOD (each source file has its own FILE_ID, so never join two views on FILE_ID). Filtering on CONTRACT_YEAR alone also works for a year with a single release; contract years with quarterly revisions carry several.

Sample queries

About this feed

Inpatient Hospital Acute VBID and UF reduced cost data for B19A packages. Source file pbp_b1a_b19a_inpat_hosp_vbid_uf.txt, one row per package (BID_ID, PBP_VBID_GROUP_ID) per release; CMS column names and raw codes unchanged.

Source: CMS feed metadata

Theme: Plan Benefits

Coverage timeline

2020–2027 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

8 of 8 years covered, no gaps.

Release history

Report period
Files
Loaded
Latest
CMS source

2027-01-01

1

2026-10-04

✓

2026-01-01

1

2026-10-04

2025-01-01

1

2026-10-04

2024-10-01

1

2026-10-04

2024-07-01

1

2026-10-04

2024-01-01

1

2026-10-04

2023-10-01

1

2026-10-04

2023-07-01

1

2026-10-04

2023-04-01

1

2026-10-04

2022-04-01

1

2026-10-04

Show 6 earlier report periods
Report period
Files
Loaded
Latest
CMS source

2022-01-01

1

2026-10-04

2021-04-01

1

2026-10-04

2021-02-01

1

2026-10-04

2021-01-01

1

2026-10-04

2020-10-01

1

2026-10-04

2020-04-01

1

2026-10-04

Data dictionary

📋 302 data columns + 5 lineage columns

Data columns

Column
Type

PBP_A_HNUMBER

TEXT

PBP_A_PLAN_IDENTIFIER

TEXT

SEGMENT_ID

TEXT

PBP_A_BEN_COV

TEXT

PBP_A_PLAN_TYPE

TEXT

ORGTYPE

TEXT

BID_ID

TEXT

VERSION

TEXT

PBP_VBID_GROUP_ID

TEXT

PBP_B1A_BENDESC_YN

TEXT

PBP_B1A_BENDESC_AD_UP_NMCS

TEXT

PBP_B1A_BENDESC_AMO_AD

TEXT

PBP_B1A_BENDESC_LIM_AD

TEXT

PBP_B1A_BENDESC_AMT_AD

TEXT

PBP_B1A_BENDESC_AMO_NMCS

TEXT

PBP_B1A_BENDESC_AMO_UP

TEXT

PBP_B1A_MAXENR_YN

TEXT

PBP_B1A_MAXENR_AMT

TEXT

PBP_B1A_MAXENR_PER

TEXT

PBP_B1A_MAXENR_PER_D

TEXT

PBP_B1A_COST_VARY_TIERS_YN

TEXT

PBP_B1A_COST_VARY_TIER_NUM

TEXT

PBP_B1A_COST_VARY_LOW_TIER

TEXT

PBP_B1A_COINS_YN

TEXT

PBP_B1A_MC_COINS_CSTSHR_YN_T1

TEXT

PBP_B1A_COINS_MCS_PCT_T1

TEXT

PBP_B1A_COINS_MCS_INT_NUM_T1

TEXT

PBP_B1A_COINS_MCS_PCT_INT1_T1

TEXT

PBP_B1A_COINS_MCS_BGND_INT1_T1

TEXT

PBP_B1A_COINS_MCS_ENDD_INT1_T1

TEXT

PBP_B1A_COINS_MCS_PCT_INT2_T1

TEXT

PBP_B1A_COINS_MCS_BGND_INT2_T1

TEXT

PBP_B1A_COINS_MCS_ENDD_INT2_T1

TEXT

PBP_B1A_COINS_MCS_PCT_INT3_T1

TEXT

PBP_B1A_COINS_MCS_BGND_INT3_T1

TEXT

PBP_B1A_COINS_MCS_ENDD_INT3_T1

TEXT

PBP_B1A_MC_COINS_CSTSHR_YN_T2

TEXT

PBP_B1A_COINS_MCS_PCT_T2

TEXT

PBP_B1A_COINS_MCS_INT_NUM_T2

TEXT

PBP_B1A_COINS_MCS_PCT_INT1_T2

TEXT

PBP_B1A_COINS_MCS_BGND_INT1_T2

TEXT

PBP_B1A_COINS_MCS_ENDD_INT1_T2

TEXT

PBP_B1A_COINS_MCS_PCT_INT2_T2

TEXT

PBP_B1A_COINS_MCS_BGND_INT2_T2

TEXT

PBP_B1A_COINS_MCS_ENDD_INT2_T2

TEXT

PBP_B1A_COINS_MCS_PCT_INT3_T2

TEXT

PBP_B1A_COINS_MCS_BGND_INT3_T2

TEXT

PBP_B1A_COINS_MCS_ENDD_INT3_T2

TEXT

PBP_B1A_MC_COINS_CSTSHR_YN_T3

TEXT

PBP_B1A_COINS_MCS_PCT_T3

TEXT

PBP_B1A_COINS_MCS_INT_NUM_T3

TEXT

PBP_B1A_COINS_MCS_PCT_INT1_T3

TEXT

PBP_B1A_COINS_MCS_BGND_INT1_T3

TEXT

PBP_B1A_COINS_MCS_ENDD_INT1_T3

TEXT

PBP_B1A_COINS_MCS_PCT_INT2_T3

TEXT

PBP_B1A_COINS_MCS_BGND_INT2_T3

TEXT

PBP_B1A_COINS_MCS_ENDD_INT2_T3

TEXT

PBP_B1A_COINS_MCS_PCT_INT3_T3

TEXT

PBP_B1A_COINS_MCS_BGND_INT3_T3

TEXT

PBP_B1A_COINS_MCS_ENDD_INT3_T3

TEXT

PBP_B1A_COINS_LRD_INT_NUM_T1

TEXT

PBP_B1A_COINS_LRD_PCT_INT1_T1

TEXT

PBP_B1A_COINS_LRD_BGND_INT1_T1

TEXT

PBP_B1A_COINS_LRD_ENDD_INT1_T1

TEXT

PBP_B1A_COINS_LRD_PCT_INT2_T1

TEXT

PBP_B1A_COINS_LRD_BGND_INT2_T1

TEXT

PBP_B1A_COINS_LRD_ENDD_INT2_T1

TEXT

PBP_B1A_COINS_LRD_PCT_INT3_T1

TEXT

PBP_B1A_COINS_LRD_BGND_INT3_T1

TEXT

PBP_B1A_COINS_LRD_ENDD_INT3_T1

TEXT

PBP_B1A_COINS_LRD_INT_NUM_T2

TEXT

PBP_B1A_COINS_LRD_PCT_INT1_T2

TEXT

PBP_B1A_COINS_LRD_BGND_INT1_T2

TEXT

PBP_B1A_COINS_LRD_ENDD_INT1_T2

TEXT

PBP_B1A_COINS_LRD_PCT_INT2_T2

TEXT

PBP_B1A_COINS_LRD_BGND_INT2_T2

TEXT

PBP_B1A_COINS_LRD_ENDD_INT2_T2

TEXT

PBP_B1A_COINS_LRD_PCT_INT3_T2

TEXT

PBP_B1A_COINS_LRD_BGND_INT3_T2

TEXT

PBP_B1A_COINS_LRD_ENDD_INT3_T2

TEXT

PBP_B1A_COINS_LRD_INT_NUM_T3

TEXT

PBP_B1A_COINS_LRD_PCT_INT1_T3

TEXT

PBP_B1A_COINS_LRD_BGND_INT1_T3

TEXT

PBP_B1A_COINS_LRD_ENDD_INT1_T3

TEXT

PBP_B1A_COINS_LRD_PCT_INT2_T3

TEXT

PBP_B1A_COINS_LRD_BGND_INT2_T3

TEXT

PBP_B1A_COINS_LRD_ENDD_INT2_T3

TEXT

PBP_B1A_COINS_LRD_PCT_INT3_T3

TEXT

PBP_B1A_COINS_LRD_BGND_INT3_T3

TEXT

PBP_B1A_COINS_LRD_ENDD_INT3_T3

TEXT

PBP_B1A_AD_COST_VARY_TIERS_YN

TEXT

PBP_B1A_AD_COST_VARY_TIER_NUM

TEXT

PBP_B1A_AD_COST_VARY_LOW_TIER

TEXT

PBP_B1A_COINS_AD_INTRVL_NUM_T1

TEXT

PBP_B1A_COINS_AD_PCT_INT1_T1

TEXT

PBP_B1A_COINS_AD_BGND_INT1_T1

TEXT

PBP_B1A_COINS_AD_ENDD_INT1_T1

TEXT

PBP_B1A_COINS_AD_PCT_INT2_T1

TEXT

PBP_B1A_COINS_AD_BGND_INT2_T1

TEXT

PBP_B1A_COINS_AD_ENDD_INT2_T1

TEXT

PBP_B1A_COINS_AD_PCT_INT3_T1

TEXT

PBP_B1A_COINS_AD_BGND_INT3_T1

TEXT

PBP_B1A_COINS_AD_ENDD_INT3_T1

TEXT

PBP_B1A_COINS_AD_INTRVL_NUM_T2

TEXT

PBP_B1A_COINS_AD_PCT_INT1_T2

TEXT

PBP_B1A_COINS_AD_BGND_INT1_T2

TEXT

PBP_B1A_COINS_AD_ENDD_INT1_T2

TEXT

PBP_B1A_COINS_AD_PCT_INT2_T2

TEXT

PBP_B1A_COINS_AD_BGND_INT2_T2

TEXT

PBP_B1A_COINS_AD_ENDD_INT2_T2

TEXT

PBP_B1A_COINS_AD_PCT_INT3_T2

TEXT

PBP_B1A_COINS_AD_BGND_INT3_T2

TEXT

PBP_B1A_COINS_AD_ENDD_INT3_T2

TEXT

PBP_B1A_COINS_AD_INTRVL_NUM_T3

TEXT

PBP_B1A_COINS_AD_PCT_INT1_T3

TEXT

PBP_B1A_COINS_AD_BGND_INT1_T3

TEXT

PBP_B1A_COINS_AD_ENDD_INT1_T3

TEXT

PBP_B1A_COINS_AD_PCT_INT2_T3

TEXT

PBP_B1A_COINS_AD_BGND_INT2_T3

TEXT

PBP_B1A_COINS_AD_ENDD_INT2_T3

TEXT

PBP_B1A_COINS_AD_PCT_INT3_T3

TEXT

PBP_B1A_COINS_AD_BGND_INT3_T3

TEXT

PBP_B1A_COINS_AD_ENDD_INT3_T3

TEXT

PBP_B1A_COINS_NMCS_STRUC_YN

TEXT

PBP_B1A_COINS_NMCS_PCT

TEXT

PBP_B1A_COINS_NMCS_INTRVL_NUM

TEXT

PBP_B1A_COINS_NMCS_PCT_INTRVL1

TEXT

PBP_B1A_COINS_NMCS_BGND_NTRVL1

TEXT

PBP_B1A_COINS_NMCS_ENDD_NTRVL1

TEXT

PBP_B1A_COINS_NMCS_PCT_INTRVL2

TEXT

PBP_B1A_COINS_NMCS_BGND_NTRVL2

TEXT

PBP_B1A_COINS_NMCS_ENDD_NTRVL2

TEXT

PBP_B1A_COINS_NMCS_PCT_INTRVL3

TEXT

PBP_B1A_COINS_NMCS_BGND_NTRVL3

TEXT

PBP_B1A_COINS_NMCS_ENDD_NTRVL3

TEXT

PBP_B1A_COINS_UP_CSTSHR_YN

TEXT

PBP_B1A_COINS_PCT_UP

TEXT

PBP_B1A_DED_YN

TEXT

PBP_B1A_DED_AMT_T1

TEXT

PBP_B1A_DED_AMT_T2

TEXT

PBP_B1A_DED_AMT_T3

TEXT

PBP_B1A_COPAY_YN

TEXT

PBP_B1A_MC_COPAY_CSTSHR_YN_T1

TEXT

PBP_B1A_COPAY_MCS_AMT_T1

TEXT

PBP_B1A_COPAY_MCS_INT_NUM_T1

TEXT

PBP_B1A_COPAY_MCS_AMT_INT1_T1

TEXT

PBP_B1A_COPAY_MCS_BGND_INT1_T1

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT1_T1

TEXT

PBP_B1A_COPAY_MCS_AMT_INT2_T1

TEXT

PBP_B1A_COPAY_MCS_BGND_INT2_T1

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT2_T1

TEXT

PBP_B1A_COPAY_MCS_AMT_INT3_T1

TEXT

PBP_B1A_COPAY_MCS_BGND_INT3_T1

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT3_T1

TEXT

PBP_B1A_MC_COPAY_CSTSHR_YN_T2

TEXT

PBP_B1A_COPAY_MCS_AMT_T2

TEXT

PBP_B1A_COPAY_MCS_INT_NUM_T2

TEXT

PBP_B1A_COPAY_MCS_AMT_INT1_T2

TEXT

PBP_B1A_COPAY_MCS_BGND_INT1_T2

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT1_T2

TEXT

PBP_B1A_COPAY_MCS_AMT_INT2_T2

TEXT

PBP_B1A_COPAY_MCS_BGND_INT2_T2

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT2_T2

TEXT

PBP_B1A_COPAY_MCS_AMT_INT3_T2

TEXT

PBP_B1A_COPAY_MCS_BGND_INT3_T2

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT3_T2

TEXT

PBP_B1A_MC_COPAY_CSTSHR_YN_T3

TEXT

PBP_B1A_COPAY_MCS_AMT_T3

TEXT

PBP_B1A_COPAY_MCS_INT_NUM_T3

TEXT

PBP_B1A_COPAY_MCS_AMT_INT1_T3

TEXT

PBP_B1A_COPAY_MCS_BGND_INT1_T3

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT1_T3

TEXT

PBP_B1A_COPAY_MCS_AMT_INT2_T3

TEXT

PBP_B1A_COPAY_MCS_BGND_INT2_T3

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT2_T3

TEXT

PBP_B1A_COPAY_MCS_AMT_INT3_T3

TEXT

PBP_B1A_COPAY_MCS_BGND_INT3_T3

TEXT

PBP_B1A_COPAY_MCS_ENDD_INT3_T3

TEXT

PBP_B1A_COPAY_LRD_INT_NUM_T1

TEXT

PBP_B1A_COPAY_LRD_AMT_INT1_T1

TEXT

PBP_B1A_COPAY_LRD_BGND_INT1_T1

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT1_T1

TEXT

PBP_B1A_COPAY_LRD_AMT_INT2_T1

TEXT

PBP_B1A_COPAY_LRD_BGND_INT2_T1

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT2_T1

TEXT

PBP_B1A_COPAY_LRD_AMT_INT3_T1

TEXT

PBP_B1A_COPAY_LRD_BGND_INT3_T1

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT3_T1

TEXT

PBP_B1A_COPAY_LRD_INT_NUM_T2

TEXT

PBP_B1A_COPAY_LRD_AMT_INT1_T2

TEXT

PBP_B1A_COPAY_LRD_BGND_INT1_T2

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT1_T2

TEXT

PBP_B1A_COPAY_LRD_AMT_INT2_T2

TEXT

PBP_B1A_COPAY_LRD_BGND_INT2_T2

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT2_T2

TEXT

PBP_B1A_COPAY_LRD_AMT_INT3_T2

TEXT

PBP_B1A_COPAY_LRD_BGND_INT3_T2

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT3_T2

TEXT

PBP_B1A_COPAY_LRD_INT_NUM_T3

TEXT

PBP_B1A_COPAY_LRD_AMT_INT1_T3

TEXT

PBP_B1A_COPAY_LRD_BGND_INT1_T3

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT1_T3

TEXT

PBP_B1A_COPAY_LRD_AMT_INT2_T3

TEXT

PBP_B1A_COPAY_LRD_BGND_INT2_T3

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT2_T3

TEXT

PBP_B1A_COPAY_LRD_AMT_INT3_T3

TEXT

PBP_B1A_COPAY_LRD_BGND_INT3_T3

TEXT

PBP_B1A_COPAY_LRD_ENDD_INT3_T3

TEXT

PBP_B1A_COPAY_AD_INTRVL_NUM_T1

TEXT

PBP_B1A_COPAY_AD_AMT_INT1_T1

TEXT

PBP_B1A_COPAY_AD_BGND_INT1_T1

TEXT

PBP_B1A_COPAY_AD_ENDD_INT1_T1

TEXT

PBP_B1A_COPAY_AD_AMT_INT2_T1

TEXT

PBP_B1A_COPAY_AD_BGND_INT2_T1

TEXT

PBP_B1A_COPAY_AD_ENDD_INT2_T1

TEXT

PBP_B1A_COPAY_AD_AMT_INT3_T1

TEXT

PBP_B1A_COPAY_AD_BGND_INT3_T1

TEXT

PBP_B1A_COPAY_AD_ENDD_INT3_T1

TEXT

PBP_B1A_COPAY_AD_INTRVL_NUM_T2

TEXT

PBP_B1A_COPAY_AD_AMT_INT1_T2

TEXT

PBP_B1A_COPAY_AD_BGND_INT1_T2

TEXT

PBP_B1A_COPAY_AD_ENDD_INT1_T2

TEXT

PBP_B1A_COPAY_AD_AMT_INT2_T2

TEXT

PBP_B1A_COPAY_AD_BGND_INT2_T2

TEXT

PBP_B1A_COPAY_AD_ENDD_INT2_T2

TEXT

PBP_B1A_COPAY_AD_AMT_INT3_T2

TEXT

PBP_B1A_COPAY_AD_BGND_INT3_T2

TEXT

PBP_B1A_COPAY_AD_ENDD_INT3_T2

TEXT

PBP_B1A_COPAY_AD_INTRVL_NUM_T3

TEXT

PBP_B1A_COPAY_AD_AMT_INT1_T3

TEXT

PBP_B1A_COPAY_AD_BGND_INT1_T3

TEXT

PBP_B1A_COPAY_AD_ENDD_INT1_T3

TEXT

PBP_B1A_COPAY_AD_AMT_INT2_T3

TEXT

PBP_B1A_COPAY_AD_BGND_INT2_T3

TEXT

PBP_B1A_COPAY_AD_ENDD_INT2_T3

TEXT

PBP_B1A_COPAY_AD_AMT_INT3_T3

TEXT

PBP_B1A_COPAY_AD_BGND_INT3_T3

TEXT

PBP_B1A_COPAY_AD_ENDD_INT3_T3

TEXT

PBP_B1A_COPAY_NMCS_STRUC_YN

TEXT

PBP_B1A_COPAY_NMCS_AMT

TEXT

PBP_B1A_COPAY_NMCS_INTRVL_NUM

TEXT

PBP_B1A_COPAY_NMCS_AMT_INTRVL1

TEXT

PBP_B1A_COPAY_NMCS_BGND_NTRVL1

TEXT

PBP_B1A_COPAY_NMCS_ENDD_NTRVL1

TEXT

PBP_B1A_COPAY_NMCS_AMT_INTRVL2

TEXT

PBP_B1A_COPAY_NMCS_BGND_NTRVL2

TEXT

PBP_B1A_COPAY_NMCS_ENDD_NTRVL2

TEXT

PBP_B1A_COPAY_NMCS_AMT_INTRVL3

TEXT

PBP_B1A_COPAY_NMCS_BGND_NTRVL3

TEXT

PBP_B1A_COPAY_NMCS_ENDD_NTRVL3

TEXT

PBP_B1A_COPAY_UP_CSTSHR_YN

TEXT

PBP_B1A_COPAY_UP_AMT_STAY

TEXT

PBP_B1A_COPAY_UP_AMT_DAY

TEXT

PBP_B1A_HOSP_BEN_PERIOD

TEXT

PBP_B1A_HOSP_BEN_PERIOD_OTH

TEXT

PBP_B1A_COST_DISCHARGE_YN

TEXT

PBP_B1A_AUTH_YN

TEXT

PBP_B1A_REFER_YN

TEXT

PBP_B1A_BENDESC_YN_BONLY

TEXT

PBP_B1A_BENDESC_AMO_IACT_BONLY

TEXT

PBP_B1A_BENDESC_ULIM_BONLY

TEXT

PBP_B1A_BENDESC_AMT_DAYS_BONLY

TEXT

PBP_B1A_BENDESC_PER_BONLY

TEXT

PBP_B1A_BENDESC_PER_BONLY_D

TEXT

PBP_B1A_MAXPLAN_YN_BONLY

TEXT

PBP_B1A_MAXPLAN_AMT_BONLY

TEXT

PBP_B1A_MAXPLAN_PER_BONLY

TEXT

PBP_B1A_MAXPLAN_PER_BONLY_D

TEXT

PBP_B1A_MAXENR_YN_BONLY

TEXT

PBP_B1A_MAXENR_AMT_BONLY

TEXT

PBP_B1A_MAXENR_PER_BONLY

TEXT

PBP_B1A_MAXENR_PER_BONLY_D

TEXT

PBP_B1A_COINS_YN_BONLY

TEXT

PBP_B1A_COINS_PCT_BONLY

TEXT

PBP_B1A_COINS_PS_NUM_BONLY

TEXT

PBP_B1A_COINS_PS_PCT1_BONLY

TEXT

PBP_B1A_COINS_PS_BGND1_BONLY

TEXT

PBP_B1A_COINS_PS_ENDD1_BONLY

TEXT

PBP_B1A_COINS_PS_PCT2_BONLY

TEXT

PBP_B1A_COINS_PS_BGND2_BONLY

TEXT

PBP_B1A_COINS_PS_ENDD2_BONLY

TEXT

PBP_B1A_COINS_PS_PCT3_BONLY

TEXT

PBP_B1A_COINS_PS_BGND3_BONLY

TEXT

PBP_B1A_COINS_PS_ENDD3_BONLY

TEXT

PBP_B1A_DED_YN_BONLY

TEXT

PBP_B1A_DED_AMT_BONLY

TEXT

PBP_B1A_COPAY_YN_BONLY

TEXT

PBP_B1A_COPAY_AMT_PS_BONLY

TEXT

PBP_B1A_COPAY_PS_NUM_BONLY

TEXT

PBP_B1A_COPAY_PS_AMT1_BONLY

TEXT

PBP_B1A_COPAY_PS_BGND1_BONLY

TEXT

PBP_B1A_COPAY_PS_ENDD1_BONLY

TEXT

PBP_B1A_COPAY_PS_AMT2_BONLY

TEXT

PBP_B1A_COPAY_PS_BGND2_BONLY

TEXT

PBP_B1A_COPAY_PS_ENDD2_BONLY

TEXT

PBP_B1A_COPAY_PS_AMT3_BONLY

TEXT

PBP_B1A_COPAY_PS_BGND3_BONLY

TEXT

PBP_B1A_COPAY_PS_ENDD3_BONLY

TEXT

PBP_B1A_DISCHARGE_YN_BONLY

TEXT

PBP_B1A_AUTH_YN_BONLY

TEXT

PBP_B1A_REFER_YN_BONLY

TEXT

CONTRACT_YEAR

NUMBER

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

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:

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

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

Frequently asked questions

How often is Benefits Data - B19A Inpatient Hospital Acute (VBID/UF) updated?

CMS last published this feed on 2027-01-01. New releases are added automatically when CMS publishes them.

What years does Benefits Data - B19A Inpatient Hospital Acute (VBID/UF) cover?

2020 through 2027.

How many records are in Benefits Data - B19A Inpatient Hospital Acute (VBID/UF)?

685 rows across all 16 report periods. Because this feed is partitioned by report period, the full table total is the meaningful count; no deduplication needed.

How do I get Benefits Data - B19A Inpatient Hospital Acute (VBID/UF) data?

It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.BENEFITS_DATA__B19A_B1A_INPAT_HOSP directly; no pipeline setup required.

Benefits Data - B19B Inpatient Hospital Acute (VBID/UF)Benefits Data - Inpatient Hospital (Psychiatric)Benefits Data - Inpatient Hospital (Acute)Benefits Data - B19B Cardiac and Pulmonary Rehabilitation (VBID/UF)Benefits Data - Premiums & Deductibles

Get this feed

  1. Mount the share; the database and DWV schema appear in your account immediately

  2. Run the sample query above; no ETL, no pipeline maintenance

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


Part of the CMS Data Research Dataset; 48 research tables · 25 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →

Last updated