Medicare Fee-for-Service Comprehensive Error Rate Testing
The Medicare Fee-for-Service (FFS) Comprehensive Error Rate Testing (CERT) dataset provides information on a random sample of FFS claims to determine if they…
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.MEDICARE_FEEFORSERVICE_COMPREHENSIVE_ERROR_RATE_TESTING on Snowflake and Databricks: 16 annual reporting periods (2011–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.MEDICARE_FEEFORSERVICE_COMPREHENSIVE_ERROR_RATE_TESTING
Databricks
cms_dwv.medicare_feeforservice_comprehensive_error_rate_testing
Coverage
Jan 2011 – Dec 2025 (15 of 15 annual reporting periods)
Rows
3,034,628 (total across all reporting periods)
Cadence
Annual
Update pattern
Time-partitioned; each file adds one reporting year
CMS published
2026-02-03
Loaded
2026-02-03
Columns
8 data + 6 lineage
Identifiers
HCPCS codes
File versions
16
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.
Sample queries
About this feed
The Medicare Fee-for-Service (FFS) Comprehensive Error Rate Testing (CERT) dataset provides information on a random sample of FFS claims to determine if they were paid properly under Medicare coverage, coding, and payment rules. The dataset contains information on type of FFS claim, Diagnosis Related Group (DRG) and Healthcare Common Procedure Coding System (HCPCS) codes, provider type, type of bill, review decision, and error code. Please note, each reporting year (RY) contains claims submitted July 1 two years before the report through June 30 one year before the report. For example, the 2025 data contains claims submitted July 1, 2023 through June 30, 2024.
Source: CMS feed metadata
Keywords: Medicare, Original Medicare, Health Care Use & Payments Theme: Medicare
Coverage timeline
2011–2025 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
15 of 15 annual reporting periods present, no gaps.
Release history
2025-01-01 – 2025-12-31
2026-02-03
2026-02-03
✓
2024-01-01 – 2024-12-31
2025-10-28
2025-10-28
2024-01-01 – 2024-12-31
2024-12-03
2024-12-03
2023-01-01 – 2023-12-31
2023-12-28
2023-12-28
2022-01-01 – 2022-12-31
2023-03-06
2023-08-29
2021-01-01 – 2021-12-31
2022-01-13
2023-08-29
2020-01-01 – 2020-12-31
2021-05-20
2023-08-29
2019-01-01 – 2019-12-31
2021-05-20
2023-08-29
2018-01-01 – 2018-12-31
2021-05-20
2023-08-29
2017-01-01 – 2017-12-31
2021-05-20
2023-08-29
Data dictionary
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 (bureau 009:38).
Frequently asked questions
How often is Medicare Fee-for-Service Comprehensive Error Rate Testing updated?
Annually. CMS last published this feed on 2026-02-03, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.
What years does Medicare Fee-for-Service Comprehensive Error Rate Testing cover?
2011 through 2025: 15 annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.
How many records are in Medicare Fee-for-Service Comprehensive Error Rate Testing?
3,034,628 rows across all 16 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count; no deduplication needed.
How do I get Medicare Fee-for-Service Comprehensive Error Rate Testing data?
It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.MEDICARE_FEEFORSERVICE_COMPREHENSIVE_ERROR_RATE_TESTING directly; no pipeline setup required.
Related feeds
Medicare Post-Acute Care Utilization - Home Health Agency by Geography and ProviderHospital Service AreaMedicare Physician & Other Practitioners - by Geography and ServiceMedicare Post-Acute Care Utilization - HospiceMedicare Inpatient Hospitals - by Provider and ServiceGet this feed
Start a free trial on Snowflake Marketplace or purchase via Databricks
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 Feeds Dataset; 300+ feeds · 34B+ records · updated daily. Back to the full catalog →
Last updated

