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.