Query purpose:
Created by the CDC National Syndromic Surveillance Program (NSSP) for use with emergency department data to develop queries for all National Notifiable Diseases defined by the National Notifiable Diseases Surveillance System (NNDSS). Please note that while the disease queries are developed using the NNDSS case definition as the basis for identifying patient visits of interest, the queried patient visits themselves may or may not represent a case patient in NNDSS and further public health investigation will most often be required. This query is intended to be a version 1 and may be further improved upon by the NSSP community of practice in the future. This query is intended to be narrow and capture visits with specific terms to support greater monitoring and actionable public health data. More complex and/or broader queries may exist that more broadly capture symptoms or travel-based terms.
How it was developed:
- The CDC team used the NNDSS case definition of ehrlichiosis to identify diagnostic codes (International Classification of Diseases, 9th & 10th Revision (ICD-9-CM, ICD-10-CM), SNOMED Clinical Terms (CT)) and chief complaint free-text for syndrome development.
- The codes and free text were then categorized as inclusion or exclusion terms. These terms were formatted for querying in ESSENCE.
- Text analysis was conducted on the initial query to find additional inclusion or exclusion terms.
- The query was cross-checked internally at NSSP and by CDC subject matter experts as needed.
How it works:
The Chief Complaint Discharge Diagnosis (CCDD) parsed field is used to query both the discharge diagnosis codes and chief complaint free text, and exclusions are incorporated as necessary.
- Inclusion based on ehrlichiosis chief complaint free text terms:
- The visit is included if it contains:’
- A chief complaint related to Ehrlichiosis – (“ehrlichio”) OR
- A chief complaint related to disease agent – (“ehrlichia chaf” or “ehrlichia ew”) OR
- The visit is included if it contains:’
- Inclusion based on ICD-10 discharge diagnosis codes related to ehrlichiosis:
- The visit is included if it contains:
- A discharge diagnosis code for Ehrlichiosis – (A77.4) OR
- The visit is included if it contains:
- Inclusion based on ICD-9 discharge diagnosis codes related to ehrlichiosis:
- The visit is included if it contains:
- A discharge diagnosis code for Ehrlichiosis – (082.40 or 082.41 or 082.49) OR
- The visit is included if it contains:
- Inclusion based on SNOMED discharge diagnosis codes related to ehrlichiosis:
- The visit is included if it contains:
- A discharge diagnosis code for Ehrlichiosis – (240626005 or 441554001 or 359747000) ANDNOT
- The visit is included if it contains:
- All the above must exclude:
- A chief complaint related to history of disease – (“history of ehrlichi” or “history ehrlichi”) OR
- A chief complaint related to follow up visits – (“follow up”)
(,^ehrlichio^,OR,^ehrlichia chaf^,OR,^ehrlichia ew^,OR,^;A774^,OR,^;0824[019];^,OR,^;240626005;^,OR,^;441554001;^,OR,^;359747000;^,),ANDNOT,(,^history of ehrlichi^,OR,^history ehrlichi^,OR,^follow up^,)