New Common_DynamicRoutingDataListFirstValues_DW:

• fields:
  • DynamicRoutingDataValuesL
  • DynamicRoutingDataValuesV
• parameters:
  • @DWDBName
  • @Current_User

New Common_DynamicRoutingDataListParams_DW:

• fields:
  • DynamicRoutingDataParam
• parameters:
  • @DWDBName
  • @Current_User

New Common_DynamicRoutingDataListValues_DW:

• fields:
  • DynamicRoutingDataValues
• parameters:
  • @DWDBName
  • @Current_User
  • @DynamicParam

2.01 Detailed Agent Interactions Report:

• Parameter: @DynamicRoutingData

Users structure changes

• new tables
  • dbo.ReportUsersSettings
    • fields
      • ID
      • UserName
      • ReportID

LOGIC CHANGES:

• Users db procedures changed
  • dbo schema
    • dbo.spGet_FAttempts
    • dbo.spRpt_GetInteractionsDataset
    • AllInteractionsHandled
      
    • fnGetCustomerNameFromAbbreviation
      
    • fnGetOrgAbbr
      
    • fnGetOrgAbbrDbNameIfExists
      
    • spGet_F_AgentAssignments
      
    • spGet_F_AgentBPTime
      
    • spGet_F_Callbacks
      
    • spGet_F_Campaigns
      
    • spGet_F_InteractionDelegated
      
    • spGet_F_SupervisorAssignments
      
    • spGet_FAgentLife
      
    • spGet_FAlerts
      
    • spGet_FAttempts
      
    • spGet_FInteractionConversations
      
    • spGet_FInteractions
      
    • spGet_FInteractionSegments
      
    • spGet_FInteractionSkills
      
    • spGet_FInteractionUsage
      
    • spGet_UsersList
      
    • spRequest_ForAgentData
      
    • spRequest_ForQueueData
      
    • spRequest_ForQueueData_R1
      
    • spRpt_Common_Prm_AgentNameList
      
    • spRpt_Common_Prm_BPNameList
      
    • spRpt_Common_Prm_CampaignNameList
      
    • spRpt_Common_Prm_ContactCenterNameList
      
    • spRpt_Common_Prm_CounterTypeList
      
    • spRpt_Common_Prm_Demands
      
    • spRpt_Common_Prm_DirectionNameList
      
    • spRpt_Common_Prm_DispositionCodeList
      
    • spRpt_Common_Prm_InteractionCreationTypeList
      
    • spRpt_Common_Prm_InteractionResultList
      
    • spRpt_Common_Prm_InteractionTypeList
      
    • spRpt_Common_Prm_InteractionTypeListDW
      
    • spRpt_CompletedCampaignInteraction_Prm_DispositionCodeList
      
    • spRpt_CustomerDatabseList
      
    • spRpt_CustomerDatabseList_Admin
      
    • spRpt_CustomerDatabseList_DW
      
    • spRpt_CustomerDatabseList_USER
      
    • spRpt_CustomersCallbacks
      
    • spRpt_OpenOperationalInteractions
      
    • spRpt_ProcessedAgentShiftLifeRecords
      
    • spRpt_ProcessedOperationalInteractions
      
    • spRpt_ValidateInteractions
      
    • spSelectUserInfo
      
    • spUpload_AgentCampaignAssignment
      
    • spUpload_AgentsBreaks
      
    • spUpload_AgentsToBP
      
  • DW schema
    • spRpt_AgentDetailedAlerts
    • spRpt_AgentRejectedInteractions
    • spRpt_AgentTimeAllocationPerformance
    • spRpt_AgentTimeAllocationPerformance_SubDs1
    • spRpt_AgentTransferredInteractions
    • spRpt_BusinessProcessAgentPerf
    • spRpt_BusinessProcessCallbackPerformance
    • spRpt_BusinessProcessCallbackPerformance_SubDs1
    • spRpt_BusinessProcessDetailedAlerts
    • spRpt_CampaignInspection
    • spRpt_CampaignInspection_SubDs1
    • spRpt_CampaignTimeFrameSpecificStatistics
    • spRpt_CampaignTimeFrameSpecificStatistics_SubDs1
    • spRpt_Common_Prm_TimeZoneDefault
    • spRpt_Common_Prm_TimeZoneList
    • spRpt_CommonAgentLife
    • spRpt_CommonAlerts
    • spRpt_CommonAttempts
    • spRpt_CommonInteractions
    • spRpt_CommonInteractionSegments
    • spRpt_CompletedCampaignInteraction
    • spRpt_DelegatedInteractions
    • spRpt_DetailedAgentActivity
    • spRpt_DetailedAgentInteractions
    • spRpt_DispositionCodesDistribution
    • spRpt_IncomingCallsByAreaCode_ByAreaCode
    • spRpt_IncomingCallsByAreaCode_ByAreaCodeGroupByDestination
    • spRpt_IncomingCallsByAreaCode_ByState
    • spRpt_IncomingCallsByAreaCode_ByStateGroupByDestination
    • spRpt_InteractionDispositionCodes
    • spRpt_InteractionsAnalysis
    • spRpt_MistreatedInteractions
    • spRpt_QueryInteractionsByOriginOrDestination
    • spRpt_VoiceBilling
    • spRpt_VoiceBilling_SubDs1
    • spRpt_VoiceBillingByBusinessProcess
    • spRpt_VoiceBillingByBusinessProcess_SubDs1
    • spRpt_VoiceBillingByBusinessProcessNoAbandonedCalls
    • spRpt_VoiceBillingByBusinessProcessNoAbandonedCalls_SubDs1
    • spRpt_VoiceBillingSummaryOnly
• DBA db procedures changed
  • dbo.CleanYearDbs
• ETL db procedures changed
  • dbo.CleanYearDbs
  • Delete_D_Agent
    
  • Delete_D_AgentStatus
    
  • Delete_D_AreaCode
    
  • Delete_D_BreakCategoryType
    
  • Delete_D_BreakType
    
  • Delete_D_BusinessProcess
    
  • Delete_D_Campaign
    
  • Delete_D_Clients
    
  • Delete_D_CounterType
    
  • Delete_D_CRMContact
    
  • Delete_D_DialerType
    
  • Delete_D_InboundCampaigns
    
  • Delete_D_InteractionChannel
    
  • Delete_D_InteractionResult
    
  • Delete_D_InteractionState
    
  • Delete_D_InteractionType
    
  • Delete_D_Products
    
  • Delete_D_ProductTypes
    
  • Delete_D_Skill
    
  • Delete_F_AgentAssignments
    
  • Delete_F_AgentLife
    
  • Delete_F_Alerts
    
  • Delete_F_Attempts
    
  • Delete_F_InteractionConversations
    
  • Delete_F_InteractionDelegated
    
  • Delete_F_Interactions
    
  • Delete_F_InteractionSegments
    
  • Delete_F_InteractionSkills
    
  • Delete_F_SupervisorAssignments
    
  • Upload_D_Agent
    
  • Upload_D_AgentStatus
    
  • Upload_D_AreaCode
    
  • Upload_D_BreakCategoryType
    
  • Upload_D_BreakType
    
  • Upload_D_BusinessProcess
    
  • Upload_D_Campaign
    
  • Upload_D_Clients
    
  • Upload_D_CounterType
    
  • Upload_D_CRMContact
    
  • Upload_D_DialerType
    
  • Upload_D_HandlerType
    
  • Upload_D_InboundCampaigns
    
  • Upload_D_InteractionChannel
    
  • Upload_D_InteractionResult
    
  • Upload_D_InteractionState
    
  • Upload_D_InteractionType
    
  • Upload_D_Products
    
  • Upload_D_ProductTypes
    
  • Upload_D_Skill
    
  • Upload_F_AgentAssignments
    
  • Upload_F_AgentBpTime
    
  • Upload_F_AgentBpTime_old
    
  • Upload_F_AgentLife
    
  • Upload_F_Alerts
    
  • Upload_F_Attempts
    
  • Upload_F_Callbacks
    
  • Upload_F_InteractionConversations
    
  • Upload_F_InteractionDelegated
    
  • Upload_F_Interactions
    
  • Upload_F_InteractionSegments
    
  • Upload_F_InteractionSkills
    
  • Upload_F_InteractionUsage
    
  • Upload_F_SupervisorAssignments
• msdb db jobs changed
  • Clear_InteractionInQueue
  • UpdateOperationalInteractions
  • UploadDWData

LOGIC CHANGES:

2.01 Detailed Agent Interactions Report:

• procedures changed:
  • DW.spRpt_DetailedAgentInteractions
• Dynamic Routing Data:
  • Previous:

    • -

  • Current:
    • F_Interactions.DynamicRoutingData