Querying

ESP allows health departments to query the EHR systems of multiple providers at once to get a population level view of health indicators. Authorized users can create and securely distribute queries to network data partners who can review, execute, and securely return the results to requestors via a secure Web-based “Portal”. Data partners maintain control of their data, can review all queries before execution, and review results before securely transferring back to the Portal. Data partners can automate any portion of the query procedure. The point and click ESP query interface makes it easy for users to stratify by age, sex, race, and time period. Users can search for ICD-9 diagnosis codes, ICD-9 procedure codes, and HCPCS codes to build their query.

ESP is currently being used by the Massachusetts Department of Public Health to address population level questions of public health importance. For example, an authorized user at MDPH can query ESP data partners to assess flu vaccines by year.

ESPQueryIMage1

 

RiskScape

  • ESP has an intelligent presentation system, the RiskScape, which graphically displays population level surveillance data. The RiskScape is user friendly and visually appealing platform which is generalizable to any population level surveillance target (e.g., diabetes, asthma, heart disease, influenza like illness) and allows users maximal flexibility to stratify data in whatever way they wish. RiskScape automatically maps results by zip code, stratifying outcomes by demographic and clinical parameters, and enables users to specify custom queries and stratifications. The RiskScape provides public health practitioners with rich, up-to-date views of health measures that facilitate timely identification of health disparities and opportunities for targeted interventions.
  • For example, a health department official can specify a report of the rates of postpartum testing for frank diabetes amongst gestational diabetics stratified by zip code, race/ethnicity, and age. A report of this nature could highlight Hispanic women under age 20 in the southern neighborhoods of Boston as having disproportionately lower rates of postpartum testing. This in turn can inform a targeted public health campaign to increase postpartum testing for this well-defined population.