Guest merge log fact table
Bi_FactGuestMergeLog
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
GuestMergeHistoryPK | bigint | Unique identifier for the row | |||
MergeDate | TIMESTAMP | Date on which accounts are merged | |||
MergedBywid | bigint | employee id of the employee who did the merge | bi_dimuser userwid | ||
MergeFromwid | bigint | Guest ID which is merged into target guest ID | |||
MergeIntowid | bigint | target guest id to which guest account is merged into | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
guestmergewid | bigint | Unique identifier for the row. Primary Key | Yes | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||