X 5.4.23

Dataset Report_PlatformUsageByOrganization:

• fields:

  • Callbacks

    
    

Dataset Report_CampaignInspection:

• fields:
  • TotalEndedInServiceUnavailable

Dataset Report_CampaignInspection_SubDs:

• fields:
  • TotalEndedInServiceUnavailable

Dataset Report_DestinationTrace:

• parameters:
  • @DispositionCodeCategory

Dataset Report_DetailedAgentInteractions:

• parameters:
  • @DispositionCodeCategory

Dataset Report_InteractionsDetailRecord:

• parameters:
  • @DispositionCodeCategory

2.01 Detailed Agent Interactions Report

• Parameter: @DispositionCodeCategory

3.04 Interactions Detail Record Report

• Parameter: @DispositionCodeCategory

4.02 Destination Trace Report

• Parameter: @DispositionCodeCategory

LOGIC CHANGES:

• Users db procedures changed
  • dbo.spRpt_ValidateInteractions
  • dbo.spRpt_GetInteractionsDataset

• Admin Platform Usage By Organization Report:

  • procedures changed:
    • DW.spRpt_CustomersComparativeVoiceMinutes
  • Callbacks: 
    • Previous:

      • -

    •  Current:
      • Count(F_Interactions.InteractionId)
        F_Interactions.InteractionId = F_Callbacks.CompletedInteractionID

• 2.01 Detailed Agent Interactions Report:

  • procedures changed:
    • DW.spRpt_DetailedAgentInteractions

  • if @ShowCategoryDetails = false

    Disposition Code

    if @ShowCategoryDetails = true

    Category > SubCategory > Code: 

    • Previous:

      • F_Interactions.DispositionCode

    •  Current:

      • if @ShowCategoryDetails = false
        F_Interactions.DispositionCode

        if @ShowCategoryDetails = true
        F_Interactions.DispositionCodeCategory >

        F_Interactions.DispositionCodeSubCategory >

        F_Interactions.DispositionCode

• 3.04 Interactions Detail Record Report:

  • procedures changed:
    • DW.spRpt_InteractionsDetailRecord

  • if @ShowCategoryDetails = false

    Disposition Code

    if @ShowCategoryDetails = true

    Category > SubCategory > Code: 

    • Previous:

      • F_Interactions.DispositionCode

    •  Current:

      • if @ShowCategoryDetails = false
        F_Interactions.DispositionCode

        if @ShowCategoryDetails = true
        F_Interactions.DispositionCodeCategory >

        F_Interactions.DispositionCodeSubCategory >

        F_Interactions.DispositionCode

• 4.02 Destination Trace Report:

  • procedures changed:
    • DW.spRpt_DestinationTrace

  • if @ShowCategoryDetails = false

    Disposition Code

    if @ShowCategoryDetails = true

    Category > SubCategory > Code: 

    • Previous:

      • F_Interactions.DispositionCode

    •  Current:

      • if @ShowCategoryDetails = false
        F_Interactions.DispositionCode

        if @ShowCategoryDetails = true
        F_Interactions.DispositionCodeCategory >

        F_Interactions.DispositionCodeSubCategory >

        F_Interactions.DispositionCode

• 6.03 Campaign Inspection Report:

  • procedures changed:
    • DW.spRpt_CampaignInspection
    • DW.spRpt_CampaignInspection_SubDs1
  • Total Ended In Service Unavailable: 
    • Previous:

      • -

    •  Current:

      • Count (F_Campaigns.CampaignInteractionID)
        F_Campaigns.LastInteractionState in ('Service Unavailable')