Revision as of 14:33, July 6, 2018 by Jdruker (talk | contribs) (Before trying to join PDMTable in the column queries)
Jump to: navigation, search

Summary of Info Mart Schema Changes

Writer's note: From separate queries:
  • Table introduced = 63
  • Column introduced = 70
  • Column modified -- itemized = 29 (Column modified -- consolidated = 25)
  • Column discontinued = 4

Total number of entries in the combined table should be 63+70+29 + 4 = 166 NEED TO VERIFY BY DPL


The following table summarizes Genesys Info Mart schema changes between 8.x releases.

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 or column 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
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CUSTOMER_LEFT_FIRST 8.5.004 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CALLBACK_DIAL_RESULTS_KEY 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CALLBACK_DIM_4_KEY 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CUSTOMER_ANI 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CUSTOMER_READY_TO_START_IXN_TS 8.5.003 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DESIRED_TIME_TS 8.5.003 (renamed from DESIRED_TIME) Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DIAL_1_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DIAL_2_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DIAL_3_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DIAL_4_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DIAL_5_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource EWT_THRESHOLD_WHEN_OFFERED 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource EWT_WHEN_LAST_DIAL 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource EWT_WHEN_REJECTED 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource FIRST_OUT_IXN_ID 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_OUT_IXN_ID 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORIGINATION_IXN_ID 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORS_SESSION_ID 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource POS_WHEN_LAST_DIAL 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource PRIORITY_WHEN_A_CONNECTED 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource PRIORITY_WHEN_CB_ACCEPTED 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource PRIORITY_WHEN_C_CONNECTED 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource PUSH_DELIVERY_CONFIRMED_TS 8.5.003 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource SERVICE_END_TS 8.5.009.20 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource WAITED_BEFORE_OFFER_TIME 8.5.009.20 Column added
Documentation:GIM:Library:Table-CHAT SESSION DIM:8.5PDMSource ASYNC_MODE 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ACTIVE_IDLE_COUNT 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ACTIVE_IDLE_DURATION 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ASYNC_DORMANT_COUNT 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ASYNC_DORMANT_DURATION 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ASYNC_IDLE_COUNT 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource ASYNC_IDLE_DURATION 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource HANDLE_COUNT 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource HANDLE_DURATION 8.5.011.14 Column added
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5PDMSource THREAD_ID 8.5.014.09 Column added
Documentation:GIM:Library:Table-CONTACT ATTEMPT FACT:8.5PDMSource RECORD_FIELD_31 through RECORD_FIELD_60 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60) Column added
Documentation:GIM:Library:Table-CTL TRANSFORM HISTORY:8.5PDMSource AUDIT_KEY 8.5.009 Column added
Documentation:GIM:Library:Table-CTL TRANSFORM HISTORY:8.5PDMSource HWM_VALUE2 8.5.010 Column added
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource CONVERT_EXPRESSION 8.1.201 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource ADJUSTED_SCORE 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource DEFAULT_SCORE 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource DEFAULT_SCORES_COUNT 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource DEFAULT_SCORE_USED 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource FINAL_SCORE_THRESHOLD 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource GLOBAL_SCORES_COUNT 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource GPM_DIM1_KEY 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource INITIAL_SCORE_THRESHOLD 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource SUITABLE_AGENTS_COUNT 8.5.014.09 Column added
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource ANCHOR_ID 8.5.003 Column added
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource ANCHOR_SDT_KEY 8.5.003 Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ASM_COUNT 8.5.004 Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ASM_ENGAGE_DURATION 8.5.004 Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource FOCUS_TIME_COUNT 8.5.004 Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource FOCUS_TIME_DURATION 8.5.004 Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource IRF_ANCHOR_SENT_TS 8.5.003 (renamed from IRF_ANCHOR_DATE_TIME_KEY) Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource IRF_ANCHOR_TS 8.5.004 (renamed from IRF_ANCHOR_SENT_TS) Column added
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource TARGET_ADDRESS 8.5.006 Column added
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource CREATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource UPDATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5PDMSource CREATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5PDMSource GSW_CALL_TYPE 8.5.011.18 Column added
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5PDMSource SERVICE_ID 8.1.402 Column added
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5PDMSource SERVICE_START_TS 8.1.402 Column added
Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5PDMSource UPDATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-IRF USER DATA KEYS:8.5PDMSource CREATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-IRF USER DATA KEYS:8.5PDMSource UPDATE_AUDIT_KEY 8.5.001 Column added
Documentation:GIM:Library:Table-MEDIATION SEGMENT FACT:8.5PDMSource USERDATA_FLAG 8.5.004 Column added
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource FINAL_DISPOSITION 8.5.007 Column added
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource MEDIA_TYPE 8.5.008 Column added
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_I1_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_I2_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_QUESTIONS_I1_KEY 8.5.007 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_QUESTIONS_I2_KEY 8.5.007 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_QUESTIONS_S1_KEY 8.5.007 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_QUESTIONS_S2_KEY 8.5.007 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_S1_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_S2_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_SCORES_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource SDR_SURVEY_STATUS_KEY 8.5.005 Column added
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5PDMSource OFFER 8.5.007 Column added
Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5PDMSource UPDATE_AUDIT_KEY 8.5.010.16 Column added
Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5PDMSource CREATE_AUDIT_KEY 8.5.003 Column added
Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5PDMSource END_DATE_TIME_KEY 8.5.013.06 Column added
Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5PDMSource RESOURCE_GROUP_COMBINATION_KEY 8.5.013.06 Column added
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DESIRED_TIME 8.5.003 (renamed to DESIRED_TIME_TS) Column discontinued
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource IRF_ANCHOR_DATE_TIME_KEY 8.5.003 (renamed to IRF_ANCHOR_SENT_TS) Column discontinued
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource IRF_ANCHOR_SENT_TS 8.5.004 (renamed to IRF_ANCHOR_TS) Column discontinued
Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5PDMSource RECORDING 8.5.008 Column discontinued
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_OFFER_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CHANNEL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CONNECT_ORDER 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource CALL_DIRECTION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource DIAL_DIALOG_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource FINAL_DIAL_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource OFFER_TIMING 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource FINAL_TARGET 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DS_AUDIT_KEY 8.5.008 Column modified (data type increased from 10 to 19 digits)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource FIRST_OUT_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_CALLBACK_OFFERED_TS 8.5.008 Column modified (default value added)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_OUT_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORIGINATION_IXN_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORS_SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource PAGE_QUERY 8.5.012.15 Column modified (No longer a mandatory field)
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource PROPAGATION_RULE 8.5.001 Column modified (IRF_INITIAL value is added).
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource PROPAGATION_RULE 8.5.006 Column modified (IRF_ROUTE value is added)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MEDIA_SERVER_IXN_GUID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MESSAGE 8.5.009.20 Column modified (default value no longer defined)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource START_DATE_TIME_KEY 8.5.011 Column modified (added to the composite primary key in nonpartitioned databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR_ID 8.5.010 Column modified (in Microsoft SQL Server,data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource CUSTOMER_FOUND 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_MODE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_STATUS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_USE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource BUSINESS_RESULT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource CUSTOMER_SEGMENT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_SUBTYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource STATUS 8.5.001 Column modified (error code 26 added)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource SUBJECT 8.5.007 Column modified (data type extended from 255 to 1024 characters)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ANCHOR_FLAGS_KEY 8.5.004 Column modified (scope extended)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_INIT_TALK_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_DURATION 8.5.001 Column modified (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_COUNT 8.5.001 Column modified (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_DURATION 8.5.001 Column modified (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource LAST_INTERACTION_RESOURCE 8.5.003 and 8.5.004 Column modified (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource QUEUE_DURATION 8.1.2, 8.1.3, 8.1.4 Column modified (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ROUTING_POINT_DURATION 8.1.2, 8.1.3, 8.1.4 Column modified (behavior changed)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE 8.5.001 Column modified (InternalConferenceInvite subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE 8.5.005 Column modified (OutboundCallback subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE_CODE 8.5.001 Column modified (INTERNALCONFERENCEINVITE subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE_CODE 8.5.005 Column modified (OUTBOUNDCALLBACK subtype added)
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource 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).
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource 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)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IAGENTSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICALLSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICOMPANYSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IPRODUCTSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ1 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ2 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ3 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ4 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ5 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ6 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ10 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ7 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ8 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ9 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_COMPLETE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_IRECOMMENDSCORE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_RECORDING 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource RESOURCE_SUBTYPE 8.5.003.17 Column modified (new value, Person, added for the Agent resource type)
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource SESSION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_ID 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_TITLE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_VERSION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_CATEGORY 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource FINAL_DISPOSITION 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource CALL_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource MEDIA_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource ATRIBUTE_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource DNIS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource APPLICATION_EXIT_POINT 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource URL 8.5.008.29 Column modified (behavior changed)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource URL 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource SUCCESS 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource METHOD 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_TYPE 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource SERVICE_NAME 8.5.010 Column modified (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource 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!