ZenotiHelp

Challenge Level Metrics Dimension Table

ZTZenoti Docs Team Updated October 11, 2026 1 min readGuide

Dimension table storing the target a guest must reach at each level of a challenge: one row per challenge, metric, and level. To find the target for a guest's challenge enrollment, join Bi_FactChallenges to Bi_DimChallenges on ChallengeWID = dimchallangeswid, then join to this table on ChallengeID and LevelNum; a multi-metric challenge returns one row per metric. Rows appear only for organizations that use challenges.

Columns

Column Name Data Type Nullable Description
dimchallengelevelmetricswid BIGINT IDENTITY No Surrogate warehouse key for the challenge level (Primary Key)
LevelMetricPK BIGINT Yes Source system primary key for the challenge level record
LevelMetricID VARCHAR(36) Yes Natural unique identifier (GUID) for the challenge level
ChallengeID VARCHAR(36) Yes Identifier (GUID) of the challenge this level belongs to; matches ChallengeID in Bi_DimChallenges
MetricFK BIGINT Yes Foreign key referencing the challenge metrics definition this level measures
LevelNum INT Yes Level (tier) number within the challenge: 1, 2, 3, and so on
LevelName NVARCHAR(200) Yes Display name of the level, such as Bronze or Silver
TargetCount INT Yes How many of the metric the guest must reach at this level
SortOrder INT Yes Display order of the level within the challenge
Void BOOLEAN Yes Soft-delete flag indicating if the record is voided
CreatedOn TIMESTAMP Yes Timestamp when the level was created
CreatedBy VARCHAR(36) Yes Identifier (GUID) of the user who created the level
LastUpdatedOn TIMESTAMP Yes Timestamp when the level was last updated
LastUpdatedBy VARCHAR(36) Yes Identifier (GUID) of the user who last updated the level

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity. This table also carries etllastupdated_on, another ETL timestamp.

Primary Key

dimchallengelevelmetricswid

Foreign Keys

Column References
ChallengeID Bi_DimChallenges.ChallengeID
MetricFK the challenge metrics dimension
Was this article helpful?
Your feedback helps us improve our documentation.