Mile Stones Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing milestone definitions for loyalty or engagement programs, tracking levels, check-in counts, and associated metric information.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| dimmilestonewid | BIGINT IDENTITY | No | Surrogate warehouse key for the milestone (Primary Key) |
| MilestonesPK | BIGINT | Yes | Source system primary key for the milestone record |
| MilestonesID | VARCHAR(36) | Yes | Natural unique identifier (GUID) for the milestone |
| MilestoneName | NVARCHAR(2000) | Yes | Display name of the milestone |
| Level | INTEGER | Yes | Numeric level of the milestone within the program hierarchy |
| MilestonesMetricFK | BIGINT | Yes | Foreign key referencing the milestone metrics definition |
| CheckInCount | INTEGER | Yes | Number of check-ins required to achieve the milestone |
| CreatedOn | TIMESTAMP | Yes | Timestamp when the milestone was originally created |
| CreatedBy | VARCHAR(36) | Yes | Identifier (GUID) of the user who created the milestone |
| Void | BOOLEAN | Yes | Soft-delete flag indicating if the record is voided |
| MileStoneMetricsName | NVARCHAR(2000) | Yes | Display name of the associated milestone metric |
| ParentMileStoneMetricsName | NVARCHAR(2000) | Yes | Display name of the parent milestone 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
dimmilestonewid
Foreign Keys
| Column | References |
|---|---|
| MilestonesMetricFK | the milestone metrics dimension |
Was this article helpful?
Your feedback helps us improve our documentation.