The Wellness Campaign Analytics bundle contains data about wellness campaigns for a tenant.
Property | Value |
---|---|
Header Record | Yes |
Field Delimiter | Comma |
Record Delimiter | CR/LF |
Character Encoding | UTF-8 |
File Name | Description |
---|---|
Wellness_D_CMP_Configurations | This table contains the version records of a campaign. These version records are also known as instances or configurations. A wellness campaign is an incentive program designed to motivate members to improve their health by completing incentivized activities. A campaign is an organized collection of incentivized activities grouped into categories, subcategories, and groups. A category can have subcategories and a subcategory can have groups. A campaign instance is generated using all the configuration data. |
Wellness_D_CMP_Categories | This table contains category definitions across all instances of wellness campaigns. |
Wellness_D_CMP_Membership_Histories | This table contains all the campaign-to-consumer mappings that were deleted. |
Wellness_D_CMP_Memberships | This table contains the campaign-to-consumer mappings. |
Wellness_D_CMP_Populations | This table contains the details of all populations across all instances of wellness campaigns. |
Wellness_D_INC_Adjustment_Points | Participation in a wellness campaign is incentivized through rewards (also known as points). This table contains the details of adjustment rewards across all instances of wellness campaigns and their categories. |
Wellness_D_INC_Alternative_Goals | Wellness campaigns define objectives (also known as goals) for a consumer to complete to make them eligible for earning rewards. This table contains the details of all the alternative objectives across all instances of wellness campaigns and their categories. |
Wellness_D_INC_Incentives | Primary objectives (also known as goals) for categories in wellness campaigns have incentives. This table contains the details of the incentives associated with primary objectives. |
Wellness_D_INC_Consumer_Points | This table contains all reward-to-consumer mappings. Rewards are also known as points. |
Wellness_D_INC_Primary_Goals | Wellness campaigns define objectives (also known as goals) for a consumer to complete to make them eligible for earning rewards. This table contains the details of all the primary objectives across all instances of wellness campaigns and their categories. |
Wellness_D_INC_Points | Participation in a wellness campaign is incentivized through rewards (also known as points). This table contains the details of rewards across all instances of wellness campaigns and their categories. |
Wellness_F_INC_Goal_Exemptions | Objectives (also known as goals) can have exemptions defined for them. This table contains details of exemptions awarded to consumers across all instances of wellness campaigns. |
Wellness_F_INC_Goal_Transactions | This table contains details to support consumer objectives (also known as goals) across all instances of wellness campaigns. |
Wellness_F_INC_Consumer_Goals | This table contains all instances of consumers’ fulfillment of objectives (also known as goals). |
Wellness_F_INC_Consumer_Incentives | This table contains all instance of consumers’ incentives. |
Wellness_F_INC_Goal_Conditions | This table contains definitions for objectives’ (also known as goals) completion criteria across all objectives. |
Wellness_F_INC_Goal_Sources | This table contains details of the acceptable sources across all objectives (also known as goals). |
Wellness_F_INC_Overall_Consumer_Goals | This table contains all instances of consumers’ overall fulfillment of objectives (also known as goals). |
Wellness_F_INC_Transactions | This table contains details to support consumer rewards (also known as points) across all instances of wellness campaigns. |
Field | Definition | Data Type |
---|---|---|
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the campaign configuration record. | VARCHAR(36) |
campaign_id | The ID of the incentive campaign. | VARCHAR(36) |
campaign_category_id | The ID of the root category for the incentive campaign. | VARCHAR(36) |
created_at_dt_tm | The date and time when the campaign configuration record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the campaign configuration record was last updated. | TIMESTAMPTZ |
campaign_starts_at_dt_tm | The date and time when the incentive campaign starts. | TIMESTAMPTZ |
campaign_ends_at_dt_tm | The date and time when the incentive campaign ends. | TIMESTAMPTZ |
campaign_is_published | Indicates whether the incentive campaign is published. This field is deprecated. | BOOLEAN |
campaign_completion_threshold | The minimum number of objectives (also know as goals) that the consumer needs to complete the campaign. | INTEGER |
campaign_name | The name of the incentive campaign. | VARCHAR(191) |
campaign_description | The description of the incentive campaign. | VARCHAR(65000) |
campaign_created_at | The date and time when the incentive campaign was created. | TIMESTAMPTZ |
campaign_updated_at | The date and time when the incentive campaign was last updated. | TIMESTAMPTZ |
campaign_time_zone | The time zone in which this campaign is created. | VARCHAR(191) |
Field | Definition | Data Type |
---|---|---|
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
category_id | The ID of the category. | VARCHAR(36) |
parent_category_id | The ID of the associated parent category. | VARCHAR(36) |
category_name | The name of the category. | VARCHAR(191) |
category_description | The description of the category. | VARCHAR(65000) |
category_starts_at_dt_tm | The date and time when the category starts. | TIMESTAMPTZ |
category_ends_at_dt_tm | The date and time when the category ends. | TIMESTAMPTZ |
category_is_published | Indicates whether the campaign is published. This field is deprecated. | BOOLEAN |
category_completion_threshold | The minimum number of objectives (also known as goals) that the consumer needs to complete the category. | INTEGER |
created_at_dt_tm | The date and time when the category was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the category was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
campaign_membership_histories_id | The ID of the campaign membership history record. | BIGINT |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_id | The ID of the incentive campaign. | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
process_id | The ID of the system or process that requests the deletion of the incentive campaign membership. | VARCHAR(36) |
original_id | The ID of the campaign membership that was deleted. | VARCHAR(36) |
original_process_id | The ID of a system or process that requested the creation of the campaign membership. | VARCHAR(36) |
created_at_dt_tm | The date and time when an incentive campaign membership history record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when an incentive campaign membership history record was updated. | TIMESTAMPTZ |
original_created_at_dt_tm | The date and time when the original campaign membership record was created. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
campaign_membership_id | The ID of the campaign membership. | VARCHAR(36) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_id | The ID of the incentive campaign. | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
process_id | The ID of a system or process that requested the creation of the campaign membership. | VARCHAR(36) |
created_at_dt_tm | The date and time when a campaign membership record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when a campaign membership record was updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
population_id | The ID of the population | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
data_partition_id | The ID of the data partition. | VARCHAR(36) |
Field | Definition | Data Type |
---|---|---|
adjustment_point_id | The ID of the adjustment reward (also known as point) record. | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_category_id | The ID of the associated parent category. | VARCHAR(36) |
point_value | The value of the adjustment reward (also known as point) that is awarded every time a reward is earned. | INTEGER |
point_limit | The maximum number of adjustment rewards (also known as points) that can be earned. | INTEGER |
singular_unit | The singular value for the adjustment reward (also known as point) unit. | VARCHAR(191) |
plural_units | The plural value for the adjustment reward (also known as point) unit. | VARCHAR(191) |
locale | The locale of the adjustment reward (also known as point) unit. | VARCHAR(36) |
Field | Definition | Data Type |
---|---|---|
alternative_goal_id | The ID of the alternative objective (also known as goal) record. | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_primary_goal_id | The ID of the associated parent category. | VARCHAR(36) |
activity_definition_id | The ID of the associated activity for the alternative objective (also known as goal). | VARCHAR(36) |
source_definition_id | The ID of the source system where the associated activity is defined. | VARCHAR(36) |
source_definition_type | The type of source system where the activity is defined (EDUCATION_MODULE or QUESTIONNAIRE). | VARCHAR(191) |
frequency | Indicates how often the alternative objective (also known as goal) can be achieved (DAILY, WEEKLY, MONTHLY, QUARTERLY, BI_ANNUALLY, ANNUALLY, ONE_TIME). | VARCHAR(15) |
is_repeatable_within_frequency | Indicates whether the alternative objective (also known as goal) can be achieved multiple times in the alternative objective’s frequency. | BOOLEAN |
starts_at_dt_tm | The date and time when the alternative objective (also known as goal) starts. | TIMESTAMPTZ |
ends_at_dt_tm | The date and time when the alternative objective (also known as goal) ends. | TIMESTAMPTZ |
max_completion_count | The maximum number of times the alternative objective (also known as goal) can be achieved. | INTEGER |
accepts_all_sources | Indicates whether all sources are acceptable. | BOOLEAN |
needs_verification | Indicates whether the alternative objective (also known as goal) must be verified. When this is set to true, the alternative objective must be verified and marked as complete by an administrator or care provider. | BOOLEAN |
alternative_goal_title | The name of the alternative objective (also known as goal). | VARCHAR(191) |
alternative_goal_description | The description of the alternative objective (also known as goal). | VARCHAR(65000) |
created_at_dt_tm | The date and time when the alternative objective (also known as goal) was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the alternative objective (also known as goal) was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
incentive_id | The ID of the incentive record. | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_primary_goal_id | The ID of the associated parent primary objective (also known as goal). | VARCHAR(36) |
reward_limit_per_frequency | The maximum number of times a consumer can earn points for achieving the primary objective (also known as goal) in a frequency. | INTEGER |
created_at_dt_tm | The date and time when the incentive record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the incentive record was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
consumer_point_id | The ID of the consumer incentive record. | VARCHAR(36) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
point_id | The ID of the associated reward or adjustment reward (also known as point). | VARCHAR(36) |
earned | The earned reward (also known as point). This is the total number of points that the consumer earned, regardless of the limit for the reward. | INTEGER |
effective | The effective of the earned reward (also known as point). This is the number of points that the consumer earns after the limit of the reward is applied. | INTEGER |
created_at_dt_tm | The date and time when the reward (also known as point) was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the reward (also known as point) was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
primary_goal_id | The ID of the primary objective (also known as goal). | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_category_id | The ID of the associated parent category. | VARCHAR(36) |
activity_definition_id | The ID of the associated activity. | VARCHAR(36) |
source_definition_id | The ID of the source system where the activity is defined. | VARCHAR(36) |
source_definition_type | The type of source system where the activity is defined (EDUCATION_MODULE or QUESTIONNAIRE). | VARCHAR(191) |
frequency | Indicates how often the primary objective (also known as goal) can be achieved (DAILY, WEEKLY, MONTHLY, QUARTERLY, BI_ANNUALLY, ANNUALLY, ONE_TIME). | VARCHAR(15) |
is_repeatable_within_frequency | Indicates whether the primary objective (also known as goal) can be achieved multiple times in the primary objective’s frequency. | BOOLEAN |
starts_at_dt_tm | The date and time when the primary objective (also known as goal) starts. | TIMESTAMPTZ |
ends_at_dt_tm | The date and time when the primary objective (also known as goal) ends. | TIMESTAMPTZ |
max_completion_count | The maximum number of times the primary objective (also known as goal) can be achieved. | INTEGER |
accepts_all_sources | Indicates whether all sources are acceptable. | BOOLEAN |
needs_verification | Indicates whether the primary objective (also known as goal) must be verified. When this is set to true, the primary objective must be verified and marked as complete by an administrator or care provider. | BOOLEAN |
primary_goal_title | The name of the primary objective (also known as goal). | VARCHAR(191) |
primary_goal_description | The description of the primary objective (also known as goal). | VARCHAR(65000) |
created_at_dt_tm | The date and time when the primary objective (also known as goal) was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the primary objective (also known as goal) was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
point_id | The ID of the point record. | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_category_id | The ID of the associated parent category. | VARCHAR(36) |
parent_incentive_id | The ID of the associated parent incentive. | VARCHAR(36) |
point_value | The value that is awarded every time a reward (also known as point) is earned. | INTEGER |
point_limit | The maximum number of rewards (also known as points) that can be earned. | INTEGER |
singular_unit | The singular value for the reward (also known as point) unit. | VARCHAR(191) |
plural_units | The plural value for the reward (also known as point) unit. | VARCHAR(191) |
locale | The locale of the adjustment reward (also known as point) unit. | VARCHAR(36) |
Field | Definition | Data Type |
---|---|---|
goal_exemptions_id | The ID of the objective (also known as goal) exemption record. | VARCHAR(36) |
consumer_goal_id | The ID of the associated consumer objective (also known as goal). | VARCHAR(36) |
exemption_count | The number of exemptions awarded by an administrator for the objective (also known as goal) in the given frequency. | INTEGER |
created_at_dt_tm | The date and time when the objective (also known as goal) exemption record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the objective (also known as goal) exemption record was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
goal_transaction_id | The ID of the transaction record that supports a consumer objective (also known as goal). | VARCHAR(36) |
consumer_goal_id | The ID of the associated consumer objective (also known as goal). | VARCHAR(36) |
consumer_source_id | The ID of the consumer’s instance of a completed activity from a source system. | VARCHAR(36) |
source_definition_id | The definition ID that corresponds to the consumer source. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
created_at_dt_tm | The date and time when the transaction record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the transaction record was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
consumer_goal_id | The ID of the consumer objective (also known as goal) record. | VARCHAR(36) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
goal_id | The ID of the associated primary or alternative objective (also known as goal). | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
overall_consumer_goal_id | If applicable, this is the ID of the associated overall consumer objective (also known as goal). | VARCHAR(36) |
status | The status of the consumer objective (also known as goal). | VARCHAR(15) |
frequency_begins_at_dt_tm | The beginning date and time of the frequency for the objective (also known as goal). | TIMESTAMPTZ |
completion_count | Indicates the number of times the primary or alternative objective (also known as goal) is achieved in the given frequency. This is the sum of activityCount and exemptionCount values. | INTEGER |
activity_count | The number of times the consumer accomplishes the objective (also known as goal) in the given frequency. | INTEGER |
created_at_dt_tm | The date and time when the consumer objective (also known as goal) record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the consumer objective (also known as goal) record was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
consumer_incentives_id | The ID of the consumer incentive record. | VARCHAR(36) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
incentive_id | The ID of the associated incentive record. | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
consumer_goal_id | The ID of the associated consumer objective (also known as goal) record. | VARCHAR(36) |
consumer_point_id | The ID of the associated consumer reward (also known as point) record. | VARCHAR(36) |
rewarded_count | The number of times the incentive has been awarded for the objective (also known as goal) frequency. | INTEGER |
created_at_dt_tm | The date and time when the consumer incentive record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the consumer incentive record was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
goal_conditions_id | The ID of the objective (also known as goal) condition. | VARCHAR(36) |
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_goal_id | The ID of the associated primary or alternative objective (also known as goal). | VARCHAR(36) |
value | The value of the condition. | VARCHAR(255) |
operator | The conditional operator of the objective (also known as goal).The accepted values are =, >, <, <=, >=, INCREASE_PERCENTAGE, DECREASE_PERCENTAGE, IMPROVE_PERCENTAGE, and MATCHES. | VARCHAR(50) |
target | The target range of the associated primary or alternative objective (also known as goal). | VARCHAR(255) |
subtype | The subtype against which the condition type is compared, for example, SYSTOLIC or DIASTOLIC. | VARCHAR(36) |
consumer_condition_type | The type of conditions related to the consumer. The accepted values are AGE, GENDER, and DIABETIC. | VARCHAR(15) |
Field | Definition | Data Type |
---|---|---|
campaign_definition_key | The composite key that can be used to associate data across data files. The key is the combination of the tenant_id, campaign_configuration_id, and campaign_id fields. | VARCHAR(110) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
campaign_id | The ID of the associated incentive campaign. | VARCHAR(36) |
parent_goal_id | The ID of the associated primary or alternative objective (also known as goal). | VARCHAR(36) |
value | The sources that are permitted to meet an objective (also known as goal). If this is not specified, all sources are permitted. The allowed values are SPECIFIC_PROVIDER, CLAIM, SELF_ENTERED, APP_DEVICE, COACH_ENTERED, ADMINISTRATOR_UPLOADED, and EMR_DW_INTEGRATION. | VARCHAR(36) |
Field | Definition | Data Type |
---|---|---|
overall_consumer_goal_id | The ID of the overall consumer objective (also known as goal). | VARCHAR(30) |
tenant_id | The ID of the tenant. | VARCHAR(36) |
goal_id | The ID of the associated primary alternative objective (also known as goal). | VARCHAR(36) |
consumer_id | The ID of the consumer. | VARCHAR(36) |
status | The status of the overall consumer objective (applies to completion-based objectives). | VARCHAR(15) |
completion_count | The number of times an objective (also known as goal) has been completed by the user (applies to completion-based objectives). | INTEGER |
created_at_dt_tm | The date and time when the overall consumer objective (also known as goal) was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the overall consumer objective (also known as goal) was last updated. | TIMESTAMPTZ |
Field | Definition | Data Type |
---|---|---|
transactions_id | The ID of the transaction for an earned reward (also known as point). | VARCHAR(36) |
consumer_point_id | The ID of the associated consumer point record (also known as point). | VARCHAR(36) |
campaign_configuration_id | The ID of the associated campaign configuration. | VARCHAR(36) |
delta | The delta of the reward (also known as point). This is the change in the reward total that the transaction causes and can be negative or positive. | INTEGER |
reference_system | The reference system in which reward (also known as point) is identified. | VARCHAR(36) |
reference_id | The ID of reward (also known as point) in the reference system. | VARCHAR(36) |
created_at_dt_tm | The date and time when the transaction record was created. | TIMESTAMPTZ |
updated_at_dt_tm | The date and time when the transaction record was last created. | TIMESTAMPTZ |