ZenotiHelp

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.