ZenotiHelp

ETL Refresh Log Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing ETL refresh log entries, tracking when data was last refreshed for each center and organization along with timestamps in both UTC and center-local time.

Columns

Column Name Data Type Nullable Description
etlrefreshlogwid BIGINT IDENTITY No Surrogate warehouse key for the ETL refresh log entry (Primary Key)
etlrefreshlogid NUMERIC(19,0) Yes Source system primary key for the refresh log record
accountname VARCHAR(512) Yes Account name associated with the refresh
centerid VARCHAR(36) Yes Center identifier (GUID) for which the refresh was performed
refreshutcdatetim TIMESTAMP Yes UTC timestamp of the data refresh
centerrefreshdatetime TIMESTAMP Yes Center-local timestamp of the data refresh
lastupdateddate TIMESTAMP Yes Timestamp of the last update to the source record

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

etlrefreshlogwid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Was this article helpful?
Your feedback helps us improve our documentation.