ZenotiHelp

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.