Revision as of 20:45, June 25, 2018 by Jdruker (talk | contribs)
Jump to: navigation, search

Summary of Info Mart Schema Changes

The following tables summarize Genesys Info Mart schema changes between 8.5 releases.

Table Column Introduced in release
Table Column Introduced in release
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource ANCHOR_FLAGS_KEY
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource ANCHOR_FLAGS_KEY
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CREATE_AUDIT_KEY
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CREATE_AUDIT_KEY
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CUSTOMER_LEFT_FIRST 8.5.004
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CUSTOMER_LEFT_FIRST 8.5.004
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_FOR_AGENT_IXN
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_FOR_AGENT_IXN
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_FOR_AGENT_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_FOR_AGENT_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_ENGAGE_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_REPLY_FOR_AGENT_IXN
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_REPLY_FOR_AGENT_IXN
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_REPLY_FOR_AGENT_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource FIRST_REPLY_FOR_AGENT_THRD
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource UPDATE_AUDIT_KEY
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource UPDATE_AUDIT_KEY
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource ATTEMPT_DISPOSITION_KEY
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource CAUSE
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource CAUSE_CODE
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource CAUSE_ID
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource CREATE_AUDIT_KEY
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource DESCRIPTOR
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource DESCRIPTOR_CODE
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5PDMSource UPDATE_AUDIT_KEY
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource BOT_CATEGORY 8.5.011
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource BOT_FUNCTION 8.5.011
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource CREATE_AUDIT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource ID 8.5.011
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource BOT_NAME 8.5.011
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource CREATE_AUDIT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource ID 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource CREATE_AUDIT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource ENDED_ABNORMALLY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource ENDED_BY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource END_REASON 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource END_RESULT 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource ID 8.5.011
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource REJECTED_TO_START 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource BGS_BOT_DIM_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource BGS_BOT_NAME_DIM_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource BGS_SESSION_DIM_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource CBS_ID 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource CREATE_AUDIT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource DURATION 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource END_DATE_TIME_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource END_TS 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource INTERACTION_SDT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource MEDIA_SERVER_IXN_GUID 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource MEDIA_TYPE_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource MESSAGES_RECEIVED 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource MESSAGES_SENT 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource START_DATE_TIME_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource START_TS 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource TENANT_KEY 8.5.011
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.011
Documentation:GIM:Library:Table-CALL RESULT:8.5PDMSource CALL_RESULT
Documentation:GIM:Library:Table-CALL RESULT:8.5PDMSource CALL_RESULT_CODE
Documentation:GIM:Library:Table-CALL RESULT:8.5PDMSource CALL_RESULT_KEY
Documentation:GIM:Library:Table-CALL RESULT:8.5PDMSource CREATE_AUDIT_KEY
Documentation:GIM:Library:Table-CALL RESULT:8.5PDMSource UPDATE_AUDIT_KEY
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource CREATE_AUDIT_KEY 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource DIAL_1_RESULT 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource DIAL_2_RESULT 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource DIAL_3_RESULT 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource DIAL_4_RESULT 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource DIAL_5_RESULT 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource ID 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_OFFER_TYPE 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_TYPE 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CHANNEL 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CONNECT_ORDER 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource CALL_DIRECTION 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource DIAL_DIALOG_RESULT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource FINAL_DIAL_RESULT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource OFFER_TIMING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource DISPOSITION 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource FINAL_TARGET 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource ABANDONED_DURING_CB_OFFER 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource CREATE_AUDIT_KEY 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource DIAL_IGNORING_AVAILABILITY 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource ID 8.5.009.20
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.

More...

Error: operator for the virtual field 'PDMTable.modified' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
Comments or questions about this documentation? Contact us for support!