• 4.02 Destination Trace Report:
    • Dataset Report_DestinationTrace, new fields:
      • BusinessProcessNameInt
    • Dataset Report_DestinationTrace, new parameters (optional):
      • @BusinessProcessName
      • @MediaType
      • @InteractionType
      • @AgentName
      • @InteractionResult
      • @InteractionGuid
    • CSV Export, add field:
      • BusinessProcessName

  • New Report Admin. Growth: 

    • Dataset Report_Growth, fields:
      • org
      • subtotal
      • active_orgs
      • duration
      • onlineAgent
      • onlineSupervisor
    • Dataset Report_Growth, parameters:
      • @StartDate
      • @EndDate
      • @Offset
      • @Current_User
      • @Subtotal

LOGIC CHANGES:

  • new Users db procedures:
    • dbo.spRpt_Common_Prm_DateRangeAdminMonths
    • DW.spRpt_Growth
  • DBA db procedures changes:
    • changes procedures:
      • dbo.CreateDatabaseOnAO
      • dbo.DropDatabaseFromAOGroup
      • dbo.DropDatabaseOnAO
  • Admin. Platform Usage By Organization:

    • Third section of the report "Logged In users" column "Total Logged In" names changed:

      • Total Calls -> Total Agents
      • Incoming Calls -> Total Supervisors
  • Admin. Validate Interactions Table:
    • procedures changed:
      • dbo.spRpt_ValidateInteractions
    • changed validation rule "Queued issue":  
      • Previous:

        • InteractionSegments.InteractionState in ('AgentSelecting', 'Offered')

        • InteractionSegments.HandlerTypeID = 2

        • InteractionSegments.InteractionCreationType in ('Incoming', 'Transferred')

        • InteractionSegments.Queued = 0

      •  Current:

        • InteractionSegments.InteractionState in ('AgentSelecting')

        • InteractionSegments.HandlerTypeID = 1

        • InteractionSegments.InteractionCreationType in ('Incoming', 'Transferred')

        • InteractionSegments.Queued = 0

    • new validation rule "Queued issue":  
      • Previous:

        • -

      •  Current:

        • Interactions.Queued = 1

        • not exists InteractionSegments.InteractionState = 'AgentSelecting' and InteractionSegments.HandlerTypeID = 1 (BP)

  • 4.02 Destination Trace Report:
    • procedures changed:
      • DW.spRpt_DestinationTrace
    • Business Process Name: 
      • Previous:
        • -
      •  Current:

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

  • No labels