[SO/URSA-PHARM] Outpatient Medication Fills Aggregator for URSA-PHARM Concepts

Object Description

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.

Metadata

• Table Name: ursa.so_ursa_pharm_meds_001
• Layer: SYNTHETIC_OBJECT
• Object Type: Integrator
• Temporal Class: Event
• Case ID: Document ID
• Event Date: Filled Date
• Primary Key: Document ID

Published Fields

• Data Model Keys

  • Document ID -- The internal database identifier (used, e.g., for joins and primary keys) for the document. (See also [URSA-CORE] Document)
  • Claim ID -- The internal database identifier (used, e.g., for joins and primary keys) for the claim. (See also [URSA-CORE] Claim)
  • Patient ID -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
  • Filling Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the filling provider.
  • Prescribing Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the prescribing provider. (See also [URSA-CORE] Prescribing Provider)

• Operations Support Fields

  • Prescription Number -- The unique, user-facing (“real-world”) identifier used by operational systems or staff to identify the medication order. (See also [URSA-CORE] Medication Order)

• Date Fields

  • Filled Date -- The date a prescription or medication order was filled, with medications dispensed.

• Provider Fields

  • Prescribing Provider NPI -- The 10-digit National Provider Identifier for the prescribing provider. (See also [URSA-CORE] Prescribing Provider)
  • Filling Provider NPI -- The 10-digit National Provider Identifier for the filling provider. (See also [URSA-CORE] Filling Provider)
  • Filling Provider Description -- The natural language description of the filling provider. (See also [URSA-CORE] Filling Provider)
  • Filling Provider State Abbreviation
  • Filling Provider ZIP Code 5-Digit
  • Filling Provider Primary NUCC Provider Taxonomy Code -- The primary NUCC Provider Taxonomy code for the filling provider. (See also [URSA-CORE] Filling Provider, [URSA-CORE] Primary NUCC Provider Taxonomy Code)
  • Filling Provider Primary NUCC Provider Taxonomy Description -- The primary NUCC Provider Taxonomy description for the filling provider. (See also [URSA-CORE] Filling Provider, [URSA-CORE] Primary NUCC Provider Taxonomy Description)
  • Is Filling Provider Specialty Pharmacy -- A pharmacy that dispenses generally low volume and high cost medicinal preparations to patients who are undergoing intensive therapies for illnesses that are generally chronic, complex and potentially life threatening. Often these therapies require specialized delivery and administration.
  • Is Filling Provider Mail Order Pharmacy -- Indicates the filling provider is a mail-order pharmacy. (See also [URSA-CORE] Filling Provider)

• Medication Fields

  • NDC Code 11-Digit -- The standard 11-digit National Drug Code; e.g., 00045012400 = Tylenol 500 mg.
  • Label Description -- Supplies the name given to the product by the manufacturer.
  • Active Ingredients Description -- A natural language description of the medication's biologically active ingredient(s). For medications with multiple active ingredients, the active ingredients should be listed in alphabetical order.
  • Primary Agent Description -- The primary active ingredient in the medication. In medications with multiple active ingredients, this identifies by name only the primary agent.
  • Form Description -- The natural language description of the medication's form. (See also [URSA-CORE] Medication Form)
  • Route of Administration Description -- The natural language description of the medication's route of administration.
  • Is OTC -- Indicates that the medication is an over-the-counter (OTC) drug that does not require a prescription.
  • AHFS Therapeutic Class Code 6-Digit -- The standard 6-digit AHFS Pharmacologic-Therapeutic Class Code, representing the first 3 tiers of the AHFS Pharmacologic-Therapeutic Classification system. The code is expressed as 6 numbers, without special characters delimiting the tiers, with leading and trailing zeros as needed. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
  • AHFS Therapeutic Class Tier 1 Description -- The natural language description of the first-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
  • AHFS Therapeutic Class Tier 2 Description -- The natural language description of the second-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
  • AHFS Therapeutic Class Tier 3 Description -- The natural language description of the third-tier category within the AHFS Therapeutic Classification System that the medication is assigned to. (See also [URSA-CORE] AHFS Pharmacologic-Therapeutic Classification System)
  • Red Book Generic Cross Reference Code -- A unique 6-digit code assigned to all products that contain the same set of active ingredients. By extracting all records containing this code, users can identify comparable products regardless of trade or generic name. (See also [URSA-CORE] Red Book Generic Formulation Code)
  • Red Book Generic Formulation Code -- A unique 6-digit code identifying drugs with common active ingredients, master dosage form, strength, and route of administration. The GFC is not manufacturer or package size specific, and can therefore be used in preparation of drug utilization reports and analysis of generic alternatives for substitution and formulary development. The GFC may also be used within pharmacy and claims administration systems as an efficient means of linking NDC numbers to clinical screening functions. (See also [URSA-CORE] Red Book Generic Cross Reference Code)
  • Medi-Span GPI Code 14-Digit -- The 14-digit Medi-Span Generic Product Identifier (GPI) for the medication. The GPI is a 7-level hierarchical classification, with each level represented by two digits in the GPI. The full 14-digit GPI describes a medication's class, ingredients, dosage form, and strength. GPI values should include leading and trailing zeros and should not include hyphens or other special characters.
  • Quantity Dispensed -- The quantity of medication dispensed in the fill. For medications with discrete forms (e.g., tablets, capsules, etc.) this is the number of those discrete units dispensed. For non-discrete forms (e.g., solution, cream, etc.) this is some other measure of quantity, including (but not necessarily) the number of doses dispensed.
  • Days Supply -- The number of calendar days, including the date the medication was dispensed, the dispensed medication will last at the patient's intended dosage as defined in their prescription.
  • NCPDP Dispense as Written Code -- The standard 1-digit Dispense as Written (DAW) code developed and maintained by the National Council for Prescription Drug Programs (NCPDP), identifying the types of substitutions, if any, the pharmacy can make when filling the prescription; e.g., 1 = Substitution not allowed by prescriber.
  • Is Naloxone

• Financial Fields

  • Total Paid Amount
  • Plan Paid Amount
  • COB Paid Amount
  • Patient Paid Amount

• Module Fields

  • Is Chronic Medication
  • Is Antidepressant
  • Is Antineoplastic
  • Is Antidiabetic
  • Is Oral Antidiabetic
  • Is Oral ACEI/ARB
  • Is Statin
  • Is Beta Blocker
  • Is Sacubitril/Valsartan
  • Is Anticoagulant
  • Is Cardiac Glycosides
  • Is Insulin
  • Is Opiate Agonists
  • Is Oral Antiplatelet
  • Is Oral Hypoglycemic
  • Is CMS Star Measures Oral Antidiabetic
  • Is CMS Star Measures Oral ACEI/ARB
  • Is CMS Star Measures Statin
  • Is CMS Star Measures Sacubitril/Valsartan
  • Is CMS Star Measures Insulin
  • Is Generic
  • Is Single Source -- Indicates that the medication is considered to be available from only one source, often a brand-name product with no available generic alternatives or a generic for which a single company holds the patent and has sole rights to sell to consumers. (See also [URSA-PHARM] Is Generic)
  • Ingredients Hash
  • Provider Fill Volume Percentile Rank
  • Provider Fill Volume Quintile Category
  • Is Filling Provider Major Chain
  • Filling Provider Major Chain Description

Foreign Keys

• document_id → ursa.no_ursa_core_fin_004.document_id
• claim_id → ursa.no_ursa_core_fin_004.claim_id
• pat_id → ursa.no_ursa_core_pat_001.pat_id
• filling_prov_id → ursa.no_ursa_core_prov_001.prov_id
• prescribing_prov_id → ursa.no_ursa_core_prov_001.prov_id