CMS Provider Utilization and Payment Data Physician and Other Supplier Public Use File Data dictionary - onetomapanalytics/Meta_Data GitHub Wiki
CMS Physician and Other Supplier Public Use File data dictionary
APPENDIX A – Physician and Other Supplier PUF File Attributes
| Variable | Format | Length | Label | DataYear_BeginDate |
|---|---|---|---|---|
| npi | Char | 10 | National Provider Identifier | 2012 |
| nppes_provider_last_org_name | Char | 70 | Last Name/Organization Name of the Provider | 2012 |
| nppes_provider_first_name | Char | 20 | First Name of the Provider | 2012 |
| nppes_provider_mi | Char | 1 | Middle Initial of the Provider | 2012 |
| nppes_credentials | Char | 20 | Credentials of the Provider | 2012 |
| nppes_provider_gender | Char | 1 | Gender of the Provider | 2012 |
| nppes_entity_code | Char | 1 | Entity Type of the Provider | 2012 |
| nppes_provider_street1 | Char | 55 | Street Address 1 of the Provider | 2012 |
| nppes_provider_street2 | Char | 55 | Street Address 2 of the Provider | 2012 |
| nppes_provider_city | Char | 40 | City of the Provider | 2012 |
| nppes_provider_zip | Char | 20 | Zip Code of the Provider | 2012 |
| nppes_provider_state | Char | 2 | State Code of the Provider | 2012 |
| nppes_provider_country | Char | 2 | Country Code of the Provider | 2012 |
| provider_type | Char | 55 | Provider Type of the Provider | 2012 |
| medicare_participation_indicator | Char | 1 | Medicare Participation Indicator | 2012 |
| place_of_Service | Char | 1 | Place of Service | 2012 |
| hcpcs_code | Char | 5 | HCPCS Code | 2012 |
| hcpcs_description | Char | 256 | HCPCS Description | 2012 |
| hcpcs_drug_indicator | Char | 1 | Identifies HCPCS As Drug Included in the ASP Drug List | 2012 |
| line_srvc_cnt | Num | 8 | Number of Services | 2012 |
| bene_unique_cnt | Num | 8 | Number of Medicare Beneficiaries | 2012 |
| bene_day_srvc_cnt | Num | 8 | Number of Distinct Medicare Beneficiary/Per Day Services | 2012 |
| average_Medicare_allowed_amt | Num | 8 | Average Medicare Allowed Amount | 2012 |
| stdev_Medicare_allowed_amt1 | Num | 8 | Standard Deviation Medicare Allowed Amount | 2012 |
| average_submitted_chrg_amt | Num | 8 | Average Submitted Charge Amount | 2012 |
| stdev_submitted_chrg_amt1 | Num | 8 | Standard Deviation Submitted Charge Amount | 2012 |
| average_Medicare_payment_amt | Num | 8 | Average Medicare Payment Amount | 2012 |
| stdev_Medicare_payment_amt1 | Num | 8 | Standard Deviation Medicare Payment Amount | 2012 |
| average_Medicare_standard_amt | Num | 8 | Average Medicare Standardized Payment Amount | 2014 |
| 1 Standard deviation of payments and charges were removed in calendar year 2014. |
APPENDIX B – Medicare Physician and Other Supplier Aggregate (NPI) File Attributes
| Variable | Format | Length | Label | Data_Year_Begin_Date |
|---|---|---|---|---|
| npi | Char | 10 | National_Provider_Identifier | 2012 |
| ppes_provider_last_org_name | Char | 70 | Last_Name/Organization_Name_of_the_Provider | 2012 |
| ppes_provider_first_name | Char | 20 | First_Name_of_the_Provider | 2012 |
| ppes_provider_mi | Char | 1 | Middle_Initial_of_the_Provider | 2012 |
| ppes_credentials | Char | 20 | Credentials_of_the_Provider | 2012 |
| ppes_provider_gender | Char | 1 | Gender_of_the_Provider | 2012 |
| ppes_entity_code | Char | 1 | Entity_Type_of_the_Provider | 2012 |
| ppes_provider_street1 | Char | 55 | Street_Address_1_of_the_Provider | 2012 |
| ppes_provider_street2 | Char | 55 | Street_Address_2_of_the_Provider | 2012 |
| ppes_provider_city | Char | 40 | City_of_the_Provider | 2012 |
| ppes_provider_zip | Char | 20 | Zip_Code_of_the_Provider | 2012 |
| ppes_provider_state | Char | 2 | State_Code_of_the_Provider | 2012 |
| ppes_provider_country | Char | 2 | Country_Code_of_the_Provider | 2012 |
| rovider_type | Char | 55 | Provider_Type_of_the_Provider | 2012 |
| edicare_participation_indicator | Char | 1 | Medicare_Participation_Indicator | 2012 |
| umber_of_hcpcs | Num | 8 | Number_of_HCPCS | 2012 |
| total_services | Num | 8 | Number_of_Services | 2012 |
| total_unique_benes | Num | 8 | Number_of_Medicare_Beneficiaries | 2012 |
| total_submitted_chrg_amt | Num | 8 | Total_Submitted_Charge_Amount | 2012 |
| total_medicare_allowed_amt | Num | 8 | Total_Medicare_Allowed_Amount | 2012 |
| otal_medicare_payment_amt | Num | 8 | Total_Medicare_Payment_Amount | 2012 |
| otal_medicare_stnd_amt | Num | 8 | Total_Medicare_Standardized_Payment_Amount | 2014 |
| drug_suppress_indicator | Char | 1 | Drug_Suppress_Indicator | 2012 |
| number_of_drug_hcpcs | Num | 8 | Number_of_HCPCS_Associated_With_Drug_Services | 2012 |
| total_drug_services | Num | 8 | Number_of_Drug_Services | 2012 |
| total_drug_unique_benes | Num | 8 | Number_of_Medicare_Beneficiaries_With_Drug_Services | 2012 |
| total_drug_submitted_chrg_amt | Num | 8 | Total_Drug_Submitted_2012 | 2012 |
| total_drug_medicare_allowed_amt | Num | 8 | Total_Drug_Medicare_Allowed_Amount | 2012 |
| total_drug_medicare_payment_amt | Num | 8 | Total_Drug_Medicare_Payment_Amount | 2012 |
| total_drug_medicare_stnd_amt | Num | 8 | Total_Drug_Medicare_Standardized_Payment_Amount | 2014 |
| med_suppress_indicator_ | Char | 1 | Medical_Suppress_Indicator | 2012 |
| number_of_med_hcpcs | Num | 8 | Number_of_HCPCS_Associated_With_Medical_Services | 2012 |
| total_med_services | Num | 8 | Number_of_Medical_Services | 2012 |
| total_med_unique_benes | Num | 8 | Number_of_Medicare_Beneficiaries_With_Medical_Services | 2012 |
| total_med_submitted_chrg_amt | Num | 8 | Total_Medical_Submitted_2012 | 2012 |
| total_med_medicare_allowed_amt | Num | 8 | Total_Medical_Medicare_Allowed_Amount | 2012 |
| total_med_medicare_payment_amt | Num | 8 | Total_Medical_Medicare_Payment_Amount | 2012 |
| total_med_medicare_stnd_amt | Num | 8 | Total_Medical_Medicare_Standardized_Payment_Amount | 2014 |
| beneficiary_average_age | Num | 8 | Average_Age_of_Beneficiaries | 2012 |
| beneficiary_age_less_65_count | Num | 8 | Number_of_Beneficiaries_Age_Less_65 | 2012 |
| beneficiary_age_65_74_count | Num | 8 | Number_of_Beneficiaries_Age_65_to_74 | 2012 |
| beneficiary_age_75_84_count | Num | 8 | Number_of_Beneficiaries_Age_75_to_84 | 2012 |
| beneficiary_age_greater_84_count | Num | 8 | Number_of_Beneficiaries_Age_Greater_84 | 2012 |
| beneficiary_female_count | Num | 8 | Number_of_Female_Beneficiaries | 2012 |
| beneficiary_male_count | Num | 8 | Number_of_Male_Beneficiaries | 2012 |
| beneficiary_race_white_count | Num | 8 | Number_of_Non-Hispanic_White_Beneficiaries | 2012 |
| beneficiary_race_black_count | Num | 8 | Number_of_Black_or_African_American_Beneficiaries | 2012 |
| beneficiary_race_api_count | Num | 8 | Number_of_Asian_Pacific_Islander_Beneficiaries | 2012 |
| beneficiary_race_hispanic_count | Num | 8 | Number_of_Hispanic_Beneficiaries | 2012 |
| beneficiary_race_natind_count | Num | 8 | Number_of_American_Indian/Alaska_Native_Beneficiaries | 2012 |
| beneficiary_race_other_count | Num | 8 | Number_of_Beneficiaries_With_Race_Not_Elsewhere_Classified | 2012 |
| beneficiary_nondual_count | Num | 8 | Number_of_Beneficiaries_With_Medicare_Only_Entitlement | 2012 |
| beneficiary_dual_count | Num | 8 | Number_of_Beneficiaries_With_Medicare_&_Medicaid_Entitlement | 2012 |
| beneficiary_cc_afib_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Atrial_Fibrillation | 2012 |
| beneficiary_cc_alzrdsd_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Alzheimer’s_Disease_or_Dementia | 2012 |
| beneficiary_cc_asthma_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Asthma | 2012 |
| beneficiary_cc_cancer_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Cancer | 2012 |
| beneficiary_cc_chf_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Heart_Failure | 2012 |
| beneficiary_cc_ckd_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Chronic_Kidney_Disease | 2012 |
| beneficiary_cc_copd_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Chronic_Obstructive_Pulmonary_Disease | 2012 |
| beneficiary_cc_depr_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Depression | 2012 |
| beneficiary_cc_diab_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Diabetes | 2012 |
| beneficiary_cc_hyperl_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Hyperlipidemia | 2012 |
| beneficiary_cc_hypert_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Hypertension | 2012 |
| beneficiary_cc_ihd_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Ischemic_Heart_Disease | 2012 |
| beneficiary_cc_ost_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Osteoporosis | 2012 |
| beneficiary_cc_raoa_percent | Num | 8 | Percent_(%)of_Beneficiaries_Identified_With_Rheumatoid_Arthritis/_Osteoarthritis | 2012 |
| beneficiary_cc_schiot_percent | Num | 8 | Percent_(%)of_Beneficiaries_Identified_With_Schizophrenia/_Other_Psychotic_Disorders | 2012 |
| beneficiary_cc_strk_percent | Num | 8 | Percent_(%)_of_Beneficiaries_Identified_With_Stroke | 2012 |
| Beneficiary_Average_Risk_Score | Num | 8 | Average_HCC_Risk_Score_of_Beneficiaries | 2012 |
CMS Physician and Other Supplier Public Use File data dictionary