Challenges fact table (Redshift)
Table name: bi_factchallenges
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) | ||
UserWID | VARCHAR(36) | ||
ChallengeWID | VARCHAR(36) | Unique ID of the challenge. | |
IsActive | BOOLEAN | Indicates if 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. | |
CreatedByWID | 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. | |
CenterWId | VARCHAR(36) | Unique identifier of 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. |