| Line 1: | Line 1: | ||
= Migration Guide Prep= | = Migration Guide Prep= | ||
| + | |||
| + | |||
| + | {{#sub:{{#explode:{{{modified}}}|8.5.010|1}}|23|17}} | ||
| + | |||
| + | {{#sub:{{#explode:{{#switch:{{PONYDOCSMANUALSHORT}}|PDMMS|Library=8.5.011 (blah blah);{{Editgrn_open}}8.5.010 (data type modified in single-language databases){{Editgrn_close}}|#default=}}|8.5.010|1}}|23|21}} | ||
| + | |||
| + | {{#sub:{{#explode:{{#switch:{{PONYDOCSMANUALSHORT}}|PDMMS|Library=8.5.011 (blah blah);{{Editgrn_open}}8.5.010 (data type modified in single- and multi-language databases){{Editgrn_close}}|#default=}}|8.5.010|1}}|23|21}} | ||
| + | |||
| + | {{#sub:{{#explode:{{#switch:{{PONYDOCSMANUALSHORT}}|PDMMS|Library=8.5.011 (blah blah);{{Editgrn_open}}8.5.010 (data type modified in multi-language databases){{Editgrn_close}}|#default=}}|8.5.010|1}}|23|21}} | ||
| + | |||
| + | {{#dpl: | ||
| + | |namespace=Documentation | ||
| + | |titlematch=GIM:Library:Table-%:8.5DRAFT% | ||
| + | |includematch=/modified\s*=\s*.*8.5.010/ | ||
| + | |include={PDMColumn}.dpl8 | ||
| + | |table=,-,Column,Single-Language,Multi-Language | ||
| + | |mode=userformat | ||
| + | }} | ||
How can we use this data-driven approach to (a) streamline and (b) verify content for the Migration Guide? | How can we use this data-driven approach to (a) streamline and (b) verify content for the Migration Guide? | ||
Revision as of 22:45, April 17, 2018
Contents
Migration Guide Prep
single-language datab
single- and multi-lan
multi-language databa
| Column | Single-Language | Multi-Language |
|---|---|---|
|
[[Documentation:GIM:Library:Table-CALL TYPE:8.5DRAFT#{{{colName}}}|CALL_TYPE.{{{colName}}}]] |
||
|
USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 |
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
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
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!