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 | Primary Key |
|---|---|---|
FactSegmentId | BIGINT | PK |
ChallengeUserID | VARCHAR(36) | |
UserWID | VARCHAR(36) | |
ChallengeWID | VARCHAR(36) | |
IsActive | BOOLEAN | |
AcceptedDate | TIMESTAMP | |
AchievedDate | TIMESTAMP | |
CreatedOn | TIMESTAMP | |
CreatedByWID | VARCHAR(36) | |
OrganizationId | VARCHAR(36) | |
Status | INT | |
CenterWId | VARCHAR(36) | |
ChallengeCount | BIGINT | |
PodName | VARCHAR(20) |
|
Void | BOOLEAN |
|
groupid | BIGINT | |
etlcreateddate | TIMESTAMP |
|
etlcreatedby | VARCHAR(50) |