Guest Merge Log Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores guest profile merge history, tracking which guest profiles were merged together and by whom.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| guestmergewid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the guest merge log record. |
| guestmergehistorypk | BIGINT | YES | Source system primary key for the merge history. |
| mergeintowid | BIGINT | YES | Foreign key to the surviving/target guest profile (Bi_DimUser.userwid). |
| mergefromwid | BIGINT | YES | Foreign key to the source guest profile that was merged (Bi_DimUser.userwid). |
| mergedbywid | BIGINT | YES | Foreign key to the user who performed the merge (Bi_DimUser.userwid). |
| mergedate | TIMESTAMP | YES | Date/time the merge was performed. |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
guestmergewid
Foreign Keys
| Column | References |
|---|---|
| mergeintowid | Bi_DimUser.userwid |
| mergefromwid | Bi_DimUser.userwid |
| mergedbywid | Bi_DimUser.userwid |
Enumerator Values
| Column | Values |
|---|---|
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
Was this article helpful?
Your feedback helps us improve our documentation.