• Configuration Settings
  • Available Database Tables
  • PERSON
  • ATTRIBUTE
  • PROVIDER
  • PROVIDER_ATTRIBUTE
  • ENCOUNTER
  • CONDITION
  • MEDICATION
  • PROCEDURE
  • REPORT
  • OBSERVATION
  • IMMUNIZATION
  • CAREPLAN
  • IMAGING_STUDY
  • CLAIM
  • COVERAGE
  • QUALITY_OF_LIFE
  • UTILIZATION
  • UTILIZATION_DETAIL
  • Sample Queries
  • Sample Query 1: select everything from the "person" table.
  • Sample Query 2: select the number of living people.
  • Sample Query 3: select the people that have an active diagnosis of diabetes, along with the age of diagnosis