ZenotiHelp

User Update History Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table tracking the history of user setting/profile changes over time, capturing old and new values with effective date ranges.

Columns

Column Name Data Type Nullable Description
userupdatehistorywid BIGINT IDENTITY No Surrogate warehouse key for the user update history record
UserHistoryPK BIGINT Yes Source system primary key for the history record
UserId VARCHAR(36) Yes Unique identifier (GUID) of the user whose setting was changed
TuuhOrgId VARCHAR(36) Yes Unique identifier (GUID) of the organization associated with the history record
CurrentValue VARCHAR(MAX) Yes The value of the setting at the time of the change
settingname VARCHAR(512) Yes Name of the setting or profile attribute that was changed
startDate TIMESTAMP Yes Start date/time when this value became effective
enddate TIMESTAMP Yes End date/time when this value ceased to be effective

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

userupdatehistorywid

Foreign Keys

Column References
UserId a user/guest entity in the source system
TuuhOrgId an organization entity in the source system
OrganizationId an organization entity in the source system
Was this article helpful?
Your feedback helps us improve our documentation.