Cargo query
Showing below up to 74 results in range #201 to #274.
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PEC-REP/Library/PDMLibraryGIM/Table-INTERACTION RESOURCE FACT | I_IRF_PT_GUID | Reserved. | yes | PARTYGUID | START_DATE_TIME_KEY | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
PEC-REP/Library/PDMLibraryGIM/Table-MEDIATION SEGMENT FACT | I_MSF_IID | Improves access time, based on the INTERACTION ID. | yes | INTERACTION_ID | yes | Ascending | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||||||||
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 | ||||||||||||||||||||||
PEC-REP/Library/PDMLibraryGIM/Table-RESOURCE | IDX_RES_CFG_DBID | Reserved. | yes | RESOURCE_CFG_DBID | RESOURCE_CFG_TYPE_ID | yes | yes | Ascending | Ascending | yes | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 |