Milestones fact table (Redshift)
Table name: bi_factmilestones
This table contains data related to milestone achievements, supporting efficient tracking, analysis, and reporting of user progress and performance
Field | Field Type | Description | Primary Key |
|---|---|---|---|
FactSegmentId | BIGINT | Source system identifier for the milestone segment |
|
Factmilestoneswid | BIGINT IDENTITY | Surrogate warehouse key for the milestone fact record. | PK |
MilestoneUserID | VARCHAR(36) | Unique identifier of the milestone-user record |
|
UserWID | BIGINT | Unique identifier of the user | |
CenterWID | BIGINT | Unique identifier for the center. | |
OrganizationId | VARCHAR(36) | Unique identifier of the organization. | |
MilestoneWID | BIGINT | Unique identifier for the milestone. | |
AchievedDate | TIMESTAMP | Date on which the milestone was achieved. | |
CreatedOn | TIMESTAMP | Date on which the milestone was created. | |
CreatedByWID | VARCHAR(36) | Name of the user who created the milestone. | |
Status | INT | Indicates the status of the milestone. | |
MilestoneCount | BIGINT | Total count of current milestone level. | |
PodName | VARCHAR(20) | Identifer for the region customer belongs to. Internal to Zenoti. |
|
Void | BOOLEAN | Indicates if the record is obsolete. |
|
groupid | BIGINT | Internal to Zenoti. Used for data processing. | |
etlcreateddate | TIMESTAMP | Date on which the row was created in the table. | |
etlcreatedby | VARCHAR(50) | ETL system admin user who inserted or updated the corresponding record in this table. | |
etllastupdatedon | TIMESTAMP | Timestamp of the last ETL update (defaults to current UTC time). | |
etllastupdatedby | VARCHAR(50) | User or process that last updated this record via ETL (defaults to current user). |