November 6, 2023/ Last updated : August 9, 2024Chad HermanData Tables
MEDICATION
All meds are coded to an ATC code.
Significant work has been done to clean up the data in this table, but more work needs to be done to provide better details about the prescriptions (dose, frequency, strength).
The information about dose, frequency, and strength is all there – but it isn’t always parsed into the right fields – so one of the orig fields may contain all the prescription details – parsing and standardizing need to be improved to make this more usable data.
This table easily allows a researcher to determine if a patient has been prescribed a medication.
If a researcher wants more details – duration, dosage, strength, refilles, then would recommend requesting the orig fields (including Name_orig) so the information can be parsed out.
Date variables: use Start Date, if missing use Date Created.