Guest merge log fact table
Bi_FactGuestMergeLog_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
GuestMergeHistoryPK | DECIMAL(19,0) | Unique identifier for the row. Primary Key | Yes | ||
MergeInto | VARCHAR(36) | target guest id to which guest account is merged into | |||
MergeFrom | VARCHAR(36) | Guest ID which is merged into target guest ID | |||
MergedBy | VARCHAR(36) | employee id of the employee who did the merge | |||
MergeDate | TIMESTAMP | Date on which accounts are merged | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
CenterId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 CenterId | ||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||