Benefits Data - Plan Information
Medicare Advantage and Part D Plan Information including plan names, service areas, contact information, SNP details, and enrollment data
Part of the CMS Data Research Dataset › Plan Benefits
Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__PLAN_INFO on Snowflake — coverage from 2019 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__PLAN_INFO
Coverage
Jan 2019 – Jan 2026
Rows
154,754 (total across all reporting periods)
Update pattern
Time-partitioned — each file adds one reporting period
Latest report period
2026-01-01
Loaded
2025-11-20
Columns
99 data + 5 lineage
Identifiers
Contract ID (H-number) · Plan ID
File versions
19
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.
Latest report period Jan 2026 — awaiting the next release. New periods load automatically when CMS publishes.
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
About this feed
Medicare Advantage and Part D Plan Information including plan names, service areas, contact information, SNP details, and enrollment data
— Source: CMS feed metadata
Theme: Plan Benefits
Coverage timeline
2019–2026 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
8 of 8 years covered — no gaps.
Release history
Data dictionary
📋 99 data columns + 5 lineage columns
Data columns
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_A_CONTRACT_PARTD_FLAG
NUMBER
PBP_A_PLATINO_FLAG
NUMBER
PBP_A_SNP_PCT
NUMBER
PBP_A_VBID_INDICATOR
TEXT
PBP_A_BPT_MA_DATE_TIME
TIMESTAMP_NTZ
PBP_A_BPT_PD_DATE_TIME
TIMESTAMP_NTZ
PBP_A_BPT_MSA_DATE_TIME
TIMESTAMP_NTZ
PBP_A_BPT_ESRD_DATE_TIME
TIMESTAMP_NTZ
PBP_A_ORG_NAME
TEXT
PBP_A_ORG_MARKETING_NAME
TEXT
PBP_A_ORG_WEBSITE
TEXT
PBP_A_PLAN_NAME
TEXT
PBP_A_ORG_TYPE
NUMBER
PBP_A_NETWORK_FLAG
NUMBER
PBP_A_HOSPICE_CARE_YN
NUMBER
PBP_A_PLAN_GEOG_NAME
TEXT
PBP_A_SEGMENT_NAME
TEXT
PBP_A_EGHP_YN
NUMBER
PBP_A_EST_MEMB
NUMBER
PBP_A_CONTINUE_YN
NUMBER
PBP_A_CONTINUE_COSTSHARE_YN
NUMBER
PBP_A_PLATINO_YN
NUMBER
PBP_A_SPECIAL_NEED_FLAG
NUMBER
PBP_A_SPECIAL_NEED_PLAN_TYPE
NUMBER
PBP_A_SNP_INSTITUTIONAL_TYPE
NUMBER
PBP_A_DSNP_ZERODOLLAR
NUMBER
PBP_A_SNP_COND
NUMBER
PBP_A_SNP_STATE_CVG_YN
NUMBER
PBP_A_PHARMACY_WEBSITE
TEXT
PBP_A_FORMULARY_WEB_ADDR
TEXT
PBP_A_PHYS_WEB_ADDR
TEXT
PBP_A_CURMBR_PHONE
TEXT
PBP_A_CURMBR_PHONE_EXT
TEXT
PBP_A_CURMBR_LOC_PHONE
TEXT
PBP_A_CURMBR_LOC_PHONE_EXT
TEXT
PBP_A_PROMBR_PHONE
TEXT
PBP_A_PROMBR_PHONE_EXT
NUMBER
PBP_A_PROMBR_LOC_PHONE
TEXT
PBP_A_PROMBR_LOC_PHONE_EXT
NUMBER
PBP_A_PD_CURMBR_PHONE
TEXT
PBP_A_PD_CURMBR_PHONE_EXT
NUMBER
PBP_A_PD_CURMBR_LOC_PHONE
TEXT
PBP_A_PD_CURMBR_LOC_PHONE_EXT
NUMBER
PBP_A_PD_PROMBR_PHONE
TEXT
PBP_A_PD_PROMBR_PHONE_EXT
NUMBER
PBP_A_PD_PROMBR_LOC_PHONE
TEXT
PBP_A_PD_PROMBR_LOC_PHONE_EXT
NUMBER
PBP_A_TTYTDD_CURMBR_PHONE
TEXT
PBP_A_TTYTDD_CURMBR_PHONE_EXT
NUMBER
PBP_A_TTYTDD_CUR_LOC_PHONE
TEXT
PBP_A_TTYTDD_CUR_LOC_PHONE_EXT
NUMBER
PBP_A_TTYTDD_PROMBR_PHONE
TEXT
PBP_A_TTYTDD_PROMBR_PHONE_EXT
NUMBER
PBP_A_TTYTDD_PRO_LOC_PHONE
TEXT
PBP_A_TTYTDD_PRO_LOC_PHONE_EXT
NUMBER
PBP_A_PD_TTYTDD_CURMBR_PHONE
TEXT
PBP_A_PD_TTYTDD_CURMBR_PHN_EXT
NUMBER
PBP_A_PD_TTYTDD_CUR_LOC_PHONE
TEXT
PBP_A_PD_TTYTDD_CUR_LOC_PHN_EX
NUMBER
PBP_A_PD_TTYTDD_PROMBR_PHONE
TEXT
PBP_A_PD_TTYTDD_PROMBR_PHN_EXT
NUMBER
PBP_A_PD_TTYTDD_PRO_LOC_PHONE
TEXT
PBP_A_PD_TTYTDD_PRO_LOC_PHN_EX
NUMBER
PBP_A_FFS_BID_B_YN
NUMBER
PBP_A_FFS_BID_B_AUTH_YN
NUMBER
PBP_A_FFS_BID_B_AUTH_CATS
TEXT
PBP_A_FFS_BID_B_REF_YN
NUMBER
PBP_A_FFS_BID_B_REF_CATS
TEXT
PBP_A_FFS_BID_C_YN
NUMBER
PBP_A_FFS_BID_C_AUTH_YN
NUMBER
PBP_A_FFS_BID_C_AUTH_CATS
TEXT
PBP_A_FFS_BID_C_REF_YN
NUMBER
PBP_A_FFS_BID_C_REF_CATS
TEXT
PBP_A_FFS_BID_D_YN
NUMBER
PBP_A_TIER_YN
NUMBER
PBP_A_TIER_BENDESC_BENS
NUMBER
PBP_A_TIER_MC_BENDESC_CATS
TEXT
PBP_A_TIER_NMC_BENDESC_CATS
TEXT
PBP_A_LAST_DATA_ENTRY_DATE
TEXT
PBPVER
TEXT
PBP_A_PARTD_MODEL_FLAG
TEXT
PBP_A_PDSS_MODEL_FLAG
TEXT
PBP_A_READY_FOR_UPLOAD_DATE_TM
TEXT
PBP_A_UPLOAD_DATE_TIME
TEXT
PBP_A_SERVICE_AREA
TEXT
PBP_A_CONTRACT_NUMBER
TEXT
PBP_A_SEGMENT_ID
TEXT
PBP_A_CONTRACT_PERIOD
TEXT
PBP_A_SNP_COND_OTH1
TEXT
PBP_A_SNP_COND_OTH2
TEXT
PBP_A_SNP_COND_OTH3
TEXT
Lineage columns (present on every feed table)
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 - Plan Information updated?
CMS last published this feed on 2026-01-01. New releases are added automatically when CMS publishes them.
What years does Benefits Data - Plan Information cover?
2019 through 2026.
How many records are in Benefits Data - Plan Information?
154,754 rows across all 19 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 - Plan Information data?
It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.BENEFITS_DATA__PLAN_INFO directly — no pipeline setup required.
Related feeds
Benefits Data - Inpatient Hospital (Psychiatric)Benefits Data - Inpatient Hospital (Acute)Benefits Data - Part D Drug CoverageBenefits Data - Premiums & DeductiblesBenefits Data - Covered ServicesGet this feed
Mount the share — the database and
DWVschema appear in your account immediatelyRun 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 — 22 research tables · 20 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →
Last updated