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.