Samantha H Chang, Shawn C Hirsch, Sonia M Thomas, Mark J Edlund, Rowena J Dolor, Timothy J Ives, Charlene M Dewey, Padma Gulur, Paul R Chelminski, Kristin R Archer, Li-Tzy Wu, Janis Curtis, Adam O Goldstein, Lauren A McCormack
{"title":"利用电子健康记录处方数据获得纵向每日吗啡毫克当量的复杂性和方法。","authors":"Samantha H Chang, Shawn C Hirsch, Sonia M Thomas, Mark J Edlund, Rowena J Dolor, Timothy J Ives, Charlene M Dewey, Padma Gulur, Paul R Chelminski, Kristin R Archer, Li-Tzy Wu, Janis Curtis, Adam O Goldstein, Lauren A McCormack","doi":"10.1093/jamiaopen/ooaf053","DOIUrl":null,"url":null,"abstract":"<p><strong>Objective: </strong>To describe challenges and solutions for calculating longitudinal daily opioid dose in morphine milligram equivalents from electronic health record prescriptions for a clinical trial of voluntary opioid reduction in patients with chronic non-cancer pain.</p><p><strong>Materials and methods: </strong>Researchers obtained opioid prescriptions for 525 participants from the National Patient-Centered Clinical Research Network datamart at three health systems. Daily opioid dose was calculated using dose conversions and summing across prescriptions after applying assumptions, reviewing suspect prescribing patterns, and removing spurious prescriptions.</p><p><strong>Results: </strong>Out of 16 071 extracted prescriptions, 1207 (8%) were unusable, and 14 864 (92%) were analyzed.</p><p><strong>Discussion: </strong>Numerous challenges were identified related to incomplete data, inaccurate refill dates, and overlapping or duplicate prescriptions.</p><p><strong>Conclusion: </strong>Using electronic prescription data to calculate daily doses of opioid consumption is challenging and requires significant cleaning prior to use in research. This paper recommends steps to review and clean electronic opioid prescription data.</p>","PeriodicalId":36278,"journal":{"name":"JAMIA Open","volume":"8 3","pages":"ooaf053"},"PeriodicalIF":2.5000,"publicationDate":"2025-06-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC12169419/pdf/","citationCount":"0","resultStr":"{\"title\":\"Complexities and approaches for deriving longitudinal daily morphine milligram equivalents using electronic health record prescription data.\",\"authors\":\"Samantha H Chang, Shawn C Hirsch, Sonia M Thomas, Mark J Edlund, Rowena J Dolor, Timothy J Ives, Charlene M Dewey, Padma Gulur, Paul R Chelminski, Kristin R Archer, Li-Tzy Wu, Janis Curtis, Adam O Goldstein, Lauren A McCormack\",\"doi\":\"10.1093/jamiaopen/ooaf053\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<p><strong>Objective: </strong>To describe challenges and solutions for calculating longitudinal daily opioid dose in morphine milligram equivalents from electronic health record prescriptions for a clinical trial of voluntary opioid reduction in patients with chronic non-cancer pain.</p><p><strong>Materials and methods: </strong>Researchers obtained opioid prescriptions for 525 participants from the National Patient-Centered Clinical Research Network datamart at three health systems. Daily opioid dose was calculated using dose conversions and summing across prescriptions after applying assumptions, reviewing suspect prescribing patterns, and removing spurious prescriptions.</p><p><strong>Results: </strong>Out of 16 071 extracted prescriptions, 1207 (8%) were unusable, and 14 864 (92%) were analyzed.</p><p><strong>Discussion: </strong>Numerous challenges were identified related to incomplete data, inaccurate refill dates, and overlapping or duplicate prescriptions.</p><p><strong>Conclusion: </strong>Using electronic prescription data to calculate daily doses of opioid consumption is challenging and requires significant cleaning prior to use in research. This paper recommends steps to review and clean electronic opioid prescription data.</p>\",\"PeriodicalId\":36278,\"journal\":{\"name\":\"JAMIA Open\",\"volume\":\"8 3\",\"pages\":\"ooaf053\"},\"PeriodicalIF\":2.5000,\"publicationDate\":\"2025-06-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC12169419/pdf/\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"JAMIA Open\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1093/jamiaopen/ooaf053\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"2025/6/1 0:00:00\",\"PubModel\":\"eCollection\",\"JCR\":\"Q2\",\"JCRName\":\"HEALTH CARE SCIENCES & SERVICES\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"JAMIA Open","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1093/jamiaopen/ooaf053","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2025/6/1 0:00:00","PubModel":"eCollection","JCR":"Q2","JCRName":"HEALTH CARE SCIENCES & SERVICES","Score":null,"Total":0}
Complexities and approaches for deriving longitudinal daily morphine milligram equivalents using electronic health record prescription data.
Objective: To describe challenges and solutions for calculating longitudinal daily opioid dose in morphine milligram equivalents from electronic health record prescriptions for a clinical trial of voluntary opioid reduction in patients with chronic non-cancer pain.
Materials and methods: Researchers obtained opioid prescriptions for 525 participants from the National Patient-Centered Clinical Research Network datamart at three health systems. Daily opioid dose was calculated using dose conversions and summing across prescriptions after applying assumptions, reviewing suspect prescribing patterns, and removing spurious prescriptions.
Results: Out of 16 071 extracted prescriptions, 1207 (8%) were unusable, and 14 864 (92%) were analyzed.
Discussion: Numerous challenges were identified related to incomplete data, inaccurate refill dates, and overlapping or duplicate prescriptions.
Conclusion: Using electronic prescription data to calculate daily doses of opioid consumption is challenging and requires significant cleaning prior to use in research. This paper recommends steps to review and clean electronic opioid prescription data.