• DW structure changes
    • added indexes to tables:
      • F_AgentLife table
        • IX_F_AgentLife_SourceKey_StartTime_AgentLifeTypeID
    • add new column 
      • F_Interactions table
        • HPBXCallInfo
    • change column type
      • F_Interactions.CampaignId
        • smallint->int
      • F_InteractionSegments.CampaignId
        • smallint->int
      • F_Attempts.CampaignId
        • smallint->int
      • D_Campaign.CampaignId
        • smallint→int
  • DBA structure changes
    • new tables
      • dbo.ASPStateTempSessions
        • fields
          • SessionId
          • Created
          • Expires
          • LockDate
          • LockDateLocal
          • LockCookie
          • Timeout
          • Locked
          • SessionItemShort
          • SessionItemLong
          • Flags  
      • dbo.ASPStateTempApplications
        • fields
          • AppId
          • AppName

LOGIC CHANGES:

  • ETL db changes:
    • changes procedures:
      • dbo.Upload_F_AgentLife(optimization)
      • dbo.Upload_D_Skill
      • dbo.Upload_F_Interactions
      • dbo.Upload_F_InteractionSegments
      • dbo.Upload_F_Attempts
  • DBA new db procedures:
    • dbo.DeleteExpiredSessions
    • dbo.GetHashCode
    • dbo.TempGetAppID
    • dbo.TempGetStateItem
    • dbo.TempGetStateItem2
    • dbo.TempGetStateItem3
    • dbo.TempGetStateItemExclusive
    • dbo.TempGetStateItemExclusive2
    • dbo.TempGetStateItemExclusive3
    • dbo.TempGetVersion
    • dbo.TempInsertStateItemLong
    • dbo.TempInsertStateItemShort
    • dbo.TempInsertUninitializedItem
    • dbo.TempReleaseStateItemExclusive
    • dbo.TempRemoveStateItem
    • dbo.TempResetTimeout
    • dbo.TempUpdateStateItemLong
    • dbo.TempUpdateStateItemLongNullShort
    • dbo.TempUpdateStateItemShort
    • dbo.TempUpdateStateItemShortNullLong
    • dbo.GetMajorVersion
  • DBA db procedures changed:
    • dbo.UpdateSubscriptionsMissingAgent
    • dbo.UpdateSubscriptionsMissingBP
    • dbo.UpdateSubscriptionsBPGroupChanges
  • Users db procedures changed:
    • DW.spRpt_Common_Prm_AgentGroups
    • DW.spRpt_Common_Prm_BPGroups
    • DW.spRpt_DestinationTrace
    • DW.spRpt_DetailedBusinessEntity
    • DW.spRpt_DetailedBusinessEntity_SubDs1
  • No labels