Benefits Data - Inpatient Hospital (Acute)

Medicare Advantage inpatient acute hospital stay benefit details including copays, coinsurance, deductibles, and prior authorization requirements (PBP B1A)

Part of the CMS Data Research Dataset › Plan Benefits

Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__INPATIENT_HOSPITAL_ACUTE on Snowflake — coverage from 2002 to 2026 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__INPATIENT_HOSPITAL_ACUTE
Coverage	Jan 2002 – Jan 2026
Rows	195,603 (total across all reporting periods)
Update pattern	Time-partitioned — each file adds one reporting period
Latest report period	2026-01-01
Loaded	2026-04-09
Columns	379 data + 5 lineage
Identifiers	Contract ID (H-number) · Plan ID
File versions	37 (36 report periods)
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace

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

Current — data runs through the Jan 2026 report period. Next CMS release expected ~Jan 2027.

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.

Sample queries

-- Latest report period only (drop the WHERE clause for the full history)
SELECT *
FROM DWV.BENEFITS_DATA__INPATIENT_HOSPITAL_ACUTE
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

About this feed

Medicare Advantage inpatient acute hospital stay benefit details including copays, coinsurance, deductibles, and prior authorization requirements (PBP B1A)

— Source: CMS feed metadata

Theme: Plan Benefits

Coverage timeline

2002–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

25 of 25 years covered — no gaps.

Release history

Report period	Files	Loaded	Latest	CMS source
2026-01-01	1	2026-04-09	✓	source ↗
2025-01-01	1	2026-04-09		source ↗
2024-10-01	1	2026-04-09		source ↗
2024-07-01	1	2026-04-09		source ↗
2024-01-01	1	2026-04-09		source ↗
2023-10-01	1	2026-04-09		source ↗
2023-07-01	1	2026-04-09		source ↗
2023-04-01	1	2026-04-09		source ↗
2023-01-01	1	2026-04-09		source ↗
2022-04-01	1	2026-04-09		source ↗

Show 26 earlier report periods

Report period	Files	Loaded	Latest	CMS source
2022-01-01	1	2026-04-09		source ↗
2021-10-01	1	2026-04-09		source ↗
2021-04-01	1	2026-04-09		source ↗
2021-02-01	1	2026-04-09		source ↗
2021-01-01	1	2026-04-09		source ↗
2020-10-01	1	2026-04-09		source ↗
2020-04-01	1	2026-04-09		source ↗
2020-01-01	1	2026-04-09		source ↗
2019-01-01	1	2026-04-09		source ↗
2018-01-01	1	2026-04-09		source ↗
2017-01-01	1	2026-04-09		source ↗
2016-01-01	2	2026-04-09		source ↗
2015-01-01	1	2026-04-09		source ↗
2014-01-01	1	2026-04-09		source ↗
2013-01-01	1	2026-04-09		source ↗
2012-01-01	1	2026-04-09		source ↗
2011-01-01	1	2026-04-09		source ↗
2010-01-01	1	2026-04-09		source ↗
2009-01-01	1	2026-04-09		source ↗
2008-01-01	1	2026-04-09		source ↗
2007-01-01	1	2026-04-09		source ↗
2006-01-01	1	2026-04-09		source ↗
2005-01-01	1	2026-04-09		source ↗
2004-01-01	1	2026-04-09		source ↗
2003-01-01	1	2026-04-09		source ↗
2002-01-01	1	2026-04-09		source ↗

Data dictionary

📋 379 data columns + 5 lineage columns

Data columns

Column	Type
PBP_A_HNUMBER	TEXT
PBP_A_PLAN_IDENTIFIER	NUMBER
SEGMENT_ID	NUMBER
PBP_A_BEN_COV	NUMBER
PBP_A_PLAN_TYPE	NUMBER
ORGTYPE	NUMBER
BID_ID	TEXT
VERSION	NUMBER
PBP_B1A_BENDESC_YN	NUMBER
PBP_B1A_BENDESC_AD_UP_NMCS	NUMBER
PBP_B1A_BENDESC_AMO_AD	NUMBER
PBP_B1A_BENDESC_LIM_AD	NUMBER
PBP_B1A_BENDESC_AMT_AD	NUMBER
PBP_B1A_BENDESC_AMO_NMCS	NUMBER
PBP_B1A_BENDESC_AMO_UP	NUMBER
PBP_B1A_MAXENR_YN	NUMBER
PBP_B1A_MAXENR_AMT	NUMBER
PBP_B1A_MAXENR_PER	NUMBER
PBP_B1A_MAXENR_PER_D	TEXT
PBP_B1A_COST_VARY_TIERS_YN	NUMBER
PBP_B1A_COST_VARY_TIER_NUM	NUMBER
PBP_B1A_COST_VARY_LOW_TIER	NUMBER
PBP_B1A_COINS_YN	NUMBER
PBP_B1A_MC_COINS_CSTSHR_YN_T1	NUMBER
PBP_B1A_COINS_MCS_PCT_T1	NUMBER
PBP_B1A_COINS_MCS_INT_NUM_T1	NUMBER
PBP_B1A_COINS_MCS_PCT_INT1_T1	NUMBER
PBP_B1A_COINS_MCS_BGND_INT1_T1	NUMBER
PBP_B1A_COINS_MCS_ENDD_INT1_T1	NUMBER
PBP_B1A_COINS_MCS_PCT_INT2_T1	NUMBER
PBP_B1A_COINS_MCS_BGND_INT2_T1	NUMBER
PBP_B1A_COINS_MCS_ENDD_INT2_T1	NUMBER
PBP_B1A_COINS_MCS_PCT_INT3_T1	NUMBER
PBP_B1A_COINS_MCS_BGND_INT3_T1	NUMBER
PBP_B1A_COINS_MCS_ENDD_INT3_T1	NUMBER
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	NUMBER
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	NUMBER
PBP_B1A_AD_COST_VARY_TIER_NUM	NUMBER
PBP_B1A_AD_COST_VARY_LOW_TIER	NUMBER
PBP_B1A_COINS_AD_INTRVL_NUM_T1	NUMBER
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	NUMBER
PBP_B1A_DED_AMT_T1	NUMBER
PBP_B1A_DED_AMT_T2	TEXT
PBP_B1A_DED_AMT_T3	TEXT
PBP_B1A_COPAY_YN	NUMBER
PBP_B1A_MC_COPAY_CSTSHR_YN_T1	NUMBER
PBP_B1A_COPAY_MCS_AMT_T1	NUMBER
PBP_B1A_COPAY_MCS_INT_NUM_T1	NUMBER
PBP_B1A_COPAY_MCS_AMT_INT1_T1	NUMBER
PBP_B1A_COPAY_MCS_BGND_INT1_T1	NUMBER
PBP_B1A_COPAY_MCS_ENDD_INT1_T1	NUMBER
PBP_B1A_COPAY_MCS_AMT_INT2_T1	NUMBER
PBP_B1A_COPAY_MCS_BGND_INT2_T1	NUMBER
PBP_B1A_COPAY_MCS_ENDD_INT2_T1	NUMBER
PBP_B1A_COPAY_MCS_AMT_INT3_T1	NUMBER
PBP_B1A_COPAY_MCS_BGND_INT3_T1	NUMBER
PBP_B1A_COPAY_MCS_ENDD_INT3_T1	NUMBER
PBP_B1A_MC_COPAY_CSTSHR_YN_T2	NUMBER
PBP_B1A_COPAY_MCS_AMT_T2	NUMBER
PBP_B1A_COPAY_MCS_INT_NUM_T2	NUMBER
PBP_B1A_COPAY_MCS_AMT_INT1_T2	NUMBER
PBP_B1A_COPAY_MCS_BGND_INT1_T2	NUMBER
PBP_B1A_COPAY_MCS_ENDD_INT1_T2	NUMBER
PBP_B1A_COPAY_MCS_AMT_INT2_T2	NUMBER
PBP_B1A_COPAY_MCS_BGND_INT2_T2	NUMBER
PBP_B1A_COPAY_MCS_ENDD_INT2_T2	NUMBER
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	NUMBER
PBP_B1A_COPAY_MCS_AMT_T3	NUMBER
PBP_B1A_COPAY_MCS_INT_NUM_T3	NUMBER
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	NUMBER
PBP_B1A_COPAY_LRD_AMT_INT1_T1	NUMBER
PBP_B1A_COPAY_LRD_BGND_INT1_T1	NUMBER
PBP_B1A_COPAY_LRD_ENDD_INT1_T1	NUMBER
PBP_B1A_COPAY_LRD_AMT_INT2_T1	NUMBER
PBP_B1A_COPAY_LRD_BGND_INT2_T1	NUMBER
PBP_B1A_COPAY_LRD_ENDD_INT2_T1	NUMBER
PBP_B1A_COPAY_LRD_AMT_INT3_T1	NUMBER
PBP_B1A_COPAY_LRD_BGND_INT3_T1	NUMBER
PBP_B1A_COPAY_LRD_ENDD_INT3_T1	NUMBER
PBP_B1A_COPAY_LRD_INT_NUM_T2	NUMBER
PBP_B1A_COPAY_LRD_AMT_INT1_T2	NUMBER
PBP_B1A_COPAY_LRD_BGND_INT1_T2	NUMBER
PBP_B1A_COPAY_LRD_ENDD_INT1_T2	NUMBER
PBP_B1A_COPAY_LRD_AMT_INT2_T2	NUMBER
PBP_B1A_COPAY_LRD_BGND_INT2_T2	NUMBER
PBP_B1A_COPAY_LRD_ENDD_INT2_T2	NUMBER
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	NUMBER
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	NUMBER
PBP_B1A_COPAY_AD_AMT_INT1_T1	NUMBER
PBP_B1A_COPAY_AD_BGND_INT1_T1	NUMBER
PBP_B1A_COPAY_AD_ENDD_INT1_T1	NUMBER
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	NUMBER
PBP_B1A_COPAY_AD_AMT_INT1_T2	NUMBER
PBP_B1A_COPAY_AD_BGND_INT1_T2	NUMBER
PBP_B1A_COPAY_AD_ENDD_INT1_T2	NUMBER
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	NUMBER
PBP_B1A_COPAY_NMCS_AMT	NUMBER
PBP_B1A_COPAY_NMCS_INTRVL_NUM	NUMBER
PBP_B1A_COPAY_NMCS_AMT_INTRVL1	NUMBER
PBP_B1A_COPAY_NMCS_BGND_NTRVL1	NUMBER
PBP_B1A_COPAY_NMCS_ENDD_NTRVL1	NUMBER
PBP_B1A_COPAY_NMCS_AMT_INTRVL2	NUMBER
PBP_B1A_COPAY_NMCS_BGND_NTRVL2	NUMBER
PBP_B1A_COPAY_NMCS_ENDD_NTRVL2	NUMBER
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	NUMBER
PBP_B1A_COPAY_UP_AMT_STAY	TEXT
PBP_B1A_COPAY_UP_AMT_DAY	TEXT
PBP_B1A_HOSP_BEN_PERIOD	NUMBER
PBP_B1A_HOSP_BEN_PERIOD_OTH	TEXT
PBP_B1A_COST_DISCHARGE_YN	NUMBER
PBP_B1A_AUTH_YN	NUMBER
PBP_B1A_REFER_YN	NUMBER
PBP_B1A_BENDESC_YN_BONLY	NUMBER
PBP_B1A_BENDESC_AMO_IACT_BONLY	NUMBER
PBP_B1A_BENDESC_ULIM_BONLY	NUMBER
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	NUMBER
PBP_B1A_MAXPLAN_AMT_BONLY	TEXT
PBP_B1A_MAXPLAN_PER_BONLY	TEXT
PBP_B1A_MAXPLAN_PER_BONLY_D	TEXT
PBP_B1A_MAXENR_YN_BONLY	NUMBER
PBP_B1A_MAXENR_AMT_BONLY	TEXT
PBP_B1A_MAXENR_PER_BONLY	TEXT
PBP_B1A_MAXENR_PER_BONLY_D	TEXT
PBP_B1A_COINS_YN_BONLY	NUMBER
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	NUMBER
PBP_B1A_DED_AMT_BONLY	TEXT
PBP_B1A_COPAY_YN_BONLY	NUMBER
PBP_B1A_COPAY_AMT_PS_BONLY	NUMBER
PBP_B1A_COPAY_PS_NUM_BONLY	NUMBER
PBP_B1A_COPAY_PS_AMT1_BONLY	NUMBER
PBP_B1A_COPAY_PS_BGND1_BONLY	NUMBER
PBP_B1A_COPAY_PS_ENDD1_BONLY	NUMBER
PBP_B1A_COPAY_PS_AMT2_BONLY	NUMBER
PBP_B1A_COPAY_PS_BGND2_BONLY	NUMBER
PBP_B1A_COPAY_PS_ENDD2_BONLY	NUMBER
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	NUMBER
PBP_B1A_AUTH_YN_BONLY	NUMBER
PBP_B1A_REFER_YN_BONLY	NUMBER
PBP_B1A_AUTH	TEXT
PBP_B1A_AUTH_BONLY	TEXT
PBP_B1A_COINS_MCS_PCT	TEXT
PBP_B1A_COINS_MCS_INTRVL_NUM	TEXT
PBP_B1A_COINS_MCS_PCT_INTRVL1	TEXT
PBP_B1A_COINS_AD_BGND_INTRVL1	TEXT
PBP_B1A_COINS_MCS_BGND_INTRVL1	TEXT
PBP_B1A_MDCR_COINS_CSTSHRS_YN	TEXT
PBP_B1A_COINS_AD_BGND_INTRVL2	TEXT
PBP_B1A_COINS_MCS_ENDD_INTRVL1	TEXT
PBP_B1A_COINS_AD_BGND_INTRVL3	TEXT
PBP_B1A_COINS_MCS_PCT_INTRVL2	TEXT
PBP_B1A_COINS_AD_ENDD_INTRVL1	TEXT
PBP_B1A_COINS_MCS_BGND_INTRVL2	TEXT
PBP_B1A_COINS_AD_ENDD_INTRVL2	TEXT
PBP_B1A_COINS_MCS_ENDD_INTRVL2	TEXT
PBP_B1A_COINS_AD_ENDD_INTRVL3	TEXT
PBP_B1A_COINS_MCS_PCT_INTRVL3	TEXT
PBP_B1A_COINS_AD_INTRVL_NUM	TEXT
PBP_B1A_COINS_MCS_BGND_INTRVL3	TEXT
PBP_B1A_COINS_AD_PCT_INTRVL1	TEXT
PBP_B1A_COINS_MCS_ENDD_INTRVL3	TEXT
PBP_B1A_COINS_AD_PCT_INTRVL2	TEXT
PBP_B1A_COINS_COV_MCS	TEXT
PBP_B1A_COINS_AD_PCT_INTRVL3	TEXT
PBP_B1A_COINS_COV_AD	TEXT
PBP_B1A_COINS_COV_BONLY	TEXT
PBP_B1A_COINS_LRD_INTRVL_NUM	TEXT
PBP_B1A_COINS_COV_NMCS	TEXT
PBP_B1A_COINS_LRD_PCT_INTRVL1	TEXT
PBP_B1A_COINS_COV_UP	TEXT
PBP_B1A_COINS_LRD_BGND_INTRVL1	TEXT
PBP_B1A_COINS_LRD_ENDD_INTRVL1	TEXT
PBP_B1A_COINS_LRD_PCT_INTRVL2	TEXT
PBP_B1A_COINS_LRD_BGND_INTRVL2	TEXT
PBP_B1A_COINS_LRD_ENDD_INTRVL2	TEXT
PBP_B1A_COINS_LRD_PCT_INTRVL3	TEXT
PBP_B1A_COINS_LRD_BGND_INTRVL3	TEXT
PBP_B1A_COINS_LRD_ENDD_INTRVL3	TEXT
PBP_B1A_COINS_COV_LRD	TEXT
PBP_B1A_DED_AMT	TEXT
PBP_B1A_COPAY_MCS_AMT	TEXT
PBP_B1A_COPAY_MCS_INTRVL_NUM	TEXT
PBP_B1A_COPAY_MCS_AMT_INTRVL1	TEXT
PBP_B1A_COPAY_MCS_BGND_INTRVL1	TEXT
PBP_B1A_COPAY_MCS_ENDD_INTRVL1	TEXT
PBP_B1A_COPAY_MCS_AMT_INTRVL2	TEXT
PBP_B1A_COPAY_MCS_BGND_INTRVL2	TEXT
PBP_B1A_COPAY_MCS_ENDD_INTRVL2	TEXT
PBP_B1A_COPAY_MCS_AMT_INTRVL3	TEXT
PBP_B1A_COPAY_MCS_BGND_INTRVL3	TEXT
PBP_B1A_COPAY_MCS_ENDD_INTRVL3	TEXT
PBP_B1A_MDCR_COPAY_CSTSHRS_YN	TEXT
PBP_B1A_COPAY_AD_INTRVL_NUM	TEXT
PBP_B1A_COPAY_AD_AMT_INTRVL1	TEXT
PBP_B1A_COPAY_AD_BGND_INTRVL1	TEXT
PBP_B1A_COPAY_AD_ENDD_INTRVL1	TEXT
PBP_B1A_COPAY_AD_AMT_INTRVL2	TEXT
PBP_B1A_COPAY_AD_AMT_INTRVL3	TEXT
PBP_B1A_COPAY_AD_BGND_INTRVL2	TEXT
PBP_B1A_COPAY_AD_ENDD_INTRVL2	TEXT
PBP_B1A_COPAY_AD_BGND_INTRVL3	TEXT
PBP_B1A_COPAY_AD_ENDD_INTRVL3	TEXT
PBP_B1A_COPAY_LRD_INTRVL_NUM	TEXT
PBP_B1A_COPAY_LRD_AMT_INTRVL1	TEXT
PBP_B1A_COPAY_LRD_BGND_INTRVL1	TEXT
PBP_B1A_COPAY_LRD_ENDD_INTRVL1	TEXT
PBP_B1A_COPAY_LRD_AMT_INTRVL2	TEXT
PBP_B1A_COPAY_LRD_BGND_INTRVL2	TEXT
PBP_B1A_COPAY_LRD_ENDD_INTRVL2	TEXT
PBP_B1A_COPAY_LRD_AMT_INTRVL3	TEXT
PBP_B1A_COPAY_LRD_BGND_INTRVL3	TEXT
PBP_B1A_COPAY_LRD_ENDD_INTRVL3	TEXT
PBP_B1A_COST_SHARE_VARY_YN	TEXT
PBP_B1A_PFFS_COPAY_AMT	TEXT
PBP_B1A_PFFS_MAXENR_AMT	TEXT
PBP_B1A_MAXPLAN_COV_BONLY	TEXT
PBP_B1A_ESRD_COPAY_AMT	TEXT
PBP_B1A_ESRD_MAXENR_AMT	TEXT

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:

SELECT d.PBP_A_HNUMBER, d.PBP_A_PLAN_IDENTIFIER, d.SEGMENT_ID,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.BENEFITS_DATA__INPATIENT_HOSPITAL_ACUTE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation (MA/Part D contract and enrollment data)

• Latest source file from CMS (zip)

Frequently asked questions

How often is Benefits Data - Inpatient Hospital (Acute) updated?

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

What years does Benefits Data - Inpatient Hospital (Acute) cover?

2002 through 2026.

How many records are in Benefits Data - Inpatient Hospital (Acute)?

195,603 rows across all 36 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 - Inpatient Hospital (Acute) data?

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

Related feeds

Benefits Data - Inpatient Hospital (Psychiatric)Benefits Data - Covered ServicesBenefits Data - Premiums & DeductiblesBenefits Data - Part D Drug CoverageBenefits Data - Plan Information

Get this feed

1. Start a free trial on Snowflake Marketplace

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

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