Utc To Center Time Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table that maps UTC time offsets to center-specific local times for each organization center.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| utctocentertimewid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| minutestoadd | INTEGER | Yes | Number of minutes to add to UTC to derive center local time |
| centerwid | BIGINT | Yes | Foreign key reference to the center dimension warehouse ID |
| centername | VARCHAR(256) | Yes | Display name of the center |
| orgaccountname | VARCHAR(514) | Yes | Organization account name |
| organizationname | VARCHAR(1028) | Yes | Full name of the organization |
| void | INTEGER | Yes | Void/soft-delete flag (non-zero indicates voided) |
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
utctocentertimewid
Foreign Keys
| Column | References |
|---|---|
| centerwid | the center dimension (Bi_DimCenter or equivalent center table) |
Enumerator Values
| Column | Values |
|---|---|
| void | -- 0 = active, non-zero = voided |
Was this article helpful?
Your feedback helps us improve our documentation.