Challenges dimension table (Redshift)
Table name: bi_dimchallenges
This table contains data related to challenges, designed to enable efficient management, reporting, and analytical processes.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
ChallengePK | BIGINT | Primary key for this table. | PK |
ChallengeID | VARCHAR (36) | Unique ID of the challenge. | |
ChallengeName | VARCHAR (2000) | Name of the challenge. | |
ChallengeDescription | VARCHAR (65535) | Description of the challenge. | |
ChallengeMetrics | BIGINT | Metric of challenge (for example, # of classes attended). |
|
ChallengeTypeCount | INTEGER | Count of challenge metrics needed to complete the metric. | |
ChallengeStartDate | TIMESTAMP | Start date of the challenge. | |
ChallengeEndDate | TIMESTAMP | End date of the challenge. | |
RuleId | VARCHAR (36) | Unique identifier of the rule associated with the challenge. | |
CreatedOn | TIMESTAMP | Date on the which the challenge was created. | |
CreatedBy | VARCHAR (36) | Name of the user who created the challenge. | |
OrganizationId | VARCHAR (36) | Unique identifier for the organization. | |
Void | BOOLEAN | Indicates if the record is obsolete. | |
ChallengeMetricsName | VARCHAR (2000) | Name of the challenge metric. | |
ParentChallengeMetricsName | VARCHAR (2000) | Name of the parent challenge 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. |