Using the Example Queries

The Evisions Data Model (EDM) online reference provides queries for each supported entity. You are encouraged to use these samples and customize them as needed for your institution.

To access the example query for an entity, navigate to the Query Editor page for that entity, then select Example SQL Queries.

The Evisions Data Model page for the entity displays in a new tab.

Scroll to the bottom of the page to see the example SQL query. You can copy and paste this query into the query editor. In some cases you only need to make minor modifications to the query.