Challenges Analytics Schema v1
Overview
The Challenges Analytics bundle contains data used in the Oracle Health Data Intelligence Challenges service.
Character Separated Values (CSV) Properties
| Property |
Value |
| Header Record |
Yes |
| Field Delimiter |
Comma |
| Record Delimiter |
CR/LF |
| Character Encoding |
UTF-8 |
Files
Field Definitions
Consumer_Engagement_D_CG_ChallengeGoals
| Field |
Definition |
Data Type |
| goal_id |
The ID of the challenge goal. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| type |
The type of the challenge goal. |
VARCHAR(36) |
| value |
The target number for meeting the challenge goal. |
INTEGER |
| unit |
The unit for displaying the type of the challenge goal. |
VARCHAR(36) |
| name |
The translated name of the challenge goal. |
VARCHAR(191) |
| description |
The description of the challenge goal. |
VARCHAR(255) |
| locale |
The locale. Locales must match the ISO 639-1 specification, which uses a two-letter code to identify the language and is separated by a hyphen. |
VARCHAR(6) |
Consumer_Engagement_D_CD_ChallengeDefinitions
| Field |
Definition |
Data Type |
| challenge_id |
The ID of the challenge definition. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| time_zone |
The time zone in which the challenge was set up. This value matches a valid time zone in the Internet Assigned Numbers Authority (IANA) database. See Time Zone Database on the IANA website for more information. |
VARCHAR(191) |
| starts_at_dt_tm |
The start date and time of the challenge. |
TIMESTAMPTZ |
| ends_at_dt_tm |
The end date and time of the challenge. |
TIMESTAMPTZ |
| registration_starts_at_dt_tm |
The start date and time of registration for a challenge. |
TIMESTAMPTZ |
| registration_ends_at_dt_tm |
The end date and time of registration for a challenge. |
TIMESTAMPTZ |
| image_url |
The image URL corresponding to the challenge. |
VARCHAR(255) |
| name |
The translated name of the challenge. |
VARCHAR(191) |
| description |
The description of the challenge. |
VARCHAR(255) |
| locale |
The locale. Locales must match the ISO 639-1 specification, which uses a two-letter code to identify the language and is separated by a hyphen. |
VARCHAR(6) |
| catalog_id |
The ID of the catalog associated with the challenge. |
VARCHAR(36) |
| category_id |
The ID of the category associated with the challenge. |
VARCHAR(36) |
| goal_id |
The ID of the goal associated with the challenge. |
VARCHAR(36) |
Consumer_Engagement_F_CR_ChallengeRegistrations
| Field |
Definition |
Data Type |
| registration_id |
The ID of the challenge registration. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer. |
VARCHAR(36) |
| status |
The status to keep track of whether a consumer is currently registered or unregistered for a challenge. |
VARCHAR(15) |
| challenge_id |
The ID of the challenge with which this registration is associated. |
VARCHAR(36) |
Consumer_Engagement_D_CC_ChallengeCatalogs
| Field |
Definition |
Data Type |
| catalog_id |
The ID of the challenge catalog. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| name |
The translated name of the challenge catalog. |
VARCHAR(191) |
| description |
The description of the challenge catalog. |
VARCHAR(255) |
| locale |
The locale. Locales must match the ISO 639-1 specification, which uses a two-letter code to identify the language and is separated by a hyphen. |
VARCHAR(6) |
Consumer_Engagement_D_CC_ChallengeCategories
| Field |
Definition |
Data Type |
| category_id |
The ID of the challenge category. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| name |
The translated name of the challenge category. |
VARCHAR(191) |
| description |
The description of the challenge category. |
VARCHAR(255) |
| locale |
The locale. Locales must match the ISO 639-1 specification, which uses a two-letter code to identify the language and is separated by a hyphen. |
VARCHAR(6) |
Consumer_Engagement_D_CC_ChallengeConfigurations
| Field |
Definition |
Data Type |
| challenge_config_id |
The ID of the challenge configuration. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| domain |
The domain name of the challenge configuration. |
VARCHAR(191) |
| catalog_id |
The ID of the catalog associated with the challenge configuration. |
VARCHAR(36) |
Consumer_Engagement_D_TCD_TeamChallengeDefinitions
| Field |
Definition |
Data Type |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| time_zone |
The time zone in which team challenge was set up. This value matches a valid time zone in the IANA database. See Time Zone Database on the IANA website for more information. |
VARCHAR(191) |
| max_team_registrations |
The maximum number of registrations allowed for a team participating in a team challenge. |
INTEGER |
| starts_at_dt_tm |
The start date and time of the team challenge. |
TIMESTAMPTZ |
| ends_at_dt_tm |
The end date and time of the team challenge. |
TIMESTAMPTZ |
| registration_starts_at_dt_tm |
The start date and time of registration for a team challenge. |
TIMESTAMPTZ |
| registration_ends_at_dt_tm |
The end date and time of registration for a team challenge. |
TIMESTAMPTZ |
| image_url |
The image URL corresponding to the team challenge. |
VARCHAR(255) |
| team_challenge_name |
The translated name of the team challenge. |
VARCHAR(191) |
| team_challenge_description |
The description of the team challenge. |
VARCHAR(255) |
| locale |
The locale. Locales must match the ISO 639-1 specification, which uses a two-letter code to identify the language and is separated by a hyphen. |
VARCHAR(6) |
| catalog_id |
The ID of the catalog associated with the team challenge. |
VARCHAR(36) |
| category_id |
The ID of the category associated with the team challenge. |
VARCHAR(36) |
| goal_id |
The ID of the goal associated with the team challenge. |
VARCHAR(36) |
Consumer_Engagement_D_TD_TeamDefinitions
| Field |
Definition |
Data Type |
| team_id |
The ID of the team. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| team_name |
The name of the team. |
VARCHAR(255) |
| team_description |
The description of the team. |
VARCHAR(1000) |
| image_url |
The image URL corresponding to the team. |
VARCHAR(1000) |
| creator_kind |
The kind of user who created the team. It could be set to ADMIN or CONSUMER. |
VARCHAR(36) |
| creator_id |
The ID of the creator of the team. If the creator is of kind ADMIN, the id field can be null. |
VARCHAR(36) |
Consumer_Engagement_F_TR_TeamRegistrations
| Field |
Definition |
Data Type |
| team_registration_id |
The ID of the team registration. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| team_id |
The ID of the team. |
VARCHAR(36) |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer. |
VARCHAR(36) |
Consumer_Engagement_D_TA_TeamAvailabilities
| Field |
Definition |
Data Type |
| team_availability_id |
The ID of the team availability. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| team_id |
The ID of the team. |
VARCHAR(36) |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| available_registrations |
The number of available registrations in the team. |
INTEGER |
Consumer_Engagement_F_CO_ChallengeOutcomes
| Field |
Definition |
Data Type |
| challenge_outcome_id |
The ID of the challenge outcome. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| challenge_id |
The ID of the challenge. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer. |
VARCHAR(36) |
| total |
The total amount of activity done by the consumer in the challenge. |
INTEGER |
| rank |
The rank of the consumer compared to other consumers in the challenge. |
INTEGER |
| status |
The status showing whether a consumer has completed the challenge or not. |
VARCHAR(191) |
| unit |
The unit of measure for the total amount of activity done by consumer in the challenge. |
VARCHAR(191) |
Consumer_Engagement_D_TCO_TeamChallengeOutcomes
| Field |
Definition |
Data Type |
| team_challenge_outcome_id |
The ID of the team challenge outcome. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| team_id |
The ID of the team. |
VARCHAR(36) |
| total |
The total amount of activity done by a team in the team challenge. |
INTEGER |
| average |
The average amount of activity done by each consumer of the team in the team challenge. |
DOUBLE |
| rank |
The rank of the team compared to other teams in the team challenge. |
INTEGER |
| status |
The status showing whether a team has met the team challenge goals or not. |
VARCHAR(191) |
| unit |
The unit of measure for the total amount of activity done by a team in the team challenge. |
VARCHAR(191) |
Consumer_Engagement_F_TO_TeamOutcomes
| Field |
Definition |
Data Type |
| team_outcome_id |
The ID of the team outcome. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| team_challenge_id |
The ID of the team challenge. |
VARCHAR(36) |
| team_id |
The ID of the team. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer. |
VARCHAR(36) |
| total |
The total amount of activity done by a consumer in the team challenge. |
INTEGER |
| rank |
The rank of the consumer compared to other consumers in the team. |
INTEGER |
| status |
The status showing whether a consumer’s team has met the team challenge goal or not. |
VARCHAR(191) |
| unit |
The unit of measure for the total amount of activity done by a consumer in the team challenge. |
VARCHAR(191) |
