Help

Data dictionary

What each term and column means, the codes behind every procedure, and how often each source is refreshed.

Terms you will meet

Reported and estimated

Medicare fee-for-service is reported: CMS’s own count of patients on traditional Medicare. Fee-for-service alone falls as patients move to Medicare Advantage, so its trend understates the market.

All Medicare is estimated: Fee-for-service plus Medicare Advantage patients at each state's enrollment share. All payers is estimated too: Medicare scaled by its share of the procedure nationally: commercial, Medicaid and other patients added. An estimate is always labelled (“est.”, “all”, or a range) and never replaces the reported count.

For you: Rank on the reported count; size a market or an account with the estimate. Quote a surgeon’s own figures only as Medicare.

CMS's under-11 rule
  • CMS leaves out any surgeon, code and year with fewer than 11 patients, to protect privacy.
  • A blank is “none, or under 11”, not zero.
  • MedaRep estimates the missing cases from the state totals CMS does publish and shows them as “+~N est.” under the reported count, placed with the surgeons most likely to hold them.

For you: A surgeon with a small count, or none, may still operate here: check their practice and hospitals before writing them off.

Payment depth

The deepest kind of engagement a company reported with a surgeon for these products in Open Payments, which says more than the dollar total. A surgeon’s main company is the one with the most reported engagement (Open Payments dollars) for these products in a program year, over $500.

  • none: No payment for these products in Open Payments: no visible tie to any company.
  • hospitality: Meals, travel or education only. A courtesy, not a commitment: the surgeon may be open to a conversation.
  • speaker: Speaking or teaching for the company: a closer working relationship, and may be less likely to change.
  • consulting: Consulting: a sign of a working relationship with the company.
  • royalty: Royalties or licence fees: often a sign of design work on a product. The deepest tie, and the least likely to change.

For you: Consider starting with the surgeons at none or hospitality. Open Payments shows the payments companies reported. It suggests engagement, not which devices a surgeon uses, and is not evidence of wrongdoing. Payments are never something to raise with them.

Employment model

How the surgeon’s practice is run, from Medicare enrollment, NPPES and hospital ownership records. It says who decides on product:

  • Independent group: surgeon-led: the group decides, and implant economics are theirs.
  • Solo: single decision-maker.
  • Health-system employed: committee-gated: surgeon preference feeds a value-analysis process.
  • Academic: department-gated: chair, residents, and research ties shape adoption.
  • Not a practice: the record is a therapy, imaging, anesthesia or staffing company, not a surgical practice.
  • Unknown: not enough public evidence to say.

For you: With an independent group, sell to the surgeons; with a health system, plan for value analysis and the contract as well as the surgeon.

Engagement moved
  • Engagement moved: a different main company (the one most engaged with them) in the latest payment year than the year before. Engagement moved; the earlier company may still call on them, and it does not show device use.
  • Engagement may move: a model trained on past changes scores the chance of one next year.
  • With your lines on your account: engagement moving to your company reads Engagement moved to you, away from it Engagement moved away, and a high chance of a change away from you Retention risk.

For you: A surgeon whose engagement just moved may still be settling in: consider calling the ones whose engagement moved away from a competitor, and checking in with the ones marked Retention risk.

Warm paths

The warmest way from one of your customers to a target, from public records only, strongest first:

  1. Partners in the same group (strong in a group of up to 10, or the same office).
  2. Former partners.
  3. The same hospital (real at a small one, weak at a large one).
  4. The same company’s faculty or speaker bureau.

No public file records referrals, so a path suggests who knows whom.

For you: Ask the customer at the start of the path for an introduction before you cold-call the surgeon at its end.

Trend
  • A surgeon’s yearly change in Medicare cases over 3 years.
  • Their county’s shift to Medicare Advantage is removed first: it otherwise looks like a decline in every growing market.
  • Growth or decline is called only on 20 or more cases and a change of 15% or more; anything smaller reads as steady.

For you: A growing surgeon is adding cases someone will supply: be early.

Forecasts
  • CMS publishes about two years late.
  • A model trained on every surgeon’s billing history forecasts each surgeon’s cases for the years since; a second scores the chance they stop billing Medicare here.
  • Every forecast comes with a range from its measured error: treat the range, not the point, as the claim.
  • How they are built and tested is on the about page.

For you: Use the forecast to plan this year’s calls, and the reported years to talk about the past.

MS-DRG, MCC and CC

A hospital is paid for an inpatient stay by its Medicare Severity Diagnosis Related Group: the main operation (or diagnosis), split by how sick the patient was.

  • With MCC: the stay had a major complication or comorbidity (MCC), a secondary diagnosis on CMS's MCC list, such as acute respiratory failure or sepsis.
  • With CC: the stay had a complication or comorbidity (CC), none of them major.
  • Without CC/MCC: neither a complication nor a comorbidity on CMS's lists.
  • The operations are the same in each half of a pair, so 469 and 470 together are the hospital’s hip and knee replacements.
  • CMS renumbers DRGs every October; the families list old and new numbers, and each one below says when it started or stopped (MS-DRG v44.0, in use from October 2026).
  • A DRG can hold more than one family’s procedures: 469 and 470 count hips and knees together. Such a DRG is marked shared, and its count is the same number on each family, so never add the families’ DRG counts together.
  • The CPT counts on a surgeon are the family-only view.

For you: Add the with- and without-MCC halves together for a hospital’s volume. A high MCC share points to a trauma or referral centre, where sicker patients mean longer stays and more implants per case.

All-payer cases (New York)

New York publishes, free, every hospital’s inpatient stays from every payer, by procedure: its SPARCS de-identified discharge file. MedaRep has it for New York only.

  • Counting: each stay by its principal procedure, in the state’s procedure categories (AHRQ’s CCSR), each read for the families below. One category can serve two families (spine fusion is lumbar and cervical together).
  • Payers: Medicare (traditional and Medicare Advantage together), Commercial (Blue Cross and private insurance), Medicaid (including its managed care), and Other and self-pay.
  • Campuses: those CMS certifies under one number are counted together.
  • Small counts: none of 10 or fewer is shown, nor one that could be worked out from the others.

Source: New York State Department of Health, SPARCS de-identified inpatient discharges (health.data.ny.gov). The New York State Department of Health makes no representation, warranty or guarantee relating to the data or analyses derived from these data.

For you: Beside a New York hospital’s Medicare figures, this is its whole book of business: rank accounts on it for an under-65 procedure (spine, trauma, bariatric), and lead with a premium product where the commercial share is high.

Why now

Reasons to call a surgeon this week, each a fact MedaRep holds, strongest first:

  • Engagement moved: The company most engaged with them for these products changed in the latest Open Payments year.
  • Engagement may move: The model puts the chance that the company most engaged with them changes next year well above average, with its reasons.
  • Possible disruption (FDA recall): FDA posted a recall in the last 120 days on products of a company engaged with them for these products, weighed by its class and size: a possible disruption of supply or service. Consider asking how their supply and service have been, without raising the recall.
  • Practice change: A move or a new practice in the last 12 months, from the Medicare enrollment snapshots.
  • Partner left the group: A partner in the same specialty left their group of 2 to 5 in the last 12 months, from the Medicare enrollment snapshots. In groups this small the partners who stay have tended to pick up about 3% more of the family the next year than forecast (2021-2024 back-test).
  • New surgeon: A fellow who stayed or a surgeon who joined a group, not in CMS's claims files yet.
  • Volume surge: Medicare cases up 25% or more on a real base.
  • Latest CMS count: CMS's clinician count for the latest 12 months it has processed (what Medicare.gov shows on their profile), read against their latest Medicare claims: new to a procedure (no claims in three years and none estimated under the floor), busier or slower by half or more, or few or none. Months behind, where the claims run two years behind; the 14 procedure groups CMS counts.
  • TEAM hospital: Operates at a hospital in CMS's Transforming Episode Accountability Model (TEAM), mandatory in selected areas from January 2026: the hospital answers for the total Medicare cost of joint replacement, hip fracture, spinal fusion and major bowel episodes through 30 days after discharge, so it may weigh length of stay, setting and readmissions beside the implant price. From CMS's participant list (refreshed quarterly).
  • Moving to surgery centers: Did 11 or more Medicare cases in the latest claims year on procedures CMS's outpatient rules have since added to the list a surgery center can bill (the CY2026 and CY2027 OPPS/ASC final rules, which also took them off the inpatient-only list): some of those cases may leave the hospital.
  • Prior authorization (WISeR): Among the 25 busiest surgeons in a territory in Arizona, New Jersey, Ohio, Oklahoma, Texas or Washington, in a family with services in CMS's WISeR model (spinal cord stimulator leads, knee arthroscopy for osteoarthritis, cervical fusion, vertebral augmentation, hypoglossal and vagus nerve stimulators, incontinence devices and sacral nerve stimulation, penile prostheses, skin substitutes): Original Medicare needs prior authorization for those cases from 2026-01-15 through 2031. From CMS's operational guide, Appendix A.
  • New to Medicare: On CMS's list of first-time Medicare enrollments still being processed (updated about twice a week), and in the territory by NPPES with a specialty for its procedures: new here, before any claim shows them.
  • Hospital changed owners: Operates at a hospital that changed owners in the last 18 months, from CMS's quarterly change-of-ownership list: new owners often revisit contracts and value analysis.
  • In CMS's specialty model: In CMS's Ambulatory Specialty Model from 2027, low back pain (spine and pain procedures) or heart failure (cardiac devices): part of the clinician's Medicare pay follows the cost and outcomes of those patients.
  • Moved into the office: 40% or more of a procedure's Medicare cases billed in their own office, up 25 points or more in 3 years: most likely an office-based lab, where the surgeon buys the devices on cost.
  • Stimulator trials: Spinal cord stimulation: about 10 or more stimulator trials in the latest Medicare year, either up 25% or more on the year before or with few permanent implants of their own. Trials are estimated from lead claims (two leads a placement, less the leads of their own percutaneous implants). The system is chosen at the trial.
  • Customer's partner: In a group now with one of your customers: the land-and-expand call.
  • Likely incumbent's FDA clearance: The company most engaged with them for these products got a new device cleared or approved by FDA recently: a new entrant, a new system or a line extension.
  • Looks like your customers: Fits the pattern of your customers: where they operate, how they are employed, how busy they are, who engages them.
  • In the news: This week's news for the territory names them or their practice.
  • Trial gone quiet: You marked them trialing, and no visit is logged in 21 days.
  • Competitor account, worth a call: You marked them on a competitor, and a reason above may make them open to a conversation: a likely change of company, a recall that may disrupt supply, a move, a company change, a new office or a new product.
  • Worth reconnecting: You marked them lost, and a reason above may make them open to a conversation again.
  • Room to grow: Your customer in this segment, at some or about half of their cases by your own mark, with 20 or more Medicare cases here.
  • Customer gone quiet: Your customer (using us), with no visit logged in 60 days.
  • Worth checking in: Your customer (using us), with a reason above that they may leave: a likely change of company, a move or a new office of their own. The share you set says what is at stake.

For you: Work through the list on a Friday, when there is time to look into each surgeon, and plan next week’s calls top down; the Friday email sends the same list. More in Why now.

Codes by procedure

Each procedure family is a fixed set of billing codes:

  • The CPT and HCPCS codes the surgeon bills (CMS’s physician files).
  • The MS-DRGs the hospital bills for an inpatient stay.
  • The APCs an outpatient department is paid under.
  • The FDA product codes its devices are cleared under.

The numbers are listed here, so a code can be found on this page; open a family for what each code is.

Spine & neurosurgery

Biologics & wound care

Pain & neuromodulation

Cardiac rhythm & electrophysiology

Interventional & structural cardiology

Vascular & endovascular

Neurovascular & neurosurgical devices

General & bariatric surgery

  • Hernia repair
    49505 49650 49651 49560 49561 49565 49566 49570 49572 49585 49587 49590 49652 49653 49654 49655 49656 49657 49591 49592 49593 49594 49595 49596 49613 49614 49615 49616 49617 49618 49621 49622 · DRG 353 354 355 · FDA FTL FTM OWT
  • Bariatric surgery
    43644 43775 43770 · DRG 619 620 621 · FDA GAG GDW
  • Antireflux & hiatal hernia surgery
    43280 43281 43282 · DRG 326 327 328 · FDA GAG GDW
  • Colorectal resection
    44204 44205 44207 44140 44145 44160 45395 45397 · DRG 329 330 331 · FDA GAG GDW NAY
  • Cholecystectomy & appendectomy
    47562 47563 44970 47600 · DRG 417 418 419 338 339 340 397 398 399 · FDA GAG GCJ GDW
  • Breast reconstruction
    19357 19340 19342 19364 19380 · FDA FTR FWM

Urology & women's health

ENT & sleep

Ophthalmology

GI & pulmonary endoscopy

Interventional oncology & breast

Diabetes & referred DME

Referred equipment (Who orders it)

Equipment and supplies a clinician orders and a supplier bills (CMS’s DMEPOS file by referring provider), counted by HCPCS Level II code. The referring clinician is the account for these reps.

  • Knee braces
    L1810–L1860
  • Spinal orthoses
    L0112–L0651

    Cervical collars through TLSOs.

  • Ankle-foot orthoses & walking boots
    L1900–L2999, L4350–L4398
  • Shoulder, elbow, wrist & hand orthoses
    L3650–L3999
  • Bone growth stimulators
    E0747, E0748, E0749, E0760

    Spinal (E0748) and non-spinal electrical and ultrasonic stimulators, ordered after fusion or for non-union.

  • Continuous glucose monitors
    A9276–A9278, K0553, K0554, E2102, E2103, A4238, A4239
  • Insulin pumps & supplies
    A4224–A4232, E0784, E0787, A9274
  • Diabetic shoes & inserts
    A5500–A5514
  • Negative-pressure wound therapy
    E2402, A6550, A9272, K0743–K0746
  • Surgical dressings
    A6010–A6530
  • Pneumatic compression & lymphedema garments
    E0650–E0676, A6531–A6549
  • CPAP & sleep therapy
    E0601, E0470, E0471, E0561, E0562, A7027–A7039, A7044–A7046
  • CPM & cold therapy
    E0935, E0936, E0218, E0217, E0236

    Continuous passive motion and water-circulating cold therapy after joint surgery.

Sources, refresh and lag

Every figure is shown with the year it describes. Public files lag, so the newest year is rarely this one. Publishers and uses are on the data sources page.

  • Medicare Physician & Other Practitioners, by Provider and Service; by Provider; by Geography and Service · CMS
    Refresh
    Once a year, when CMS publishes the year
    Lag
    Newest year 2024: about 2 years behind
  • Physician/Supplier Procedure Summary (PSPS) · CMS
    Refresh
    Once a year, when CMS publishes the year
    Lag
    Newest year 2025: about 1 year behind
  • Medicare Inpatient and Outpatient Hospitals, by Provider and Service · CMS
    Refresh
    Once a year, when CMS publishes the year
    Lag
    Newest year 2024: about 2 years behind
  • Medicare Durable Medical Equipment, Devices & Supplies, by Referring Provider and Service · CMS
    Refresh
    Once a year, when CMS publishes the year
    Lag
    Newest year 2024: about 2 years behind
  • Medicare Part D Prescribers, by Provider and Drug · CMS
    Refresh
    Once a year, when CMS publishes the year
    Lag
    Newest year 2024: about 2 years behind
  • Doctors and Clinicians national file (PECOS) and its archives · CMS
    Refresh
    Every month, on the 21st
    Lag
    CMS updates it monthly; a move can take months to reach it
  • Medicare Fee-For-Service Public Provider Enrollment and Reassignment · CMS
    Refresh
    Every month, on the 21st
    Lag
    The latest monthly release
  • Hospital General Information, ASC Quality, Provider of Services, Hospital All Owners, Cost Reports (HCRIS) · CMS
    Refresh
    Every month on the 21st; the yearly files once a year, when CMS publishes the year
    Lag
    The monthly files are current; the yearly ones' newest year is 2024
  • Medicare Monthly Enrollment; Medicare Advantage state/county penetration; Geographic Variation · CMS
    Refresh
    Every month, on the 21st
    Lag
    Medicare Advantage share monthly, the enrollment file about four months behind; Medicare use per county about two years behind
  • Hospital Inpatient Discharges (SPARCS De-Identified), 2018-2024 · New York State Department of Health
    Refresh
    Reloaded by hand once a year, when New York posts the year
    Lag
    New York posts a year about eight months after it ends: newest year 2024
  • MS-DRG Definitions Manual (v40-v44) and ICD-10-PCS code tables · CMS
    Refresh
    Rebuilt by hand each October from CMS’s new version
    Lag
    Version 44, in use since October 1, 2026
  • Open Payments: general and research payments · CMS
    Refresh
    Once a year, when CMS publishes the program year (by June 30)
    Lag
    Newest year 2025: about 1 year behind
  • NPPES NPI files and the NPI Registry API · CMS
    Refresh
    Every month, on the 21st
    Lag
    Current: clinicians update their own records, some rarely
  • Population estimates and ZCTA-to-county relationship files · U.S. Census Bureau
    Refresh
    Every month, on the 21st
    Lag
    Population as of July 1 of the year before; ZIP-to-county from the 2020 census
  • 510(k) premarket notifications, PMA approvals and device classification (openFDA) · U.S. Food and Drug Administration
    Refresh
    Reloaded by hand
    Lag
    As of the last reload; FDA posts a decision within days to weeks
  • Device recalls and enforcement reports (openFDA) · U.S. Food and Drug Administration
    Refresh
    Reloaded by hand
    Lag
    As of the last reload; FDA posts a recall once it has classified it
  • MAUDE adverse event reports (openFDA) · U.S. Food and Drug Administration
    Refresh
    Reloaded by hand
    Lag
    Trends stop six months short of today: about a third of reports are filed late
  • EDGAR company facts (XBRL) · U.S. Securities and Exchange Commission
    Refresh
    Reloaded by hand
    Lag
    The company's latest quarterly or annual filing
  • Hospital price transparency files (45 CFR 180) · Each hospital
    Refresh
    Reloaded by hand
    Lag
    Each file's own date, which hospitals must update at least yearly
  • OpenAlex · OurResearch
    Refresh
    Reloaded by hand
    Lag
    Weeks after a paper is published
  • IP to City Lite (CC BY 4.0) · DB-IP (db-ip.com)
    Refresh
    Every month, on the 2nd
    Lag
    The month's file

All guides