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.