View table: PDMIndexItem
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 |