Consumer Onboarding Analytics Schema v1
Overview
The Consumer Onboarding Analytics bundle contains the data used to onboard a consumer for the Oracle Health Data Intelligence Wellness application.
Character Separated Values (CSV) Properties
| Property |
Value |
| Header Record |
Yes |
| Field Delimiter |
Comma |
| Record Delimiter |
CR/LF |
| Character Encoding |
UTF-8 |
Files
Field Definitions
Wellness_Application_F_ENR_Eligibility_Records
| Field |
Definition |
Data Type |
| eligibility_record_id |
The ID of the eligibility record. |
VARCHAR(36) |
| member_identifier |
The tenant-configurable ID that uniquely identifies an eligible member. |
VARCHAR(191) |
| consumer_id |
The ID of the associated consumer. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| date_of_birth |
The birth date of an eligible member in International Organization for Standardization (ISO) 8601 yyyy-mm-dd format. |
DATE |
| middle_name |
The middle name of an eligible member. |
VARCHAR(255) |
| given_name |
The first name of an eligible member. |
VARCHAR(255) |
| gender |
The administrative gender code of an eligible member. The administrative gender can differ from an eligible member’s clinical sex, preferred gender identity, legal sex, and birth sex. |
INTEGER |
| member_group |
The member group of an eligible member. This information is used to attach an alias to a consumer group in the Consumer Well-being system. |
VARCHAR(255) |
| relationship |
The relationship of an eligible member to a client, for example, EMPLOYEE_SPOUSE is a spouse of an employee. |
VARCHAR(255) |
| termination_date |
The termination date of an eligible member. This date indicates when an eligible member is disabled from using the Consumer Well-being system. |
DATE |
| updated_by_id |
An ID for a system or person (such as an administrator) that creates or updates the eligibility record. |
VARCHAR(36) |
| updated_by_type |
The type describes who or what created or updated the eligibility record. |
INTEGER |
| create_dt_tm |
The date and time when the eligibility record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the eligibility record was last updated. |
TIMESTAMPTZ |
| Field |
Definition |
Data Type |
| additional_information_id |
The ID of the additional information of an eligibility record. |
VARCHAR(36) |
| eligibility_record_id |
The ID of the eligibility record. |
VARCHAR(36) |
| name |
A name of the field that describes the metadata of the eligibility record. |
VARCHAR(191) |
| value |
The value of the metadata of the eligibility record. |
VARCHAR(191) |
| create_dt_tm |
The date and time when the additional information of the eligibility record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the additional information of the eligibility record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Terminated_Records
| Field |
Definition |
Data Type |
| terminated_record_id |
The ID of the terminated record associated with an eligibility record. |
VARACHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer associated with the terminated record. |
VARCHAR(36) |
| member_identifier |
The tenant-configurable unique ID of an eligible member. |
VARCHAR(191) |
| member_group |
The member group of an eligible member. This information is used to attach an alias to a consumer group in the Consumer Well-being system. |
VARCHAR(130) |
| termination_date |
The date when access to the Consumer Well-being system was disabled for an eligible member. |
DATE |
| onboarding_date |
The date when a consumer was onboarded as an eligible member. |
DATE |
| create_dt_tm |
The date and time when the eligibility record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the eligibility record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Completed_User_Enrollments
| Field |
Definition |
Data Type |
| user_enrollment_id |
The ID of the completed user enrollment. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| consumer_id |
The ID of the associated consumer. |
VARCHAR(191) |
| idp_entity_id |
The ID of the entity used by the identity provider. |
VARCHAR(255) |
| idp_principal |
The principal used by the identity provider. |
VARCHAR(255) |
| domain |
The domain with which the enrolled user is associated. |
VARCHAR(255) |
| terms_of_use_acceptance_id |
The ID of the terms of use acceptance. |
VARCHAR(255) |
| create_dt_tm |
The date and time when the completed user enrollment record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the completed user enrollment record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Consumer_Site_Associations
| Field |
Definition |
Data Type |
| consumer_site_association_id |
The ID of the consumer site association. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| consumer_id |
The ID of the associated consumer. |
VARCHAR(36) |
| domain_name |
The name of the associated web domain. |
VARCHAR(191) |
| end_effective_dt_tm |
The date and time from which a particular association ended. |
TIMESTAMPTZ |
| create_dt_tm |
The date and time when the consumer site association record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the consumer site association record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Terms_Of_Use
| Field |
Definition |
Data Type |
| terms_of_use_id |
The ID of the terms of use. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| tou_identifier |
The tenant-configurable unique ID for the terms of use. |
VARCHAR(255) |
| reset_date |
The date the terms of use would be prompted to accept again. |
DATE |
| create_dt_tm |
The date and time when the terms of use record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the terms of use record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Terms_Of_Use_Translations
| Field |
Definition |
Data Type |
| terms_of_use_translations_id |
The ID of the terms of use translations. |
VARCHAR(36) |
| locale |
The locale of the terms of use. |
VARCHAR(255) |
| content |
The content for the terms of use to be displayed. |
VARCHAR(255) |
| terms_of_use_id |
The ID of the terms of use. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the terms of use translations record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the terms of use translations record was last updated. |
TIMESTAMPTZ |
Wellness_Application_F_ENR_Tou_Acceptances
| Field |
Definition |
Data Type |
| tou_acceptances_id |
The ID of the terms of use acceptances. |
VARCHAR(36) |
| tou_id |
The ID of the terms of use. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(36) |
| consumer_id |
The ID of the consumer who accepted the terms of use. |
VARCHAR(36) |
| domain_name |
The name of the associated web domain. |
VARCHAR(255) |
| create_dt_tm |
The date and time when the terms of use acceptances record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the terms of use acceptances record was last updated. |
TIMESTAMPTZ |
