Challenges Dimension Table
ZTZenoti Docs Team Updated October 11, 2026 1 min readGuide
Dimension table storing challenge definitions for loyalty or engagement programs, including metadata about challenge metrics, rules, and validity periods.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| dimchallangeswid | BIGINT IDENTITY | No | Surrogate warehouse key for the challenge (Primary Key) |
| ChallengePK | BIGINT | Yes | Source system primary key for the challenge record |
| ChallengeID | VARCHAR(36) | Yes | Natural unique identifier (GUID) for the challenge |
| ChallengeName | NVARCHAR(2000) | Yes | Display name of the challenge |
| ChallengeDescription | NVARCHAR(65535) | Yes | Detailed description of the challenge |
| ChallengeMetricsFK | BIGINT | Yes | Foreign key referencing the challenge metrics definition |
| ChallengeTypeCount | INTEGER | Yes | Count or threshold value for the challenge type |
| ChallengeStartDate | TIMESTAMP | Yes | Start date of the challenge validity period |
| ChallengeEndDate | TIMESTAMP | Yes | End date of the challenge validity period |
| RuleId | VARCHAR(36) | Yes | Identifier (GUID) of the rule associated with the challenge |
| CreatedOn | TIMESTAMP | Yes | Timestamp when the challenge was originally created |
| CreatedBy | VARCHAR(36) | Yes | Identifier (GUID) of the user who created the challenge |
| Void | BOOLEAN | Yes | Soft-delete flag indicating if the record is voided |
| ChallengeType | INT | Yes | Type of challenge (see Enumerator Values) |
| ChallengeMetricsName | NVARCHAR(2000) | Yes | Display name of the associated challenge metric |
| ParentChallengeMetricsName | NVARCHAR(2000) | Yes | Display name of the parent challenge metric |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
dimchallangeswid
Foreign Keys
| Column | References |
|---|---|
| ChallengeMetricsFK | the challenge metrics dimension |
Enumerator Values
| Column | Values |
|---|---|
| ChallengeType | 1 = Standard: one metric, one target 2 = Multi-metric: several metrics, each with its own target 3 = Multi-tier: one metric with levels (such as Bronze and Silver), each with a higher target. Level targets are in Bi_DimChallengeLevelMetrics. |
Was this article helpful?
Your feedback helps us improve our documentation.