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.