View table: PDMIndexItem

Jump to: navigation, search

Table structure:

  • indexName - String
  • indexDesc - Wikitext
  • indexPresentInPartitioned - String
  • indexKey - String
  • indexKey1 - String
  • indexKey2 - String
  • indexKey3 - String
  • indexKey4 - String
  • indexKey5 - String
  • indexKey6 - String
  • indexKey7 - String
  • indexKey8 - String
  • indexKey9 - String
  • indexKey10 - String
  • keyPresentInNonpartitioned - String
  • keyPresentInNonpartitioned1 - String
  • keyPresentInNonpartitioned2 - String
  • keyPresentInNonpartitioned3 - String
  • keyPresentInNonpartitioned4 - String
  • keyPresentInNonpartitioned5 - String
  • keyPresentInNonpartitioned6 - String
  • keyPresentInNonpartitioned7 - String
  • keyPresentInNonpartitioned8 - String
  • keyPresentInNonpartitioned9 - String
  • keyPresentInNonpartitioned10 - String
  • sort - String
  • sort1 - String
  • sort2 - String
  • sort3 - String
  • sort4 - String
  • sort5 - String
  • sort6 - String
  • sort7 - String
  • sort8 - String
  • sort9 - String
  • sort10 - String
  • isUnique - String
  • cluster - String

This table has 274 rows altogether.

Page indexName indexDesc indexPresentInPartitioned indexKey indexKey1 indexKey2 indexKey3 indexKey4 indexKey5 indexKey6 indexKey7 indexKey8 indexKey9 indexKey10 keyPresentInNonpartitioned keyPresentInNonpartitioned1 keyPresentInNonpartitioned2 keyPresentInNonpartitioned3 keyPresentInNonpartitioned4 keyPresentInNonpartitioned5 keyPresentInNonpartitioned6 keyPresentInNonpartitioned7 keyPresentInNonpartitioned8 keyPresentInNonpartitioned9 keyPresentInNonpartitioned10 sort sort1 sort2 sort3 sort4 sort5 sort6 sort7 sort8 sort9 sort10 isUnique cluster
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL AUDIT LOG IDX_CTL_AL_CTS Improves purge performance. yes CREATED_TS yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL ETL HISTORY I_C_ETL_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL EXTRACT HISTORY I_C_EXTRACT_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL GDPR HISTORY I_CTL_GDPR_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL GDPR HISTORY I_CTL_GDPR_H_C_ID Improves search performance. yes CONSUMER_ID yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL PURGE HISTORY I_C_PURGE_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL TRANSFORM HISTORY I_C_TRANSFORM_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-AGENT LOCATION I_AGENTLOC_LOCATION Ensures that the combinations of values that are stored in the dimension table are unique. yes TENANT_KEY AGENT_LOCATION_STRING yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-AGENT LOCATION NewTitle I_AGENTLOC_LOCATION Ensures that the combinations of values that are stored in the dimension table are unique. yes TENANT_KEY AGENT_LOCATION_STRING yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS BOT DIM I_BGS_BOT_DIM Ensures that the combinations of values that are stored in the dimension table are unique. yes BOT_CATEGORY BOT_FUNCTION yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS BOT NAME DIM I_BGS_BOT_NAME_DIM Ensures that the combinations of values that are stored in the dimension table are unique. yes BOT_NAME yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM I_BGS_SESSION_DIM Ensures that the combinations of values that are stored in the dimension table are unique. yes REJECTED_TO_START ENDED_ABNORMALLY ENDED_BY END_REASON END_RESULT yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT I_BGS_SESSION_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES I_BOT_ATTRIBUTES Ensures that the combinations of values that are stored in the dimension table are unique. yes NAME TYPE OUTCOME PROVIDER yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT INTENT I_BOT_INTENT Ensures that the combinations of values that are stored in the dimension table are unique. yes INTENT yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS I_CALLBACK_DIAL_RESULTS Ensures that the combinations of values that are stored in the dimension table are unique. yes DIAL_1_RESULT DIAL_2_RESULT DIAL_3_RESULT DIAL_4_RESULT DIAL_5_RESULT yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 I_CALLBACK_DIM_1 Ensures that the combinations of values that are stored in the dimension table are unique. yes CHANNEL CALLBACK_OFFER_TYPE CALLBACK_TYPE CONNECT_ORDER yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 I_CALLBACK_DIM_2 Ensures that the combinations of values that are stored in the dimension table are unique. yes DIAL_DIALOG_RESULT CALL_DIRECTION FINAL_DIAL_RESULT OFFER_TIMING yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 3 I_CALLBACK_DIM_3 Ensures that the combinations of values that are stored in the dimension table are unique. yes FINAL_TARGET DISPOSITION yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 4 I_CALLBACK_DIM_4 Ensures that the combinations of values that are stored in the dimension table are unique. yes ABANDONED_DURING_CB_OFFER DIAL_IGNORING_AVAILABILITY yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT I_CLMF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT I_CLMF_TNT Improves access time, based on the Tenant. yes TENANT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT I_CGSEF_DT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY END_DATE_TIME_KEY yes yes Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT I_CGSEF_SID Ensures that the facts that are stored in the table are for unique sessions. yes CAMPAIGN_GROUP_SESSION_ID START_DATE_TIME_KEY yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT I_CGSEF_TNT Improves access time, based on the Tenant. yes TENANT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT I_CGSTF_CGSF Improves access time, based on the Campaign Group Session Fact key. yes CAMP_GROUP_SESSION_FACT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT I_CGSTF_STD Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT I_CGSTF_TNT Improves access time, based on the Tenant. yes TENANT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR DIM1 I_CDR_DIM1 Reserved for future use. yes DIRECTION DEVICE_DBID DEVICE_NAME DEVICE_CLASS yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT I_CDR_FACT_SDT Reserved for future use. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM I_CHAT_SESSION_DIM Ensures that the combinations of values that are stored in the dimension table are unique. yes ASYNC_MODE ENDED_BY ENDED_REASON LANGUAGE_NAME MEDIA_ORIGIN yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT I_CHAT_SESSION_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT THREAD FACT I_CHAT_THREAD_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-COBROWSE END REASON I_COBROWSE_END_REASON Ensures that the combinations of values that are stored in the dimension table are unique. yes SESSION_END_REASON yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-COBROWSE FACT I_COBROWSE_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-COBROWSE MODE I_COBROWSE_MODE Ensures that the combinations of values that are stored in the dimension table are unique. yes SEGMENT_MODE yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-COBROWSE PAGE I_COBROWSE_PAGE Ensures that the combinations of values that are stored in the dimension table are unique. yes PAGE_DOMAIN PAGE_PATH PAGE_TITLE yes yes yes Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-COBROWSE USER AGENT I_COBROWSE_USER_AGENT Ensures that the combinations of values that are stored in the dimension table are unique. yes CREATOR_USER_AGENT CREATOR_DEVICE_CLASS CREATOR_DEVICE_BRAND CREATOR_DEVICE_NAME CREATOR_OS_CLASS CREATOR_OS_NAME CREATOR_OS_VER CREATOR_AGENT_CLASS CREATOR_AGENT_NAME CREATOR_AGENT_VER yes yes yes yes yes yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT I_CAF_CGSF Improves access time, based on the Campaign Group Session Fact key. yes CAMP_GROUP_SESSION_FACT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT I_CAF_CID Improves access time, based on the Call ID. yes CALLID yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT I_CAF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT I_CAF_TNT Improves access time, based on the Tenant. yes TENANT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL AUDIT LOG IDX_CTL_AL_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL ETL HISTORY I_C_ETL_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL EXTRACT HISTORY I_C_EXTRACT_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL GDPR HISTORY I_CTL_GDPR_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL GDPR HISTORY I_CTL_GDPR_H_C_ID Improves search performance. yes CONSUMER_ID yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL PURGE HISTORY I_C_PURGE_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-CTL TRANSFORM HISTORY I_C_TRANSFORM_H_CTS Improves purge performance. yes CREATED_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_30 Improves access time, based on a 30-minute key. yes DATE_TIME_30MIN_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_30_INT Improves access time, based on the 30-minute key, the next 30-minute key, and the primary key. yes DATE_TIME_30MIN_KEY DATE_TIME_NEXT_30MIN_KEY DATE_TIME_KEY yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_CAL_DATE Improves access time, based on the calendar date. yes CAL_DATE yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_DAY_INT Improves access time, based on the day key, the next day key, and the primary key. yes DATE_TIME_DAY_KEY DATE_TIME_NEXT_DAY_KEY DATE_TIME_KEY yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_HOUR_INT Improves access time, based on the hour key, the next hour key, and the primary key. yes DATE_TIME_HOUR_KEY DATE_TIME_NEXT_HOUR_KEY DATE_TIME_KEY yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_MONTH_INT Improves access time, based on the month key, the next month key, and the primary key. yes DATE_TIME_MONTH_KEY DATE_TIME_NEXT_MONTH_KEY DATE_TIME_KEY yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_NEXT Improves access time, based on the key of the next record. yes DATE_TIME_NEXT_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME IDX_DT_NEXT30 Improves access time, based on the next 30-minute key. yes DATE_TIME_NEXT_30MIN_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GIDB GCX LOGIN INFO IDX_LOGIN_INFO yes AGENTID LOGINID STATUS yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GIDB GCX LOGIN INFO I_GCX_LOGIN_INFO_TTS yes DELETED_TS LOGINID STATUS yes yes yes Ascending Ascending Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GPM DIM1 I_GPM_DIM1 Ensures that the combinations of values that are stored in the dimension table are unique. yes PREDICTOR_TYPE ROUTING_CRITERIA yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GPM FACT I_GPM_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GPM MODEL I_GPM_MODEL Ensures that the combinations of values that are stored in the dimension table are unique. yes MODEL MODEL_ID yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GPM PREDICTOR I_GPM_PREDICTOR Ensures that the combinations of values that are stored in the dimension table are unique. yes PREDICTOR PREDICTOR_ID yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GPM RESULT I_GPM_RESULT Ensures that the combinations of values that are stored in the dimension table are unique. yes GPM_MODE GPM_STATUS GPM_RESULT GPM_USE CUSTOMER_FOUND yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GROUP ANNEX I_GROUP_ANNEX Improves access time, based on dimension values. yes CFGOBJECTID CFGOBJECTTYPE KEYNAME SECTIONNAME yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-GROUP ANNEX I_GROUP_ANNEX_END_TS Improves access time, based on the End Timestamp. yes END_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION DESCRIPTOR I_INTERACTION_DESCRIPTOR Ensures that the combinations of values that are stored in the dimension table for each tenant are unique. yes TENANT_KEY CUSTOMER_SEGMENT SERVICE_TYPE SERVICE_SUBTYPE BUSINESS_RESULT yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION FACT I_IF_CID Improves access time, based on the Call ID. yes MEDIA_SERVER_IXN_GUID yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION FACT I_IF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION RESOURCE FACT IDX_IRF_IID Improves access time, based on the INTERACTION ID. yes INTERACTION_ID yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION RESOURCE FACT I_IRF_PT_GUID Reserved. yes PARTYGUID START_DATE_TIME_KEY yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION RESOURCE FACT I_IRF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-IRF USER DATA CUST 1 I_IRF_USER_DATA_CUST_1_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-IRF USER DATA GEN 1 I_IRF_USER_DATA_GEN_1_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-IRF USER DATA KEYS I_IRF_USER_DATA_KEYS_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-IXN RESOURCE STATE FACT I_IRSF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR CAMPAIGN I_LDR_CAMPAIGN Ensures that the combinations of values that are stored in the dimension table are unique. yes CAMPAIGN_GROUP_NAME CAMPAIGN_GROUP_ID CAMPAIGN_TEMPLATE_NAME yes yes yes Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR DEVICE I_LDR_DEVICE Ensures that the combinations of values that are stored in the dimension table are unique. yes DEVICE_COUNTRY_CODE DEVICE_AREA_CODE DEVICE_STATE_CODE DEVICE_TIMEZONE yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR FACT I_LDR_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR GROUP I_LDR_GROUP Ensures that the combinations of values that are stored in the dimension table are unique. yes GROUP_NAME yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR LIST I_LDR_LIST Ensures that the combinations of values that are stored in the dimension table are unique. yes LIST_NAME LIST_ID yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR POSTAL CODE I_LDR_POSTAL_CODE Ensures that the combinations of values that are stored in the dimension table are unique. yes POSTAL_CODE yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-LDR RECORD I_LDR_RECORD Ensures that the combinations of values that are stored in the dimension table are unique. yes CONTACT_INFO_TYPE RECORD_TYPE RECORD_STATUS DISPOSITION yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-MEDIA ORIGIN I_MEDIA_ORIGIN Ensures that the combinations of values that are stored in the dimension table are unique. yes MEDIA_ORIGIN yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-MEDIA TYPE I_MEDIA_TP_MCD Ensures that the combinations of values that are stored in the dimension table are unique. yes MEDIA_NAME_CODE yes Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-MEDIATION SEGMENT FACT I_MSF_IID Improves access time, based on the INTERACTION ID. yes INTERACTION_ID yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-MEDIATION SEGMENT FACT I_MSF_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 1 I_POST_CALL_SURVEY_DIM_1 Improves access time. yes TENANT_KEY SURVEY_IAGENTSCORE SURVEY_ICOMPANYSCORE SURVEY_ICALLSCORE SURVEY_IPRODUCTSCORE SURVEY_IQ1 yes yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 2 I_POST_CALL_SURVEY_DIM_2 Improves access time. yes TENANT_KEY SURVEY_IQ2 SURVEY_IQ3 SURVEY_IQ4 SURVEY_SQ1 SURVEY_SQ2 yes yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 3 I_POST_CALL_SURVEY_DIM_3 Improves access time. yes TENANT_KEY SURVEY_SQ3 SURVEY_SQ4 SURVEY_SQ5 SURVEY_SQ6 SURVEY_SQ7 yes yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 4 I_POST_CALL_SURVEY_DIM_4 Improves access time. yes TENANT_KEY SURVEY_SQ8 SURVEY_SQ9 SURVEY_SQ10 SURVEY_IQ5 SURVEY_IQ6 yes yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 5 I_POST_CALL_SURVEY_DIM_5 Improves access time. yes TENANT_KEY SURVEY_IQ7 SURVEY_IQ8 SURVEY_IQ9 SURVEY_IQ10 yes yes yes yes yes Ascending Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-POST CALL SURVEY DIM 6 I_POST_CALL_SURVEY_DIM_6 Improves access time. yes TENANT_KEY SURVEY_IRECOMMENDSCORE SURVEY_COMPLETE SURVEY_RECORDING yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE IDX_RES_CFG_DBID Reserved. yes RESOURCE_CFG_DBID RESOURCE_CFG_TYPE_ID yes yes Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE IDX_RES_TYPE_CODE Improves access time, based on the code for the resource type. yes RESOURCE_TYPE_CODE yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE I_RES_KEY_CFG_DBID Reserved. yes RESOURCE_KEY RESOURCE_CFG_DBID RESOURCE_CFG_TYPE_ID yes yes yes Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE ANNEX I_RESOURCE_ANNEX Improves access time, based on dimension values. yes CFGOBJECTID CFGOBJECTTYPE KEYNAME SECTIONNAME yes yes yes yes Ascending Ascending Ascending Ascending yes
Draft:PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE ANNEX I_RESOURCE_ANNEX_END_TS Improves access time, based on the End Timestamp. yes END_TS yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR ACTIVITIES FACT I_SDR_ACTIVITIES_FACT_SDT Improves access time, based on the Start Date Time key. yes START_DATE_TIME_KEY yes Ascending
Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR ACTIVITY I_SDR_ACTIVITY Ensures that the combinations of values that are stored in the dimension table are unique. yes NAME yes Ascending yes

More...

Retrieved from "https://all.docs.genesys.com/Special:CargoTables/PDMIndexItem (2022-07-01 19:03:27)"