Revision as of 18:15, July 4, 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.


"released"

"Documentation:GIM:Library:%%:8.5PDMSource"


132 tables

Table
Table
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT
Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT
Documentation:GIM:Library:Table-BGS BOT DIM:8.5DRAFT
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5DRAFT
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5DRAFT
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5DRAFT
Documentation:GIM:Library:Table-CALL RESULT:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5DRAFT
Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT
Documentation:GIM:Library:Table-CALLING LIST METRIC FACT:8.5DRAFT
Documentation:GIM:Library:Table-CAMPAIGN GROUP SESSION FACT:8.5DRAFT
Documentation:GIM:Library:Table-CAMPAIGN GROUP STATE FACT:8.5DRAFT
Documentation:GIM:Library:Table-CAMPAIGN GROUP STATE:8.5DRAFT
Documentation:GIM:Library:Table-CDR DIM1:8.5DRAFT
Documentation:GIM:Library:Table-CDR FACT:8.5DRAFT
Documentation:GIM:Library:Table-CHAT SESSION DIM:8.5DRAFT
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT
Documentation:GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT
Documentation:GIM:Library:Table-COBROWSE END REASON:8.5DRAFT
Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT
Documentation:GIM:Library:Table-COBROWSE MODE:8.5DRAFT
Documentation:GIM:Library:Table-COBROWSE PAGE:8.5DRAFT
Documentation:GIM:Library:Table-COBROWSE USER AGENT:8.5DRAFT
Documentation:GIM:Library:Table-CONTACT ATTEMPT FACT:8.5DRAFT
Documentation:GIM:Library:Table-CONTACT INFO TYPE:8.5DRAFT
Documentation:GIM:Library:Table-CTL AUDIT LOG:8.5DRAFT
Documentation:GIM:Library:Table-CTL ETL HISTORY:8.5DRAFT
Documentation:GIM:Library:Table-CTL EXTRACT HISTORY:8.5DRAFT
Documentation:GIM:Library:Table-CTL GDPR HISTORY:8.5DRAFT
Documentation:GIM:Library:Table-CTL PURGE HISTORY:8.5DRAFT
Documentation:GIM:Library:Table-CTL TRANSFORM HISTORY:8.5DRAFT
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT
Documentation:GIM:Library:Table-CTL UDE KEYS TO DIM MAPPING:8.5DRAFT
Documentation:GIM:Library:Table-DATE TIME:8.5DRAFT
Documentation:GIM:Library:Table-DIALING MODE:8.5DRAFT
Documentation:GIM:Library:Table-GPM DIM1:8.5DRAFT
Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT
Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT
Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT
Documentation:GIM:Library:Table-GROUP ANNEX:8.5DRAFT
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT
Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT
Documentation:GIM:Library:Table-INTERACTION RESOURCE STATE:8.5DRAFT
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT
Documentation:GIM:Library:Table-IRF USER DATA KEYS:8.5DRAFT
Documentation:GIM:Library:Table-IXN RESOURCE STATE FACT:8.5DRAFT
Documentation:GIM:Library:Table-LDR CAMPAIGN:8.5DRAFT
Documentation:GIM:Library:Table-LDR DEVICE:8.5DRAFT
Documentation:GIM:Library:Table-LDR FACT:8.5DRAFT
Documentation:GIM:Library:Table-LDR GROUP:8.5DRAFT
Documentation:GIM:Library:Table-LDR LIST:8.5DRAFT
Documentation:GIM:Library:Table-LDR POSTAL CODE:8.5DRAFT
Documentation:GIM:Library:Table-LDR RECORD:8.5DRAFT
Documentation:GIM:Library:Table-MEDIA ORIGIN:8.5DRAFT
Documentation:GIM:Library:Table-MEDIA TYPE:8.5DRAFT
Documentation:GIM:Library:Table-MEDIATION SEGMENT FACT:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT
Documentation:GIM:Library:Table-RECORD FIELD GROUP 1:8.5DRAFT
Documentation:GIM:Library:Table-RECORD FIELD GROUP 2:8.5DRAFT
Documentation:GIM:Library:Table-RECORD STATUS:8.5DRAFT
Documentation:GIM:Library:Table-RECORD TYPE:8.5DRAFT
Documentation:GIM:Library:Table-REQUESTED SKILL COMBINATION:8.5DRAFT
Documentation:GIM:Library:Table-REQUESTED SKILL:8.5DRAFT
Documentation:GIM:Library:Table-RESOURCE ANNEX:8.5DRAFT
Documentation:GIM:Library:Table-RESOURCE GROUP COMBINATION:8.5DRAFT
Documentation:GIM:Library:Table-RESOURCE STATE REASON:8.5DRAFT
Documentation:GIM:Library:Table-RESOURCE STATE:8.5DRAFT
Documentation:GIM:Library:Table-RESOURCE:8.5DRAFT
Documentation:GIM:Library:Table-ROUTING TARGET:8.5DRAFT
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT
Documentation:GIM:Library:Table-SDR ACTIVITY:8.5DRAFT
Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT
Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXIT POINT:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT
Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT
Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT
Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT
Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT

More...

Modified

Table Table Introduced Column Introduced Column Modified
Table Table Introduced Column Introduced Column Modified
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.008 (data type increased from 10 to 19 digits)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.008 (default value added)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.009.20 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.009.20 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.009.20 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. 8.5.009.20 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource 8.5.011.14 8.5.012.15 (No longer a mandatory field)
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource 8.5.006 (IRF_ROUTE value is added) 8.5.001 (IRF_INITIAL value is added).
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource 8.5.006 (IRF_ROUTE value is added) 8.5.001 (IRF_INITIAL value is added).
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource 8.5.009 8.5.009.20 (default value no longer defined)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource 8.5.009 8.5.011 (added to the composite primary key in nonpartitioned databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource 8.5.009 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource 8.5.001 (error code 26 added)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource 8.5.007 (data type extended from 255 to 1024 characters)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.003 and 8.5.004 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource 8.5.004 (scope extended)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource 8.5.005 (OutboundCallback subtype added) 8.5.001 (InternalConferenceInvite subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource 8.5.005 (OutboundCallback subtype added) 8.5.001 (InternalConferenceInvite subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource 8.5.005 (OUTBOUNDCALLBACK subtype added) 8.5.001 (INTERNALCONFERENCEINVITE subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource 8.5.005 (OUTBOUNDCALLBACK subtype added) 8.5.001 (INTERNALCONFERENCEINVITE subtype added)
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types).
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types).
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource 8.5.003. Supported in certain deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource 8.5.003.17 (new value, Person, added for the Agent resource type)
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource 8.5.007. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource 8.5.007. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.007 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.008 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource 8.5.005. Supported in certain Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) 8.5.008.29 (behavior changed)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) 8.5.008.29 (behavior changed)
Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource 8.5.004.09. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource 8.5.001. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource 8.5.004. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource 8.5.004. Supported in Genesys Engage cloud deployments only. 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)

More...

Table Column Change occurred in
Table Column Change occurred in
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
ATTEMPT_DISPOSITION
BGS_BOT_DIM 8.5.011
BGS_BOT_DIM 8.5.011
BGS_BOT_DIM 8.5.011
BGS_BOT_DIM 8.5.011
BGS_BOT_NAME_DIM 8.5.011
BGS_BOT_NAME_DIM 8.5.011
BGS_BOT_NAME_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_DIM 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
BGS_SESSION_FACT 8.5.011
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIAL_RESULTS 8.5.009.20
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_4 8.5.009.20
CALLBACK_DIM_4 8.5.009.20
CALLBACK_DIM_4 8.5.009.20
CALLBACK_DIM_4 8.5.009.20
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.

More...

Table Column Change occurred in
Table Column Change occurred in
ANCHOR_FLAGS ANCHOR_FLAGS_KEY
ANCHOR_FLAGS ANCHOR_FLAGS_KEY
ANCHOR_FLAGS CREATE_AUDIT_KEY
ANCHOR_FLAGS CREATE_AUDIT_KEY
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004
ANCHOR_FLAGS FIRST_ENGAGE_FOR_AGENT_IXN
ANCHOR_FLAGS FIRST_ENGAGE_FOR_AGENT_IXN
ANCHOR_FLAGS FIRST_ENGAGE_FOR_AGENT_THRD
ANCHOR_FLAGS FIRST_ENGAGE_FOR_AGENT_THRD
ANCHOR_FLAGS FIRST_ENGAGE_THRD
ANCHOR_FLAGS FIRST_ENGAGE_THRD
ANCHOR_FLAGS FIRST_REPLY_FOR_AGENT_IXN
ANCHOR_FLAGS FIRST_REPLY_FOR_AGENT_IXN
ANCHOR_FLAGS FIRST_REPLY_FOR_AGENT_THRD
ANCHOR_FLAGS FIRST_REPLY_FOR_AGENT_THRD
ANCHOR_FLAGS UPDATE_AUDIT_KEY
ANCHOR_FLAGS UPDATE_AUDIT_KEY
ATTEMPT_DISPOSITION ATTEMPT_DISPOSITION_KEY
ATTEMPT_DISPOSITION CAUSE
ATTEMPT_DISPOSITION CAUSE_CODE
ATTEMPT_DISPOSITION CAUSE_ID
ATTEMPT_DISPOSITION CREATE_AUDIT_KEY
ATTEMPT_DISPOSITION DESCRIPTOR
ATTEMPT_DISPOSITION DESCRIPTOR_CODE
ATTEMPT_DISPOSITION UPDATE_AUDIT_KEY
BGS_BOT_DIM BOT_CATEGORY 8.5.011
BGS_BOT_DIM BOT_FUNCTION 8.5.011
BGS_BOT_DIM CREATE_AUDIT_KEY 8.5.011
BGS_BOT_DIM ID 8.5.011
BGS_BOT_NAME_DIM BOT_NAME 8.5.011
BGS_BOT_NAME_DIM CREATE_AUDIT_KEY 8.5.011
BGS_BOT_NAME_DIM ID 8.5.011
BGS_SESSION_DIM CREATE_AUDIT_KEY 8.5.011
BGS_SESSION_DIM ENDED_ABNORMALLY 8.5.011
BGS_SESSION_DIM ENDED_BY 8.5.011
BGS_SESSION_DIM END_REASON 8.5.011
BGS_SESSION_DIM END_RESULT 8.5.011
BGS_SESSION_DIM ID 8.5.011
BGS_SESSION_DIM REJECTED_TO_START 8.5.011
BGS_SESSION_FACT BGS_BOT_DIM_KEY 8.5.011
BGS_SESSION_FACT BGS_BOT_NAME_DIM_KEY 8.5.011
BGS_SESSION_FACT BGS_SESSION_DIM_KEY 8.5.011
BGS_SESSION_FACT CBS_ID 8.5.011
BGS_SESSION_FACT CREATE_AUDIT_KEY 8.5.011
BGS_SESSION_FACT DURATION 8.5.011
BGS_SESSION_FACT END_DATE_TIME_KEY 8.5.011
BGS_SESSION_FACT END_TS 8.5.011
BGS_SESSION_FACT INTERACTION_SDT_KEY 8.5.011
BGS_SESSION_FACT MEDIA_SERVER_IXN_GUID 8.5.011
BGS_SESSION_FACT MEDIA_TYPE_KEY 8.5.011
BGS_SESSION_FACT MESSAGES_RECEIVED 8.5.011
BGS_SESSION_FACT MESSAGES_SENT 8.5.011
BGS_SESSION_FACT START_DATE_TIME_KEY 8.5.011
BGS_SESSION_FACT START_TS 8.5.011
BGS_SESSION_FACT TENANT_KEY 8.5.011
BGS_SESSION_FACT UPDATE_AUDIT_KEY 8.5.011
CALLBACK_DIAL_RESULTS CREATE_AUDIT_KEY 8.5.009.20
CALLBACK_DIAL_RESULTS DIAL_1_RESULT 8.5.009.20
CALLBACK_DIAL_RESULTS DIAL_2_RESULT 8.5.009.20
CALLBACK_DIAL_RESULTS DIAL_3_RESULT 8.5.009.20
CALLBACK_DIAL_RESULTS DIAL_4_RESULT 8.5.009.20
CALLBACK_DIAL_RESULTS DIAL_5_RESULT 8.5.009.20
CALLBACK_DIAL_RESULTS ID 8.5.009.20
CALLBACK_DIM_1 CALLBACK_OFFER_TYPE 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 CALLBACK_TYPE 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 CHANNEL 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 CONNECT_ORDER 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_1 ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 CALL_DIRECTION 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 DIAL_DIALOG_RESULT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 FINAL_DIAL_RESULT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_2 OFFER_TIMING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 CREATE_AUDIT_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 DISPOSITION 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 FINAL_TARGET 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_3 ID 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_DIM_4 ABANDONED_DURING_CB_OFFER 8.5.009.20
CALLBACK_DIM_4 CREATE_AUDIT_KEY 8.5.009.20
CALLBACK_DIM_4 DIAL_IGNORING_AVAILABILITY 8.5.009.20
CALLBACK_DIM_4 ID 8.5.009.20
CALLBACK_FACT ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ABANDONED_WAITING 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT ADDED_TS 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT AGENT_ADDED_TO_IXN 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
CALLBACK_FACT CALLBACK_ACCEPTED 8.1.402. Supported for on-premises deployments starting with release 8.5.005.

More...

Query that used to work but doesn't since I changed PDMTable.modified to a list:

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!