ZenotiHelp

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.