Jump to: navigation, search
Line 6: Line 6:
 
tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified
 
tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified
 
|join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID
 
|join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID
−
|fields=PDMTable._pageName=Table,PDMColumn.colName=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,IF((PDMColumn.modified IS NOT NULL),PDMColumn.introduced,''))=Introduced in release,IF((PDMColumn__modified._value IS NOT NULL),PDMColumn__modified._value,'')=Modified in release
+
|fields=PDMTable._pageName=Table,PDMColumn.colName=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.introduced,''))=Introduced in release,
−
|where=PDMTable._pageName LIKE "%Library:%:8.5DRAFT"
+
|where=PDMTable._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="%:8.5DRAFT%"|preview|released|#default="%8.5PDMSource%"}} AND ((PDMTable.introduced IS NOT NULL) OR (PDMTable__modified._value IS NOT NULL))
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}
Line 18: Line 18:
 
|rows per page = 100
 
|rows per page = 100
 
}}
 
}}
 +
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 20:45, June 25, 2018

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!