Skip to main content

Table 3 Algorithm components for measurement of pre-procedural antimicrobial use in cardiac device procedures

From: Novel methodology to measure pre-procedure antimicrobial prophylaxis: integrating text searches with structured data from the Veterans Health Administration’s electronic medical record

Electronic Medical Record Extract

Specific Fields

Criteria

Inpatient Utilization

CPT code

Matches CPT code for cardiac device procedure

Procedure date+time

Inpatient procedure ID

Patient ID

Outpatient Utilization

CPT code

Matches CPT code for cardiac device procedure

Procedure date+time

Outpatient procedure ID

Patient ID

Text Integrated Clinical Notes

Note entry date

Note date created ≥7 days of procedure

Note text matches wild card text string for antibiotic name (list of search terms in Additional file 1)

Title

Document definition

Text

Patient ID

Inpatient Pharmacy Dispensing

Drug dispensed date

Drug dispensed date ≤7 days of procedure date

Drug name matches wild card text string for antibiotic name (list of search terms in Additional file 1)

Days supply = 1

Drug class code

Drug name without dose

Days supply

Patient ID

Outpatient Pharmacy Dispensing

Drug dispensed date

Drug dispensed date ≤7 days of procedure date

Drug name matches wild card text string for antibiotic name (list of search terms in Additional file 1)

Days supply = 1

Drug class code

Drug name without dose

Days supply

Patient ID

CPRS Orders

Entered date+time

Order start date+time ≤ 7 days of procedure date+time

Order item name matches text string for antibiotic name (list of search terms in Additional file 1)

Order start date+time

Order stop date+time

Order item name

Patient ID

  1. We pulled data from electronic medical record extracts according to the following criteria. Note, VA specific variables to ensure the fields are populated with true data, as opposed to place holder text, are not shown as these are not useful outside the VA. Full code available from authors