ZenotiHelp

Milestones Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Records guest milestone achievements, tracking when users reach defined milestones at specific centers.

Columns

Column Name Data Type Nullable Description
Factmilestoneswid BIGINT IDENTITY NOT NULL Surrogate warehouse key for the milestone fact record.
FactSegmentId BIGINT NULL Source system identifier for the milestone segment.
MilestoneUserID VARCHAR(36) NULL Unique identifier of the milestone-user association in the source system.
UserWID BIGINT NULL Warehouse key referencing the guest/user dimension.
CenterWID BIGINT NULL Warehouse key referencing the center dimension.
MilestoneWID BIGINT NULL Warehouse key referencing the milestone dimension.
AchievedDate TIMESTAMP NULL Date/time when the user achieved the milestone.
CreatedOn TIMESTAMP NULL Date/time the milestone record was created in the source system.
CreatedByWID BIGINT NULL Warehouse key of the user who created this milestone record.
Status INT NULL Status code of the milestone achievement.
MilestoneCount BIGINT NULL Count of milestones associated with this record.
Void BOOLEAN NULL Flag indicating whether the record is voided (soft delete).

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

Factmilestoneswid

Foreign Keys

Column References
UserWID Bi_DimUser.userwid
CenterWID Bi_DimCenter.centerwid
CreatedByWID Bi_DimUser.userwid

Enumerator Values

Column Values
Status 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
Void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.