Consumer Engagement Analytics Schema v1
Overview
The Consumer Engagement Analytics bundle contains data used in the Oracle Health Data Intelligence Consumer Engagement service.
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 |
| Consumer_Engagement_F_EVT_Addresses |
This table contains information about the venue addresses where the event is being held. |
| Consumer_Engagement_F_EVT_Attendances |
This table contains information about the consumers who attended each event and slot. |
| Consumer_Engagement_F_EVT_Categories |
This table contains information about the category to which an event belongs. |
| Consumer_Engagement_F_EVT_Codes |
This table contains information about an event category’s code, which represents a concept from a single, specified (not fixed) code system. No restrictions exist for the code system. It can be local and proprietary or standard and recognized by Health Data Intelligence. |
| Consumer_Engagement_F_EVT_Events |
This table contains information about an event. This includes event details such as the name, start time, end time, and multiple slot information. |
| Consumer_Engagement_F_EVT_Leaders |
This table contains information about the individual who will provide guidance and instructions for the event. |
| Consumer_Engagement_F_EVT_Locations |
This table contains information about the event’s location. |
| Consumer_Engagement_F_EVT_Registrations |
This table contains registration information. A registration defines which consumer registered for which slot, event, and series. |
| Consumer_Engagement_F_EVT_Series |
This table contains information about an event series. An event series groups related events. |
| Consumer_Engagement_F_EVT_Slots |
This table contains information about an event’s slot. It contains details such as the number of available registrations, the maximum registration limit, the cutoff time for registration, the slot starting time, and the slot ending time. |
| Consumer_Engagement_F_EVT_Telecoms |
This table contains the contact details of the person who is assigned as the leader of the event or series. |
Field Definitions
Consumer_Engagement_F_EVT_Addresses
| Field |
Definition |
Data Type |
| address_id |
The ID of the venue address. |
VARCHAR(36) |
| city |
The city of the event venue. |
VARCHAR(191) |
| district |
The district of the event venue. |
VARCHAR(191) |
| state |
The state of the event venue. |
VARCHAR(191) |
| country |
The country of the event venue. |
VARCHAR(191) |
| postal_code |
The postal code of the event venue. |
VARCHAR(191) |
| location_id |
The ID of the location. |
VARCHAR(191) |
| lines |
The lines of the address that indicate the building number, street number, street name, street direction, and similar address information. |
VARCHAR |
| create_dt_tm |
The date and time when the address record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the address record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Attendances
| Field |
Definition |
Data Type |
| attendance_id |
The ID of the event attendance. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| event_id |
The ID of the event. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the attendance record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the attendance record was updated. |
TIMESTAMPTZ |
| slot_id |
The ID of the event slot. |
VARCHAR(191) |
| series_id |
The ID of the event series. |
VARCHAR(191) |
| consumer_id |
The ID of the Health Data Intelligence consumer |
VARCHAR(191) |
Consumer_Engagement_F_EVT_Categories
| Field |
Definition |
Data Type |
| category_id |
The ID of the category. |
VARCHAR(36) |
| category_name |
The name of the category. |
VARCHAR(255) |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| create_dt_tm |
The date and time when the category record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the category record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Codes
| Field |
Definition |
Data Type |
| code_id |
The ID of the code. |
VARCHAR(36) |
| code |
The unique ID of the code. |
VARCHAR(191) |
| code_system |
The ID of the coding system that gives meaning to the code. |
VARCHAR(191) |
| display |
A human-readable representation of the code. |
VARCHAR(191) |
| category_id |
The ID of the category. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the code record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the code record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Events
| Field |
Definition |
Data Type |
| event_id |
The ID of the event. |
VARCHAR(36) |
| event_name |
The name of the event. |
VARCHAR(255) |
| event_description |
Additional details about the event that describe the schedule, the intent behind hosting the event, the speakers (if any), and so on. |
VARCHAR |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| location_id |
The ID of the location. |
VARCHAR(36) |
| category_id |
The ID of the category. |
VARCHAR(36) |
| series_id |
The ID of the event series. |
VARCHAR(36) |
| event_registration_status |
The current registration status of the event. OPEN indicates that the event has open slots available for registration. FULL indicates that registrations for all slots in the event have reached capacity. CLOSED indicates that the registration period for all slots in the event has ended. |
TINYINT |
| create_dt_tm |
The date and time when the event record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the event record was updated. |
TIMESTAMPTZ |
| event_starts_at |
The date and time when the event starts, in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. |
TIMESTAMPTZ |
| event_ends_at |
The date and time when the event ends, in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. |
TIMESTAMPTZ |
| multislot |
Indicates whether the event has the same session hosted multiple times. |
BOOLEAN |
| event_time_zone |
The time zone used to configure the start and end times for this event. The value should be a valid Internet Assigned Numbers Authority (IANA) time zone. |
VARCHAR(255) |
Consumer_Engagement_F_EVT_Leaders
| Field |
Definition |
Data Type |
| leader_id |
The ID of the leader. |
VARCHAR(36) |
| leader_name |
The full name of the person who is assigned as the leader of the event or series. |
VARCHAR(255) |
| event_id |
The ID of the event. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the leader record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the leader record was updated. |
TIMESTAMPTZ |
| series_id |
The ID of the event series. |
VARCHAR(36) |
Consumer_Engagement_F_EVT_Locations
| Field |
Definition |
Data Type |
| location_id |
The ID of the location. |
VARCHAR(36) |
| location_name |
The name of the location. |
VARCHAR(255) |
| location_description |
The free-text description of the location. |
VARCHAR |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| create_dt_tm |
The date and time when the location record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the location record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Registrations
| Field |
Definition |
Data Type |
| registration_id |
The ID of the event registration. |
VARCHAR(36) |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| consumer_id |
The ID of the Health Data Intelligence consumer |
VARCHAR(191) |
| event_id |
The ID of the event. |
VARCHAR(36) |
| slot_id |
The ID of the event slot. |
VARCHAR(36) |
| series_id |
The ID of the event series. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the registration record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the registration record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Series
| Field |
Definition |
Data Type |
| series_id |
The ID of the event series. |
VARCHAR(36) |
| series_name |
The name of the event series. |
VARCHAR(255) |
| series_description |
Additional details about the event series that describe the sessions, schedule, the intent behind hosting the series, the speakers (if any), and so on. |
VARCHAR |
| tenant_id |
The ID of the tenant. |
VARCHAR(191) |
| image_url |
The URL of the image for the series. |
VARCHAR(255) |
| series_registration_status |
The current registration status of the event series. OPEN indicates that the series has events with open slots available for registration. FULL indicates that registrations for all slots for at least one event in the series have reached capacity. CLOSED indicates that the registration period for all slots for at least one event in the series has ended. |
INTEGER |
| create_dt_tm |
The date and time when the series record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the series record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Slots
| Field |
Definition |
Data Type |
| slot_id |
The ID of the event slot. |
slot_id |
| max_registrations |
The maximum number of attendees for this session of the event. |
INTEGER |
| slot_description |
Additional details about the event slot that describe the session, schedule, and so on. |
VARCHAR |
| slot_starts_at |
The date and time when this session of the event starts, in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. |
TIMESTAMPTZ |
| slot_ends_at |
The date and time when this session of the event ends, in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. |
TIMESTAMPTZ |
| event_id |
The ID of the event. |
VARCHAR(36) |
| registration_ends_at |
The date and time when registration for this session of the event ends, in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. |
TIMESTAMPTZ |
| slot_time_zone |
The time zone used to configure the start, end, and registration times for this session of the event. The value should be a valid IANA time zone. |
VARCHAR(255) |
| available_registrations |
The number of available registrations for this session of the event. The number of available registrations cannot be less than zero or greater than the value of the maxRegistrations field. The default value is the value of the maxRegistrations field. |
INTEGER |
| create_dt_tm |
The date and time when the slot record was created. |
TIMESTAMPTZ |
| update_dt_tm |
The date and time when the slot record was updated. |
TIMESTAMPTZ |
Consumer_Engagement_F_EVT_Telecoms
| Field |
Definition |
Data Type |
| telecom_id |
The ID of the telecom. |
VARCHAR(36) |
| telecom_system |
The system of the telecom. |
INTEGER |
| value |
The value of the telecom. |
VARCHAR(255) |
| leader_id |
The ID of the leader. |
VARCHAR(36) |
| create_dt_tm |
The date and time when the telecom record was created. |
TIMESTAMPTZ |
| create_dt_tm |
The date and time when the telecom record was updated. |
TIMESTAMPTZ |
