Data Warehouse Heartbeat

Does your agency access the Data Warehouse (DW) for reporting purposes?  If so, you are probably aware of the lag that can sometimes occur in the DW, causing the data to be out of sync with the actual Accela Production database.  There is a simple query that you can execute in the DW to find the “heartbeat” or the last updated date and time that the DW was in sync with the Production database:

select * from accela.stream_heartbeat;

Marion County, who heavily relies on the DW, even wrote a report for end users to generate that shows the last updated date and time using this query so that they are aware when there is a lag.