This table provides a mapping between centers and campaigns. The following table lists columns included in the Bi_DimCampaignCenters_s3 table.
Column name | Column type | Description | Primary key |
|---|---|---|---|
CampaignCenterswid | BIGINT | Yes | |
CampaignCenterId | VARCHAR(36) | Unique identifier for center-campaign combination | |
CampaignId | VARCHAR(36) | Unique identifier for each campaign | |
CenterId | VARCHAR(36) | Unique identifier for the center | |
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |
MaxRedemptionTimes | INTEGER | Maximum number of times a campaign can be redeemed in a center | |
EtlLastUpdatedOn | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |
EtlLastUpdatedBy | VARCHAR(50) | ETL system admin user who inserted or updated the corresponding record in this table. | |
podname | VARCHAR(20) | Internal to Zenoti. | |
organizationid | VARCHAR(36) | Unique identifier for the organization | |
groupid | BIGINT | Internal to Zenoti. Used for data processing. |