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)