Revision as of 22:48, April 17, 2018 by Jdruker (talk | contribs) (Undo revision 662008 by Jdruker (talk))
Jump to: navigation, search

Migration Guide Prep

How can we use this data-driven approach to (a) streamline and (b) verify content for the Migration Guide?

Quick-and-dirty proof of concept. Need to templatize this -- without using phantom templates, it's hard to refine the output.

This allows for {{Editgrn_open}} at the start of the parameter value. Would also need to allow for change bars and switch functions (list below does not include the Oracle VARCHAR fix).

Tables introduced

Article Table Introduced
GIM:Library:Table-BGS BOT DIM:8.5DRAFT 8.5.011
GIM:Library:Table-BGS BOT NAME DIM:8.5DRAFT 8.5.011
GIM:Library:Table-BGS SESSION DIM:8.5DRAFT 8.5.011
GIM:Library:Table-BGS SESSION FACT:8.5DRAFT 8.5.011
GIM:Library:Table-CALLBACK DIAL RESULTS:8.5DRAFT 8.5.009.20
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
GIM:Library:Table-CALLBACK DIM 4:8.5DRAFT 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
GIM:Library:Table-CDR DIM1:8.5DRAFT 8.5.013.06
GIM:Library:Table-CDR FACT:8.5DRAFT 8.5.013.06
GIM:Library:Table-CHAT SESSION DIM:8.5DRAFT 8.5.011
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT 8.5.011
GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT 8.5.014.09
GIM:Library:Table-COBROWSE END REASON:8.5DRAFT 8.5.011.14
GIM:Library:Table-COBROWSE FACT:8.5DRAFT 8.5.011.14
GIM:Library:Table-COBROWSE MODE:8.5DRAFT 8.5.011.14
GIM:Library:Table-COBROWSE PAGE:8.5DRAFT 8.5.011.14
GIM:Library:Table-COBROWSE USER AGENT:8.5DRAFT 8.5.011.14
GIM:Library:Table-CTL GDPR HISTORY:8.5DRAFT 8.5.010
GIM:Library:Table-GPM DIM1:8.5DRAFT 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT 8.5.009
GIM:Library:Table-GPM MODEL:8.5DRAFT 8.5.009
GIM:Library:Table-GPM PREDICTOR:8.5DRAFT 8.5.009
GIM:Library:Table-GPM RESULT:8.5DRAFT 8.5.009
GIM:Library:Table-GROUP ANNEX:8.5DRAFT 8.1.4
GIM:Library:Table-LDR CAMPAIGN:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR DEVICE:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR FACT:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR GROUP:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR LIST:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR POSTAL CODE:8.5DRAFT 8.5.012.15
GIM:Library:Table-LDR RECORD:8.5DRAFT 8.5.012.15
GIM:Library:Table-MEDIA ORIGIN:8.5DRAFT 8.5.014.09
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT 8.5.003. Supported in certain deployments only.
GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT 8.5.007. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR ACTIVITY:8.5DRAFT 8.5.007. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR APPLICATION:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR CALL TYPE:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXIT POINT:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT 8.5.004.09. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT 8.5.004.09. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT 8.5.004. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR INPUT:8.5DRAFT 8.5.004.09. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT 8.5.004.09. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR LANGUAGE:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR MESSAGE:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR MILESTONE:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT 8.5.001
GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT 8.5.008.29. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT 8.5.008.29. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY I1:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY I2:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT 8.5.008.29. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT 8.5.007. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT 8.5.007. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT 8.5.007. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT 8.5.007. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY SCORES:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT 8.5.005. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT 8.5.005.20. Supported in certain Genesys Engage cloud deployments only.
GIM:Library:Table-SDR USER INPUT:8.5DRAFT 8.5.004.09
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT 8.5.004.09
GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT 8.5.001. Supported in Genesys Engage cloud deployments only.
GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT 8.5.002

Tables modified

Article Table Modified
GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT 8.5.004 (CUSTOMER_LEFT_FIRST column added); 8.5.001 (population of FIRST_*_THRD metrics made conditional)
GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT 8.5.003 (In Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data types for the following columns modified in multi-language databases: CHANNEL, CALLBACK_OFFER_TYPE, CALLBACK_TYPE, CONNECT_ORDER)
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data types for the following columns modified in multi-language databases: DIAL_DIALOG_RESULT, CALL_DIRECTION, FINAL_DIAL_RESULT, OFFER_TIMING)
GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for FINAL_TARGET modified in multi-language databases)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for various ID columns modified in multi-language databases, as identified in the column descriptions); 8.5.009.20 (21 new columns added, as identified in the column descriptions); 8.5.003 (PUSH_DELIVERY_CONFIRMED_TS and CUSTOMER_READY_TO_START_IXN_TS added; DESIRED_TIME renamed to DESIRED_TIME_TS, which has been made mandatory)
GIM:Library:Table-CALL RESULT:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CAMPAIGN GROUP SESSION FACT:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CAMPAIGN GROUP STATE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CAMPAIGN GROUP STATE FACT:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CHAT SESSION DIM:8.5DRAFT 8.5.011.14 (ASYNC_MODE column added to table and index)
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT 8.5.014.09 (THREAD_ID column added); 8.5.011.14 (8 new columns added specific to asynchronous chat, as identified in the column descriptions)
GIM:Library:Table-CONTACT ATTEMPT FACT:8.5DRAFT 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60 added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CONTACT INFO TYPE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL AUDIT LOG:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL ETL HISTORY:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL EXTRACT HISTORY:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL GDPR HISTORY:8.5DRAFT 8.5.010.16 (scope extended to cover employee GDPR requests)
GIM:Library:Table-CTL PURGE HISTORY:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL TRANSFORM HISTORY:8.5DRAFT 8.5.010 (HWM_VALUE2 column added); 8.5.009 (AUDIT_KEY column added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL UDE KEYS TO DIM MAPPING:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.1.201 (CONVERT_EXPRESSION column added)
GIM:Library:Table-DATE TIME:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-DIALING MODE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-GPM FACT:8.5DRAFT 8.5.014.09 (DEFAULT_SCORE, DEFAULT_SCORE_USED, DEFAULT_SCORES_COUNT, GLOBAL_SCORES_COUNT, ADJUSTED_SCORE, INITIAL_SCORE_THRESHOLD, FINAL_SCORE_THRESHOLD, SUITABLE_AGENTS_COUNT, GPM_DIM1_KEY added); 8.5.011 (START_DATE_TIME_KEY became part of the composite primary key in nonpartitioned as well as partitioned databases); 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for MEDIA_SERVER_IXN_GUID modified in multi-language databases)
GIM:Library:Table-GPM MODEL:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the MODEL and MODEL_ID columns modified in single-language databases)
GIM:Library:Table-GPM PREDICTOR:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the PREDICTOR and PREDICTOR_ID columns modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: GPM_MODE, GPM_STATUS, GPM_RESULT, GPM_USE, CUSTOMER_FOUND)
GIM:Library:Table-GROUP ANNEX:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single- and multi-language databases: CUSTOMER_SEGMENT, SERVICE_TYPE, SERVICE_SUBTYPE, BUSINESS_RESULT); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-INTERACTION FACT:8.5DRAFT 8.5.003 (ANCHOR_ID and ANCHOR_SDT_KEY added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT 8.5.006 (TARGET_ADDRESS column added); 8.5.004 (IRF_ANCHOR_SENT_TS renamed to IRF_ANCHOR_TS; LAST_INTERACTION_RESOURCE column populated for all media types; scope of ANCHOR_FLAGS_KEY extended; columns added: FOCUS_TIME_COUNT, FOCUS_TIME_DURATION, ASM_COUNT, ASM_ENGAGE_DURATION); 8.5.003 (IRF_ANCHOR_DATE_TIME_KEY column renamed to IRF_ANCHOR_SENT_TS; LAST_INTERACTION_RESOURCE column populated for voice); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.5.001 (scope of some CONS_* fields expanded to include chat consultations)
GIM:Library:Table-INTERACTION RESOURCE STATE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-INTERACTION TYPE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters); 8.5.005.09 (data types of CUSTOM_DATA_13 through CUSTOM_DATA_16 changed to character data types); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added)
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT 8.5.011.18 (GSW_CALL_TYPE added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added)
GIM:Library:Table-IRF USER DATA KEYS:8.5DRAFT 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added)
GIM:Library:Table-MEDIATION SEGMENT FACT:8.5DRAFT 8.5.004 (USERDATA_FLAG added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-MEDIA TYPE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: SURVEY_IAGENTSCORE, SURVEY_ICOMPANYSCORE, SURVEY_ICALLSCORE, SURVEY_IPRODUCTSCORE, SURVEY_IQ1)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases and for the SURVEY_SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases and for the SURVEY_SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_* columns modified in single-language databases)
GIM:Library:Table-RECORD FIELD GROUP 1:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RECORD FIELD GROUP 2:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RECORD STATUS:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RECORD TYPE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-REQUESTED SKILL COMBINATION:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RESOURCE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RESOURCE ANNEX:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RESOURCE STATE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-RESOURCE STATE REASON:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-ROUTING TARGET:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for SESSION_ID modified in multi-language databases)
GIM:Library:Table-SDR ACTIVITY:8.5DRAFT 8.5.010 (data type for the NAME column modified in single-language databases)
GIM:Library:Table-SDR APPLICATION:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the APPLICATION_* columns modified in single-language databases); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the FINAL_DISPOSITION column modified in single-language databases and for the DISPOSITION_TYPE and DISPOSITION_CATEGORY columns in single- and multi-language databases); 8.5.007 (FINAL_DISPOSITION column added)
GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added)
GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for DNIS modified in single-language databases)
GIM:Library:Table-SDR EXIT POINT:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for APPLICATION_EXIT_POINT modified in single-language databases)
GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for URL modified in single-language databases)
GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: REQUEST_NAME, REQUEST_TYPE, METHOD)
GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added)
GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for SUCCESS modified in single-language databases)
GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for SERVICE_NAME and SERVICE_RESPONSE_DESC modified in single- and multi-language databases)
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for COUNTRY_CODE modified in single-language databases and for COUNTRY_NAME, REGION, and TIMEZONE modified in single- and multi-language databases)
GIM:Library:Table-SDR INPUT:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for INPUT_NAME and INPUT_TYPE modified in single-language databases)
GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: SELECTED_OPTION, STRIKEOUT, SUCCESS)
GIM:Library:Table-SDR LANGUAGE:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for LANGUAGE_CODE and LANGUAGE_NAME modified in single-language databases)
GIM:Library:Table-SDR MESSAGE:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for MESSAGE_FILE modified in single-language databases)
GIM:Library:Table-SDR MILESTONE:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for MILESTONE and MILESTONE_PATH modified in single- and multi-language databases)
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.005 (SDR_SURVEY_* keys added); 8.5.007 (SDR_SURVEY_QUESTIONS_* keys added)
GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for SURVEY_ANSWER_STR modified in single-language databases)
GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (data type for SESSION_ID and INTERACTION_ID modified in multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for QUESTION modified in single-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the IQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the IQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: COMPLETE, RECORDING, OFFER); 8.5.008 (RECORDING column deprecated); 8.5.007 (OFFER column added)
GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for SESSION_ID modified in multi-language databases)
GIM:Library:Table-SDR USER INPUT:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for USER_INPUT_TYPE modified in single-language databases)
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for UTTERANCE and INTERPRETATION modified in multi-language databases); 8.5.008 (data type for UTTERANCE and INTERPRETATION increased from 50 to 512 characters)
GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT 8.5.010.16 (UPDATE_AUDIT_KEY added)
GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT 8.5.013.06 (END_DATE_TIME_KEY and RESOURCE_GROUP_COMBINATION_KEY added); 8.5.003 (CREATE_AUDIT_KEY column added)
GIM:Library:Table-STG IDB FK VIOLATION:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.5.011.14 (data type for TABLE_NAME increased from 30 to 255 characters)
GIM:Library:Table-STRATEGY:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-TECHNICAL DESCRIPTOR:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-TIME ZONE:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-USER DATA CUST DIM 1:8.5DRAFT 8.5.010 (in Microsoft SQL Server, data type for DIM_ATTRIBUTE_1 through DIM_ATTRIBUTE_5 modified in single- and multi-language databases); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GIM:Library:Table-WORKBIN:8.5DRAFT 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)

Columns introduced

Article Column Column Introduced
GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT CUSTOMER_LEFT_FIRST 8.5.004
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DESIRED_TIME_TS 8.5.003 (renamed from DESIRED_TIME)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT PUSH_DELIVERY_CONFIRMED_TS 8.5.003
GIM:Library:Table-CALLBACK FACT:8.5DRAFT CUSTOMER_READY_TO_START_IXN_TS 8.5.003
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DIAL_1_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DIAL_2_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DIAL_3_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DIAL_4_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DIAL_5_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT EWT_WHEN_REJECTED 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT CUSTOMER_ANI 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT SERVICE_END_TS 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT WAITED_BEFORE_OFFER_TIME 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT EWT_WHEN_LAST_DIAL 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT POS_WHEN_LAST_DIAL 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT PRIORITY_WHEN_CB_ACCEPTED 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT PRIORITY_WHEN_C_CONNECTED 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT PRIORITY_WHEN_A_CONNECTED 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT EWT_THRESHOLD_WHEN_OFFERED 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT ORIGINATION_IXN_ID 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT FIRST_OUT_IXN_ID 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT LAST_OUT_IXN_ID 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT ORS_SESSION_ID 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT CALLBACK_DIAL_RESULTS_KEY 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT CALLBACK_DIM_4_KEY 8.5.009.20
GIM:Library:Table-CALLBACK FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-CHAT SESSION DIM:8.5DRAFT ASYNC_MODE 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ASYNC_DORMANT_COUNT 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ASYNC_DORMANT_DURATION 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ASYNC_IDLE_COUNT 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ASYNC_IDLE_DURATION 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ACTIVE_IDLE_COUNT 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT ACTIVE_IDLE_DURATION 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT HANDLE_COUNT 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT HANDLE_DURATION 8.5.011.14
GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT THREAD_ID 8.5.014.09
GIM:Library:Table-CONTACT ATTEMPT FACT:8.5DRAFT RECORD_FIELD_31 through RECORD_FIELD_60 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60)
GIM:Library:Table-CTL TRANSFORM HISTORY:8.5DRAFT HWM_VALUE2 8.5.010
GIM:Library:Table-CTL TRANSFORM HISTORY:8.5DRAFT AUDIT_KEY 8.5.009
GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT CONVERT_EXPRESSION 8.1.201
GIM:Library:Table-GPM FACT:8.5DRAFT DEFAULT_SCORE 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT DEFAULT_SCORE_USED 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT DEFAULT_SCORES_COUNT 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT GLOBAL_SCORES_COUNT 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT ADJUSTED_SCORE 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT INITIAL_SCORE_THRESHOLD 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT FINAL_SCORE_THRESHOLD 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT SUITABLE_AGENTS_COUNT 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT GPM_DIM1_KEY 8.5.014.09
GIM:Library:Table-GPM FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-INTERACTION FACT:8.5DRAFT ANCHOR_ID 8.5.003
GIM:Library:Table-INTERACTION FACT:8.5DRAFT ANCHOR_SDT_KEY 8.5.003
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT IRF_ANCHOR_SENT_TS 8.5.003 (renamed from IRF_ANCHOR_DATE_TIME_KEY)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT IRF_ANCHOR_TS 8.5.004 (renamed from IRF_ANCHOR_SENT_TS)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT TARGET_ADDRESS 8.5.006
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT FOCUS_TIME_COUNT 8.5.004
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT FOCUS_TIME_DURATION 8.5.004
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT ASM_COUNT 8.5.004
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT ASM_ENGAGE_DURATION 8.5.004
GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT CREATE_AUDIT_KEY 8.5.001
GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT UPDATE_AUDIT_KEY 8.5.001
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT CREATE_AUDIT_KEY 8.5.001
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT UPDATE_AUDIT_KEY 8.5.001
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT SERVICE_ID 8.1.402
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT SERVICE_START_TS 8.1.402
GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT GSW_CALL_TYPE 8.5.011.18
GIM:Library:Table-IRF USER DATA KEYS:8.5DRAFT CREATE_AUDIT_KEY 8.5.001
GIM:Library:Table-IRF USER DATA KEYS:8.5DRAFT UPDATE_AUDIT_KEY 8.5.001
GIM:Library:Table-MEDIATION SEGMENT FACT:8.5DRAFT USERDATA_FLAG 8.5.004
GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT FINAL_DISPOSITION 8.5.007
GIM:Library:Table-SDR CALL TYPE:8.5DRAFT MEDIA_TYPE 8.5.008
GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_SCORES_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_I1_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_I2_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_S1_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_S2_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_QUESTIONS_I1_KEY 8.5.007
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_QUESTIONS_I2_KEY 8.5.007
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_QUESTIONS_S1_KEY 8.5.007
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_QUESTIONS_S2_KEY 8.5.007
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT SDR_SURVEY_STATUS_KEY 8.5.005
GIM:Library:Table-SDR SESSION FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT OFFER 8.5.007
GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT UPDATE_AUDIT_KEY 8.5.010.16
GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT END_DATE_TIME_KEY 8.5.013.06
GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT RESOURCE_GROUP_COMBINATION_KEY 8.5.013.06
GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT CREATE_AUDIT_KEY 8.5.003

Columns modified

Article Column Column Modified
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT CHANNEL 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT CALLBACK_OFFER_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT CALLBACK_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT CONNECT_ORDER 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT DIAL_DIALOG_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT CALL_DIRECTION 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT FINAL_DIAL_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT OFFER_TIMING 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT FINAL_TARGET 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DS_AUDIT_KEY 8.5.008 (data type increased from 10 to 19 digits)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT LAST_CALLBACK_OFFERED_TS 8.5.008 (default value added)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT ORIGINATION_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT FIRST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT LAST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-CALLBACK FACT:8.5DRAFT ORS_SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-COBROWSE FACT:8.5DRAFT PAGE_QUERY 8.5.012.15 (No longer a mandatory field)
GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT PROPAGATION_RULE 8.5.006 (IRF_ROUTE value is added); 8.5.001 (IRF_INITIAL value is added).
GIM:Library:Table-GPM FACT:8.5DRAFT MEDIA_SERVER_IXN_GUID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-GPM FACT:8.5DRAFT START_DATE_TIME_KEY 8.5.011 (added to the composite primary key in nonpartitioned databases)
GIM:Library:Table-GPM FACT:8.5DRAFT MESSAGE 8.5.009.20 (default value no longer defined)
GIM:Library:Table-GPM MODEL:8.5DRAFT MODEL 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM MODEL:8.5DRAFT MODEL_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM PREDICTOR:8.5DRAFT PREDICTOR 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM PREDICTOR:8.5DRAFT PREDICTOR_ID 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT GPM_MODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT GPM_STATUS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT GPM_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT GPM_USE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-GPM RESULT:8.5DRAFT CUSTOMER_FOUND 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT CUSTOMER_SEGMENT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT SERVICE_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT SERVICE_SUBTYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT BUSINESS_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-INTERACTION FACT:8.5DRAFT SUBJECT 8.5.007 (data type extended from 255 to 1024 characters)
GIM:Library:Table-INTERACTION FACT:8.5DRAFT STATUS 8.5.001 (error code 26 added)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT ANCHOR_FLAGS_KEY 8.5.004 (scope extended)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT LAST_INTERACTION_RESOURCE 8.5.003 and 8.5.004 (behavior changed)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT ROUTING_POINT_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT QUEUE_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT CONS_INIT_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT CONS_RCV_RING_COUNT 8.5.001 (scope expanded to include chat consultations)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT CONS_RCV_RING_DURATION 8.5.001 (scope expanded to include chat consultations)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT CONS_RCV_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT CONS_RCV_TALK_DURATION 8.5.001 (scope expanded to include chat consultations)
GIM:Library:Table-INTERACTION TYPE:8.5DRAFT INTERACTION_SUBTYPE 8.5.005 (OutboundCallback subtype added); 8.5.001 (InternalConferenceInvite subtype added)
GIM:Library:Table-INTERACTION TYPE:8.5DRAFT INTERACTION_SUBTYPE_CODE 8.5.005 (OUTBOUNDCALLBACK subtype added); 8.5.001 (INTERNALCONFERENCEINVITE subtype added)
GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT CUSTOM_DATA_1 through CUSTOM_DATA_16 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).
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT SURVEY_IAGENTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT SURVEY_ICOMPANYSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT SURVEY_ICALLSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT SURVEY_IPRODUCTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT SURVEY_IQ1 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT SURVEY_IQ2 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT SURVEY_IQ3 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT SURVEY_IQ4 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT SURVEY_SQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT SURVEY_SQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT SURVEY_SQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT SURVEY_SQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT SURVEY_SQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT SURVEY_SQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT SURVEY_SQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT SURVEY_SQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT SURVEY_SQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT SURVEY_SQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT SURVEY_IQ5 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT SURVEY_IQ6 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT SURVEY_IQ7 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT SURVEY_IQ8 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT SURVEY_IQ9 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT SURVEY_IQ10 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT SURVEY_IRECOMMENDSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT SURVEY_COMPLETE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT SURVEY_RECORDING 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-RESOURCE:8.5DRAFT RESOURCE_SUBTYPE 8.5.003.17 (new value, Person, added for the Agent resource type)
GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-SDR ACTIVITY:8.5DRAFT NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR APPLICATION:8.5DRAFT APPLICATION_VERSION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR APPLICATION:8.5DRAFT APPLICATION_TITLE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR APPLICATION:8.5DRAFT APPLICATION_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT DISPOSITION_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT DISPOSITION_CATEGORY 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT FINAL_DISPOSITION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR CALL TYPE:8.5DRAFT CALL_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR CALL TYPE:8.5DRAFT MEDIA_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT ATRIBUTE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT DNIS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXIT POINT:8.5DRAFT APPLICATION_EXIT_POINT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT URL
GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT REQUEST_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT REQUEST_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT METHOD 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT SUCCESS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT SERVICE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT SERVICE_RESPONSE_DESC 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT COUNTRY_CODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT COUNTRY_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT REGION 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT TIMEZONE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR INPUT:8.5DRAFT INPUT_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR INPUT:8.5DRAFT INPUT_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT SELECTED_OPTION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT STRIKEOUT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT SUCCESS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR LANGUAGE:8.5DRAFT LANGUAGE_CODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR LANGUAGE:8.5DRAFT LANGUAGE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR MESSAGE:8.5DRAFT MESSAGE_FILE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR MILESTONE:8.5DRAFT MILESTONE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR MILESTONE:8.5DRAFT MILESTONE_PATH 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT SURVEY_ANSWER_STR 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT INTERACTION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT QUESTION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT IQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT IQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT IQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT IQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT IQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT IQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT IQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT IQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT IQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT IQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT SQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT SQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT SQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT SQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT SQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT SQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT SQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT SQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT SQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT SQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT SQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT SQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT SQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT SQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S1:8.5DRAFT SQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT SQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT SQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT SQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT SQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY S2:8.5DRAFT SQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT COMPLETE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT RECORDING 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT OFFER 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
GIM:Library:Table-SDR USER INPUT:8.5DRAFT USER_INPUT_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT START_TS_MS 8.5.008 (no longer mandatory)
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT UTTERANCE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases); 8.5.008 (data type increased from 50 to 512 characters)
GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT INTERPRETATION 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases); 8.5.008 (data type increased from 50 to 512 characters)
GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT TABLE_NAME 8.5.011.14 (data type increased from 30 to 255 characters)
GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT CODE 8.5.001 (error code 26 added)
GIM:Library:Table-USER DATA CUST DIM 1:8.5DRAFT DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)

Columns discontinued

Article Column Column Discontinued
GIM:Library:Table-CALLBACK FACT:8.5DRAFT DESIRED_TIME 8.5.003 (renamed to DESIRED_TIME_TS)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT IRF_ANCHOR_DATE_TIME_KEY 8.5.003 (renamed to IRF_ANCHOR_SENT_TS)
GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT IRF_ANCHOR_SENT_TS 8.5.004 (renamed to IRF_ANCHOR_TS)
GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT RECORDING 8.5.008
Comments or questions about this documentation? Contact us for support!