Guest merge log fact table
Bi_FactGuestMergeLog
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
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 | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
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 | |||