• DW structure changes
    • new tables:
      • D_AgentGroup
      • D_BPGroup
      • D_AgentGroupAssignments
      • D_BPGroupAssignments
  • Users structure changes
    • new tables:
      • dbo.OrganizationGrowth
  • New SQL Server Agent Job
    • Add_Job_Scheduler_User_To_DW
  • 4.01 Detailed Business Entity:
    • Report_DetailedBusinessEntity, new fields:
      • BusinessProcessNameInt
    • Report_DetailedBusinessEntity_SubDs, new fields:
      • BusinessProcessNameInt

LOGIC CHANGES:

  • ETL db changes:
    • changes procedures:
      • dbo.Upload_D_Agent
      • dbo.Upload_D_BusinessProcess
  • DBA db procedures changes:
    • changes procedures:
      • dbo.UpdateSubscriptionsMissingAgent
      • dbo.UpdateSubscriptionsMissingBP
  • new Users db procedures:
    • dbo.spGet_Agent
    • dbo.spGet_AgentGroup
    • dbo.spGet_AgentGroupAssignments
    • dbo.spGet_BPGroup
    • dbo.spGet_BPGroupAssignments
    • dbo.spGet_BusinessProcess
    • dbo.spSet_AgentGroup
    • dbo.spSet_BPGroup
  • Admin. Growth:
    • procedures changed:
      • DW.spRpt_Growth
    • Total logged in Supervisors:  
      • Previous:

        • count(distinct case when isnull(D_agent.IsSupervisor, 0) = 1 then F_AgentBpTime.AgentId else null end)

      •  Current:

        • count(distinct case when isnull(D_agent.IsSupervisor, 0) = 1 then F_AgentLife.AgentId else null end) 

  • 2.03 Agent Scoring:
    • procedures changed:
      • DW.spRpt_AgentScoring
      • DW.spRpt_AgentScoring_SubDs1
      • DW.spRpt_AgentScoring_SubDs2
    • BP Name filter: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • 4.01 Detailed Business Entity:
    • procedures changed:
      • DW.spRpt_DetailedBusinessEntity
      • DW.spRpt_DetailedBusinessEntity_SubDs1
    • BP Name: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • 4.03 Interaction Disposition Codes:
    • procedures changed:
      • DW.spRpt_InteractionDispositionCodes
    • BP Name filter and grouping: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • 4.10 Inbound Interactions Distribution:
    • procedures changed:
      • DW.spRpt_InboundInteractionDistribution
    • BP Name filter: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • 4.11 Interactions Analysis:
    • procedures changed:
      • DW.spRpt_InteractionsAnalysis
    • BP Name filter: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • 4.13 Disposition Codes Distribution:
    • procedures changed:
      • DW.spRpt_DispositionCodesDistribution
    • BP Name filter: 
      • Previous:
        • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
      •  Current:

        • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

  • No labels