Avaya Analytics 3.7

Tables (17)

DM_ACCOUNT (Untitled)

  • ACCOUNT_SK (Key) — INTEGER — Primary key — NOT NULL
  • ACCOUNT_NAME (Field) — TEXT (128)
  • ACTIVE_RECORD (Field2) — CHAR (1)
  • AGENT_DISPLAY_NAME (Field3) — TEXT (128)
  • AGENT_FIRST_NAME (Field4) — TEXT (128)
  • AGENT_ID (Field5)
  • AGENT_LAST_NAME (Field6)
  • AGENT_USER_HANDLE (Field7)
  • CHANNEL_ID (Field8)
  • CHANNEL_NAME (Field9)
  • LAST_CHANGED (Field10) — DATE
  • LOGIN_ID (Field11)
  • MULTIPLICITY (Field12) — INTEGER
  • PROVIDER_NAME (Field13)
  • ROW_ACTIVE_DATE (Field14) — DATE
  • ROW_INACTIVE_DATE (Field15) — DATE
  • SUPERVISOR_DISPLAY_NAME (Field16)
  • SUPERVISOR_FIRST_NAME (Field17)
  • SUPERVISOR_ID (Field18)
  • SUPERVISOR_LAST_NAME (Field19)
  • TENANT_ID (Field20)
  • UA_ACCOUNT (Field21) — CHAR(1)

DM_AGENT (Untitled2)

  • AGENT_SK (PK) — INTEGER — Primary key — NOT NULL
  • ACTIVE_RECORD (Field) — CHAR (1)
  • AGENT_DISPLAY_NAME (Field2) — TEXT (128)
  • AGENT_FIRST_NAME (Field3) — TEXT (128)
  • AGENT_ID (Field4) — TEXT (128)
  • AGENT_LAST_NAME (Field5) — TEXT (128)
  • AGENT_USER_HANDLE (Field6) — TEXT (128)
  • LAST_CHANGED (Field7) — DATE
  • ROW_ACTIVE_DATE (Field8) — DATE
  • ROW_INACTIVE_DATE (Field9) — DATE
  • SUPERVISOR_DISPLAY_NAME (Field10) — TEXT (128)
  • SUPERVISOR_FIRST_NAME (Field11) — TEXT (128)
  • SUPERVISOR_ID (Field12) — TEXT (128)
  • SUPERVISOR_LAST_NAME (Field13) — TEXT (128)

DM_AGENT_ATTRIBUTES (Untitled5)

  • AGENT_ATTRIBUTE_SK (Key) — Primary key — NOT NULL
  • AGENT_SK (PK) — INTEGER — Foreign key → DM_AGENT.AGENT_SK — NOT NULL
  • ACTIVE_RECORD (Field)
  • CATEGORY (Field3)
  • LAST_CHANGED (Field4)
  • ROW_ACTIVE_DATE (Field5)
  • ROW_INACTIVE_DATE (Field6)
  • VALUE (Field7)

DM_QUARTER_HOURS (Untitled3)

  • QUARTER_HOUR_SK (PK) — INTEGER — Primary key — NOT NULL
  • DAY_ABBRV (Field)
  • DAY_DT (Field2)
  • DAY_NAME (Field3)
  • DAY_NUMBER (Field4)
  • HOUR_DT (Field5) — DATE
  • HOUR_NUMBER (Field6) — INTEGER
  • HOUR_SK (Field7) — NTEGER
  • ISO_WEEK (Field8) — NTEGER
  • MON_ABBRV (Field9)
  • MONDAY_WEEK (Field10) — DATE
  • MONTH_NAME (Field11)
  • MONTH_NUMBER (Field12)
  • MONTH_SK (Field13)
  • QUARTER_HOUR_DT (Field14)
  • QUARTER_HOUR_MINUTES (Field15) — INTEGER
  • SUNDAY_WEEK (Field16)
  • YEAR_NUMBER (Field17)
  • YEAR_SK (Field18) — INTEGER
  • Field19

DM_ROUTING_POINTS (Untitled7)

  • ROUTING_POINT_SK (Key) — Primary key — NOT NULL
  • ACTIVE_RECORD (Field)
  • LAST_CHANGED (Field2)
  • ROUTING_POINT_ID (Field3)
  • ROUTING_POINT_NAME (Field4)
  • ROUTING_POINT_SK (Field5)
  • ROUTING_POINT_SUBTYPE (Field6)
  • ROUTING_POINT_TYPE (Field7)
  • ROW_ACTIVE_DATE (Field8)
  • ROW_INACTIVE_DATE (Field9)

DM_ROUTING_SERVICES (Untitled4)

  • ROUTING_SERVICE_SK (PK) — Primary key — NOT NULL
  • ACTIVE_RECORD (Field)
  • CHANNEL_NAME (Field2)
  • LAST_CHANGED (Field3) — DATE
  • PROVIDER_NAME (Field4)
  • ROUTING_SERVICE_ID (Field5)
  • ROUTING_SERVICE_NAME (Field6)
  • ROUTING_SERVICE_SK (Field7)
  • ROW_ACTIVE_DATE (Field8)
  • ROW_INACTIVE_DATE (Field9)

DM_SITES (Untitled6)

  • SITE_SK (Key) — NTEGER — Primary key — NOT NULL
  • ACTIVE_RECORD (Field)
  • LAST_CHANGED (Field2)
  • ROW_ACTIVE_DATE (Field3)
  • ROW_INACTIVE_DATE (Field4)
  • SITE_ID (Field5)
  • SITE_NAME (Field6)

FCT_ACCOUNT_INTERVAL (Untitled8)

  • UTC_QUARTER_HOUR_SK (PK) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • ACCOUNT_SK (Key) — INTEGER — Foreign key → DM_ACCOUNT.ACCOUNT_SK — NOT NULL
  • OFFERED (Field2)
  • COMPLETED (Field3)
  • ABANDONED (Field4)
  • NOT_ANSWERED (Field5)
  • CONFERENCED (Field6)
  • ANSWERED (Field7)
  • CONSULTS (Field8)
  • TRANSFERRED (Field9)
  • LOGON_DURATION (Field10)
  • ACW (Field11)
  • ACW_EXTENDED (Field12)
  • TRANSFERRED_TO_SERVICE (Field13)
  • ADHOC (Field14)
  • ADHOC_DURATION (Field15)
  • CONSULTS_INITIATED (Field16)
  • CONSULTS_INITIATE_TO_SERVICE (Field17)
  • CONSULTS_INITIATE_TO_AGENT (Field18)
  • TRANSFERRED_INITIATED (Field19)
  • CONFERENCED_INITIATED (Field20)
  • CONSULTS_ACCEPTED (Field21)
  • CONSULTS_ACCEPT_FROM_SERVICE (Field22)
  • CONSULTS_ACCEPT_FROM_AGENT (Field23)
  • TRANSFERRED_ACCEPTED (Field24)
  • CONFERENCED_ACCEPTED (Field25)
  • TRANSFERRED_INITIATED_TO_SERVICE (Field26)
  • TRANSFERRED_INITIATED_TO_AGENT (Field27)
  • TRANSFERRED_ACCEPTED_FROM_SERVICE (Field28)
  • COACHED (Field29)
  • COACHING (Field30)
  • OBSERVED (Field31)
  • OBSERVING (Field32)
  • BARGED_IN (Field33)
  • BARGED_OUT (Field34)
  • HOLD_DURATION (Field35)
  • ACW_DURATION (Field36)
  • BLENDED_ACTIVE_DURATION (Field37)
  • ALERT_DURATION (Field38)
  • ACTIVE_TIME_DURATION (Field39)
  • CONSULT_DURATION (Field40)
  • CONSULTING_DURATION (Field41)

FCT_AGENT_INTERVAL (Untitled9)

  • UTC_QUARTER_HOUR_SK (PK) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • AGENT_SK (PK2) — INTEGER — Foreign key → DM_AGENT.AGENT_SK — NOT NULL
  • OFFERED (Field)
  • COMPLETED (Field2)
  • ABANDONED (Field3)
  • NOT_ANSWERED (Field4)
  • CONFERENCED (Field5)
  • TRANSFERRED (Field6)
  • IDLE_TIME_DURATION (Field7)
  • HOLD_DURATION (Field8)
  • ACW_DURATION (Field9)
  • BLENDED_ACTIVE_DURATION (Field10)
  • ALERT_DURATION (Field11)
  • NOT_READY_TIME_DURATION (Field12)
  • LONG_ENGAGEMENTS (Field13)

FCT_AGENT_LOGON (Untitled17)

  • AGENT_LOGON_SK (Key) — Primary key — NOT NULL
  • AGENT_SK (PK) — INTEGER — Foreign key → DM_AGENT.AGENT_SK — NOT NULL
  • LOGIN_TIMESTAMP (Field2)
  • LOGOUT_TIMESTAMP (Field3)
  • LOGON_DURATION (Field4)
  • STATUS (Field5)
  • LAST_CHANGED (Field6)

FCT_CDR_AGENT_SEGMENT (Untitled10)

  • ENGAGEMENT_ID (Key) — Primary key — NOT NULL
  • CONTACT_ID (Key2) — Primary key — NOT NULL
  • SEGMENT_ID (Key3) — Primary key — NOT NULL
  • ORIGINATED_TIME (Key4) — Primary key — NOT NULL
  • ROUTING_SERVICE_SK (Field2)
  • CDR_AGENT_SEGMENT_SK (Field6)
  • DEFERRED_REASON_CODE_SK (Field7)
  • AGENT_CHANNEL_ADDRESS (Field8)
  • ENGAGEMENT_ID (Field9)
  • CONTACT_ID (Field10)
  • SEGMENT_ID (Field11)
  • SEGMENT_TYPE (Field12)
  • ORIGINATED_TIMESTAMP (Field13)
  • ANSWER_TIMESTAMP (Field14)
  • AGENT_SK (PK) — INTEGER — Foreign key → DM_AGENT.AGENT_SK — NOT NULL
  • ROUTING_POINT_SK (Key5) — Foreign key → DM_ROUTING_POINTS.ROUTING_POINT_SK — NOT NULL
  • CDR_CUSTOMER_CONTACT_SK (Key6) — Foreign key → FCT_CDR_CUSTOMER_CONTACT.CDR_CUSTOMER_CONTACT_SK — NOT NULL
  • CDR_CUSTOMER_ENGAGEMENT_SK (Field3) — Foreign key → FCT_CDR_CUSTOMER_ENGAGEMENT.CDR_CUSTOMER_ENGAGEMENT_SK

FCT_CDR_CUSTOMER_CONTACT (Untitled11)

  • CDR_CUSTOMER_CONTACT_SK (Key) — Primary key — NOT NULL
  • ENGAGEMENT_ID (Field5)
  • CONTACT_ID (Field6)
  • CUSTOMER_ID (Field7)
  • SEGMENT_TYPE (Field8)
  • END_TIMESTAMP (Field9)
  • RING_TIME_DURATION (Field10)
  • HANDLING_TIME_DURATION (Field11)
  • HOLD_DURATION (Field12)
  • ACTIVE_TIME_DURATION (Field13)
  • ROUTING_POINT_SK (Key2) — Foreign key → DM_ROUTING_POINTS.ROUTING_POINT_SK — NOT NULL
  • UTC_QUARTER_HOUR_SK (PK2) — INTEGER — Foreign key → FCT_ROUTE_SERV_BY_AGT_INTERVAL.UTC_QUARTER_HOUR_SK — NOT NULL
  • CDR_CUSTOMER_ENGAGEMENT_SK (Field3) — Foreign key → FCT_CDR_CUSTOMER_ENGAGEMENT.CDR_CUSTOMER_ENGAGEMENT_SK

FCT_CDR_CUSTOMER_ENGAGEMENT (Untitled12)

  • TC_QUARTER_HOUR_SK (Key) — Primary key — NOT NULL
  • AGENT_SK (Key2) — Primary key — NOT NULL
  • CDR_CUSTOMER_ENGAGEMENT_SK (Field3) — Primary key
  • ROUTING_SERVICE_SK (PK) — Foreign key → DM_ROUTING_SERVICES.ROUTING_SERVICE_SK — NOT NULL
  • ENGAGEMENT_ID (FK)
  • ORIGINATED_TIMESTAMP (Field5)
  • END_TIMESTAMP (Field6)
  • ENGAGEMENT_DURATION (Field7)
  • INCOMPLETE (Field8)
  • PERSONAL_CONTACT_INDICATOR (Field9)
  • ROUTING_POINT_SK (Key4) — Foreign key → DM_ROUTING_POINTS.ROUTING_POINT_SK — NOT NULL

FCT_ROUTE_SERV_BY_AGT_INTERVAL (Untitled13)

  • UTC_QUARTER_HOUR_SK (PK2) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • OFFERED (Field)
  • COMPLETED (Field2)
  • ABANDONED (Field3)
  • NOT_ANSWERED (Field4)
  • CONFERENCED (Field5)
  • ANSWERED (Field6)
  • CONSULTS (Field7)
  • TRANSFERRED (Field8)
  • AGENT_SK (PK) — INTEGER — Foreign key → DM_AGENT.AGENT_SK — NOT NULL
  • ROUTING_SERVICE_SK (PK3) — Foreign key → DM_ROUTING_SERVICES.ROUTING_SERVICE_SK — NOT NULL

FCT_ROUTING_POINT_INTERVAL (Untitled16)

  • ROUTING_POINT_SK (Key2) — Foreign key → DM_ROUTING_POINTS.ROUTING_POINT_SK — NOT NULL
  • UTC_QUARTER_HOUR_SK (PK) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • HANDLED (Field)
  • ROUTING_DURATION (Field2)
  • DISCONNECTS (Field3)

FCT_ROUTING_SERVICE_INTERVAL (Untitled14)

  • UTC_QUARTER_HOUR_SK (PK2) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • ROUTING_SERVICE_SK (PK) — Foreign key → DM_ROUTING_SERVICES.ROUTING_SERVICE_SK — NOT NULL
  • ANSWERED (Field)
  • ABANDONED (Field2)
  • OFFERED (Field3)
  • COMPLETED (Field4)
  • NOT_ANSWERED (Field5)
  • TRANSFERRED (Field6)
  • ACTIVE_TIME_DURATION (Field7)
  • RING_TIME_DURATION (Field8)

FCT_SITE_INTERVAL (Untitled15)

  • SITE_SK (Key) — NTEGER — Foreign key → DM_SITES.SITE_SK — NOT NULL
  • UTC_QUARTER_HOUR_SK (PK) — INTEGER — Foreign key → DM_QUARTER_HOURS.QUARTER_HOUR_SK — NOT NULL
  • OFFERED (Field2)
  • COMPLETED (Field3)
  • ABANDONED (Field4)
  • NOT_ANSWERED (Field5)
  • ANSWERED (Field6)
  • HOLDS (Field7)
  • COMP_ANSWERED (Field8)
  • COMP_OFFERED (Field9)
  • COMP_HOLDS (Field10)
  • CONSULTS_INITIATED (Field11)
  • CONSULTS_INITIATE_TO_SERVICE (Field12)