Data Mart for Qualifying Medication Synchronization Fills

Object Description

One record per outpatient medication fill for a chronic medication. In instances where a patient receives two fills on the same date for a similar medication, only keeping the details of the larger of the two fills to prevent the second fill on the same date counting towards the "next" fill for med sync purposes.

Metadata

• Table Name: ursa.dm_ursa_pharm_201
• Layer: Data Mart
• Object Type: Single Stack
• 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.