Revision as of 11:26, April 26, 2018 by Jdruker (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 formatting templates, it's hard to refine the output (e.g., combine table and column info) and you can't set up a query form (e.g., customer selects "from" and "to" releases to see deltas only between that range).

This allows for {{Editgrn_open}}, <strike>, {{#switch:...}} at the start of the parameter value. Would also need to allow for change bars and maybe other parser functions (if? replace?).

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
This page was last edited on April 26, 2018, at 11:26.
Comments or questions about this documentation? Contact us for support!