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. |
|
ChallengeID | VARCHAR (36) | Unique ID of the challenge. | |
dimchallangeswid | BIGINT IDENTITY | Surrogate warehouse key for the challenge (Primary Key) | PK |
ChallengeName | VARCHAR (2000) | Name of the challenge. | |
ChallengeDescription | VARCHAR (65535) | Description of the challenge. | |
ChallengeMetricsFK | BIGINT | Foreign key referencing the challenge metrics definition | |
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. |