Jump to: navigation, search

Summary of Info Mart Schema Changes

The following table summarizes Genesys Info Mart schema changes between 8.x releases, for all supported RDBMS types. Some of the changes listed might not apply to the RDBMS you use.

Tip
Type in the Search box to quickly filter the table by release, table name, type of change, and so on. Alternatively, click a column header to sort the table to group entries. Click the table name in an entry to link to a full description of the table.


Table Column Changed in release Type of change
Table Column Changed in release Type of change
BGS_BOT_DIM 8.5.011 Table added
BGS_BOT_NAME_DIM 8.5.011 Table added
BGS_SESSION_DIM 8.5.011 Table added
BGS_SESSION_FACT 8.5.011 Table added
CALLBACK_DIAL_RESULTS 8.5.009.20 Table added
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added
CALLBACK_DIM_4 8.5.009.20 Table added
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added
CHAT_SESSION_DIM 8.5.011 Table added
CHAT_SESSION_FACT 8.5.011 Table added
CTL_GDPR_HISTORY 8.5.010 Table added
GPM_FACT 8.5.009 Table added
GPM_MODEL 8.5.009 Table added
GPM_PREDICTOR 8.5.009 Table added
GPM_RESULT 8.5.009 Table added
GROUP_ANNEX 8.1.4 Table added
POST_CALL_SURVEY_DIM_1 8.5.003. Supported in certain deployments only. Table added
POST_CALL_SURVEY_DIM_2 8.5.003. Supported in certain deployments only. Table added
POST_CALL_SURVEY_DIM_3 8.5.003. Supported in certain deployments only. Table added
POST_CALL_SURVEY_DIM_4 8.5.003. Supported in certain deployments only. Table added
POST_CALL_SURVEY_DIM_5 8.5.003. Supported in certain deployments only. Table added
POST_CALL_SURVEY_DIM_6 8.5.003. Supported in certain deployments only. Table added
SDR_ACTIVITIES_FACT 8.5.007. Supported in Genesys Cloud deployments only. Table added
SDR_ACTIVITY 8.5.007. Supported in Genesys Cloud deployments only. Table added
SDR_APPLICATION 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_CALL_DISPOSITION 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_CALL_TYPE 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_CUST_ATRIBUTES 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_CUST_ATRIBUTES_FACT 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_ENTRY_POINT 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_EXIT_POINT 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_EXT_HTTP_REST 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_EXT_REQUEST 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_EXT_REQUEST_FACT 8.5.004.09. Supported in Genesys Cloud deployments only. Table added
SDR_EXT_REQUEST_OUTCOME 8.5.004.09. Supported in Genesys Cloud deployments only. Table added
SDR_EXT_SERVICE_OUTCOME 8.5.004. Supported in Genesys Cloud deployments only. Table added
SDR_GEO_LOCATION 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_INPUT 8.5.004.09. Supported in Genesys Cloud deployments only. Table added
SDR_INPUT_OUTCOME 8.5.004.09. Supported in Genesys Cloud deployments only. Table added
SDR_LANGUAGE 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_MESSAGE 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_MILESTONE 8.5.001. Supported in Genesys Cloud deployments only. Table added
SDR_SESSION_FACT 8.5.001 Table added
SDR_SURVEY_ANSWERS 8.5.008.29. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_FACT 8.5.008.29. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_I1 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_I2 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_QUESTIONS 8.5.008.29. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_I1 8.5.007. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_I2 8.5.007. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_S1 8.5.007. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_S2 8.5.007. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_S1 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_S2 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_SCORES 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_STATUS 8.5.005. Supported in certain Genesys Cloud deployments only. Table added
SDR_SURVEY_TRANSCRIPT_FACT 8.5.005.20. Supported in certain Genesys Cloud deployments only. Table added
SDR_USER_INPUT 8.5.004.09 Table added
SDR_USER_INPUTS_FACT 8.5.004.09 Table added
SDR_USER_MILESTONE_FACT 8.5.001. Supported in Genesys Cloud deployments only. Table added
SM_MEDIA_NEUTRAL_STATE_FACT 8.5.002 Table added
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004 Column added
CALLBACK_FACT CALLBACK_DIAL_RESULTS_KEY 8.5.009.20 Column added
CALLBACK_FACT CALLBACK_DIM_4_KEY 8.5.009.20 Column added
CALLBACK_FACT CUSTOMER_ANI 8.5.009.20 Column added
CALLBACK_FACT CUSTOMER_READY_TO_START_IXN_TS 8.5.003 Column added
CALLBACK_FACT DESIRED_TIME_TS 8.5.003 (renamed from DESIRED_TIME) Column added
CALLBACK_FACT DIAL_1_TS 8.5.009.20 Column added
CALLBACK_FACT DIAL_2_TS 8.5.009.20 Column added
CALLBACK_FACT DIAL_3_TS 8.5.009.20 Column added
CALLBACK_FACT DIAL_4_TS 8.5.009.20 Column added
CALLBACK_FACT DIAL_5_TS 8.5.009.20 Column added
CALLBACK_FACT EWT_THRESHOLD_WHEN_OFFERED 8.5.009.20 Column added
CALLBACK_FACT EWT_WHEN_LAST_DIAL 8.5.009.20 Column added
CALLBACK_FACT EWT_WHEN_REJECTED 8.5.009.20 Column added
CALLBACK_FACT FIRST_OUT_IXN_ID 8.5.009.20 Column added
CALLBACK_FACT LAST_OUT_IXN_ID 8.5.009.20 Column added
CALLBACK_FACT ORIGINATION_IXN_ID 8.5.009.20 Column added
CALLBACK_FACT ORS_SESSION_ID 8.5.009.20 Column added
CALLBACK_FACT POS_WHEN_LAST_DIAL 8.5.009.20 Column added
CALLBACK_FACT PRIORITY_WHEN_A_CONNECTED 8.5.009.20 Column added
CALLBACK_FACT PRIORITY_WHEN_CB_ACCEPTED 8.5.009.20 Column added
CALLBACK_FACT PRIORITY_WHEN_C_CONNECTED 8.5.009.20 Column added
CALLBACK_FACT PUSH_DELIVERY_CONFIRMED_TS 8.5.003 Column added
CALLBACK_FACT SERVICE_END_TS 8.5.009.20 Column added
CALLBACK_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
CALLBACK_FACT WAITED_BEFORE_OFFER_TIME 8.5.009.20 Column added
CONTACT_ATTEMPT_FACT RECORD_FIELD_31 through RECORD_FIELD_60 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60) Column added
CTL_TRANSFORM_HISTORY AUDIT_KEY 8.5.009 Column added
CTL_TRANSFORM_HISTORY HWM_VALUE2 8.5.010 Column added
CTL_UD_TO_UDE_MAPPING CONVERT_EXPRESSION 8.1.201 Column added
GPM_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
INTERACTION_FACT ANCHOR_ID 8.5.003 Column added
INTERACTION_FACT ANCHOR_SDT_KEY 8.5.003 Column added
INTERACTION_RESOURCE_FACT ASM_COUNT 8.5.004 Column added
INTERACTION_RESOURCE_FACT ASM_ENGAGE_DURATION 8.5.004 Column added
INTERACTION_RESOURCE_FACT FOCUS_TIME_COUNT 8.5.004 Column added
INTERACTION_RESOURCE_FACT FOCUS_TIME_DURATION 8.5.004 Column added
INTERACTION_RESOURCE_FACT IRF_ANCHOR_SENT_TS 8.5.003 (renamed from IRF_ANCHOR_DATE_TIME_KEY) Column added
INTERACTION_RESOURCE_FACT IRF_ANCHOR_TS 8.5.004 (renamed from IRF_ANCHOR_SENT_TS) Column added
INTERACTION_RESOURCE_FACT TARGET_ADDRESS 8.5.006 Column added
IRF_USER_DATA_CUST_1 CREATE_AUDIT_KEY 8.5.001 Column added
IRF_USER_DATA_CUST_1 UPDATE_AUDIT_KEY 8.5.001 Column added
IRF_USER_DATA_GEN_1 CREATE_AUDIT_KEY 8.5.001 Column added
IRF_USER_DATA_GEN_1 SERVICE_ID 8.1.402 Column added
IRF_USER_DATA_GEN_1 SERVICE_START_TS 8.1.402 Column added
IRF_USER_DATA_GEN_1 UPDATE_AUDIT_KEY 8.5.001 Column added
IRF_USER_DATA_KEYS CREATE_AUDIT_KEY 8.5.001 Column added
IRF_USER_DATA_KEYS UPDATE_AUDIT_KEY 8.5.001 Column added
MEDIATION_SEGMENT_FACT USERDATA_FLAG 8.5.004 Column added
SDR_ACTIVITIES_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_CALL_DISPOSITION FINAL_DISPOSITION 8.5.007 Column added
SDR_CALL_TYPE MEDIA_TYPE 8.5.008 Column added
SDR_CUST_ATRIBUTES_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_EXT_REQUEST_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_SESSION_FACT SDR_SURVEY_I1_KEY 8.5.005 Column added
SDR_SESSION_FACT SDR_SURVEY_I2_KEY 8.5.005 Column added
SDR_SESSION_FACT SDR_SURVEY_QUESTIONS_I1_KEY 8.5.007 Column added
SDR_SESSION_FACT SDR_SURVEY_QUESTIONS_I2_KEY 8.5.007 Column added
SDR_SESSION_FACT SDR_SURVEY_QUESTIONS_S1_KEY 8.5.007 Column added
SDR_SESSION_FACT SDR_SURVEY_QUESTIONS_S2_KEY 8.5.007 Column added
SDR_SESSION_FACT SDR_SURVEY_S1_KEY 8.5.005 Column added
SDR_SESSION_FACT SDR_SURVEY_S2_KEY 8.5.005 Column added
SDR_SESSION_FACT SDR_SURVEY_SCORES_KEY 8.5.005 Column added
SDR_SESSION_FACT SDR_SURVEY_STATUS_KEY 8.5.005 Column added
SDR_SESSION_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_SURVEY_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_SURVEY_STATUS OFFER 8.5.007 Column added
SDR_SURVEY_TRANSCRIPT_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_USER_INPUTS_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SDR_USER_MILESTONE_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added
SM_MEDIA_NEUTRAL_STATE_FACT CREATE_AUDIT_KEY 8.5.003 Column added
CALLBACK_FACT DESIRED_TIME 8.5.003 (renamed to DESIRED_TIME_TS) Column discontinued
INTERACTION_RESOURCE_FACT IRF_ANCHOR_DATE_TIME_KEY 8.5.003 (renamed to IRF_ANCHOR_SENT_TS) Column discontinued
INTERACTION_RESOURCE_FACT IRF_ANCHOR_SENT_TS 8.5.004 (renamed to IRF_ANCHOR_TS) Column discontinued
SDR_SURVEY_STATUS RECORDING 8.5.008 Column discontinued
CALLBACK_DIM_1 CALLBACK_OFFER_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_1 CALLBACK_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_1 CHANNEL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_1 CONNECT_ORDER 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_2 CALL_DIRECTION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_2 DIAL_DIALOG_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_2 FINAL_DIAL_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_2 OFFER_TIMING 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_DIM_3 FINAL_TARGET 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_FACT DS_AUDIT_KEY 8.5.008 Column modified (data type increased from 10 to 19 digits)
CALLBACK_FACT FIRST_OUT_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_FACT LAST_CALLBACK_OFFERED_TS 8.5.008 Column modified (default value added)
CALLBACK_FACT LAST_OUT_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_FACT ORIGINATION_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CALLBACK_FACT ORS_SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
CTL_UD_TO_UDE_MAPPING PROPAGATION_RULE 8.5.001 Column modified (IRF_INITIAL value is added).
CTL_UD_TO_UDE_MAPPING PROPAGATION_RULE 8.5.006 Column modified (IRF_ROUTE value is added)
GPM_FACT MEDIA_SERVER_IXN_GUID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
GPM_FACT MESSAGE 8.5.009.20 Column modified (default value no longer defined)
GPM_FACT START_DATE_TIME_KEY 8.5.011 Column modified (added to the composite primary key in nonpartitioned databases)
GPM_MODEL MODEL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_MODEL MODEL_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_PREDICTOR PREDICTOR 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_PREDICTOR PREDICTOR_ID 8.5.010 Column modified (in Microsoft SQL Server,data type modified in single-language databases)
GPM_RESULT CUSTOMER_FOUND 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_RESULT GPM_MODE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_RESULT GPM_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_RESULT GPM_STATUS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
GPM_RESULT GPM_USE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
INTERACTION_DESCRIPTOR BUSINESS_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
INTERACTION_DESCRIPTOR CUSTOMER_SEGMENT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
INTERACTION_DESCRIPTOR SERVICE_SUBTYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
INTERACTION_DESCRIPTOR SERVICE_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
INTERACTION_FACT STATUS 8.5.001 Column modified (error code 26 added)
INTERACTION_FACT SUBJECT 8.5.007 Column modified (data type extended from 255 to 1024 characters)
INTERACTION_RESOURCE_FACT ANCHOR_FLAGS_KEY 8.5.004 Column modified (scope extended)
INTERACTION_RESOURCE_FACT CONS_INIT_TALK_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
INTERACTION_RESOURCE_FACT CONS_RCV_RING_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
INTERACTION_RESOURCE_FACT CONS_RCV_RING_DURATION 8.5.001 Column modified (scope expanded to include chat consultations)
INTERACTION_RESOURCE_FACT CONS_RCV_TALK_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
INTERACTION_RESOURCE_FACT CONS_RCV_TALK_DURATION 8.5.001 Column modified (scope expanded to include chat consultations)
INTERACTION_RESOURCE_FACT LAST_INTERACTION_RESOURCE 8.5.003 and 8.5.004 Column modified (behavior changed)
INTERACTION_RESOURCE_FACT QUEUE_DURATION 8.1.2, 8.1.3, 8.1.4 Column modified (behavior changed)
INTERACTION_RESOURCE_FACT ROUTING_POINT_DURATION 8.1.2, 8.1.3, 8.1.4 Column modified (behavior changed)
INTERACTION_TYPE INTERACTION_SUBTYPE 8.5.001 Column modified (InternalConferenceInvite subtype added)
INTERACTION_TYPE INTERACTION_SUBTYPE 8.5.005 Column modified (OutboundCallback subtype added)
INTERACTION_TYPE INTERACTION_SUBTYPE_CODE 8.5.001 Column modified (INTERNALCONFERENCEINVITE subtype added)
INTERACTION_TYPE INTERACTION_SUBTYPE_CODE 8.5.005 Column modified (OUTBOUNDCALLBACK subtype added)
IRF_USER_DATA_CUST_1 CUSTOM_DATA_1 through CUSTOM_DATA_16 8.5.005.09 Column modified (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).
IRF_USER_DATA_CUST_1 CUSTOM_DATA_1 through CUSTOM_DATA_16 8.5.007 Column modified (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)
POST_CALL_SURVEY_DIM_1 SURVEY_IAGENTSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_1 SURVEY_ICALLSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_1 SURVEY_ICOMPANYSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_1 SURVEY_IPRODUCTSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_1 SURVEY_IQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_2 SURVEY_IQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_2 SURVEY_IQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_2 SURVEY_IQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_2 SURVEY_SQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_2 SURVEY_SQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_4 SURVEY_IQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_4 SURVEY_IQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
POST_CALL_SURVEY_DIM_5 SURVEY_IQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_5 SURVEY_IQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_5 SURVEY_IQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_5 SURVEY_IQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_6 SURVEY_COMPLETE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_6 SURVEY_IRECOMMENDSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
POST_CALL_SURVEY_DIM_6 SURVEY_RECORDING 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
RESOURCE_ RESOURCE_SUBTYPE 8.5.003.17 Column modified (new value, Person, added for the Agent resource type)
SDR_ACTIVITIES_FACT SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
SDR_ACTIVITY NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_APPLICATION APPLICATION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_APPLICATION APPLICATION_TITLE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_APPLICATION APPLICATION_VERSION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_CALL_DISPOSITION DISPOSITION_CATEGORY 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_CALL_DISPOSITION DISPOSITION_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_CALL_DISPOSITION FINAL_DISPOSITION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_CALL_TYPE CALL_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_CALL_TYPE MEDIA_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_CUST_ATRIBUTES ATRIBUTE_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_ENTRY_POINT DNIS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXIT_POINT APPLICATION_EXIT_POINT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_HTTP_REST URL 8.5.008.29 Column modified (behavior changed)
SDR_EXT_HTTP_REST URL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_REQUEST METHOD 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_REQUEST REQUEST_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_REQUEST REQUEST_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_REQUEST_OUTCOME SUCCESS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_EXT_SERVICE_OUTCOME SERVICE_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_EXT_SERVICE_OUTCOME SERVICE_RESPONSE_DESC 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_GEO_LOCATION COUNTRY_CODE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_GEO_LOCATION COUNTRY_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_GEO_LOCATION REGION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_GEO_LOCATION TIMEZONE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_INPUT INPUT_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_INPUT INPUT_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_INPUT_OUTCOME SELECTED_OPTION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_INPUT_OUTCOME STRIKEOUT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_INPUT_OUTCOME SUCCESS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_LANGUAGE LANGUAGE_CODE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_LANGUAGE LANGUAGE_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_MESSAGE MESSAGE_FILE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_MILESTONE MILESTONE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_MILESTONE MILESTONE_PATH 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_ANSWERS SURVEY_ANSWER_STR 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_SURVEY_FACT INTERACTION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
SDR_SURVEY_FACT SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
SDR_SURVEY_QUESTIONS QUESTION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_SURVEY_QUESTIONS_I1 IQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I1 IQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I1 IQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I1 IQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I1 IQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I2 IQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I2 IQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I2 IQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I2 IQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_I2 IQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S1 SQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S1 SQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S1 SQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S1 SQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S1 SQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S2 SQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S2 SQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S2 SQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S2 SQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_QUESTIONS_S2 SQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S1 SQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S1 SQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S1 SQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S1 SQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S1 SQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S2 SQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S2 SQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S2 SQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S2 SQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_S2 SQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
SDR_SURVEY_STATUS COMPLETE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_SURVEY_STATUS OFFER 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_SURVEY_STATUS RECORDING 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_SURVEY_TRANSCRIPT_FACT SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
SDR_USER_INPUT USER_INPUT_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
SDR_USER_INPUTS_FACT INTERPRETATION 8.5.008 Column modified (data type increased from 50 to 512 characters)
SDR_USER_INPUTS_FACT INTERPRETATION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
SDR_USER_INPUTS_FACT START_TS_MS 8.5.008 Column modified (no longer mandatory)
SDR_USER_INPUTS_FACT UTTERANCE 8.5.008 Column modified (data type increased from 50 to 512 characters)
SDR_USER_INPUTS_FACT UTTERANCE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
STG_TRANSFORM_DISCARDS CODE 8.5.001 Column modified (error code 26 added)
USER_DATA_CUST_DIM_1 DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
ATTEMPT_DISPOSITION Various columns 8.5.003 Column modified (In Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CALL_RESULT Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CAMPAIGN_GROUP_SESSION_FACT Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CAMPAIGN_GROUP_STATE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CAMPAIGN_GROUP_STATE_FACT Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CONTACT_ATTEMPT_FACT Various columns in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CONTACT_INFO_TYPE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_AUDIT_LOG Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_ETL_HISTORY Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_EXTRACT_HISTORY Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_PURGE_HISTORY Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_TRANSFORM_HISTORY Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_UDE_KEYS_TO_DIM_MAPPING Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
CTL_UD_TO_UDE_MAPPING Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
DATE_TIME Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
DIALING_MODE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
GROUP_ANNEX Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
INTERACTION_DESCRIPTOR Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
INTERACTION_FACT Various columns in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
INTERACTION_RESOURCE_FACT Various columns in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
INTERACTION_RESOURCE_STATE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
INTERACTION_TYPE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
IRF_USER_DATA_CUST_1 Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
IRF_USER_DATA_GEN_1 Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
MEDIATION_SEGMENT_FACT Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
MEDIA_TYPE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RECORD_FIELD_GROUP_1 Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RECORD_FIELD_GROUP_2 Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RECORD_STATUS Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RECORD_TYPE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
REQUESTED_SKILL_COMBINATION Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RESOURCE_ Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RESOURCE_ANNEX Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RESOURCE_STATE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
RESOURCE_STATE_REASON Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
ROUTING_TARGET Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
SDR_APPLICATION Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
STG_IDB_FK_VIOLATION Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
STG_TRANSFORM_DISCARDS Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
STRATEGY Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
TECHNICAL_DESCRIPTOR Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
TIME_ZONE Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
USER_DATA_CUST_DIM_1 Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)
WORKBIN Various columns 8.5.003 Column modified (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 18 July 2018, at 13:42.