View When Your Data Was Last Refreshed - Elation Help Center

View last refresh date from the UI

Start by accessing your data by

Viewing left navigation bar
Clicking on Data > Databases
Click on any table in the ELATIONHEALTHEHDW database
Then hover over the clock icon located underneath the header.

This will tell you the last time your practice had a full refresh of your data.

View last refresh data via query

You can also run the below query to get insight into when your data was last refreshed. This method relies on the hdb_last_sync column, which is present on every table in your Hosted Database.

hdb_last_sync records when Elation’s internal data store last refreshed a row from the source application. It does not represent when your Hosted Database as a whole completed its most recent refresh, nor the exact moment an individual record became available in your account.

This assumes your practice most often modifies appointments, visit note, or patient information and results the last time any of those tables were last_modified.

with visits_cte as(
select max(hdb_last_sync) as last_modified
from visit_note
)
,appointment_cte as(
select max(hdb_last_sync) as last_modified
from appointment
)
,patient_cte as(
select max(hdb_last_sync) as last_modified
from patient
)
,last_refreshed_date as(
select
*
from(
select
last_modified 
from visits_cte
union all
select last_modified
from appointment_cte
union all
select last_modified
from patient_cte
)
)
select 
max(last_modified) as last_refresh_date
from last_refreshed_date;

If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>

⌘I