table - interaction «Interaction»

Derivation Hierarchy

interaction
«Interaction»

Global

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: interaction
Label:: Interaction (en)

Created On:: 2022.03.18 03:27:35
Created By:: system

Updated On:: 2022.03.18 03:57:53
Updated By:: system

Column Updated On:: 2022.03.18 03:35:08
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

Status	Name	Label	Datatype	Length	Scope	Reference	Included By
	active	Active	boolean	40	Global		interaction
	application	Application	reference	32	Global	sys_scope	interaction
	assigned_at	Assigned At	glide_date_time	40	Global		interaction
	assigned_to	Assigned to	reference	32	Global	sys_user	interaction
	assignment_group	Assignment group	reference	32	Global	sys_user_group	interaction
	auto_resolution	Auto resolution	boolean	40	Global		interaction
	category	Category	string[choice]	40	Global		interaction
	channel_metadata_document	Channel Metadata Record	document_id	32	Global		interaction
	channel_metadata_table	Channel Metadata Table	table_name	80	Global		interaction
	channel_user_profile	Channel user profile	reference	32	Global	sys_cs_channel_user_profile	interaction
	closed_at	Closed	glide_date_time	40	Global		interaction
	closed_by	Closed by	reference	32	Global	sys_user	interaction
	company	Company	reference	32	Global	core_company	interaction
	context	Context	reference	32	Global	v_interaction_context	interaction
	context_document	Context Record	document_id	32	Global		interaction
	context_table	Context Table	table_name	80	Global		interaction
	csat_score	Customer Satisfaction Score	decimal	15	Global		interaction
	direction	Direction	string[choice]	40	Global		interaction
	duration	Duration	glide_duration	40	Global		interaction
	help_requested	Help Requested	boolean	40	Global		interaction
	internal_transcript	Internal Transcript	string	16000	Global		interaction
	location	Location	reference	32	Global	cmn_location	interaction
D	number	Number	string	40	Global		interaction
	opened_at	Opened	glide_date_time	40	Global		interaction
	opened_by	Opened by	reference	32	Global	sys_user	interaction
	opened_for	Opened for	reference	32	Global	sys_user	interaction
	parent	Parent	reference	32	Global	interaction	interaction
	provider_application	Provider application	reference	32	Global	sys_cs_provider_application	interaction
	short_description	Short description	string	160	Global		interaction
	state	State	string[choice]	40	Global		interaction
	state_changed_on	State Changed On	glide_date_time	40	Global		interaction
	state_reason	State Reason	choice[choice]	40	Global		interaction
	subcategory	Subcategory	string[choice]	40	Global		interaction
	subtype	Subtype	string	40	Global		interaction
	system_wrap_up	System Wrap Up	boolean	40	Global		interaction
	sys_class_name	Interaction class name	sys_class_name[choice]	80	Global		interaction
	sys_created_by	Created by	string	40	Global		interaction
	sys_created_on	Created	glide_date_time	40	Global		interaction
	sys_domain	Domain	domain_id	32	Global		interaction
	sys_domain_path	Domain Path	domain_path	255	Global		interaction
K	sys_id	Sys ID	GUID	32	Global		interaction
	sys_mod_count	Updates	integer	40	Global		interaction
	sys_updated_by	Updated by	string	40	Global		interaction
	sys_updated_on	Updated	glide_date_time	40	Global		interaction
	transcript	Transcript	string	16000	Global		interaction
M	type	Type	string[choice]	40	Global		interaction
	user_language	User language	string	40	Global		interaction
	verified	Verified	boolean	40	Global		interaction
	virtual_agent	Virtual agent	boolean	40	Global		interaction
	voice_used	Voice used	boolean	40	Global		interaction
	wait_time	Wait time	glide_duration	40	Global		interaction
	work_notes	Work notes	journal_input	4000	Global		interaction
	wrap_up_duration	Wrap Up Duration	glide_duration	40	Global		interaction

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Uta	Tokyo (Vanilla)	Tokyo
account	missing	missing		missing	missing
agent_average_response_time	missing	missing		missing	missing
agent_chat	missing	missing		missing	missing
caller_phone_number	missing			missing	missing
chat_summary	missing		missing	missing	missing
client_host	missing			missing	missing
client_session_id	missing			missing	missing
consumer	missing	missing		missing	missing
consumer_profile	missing	missing		missing	missing
contact	missing	missing		missing	missing
first_response_wait_time	missing	missing		missing	missing
handling_duration	missing	missing		missing	missing
help_requested_conversation	missing	missing		missing	missing
last_msg_sent	missing	missing		missing	missing
live_handoff_time	missing	missing		missing	missing
recording_url	missing			missing	missing
requester_average_response_time	missing	missing		missing	missing
sentiment	missing			missing	missing
supervisor_joined_conversation	missing	missing		missing	missing
transcript_downloaded	missing	missing		missing	missing
	show all 20 ...

Referenced

interaction referenced from table:: conversation_metrics, interaction, interaction_context, interaction_log, interaction_related_record, sc_request

Diagram interaction «Interaction» / Global (global)

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out