Others titles

  • CMS Prescription Drug Profiles PUFs
  • Prescription Drug Profiles PUF

Keywords

  • Medicare Drugs Claims
  • Prescription Drug Profiles
  • Medicare Prescription Drug Claims
  • Medicare Beneficiaries Part D Payments
  • Prescription Drug Plans
  • Medicare Prescription Drug Payments
  • PUF Data
  • Prescription Drugs File
  • Drug Information
  • Part D Drug Event Files

Medicare Prescription Drugs Claims

This de-identified dataset contains details 100% of the prescription drug claims made by Medicare beneficiaries during the year of release. This dataset is part of the Public Use Files (PUFs) released by the Centers for Medicare & Medicaid Services (CMS), which are public domain de-identified data files available for research with claim-specific information. The purpose of these files is to provide information while protecting confidentiality.

Log in to download
Complexity

Get The Data

For getting access to data download links please read and accept the end-user license agreement.
Your Data License
  • Research
    Non-Commercial, Share-Alike, Attribution Free Forever
  • Commercial
    Commercial Use, Remix & Adapt, White Label Log in to download

John Snow Labs Standard End User License Agreement

Last updated:January 20, 2021

This Standard End User License Agreement (“EULA”) applies to customers of John Snow Labs Inc. (as defined below), using any product of John Snow Labs Inc. on John Snow Labs Marketplace as defined below (hereinafter referred to “you”) and John Snow Labs Inc., a Delaware corporation (“John Snow Labs”, “we” or “us”).

By downloading, installing, and/or using (as applicable) any Product of John Snow Labs (as defined below), you automatically agree to be bound by, and use our Products in compliance with, this EULA. This EULA, together with additional terms and conditions and/or policies referenced herein or located on https://www.johnsnowlabs.com and/or conveyed to you by John Snow Labs, is a legally binding contract between you and John Snow Labs.

PLEASE READ THIS EULA CAREFULLY BEFORE PURCHASING, INSTALLING OR USING OUR PRODUCTS MADE AVAILABLE ON JOHN SNOW LABS MARKETPLACE.

We may make changes to this EULA from time to time. When we do so, we will revise the “last updated” date given above. The then-current version of this EULA will supersede all earlier versions. You agree that your continued use of our Products after such changes have been published to our EULA will constitute your acceptance of such revised EULA.

Definitions

“John Snow Labs Data Library” means a data library located at https://www.johnsnowlabs.com;

“Products” means products and services of John Snow Labs that you download and use from listings in John Snow Labs Data Library;

Important Notice

By installing and using our Products, you acknowledge that the use of the Products can be subject to the restrictions and controls imposed by United States export regulations.

You represent and warrant that you do not intend to use the Products for any purpose prohibited by United States export regulations, including, without limitation, terrorism, cyber-attacks, cyber-crimes, money-laundering, industrial espionage, or nuclear, chemical or biological weapons proliferation. Further, you represent and warrant that you are not listed as a denied party on any list governing United States exports.

Eligibility

Our Products can be used by an individual, business or other legal entity, or both. If you are entering into this EULA, or using the Products, on behalf of a company or other legal entity, you represent that you have the authority to bind such entity to this EULA, in which case “you” shall refer to such entity.

In the event you have entered into a separate written agreement with John Snow Labs regarding the Products that contemplates terms that are inconsistent with this EULA, the written agreement shall control and this EULA will not apply to you to the extent inconsistent with such written agreement, or, if such written agreement is contemplated to be in lieu of this EULA, then this EULA shall not apply at all.

Your Access and Use

Subject to your compliance with this EULA, as well as any other applicable policies, John Snow Labs grants you non-exclusive, non-transferable, license to install, access to, modify, and use of, the Products worldwide (subject to applicable export laws) during the term of this EULA (as described below) solely for research, private study and personal use of Products.

This license is personal to you, and you may not resell our Products, permit other users access to our Products through your account. Your right to use our Products is limited by all terms and conditions set forth in this EULA.

Except for your pre-existing rights and this license granted to you, we and our licensors retain all rights, titles and interests in and to our Products, all related intellectual property rights, including trademarks (whether registered or pending), domain and business names. Our Products are protected by applicable intellectual property laws, including United States copyright law and international treaties.

Except for the foregoing license, you have no other rights in the Products and you may not modify, edit, copy, reproduce, create derivative works of, reverse engineer, alter, enhance or in any way exploit the Products in any manner. If you breach any of this EULA, the above license will terminate automatically.

You will be deemed to have taken any action that you permit, assist or facilitate any person or entity to take related to this EULA, your content or use of the Products. You are responsible for end users’ use of your content and the Products. You will ensure that all end users comply with your obligations under this EULA and that the terms of your agreement with each end user are consistent with this EULA. If you become aware of any violation of your obligations under this EULA caused by an end user, you will immediately suspend access to your content and the Products by such end user. We do not provide any support or services to end users unless we have a separate agreement with you or an end user obligating us to provide such support or services.

Restrictions

You will access or use our Products solely via John Snow Labs Data Library.

Except as otherwise explicitly provided in this EULA or as may be expressly permitted by applicable law, you will not, and will not permit or authorize any third party to:

  1. reproduce, modify, translate, enhance, decompile, disassemble, reverse engineer or create derivative works of any of our Products or its technological features or measures;
  2. rent, lease, sell, resell, loan, distribute, or sublicense access to any of our Products;
  3. circumvent or disable any security or technological features or measures of our Products;
  4. use our intellectual property rights without our express prior written authorization;
  5. use our Products for more than one trial period, unless the trial period is extended by John Snow Labs’ prior written permit;
  6. use our Products with an intent to build a competitive product or service, or copy or substantially copy any ideas, features, functions, organization, structure, application program interface, graphics, or user interface of the Products;
  7. store, copy, modify, distribute, or resell any of the information; audio, visual, and audiovisual works, or other content made available on our Products (collectively, “Content”) or compile or collect any Content as part of a database or other work;
  8. use any automated tool (e.g., robots, spiders) to access or use our Products, or to store, copy, modify, distribute, or resell any Content;
  9. circumvent or disable any rights management, usage rules, or other security features of our Products;
  10. use our Products in a manner that overburdens, or that threatens the integrity, performance, or availability of, our Products; or
  11. remove, alter, or obscure any proprietary notices (including copyright and trademark notices) on any portion of our Products or any Content.

Fees and Taxes

Your use of the Products is subject to our fees. All fees are given on our website https://www.johnsnowlabs.com. Except as set forth in this EULA, the fees are non-refundable. We are entitled to revise our fees from time to time.

The fees exclude any federal, state or local taxes, VAT, GST, or similar taxes. You are responsible for identification and payment of all taxes as required by applicable law.

Term and Termination

This EULA will become effective as of the date of your order of Products and shall be in effect until terminated.

John Snow Labs may suspend or terminate your right to use our Products, if you or your end user’s use of the Products:

  1. is in breach of this EULA;
  2. poses a security risk to our Products;
  3. could adversely impact our systems, the Products or other customers;
  4. could subject us, our affiliates, or any third party to liability; or
  5. could be fraudulent.

We may also suspend or terminate your right to use our Products, if you fail to perform your payment obligations, or you have ceased to operate in the ordinary course, made an assignment for the benefit of creditors or similar disposition of your assets, or become the subject of any bankruptcy, reorganization, liquidation, dissolution or similar proceeding.

We may also suspend or terminate your right to use our Products without any reason upon a relevant 30 days’ written notice to you and will refund the unused fees pre-paid by you for access to the Products for the affected time period (if any). Where your access is suspended or terminated by the breach of this EULA or applicable laws, John Snow Labs will will not provide, or be liable for, any refund.

You will cease use of the Products during any period of suspension, or upon termination of this EULA.

All provisions which by their nature are intended to survive termination shall survive termination of this EULA.

Support

If applicable to your Product, John Snow Labs will provide you with the support services. If you use a trial access, support services are excluded. Under this EULA, our support services exclude any installation, training, maintenance services (including any error corrections, bug fixes, or new releases), technical assistance, consulting services, or other services of any kind. Such services are provided at John Snow Labs’ discretion.

From time to time John Snow Labs can perform updates to our software. If available, such updates may include bug fixes, new features and/or enhancements. You are solely responsible for deploying such updates at your own risk and liability.

Access to our Products

We do not provide you with the equipment to access our Products. You are responsible for all fees charged by third parties related to your access and use of our Products (e.g., charges by Internet service providers).

You are responsible for monitoring your use of the Products, including payment of all fees and/or taxes related to such access and use. You agree that John Snow Labs is permitted to request and you hereby consent to provide John Snow Labs information related to your use of the Products for auditing purposes.

You also certify that you are legally permitted to use the Products, and take full responsibility for the selection and use of the Products. This EULA is void where prohibited by law, and the right to use the Products is revoked in such jurisdictions. John Snow Labs makes no claim that the Products may be lawfully used outside of the United States. If you use the Products from outside of the United States, you do so at your own risk and you are responsible for compliance with the laws of jurisdiction.

Privacy Policy

We may collect, store and receive personal and other information about you through our Products. Our collection and use of this information is governed by our Privacy Policy available at https://www.JohnSnowLabs.com/privacy/ which may be amended from time to time.

Links and Third Party Content

Our Products may display, or contain links to, third party products, services, and websites. Any opinions, advice, statements, services, offers, or other information that constitutes part of the content expressed, authored, or made available by other users or other third parties, or which is accessible through or may be located using our Products (collectively, “Third Party Content”) are those of the respective authors or producers and not of us or our shareholders, directors, officers, employees, agents, or representatives.

We do not control Third Party Content and do not guarantee the accuracy, integrity or quality of such Third Party Content. We are not responsible for the performance of, we do not endorse, and we are not responsible or liable for, any Third Party Content or any information or materials advertised in any Third Party Content. By using our Products, you may be exposed to content that is offensive, indecent, or objectionable. We are not responsible or liable, directly or indirectly, for any damage or loss caused to you by your use of or reliance on any goods, services, or information available on or through any third party service or Third Party Content. It is your responsibility to evaluate the information, opinion, advice, or other content available on and through our Products.

Proprietary Rights

John Snow Labs will not obtain any rights under this EULA from you (or your licensors) to your content.

The Products, including software, is and remains the exclusive property of John Snow Labs and its licensors. Except for the access and use rights expressly set forth in this EULA, no license or other rights in or to the Products or John Snow Labs trademark(s) and other intellectual property rights therein, are granted to you, and all such licenses and rights are expressly reserved. You will not remove, alter, or obscure any proprietary notices (including copyright and trademark notices) on any portion of our Products or any Content.

Trademarks

“John Snow Labs,” the John Snow Labs logo, and any other product, business or service name or slogan, whether registered or pending, displayed on our Products are trademarks of John Snow Labs, Inc. or its suppliers or licensors, and may not be copied, imitated or used, in whole or in part, without the prior written permission of John Snow Labs or the applicable trademark holder. You may not use any metatags or any other “hidden text” utilizing “John Snow Labs” or any other name, trademark or product, business or service name of John Snow Labs without our prior written permission. In addition, the look and feel of our Products, including all page headers, custom graphics, button icons and scripts, is the service mark, trademark and/or trade dress of John Snow Labs and may not be copied, imitated or used, in whole or in part, without our prior written permission. All other trademarks, pending trademarks, registered trademarks, product names and company names or logos mentioned in our Products are the property of John Snow Labs Inc. and/or their respective owners. Reference to any products, services, processes or other information, by trade name, trademark, manufacturer, supplier, or otherwise does not constitute or imply endorsement, sponsorship, or recommendation thereof by us.

Disclaimer of Warranties

YOUR USE OF THE PRODUCTS IS AT YOUR SOLE RISK. THE PRODUCTS AND CONTENT EACH ARE PROVIDED ON AN “AS IS” AND “AS AVAILABLE” BASIS. WE AND OUR SUPPLIERS AND LICENSORS EXPRESSLY DISCLAIM ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, AND NON-INFRINGEMENT. WE DO NOT GUARANTEE THE ACCURACY, COMPLETENESS, OR USEFULNESS OF THE PRODUCTS OR ANY CONTENT, AND YOU RELY ON THE PRODUCTS AND CONTENT AT YOUR OWN RISK. ANY MATERIAL THAT YOU ACCESS OR OBTAIN THROUGH OUR PRODUCTS IS DONE AT YOUR OWN DISCRETION AND RISK AND YOU WILL BE SOLELY RESPONSIBLE FOR ANY DAMAGE TO YOUR COMPUTER OR LOSS OF DATA THAT RESULTS FROM THE DOWNLOAD OF ANY MATERIAL THROUGH OUR PRODUCTS. NO ADVICE OR INFORMATION, WHETHER ORAL OR WRITTEN, OBTAINED BY YOU FROM US OR THROUGH OR FROM OUR PRODUCTS WILL CREATE ANY WARRANTY NOT EXPRESSLY STATED IN THIS EULA. SOME STATES MAY PROHIBIT A DISCLAIMER OF WARRANTIES AND YOU MAY HAVE OTHER RIGHTS THAT VARY FROM STATE TO STATE.

Limitation of Liability

WE AND OUR SUPPLIERS AND LICENSORS WILL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR EXEMPLARY DAMAGES, INCLUDING BUT NOT LIMITED TO, DAMAGES FOR LOSS OF PROFITS, GOODWILL, USE, DATA, OR OTHER INTANGIBLE LOSSES (EVEN IF WE HAVE BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), RESULTING FROM YOUR USE OF OUR PRODUCTS AND CONTENT. UNDER NO CIRCUMSTANCES WILL THE TOTAL LIABILITY OF US AND OUR SUPPLIERS AND LICENSORS OF ALL KINDS ARISING OUT OF OR RELATED TO YOUR USE OF THE PRODUCTS AND CONTENT (INCLUDING BUT NOT LIMITED TO WARRANTY CLAIMS), REGARDLESS OF THE FORUM AND REGARDLESS OF WHETHER ANY ACTION OR CLAIM IS BASED ON CONTRACT, TORT, OR OTHERWISE, EXCEED THE AMOUNTS, IF ANY, THAT YOU HAVE PAID FOR YOUR USE OF THE PRODUCTS AND CONTENT. BECAUSE SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.

Indemnity

To the full extent permitted by applicable law, you shall defend, indemnify and hold harmless John Snow Labs, its affiliates and its licensors, and each of their respective employees, officers, directors, and representatives from and against any claims, damages, losses, liabilities, costs, and expenses (including reasonable attorney’s fees) arising out of or relating to any third party claim concerning: (a) your use of the Products; (b) breach of this EULA or violation of applicable law by you; (c) any content or the combination of such content with other software, content or processes, including any claim involving alleged infringement or misappropriation of third-party rights by such content or combination; or (d) breach of any obligation or duty you owe to a third party.

Legal Notices

Enforcement of this EULA will be governed by the laws of the State of Delaware, excluding its conflict and choice of law principles. The exclusive jurisdiction and venue for any claims arising out of or related to this EULA or your use of the Products will lie in the state and federal courts located in Sussex County, within the State of Delaware, and you irrevocably agree to submit to the jurisdiction of such courts. Our failure to enforce any right or provision in this EULA will not constitute a waiver of such right or provision unless acknowledged and agreed by us in writing. In the event that a court of competent jurisdiction finds any provision of this EULA to be illegal, invalid, or unenforceable, the remaining provisions will remain in full force and effect.

Notifications

We may use your contact information to notify you if we have any legitimate interest or if we need to notify you on any important information related to your use of Products. We will not send you newsletters unless you expressly consented to such notifications.

Contacting Us

If you have any questions or concerns about our Products or this EULA, you may contact us by email at support@JohnSnowLabs.com.

Description

The Prescription Drug Profiles are collected from Medicare prescription drug claims for the year of the prescription filling. They include beneficiary demographics, plan characteristics, drug characteristics, prescriber characteristics and payment information. Each record corresponds to a profile or cell defined by the characteristics of the previously mentioned variables. The dataset contains all the prescription drug claims during the year for Medicare beneficiaries of Part D.

Prescription drug events (or Part D Drug Event Files) are merged with the following files to construct the Prescription Drug Profiles PUF for the reference year:

Beneficiary Summary File;
Part D Plan Characteristics File;
Part D Prescriber Characteristics File;
RxNorm, available from the U.S National Library of Medicine, National Institutes of Health;
National Formulary, available from the Department of Veterans Affairs; and
Results of the CMS-RxHCC risk-adjustment model.

Reference: CMS. (2013). CMS.gov. Retrieved 4 April, 2016.

About this Dataset

Data Info

Date Created

2008

Last Modified

2010

Version

2010

Update Frequency

Irregular

Temporal Coverage

2010

Spatial Coverage

United States

Source

John Snow Labs; Centers for Medicare and Medicaid Services (CMS);

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Medicare Drugs Claims, Prescription Drug Profiles, Medicare Prescription Drug Claims, Medicare Beneficiaries Part D Payments, Prescription Drug Plans, Medicare Prescription Drug Payments, PUF Data, Prescription Drugs File, Drug Information, Part D Drug Event Files

Other Titles

CMS Prescription Drug Profiles PUFs, Prescription Drug Profiles PUF

Data Fields

Name Description Type Constraints
Beneficiary_Age_Category_CodeThis categorical variable is based on the beneficiary's age at end of the reference year (2010). In the event the beneficiary died during the reference year, the age at the date of death is used. It is based on the BENE_AGE_AT_END_REF_YR variable in the Beneficiary Summary File (BSF). 1=Under 65, 2=65-69, 3=70-74, 4=75-79, 5=80-84, 6=85 & older.integerlevel : Nominal
RxNorm_Concept_Unique_IdentifierThis variable indicates the corresponding drug's RxNorm RxCUI (RxNorm Concept Unique Identifier). RxNorm is a normalized naming system for generic and branded drugs produced by the National Library of Medicine. The PUF contains 1,229 distinct RXCUIs (including "missing" identified by a value of 0). The table below provides the frequency of the corresponding RxNorm RxCUI for the top ten drug names. It is determined by matching the PROD_SRVC_ID variable in the PDE File with the National Drug Code (NDC) in RxNorm. 36567= Simvastatin, 10582= Thyroxine, 6918=Metoprolol, 29046=Lisinopril, 214182=Acetaminophen/Hydrocodone, 17767=Amlodipine, 7646=Omeprazole, 4603=Furosemide, 6809=Metforminintegerlevel : Nominal
Drug_Major_ClassThis categorical field indicates the major class of the drug. This variable is created using the VA_CLASS variable in the Veterans Affairs National Drug File (VA‐NDF) database. The DRUG_MAJOR_CLASS group's drugs into major (Level 0) categories based on mechanism and effect. The PUF contains 30 distinct drug classes (including "missing" identified by a value of 0). The ten most frequent values for major drug class and their frequencies are provided below. CV000=Cardiovascular medications, CN000= Central Nervous System Medications, HS000=Hormones/Synthetics/Modifiers, GA000= Gastrointestinal Medications, AM000= Antimicrobials, MS000= Musculoskeletal Medications, BL000= Blood Products/Modifiers/Volume Expanders, RE000= Respiratory Tract Medications, OP000= Ophthalmic Agents.string-
Drug_ClassThis categorical field indicates the class of the drug. This variable is created using the VA_CLASS variable in the VA‐NDF database. The DRUG_CLASS group's drugs into minor (Level 1) categories based on mechanism and effect. The PUF contains 263 distinct drug classes (including "missing" identified by a value of 0). The ten most frequent values for drug class and their frequencies are provided below. CV350= Antilipemic Agents, CV100= Beta Blockers/Related, CN609= Antidepressants, CN101=Analgesics, HS502=Blood Glucose Regulation Agents, CV800=Ace Inhibitors, CV200=Calcium Channel Blockers, GA900=Gastric Medications, Other, HS851=Thyroid Modifiers.string-
Drug_Type_ClassThis categorical field indicates the type of the drug: unknown, generic drug, or brand name drug. It is determined by matching the PROD_SRVC_ID variable in the PDE File with the National Drug Code (NDC) in RxNorm. 1=Brand name, 2=Generic Name.integerlevel : Nominal
Plan_TypeThis categorical variable indicates the type of plan associated with events in the profile. It is derived from the Contract_ID code in the Part D Plan Characteristics File. This field summarizes plan type in four categories: (1) Prescription Drug Plans (PDP) (Contract_ID starts with letter “S”), (2) Medicare Advantage Part D (Contract_ID starts with letter “H” or “R”), (3) Other Plan (Contract_ID starts with letter “E”).integerlevel : Nominal
Coverage_TypeThis categorical variable indicates beneficiary liability of cost‐sharing. The beneficiary cost share group code associated with each event is taken from the month in which the event is recorded. This variable is created using the CST_SHR_GRP_CD_01 to CST_SHR_GRP_CD_12 variables in the Beneficiary Summary File. Cost‐sharing codes are classified into five categories: (1) Dual Eligible (variable values of 01, 02 or 03 in the month of the event), (2) Low Income Subsidy (LIS) (variable values of 04, 05, 06, 07, or 08 in the month of the event), (3) No Subsidy (variable values of 00, XX, 09, 10, 11, 12 or 13 in the month of event)integerlevel : Nominal
Benefit_PhaseIndicates the benefit phase in which the claim was expected to occur based on a data of service ordering of the beneficiary's claims, the beneficiary's accumulated gross drug and out‐of‐pocket costs, and the plan's deductible, initial coverage limit (ICL) and out‐of‐pocket threshold (OOPT) amount. This variable is created using the BENEFIT_PHASE variable in the PDE File. 1=Catastrophic, 2=Deductible, 3=Initial coverage limit, 4=Non-covered drug, 5=Pre-initial coverage limit.integerlevel : Nominal
Drug_Benefit_TypeIndicates the type of Part D benefit structure used by the plan benefit package. This variable is created using the DRUG_BENEFIT_TYPE variable in the Part D Plan Characteristics File. 1=Defined standard, 2=Actuarially equivalent, 3=Basic Alternative, 4=Enhanced alternative.integerlevel : Nominal
Prescriber_TypeThis categorical field indicates the type of the prescriber. This variable is created using the PRIMARY_TAXONOMY_CD variable in the Prescriber Characteristics File. It is based on the National Uniform Claims Committee (NUCC) taxonomy code reported as primary by the prescriber in the National Plan & Provider Enumeration System (NPPES) database. Prescriber codes are classified into five categories 1=Family Medicine, 2=Internal medicine, 3=Psychiatry & neurology, 4=Specialist, 5=Other.integerlevel : Nominal
Gap_CoverageIndicator for whether the plan benefit package offers gap coverage. This variable is created using the GAP_COVERAGE variable in the Part D Plan Characteristics File. It summarizes gap coverage as: (1) No gap coverage (variable values of "N"), (2) Offers gap coverage (all other variable values).integerlevel : Nominal
Tier_IDThis variable represents the minimum cost sharing tier in which the product was placed in the sponsor's formulary. This variable is created using the TIER_ID variable in the PDE File. As each plan may have different tier definitions, descriptions for variable values 1‐6 are left blank.integerlevel : Nominal
Mean_RXHCC_ScoreThis is the average of the RxHCC score associated with each beneficiary with a prescription drug event in the profile. The RxHCC score is created by the CMS‐RxHCC risk‐adjustment model. The model assigns a risk score to reflect the health status of each beneficiary according to demographic variables and the beneficiary’s diagnosis history. A higher risk score correlates to higher estimated costs for a beneficiary. Payments to Medicare Part D Plans are adjusted by CMS according to the risk scores of the beneficiaries.numberlevel : Ratio
Average_Days_SupplyThis is the arithmetic average number of days' supply of medication dispensed by the pharmacy for all events in profile. This variable is created using the DAYS_SUPLY_NUM variable in the PDE file. The following summary shows the average number of days' supply rounded to the nearest day.numberlevel : Ratio
Average_Total_Drug_CostThis is the arithmetic average dollar amount for all events in the profile on the entire cost of the prescription based on the sum of ingredient cost paid, dispensing fee paid, and total amount attributed to sales tax. This variable is created using the TOT_RX_CST_AMT variable in the PDE file. The following summary shows the average total drug cost rounded to the nearest dollar.numberlevel : Ratio
Average_Patient_Payment_AmountThis is the arithmetic average dollar amount for all events in the profile on what the beneficiary paid that is not reimbursed by a third party (e.g., copayments, coinsurance, deductible or other patient pay amounts). This variable is created using the PTNT_PAY_AMT variable in the PDE file. The following summary shows the average patient payment amount rounded to the nearest dollar.numberlevel : Ratio
PartD_Event_CountThis variable contains the number of Part D events associated with each profile. The sum of this variable (1,110,089,154) is the total number of Part D events for the 100% population of Fee‐ for‐Service beneficiaries in 2010.integerlevel : Ratio
Beneficiary_Count_CategoryThis variable is based on the number of unique beneficiaries associated with the profile. It is categorized into six values. 1=11-15, 2=16-20, 3=21-50, 4=51-100, 5=101-500, 6=501+.integerlevel : Nominal

Data Preview

Beneficiary Age Category CodeRxNorm Concept Unique IdentifierDrug Major ClassDrug ClassDrug Type ClassPlan TypeCoverage TypeBenefit PhaseDrug Benefit TypePrescriber TypeGap CoverageTier IDMean RXHCC ScoreAverage Days SupplyAverage Total Drug CostAverage Patient Payment AmountPartD Event CountBeneficiary Count Category
1124.434.4271
111.01.46628.2561.0382
111.01.02.01.70525.7218.2472
111.01.02.01.01.01.85516.415.5473
111.01.02.01.02.01.95935.258.71173
111.01.02.02.01.01.92914.318.8824
111.01.02.02.02.02.054000000000000331.840.52044
111.01.02.02.03.02.19328.5201.7171
111.01.02.05.01.6325.6103.0553
111.01.02.05.01.8129.1841.0361