Medication Days Covered Enhancements

Reviewers Wanted

This is an open call for reviews of this new module. Please provide any feedback by 6/28/2019.

Description

This is the combination of work done by @jcd71 and myself to create "Medication Days Covered" views using claims and LMR data. This merge includes commits added by a WIP merge request (!9 (closed)), which was added to this feature branch at dd94fc8a.

Changes

MedicationDaysCovered

1. Add new columns:
   • PrescribingProviderNPI
   • TherapeuticClassDSC
2. Rename columns:
   • DiscreteFrequencyID -> FrequencyID
   • DiscreteFrequencyDSC -> FrequencyDSC
   • DiscreteDispenseQuantityNBR -> DispenseQTY
   • DiscreteDoseAMT -> DoseAMT
   • DiscreteDispenseUnitDSC -> DispenseUnitDSC
3. Logic changes:
   • Ignore medication orders with a NULL DiscreteFrequencyID. It is impossible to calculate the duration for these records.
   • Ignore medication orders with a NULL DiscreteDispenseQuantityNBR. It is impossible to calculate the duration for these records.

MedicationDaysCoveredClaims [NEW!]

Defines a view for identifying the number of days covered by a prescription claim. This view uses Payer data.

NOTE: Prescription claims do not contain the same information as other medication order data - primarily dose and strength information. It may be possible to identify some of these fields using the NDC code in a future enhancement.

MedicationDaysCoveredLMR [NEW!]

Defines a view for identifying the number of days covered by an LMR order detail. This data is no longer being updated, so users should expect this view to be "Frozen." This data may be useful for analytics that require pre-Epic data.

NOTE: Due to the large number of FrequencyMnemonicCD values that needed to be mapped to a wall time, only the top 200 frequencies are currently supported. This accounted for over 95% of LMR medication orders, however. We plan to increase the breadth of this mapping in future enhancements.