Revision as of 14:38, July 10, 2018 by Jdruker (talk | contribs)
Jump to: navigation, search

Summary of Info Mart Schema Changes

Writer's note: From separate Cargo queries (see User:Jdruker/CargoQueriesForPDMs:
  • Old PDMColumn table:
    • Table introduced = 63
    • Column introduced = 71
    • Column modified -- itemized = 35 (Column modified -- consolidated = 31 vs. 150 per DPL)
    • Column discontinued = 4
  • Re-created PDMColumn table (after a couple of manual resaves):
    • Table introduced = 63
    • Column introduced = 71
    • Column modified -- itemized = 32 (Column modified -- consolidated = 28 vs. 150 per DPL)
    • Column discontinued = 4

When the old PDMColumn table was active, the total number of entries in the following combined table was arithmetically correct at 63+71+ 35 + 4 = 173, so the query was validated. The current combo query results are not complete. Per DPL, the modified columns numbers should be very much higher. Need to manually resave pages to refresh the Cargo table.

To do:

  • Probably not worth tweaking the template now to Include Views, but put something somewhere to prompt an update if deltas for views occur in the future.
  • Add to wish list: Put a form on the page to allow users to generate a filtered list based on a starting and ending version they choose.


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
CDR_DIM1 8.5.013.06 Table added
CDR_FACT 8.5.013.06 Table added
CHAT_SESSION_DIM 8.5.011 Table added
CHAT_SESSION_FACT 8.5.011 Table added
CHAT_THREAD_FACT 8.5.014.09 Table added
COBROWSE_END_REASON 8.5.011.14 Table added
COBROWSE_FACT 8.5.011.14 Table added
COBROWSE_MODE 8.5.011.14 Table added
COBROWSE_PAGE 8.5.011.14 Table added
COBROWSE_USER_AGENT 8.5.011.14 Table added
CTL_GDPR_HISTORY 8.5.010 Table added
GPM_DIM1 8.5.014.09 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
LDR_CAMPAIGN 8.5.012.15 Table added
LDR_DEVICE 8.5.012.15 Table added
LDR_FACT 8.5.012.15 Table added
LDR_GROUP 8.5.012.15 Table added
LDR_LIST 8.5.012.15 Table added
LDR_POSTAL_CODE 8.5.012.15 Table added
LDR_RECORD 8.5.012.15 Table added
MEDIA_ORIGIN 8.5.014.09 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 Engage cloud deployments only. Table added
SDR_ACTIVITY 8.5.007. Supported in Genesys Engage cloud deployments only. Table added
SDR_APPLICATION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_CALL_DISPOSITION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_CALL_TYPE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_CUST_ATRIBUTES 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_CUST_ATRIBUTES_FACT 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_ENTRY_POINT 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXIT_POINT 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXT_HTTP_REST 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXT_REQUEST 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXT_REQUEST_FACT 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXT_REQUEST_OUTCOME 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added
SDR_EXT_SERVICE_OUTCOME 8.5.004. Supported in Genesys Engage cloud deployments only. Table added
SDR_GEO_LOCATION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_INPUT 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added
SDR_INPUT_OUTCOME 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added
SDR_LANGUAGE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_MESSAGE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_MILESTONE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added
SDR_SESSION_FACT 8.5.001 Table added
SDR_SURVEY_ANSWERS 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_FACT 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_I1 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_I2 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_QUESTIONS 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_I1 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_I2 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_S1 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_QUESTIONS_S2 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_S1 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_S2 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_SCORES 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_STATUS 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added
SDR_SURVEY_TRANSCRIPT_FACT 8.5.005.20. Supported in certain Genesys Engage 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 Engage 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
CHAT_SESSION_DIM ASYNC_MODE 8.5.011.14 Column added
CHAT_SESSION_FACT ACTIVE_IDLE_COUNT 8.5.011.14 Column added
CHAT_SESSION_FACT ACTIVE_IDLE_DURATION 8.5.011.14 Column added
CHAT_SESSION_FACT ASYNC_DORMANT_COUNT 8.5.011.14 Column added
CHAT_SESSION_FACT ASYNC_DORMANT_DURATION 8.5.011.14 Column added
CHAT_SESSION_FACT ASYNC_IDLE_COUNT 8.5.011.14 Column added
CHAT_SESSION_FACT ASYNC_IDLE_DURATION 8.5.011.14 Column added
CHAT_SESSION_FACT HANDLE_COUNT 8.5.011.14 Column added
CHAT_SESSION_FACT HANDLE_DURATION 8.5.011.14 Column added
CHAT_SESSION_FACT THREAD_ID 8.5.014.09 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 ADJUSTED_SCORE 8.5.014.09 Column added
GPM_FACT DEFAULT_SCORE 8.5.014.09 Column added
GPM_FACT DEFAULT_SCORES_COUNT 8.5.014.09 Column added
GPM_FACT DEFAULT_SCORE_USED 8.5.014.09 Column added
GPM_FACT FINAL_SCORE_THRESHOLD 8.5.014.09 Column added
GPM_FACT GLOBAL_SCORES_COUNT 8.5.014.09 Column added
GPM_FACT GPM_DIM1_KEY 8.5.014.09 Column added
GPM_FACT INITIAL_SCORE_THRESHOLD 8.5.014.09 Column added
GPM_FACT SUITABLE_AGENTS_COUNT 8.5.014.09 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 GSW_CALL_TYPE 8.5.011.18 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
SM_MEDIA_NEUTRAL_STATE_FACT END_DATE_TIME_KEY 8.5.013.06 Column added
SM_MEDIA_NEUTRAL_STATE_FACT RESOURCE_GROUP_COMBINATION_KEY 8.5.013.06 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)
COBROWSE_FACT PAGE_QUERY 8.5.012.15 Column modified (No longer a mandatory field)
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)
Comments or questions about this documentation? Contact us for support!