ESP Requests

The Electronic Support for Public Health (ESP) Requests are a set of requests that operate against a simplified version of the full ESP data model, called ESP: MDPHnet. The ESP data model is a standardized representation of EHR-based encounter and patient demographic information. It uses a set of complex algorithms to identify selected diseases of public health concern such as acute hepatitis B, Lyme disease, influenza-like illness, and diabetes. The ESP: MDPHnet data model is generated via SQL scripts that execute against the full ESP data model. It provides a mapping layer between the full set of ESP tables and the PopMedNet software.

The ESP Requests are:

• ICD-9 Diagnosis – used to build ad-hoc custom health measure queries based on ICD-9 3-digit, 4-digit, and 5 digit diagnosis codes that produce reports stratified by ICD-9 code, period, gender, race, age range, and zip code.
• /wiki/spaces/DPM/pages/8880325 – used to select one of a list of reportable disease reports that are produced periodically on the ESP servers stratified by period, gender, race, and age range.
• Query Composer – used to identify cohorts using complex constraints within inclusion and exclusion criteria that are stratified by period, gender, race, age range, center, zip code, and ICD-9 code or reportable disease.
  
  

The table below demonstrates the complexity of Query Composer requests in comparison to the ESP ICD-9 Diagnosis or Reportable Disease requests.