ZenotiHelp

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.