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

Relational Diagram

Related Key Concepts

None.

Dedicated Precursors

None.

FAQs

None.