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.

Important
Starting with release 8.5.014.14 on August 30, 2019, Genesys Info Mart is part of 9.0. This document is valid only for the 8.5 releases of this product before Genesys Info Mart was part of 9.0. For 8.5 releases of Genesys Info Mart after August 30, 2019, see the Current version of this document.
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.


TableColumnChanged in releaseType of changeMore information
TableColumnChanged in releaseType of changeMore information
BGS_BOT_DIM 8.5.011 Table added See table
BGS_BOT_NAME_DIM 8.5.011 Table added See table
BGS_SESSION_DIM 8.5.011 Table added See table
BGS_SESSION_FACT 8.5.011 Table added See table
CALLBACK_DIAL_RESULTS 8.5.009.20 Table added See table
CALLBACK_DIM_1 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added See table
CALLBACK_DIM_2 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added See table
CALLBACK_DIM_3 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added See table
CALLBACK_DIM_4 8.5.009.20 Table added See table
CALLBACK_FACT 8.1.402. Supported for on-premises deployments starting with release 8.5.005. Table added See table
CDR_DIM1 8.5.013.06 Table added See table
CDR_FACT 8.5.013.06 Table added See table
CHAT_SESSION_DIM 8.5.011 Table added See table
CHAT_SESSION_FACT 8.5.011 Table added See table
CHAT_THREAD_FACT 8.5.014.09 Table added See table
COBROWSE_END_REASON 8.5.011.14 Table added See table
COBROWSE_FACT 8.5.011.14 Table added See table
COBROWSE_MODE 8.5.011.14 Table added See table
COBROWSE_PAGE 8.5.011.14 Table added See table
COBROWSE_USER_AGENT 8.5.011.14 Table added See table
CTL_GDPR_HISTORY 8.5.010 Table added See table
GPM_DIM1 8.5.014.09 Table added See table
GPM_FACT 8.5.009 Table added See table
GPM_MODEL 8.5.009 Table added See table
GPM_PREDICTOR 8.5.009 Table added See table
GPM_RESULT 8.5.009 Table added See table
GROUP_ANNEX 8.1.4 Table added See table
LDR_CAMPAIGN 8.5.012.15 Table added See table
LDR_DEVICE 8.5.012.15 Table added See table
LDR_FACT 8.5.012.15 Table added See table
LDR_GROUP 8.5.012.15 Table added See table
LDR_LIST 8.5.012.15 Table added See table
LDR_POSTAL_CODE 8.5.012.15 Table added See table
LDR_RECORD 8.5.012.15 Table added See table
MEDIA_ORIGIN 8.5.014.09 Table added See table
POST_CALL_SURVEY_DIM_1 8.5.003. Supported in certain deployments only. Table added See table
POST_CALL_SURVEY_DIM_2 8.5.003. Supported in certain deployments only. Table added See table
POST_CALL_SURVEY_DIM_3 8.5.003. Supported in certain deployments only. Table added See table
POST_CALL_SURVEY_DIM_4 8.5.003. Supported in certain deployments only. Table added See table
POST_CALL_SURVEY_DIM_5 8.5.003. Supported in certain deployments only. Table added See table
POST_CALL_SURVEY_DIM_6 8.5.003. Supported in certain deployments only. Table added See table
SDR_ACTIVITIES_FACT 8.5.007. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_ACTIVITY 8.5.007. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_APPLICATION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_CALL_DISPOSITION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_CALL_TYPE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_CUST_ATRIBUTES 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_CUST_ATRIBUTES_FACT 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_ENTRY_POINT 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXIT_POINT 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXT_HTTP_REST 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXT_REQUEST 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXT_REQUEST_FACT 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXT_REQUEST_OUTCOME 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_EXT_SERVICE_OUTCOME 8.5.004. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_GEO_LOCATION 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_INPUT 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_INPUT_OUTCOME 8.5.004.09. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_LANGUAGE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_MESSAGE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_MILESTONE 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SDR_SESSION_FACT 8.5.001 Table added See table
SDR_SURVEY_ANSWERS 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_FACT 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_I1 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_I2 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_QUESTIONS 8.5.008.29. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_QUESTIONS_I1 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_QUESTIONS_I2 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_QUESTIONS_S1 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_QUESTIONS_S2 8.5.007. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_S1 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_S2 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_SCORES 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_STATUS 8.5.005. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_SURVEY_TRANSCRIPT_FACT 8.5.005.20. Supported in certain Genesys Engage cloud deployments only. Table added See table
SDR_USER_INPUT 8.5.004.09 Table added See table
SDR_USER_INPUTS_FACT 8.5.004.09 Table added See table
SDR_USER_MILESTONE_FACT 8.5.001. Supported in Genesys Engage cloud deployments only. Table added See table
SM_MEDIA_NEUTRAL_STATE_FACT 8.5.002 Table added See table
ANCHOR_FLAGS CUSTOMER_LEFT_FIRST 8.5.004 Column added See table
CALLBACK_FACT CALLBACK_DIAL_RESULTS_KEY 8.5.009.20 Column added See table
CALLBACK_FACT CALLBACK_DIM_4_KEY 8.5.009.20 Column added See table
CALLBACK_FACT CUSTOMER_ANI 8.5.009.20 Column added See table
CALLBACK_FACT CUSTOMER_READY_TO_START_IXN_TS 8.5.003 Column added See table
CALLBACK_FACT DESIRED_TIME_TS 8.5.003 (renamed from DESIRED_TIME) Column added See table
CALLBACK_FACT DIAL_1_TS 8.5.009.20 Column added See table
CALLBACK_FACT DIAL_2_TS 8.5.009.20 Column added See table
CALLBACK_FACT DIAL_3_TS 8.5.009.20 Column added See table
CALLBACK_FACT DIAL_4_TS 8.5.009.20 Column added See table
CALLBACK_FACT DIAL_5_TS 8.5.009.20 Column added See table
CALLBACK_FACT EWT_THRESHOLD_WHEN_OFFERED 8.5.009.20 Column added See table
CALLBACK_FACT EWT_WHEN_LAST_DIAL 8.5.009.20 Column added See table
CALLBACK_FACT EWT_WHEN_REJECTED 8.5.009.20 Column added See table
CALLBACK_FACT FIRST_OUT_IXN_ID 8.5.009.20 Column added See table
CALLBACK_FACT LAST_OUT_IXN_ID 8.5.009.20 Column added See table
CALLBACK_FACT ORIGINATION_IXN_ID 8.5.009.20 Column added See table
CALLBACK_FACT ORS_SESSION_ID 8.5.009.20 Column added See table
CALLBACK_FACT POS_WHEN_LAST_DIAL 8.5.009.20 Column added See table
CALLBACK_FACT PRIORITY_WHEN_A_CONNECTED 8.5.009.20 Column added See table
CALLBACK_FACT PRIORITY_WHEN_CB_ACCEPTED 8.5.009.20 Column added See table
CALLBACK_FACT PRIORITY_WHEN_C_CONNECTED 8.5.009.20 Column added See table
CALLBACK_FACT PUSH_DELIVERY_CONFIRMED_TS 8.5.003 Column added See table
CALLBACK_FACT SERVICE_END_TS 8.5.009.20 Column added See table
CALLBACK_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added See table
CALLBACK_FACT WAITED_BEFORE_OFFER_TIME 8.5.009.20 Column added See table
CHAT_SESSION_DIM ASYNC_MODE 8.5.011.14 Column added See table
CHAT_SESSION_FACT ACTIVE_IDLE_COUNT 8.5.011.14 Column added See table
CHAT_SESSION_FACT ACTIVE_IDLE_DURATION 8.5.011.14 Column added See table
CHAT_SESSION_FACT ASYNC_DORMANT_COUNT 8.5.011.14 Column added See table
CHAT_SESSION_FACT ASYNC_DORMANT_DURATION 8.5.011.14 Column added See table
CHAT_SESSION_FACT ASYNC_IDLE_COUNT 8.5.011.14 Column added See table
CHAT_SESSION_FACT ASYNC_IDLE_DURATION 8.5.011.14 Column added See table
CHAT_SESSION_FACT HANDLE_COUNT 8.5.011.14 Column added See table
CHAT_SESSION_FACT HANDLE_DURATION 8.5.011.14 Column added See table
CHAT_SESSION_FACT THREAD_ID 8.5.014.09 Column added See table
CONTACT_ATTEMPT_FACT RECORD_FIELD_31 through RECORD_FIELD_60 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60) Column added See table
CTL_TRANSFORM_HISTORY AUDIT_KEY 8.5.009 Column added See table
CTL_TRANSFORM_HISTORY HWM_VALUE2 8.5.010 Column added See table
CTL_UD_TO_UDE_MAPPING CONVERT_EXPRESSION 8.1.201 Column added See table
GPM_FACT ADJUSTED_SCORE 8.5.014.09 Column added See table
GPM_FACT DEFAULT_SCORE 8.5.014.09 Column added See table
GPM_FACT DEFAULT_SCORES_COUNT 8.5.014.09 Column added See table
GPM_FACT DEFAULT_SCORE_USED 8.5.014.09 Column added See table
GPM_FACT FINAL_SCORE_THRESHOLD 8.5.014.09 Column added See table
GPM_FACT GLOBAL_SCORES_COUNT 8.5.014.09 Column added See table
GPM_FACT GPM_DIM1_KEY 8.5.014.09 Column added See table
GPM_FACT INITIAL_SCORE_THRESHOLD 8.5.014.09 Column added See table
GPM_FACT SUITABLE_AGENTS_COUNT 8.5.014.09 Column added See table
GPM_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added See table
INTERACTION_FACT ANCHOR_ID 8.5.003 Column added See table
INTERACTION_FACT ANCHOR_SDT_KEY 8.5.003 Column added See table
INTERACTION_RESOURCE_FACT ASM_COUNT 8.5.004 Column added See table
INTERACTION_RESOURCE_FACT ASM_ENGAGE_DURATION 8.5.004 Column added See table
INTERACTION_RESOURCE_FACT FOCUS_TIME_COUNT 8.5.004 Column added See table
INTERACTION_RESOURCE_FACT FOCUS_TIME_DURATION 8.5.004 Column added See table
INTERACTION_RESOURCE_FACT IRF_ANCHOR_SENT_TS 8.5.003 (renamed from IRF_ANCHOR_DATE_TIME_KEY) Column added See table
INTERACTION_RESOURCE_FACT IRF_ANCHOR_TS 8.5.004 (renamed from IRF_ANCHOR_SENT_TS) Column added See table
INTERACTION_RESOURCE_FACT TARGET_ADDRESS 8.5.006 Column added See table
IRF_USER_DATA_CUST_1 CREATE_AUDIT_KEY 8.5.001 Column added See table
IRF_USER_DATA_CUST_1 UPDATE_AUDIT_KEY 8.5.001 Column added See table
IRF_USER_DATA_GEN_1 CREATE_AUDIT_KEY 8.5.001 Column added See table
IRF_USER_DATA_GEN_1 GSW_CALL_TYPE 8.5.011.18 Column added See table
IRF_USER_DATA_GEN_1 SERVICE_ID 8.1.402 Column added See table
IRF_USER_DATA_GEN_1 SERVICE_START_TS 8.1.402 Column added See table
IRF_USER_DATA_GEN_1 UPDATE_AUDIT_KEY 8.5.001 Column added See table
IRF_USER_DATA_KEYS CREATE_AUDIT_KEY 8.5.001 Column added See table
IRF_USER_DATA_KEYS UPDATE_AUDIT_KEY 8.5.001 Column added See table
MEDIATION_SEGMENT_FACT USERDATA_FLAG 8.5.004 Column added See table
SDR_ACTIVITIES_FACT UPDATE_AUDIT_KEY 8.5.010.16 Column added See table
Showing 1 to 150 of 382 entries
This page was last edited on January 10, 2020, at 20:48.
Comments or questions about this documentation? Contact us for support!