Query purpose:
To assist state, local, tribal, territorial, and federal public health practitioners in monitoring emergency department (ED) visits related to Pertussis (Pertussis v2 CCDD Parsed) and diagnosed with Pertussis (Pertussis v2 DD).
How it works:
Pertussis v2 CCDD Parsed is a CCDD Parsed version of the definition, utilizing the Chief Complaint Discharge Diagnosis Parsed (CCDD Parsed) field to query discharge diagnosis codes and chief complaint term free text. Pertussis v2 DD uses the Discharge Diagnosis Parsed field to only query discharge diagnosis codes. Both definitions identify visits with codes/terms indicating visits associated with pertussis (see Tables, inclusions) while excluding visits that contain certain codes or terms related to encounters for pertussis vaccination or parapertussis (see Tables 1, exclusions). Tables are available in the attached fact sheet.
ESSENCE syntax for CCDD Parsed Free Text Field, Pertussis v2 CCDD Parsed
(,^;A37[09]^,OR,^;5247005;^,OR,^;93417001;^,OR,^;170526005;^,OR,^;27836007;^,OR,^;59475000;^,OR,^;408682005;^,OR,^;271567008;^,OR,^;60537006;^,OR,^;782715005;^,OR,^;192650000;^,OR,^;033;^,OR,^;033[09];^,OR,^whooping^,OR,^ pertuss^,OR,^pertuss^,ANDNOT,^[a-z]pertuss^,),ANDNOT,(,^vacc^,OR,^immun^,OR,^proph^,OR,^;Z23^,OR,^;A371^,OR,^;26183002;^,OR,^;77116006;^,OR,^;1092951000119106;^,)
ESSENCE syntax for DD parsed field, Pertussis v2 DD
(,^;A37[09]^,OR,^;5247005;^,OR,^;93417001;^,OR,^;170526005;^,OR,^;27836007;^,OR,^;59475000;^,OR,^;408682005;^,OR,^;271567008;^,OR,^;60537006;^,OR,^;782715005;^,OR,^;192650000;^,OR,^;033;^,OR,^;033[09];^,),ANDNOT,(,^;Z23^,OR,^;A371^,OR,^;26183002;^,OR,^;77116006;^,OR,^;1092951000119106;^,)