Derivation Hierarchy

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
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver 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
show all 20 ...

Referenced

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

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