Cargo query
Showing below up to 100 results in range #101 to #200.
View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR APPLICATION | I_SDR_APPLICATION | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | APPLICATION_VERSION | APPLICATION_TITLE | APPLICATION_ID | yes | yes | yes | Ascending | Ascending | Ascending | yes | |||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR BOTS FACT | I_SDR_BOTS_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 CALL DISPOSITION | I_SDR_CALL_DISPOSITION | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | DISPOSITION_TYPE | DISPOSITION_CATEGORY | FINAL_DISPOSITION | yes | yes | yes | Ascending | Ascending | Ascending | yes | |||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR CALL TYPE | I_SDR_CALL_TYPE | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | CALL_TYPE | MEDIA_TYPE | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR CUST ATRIBUTES | I_SDR_CUST_ATRIBUTES | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | ATRIBUTE_NAME | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR CUST ATRIBUTES FACT | I_SDR_CUST_ATRIBUTES_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 ENTRY POINT | I_SDR_ENTRY_POINT | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | DNIS | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR EXIT POINT | I_SDR_EXIT_POINT | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | APPLICATION_EXIT_POINT | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR EXT HTTP REST | I_SDR_EXT_HTTP_REST | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | URL | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR EXT REQUEST | I_SDR_EXT_REQUEST | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | REQUEST_NAME | REQUEST_TYPE | METHOD | yes | yes | yes | Ascending | Ascending | Ascending | yes | |||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR EXT REQUEST FACT | I_SDR_EXT_REQUEST_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 EXT REQUEST OUTCOME | I_SDR_EXT_REQUEST_OUTCOME | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | RESPONSE_CODE | SUCCESS | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR EXT SERVICE OUTCOME | I_SDR_EXT_SERVICE_OUTCOME | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | SERVICE_NAME | SERVICE_RESPONSE_CODE | SERVICE_RESPONSE_DESC | yes | yes | yes | Ascending | Ascending | Ascending | yes | |||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR GEO LOCATION | I_SDR_GEO_LOCATION | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | COUNTRY_CODE | COUNTRY_NAME | REGION | TIMEZONE | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | yes | ||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR INPUT | I_SDR_INPUT | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | INPUT_NAME | INPUT_TYPE | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR INPUT OUTCOME | I_SDR_INPUT_OUTCOME | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | SELECTED_OPTION | NO_INPUT_COUNT | NO_MATCH_COUNT | STRIKEOUT | SUCCESS | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR LANGUAGE | I_SDR_LANGUAGE | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | LANGUAGE_CODE | LANGUAGE_NAME | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR MESSAGE | I_SDR_MESSAGE | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | MESSAGE_FILE | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR MILESTONE | I_SDR_MILESTONE | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | MILESTONE | MILESTONE_PATH | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SESSION FACT | I_SDR_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-SDR SURVEY ANSWERS | I_SDR_SURVEY_ANSWERS | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | SURVEY_ANSWER_INT | SURVEY_ANSWER_STR | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY FACT | I_SDR_SURVEY_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 SURVEY I1 | I_SDR_SURVEY_I1 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | IQ1 | IQ2 | IQ3 | IQ4 | IQ5 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY I2 | I_SDR_SURVEY_I2 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | IQ6 | IQ7 | IQ8 | IQ9 | IQ10 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY QUESTIONS | I_SDR_SURVEY_QUESTIONS | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | QUESTION | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY QUESTIONS I1 | I_SDR_SURVEY_QUESTIONS_I1 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | IQ1 | IQ2 | IQ3 | IQ4 | IQ5 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY QUESTIONS I2 | I_SDR_SURVEY_QUESTIONS_I2 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | IQ6 | IQ7 | IQ8 | IQ9 | IQ10 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY QUESTIONS S1 | I_SDR_SURVEY_QUESTIONS_S1 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | SQ1 | SQ2 | SQ3 | SQ4 | SQ5 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY QUESTIONS S2 | I_SDR_SURVEY_QUESTIONS_S2 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | SQ6 | SQ7 | SQ8 | SQ9 | SQ10 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY S1 | I_SDR_SURVEY_S1 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | SQ1 | SQ2 | SQ3 | SQ4 | SQ5 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY S2 | I_SDR_SURVEY_S2 | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | SQ6 | SQ7 | SQ8 | SQ9 | SQ10 | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY SCORES | I_SDR_SURVEY_SCORES | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | IAGENTSCORE | ICOMPANYSCORE | ICALLSCORE | IPRODUCTSCORE | IRECOMMEDSCORE | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | yes | |||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY STATUS | I_SDR_SURVEY_STATUS | Improves access time, based on the CREATE_AUDIT_KEY value. | yes | COMPLETE | RECORDING | OFFER | yes | yes | yes | Ascending | Ascending | Ascending | yes | |||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR SURVEY TRANSCRIPT FACT | I_SDR_SRV_TRANSCRIPT_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 USER INPUT | I_SDR_USER_INPUT | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | USER_INPUT_TYPE | yes | Ascending | yes | |||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SDR USER INPUTS FACT | I_SDR_USER_INPUTS_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 USER MILESTONE FACT | I_SDR_USER_MILESTONE_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-SM RES SESSION FACT | I_SM_RS_SSSN_SDT | Improves access time, based on the Start Date Time key. | yes | START_DATE_TIME_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SM RES STATE FACT | I_RSSF_RMESSSR | Improves access time. | yes | RESOURCE_KEY | MEDIA_TYPE_KEY | END_MSEC | START_MSEC | START_DATE_TIME_KEY | SM_RES_STATE_FACT_KEY | RESOURCE_STATE_KEY | yes | yes | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | Ascending | Ascending | ||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SM RES STATE FACT | I_RSSF_SDT | Improves access time, based on the Start Date Time key. | yes | START_DATE_TIME_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-SM RES STATE REASON FACT | I_RSRF_SDT | Improves access time, based on the Start Date Time key. | yes | START_DATE_TIME_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-USER DATA CUST DIM 1 | I_USER_DATA_CUST_DIM_1 | Ensures that the combinations of values that are stored in the dimension table are unique. | yes | TENANT_KEY | DIM_ATTRIBUTE_1 | DIM_ATTRIBUTE_2 | DIM_ATTRIBUTE_3 | DIM_ATTRIBUTE_4 | DIM_ATTRIBUTE_5 | yes | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | Ascending | yes | ||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-USER DATA GEN DIM 1 | I_USER_DATA_GEN_DIM_1 | Reserved for internal use. | yes | TENANT_KEY | DIM_ATTRIBUTE_1 | DIM_ATTRIBUTE_2 | DIM_ATTRIBUTE_3 | DIM_ATTRIBUTE_4 | DIM_ATTRIBUTE_5 | yes | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | Ascending | yes | ||||||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-USER DATA GEN DIM 2 | I_USER_DATA_GEN_DIM_2 | Reserved for internal use. | yes | TENANT_KEY | DIM_ATTRIBUTE_1 | DIM_ATTRIBUTE_2 | DIM_ATTRIBUTE_3 | DIM_ATTRIBUTE_4 | DIM_ATTRIBUTE_5 | yes | yes | yes | yes | yes | yes | Ascending | Ascending | Ascending | Ascending | Ascending | Ascending | yes | ||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||
| 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 | ||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | I_CLMF_TNT | Improves access time, based on the Tenant. | yes | TENANT_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | I_CGSEF_TNT | Improves access time, based on the Tenant. | yes | TENANT_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | I_CGSTF_TNT | Improves access time, based on the Tenant. | yes | TENANT_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | I_CDR_FACT_SDT | Reserved for future use. | yes | START_DATE_TIME_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | ||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT | I_CAF_CID | Improves access time, based on the Call ID. | yes | CALLID | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CONTACT ATTEMPT FACT | I_CAF_TNT | Improves access time, based on the Tenant. | yes | TENANT_KEY | yes | Ascending | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-CTL ETL HISTORY | I_C_ETL_H_CTS | Improves purge performance. | yes | CREATED_TS | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-DATE TIME | IDX_DT_CAL_DATE | Improves access time, based on the calendar date. | yes | CAL_DATE | yes | Ascending | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-GIDB GCX LOGIN INFO | IDX_LOGIN_INFO | yes | AGENTID | LOGINID | STATUS | yes | yes | yes | Ascending | Ascending | Ascending | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||
| 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 | ||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION RESOURCE FACT | IDX_IRF_IID | Improves access time, based on the INTERACTION ID. | yes | INTERACTION_ID | yes | Ascending |