Skip to main content

Main menu

  • Home
  • Articles
    • Current
    • Published Ahead of Print
    • Archive
    • Supplemental Issues
    • Collections - French
    • Collections - English
  • Info for
    • Authors & Reviewers
    • Submit a Manuscript
    • Advertisers
    • Careers & Locums
    • Subscribers
    • Permissions
  • About CFP
    • About CFP
    • About the CFPC
    • Editorial Advisory Board
    • Terms of Use
    • Contact Us
  • Feedback
    • Feedback
    • Rapid Responses
    • Most Read
    • Most Cited
    • Email Alerts
  • Blogs
    • Latest Blogs
    • Blog Guidelines
    • Directives pour les blogues
  • Mainpro+ Credits
    • About Mainpro+
    • Member Login
    • Instructions
  • Other Publications
    • http://www.cfpc.ca/Canadianfamilyphysician/
    • https://www.cfpc.ca/Login/
    • Careers and Locums

User menu

  • My alerts

Search

  • Advanced search
The College of Family Physicians of Canada
  • Other Publications
    • http://www.cfpc.ca/Canadianfamilyphysician/
    • https://www.cfpc.ca/Login/
    • Careers and Locums
  • My alerts
The College of Family Physicians of Canada

Advanced Search

  • Home
  • Articles
    • Current
    • Published Ahead of Print
    • Archive
    • Supplemental Issues
    • Collections - French
    • Collections - English
  • Info for
    • Authors & Reviewers
    • Submit a Manuscript
    • Advertisers
    • Careers & Locums
    • Subscribers
    • Permissions
  • About CFP
    • About CFP
    • About the CFPC
    • Editorial Advisory Board
    • Terms of Use
    • Contact Us
  • Feedback
    • Feedback
    • Rapid Responses
    • Most Read
    • Most Cited
    • Email Alerts
  • Blogs
    • Latest Blogs
    • Blog Guidelines
    • Directives pour les blogues
  • Mainpro+ Credits
    • About Mainpro+
    • Member Login
    • Instructions
  • RSS feeds
  • Follow cfp Template on Twitter
  • LinkedIn
  • Instagram
Research ArticleCollege

You and your EMR: the research perspective

Part 3. Answering practice-level questions

Joshua D. Shadd, Sonny Cejic, Amanda Terry, Bridget L. Ryan, Moira Stewart and Amardeep Thind
Canadian Family Physician March 2012; 58 (3) 344-345;
Joshua D. Shadd
MD CCFP
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: jshadd2@uwo.ca
Sonny Cejic
MSc MD CCFP
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Amanda Terry
MA PhD
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Bridget L. Ryan
MSc PhD
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Moira Stewart
PhD
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Amardeep Thind
MD PhD
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • Article
  • eLetters
  • Info & Metrics
  • PDF
Loading

Dr Park and her team have had their electronic medical record (EMR) for almost 2 years. Throughout this time, they have been recording questions they hope their EMR might help them answer. These questions have arisen from practice-management concerns, proposed quality-improvement initiatives, and old-fashioned clinical curiosity. They are wondering how to begin using the EMR to provide some answers.

Electronic medical records can be used to answer many practice-level questions. Regardless of your motivation for querying your EMR, several matters must be considered.

What is your question?

A clear answer can only arise from a focused question. A broad area of interest (eg, blood pressure measurement) will need to be narrowed to a specific research question that meets the FINER (feasible, interesting, novel, ethical, and relevant) criteria.1 Quantitative research questions* fall into 2 broad categories: descriptive and analytic. Descriptive questions portray important characteristics of a phenomenon, group, or process of interest (eg, What proportion of office visits has a blood pressure measurement recorded in the patient’s record?). Analytic questions compare 2 or more groups or conditions (eg, Did changing office procedures affect the proportion of office visits at which a patient’s blood pressure reading is documented?). The mnemonic PICOT2 (population, intervention, comparator, outcome, time frame) can help in formulating a good analytic research question.

Is the information you need to answer your question present and accessible in the EMR?

To answer any question from your EMR, you must be able to define a numerator and a denominator for the phenomenon, group, or process of interest, and you must be able to reliably identify these based on information present in the EMR. Experienced EMR researchers will tell you that fulfilling these criteria is more complicated than it might initially seem. For example, in one study investigating 6 different potential ways of identifying patients with diabetes in a primary care EMR database, the prevalence of diabetes ranged more than 2-fold (from 5.0% to 12.0%) depending on which definition was used.3

In EMRs, key information might be recorded in a variety of different places or might be missing altogether. For example, a patient’s height might appear in a note, on a periodic health examination template, in a structured height-and-weight field, or in a customized field created by an individual clinician. For many patients, height might not have yet been documented anywhere in the EMR. The research query must take into account and search for the variety of ways that information will be recorded in the EMR.

How will you translate patient information into a numerator and a denominator?

Imagine you are interested in determining the proportion of your patients with renal failure who have been referred to a nephrologist. In order to answer your question, relevant data from individual patient records will need to be translated into numbers that can be counted by the computer. If the EMR contained a tick box for “renal failure present,” then your denominator could be readily distinguished. Because EMRs are not designed this way, you will need to translate (recode) the data that do exist (eg, text in the cumulative patient profile) into a form that can be recognized and counted by the computer. This entails identifying all possible variations on “renal failure” that might be present in the cumulative patient profile (“renal failure,” “nephropathy,” “CRF” [chronic renal failure], “microalbuminuria,” etc) and translating them into a new variable: renal failure present or absent. Consistency in data entry4 (eg, ensuring all users reliably record renal failure in an identical fashion) will reduce the burden of recoding.

How will you extract and analyze the information?

Depending on the specific EMR used, many descriptive, practice-level questions of clinical interest in family physicians’ offices (eg, What proportion of women older than age 50 had a mammogram in the past 2 years?) can be answered by the EMR software using customizable queries or a structured query language interface. For analytic questions (eg, Are obese and nonobese women equally likely to have undergone a screening mammogram in the past 2 years?), it will likely be necessary to export the data into a separate software package (eg, Excel, SPSS) for analysis. Statistical capabilities, available technical support, and ease of exporting data vary among EMR products and should be considered at the outset of the research process.5–7

Do you need special permission to analyze and report the data?

Formal approval from an institutional (hospital or university) research ethics board might not be required for chart audit research or queries that remain entirely internal to the practice (eg, quality improvement). If it is hoped that any portion of the study will be shared outside the practice, then clearance from the local research ethics board might be necessary, particularly if the study involves combining data from multiple providers or exporting data from the EMR into a separate database. For physicians in clinics associated with hospitals, additional procedures might be necessary to obtain approval from hospital data custodians.8 Investigating applicable local standards should be an early step in the research-planning process.

Today’s EMRs make it possible for individual physicians to ask and answer important questions about their own practices; however, doing so requires attention to several issues and processes that are best considered well before they hope to analyze data. A little foresight goes a long way in practice-level EMR research.

Acknowledgments

Dr Ryan is funded by a postdoctoral fellowship from the Dr Brian W. Gilbert Canada Research Chair in Primary Health Care Research. Dr Stewart is funded by the Dr Brian W. Gilbert Canada Research Chair in Primary Health Care Research. Dr Thind is a Canada Research Chair in Health Services Research.

Notes

Hypothesis is a quarterly series in Canadian Family Physician, coordinated by the Section of Researchers of the College of Family Physicians of Canada. The goal is to explore clinically relevant research concepts for all CFP readers. Submissions are invited from researchers and nonresearchers. Ideas or submissions can be submitted online at http://mc.manuscriptcentral.com/cfp or through the CFP website www.cfp.ca under “Authors and Reviewers.”

Footnotes

  • ↵* The potential of EMRs for qualitative research is, at present, underexplored.

  • Competing interests

    Dr Cejic is Chair of the Nightingale Advisory Board at Nightingale Informatix (the vendor of the electronic medical record that Dr Cejic uses). None of the other authors has any competing interests to declare.

  • Copyright© the College of Family Physicians of Canada

References

  1. ↵
    1. Cummings SR,
    2. Browner WS,
    3. Hulley SB
    . Conceiving the research question. In: Hulley SB, Cummings SR, Browner WS, Grady DG, Newman TB, editors. Designing clinical research. 3rd ed. Philadelphia, PA: Lippincott Williams & Wilkins; 2007. p. 17-26.
  2. ↵
    1. Haynes R
    . Forming research questions. In: Haynes R, Sacket D, Guyatt G, Tugwell P, editors. Clinical epidemiology. How to do clinical practice research. Philadelphia, PA: Lippincott Williams & Wilkins; 2006. p. 3-14.
  3. ↵
    1. Harris SB,
    2. Glazier RH,
    3. Tompkins JW,
    4. Wilton AS,
    5. Chevendra V,
    6. Stewart MA,
    7. et al
    . Investigating concordance in diabetes diagnosis between primary care charts (electronic medical records) and health administrative data: a retrospective cohort study. BMC Health Serv Res 2010;10:347.
    OpenUrlCrossRefPubMed
  4. ↵
    1. Ryan BL,
    2. Shadd JD,
    3. Terry A,
    4. Cejic S,
    5. Chevendra V,
    6. Thind A
    . You and your EMR: the research perspective. Part 2. How structure matters. Can Fam Physician. Vol. 57. 2011. p. 1473-4. Available from: www.cfp.ca/content/57/12/1473.full.pdf+html. Accessed 2012 Jan 23.
    OpenUrlFREE Full Text
  5. ↵
    1. Terry AL,
    2. Chevendra V,
    3. Thind A,
    4. Stewart M,
    5. Marshall JN,
    6. Cejic C
    . Using your electronic medical record for research: a primer for avoiding pitfalls. Fam Pract 2010;27(1):121-6. Epub 2009 Oct 14.
    OpenUrlAbstract/FREE Full Text
    1. Holbrook A,
    2. Keshavjee K,
    3. Troyan S,
    4. Pray M,
    5. Ford PT,
    6. COMPETE Investigators
    . Applying methodology to electronic medical record selection. Int J Med Inform 2003;71(1):43-50.
    OpenUrlCrossRefPubMed
  6. ↵
    1. Ryan BL,
    2. Cejic S,
    3. Shadd JD,
    4. Terry A,
    5. Chevendra V,
    6. Thind A
    . You and your EMR: the research perspective. Part 1. Selecting and implementing an EMR. Can Fam Physician. Vol. 57. 2011. p. 1090-1. Available from: www.cfp.ca/content/57/9/1090.full.pdf+html. Accessed 2012 Jan 23.
    OpenUrlFREE Full Text
  7. ↵
    1. Gold JL
    . Whose medical records are these, anyway? Ownership, access, custodianship and ethical duties. Ont Med Rev 2011;78:20-2.
    OpenUrl
PreviousNext
Back to top

In this issue

Canadian Family Physician: 58 (3)
Canadian Family Physician
Vol. 58, Issue 3
1 Mar 2012
  • Table of Contents
  • About the Cover
  • Index by author
Print
Download PDF
Article Alerts
Sign In to Email Alerts with your Email Address
Email Article

Thank you for your interest in spreading the word on The College of Family Physicians of Canada.

NOTE: We only request your email address so that the person you are recommending the page to knows that you wanted them to see it, and that it is not junk mail. We do not capture any email address.

Enter multiple addresses on separate lines or separate them with commas.
You and your EMR: the research perspective
(Your Name) has sent you a message from The College of Family Physicians of Canada
(Your Name) thought you would like to see the The College of Family Physicians of Canada web site.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Citation Tools
You and your EMR: the research perspective
Joshua D. Shadd, Sonny Cejic, Amanda Terry, Bridget L. Ryan, Moira Stewart, Amardeep Thind
Canadian Family Physician Mar 2012, 58 (3) 344-345;

Citation Manager Formats

  • BibTeX
  • Bookends
  • EasyBib
  • EndNote (tagged)
  • EndNote 8 (xml)
  • Medlars
  • Mendeley
  • Papers
  • RefWorks Tagged
  • Ref Manager
  • RIS
  • Zotero
Respond to this article
Share
You and your EMR: the research perspective
Joshua D. Shadd, Sonny Cejic, Amanda Terry, Bridget L. Ryan, Moira Stewart, Amardeep Thind
Canadian Family Physician Mar 2012, 58 (3) 344-345;
Twitter logo Facebook logo Mendeley logo
  • Tweet Widget
  • Facebook Like
  • Google Plus One

Jump to section

  • Article
    • What is your question?
    • Is the information you need to answer your question present and accessible in the EMR?
    • How will you translate patient information into a numerator and a denominator?
    • How will you extract and analyze the information?
    • Do you need special permission to analyze and report the data?
    • Acknowledgments
    • Notes
    • Footnotes
    • References
  • eLetters
  • Info & Metrics
  • PDF

Related Articles

  • No related articles found.
  • PubMed
  • Google Scholar

Cited By...

  • Identifying patients with asthma in primary care electronic medical record systems: Chart analysis-based electronic algorithm validation study
  • You and your EMR: the research perspective: Part 4. Optimizing EMRs in primary health care practice and research
  • Google Scholar

More in this TOC Section

College

  • Le leadership au service d’autrui
  • Money talk: a CFPC financial update
  • Servant leadership
Show more College

Hypothesis

  • State of traditional healing from the perspective of cultural support
  • Strength in family medicine research
  • Utility of hashing and salting algorithms in quality improvement studies
Show more Hypothesis

Similar Articles

Navigate

  • Home
  • Current Issue
  • Archive
  • Collections - English
  • Collections - Française

For Authors

  • Authors and Reviewers
  • Submit a Manuscript
  • Permissions
  • Terms of Use

General Information

  • About CFP
  • About the CFPC
  • Advertisers
  • Careers & Locums
  • Editorial Advisory Board
  • Subscribers

Journal Services

  • Email Alerts
  • Twitter
  • LinkedIn
  • Instagram
  • RSS Feeds

Copyright © 2025 by The College of Family Physicians of Canada

Powered by HighWire