Patient and Encounter Level Tables

Owned by Melanie Davies (Unlicensed)
Last updated: Jun 16, 2021 by Adam Paczuski (Unlicensed)
1 min read

The ESP: MDPHNet data model includes the following tables.

Whenever possible, the organization and format of information in these tables is patterned after the Mini-Sentinel Common Data Model (MSCDM), v2.1. Use of the MSCDM will facilitate cross-project sharing of querying capabilities.

  • ESP_DEMOGRAPHIC: Contains one record per patient with the most recent information on birth date, sex, ethnicity, and race.
  • ESP_ENCOUNTER: Contains one record per patient visit.  This table includes provider, visit date, visit location, encounter type and age group information.
  • ESP_DIAGNOSIS: Contains one record per combination of patient, visit and diagnosis.
  • ESP_DISEASE:  Contains one record per combination of patient and detected disease\case based on the ESP case detection algorithms. The table includes detection criteria, review workflow status, reviewer notes and derived variables for 5 year, 10 year and Mini-Sentinel age groups.