Scribd
Upload
36 views2 pages

Diabetes Screening Analysis 40+ BMI≥25

The document describes calculating the percentage of patients aged 40 or older with a BMI of 25 or higher who received screening for abnormal blood glucose at least once in the last 3 years based on EHR data, and exploring the trend of proper diabetes screening in this group over the last 5 calendar years.

Uploaded by

Yue Yu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
36 views2 pages

Diabetes Screening Analysis 40+ BMI≥25

The document describes calculating the percentage of patients aged 40 or older with a BMI of 25 or higher who received screening for abnormal blood glucose at least once in the last 3 years based on EHR data, and exploring the trend of proper diabetes screening in this group over the last 5 calendar years.

Uploaded by

Yue Yu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

You are analyzing ambulatory EHR data to see if patients are screened for

diabetes. You will calculate the percentage of patients aged 40 years and older
with a BMI ≥ 25 who are seen for at least two office visits or at least one
preventive visit during the 12-month period who were screened for abnormal
blood glucose at least once in the last 3 years. Screening for abnormal blood
glucose may include ordering a fasting plasma glucose, 2-h plasma glucose
during a 75g oral glucose tolerance test, or A1C.

Goal: Describe whether the diabetes screening is performed in patients from


40 years old and older with BMI ≥ 25

1. Sub-goal: Identify instances of patients (aged 40 years and older)


with BMI ≥ 25
a. From the ambulatory EHR database, filter patients (aged 40
years and older) admitted to hospital in calendar year
between 2016-2020
b. In these patients, filter by records of BMI ≥ 25 who are seen
for at least two office visits or at least one preventive visit
during the 12-month period
c. Exclude patients who have records with preexisting diabetes
history at the hospital admission
d. Calculate the total number of these patients and serve as
denominator
2. Sub-goal: Calculate percentage of patients with BMI ≥ 25 were
screened for abnormal blood glucose
a. In the patients from sub-goal 1, for each patient check for
records of abnormal blood glucose testing criteria including:
i. Ordering a fasting plasma glucose
ii. Ordering a 2-h plasma glucose during a 75g oral
glucose tolerance test
iii. Ordering a A1C test
b. Filter patients by records of screening for the above tests for
at least once in the last 3 years
i. Calculate the total number of these patients
ii. The number of these patient serves as numerator
c. Calculate the percentage of patients with BMI ≥ 25 were
screened for abnormal blood glucose
i. With total from sub-goal 1-c as denominator and total
from sub-goal 2-b as numerator, calculate the
proportion.
3. Sub-goal: Explore the trend of proper diabetes screening in patients
with BMI ≥ 25 in the last 5 calendar years
a. Divide records of the patients collected in sub-goal 1 into 5
sub-groups based on calendar year: 2016, 2017, 2018, 2019,
2020
b. For each subgroup calculate the proportion of patients that
were screened for abnormal blood glucose using steps
described in sub-goal 2
c. Plot a line graph of proportion against year

You might also like