Milestones dimension table (S3)
Table name: bi_dimmilestones_s3
This table stores data related to milestones, enabling efficient management, tracking, and reporting of milestone information.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
MilestonesPK | BIGINT | Primary key for this table. | PK |
MilestonesID | VARCHAR (36) | Unique identifier for the milestone. | |
MilestoneName | VARCHAR (2000) | Name of the milestone. | |
Level | INTEGER | Level of the milestone. | |
CheckInCount | INTEGER | Number of milestones needed to complete the level. | |
OrganizationId | VARCHAR (36) | Unique identifier for the organization. | |
Void | BOOLEAN | Indicates if the record is obsolete. | |
CreatedOn | TIMESTAMP | Date on which the milestone was created. | |
CreatedBy | VARCHAR (36) | Name of the user who created the milestone. | |
MilestonesMetricFK | BIGINT | ||
MilestoneMetricsName | VARCHAR (2000) | Name of the milestone metric. | |
ParentMileStoneMetricsName | VARCHAR (2000) | Name of the parent milestone metric. | |
etllastupdatedon | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |
etllastupdatedby | VARCHAR(50) | ETL system admin user who inserted or updated the corresponding record in this table. | |
PodName | VARCHAR(20) | Identifer for the region customer belongs to. Internal to Zenoti. | |
groupid | BIGINT | Internal to Zenoti. Used for data processing. |