DW structure changes

• add new column
  • F_InteractionSegments table
    • SIPCallID
    • HPBXCallInfo

LOGIC CHANGES:

• Users db procedures changed
  • dbo schema
    • dbo.spGet_FInteractionSegments
    • dbo.spRpt_Common_Prm_AllTimeZoneList
    • dbo.spRpt_Common_Prm_TimeZoneList
    • dbo.spRpt_ValidateInteractions
  • DW schema
    • DW.spRpt_DetailedAgentInteractions
    • DW.spRpt_CommonAgentLife
    • DW.spRpt_CommonAlerts
    • DW.spRpt_CommonAttempts
    • DW.spRpt_CommonInteractions
    • DW.spRpt_CommonInteractionSegments
• ETL db procedures changed
  • Upload_F_InteractionSegments
  • dbo.Delete_D_TimeZone

LOGIC CHANGES:

4.02 Destination Trace Report:

• procedures changed:
  • DW.spRpt_DestinationTrace
• SIP Call Id:
  • Previous:

    • -

  • Current:
    • F_InteractionSegments.SIPCallId

• HPBX Call Info:
  • Previous:

    • -

  • Current:
    • F_InteractionSegments.HPBXCallInfo