ZenotiHelp

Challenges Fact Table

ZTZenoti Docs Team Updated October 11, 2026 1 min readGuide

Records guest participation in challenges, tracking acceptance, achievement status, and associated metrics per user and center.

Columns

Column Name Data Type Nullable Description
Factchallangeswid BIGINT IDENTITY NOT NULL Surrogate warehouse key for the challenge fact record.
FactSegmentId BIGINT NULL Source system identifier for the challenge segment.
ChallengeUserID VARCHAR(36) NULL Unique identifier of the challenge-user association in the source system.
UserWID BIGINT NULL Warehouse key referencing the guest/user dimension.
ChallengeWID BIGINT NULL Warehouse key referencing the challenge dimension.
IsActive BOOLEAN NULL Indicates if the challenge participation is currently active.
AcceptedDate TIMESTAMP NULL Date/time when the user accepted the challenge.
AchievedDate TIMESTAMP NULL Date/time when the user achieved/completed the challenge.
CreatedOn TIMESTAMP NULL Date/time the challenge record was created in the source system.
CreatedByWID BIGINT NULL Warehouse key of the user who created this challenge record.
Status INT NULL Status code of the challenge participation.
CenterWId BIGINT NULL Warehouse key referencing the center dimension.
ChallengeCount BIGINT NULL Count of challenges associated with this record.
Void BOOLEAN NULL Flag indicating whether the record is voided (soft delete).
LevelNum INT NULL Level (tier) of the guest's challenge enrollment. With the challenge's ChallengeID, it joins to Bi_DimChallengeLevelMetrics for that level's target.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

Factchallangeswid

Foreign Keys

Column References
UserWID Bi_DimUser.userwid
CenterWId Bi_DimCenter.centerwid
CreatedByWID Bi_DimUser.userwid
ChallengeWID Bi_DimChallenges.dimchallangeswid

Enumerator Values

Column Values
IsActive true = Active, false = Inactive
Status 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
Void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.