Overview

This page lists the queryable MedChat data schema, including fields for each table, along with their data type and any field-specific comments.

All tables have an EnqueuedDateTime field which represents the datetime that a record was ingested from the online transactional database tables. The EnqueuedDateTime fields can largely be ignored for most query purposes.

Live Chat Tables

LiveChats

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
OrganizationId	guid	Organization's unique identifier
OrganizationName	string	Organization's name
WidgetId	guid	Unique identifier for a widget
WidgetName	string	Name of the widget
TopicId	guid	A widget topic's unique identifier
TopicName	string	A widget topic's assigned name
PatientName	string	Name of user initiating the chat
InitiatedDateTime	datetime	Datetime when the patient initiated the chat
StartedDateTime	datetime	Datetime of the first agent message
EndedDateTime	datetime	Datetime when the chat ended
ArchivedDateTime	datetime	Datetime when the chat was archived
ChatEndReason	string	Reason as to why the chat ended
ChatEndedBy	string	Who ended the chat. Values are Agent, System, User.
AgentMessageCount	int	Number of messages sent by agent(s) during the chat
PatientMessageCount	int	Number of messages sent by patient during the chat
FirstAgentAssignedDateTime	datetime	Datetime when the first agent was assigned to the chat
AgentCount	int	Number of agents who participated in the chat
HoldTime	timespan	Time from when the chatbot interaction ends (or from the start of the chat, if no chatbot) until the first agent is assigned. (i.e., Patient's time in the waiting queue)
WaitTime	timespan	Time from when the first agent was assigned to the chat until the agent's first message
ServiceTime	timespan	Time from when the chatbot interaction ends (or from the start of the chat, if no chatbot) until the chat ends
ArchiveTime	timespan	Time from when the chatbot interaction ends (or from the start of the chat, if no chatbot) until the chat is archived
IsSmsInitiated	bool	Indicates whether the chat was initiated through an SMS secure link
SmsChatId	guid	The ID of the SMS chat that originated the live chat
OfflineBotUsed	bool	Indicates whether a chatbot was used while the topic was unavailable for live agents
InitialContext	string	URL the patient was on when they initiated the chat
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
ChatInviteCode	string	The system-generated invite code included in an SMS secure link to a live chat
LiveChatRegisteredChatId	guid	The guid for a generated Registered Chat (see MedChat Help Center for more information)
OnlineBotUsed	bool	Indicates whether a chatbot was used while the topic was available
TransferredToLiveChatId	guid	Captures the new live chat ID spawned from an agent's transfer without history
TransferredFromLiveChatId	guid	Captures the originating live chat ID for a chat that was transferred without history
AgentTransfersCount	int	Tracks the number of agent-to-agent transfers for a live chat
SystemTransfersCount	int	Tracks the number of times an auto-transfer kicks in due to an agent's non-response

LiveChatAgents

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
UserId	guid	Agent's unique identifier
FirstName	string	Agent's first name
LastName	string	Agent's last name
AssignedDateTime	datetime	Datetime when the system assigned the chat to the Agent
AgentSequence	int	The order that the agent was assigned to the chat
FirstMessageDateTime	datetime	Datetime of the Agent's first message sent on the chat
LastMessageDateTime	datetime	Datetime of the agent's last message sent on the chat
AgentChatTime	timespan	Time from when the agent was assigned until the agent's last message
WaitTime	timespan	Time from when the agent joined the chat until the agent's first message
MessageCount	int	Number of messages sent by the agent on the chat
AverageResponseTime	timespan	Average time span the agent responds to a patient message
Weight	int	Internal value used to determine how much an agent's average response time should factor into the total average response time for the chat
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatQuickReplies

Column Name	Data Type	Comments
MessageId	guid	Unique identifier of the message
LiveChatId	guid	Unique identifier of the live chat
UserId	guid	Agent's unique identifier
QuickReplyId	guid	Unique identifier of the quick reply
QuickReplyTitle	string	Title of the quick reply
Timestamp	datetime	Datetime the quick reply was sent
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatSurveys

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
ExperienceRating	int	Patient-submitted experience rating for the live chat, on a scale of 1 to 5
ExperienceRatingText	string	Patient-submitted experience rating text for the live chat
AdditionalComments	string	Additional patient comments
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatTags

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
TagId	guid	Unique identifier of the tag
Tag	string	Tag name
Category	string	Tag category
UserId	guid	Unique user identifier of the agent that added the tag
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatTasks

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
TaskId	guid	Unique identifier of the task
TaskType	string	Task type. Possible values are OfflineChatFollowUp, MissedBotTransferFollowUp, FlaggedEvent
CreatedDateTime	datetime	Datetime the task was created
ClaimedStatus	string	Task claimed status. Possible values are Unclaimed, Claimed
ClaimedByUserId	guid	User ID of the agent that claimed the task
ClaimedDateTime	datetime	Datetime the task was claimed
ResolutionStatus	string	Resolution status of the task. Possible values are Unresolved, Resolved, Closed
ResolvedDateTime	datetime	Datetime the task was resolved
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatInputs

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the live chat
BlockId	string	The ID of the input block. Triage bot input block IDs are prefixed with TriageBot. For example, TriageBot.Region.
Values	string	The input value(s) submitted by the patient for this input block. For blocks that accept multiple values (like a Multiple Choice block), multiple values are stored as a comma-separated list.
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatAttributes

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the live chat
AttributeName	string	Name of the attribute
DataType	string	Data type of the attribute
AttributeValue	string	Value of the attribute
IsCustom	bool	Indicates whether the attribute is a custom attribute or a system attribute
CollectionItemType	string	If a collection type, indicates the date type of the items in the collection
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChatRegisteredChats

Column Name	Data Type	Comments
LiveChatRegisteredChatId	guid	Unique identifier of the registered chat
LiveChatId	guid	Unique identifier of the live chat
WidgetId	guid	Unique identifier for a widget
WidgetName	string	Name of the widget
TopicId	guid	A widget topic's unique identifier
TopicName	string	A widget topic's assigned name
PatientName	string	Name of user initiating the chat
Status	string	Status of the registered chat. Possible values are Registered, ChatStarted, Expired
CreatedDateTime	datetime	Datetime the registered chat was created
ExpiresDateTime	datetime	Datetime the registered chat expires
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
ReferenceCode	string	Redacted. The reference code is the credential half of the chat link, so this column always reads

Chat Bot Tables

ChatBotExecutions

Column Name	Data Type	Comments
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
LiveChatId	guid	Unique identifier of the chat
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
Status	string	Status of the chat bot execution. Possible values are Active, Complete, Paused, Error
CreatedDateTime	datetime	Datetime the execution was created
UpdatedDateTime	datetime	Datetime the execution was updated
CompletedDateTime	datetime	Datetime the execution completed
CompletionReason	string	Reason the execution completed. Possible values are ExecutionCompleted, ChatEnded, Error
RanToCompletion	bool	Indicates whether the execution ran to completion
LastChatBotStepExecutionId	guid	Unique identifier of the last chat bot step executed
LastChatBotStepExecutionStepId	int	Step ID of the last chat bot step executed
LastChatBotStepExecutionStepName	string	Name of the last chat bot step executed
LastChatBotStepExecutionStepType	string	Step type of the last chat bot step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

ChatBotStepExecutions

Column Name	Data Type	Comments
ChatBotStepExecutionId	guid	Unique identifier of the chat bot step execution
LiveChatId	guid	Unique identifier of the chat
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
FlowId	guid	Unique identifier of the chat bot flow
FlowName	string	Name of the chat bot flow
FlowCreatedDateTime	datetime	Datetime that the flow was created
StepId	int	Step ID of the step that executed
StepName	string	Step name of the step that executed
StepType	string	Step type of the step that executed
EventDateTime	datetime	Datetime that the step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

TriageBotResults

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the chat
Score	int	Triage bot score
RecommendationOptions	string	Triage bot recommendation option
Selection	string	Selected option
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Answer Bot Tables

ArticleViews

Column Name	Data Type	Comments
EventId	guid	Unique identifier of the event
ArticleId	guid	Unique identifier of the article
ArticleTitle	string	Title of the article
CategoryId	guid	Unique identifier of the category
CategoryName	string	Name of the category
Context	string	URL the patient was on when they viewed the article
SessionId	string	Unique identifier representing the user's session
WidgetId	guid	Unique identifier of the widget
WidgetName	string	Name of the widget
Timestamp	datetime	Datetime when the article was viewed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

PerformedSearches

Column Name	Data Type	Comments
EventId	guid	Unique identifier of the event
Query	string	Search query
CorrelationId	guid	Correlation ID
ResultCount	int	Number of search results
Result1ArticleId	guid	Unique identifer of the first search result article
Result1ArticleTitle	string	Title of the first search result article
Result1CategoryId	guid	Category ID of the first search result article
Result1Category	string	Category of the first search result article
Result1Score	real	Accuracy score of the first search result
Result2ArticleId	guid	Unique identifer of the second search result article
Result2ArticleTitle	string	Title of the second search result article
Result2CategoryId	guid	Category ID of the second search result article
Result2Category	string	Category of the second search result article
Result2Score	real	Accuracy score of the second search result
Result3ArticleId	guid	Unique identifer of the third search result article
Result3ArticleTitle	string	Title of the third search result article
Result3CategoryId	guid	Category ID of the third search result article
Result3Category	string	Category of the third search result article
Result3Score	real	Accuracy score of the third search result
SessionId	string	User's session ID
GapScore	int	Gap score for the search
WidgetId	guid	Unique identifier for a widget
WidgetName	string	Name of the widget
Timestamp	datetime	Datetime of the search
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SearchConcepts

Column Name	Data Type	Comments
SearchConceptId	guid	Unique identifier of the search concept
DisplayText	string	Display text
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

PerformedSearchConcepts

Column Name	Data Type	Comments
EventId	guid	Unique identifier of the event
SearchConceptId	guid	Unique identifier of the search concept
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SMS Chat Tables

SmsChats

Column Name	Data Type	Comments
SmsChatId	guid	Unique identifier of the SMS chat
OrganizationId	guid	Organization's unique identifier
Name	string	Name of the recipient
UserPhoneNumber	string	Phone number of the recipient
Status	string	Status of the chat. Possible values are Queued, Active, Subscribed, Unsubscribed
CreatedDateTime	datetime	Datetime the SMS chat was created
LastActivityDateTime	datetime	Datetime of the last activity on the chat
UnsubscribedDateTime	datetime	Datetime that the recipient unsubscribed from the chat
OrgPhoneNumber	string	Phone number of the org number
OrgPhoneNumberName	string	Phone number name of the org number
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SmsChatSessions

Column Name	Data Type	Comments
SmsChatSessionId	guid	Unique identifier of the SMS chat session
SmsChatId	guid	Unique identifier of the SMS chat
UserId	guid	Unique identifier of the agent
Status	string	Session status. Possible values are Open, Closed
SessionStartDateTime	datetime	Datetime the session started
SessionEndDateTime	datetime	Datetime the session ended
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SmsChatMessages

Column Name	Data Type	Comments
SmsChatMessageId	guid	Unique identifier of the SMS chat message
SmsChatId	guid	Unique identifier of the SMS chat
UserId	guid	Unique identifier of the user who sent the message
UserType	string	User type of the user who sent the message. Possible values are Internal, Anonymous, Bot, AiAgent, ApiClient
Timestamp	datetime	Datetime of the message
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
IsSystemMessage	bool	Indicates whether the message was system message (i.e., not from the patient, the agent, or a text bot)

SmsChatInvites

Column Name	Data Type	Comments
SmsChatInviteId	guid	Unique identifier of the SMS chat invite
SmsChatId	guid	Unique identifier of the SMS chat
AgentUserId	guid	User ID of the agent that sent the invite
WidgetId	guid	Unique identifier for a widget
WidgetName	string	Name of the widget
TopicId	guid	A widget topic's unique identifier
TopicName	string	A widget topic's assigned name
SentDateTime	datetime	Datetime the invite was sent
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
InviteBaseUrl	string	Invite base URL
InviteUrl	string	Invite URL
ChatInviteCode	string	Invite code

SmsChatAttributes

Column Name	Data Type	Comments
SmsChatId	guid	Unique identifier of the SMS chat
AttributeName	string	Name of the attribute
DataType	string	Data type of the attribute
AttributeValue	string	Value of the attribute
IsCustom	bool	Indicates whether the attribute is a custom attribute or a system attribute
CollectionItemType	string	If a collection type, indicates the date type of the items in the collection
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
SmsChatAttributeId	guid	Unique identifier of the SMS chat attribute
TextBotExecutionId	guid	Unique identifier of the text bot execution
DeletedDateTime	datetime	Datetime the attribute was deleted

User Tables

Users

Column Name	Data Type	Comments
UserId	guid	Unique identifier of the user
OrganizationId	guid	Organization's unique identifier
FirstName	string	User's first name
LastName	string	User's last name
EmailAddress	string	User's e-mail address
Roles	string	Comma-separated list of the user's roles
IsAgent	bool	Indicates whether the user is an agent
IsActive	bool	Indicates whether the user is active
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
IsGuest	bool	Indicates wheter the user is a guest acount in the organization

UserPresences

Column Name	Data Type	Comments
UserId	guid	Unique identifier of the user
OrganizationId	guid	Organization's unique identifier
LiveChatPresence	string	User's live chat presence. Possible values are Active, Away
TeamChatPresence	string	User's spaces presence. Possible values are Active, Away
Timestamp	datetime	Datetime user's presence last changed
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

CustomUserAttributes

Column Name	Data Type	Comments
AttributeId	guid	Unique identifier of the user attribute
UserId	guid	Unique identifier of the user
AttributeName	string	Name of the user attribute
Value	string	Value of the user attribute
PermissionScope	string	Permission scope of the user attribute
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Cloud Function Tables

CloudFunctionErrors

Column Name	Data Type	Comments
CloudFunctionErrorId	guid	Unique identifier of the cloud function error
CloudFunctionExecutionId	guid	Unique identifier of the cloud function execution
CloudFunctionId	guid	Unique identifier of the cloud function
LiveChatId	guid	Unique identifier of the chat
OrganizationId	guid	Organization's unique identifier
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
TriggerId	guid	Unique identifier of the trigger
HttpStatusCode	int	Http status code from the cloud function
ResponseContent	string	Response content from the cloud function
Timestamp	datetime	Datetime of the cloud function error
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

CloudFunctionExecutions

Column Name	Data Type	Comments
CloudFunctionExecutionId	guid	Unique identifier of the cloud function execution
CloudFunctionId	guid	Unique identifier of the cloud function
LiveChatId	guid	Unique identifier of the chat
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
TriggerId	guid	Unique identifier of the trigger
DurationMs	int	The duration in milliseconds of the cloud function execution
HadError	bool	Indicates whether the cloud function execution encountered an error
StartDateTime	datetime	Datetime of the start of the cloud function execution
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Custom Script Tables

CustomScriptErrors

Column Name	Data Type	Comments
CustomScriptErrorId	guid	Unique identifier of the custom script error
CustomScriptExecutionId	guid	Unique identifier of the custom script execution
CustomScriptId	guid	Unique identifier of the custom script
LiveChatId	guid	Unique identifier of the chat
OrganizationId	guid	Organization's unique identifier
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
Message	string	Error message
StackTrace	string	Stack trace of the error
Timestamp	datetime	Datetime of the custom script error
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

CustomScriptExecutions

Column Name	Data Type	Comments
CustomScriptExecutionId	guid	Unique identifier of the custom script execution
CustomScriptId	guid	Unique identifier of the custom script
LiveChatId	guid	Unique identifier of the chat
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
DurationMs	int	The duration in milliseconds of the custom script execution
HadError	bool	Indicates whether the custom script execution encountered an error
StartDateTime	datetime	Datetime of the start of the custom script execution
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

CustomScriptTraces

Column Name	Data Type	Comments
CustomScriptTraceId	guid	Unique identifier of the custom script trace
CustomScriptExecutionId	guid	Unique identifier of the custom script execution
CustomScriptId	guid	Unique identifier of the custom script
LiveChatId	guid	Unique identifier of the chat
OrganizationId	guid	Organization's unique identifier
ChatBotId	guid	Unique identifier of the chat bot
ChatBotName	string	Name of the chat bot
ChatBotExecutionId	guid	Unique identifier of the chat bot execution
Message	string	Cutom trace message
SeverityLevel	string	Custom trace severity level
Timestamp	datetime	Datetime of the custom trace
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Journey Tables

JourneyAttributes

Column Name	Data Type	Comments
JourneyInstanceId	guid	Unique identifier of the journey instance
AttributeName	string	Name of the attribute
DataType	string	Data type of the attribute
AttributeValue	string	Value of the attribute
IsCustom	bool	Indicates whether the attribute is a custom attribute or a system attribute
CollectionItemType	string	If a collection type, indicates the date type of the items in the collection
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

JourneyInstances

Column Name	Data Type	Comments
JourneyInstanceId	guid	Unique identifier of the journey instance
JourneyBotId	guid	Unique identifier of the journey bot
JourneyBotName	string	Name of the journey bot
JourneyBatchId	guid	Unique identitifer of the journey batch
InitiatingUserId	guid	ID of the user who initiated the journey instance
JourneyInstanceStatus	string	Status of the journey instance. Possible value are NotStarted, InProgress, InvokedFlowOnExistingInstance, Completed, InError, Cancelled, Scheduled, Queued.
ErrorMessage	string	Error message of the journey instance
ReferenceJourneyInstanceId	guid	ID of the journey instance that was in progress on which this journey instance attempted to invoke a subflow
InvokeFlowId	int	The unique identifier of the subflow that was invoked
ScheduledTimeZone	string	The time zone of the DateTime when this journey instance is scheduled to execute
ScheduledDateTime	datetime	The datetime that this journey instance is scheduled to execute
JourneyExecutionStatus	string	The journey execution status. Possible values are Active, Complete, Paused, Error
JourneyExecutionId	guid	Unique identifier of the journey execution
InstanceCreatedDateTime	datetime	Datetime the instance was created
ExecutionCreatedDateTime	datetime	Datetime the journey execution started
ExecutionUpdatedDateTime	datetime	Datetime the journey execution was last updated
ExecutionCompletedDateTime	datetime	Datetime the journey execution completed
CompletionReason	string	Journey execution completion reason. Possible values are ExecutionCompleted, Error.
RanToCompletion	bool	Indicates whether the execution ran to completion
LastJourneyStepExecutionId	guid	Unique identifier of the last journey bot step executed
LastJourneyStepExecutionStepId	int	Step ID of the last journey bot step executed
LastJourneyStepExecutionStepName	string	Name of the last journey bot step executed
LastJourneyStepExecutionStepType	string	Step type of the last journey bot step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

JourneyParameters

Column Name	Data Type	Comments
JourneyInstanceId	guid	Unique identifier of the journey instance
AttributeName	string	Name of the parameter
AttributeValue	string	Value of the parameter
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

JourneyStepExecutions

Column Name	Data Type	Comments
JourneyStepExecutionId	guid	Unique identifier of the journey bot step execution
JourneyInstanceId	guid	Unique identifier of the journey instance
JourneyExecutionId	guid	Unique identifier of the journey bot execution
JourneyBotId	guid	Unique identifier of the journey bot
JourneyBotName	string	Name of the journey bot
FlowId	guid	Unique identifier of the journey bot flow
FlowName	string	Name of the journey bot flow
FlowCreatedDateTime	datetime	Datetime that the flow was created
StepId	int	Step ID of the step that executed
StepName	string	Step name of the step that executed
StepType	string	Step type of the step that executed
EventDateTime	datetime	Datetime that the step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SMS Batch Tables

SmsBatchRecipientParameters

Column Name	Data Type	Comments
SmsBatchRecipientId	guid	Unique identifier of the recipient
OrganizationId	guid	Organization's unique identifier
AttributeName	string	Name of the parameter
AttributeValue	string	Value of the parameter
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SmsBatchRecipients

Column Name	Data Type	Comments
SmsBatchRecipientId	guid	Unique identifier of the recipient
SmsBatchId	guid	Unique identifier of the3 SMS batch
OrganizationId	guid	Organization's unique identifier
RecipientName	string	Name of the recipient
RecipientPhoneNumber	string	Phone number of the recipient
RecipientStatus	string	Batch recipient status. Possible values are NotSent, Queued, AwaitingTextBotStart, Scheduled, Sent, InError, Cancelled
SentDateTime	datetime	Datetime the batch was started for this recipient
ErrorMessage	string	Error message sending to this recipient
SmsChatId	guid	Unique identifier of the SMS chat
TextBotExecutionId	guid	Unique identifier of the text bot execution
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

SmsBatches

Column Name	Data Type	Comments
SmsBatchId	guid	Unique identifier of the SMS batch
OrganizationId	guid	Organization's unique identifier
SenderPhoneNumber	string	Senders phone number
BatchStatus	string	Batch status. Possible values are Created, Scheduled, InProgress, Paused, Complete, Cancelled
InitiatedByUserId	guid	User ID of the agent that initiated the batch
TextBot	string	Name of the text bot
CreatedDateTime	datetime	Datetime batch was created
ScheduledDateTime	datetime	Datetime batch is scheduled to be sent
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
SenderPhoneNumberName	string	Sender phone number name

Text Bot Tables

TextBotExecutions

Column Name	Data Type	Comments
TextBotExecutionId	guid	Unique identifier of the text bot execution
SmsChatId	guid	Unique identifier of the chat
TextBotId	guid	Unique identifier of the text bot
TextBotName	string	Name of the text bot
InitiatingUserId	guid	Unique identifier of the agent that initiated the text bot execution
Status	string	Status of the text bot execution. Possible values are Active, Complete, Paused, Error
CreatedDateTime	datetime	Datetime the execution was created
UpdatedDateTime	datetime	Datetime the execution was updated
CompletedDateTime	datetime	Datetime the execution completed
CompletionReason	string	Reason the execution completed. Possible values are ExecutionCompleted, ChatEnded, Error
RanToCompletion	bool	Indicates whether the execution ran to completion
LastTextBotStepExecutionId	guid	Unique identifier of the last text bot step executed
LastTextBotStepExecutionStepId	int	Step ID of the last text bot step executed
LastTextBotStepExecutionStepName	string	Name of the last text bot step executed
LastTextBotStepExecutionStepType	string	Step type of the last text bot step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

TextBotStepExecutions

Column Name	Data Type	Comments
TextBotStepExecutionId	guid	Unique identifier of the text bot step execution
SmsChatId	guid	Unique identifier of the chat
TextBotExecutionId	guid	Unique identifier of the text bot execution
TextBotId	guid	Unique identifier of the text bot
TextBotName	string	Name of the text bot
FlowId	guid	Unique identifier of the text bot flow
FlowName	string	Name of the text bot flow
FlowCreatedDateTime	datetime	Datetime that the flow was created
StepId	int	Step ID of the step that executed
StepName	string	Step name of the step that executed
StepType	string	Step type of the step that executed
EventDateTime	datetime	Datetime that the step executed
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Other

AiEvalMessageSentiments

Column Name	Data Type	Comments
AiEvalMessageSentimentId	guid	The unique identifier of the AI eval message sentiment
InteractionType	string	The type of interaction (LiveChat, CopilotChat, VoiceChat, TextChat)
InteractionId	guid	Unique identifier of the interaction
MessageId	guid	Unique identifier of the message being evaluated
Sentiment	string	The detected sentiment of the message: positive, negative, or neutral
Reasons	dynamic	Array of strings explaining reasons contributing to the detected sentiment
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

AiEvalModelDecisions

Column Name	Data Type	Comments
AiEvalModelDecisionId	guid	The unique identifier of the AI eval model decision
InteractionType	string	The type of interaction (LiveChat, CopilotChat, VoiceChat, TextChat)
InteractionId	guid	Unique identifier of the interaction
MessageId	guid	Unique identifier of the message being evaluated
Assessment	string	Assessment result: correct, incorrect, or ambiguous
FailureReasons	dynamic	Array of strings explaining reasons for failure if assessment is incorrect
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
PromptCallId	guid	Unique identifier of the prompt call that generated the model decision being evaluated

AiEvalResolutions

Column Name	Data Type	Comments
AiEvalResolutionId	guid	The unique identifier of the AI eval resolution
InteractionType	string	The type of interaction (LiveChat, CopilotChat, VoiceChat, TextChat)
InteractionId	guid	Unique identifier of the interaction
UserIntent	string	The user's intent as determined by AI evaluation
Resolved	string	Resolution status: resolved, unresolved, or unknown
Reason	dynamic	Array of strings explaining the resolution reasoning (deprecated - use Reasons instead)
Topics	dynamic	Array of strings representing topics identified in the interaction
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
Reasons	dynamic	Array of strings explaining the resolution reasoning

AiEvalSentiments

Column Name	Data Type	Comments
AiEvalSentimentId	guid	The unique identifier of the AI eval sentiment
InteractionType	string	The type of interaction (LiveChat, CopilotChat, VoiceChat, TextChat)
InteractionId	guid	Unique identifier of the interaction
OverallSentiment	string	Overall sentiment assessment: positive, negative, or unknown
FinalSentiment	string	Final sentiment assessment: positive, negative, or unknown
Reasons	dynamic	Array of strings explaining the sentiment reasoning
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

AiModelUsages

Column Name	Data Type	Comments
CreditsUsed	decimal	The number of credits used in the interaction
AiFeatureName	string	The name of the AI feature that was being used
UserId	guid	Unique identifier of the user who utilized an AI feature
PhoneNumberId	guid	Unique identifier of the phone number associated with a textbot-related AI usage
WidgetId	guid	Unique identifier of the widget associated with a chatbot-related AI usage
Timestamp	datetime	Datetime when the AI Model was queried
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

AnalyzerConfigurations

Column Name	Data Type	Comments
AnalyzerId	guid	The unique identifier of the analyzer configuration
AnalyzerEdit	int	The edit/version number of this analyzer configuration
AnalyzerKind	string	The kind of analyzer (e.g. Eval, EventDetection)
AnalyzerType	string	The specific type of analyzer (e.g. Sentiment, IssueDetection)
AnalyzerName	string	The display name of the analyzer configuration
OutputFields	dynamic	Dynamic array of output field definitions including name, groupable flag, and groupable sub-paths
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
InteractionTypes	dynamic	Dynamic array of the interaction types the analyzer's trigger fires on (e.g. ['LiveChat','VoiceChat'], ['TaskDiscussion'])

AnalyzerResults

Column Name	Data Type	Comments
AnalyzerResultId	guid	The unique identifier of the analyzer result
AnalyzerId	guid	The unique identifier of the analyzer configuration
AnalyzerEdit	int	The edit/version number of the analyzer configuration that produced this result
AnalyzerKind	string	The kind of analyzer (e.g. Eval, EventDetection)
AnalyzerType	string	The specific type of analyzer (e.g. Sentiment, IssueDetection)
InteractionType	string	The type of interaction (LiveChat, VoiceChat, TaskDiscussion). Note: LiveChat covers both MC 1.0 chats (LiveChats) and EM chats (LiveChat_2_0_Chats); join InteractionId against both to identify which
InteractionId	guid	Unique identifier of the interaction
MessageId	guid	Unique identifier of the specific message within the interaction, if applicable
PromptCallId	guid	Unique identifier of the prompt call that produced this result, if applicable
OuterResult	dynamic	Dynamic object containing the analyzer kind-specific result properties (e.g. eventDetected for EventDetection analyzers)
Result	dynamic	Dynamic object containing the analyzer's output fields as configured by the user
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
SystemKey	string	The stable system-analyzer key identifying which built-in system analyzer produced this result (e.g. resolution, conversation_sentiment, user_message_sentiment, model_decision); null for custom analyzers
WidgetId	guid	Unique identifier of the widget the analyzed conversation came in on (LiveChat 2.0 only); null when the interaction has no widget
WidgetName	string	Name of the widget at the time the result was published; null when unset or unresolvable. Filter by WidgetId — a later rename leaves this value on existing rows
PhoneNumberId	guid	Unique identifier of the organization phone line the analyzed call used (VoiceChat only); null for every other interaction type
PhoneNumberName	string	Friendly name of the organization phone line at the time the result was published; null when unset or unresolvable. Matches VoiceChats.PhoneNumberName for the same line
TaskTemplateId	guid	Unique identifier of the task template the analyzed task was created from (task analyzers only); null for ad-hoc tasks and for conversation analyzers
TaskTemplateName	string	Name of the task template at the time the result was published; null when unset or unresolvable

LiveChat_2_0_Attributes

Column Name	Data Type	Comments
LiveChatAttributeId	guid	Unique identifier of the attribute
LiveChatId	guid	Unique identifier of the parent live chat
Scope	string	Scope of the attribute (e.g. Interaction, System)
Name	string	Attribute name
Value	string	Attribute value (JSON-serialized when applicable)
CreatedDateTime	datetime	When the attribute was created
UpdatedDateTime	datetime	When the attribute was last updated
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChat_2_0_Chats

Column Name	Data Type	Comments
LiveChatId	guid	Unique identifier of the live chat
OrganizationId	guid	Organization's unique identifier
OrganizationName	string	Name of the organization
WidgetId	guid	Unique identifier for the widget that hosted the chat
Status	string	Live chat status (Active, Ended, Archived)
CreatedDateTime	datetime	When the chat was created
StartedDateTime	datetime	When the chat was started
EndedDateTime	datetime	When the chat ended
ChatEndReason	string	Reason the chat ended (e.g. EndedByUser, SessionEnded)
ChatEndedBy	string	Who ended the chat (e.g. User, System)
InactivityTimeoutMinutes	int	Inactivity timeout (in minutes) configured on the widget
InitialContext	string	Initial page URL/context the chat was started from
RegisteredChatId	guid	Unique identifier of the registered chat that initiated this chat, if applicable
MessageCount	int	Total number of messages in the chat
AgentCount	int	Number of non-external-user members on the chat
ChatDuration	timespan	Total duration of the chat (ended - started)
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChat_2_0_Memberships

Column Name	Data Type	Comments
LiveChatMembershipId	guid	Unique identifier of the membership
LiveChatId	guid	Unique identifier of the parent live chat
UserId	guid	Unique identifier of the member user
Role	string	Role of the member on the chat (ExternalUser, AiAgent, HumanAgent)
JoinedDateTime	datetime	When the user joined the chat
LeftDateTime	datetime	When the user left the chat, if applicable
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChat_2_0_RegisteredChatAttributes

Column Name	Data Type	Comments
LiveChatRegisteredChatAttributeId	guid	Unique identifier of the registered chat attribute
LiveChatRegisteredChatId	guid	Unique identifier of the parent registered chat
Name	string	Attribute name
Value	string	Attribute value (JSON-serialized when applicable)
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

LiveChat_2_0_RegisteredChats

Column Name	Data Type	Comments
LiveChatRegisteredChatId	guid	Unique identifier of the registered chat
OrganizationId	guid	Organization's unique identifier
OrganizationName	string	Name of the organization
WidgetId	guid	Unique identifier of the widget the registered chat targets
ReferenceCode	string	Redacted. The reference code is the credential half of the chat link and is returned only once, when the registered chat is created, so this column always reads
Status	string	Status of the registered chat (Registered, ChatStarted)
PatientName	string	Name of the patient the registered chat was created for
StartingInteractionContext	string	Initial context (e.g. URL) the registered chat will start in
HandlingAiAgentId	guid	AI agent that will handle the chat once it starts, if specified
ExpiresDateTime	datetime	When the registered chat expires
CreatedDateTime	datetime	When the registered chat was created
UpdatedDateTime	datetime	When the registered chat was last updated
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.
RecipientName	string	Name of the person the registered chat was created for

TaskAttributes

Column Name	Data Type	Comments
TaskAttributeId	guid	Unique identifier of the task attribute
TaskId	guid	Unique identifier of the task
Scope	string	Scope of the attribute (e.g. system, custom)
Name	string	Name of the attribute
Value	string	Value of the attribute (JSON serialized) at the time of the task snapshot
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Matches the EnqueuedDateTime of the Tasks snapshot written alongside it. Note: This is a system field and generally won't be used in custom queries.

TaskStatusTransitions

Column Name	Data Type	Comments
TaskId	guid	Task's unique identifier
OrganizationId	guid	Organization's unique identifier
FromStatus	string	Status the task moved from (Draft, InProgress, Paused, Done, Cancelled); empty if there was no prior status
ToStatus	string	Status the task moved to (Draft, InProgress, Paused, Done, Cancelled)
Timestamp	datetime	Datetime when the status transition occurred
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

Tasks

Column Name	Data Type	Comments
TaskId	guid	Task's unique identifier
OrganizationId	guid	Organization's unique identifier
OrganizationName	string	Name of the organization the task belongs to
Status	string	Task lifecycle status (Draft, InProgress, Paused, Done, Cancelled)
Priority	string	Task priority (None, Low, Medium, High, Urgent)
NeedsAttention	bool	Whether the task is flagged as needing attention
TemplateId	guid	Unique identifier of the task template the task was created from, if any
TemplateName	string	Name of the task template the task was created from, if any
TaskBatchId	guid	Unique identifier of the batch the task was created in, if any
CreationSource	string	How the task was created: Manual, Template, Batch, or Analyzer
CreatedByUserId	guid	Unique identifier of the user who created the task
AssignedToUserId	guid	Unique identifier of the user the task is assigned to, if any
ParentTaskId	guid	Unique identifier of the parent task, if this task is a child
CreatedDateTime	datetime	Datetime when the task was created
StartDateTime	datetime	Datetime when the task is scheduled to start, if set
DueDateTime	datetime	Datetime when the task is due, if set
CompletedDateTime	datetime	Datetime when the task reached the Done status, if completed
CancelledDateTime	datetime	Datetime when the task reached the Cancelled status, if cancelled
UpdatedDateTime	datetime	Datetime when the task was last updated
DeletedDateTime	datetime	Datetime when the task was deleted, if deleted
TimeToCompletion	timespan	Elapsed time between task creation and completion (CompletedDateTime - CreatedDateTime)
TodoCount	int	Total number of todos on the task
TodoCompletedCount	int	Number of completed todos on the task
Edit	int	Aggregate version (edit number) of the task at the time of this snapshot
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

TriageSessions

Column Name	Data Type	Comments
TriageSessionId	guid	Triage session's unique identifier
OrganizationId	guid	Organization's unique identifier
Status	string	Session lifecycle status (Pending, Active, Completed, Cancelled) as of this row
CreationSource	string	How the session began: Nurse (a user started triage; Active from creation) or Registered (an integration registered it; Pending until a nurse started it)
TaskId	guid	Unique identifier of the task created for the session in automation-api; joins to Tasks.TaskId
ConfigurationEdit	int	Edit number of the org triage configuration the session's content reads are pinned to
Population	string	Adult or Pediatric; empty until the nurse chooses
CoverageHours	string	OfficeHours or AfterHours; empty until the nurse chooses
PatientContactId	guid	Unique identifier of the CRM contact the call is about, if linked
CallerIsPatient	bool	Whether the caller is the patient; empty until answered
CallerRelationship	string	The caller's relationship to the patient, from the org's configured options
AuthorizationConfirmed	bool	Whether the caller is authorized to discuss the patient's care; empty until answered
PmhReviewed	bool	Whether the nurse attested to reviewing the patient's medical history
InterpreterUsed	bool	Whether an interpreter was used; empty until answered
InterpreterLanguage	string	Language the interpreter interpreted, if one was documented
PreDisposition	string	What the caller would have done without the nurse line, from the org's configured list
CallOutcome	string	What the caller will do at the end of the call, from the org's configured list
DisagreeReason	string	Why the caller will not follow the triage recommendation, from the org's configured list
ProtocolCount	int	Number of protocols walked on the call
FinalProtocolId	int	Schmitt-Thompson protocol id the final disposition comes from (the most acute selected disposition across the protocols walked)
FinalProtocolTitle	string	Title of the protocol the final disposition comes from
FinalDispositionLevelId	int	Disposition level id of the final disposition
FinalDispositionHeading	string	Heading of the final disposition (e.g. Go to ED Now)
FinalDispositionAcuityLevel	int	Acuity level of the final disposition; 1 is most acute (after-hours content)
FinalDispositionUrgency	int	Urgency of the final disposition; 1 is most acute (office-hours content)
DispositionOverridden	bool	Whether the nurse's selected disposition on the final protocol differs from the one the answers reached
HandoutDeliveryCount	int	Number of handout sends (email or text) requested on the session
InformationRequestCount	int	Number of photo and text requests sent to the patient
CreatedByUserId	guid	Unique identifier of the user who created the session; empty when an integration's client credential registered it
CreatedDateTime	datetime	Datetime when the session was created
StartedByUserId	guid	Unique identifier of the nurse: the user who started the session
StartedDateTime	datetime	Datetime when the session became Active: creation for a nurse-started session, the start for a registered one
CompletedByUserId	guid	Unique identifier of the user who completed the session, if completed
CompletedDateTime	datetime	Datetime when the session was completed, if completed
CancelledByUserId	guid	Unique identifier of the user who cancelled the session, if cancelled
CancelledDateTime	datetime	Datetime when the session was cancelled, if cancelled
UpdatedDateTime	datetime	Datetime when the session was last updated
PendingDuration	timespan	Elapsed time between registration and start (StartedDateTime - CreatedDateTime); registered sessions only, once started
ActiveDuration	timespan	Elapsed time between start and completion or cancellation; empty until the session ends
Edit	int	Aggregate version (edit number) of the session at the time of this row
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

VoiceChatAttributes

Column Name	Data Type	Comments
VoiceChatAttributeId	guid	Unique identifier of the voice chat attribute
VoiceChatId	guid	Unique identifier of the voice chat
Scope	string	Scope of the attribute (e.g. system, custom)
Name	string	Name of the attribute
Value	string	Value of the attribute
OrganizationId	guid	Organization's unique identifier
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

VoiceChatMessages

Column Name	Data Type	Comments
VoiceChatMessageId	guid	Unique identifier of the voice chat message
VoiceChatId	guid	Unique identifier of the parent voice chat
UserId	guid	Unique identifier of the user who sent this message
OrganizationId	guid	Organization's unique identifier
CreatedDateTime	datetime	When this message was created
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.

VoiceChats

Column Name	Data Type	Comments
VoiceChatId	guid	Unique identifier of the voice chat
OrganizationId	guid	Organization's unique identifier
OrganizationName	string	Name of the organization
CreatedDateTime	datetime	When this voice chat was created
UpdatedDateTime	datetime	The last time the voice chat was updated
EndedDateTime	datetime	The time this voice chat conversation was ended
Status	string	Voice chat status (Completed, Failed, Busy, NoAnswer, Canceled, InProgress, Ringing, Queued)
ReferenceId	string	External reference identifier for the voice chat
UserPhoneNumber	string	Phone number of the user/patient
Direction	string	Direction of the call (Inbound, Outbound)
ForwardedFrom	string	Phone number the call was forwarded from, if applicable
CallerName	string	Name of the caller, if provided
EndedReason	string	Reason the voice chat ended
PhoneNumberId	guid	Unique identifier of the organization's phone number used
PhoneNumberName	string	Name/description of the organization's phone number
MessageCount	int	Total number of messages exchanged in this voice chat
AgentCount	int	Number of agents that participated in this voice chat
CallDuration	timespan	Total duration of the voice call
EnqueuedDateTime	datetime	Datetime stamp when record is exported from the main application and into the analytics database for display in Analytics and Custom Reports. Note: This is a system field and generally won't be used in custom queries.