NAV

Wellness Campaign Analytics Feed Type

Overview

The Wellness Campaign Analytics bundle contains data about wellness campaigns for a tenant.

Character Separated Values (CSV) Properties

Property Value
Header Record Yes
Field Delimiter Comma
Record Delimiter CR/LF
Character Encoding UTF-8

Files

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 Definitions

Wellness_D_CMP_Configurations

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)

Wellness_D_CMP_Categories

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

Wellness_D_CMP_Membership_Histories

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

Wellness_D_CMP_Memberships

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

Wellness_D_CMP_Populations

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)

Wellness_D_INC_Adjustment_Points

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)

Wellness_D_INC_Alternative_Goals

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

Wellness_D_INC_Incentives

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

Wellness_D_INC_Consumer_Points

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

Wellness_D_INC_Primary_Goals

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

Wellness_D_INC_Points

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)

Wellness_F_INC_Goal_Exemptions

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

Wellness_F_INC_Goal_Transactions

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

Wellness_F_INC_Consumer_Goals

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

Wellness_F_INC_Consumer_Incentives

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

Wellness_F_INC_Goal_Conditions

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)

Wellness_F_INC_Goal_Sources

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)

Wellness_F_INC_Overall_Consumer_Goals

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

Wellness_F_INC_Transactions

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