Physician Fee Schedule National Payment Amount File

The significant size of the Physician Fee Schedule Payment Amount File-National requires that database programs (e.g., Access, dBase, FoxPro, etc.) be used to…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.PHYSICIAN_FEE_SCHEDULE_NATIONAL_PAYMENT_AMOUNT_FILE on Snowflake and Databricks — 12 snapshot releases spanning 2021–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.PHYSICIAN_FEE_SCHEDULE_NATIONAL_PAYMENT_AMOUNT_FILE
Databricks	cms_dwv.physician_fee_schedule_national_payment_amount_file
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2025-01-01
Loaded	2025-05-18
Columns	16 data + 6 lineage
Identifiers	HCPCS codes
File versions	12
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.

Last CMS publication 2025-01-01 — awaiting the next release. New files load automatically when CMS publishes.

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.

Sample queries

Snowflake

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

Databricks

About this feed

The significant size of the Physician Fee Schedule Payment Amount File-National requires that database programs (e.g., Access, dBase, FoxPro, etc.) be used to read these data. Word processing and spreadsheet programs cannot be used. The database programs noted above will also be required to read some versions of the Physician Fee Schedule Payment Amount File Carrier-Specific.

— Source: CMS feed metadata

Keywords: Medicare, Physician Fee Schedule National Payment Amount File Theme: Medicare

Coverage timeline

2021 🟩 · 2022 🟩 · 2023 🟩 · 2024 🟩 · 2025 🟩

5 of 5 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2025-01-01	2025-01-01	2025-05-18	✓
Snapshot as of 2025-01-01	2025-01-01	2025-04-20
Snapshot as of 2025-01-01	2025-01-01	2025-04-20
Snapshot as of 2024-01-01	2024-01-01	2025-04-20
Snapshot as of 2024-01-01	2024-01-01	2025-04-20
Snapshot as of 2024-01-01	2024-01-01	2025-04-20
Snapshot as of 2023-01-01	2023-01-01	2025-04-20
Snapshot as of 2022-01-01	2022-01-01	2025-04-20
Snapshot as of 2022-01-01	2022-01-01	2025-04-20
Snapshot as of 2021-01-01	2021-01-01	2025-04-20

Show 2 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2021-01-01	2021-01-01	2025-04-20
Snapshot as of 2021-01-01	2021-01-01	2025-04-20

Data dictionary

📋 16 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Physician Fee Schedule National Payment Amount File data dictionary.

Data columns

Column	Type
YEAR	NUMBER
CARRIER	TEXT
LOCALITY	TEXT
HCPCS_CODE	TEXT
MODIFIER	TEXT
NON_FACILITY_PRICE	NUMBER
FACILITY_PRICE	NUMBER
MULTIPLE_PROCEDURE_INDICATOR	TEXT
BILATERAL_SURGERY_INDICATOR	TEXT
STATUS_CODE	TEXT
GLOBAL_SURGERY_INDICATOR	TEXT
PE_RVU_NON_FACILITY	NUMBER
PE_RVU_FACILITY	NUMBER
PROFESSIONAL_TECHNICAL_CODE	TEXT
MALPRACTICE_RVU_NON_FACILITY	NUMBER
MALPRACTICE_RVU_FACILITY	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
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

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.YEAR, d.CARRIER, d.LOCALITY,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.PHYSICIAN_FEE_SCHEDULE_NATIONAL_PAYMENT_AMOUNT_FILE 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

Frequently asked questions

How often is Physician Fee Schedule National Payment Amount File updated?

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

What years does Physician Fee Schedule National Payment Amount File cover?

2021 through 2025.

How many records are in Physician Fee Schedule National Payment Amount File?

Count the current snapshot yourself once the share is mounted:

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

How do I get Physician Fee Schedule National Payment Amount File 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.PHYSICIAN_FEE_SCHEDULE_NATIONAL_PAYMENT_AMOUNT_FILE directly — no pipeline setup required.

Related feeds

Agency for Healthcare Research and Quality (AHRQ) Patient Safety Indicator 11 (PSI-11) Measure RatesPalliative Care - PPS-Exempt Cancer Hospital - NationalHospital Value-Based Purchasing (HVBP) - Total Performance ScoreMedicare Clinical Laboratory Fee Schedule Private Payer Rates and VolumesMaternal Health - National

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

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 Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →