[DM/URSA-PHARM] Data Mart for Targeted Medication Therapy Episodes

Object Description

One record per Medication Therapy Episode (continuous period of time during which the patient is in supply, or in a gap of supply fewer than 30 days) for any Targeted Medication as defined by the URSA-PHARM module. Targeted Medications include any of the following types; antidepressants, antineoplastics, beta blockers, antidiabetics, ACEI/ARBs, statins, high-risk medications (anticoagulants, oral antiplatelets, cardiac glycosides, opiate agonists, oral hypoglycemics, insulin), and any other chronic medications.

Metadata

• Table Name: ursa.dm_ursa_pharm_003
• Layer: DATA_MART
• Object Type: Single Stack
• Temporal Class: Interval
• Case ID: Episode ID
• Interval Start Date: Episode Start Date
• Interval End Date: Episode End Date
• Primary Key: Episode ID

Published Fields

• Data Model Keys

  • Episode ID
  • 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)

• Date Fields

  • Episode Start Date
  • Episode End Date

• Episode Fields

  • Episode Length Days
  • Is Episode >= 90 Days
  • Episode Count Fills
  • Episode Aggregate Days Supply
  • Count Patient Episodes

• Module Fields

  • Episode Medication Class Category
  • Is Targeted for Chronic Status Only
  • Is Chronic Medication -- A medication meeting at least one of the following: (1) 3 or more fills over the history of the patient for this or other medications in the same AHFS Therapeutic Class ; (2) 90 or more days supply over the history of the patient for this or other medications in the same AHFS Therapeutic Class
  • Is Episode for Priority Adherence Medication
  • Is Antidepressant -- One of the Priority Adherence Medication types; a medication classified as an antidepressant based on AHFS Therapeutic Class code or Red Book Generic Cross Reference Code. (See also [URSA-PHARM] Is Priority Adherence Medication)
  • Is Antidiabetic -- One of the Priority Adherence Medication types; a medication classified as an antidiabetic based on AHFS Therapeutic Class code or Red Book Generic Cross Reference Code as an antidiabetic of any type (insulin, oral, etc.). (See also [URSA-PHARM] Is Priority Adherence Medication, [URSA-PHARM] Active Priority Adherence Medication Type Category)
  • Is Antineoplastic -- One of the Priority Adherence Medication types; a medication classified as an antineoplastic based on AHFS Therapeutic Class code. Antineoplastic drugs are medications used to treat cancer. Other names for antineoplastic drugs are anticancer, chemotherapy, chemo, cytotoxic, or hazardous drugs. (See also [URSA-PHARM] Is Priority Adherence Medication, [URSA-PHARM] Active Priority Adherence Medication Type Category)
  • Is Oral ACEI/ARB -- One of the Priority Adherence Medication types; indicates a medication classified as a angiotensin-converting enzyme inhibitor (ACEI) and an angiotensin receptor blocker (ARB) based on the Red Book Generic Cross Reference code and/or NDC being included in the CMS Stars measure specifications for Oral ACEI/ARB PDC measures. (See also [URSA-PHARM] Is Priority Adherence Medication, [URSA-PHARM] Active Priority Adherence Medication Type Category)
  • Is Beta Blocker -- One of the Priority Adherence Medication types; indicates a medication classified as a beta blocker based on the Red Book Generic Cross Reference Code classification. (See also [URSA-PHARM] Is Priority Adherence Medication)
  • Is Statin -- One of the Priority Adherence Medication types; indicates a medication classified as a Statin based on the Red Book Generic Cross Reference code and/or NDC being included in the CMS Stars Statin proportion of days covered (PDC) measure value sets. (See also [URSA-PHARM] Is Priority Adherence Medication)
  • Is Episode for any High Risk Medication
  • Is Anticoagulant -- One of the High Risk Medication types; a medication classified as an anticoagulant based on the AHFS therapeutic class. (See also [URSA-PHARM] Is High Risk Medication, [URSA-PHARM] High Risk Medication Category)
  • Is Oral Antiplatelet -- One of the High Risk Medication types; a medication classified as an oral antiplatelet based on the AHFS therapeutic class or Red Book Generic Cross Reference Code. (See also [URSA-PHARM] Is High Risk Medication, [URSA-PHARM] High Risk Medication Category)
  • Is Cardiac Glycosides -- One of the High Risk Medication types; a medication classified as a cardiac glycoside based on the AHFS therapeutic class. (See also [URSA-PHARM] Is High Risk Medication, [URSA-PHARM] High Risk Medication Category)
  • Is Oral Hypoglycemic -- One of the High Risk Medication types; a medication classified as a hypoglycemic based on the AHFS therapeutic class. (See also [URSA-PHARM] Is High Risk Medication, [URSA-PHARM] High Risk Medication Category)
  • Is Insulin -- One of the High Risk Medication types; a medication classified as an insulin based on the AHFS therapeutic class or NDC present in the CMS Stars PDC oral anti-diabetic adherence measure specifications (used as an exclusion). (See also [URSA-PHARM] Is High Risk Medication, [URSA-PHARM] High Risk Medication Category)
  • Is Opiate Agonists -- One of the High Risk Medication types; a medication classified as an opiate agonist based on the AHFS therapeutic class. Full agonist opioids activate the opioid receptors in the brain fully resulting in the full opioid effect. Examples of full agonists are heroin, oxycodone, methadone, hydrocodone, morphine, opium and others. Partial agonist opioids activate the opioid receptors in the brain, but to a much lesser degree than a full agonist. Buprenorphine is an example of a partial agonist. In clinical practice, they are used for opioid agonist maintenance therapy or withdrawal management. (See also [URSA-PHARM] Is Active Chronic Opioid Episode)

• Medication Fields

  • First Fill Label Description
  • First Fill AHFS Therapeutic Class Code
  • First Fill AHFS Therapeutic Class Tier 1
  • First Fill AHFS Therapeutic Class Tier 2
  • First Fill AHFS Therapeutic Class Tier 3
  • First Fill Red Book Generic Cross Reference Code
  • First Fill Red Book Generic Formulation Code

• Patient Fields

  • Patient First Name
  • Patient Last Name
  • Patient Date of Birth -- The patient's date of birth. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the date of birth found on that particular type of record in the source data.
  • Patient State Abbreviation
  • Patient ZIP Code 5-Digit
  • Patient Phone

• Provider Fields

  • First Filling Provider Description

• Financial Fields

  • Episode Total Paid Amount

Foreign Keys

• episode_id → ursa.so_ursa_pharm_meds_002.episode_id
• pat_id → ursa.no_ursa_core_pat_001.pat_id