• 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