Physician and Other Supplier Payment State HCPCS Aggregate Report

$447.50 / year

The dataset contains information on average utilization and payments (submitted charges, Medicare allowed amount, Medicare Payment amount, Medicare standardized payment amount) on Healthcare Common Procedure Coding System (HCPCS) codes on the state level. This Public Use File is based on information from Centers for Medicare and Medicaid Services administrative claims data for Medicare beneficiaries enrolled in the fee-for-service program available from the CMS Chronic Condition Data Warehouse.

Complexity

The data in the Physician and Other Supplier PUF covers the calendar year 2012 to 2015 and contains 100% final-action physician/supplier Part B non-institutional line items for the Medicare fee-for-service population. Each year, in the United States, health care insurers process over 5 billion claims for payment. The Healthcare Common Procedure Coding System (HCPCS) code is a standardized coding system that helps Medicare and other health insurance programs ensure the claims are processed in an orderly and consistent manner. The HCPCS Level II Code Set is one of the standard code sets used for this purpose. The HCPCS is divided into two principal subsystems, referred to as level I and level II of the HCPCS. Level I of the HCPCS is comprised of CPT (Current Procedural Terminology), a numeric coding system maintained by the American Medical Association (AMA).

The CPT, on the other hand, is a uniform coding system consisting of descriptive terms and identifying codes that are used primarily to identify medical services and procedures furnished by physicians and other healthcare professionals. Level II of the HCPCS is a standardized coding system that is used primarily to identify products, supplies, and services not included in the CPT codes, such as ambulance services and durable medical equipment, prosthetics, orthotics, and supplies (DMEPOS) when used outside a physician’s office. The Physician and Other Supplier PUF and the supplemental summary tables including the “Medicare State/National HCPCS Aggregate Tables” have been updated to include Medicare standardized payment amounts.

Date Created

2017-09-22

Last Modified

2019-06-05

Version

2019-06-05

Update Frequency

Annual

Temporal Coverage

2017-2019

Spatial Coverage

United States

Source

John Snow Labs; Centers for Medicare and Medicaid Services;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

HCPCS Code, Place of Service, Aggregate HCPCS table, Physician and Other Supplier, Utilization and Payment, State HCPCS aggregate table

Other Titles

HCPCS Code and Place of Service Aggregate Report By State, HCPCS Aggregate Report By State, Medicare Providers Utilization and Payment Data State Aggregate Report, Physicians And Other Suppliers State Aggregate Report

NameDescriptionTypeConstraints
YearYear of State HCPCS aggregate datadate-
NPPES_Provider_State_DescriptionThe state where the provider is located, as reported in National Plan and Provider Enumeration System (NPPES). The values include the 50 United States, District of Columbia, U.S. territories, Armed Forces areas, Unknown and Foreign Country.string-
HCPCS_CodeHCPCS code used to identify for the specific medical service furnished by the provider. HCPCS codes include two levels. Level I codes are the Current Procedural Terminology (CPT) codes that are maintained by the American Medical Association and Level II codes are created by CMS to identify products, supplies and services not covered by the CPT codes (such as ambulance services).string-
HCPCS_DescriptionHCPCS descriptions associated with CPT codes are consumer friendly descriptions provided by the AMA. All other descriptions are CMS Level II descriptions provided in the long form. Due to variable length restrictions, the CMS Level II descriptions have been truncated to 256 bytes. As a result, the same HCPCS description can be associated with more than one HCPCS code.string-
Is_HCPCS_Drug_IndicatorIdentifies whether the HCPCS code for the specific service furnished by the provider is an HCPCS listed on the Medicare Part B Drug Average Sales Price (ASP) Files. Yes = true, No = falseboolean-
Place_of_ServiceIdentifies whether the place of service submitted on the claims is a facility (value of ‘F’) or non-facility (value of ‘O’). Non-facility is generally an office setting; however other entities are included in non-facility.string-
Number_of_ProvidersNumber of providers within provider state, HCPCS code and place of service.integerlevel : Ratio
Number_of_ServicesNumber of services provided; note that the metrics used to count the number provided can vary from service to service.numberlevel : Ratio
Number_of_Unique_Beneficiary_Or_Provider_InteractionsNumber of unique beneficiary/provider interactions (e.g., if a single beneficiary sees two different providers for a given HCPCS code this value would be two).integerlevel : Ratio
Number_of_Distinct_Medicare_Beneficiary_Or_Per_Day_ServicesNumber of distinct Medicare beneficiary/per day services. Since a given beneficiary may receive multiple services of the same type (e.g., single vs. multiple cardiac stents) on a single day, this metric removes double-counting from the line service count to identify whether a unique service occurred.integerlevel : Ratio
Average_Submitted_Charge_AmountAverage of the charges that providers submit for the service.number-
Average_Medicare_Allowed_AmountAverage of the Medicare allowed amount for the service. Medicare allowed amounts includes the amount Medicare pays, the deductible and coinsurance amounts that the beneficiary is responsible for paying, and any amounts that a third party is responsible for paying.number-
Average_Medicare_Payment_AmountAverage amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item service.number-
Average_Medicare_Standardized_Payment_AmountAverage amount that Medicare paid after beneficiary deductible and coinsurance amounts have been deducted for the line item service and after standardization of the Medicare payment has been applied.number-
YearNPPES Provider State DescriptionHCPCS CodeHCPCS DescriptionIs HCPCS Drug IndicatorPlace of ServiceNumber of ProvidersNumber of ServicesNumber of Unique Beneficiary Or Provider InteractionsNumber of Distinct Medicare Beneficiary Or Per Day ServicesAverage Submitted Charge AmountAverage Medicare Allowed AmountAverage Medicare Payment AmountAverage Medicare Standardized Payment Amount
2016Alabama100Anesthesia for procedure on salivary gland with biopsyFalseF2102962942961284.57164.64126.17134.33
2016Alabama103Anesthesia for procedure on eyelidFalseF465301830053015792.098.6975.9481.19
2016Alabama104Anesthesia for electric shock treatmentFalseF265246016292457372.7872.5255.8759.37
2016Alabama120Anesthesia for biopsy of external middle and inner earFalseF297819807819771.79122.1592.88100.95
2016Alabama124Anesthesia for examination and biopsy of external middle and inner ear using an endoscopeFalseF29414141391.2159.9745.9650.14
2016Alabama126Anesthesia for incision of ear drumFalseF275615613615465.1475.0457.4262.06
2016Alabama140Anesthesia for procedure on eyeFalseF455369034623690803.4599.4276.1480.71
2016Alabama142Anesthesia for lens surgeryFalseF886491804302049179483.4572.8456.059.88
2016Alabama144Anesthesia for procedure on eye for corneal transplantFalseF1566636546631037.82129.9399.71106.0
2016Alabama145Anesthesia for retinal surgeryFalseF364375336603753988.08127.5198.5104.6