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

Relational Diagram

Related Key Concepts

None.

Dedicated Precursors

None.

FAQs

None.