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 carriesetllastupdated_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.