DW structure changes
Dataset Report_CompletedCampaignInteraction_DispositionCodeList deleted
Dataset Report_DetailedBusinessEntity_SubDs:
Dataset Report_AgentTransferredInteractions:
LOGIC CHANGES:
spRpt_AgentAssignmentToBP
spRpt_AgentBreaks
spRpt_AgentDetailedAlerts
spRpt_AgentInteractionSummaryReport
spRpt_AgentRejectedInteractions
spRpt_AgentTransferredInteractions
spRpt_BusinessProcessDetailedAlerts
spRpt_DestinationTrace
spRpt_DetailedAgentActivity
spRpt_DetailedAgentInteractions
spRpt_DetailedBusinessEntity
spRpt_DetailedBusinessEntity_SubDs1
spRpt_DispositionCodesDistribution
spRpt_InboundInteractionDistribution
spRpt_IncomingCallsByAreaCode_ByAreaCode
spRpt_IncomingCallsByAreaCode_ByAreaCodeGroupByDestination
spRpt_IncomingCallsByAreaCode_ByState
spRpt_IncomingCallsByAreaCode_ByStateGroupByDestination
spRpt_InteractionDispositionCodes
spRpt_MistreatedInteractions
spRpt_QueryInteractionsByOriginOrDestination
spRpt_VoiceBilling
spRpt_VoiceBilling_SubDs1
spRpt_BusinessProcessDetailedAlerts
spRpt_CompletedCallbackInteraction
spRpt_DelegatedInteractions
spRpt_InteractionsAnalysis
spRpt_VoiceBillingByBusinessProcess
spRpt_VoiceBillingByBusinessProcess_SubDs1
spRpt_VoiceBillingByBusinessProcessNoAbandonedCalls
spRpt_VoiceBillingByBusinessProcessNoAbandonedCalls_SubDs1
spRpt_VoiceBillingSummaryOnly
spRpt_APCSummary
spRpt_AgentScoringReport_Prm_InteractionTypeList
spRpt_BusinessProcessInteractionPerformance_Prm_InteractionTypeList
spRpt_CompletedCampaignInteraction_Prm_DispositionCodeList
spRpt_DetailedBusinessEntity_Prm_CustomerBillingCodeList
spRpt_InteractionDispositionCodes_Prm_DispositionCodeList
spRpt_CustomersComparativeVoiceMinutes
case
when D_AgentStatus.AgentStatusName = 'Busy' and F_AgentLife.InteractionState = 'Wrap Up' and exists (F_interactionSegments.InteractionState = 'Handling' where F_interactionSegments.InteractionId = F_AgentLife.InteractionId
and F_interactionSegments.AgentID = F_AgentLife.AgentID) then 'Handling + Wrap Up'
when D_AgentStatus.AgentStatusName = 'Dialing' and F_AgentLife.InteractionState = 'Wrap Up' and exists (F_interactionSegments.InteractionState = 'Handling' where F_interactionSegments.InteractionId = F_AgentLife.InteractionId
and F_interactionSegments.AgentID = F_AgentLife.AgentID) then 'Dialing + Wrap Up'
else F_AgentLife.InteractionState
end
-