Challenges fact table (S3)
Table name: bi_factchallenges_s3
This table stores data on user participation in challenges, enabling efficient tracking, analysis, and reporting of user performance.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
FactSegmentId | BIGINT | Primary key for this table. | PK |
ChallengeUserID | VARCHAR(36) | ||
UserID | VARCHAR(36) | ||
ChallengeID | VARCHAR(36) | Unique ID of the challenge. | |
IsActive | BOOLEAN | Indicates whether the challenge is active. | |
AcceptedDate | TIMESTAMP | Date on which the student accepted the challenge. | |
AchievedDate | TIMESTAMP | Date on which the student completed the challenge. | |
CreatedOn | TIMESTAMP | Date on which the challenge was created. | |
CreatedBy | VARCHAR(36) | Name of the user who created the challenge. | |
OrganizationId | VARCHAR(36) | Unique identifier for the organization. | |
Status | INT | Indicates the status of the challenge. | |
CenterId | VARCHAR(36) | Unique identifier for the center. | |
ChallengeCount | BIGINT | Current count of the challenge metrics. | |
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. |