Outpatient Medication Fills Aggregator for URSA-PHARM Concepts

Definition

One record per outpatient medication fill based on a pharmacy claim or EMR pharmacy fill record; MDM record matching logic here generates a Lifetime Medication Treatment Episode ID for each fill that allows linking fills with the same patient-ingredient over the lifetime of the patient.

Purpose

Used in the URSA-PHARM module to identify key attributes of Outpatient Medication Fills.

Related objects

• Outpatient Medication Fills Aggregator for URSA-PHARM Concepts
• Data Mart for Targeted Medication Therapy Episodes
• Patient Timelines for URSA-PHARM Concepts
• Pharmacy Claims

Detailed narrative of logic

1. This logic begins by integrating pharmacy claims in the URSA-CORE Pharmacy Claims natural object, which is one row per non-reversed pharmacy claim, including denied claims, with the Medication Dispensing Providers synthetic object, which One record per pharmacy provider or non-pharmacy dispensing provider, based on primary NUCC provider taxonomy code and/or including any provider listed as a filling provider on a pharmacy claim.
2. Next, module-specific flags are added for targeted medications based on AHFS Code, generic ingredient, or both. Targeted medications
3. Flags are also generated for brand versus generic medication type which can is derived from available information from first the claims and second Red Book NDC reference data, this flag indicates a medication created to be the same as an already marketed brand-name drug in dosage form, safety, strength, route of administration, quality, performance characteristics, and intended use.