Relations

  ReportAgentInteractionDetail ReportAgentState ReportAgentStateByPeriod ReportAggregateAgentStateSnapshot ReportAggregateAgentStateSnapshotNotReadyReason ReportAggregateQueueSnapshot ReportBusinessData ReportBusinessDataSessionIDs ReportBusinessDataValues ReportExternalInteractionDetail ReportInteractionOperationDetail ReportInteractionOverflow ReportInteractionRecord ReportInteractionRecordBase ReportQueueContext ReportQueueInteractionDetail ReportQueueSkillsContext ReportSessionBusinessOutcome ReportSessionContactID ReportSessionInteractionTerminate ReportSessionOutcome ReportSessionTerminate ReportShelfInteractionDetail ReportShelfInteractionSplitByPeriodDetail ReportSkillAgent ReportTeamAgent
ReportAgentInteractionDetail X             session, interactionID session, interactionID  interactionID interactionLegID, InteractionID, SessionID, destinationInteractionLegID -> interactionLegID sessionID, interactionID  interactionID, interactionLegID   sessionID  SessionID, InteractionLegID, interactionID  SessionID  SessionID, InteractionID  SessionID, ContactID, ListID SessionID, InteractionID  SessionID, InteractionID   SessionID, InteractionID SessionID, InteractionID   ReportTeamAgentSnapshoID -> SnapshotID
ReportAgentState X X                                               ReportTeamAgentSnapshoID -> SnapshotID
ReportAgentStateByPeriod X X                                             ReportTeamAgentSnapshoID -> SnapshotID
ReportAggregateAgentStateSnapshot X X X X                                            
ReportAggregateAgentStateSnapshotNotReadyReason X X X X X                                          
ReportAggregateQueueSnapshot X X X X X X                                        
ReportBusinessData X X X X X X X   BusinessDataID                                   
ReportBusinessDataSessionIDs X X X X X X X X session, interactionID  interactionID  interactionID, SessionID sessionID, interactionID   interactionID     sessionID  SessionID, InteractionID  SessionID  SessionID, InteractionID  SessionID SessionID, InteractionID SessionID, InteractionID SessionID SessionID, InteractionID SessionID, InteractionID    
ReportBusinessDataValues X X X X X X X X X                                  
ReportExternalInteractionDetail X X X X X X X X X X interactionID   interactionID   interactionID        interactionID    interactionID   InteractionID InteractionID   InteractionID InteractionID    
ReportInteractionOperationDetail X X X X X X X X X X X  interactionID   interactionID, interactionLeg,  destinationInteractionLegID -> interactionLegID      InteractionID, interactionLeg, DestinationInteractionLegID -> InteractionLegID    interactionID   InteractionID InteractionID   InteractionID InteractionID    
ReportInteractionOverflow X X X X X X X X X X X X interactionID      sessionID  SessionID, InteractionID   SessionID  SessionID, InteractionID  SessionID SessionID, InteractionID SessionID, InteractionID SessionID SessionID, InteractionID SessionID, InteractionID    
ReportInteractionRecord X X X X X X X X X X X X X ReportInteractionRecordBaseID -> ID    interactionID, interactionLegID    interactionID   InteractionID InteractionID   InteractionID InteractionID    
ReportInteractionRecordBase X X X X X X X X X X X X X X                        
ReportQueueContext X X X X X X X X X X X X X X X sessionID  SessionID   SessionID  SessionID SessionID SessionID SessionID SessionID SessionID    
ReportQueueInteractionDetail X X X X X X X X X X X X X X X X SessionID, ID -> QueueContextID  SessionID  SessionID SessionID SessionID SessionID SessionID SessionID    
ReportQueueSkillsContext X X X X X X X X X X X X X X X X X SessionID SessionID SessionID SessionID SessionID SessionID SessionID SkillID  
ReportSessionBusinessOutcome X X X X X X X X X X X X X X X X X X SessionID SessionID, InteractionID SessionID, InteractionID SessionID SessionID, InteractionID SessionID, InteractionID    
ReportSessionContactID X X X X X X X X X X X X X X X X X X X SessionID SessionID SessionID SessionID SessionID    
ReportSessionInteractionTerminate X X X X X X X X X X X X X X X X X X X X SessionID, InteractionID SessionID SessionID, InteractionID SessionID, InteractionID    
ReportSessionOutcome X X X X X X X X X X X X X X X X X X X X X SessionID SessionID, InteractionID SessionID, InteractionID    
ReportSessionTerminate X X X X X X X X X X X X X X X X X X X X X X SessionID SessionID    
ReportShelfInteractionDetail X X X X X X X X X X X X X X X X X X X X X X X SessionID, InteractionID   SnapshotID
ReportShelfInteractionSplitByPeriodDetail X X X X X X X X X X X X X X X X X X X X X X X X   SnapshotID
ReportSkillAgent X X X X X X X X X X X X X X X X X X X X X X X X X  
ReportTeamAgent X X X X X X X X X X X X X X X X X X X X X X X X X X
Note: Each connection is separated by comma (,) and is made by the column with the inserted name. A column -> column 2 means that the columns don't have the same name in each table. X represents entries duplication.