Drilldown: GCXI Attribute

Agent > Detail > State (2)

None (2)

None (2)

None (2)

Datetime (2)

None (2)

None (2)

None · ??? · A_CUSTOMER_SEGMENT, A_CA_CUSTOMER_SEGMENT, T_CUSTOMER_SEGMENT, CA_CUSTOMER_SEGMENT, Q_CUSTOMER_SEGMENT · F_YEAR, YEAR · MONTH_YEAR_AGO · MONTH_YEAR_NEXT · CAL_DATE · A_SERVICE_TYPE, A_CA_SERVICE_TYPE, CA_SERVICE_TYPE, T_SERVICE_TYPE, Q_SERVICE_TYPE · A_SERVICE_SUBTYPE, A_CA_SERVICE_SUBTYPE, CA_SERVICE_SUBTYPE, T_SERVICE_SUBTYPE, Q_SERVICE_SUBTYPE · F_MONTH, MONTH · F_QRTR, QRTR · A_BUSINESS_RESULT,A_CA_BUSINESS_RESULT,T_BUSINESS_RESULT,Q_BUSINESS_RESULT,CA_BUSINESS_RESULT · IRSF_START_TS_TIME · F_SUBHR, SUBHR · F_WEEK, WEEK · STATE_START_TS_TIME · GROUP_COMBINATION_KEY · IA_STATE_NAME · INTERACTION_TYPE_GI2.INTERACTION_TYPE · IRF_START_DATE_TIME_KEY

Other values: ; ?? @A_CLASSIFY_ACTIONABILITY_CTGNAME, @T_CLASSIFY_ACTIONABILITY_CTGNAME @A_CLASSIFY_SENTIMENT_CTGNAME, @T_CLASSIFY_SENTIMENT_CTGNAME @A_CTGNAME, @T_CTGNAME @A_INFLUENCE_CATEGORY_CTGNAME, @T_INFLUENCE_CATEGORY_CTGNAME AGM_END_TS_TIME AGM_START_TS_TIME A_AGENT_GROUP, CA_AGENT_GROUP, AD_AGENT_GROUP, LIST OF VALUES IA_AGENT_GROUP A_AGENT_NAME, CA_AGENT_NAME, AD_AGENT_NAME, SO_AGENT_NAME, IA_AGENT_NAME A_CA_CAMPAIGN_GROUP_NAME, CA_CAMPAIGN_GROUP_NAME A_CA_CAMPAIGN_NAME, CA_CAMPAIGN_NAME A_INTERACTION_SUBTYPE, CA_INTERACTION_SUBTYPE, T_INTERACTION_SUBTYPE, IF_INTERACTION_SUBTYPE, IRF_INTERACTION_SUBTYPE_CODE, IA_AGENT_INTERACTION_SUBTYPE, Q_INTERACTION_SUBTYPE, T_IRF_INTERACTION_SUBTYPE_CODE A_INTERACTION_TYPE, A_CA_INTERACTION_TYPE, T_INTERACTION_TYPE, IF_INTERACTION_TYPE, IRF_INTERACTION_TYPE, IA_AGENT_INTERACTION_TYPE, IRSF_INTERACTION_TYPE, Q_INTERACTION_TYPE, T_IRF_INTERACTION_TYPE A_QUEUE_GROUP, Q_QUEUE_GROUP CA_CALLING_LIST_NAME CBF_CUSTOMER_NUMBER CBF_SERVICE_ID CB_CALLBACK_OFFER_TYPE CB_CALLBACK_TYPE CB_CALL_DIRECTION CB_CHANNEL CB_CONNECT_ORDER CB_DIAL_DIALOG_RESULT CB_FINAL_DIAL_RESULT CB_FINAL_TARGET CB_OFFER_TIMING CB_RESOURCE_NAME DATE_RANGE F_DAY, DAY F_HOUR, HOUR IRSF_ADD_INFO IRSF_END_TS_TIME IRSF_STATE Q_GROUP_COMBINATION_KEY Q_QUEUE Q_WORKBIN_OWNER_NAME Q_WORKBIN_TYPE_CODE, Q_WORKBIN_RESOURCE_NAME SESS_ACTIVE_FLAG SESS_END_TS_TIME SESS_SESSION_FACT_KEY SESS_START_TS_TIME STATE_ACTIVE_FLAG STATE_END_TS_TIME STATE_REASON_ACTIVE_FLAG STATE_REASON_CODE, IA_REASON_CODE STATE_STATE

None · RESOURCE_Q.RESOURCE_NAME · INTERACTION_RESOURCE_FACT_GI2.RESOURCE_KEY · DATE_TIME.LABEL_YYYY_MM_DD_HH24 · DATE_TIME.LABEL_YYYY_MM · RESOURCE_A.AGENT_NAME · DATE_TIME.LABEL_YYYY_QQ · DATE_TIME.LABEL_YYYY_WE · DATE_TIME.LABEL_YYYY · DATE_TIME_YEAR_AGO.LABEL_YYYY_MM · IF_IRF_GPM_FACT_GI2.RESOURCE_KEY · RESOURCE_STATE.STATE_NAME · DATE_TIME_YEAR_NEXT.LABEL_YYYY_MM · INTERACTION_RESOURCE_FACT_GI2.IRF_ANCHOR · INTERACTION_FACT_GI2.END_TS_TIME · INTERACTION_DESCRIPTOR_GI2.BUSINESS_RESULT · INTERACTION_DESCRIPTOR_GI2.CUSTOMER_SEGMENT · INTERACTION_DESCRIPTOR_GI2.SERVICE_TYPE · INTERACTION_DESCRIPTOR_GI2.SERVICE_TYPE_SUBTYPE · INTERACTION_RESOURCE_FACT_GI2.INTERACTION_ID

Other values: ; 'NO_VALUE')) 'UNKNOWN' .ETL_AUDIT.Z_JOB_TYPE .INTERACTION_RES_FACT_TRNSFR_GI2.RESOURCE_KEY .RESOURCE_STATE_REASON_GI2.RESOURCE_STATE_REASON_KEY .interaction_ID AG2_*.DATE_TIME_KEY AG2_AGENT_* AG2_AGENT_*.GROUP_COMBINATION_KEY AG2_AGENT_*.INTERACTION_TYPE_KEY AG2_AGENT_*.RESOURCE_KEY AG2_AGENT_*.USER_DATA_KEY1 AG2_AGENT_CAMPAIGN_*.CAMPAIGN_GROUP_KEY AG2_AGENT_CAMPAIGN_*.GROUP_COMBINATION_KEY AG2_AGENT_CAMPAIGN_*.INTERACTION_TYPE_KEY AG2_AGENT_CAMPAIGN_*.RESOURCE_KEY AG2_AGENT_GRP_* AG2_AGENT_GRP_*.GROUP_KEY AG2_AGENT_GRP_*.INTERACTION_TYPE_KEY AG2_AGENT_GRP_*.USER_DATA_KEY1 AG2_AGENT_QUEUE_* AG2_AGENT_QUEUE_*.AGENT_GROUP_COMBINATION_KEY AG2_AGENT_QUEUE_*.AGENT_RESOURCE_KEY AG2_AGENT_QUEUE_*.INTERACTION_TYPE_KEY AG2_AGENT_QUEUE_*.USER_DATA_KEY1 AG2_CALLBACK_*.CBD1_KEY AG2_CALLBACK_*.CBD2_KEY AG2_CALLBACK_*.CBD3_KEY AG2_CALLBACK_*.RESOURCE_KEY AG2_CAMPAIGN_*.CAMPAIGN_GROUP_KEY AG2_CHAT_AGENT_*.GROUP_COMBINATION_KEY AG2_CHAT_AGENT_*.RESOURCE_KEY AG2_CHAT_AGENT_GRP_*.GROUP_KEY AG2_COBROWSE_AGENT_*.AGENT_RESOURCE_KEY AG2_ID_* AG2_ID_*.GPM_MODEL_KEY AG2_ID_*.GPM_PREDICTOR_KEY AG2_ID_*.GPM_RESULT AG2_ID_*.INTERACTION_TYPE_KEY AG2_ID_*.USER_DATA_KEY1 AG2_I_AGENT_*.GPM_MODEL_KEY AG2_I_AGENT_*.GPM_PREDICTOR_KEY AG2_I_AGENT_*.GPM_RESULT AG2_I_AGENT_*.GROUP_COMBINATION_KEY AG2_I_AGENT_*.INTERACTION_TYPE_KEY AG2_I_AGENT_*.RESOURCE_KEY AG2_I_MN_*.GROUP_COMBINATION_KEY AG2_I_MN_*.RESOURCE_KEY AG2_I_SESS_*.GROUP_COMBINATION_KEY AG2_I_SESS_*.RESOURCE_KEY AG2_I_SESS_STATE-*.GROUP_COMBINATION_KEY AG2_I_STATE_*.GROUP_COMBINATION_KEY AG2_I_STATE_*.RESOURCE_KEY AG2_I_STATE_RSN_*.RESOURCE_STATE_REASON_KEY AG2_QUEUE_*.GPM_MODEL_KEY AG2_QUEUE_*.GPM_PREDICTOR_KEY AG2_QUEUE_*.GPM_RESULT AG2_QUEUE_*.INTERACTION_TYPE_KEY AG2_QUEUE_ABN_*.INTERACTION_TYPE_KEY AG2_QUEUE_ACC_*.INTERACTION_TYPE_KEY AG2_SDR_ACTIVITY_*.SDR_ACTIVITY_KEY AG2_SDR_ACTIVITY_DAY.COMPLETED AG2_SDR_SESSION*.SDR_APPLICATION_KEY AG2_SDR_SESSION_*.BAILOUT_SDR_MILESTONE_KEY AG2_SDR_SESSION_*.STRIKEOUT_SDR_MILESTONE_KEY AG2_SDR_SESS_BLOCK*.SDR_APPLICATION_KEY AG2_SDR_SESS_MILESTONE*.SDR_APPLICATION_KEY AG2_SDR_SURVEY*.SDR_APPLICATION_KEY AG2_SDR_SURVEY_*.GROUP_COMBINATION_KEY AG2_SDR_SURVEY_*.RESOURCE_KEY AG2_SDR_SURVEY_ANS_*.MULTI_AGENT_FLAG AGE.AGE_* AGENT.AGENT_ID AGENT_AGENT_ID APPLICATION_VERSION) BDS_BUSINESS_UNIT.NAME BDS_NAMED_AGENTS.METRIC_NAME BDS_REGION.NAME BGS_BOT_DIM.BOT_CATEGORY BGS_BOT_DIM.BOT_FUNCTION BGS_BOT_DIM.END_RESULT BGS_SESSION_DIM.ENDED_BY BGS_SESSION_DIM.END_REASON BUSINESS_VALUE.BUSINESS_VALUE_RANGE_10 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_100 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_1000 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_5 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_50 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_500 BUSINESS_VALUE.BUSINESS_VALUE_RANGE_5_sta CALLBACK_DIAL_RESULTS CALLBACK_DIM_1.CALLBACK_OFFER_TYPE CALLBACK_DIM_1.CALLBACK_TYPE CALLBACK_DIM_1.CHANNEL CALLBACK_DIM_1.CONNECT_ORDER CALLBACK_DIM_1.ID CALLBACK_DIM_2.CALL_DIRECTION CALLBACK_DIM_2.DIAL_DIALOG_RESULT CALLBACK_DIM_2.FINAL_DIAL_RESULT CALLBACK_DIM_2.ID CALLBACK_DIM_2.OFFER_TIMING CALLBACK_DIM_3.FINAL_TARGET CALLBACK_DIM_3.ID CALLBACK_DIM_4.DIAL_IGNORING_AVAILABILITY CALLBACK_DIM_4.ID CALLBACK_FACT_GI2.CALLBACK_DIM_4_KEY CALLBACK_FACT_GI2.CUSTOMER_PHONE_NUMBER CALLBACK_FACT_GI2.DESIRED_TS_TIME CALLBACK_FACT_GI2.FINAL_RECORD CALLBACK_FACT_GI2.SERVICE_ID CALLING_LIST.CALLING_LIST_NAME CAMPAIGN.CAMPAIGN_NAME CAPTURE_POINT.CAPTURE_POINT_NAME CHAT_SESSION_DIM.ASYNC_MODE CHAT_SESSION_DIM.ENDED_BY CHAT_SESSION_DIM.ENDED_REASON CHAT_SESSION_DIM.LANGUAGE_NAME CHAT_SESSION_DIM.MEDIA_ORIGIN COBROWSE_FACT_GI2.COBROWSE_MODE_KEY COBROWSE_FACT_GI2.COBROWSE_PAGE_KEY COBROWSE_FACT_GI2.IMEDIA_SERVER_IXN_GUID COBROWSE_FACT_GI2.MEDIA_SERVER_IXN_GUID COBROWSE_FACT_GI2.PAGE_END_TIME COBROWSE_FACT_GI2.PAGE_START_TIME COBROWSE_FACT_GI2.PAGE_URL COBROWSE_FACT_GI2.SEGMENT_END_TIME COBROWSE_FACT_GI2.SEGMENT_START_TIME COBROWSE_FACT_GI2.SESSION_END_TIME COBROWSE_FACT_GI2.SESSION_END_TIME minus COBROWSE_FACT_GI2.SESSION_START_TIME COBROWSE_FACT_GI2.SESSION_START_TIME COBROWSE_FACT_GI2.SESSION_TOKEN COBROWSE_FACT_GI2.START_DATE_TIME_KEY COBROWSE_MODE.SEGMENT_MODE COBROWSE_MODE_.ID COBROWSE_PAGE.ID COBROWSE_PAGE.PAGE_TITLE CUSTOMER.CUSTOMER_ID Calculated based on INTERACTION_FACT_GI2.END_TS and INTERACTION_FACT_GI2.START_TS DATE_TIME.CAL_DATE DATE_TIME.DATE_TIME_KEY DATE_TIME.LABEL.YYYY.MM.DD DATE_TIME.LABEL_YYYY_MM_DD DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT or FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT DATE_TIME_*.CAL_DATE DATE_TIME_*.DATE_TIME_KEY DATE_TIME_SUBHR.DATE_TIME_KEY DB_VERSION.COMPONENT DB_VERSION.LVL DB_VERSION.VERSION Depending on the value of ROUTING_TARGET_TYPE_CODE ETL_AUDIT.BATCH_ID ETL_AUDIT.BATCH_LAST_EVENT_ID ETL_AUDIT.DATA_SOURCE_NAME ETL_AUDIT.DATA_SOURCE_TYPE ETL_AUDIT.ETL_AUDIT_FINISH_TIME ETL_AUDIT.ETL_AUDIT_KEY ETL_AUDIT.FIRST_EXTRACTED_EVENT_ID ETL_AUDIT.LAST_EXTRACTED_EVENT_ID ETL_AUDIT.LAST_INTERVAL_DATE_KEY ETL_AUDIT.LAST_INTERVAL_TIME_KEY ETL_AUDIT.PROCESS_NAME ETL_AUDIT.STATUS FORECAST_DATE_TIME.LABEL_YYYY FORECAST_DATE_TIME.LABEL_YYYY_MM FORECAST_DATE_TIME.LABEL_YYYY_MM_DD FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24 FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT FORECAST_DATE_TIME.LABEL_YYYY_QQ GPM_MODEL.MODEL GPM_MODEL.MODEL_ID GPM_PREDICTOR.PREDICTOR GPM_PREDICTOR.PREDICTOR_ID GPM_PREDICTOR.PREDICTOR_SWITCH GPM_RESULT.CUSTOMER_FOUND GPM_RESULT.GPM_MODE GPM_RESULT.GPM_RESULT GPM_RESULT.GPM_STATUS GPM_RESULT.ID GROUP_A.GROUP_KEY GROUP_A.GROUP_NAME GROUP_A.GROUP_NAME (WHERE GROUP_.GROUP_TYPE_CODE in ('AGENT' GROUP_CA.GROUP_KEY GROUP_CA.GROUP_NAME GROUP_Q.GROUP_NAME (WHERE GROUP_TYPE_CODE in ('QUEUE' GROUP_R.GROUP_TYPE IF_IRF_GPM_FACT_GI2.ACTIVE_FLAG IF_IRF_GPM_FACT_GI2.GPM_MODEL_KEY IF_IRF_GPM_FACT_GI2.GPM_PREDICTOR_KEY IF_IRF_GPM_FACT_GI2.GPM_RESULT IF_IRF_GPM_FACT_GI2.IF_END_TS_TIME IF_IRF_GPM_FACT_GI2.INTERACTION_ID IF_IRF_GPM_FACT_GI2.INTERACTION_RESOURCE_ID IF_IRF_GPM_FACT_GI2.INTERACTION_TYPE_KEY IF_IRF_GPM_FACT_GI2.IRF_END_TS_TIME IF_IRF_GPM_FACT_GI2.IRF_START_TS_TIME IF_IRF_GPM_FACT_GI2.LAST_QUEUE_RESOURCE_KEY IF_IRF_GPM_FACT_GI2.LAST_VQUEUE_RESOURCE_KEY IF_IRF_GPM_FACT_GI2.MEDIA_SERVER_IXN_GUID IF_IRF_GPM_FACT_GI2.MEDIA_SERVER_ROOT_IXN_ID IF_IRF_GPM_FACT_GI2.RESOURCE_GROUP_COMBINATION_KEY IF_IRF_GPM_FACT_GI2.SOURCE_ADDRESS IF_IRF_GPM_FACT_GI2.START_DATE_TIME_KEY IF_IRF_GPM_FACT_GI2.STOP_ACTION IF_IRF_GPM_FACT_GI2.TARGET_ADDRESS INTERACTION_DESCR_RCV_GI2.BUSINESS_RESULT INTERACTION_DESCR_RCV_GI2.CUSTOMER_SEGMENT INTERACTION_DESCR_RCV_GI2.INTERACTION_DESCRIPTOR_KEY INTERACTION_DESCR_RCV_GI2.SERVICE_TYPE INTERACTION_DESCR_RCV_GI2.SERVICE_TYPE_SUBTYPE INTERACTION_FACT_GI2.ACTIVE_FLAG INTERACTION_FACT_GI2.INTERACTION_ID INTERACTION_FACT_GI2.INTERACTION_SDT_KEY INTERACTION_FACT_GI2.MEDIA_SERVER_IXN_GUID INTERACTION_FACT_GI2.MEDIA_SERVER_IXN_ID INTERACTION_FACT_GI2.MEDIA_SERVER_ROOT_IXN_ID INTERACTION_FACT_GI2.SOURCE_ADDRESS INTERACTION_FACT_GI2.START_DATE_TIME_KEY INTERACTION_FACT_GI2.START_TS_TIME INTERACTION_FACT_GI2.TARGET_ADDRESS INTERACTION_RESOURCE_FACT_GI2.END_TS_TIME INTERACTION_RESOURCE_FACT_GI2.INTERACTION_RESOURCE_ID INTERACTION_RESOURCE_FACT_GI2.INTERACTION_TYPE_KEY INTERACTION_RESOURCE_FACT_GI2.LAST_INTERACTION_RESOURCE INTERACTION_RESOURCE_FACT_GI2.LAST_QUEUE_RESOURCE_KEY INTERACTION_RESOURCE_FACT_GI2.LAST_VQUEUE_RESOURCE_KEY INTERACTION_RESOURCE_FACT_GI2.RESOURCE_GROUP_COMBINATION_KEY INTERACTION_RESOURCE_FACT_GI2.RESOURE_KEY INTERACTION_RESOURCE_FACT_GI2.START_DATE_TIME_KEY INTERACTION_RESOURCE_FACT_GI2.START_TS_TIME INTERACTION_RESOURCE_FACT_GI2.STOP_ACTION INTERACTION_RESOURCE_STATE_GI2.STATE_FULL_NAME INTERACTION_RES_FACT_GI2.INTERACTION_DSCRPTR_KEY_RCV INTERACTION_RES_FACT_TRNSFR.INTERACTION_TYPE_KEY INTERACTION_RES_FACT_TRNSFR_GI2.END_TS_TIME INTERACTION_RES_FACT_TRNSFR_GI2.IF_END_TS_TIME INTERACTION_RES_FACT_TRNSFR_GI2.IF_START_TS_TIME INTERACTION_RES_FACT_TRNSFR_GI2.INTERACTION_ID INTERACTION_RES_FACT_TRNSFR_GI2.INTERACTION_RESOURCE_ID INTERACTION_RES_FACT_TRNSFR_GI2.INTERACTION_RESOURCE_ID_RCV INTERACTION_RES_FACT_TRNSFR_GI2.LAST_QUEUE_RESOURCE_KEY INTERACTION_RES_FACT_TRNSFR_GI2.LAST_QUEUE_RES_KEY_RCV INTERACTION_RES_FACT_TRNSFR_GI2.LAST_VQUEUE_RESOURCE_KEY INTERACTION_RES_FACT_TRNSFR_GI2.LAST_VQUEUE_RES_KEY_RCV INTERACTION_RES_FACT_TRNSFR_GI2.MEDIA_SERVER_IXN_GUID INTERACTION_RES_FACT_TRNSFR_GI2.RESOURCE_KEY_RCV INTERACTION_RES_FACT_TRNSFR_GI2.SOURCE_ADDRESS INTERACTION_RES_FACT_TRNSFR_GI2.START_DATE_TIME_KEY_RCV INTERACTION_RES_FACT_TRNSFR_GI2.START_TS_TIME INTERACTION_RES_FACT_TRNSFR_GI2.START_TS_TIME_RCV INTERACTION_RES_FACT_TRNSFR_GI2.TARGET_ADDRESS INTERACTION_RES_FACT_TRNSFR_GI2.TECHNICAL_DSCRPTR_KEY_RCV INTERACTION_TYPE.[INTERACTION_TYPE_NAME] INTERACTION_TYPE.[INTERACTION_TYPE_SUBTYPE] INTERACTION_TYPE_GI2.INTERACTION_TYPE INTERACTION_TYPE_GI2.INTERACTION_TYPE_KEY INTERACTION_TYPE_GI2.INTERACTION_TYPE_SUBTYPE IRF_USER_DATA_CUST_*.INTERACTION_RESOURCE_ID IRF_USER_DATA_GEN_1.CASE_ID IRF_USER_DATA_GEN_1.CUSTOMER_ID IRF_USER_DATA_GEN_1.INTERACTION_RESOURCE_ID IRF_USER_DATA_KEYS.CUSTOM_KEY_1 IRF_USER_DATA_KEYS.INTERACTION_RESOURCE_ID IWD_AGG_TASK_*.DATE_TIME_KEY IWD_AGG_TASK_*_SUBHR.DATE_TIME_KEY IWD_AGG_TASK_AGENT_SUBHR.DATE_TIME_KEY IWD_AGG_TASK_CAPT_SUBHR.DATE_TIME_KEY IWD_AGG_TASK_CLASSIF_SUBHR.DATE_TIME_KEY IWD_AGG_TASK_QUEUE_SUBHR.DATE_TIME_KEY IWD_DATE_TIME_AGENT_DAY. DATE_TIME_KEY IWD_DATE_TIME_CAPT_DAY. DATE_TIME_KEY IWD_DATE_TIME_CLASSIF_DAY. DATE_TIME_KEY IWD_DATE_TIME_QUEUE_DAY. DATE_TIME_KEY IXN_RESOURCE_STATE_FACT_GI2.END_TS_TIME IXN_RESOURCE_STATE_FACT_GI2.START_TS_TIME MEDIA_NAME_CODE MEDIA_ORIGIN.MEDIA_ORIGIN MEDIA_TYPE MEDIA_TYPE. MEDIA_NAME MEDIA_TYPE.MEDIA_NAME MEDIA_TYPE.MEDIA_TYPE_KEY MEDIA_TYPE.[MEDIA_TYPE_NAME] PROCESS.CATEGORY_LEVEL10 PROCESS.CATEGORY_LEVEL3 PROCESS.CATEGORY_LEVEL4 PROCESS.CATEGORY_LEVEL5 PROCESS.CATEGORY_LEVEL6 PROCESS.CATEGORY_LEVEL7 PROCESS.CATEGORY_LEVEL8 PROCESS.CATEGORY_LEVEL9 QA_REVIEW_DISP_CODE.QA_REVIEW_DISP_CODE_NAME RELATIVE_RANGE.RANGE_NAME RELATIVE_RANGE_NAME.RANGE_NAME REQUESTED_SKILL_COMPBINATION.SKILL_COMPBINATION_STRING RESOURCE.RESOURCE_NAME RESOURCE_.RESOURCE_KEY RESOURCE_.RESOURCE_NAME RESOURCE_.RESOURCE_TYPE RESOURCE_A.RESOURCE_KEY RESOURCE_A_RESOURCE_KEY RESOURCE_GI2.AGENT_NAME RESOURCE_GROUP_COMBINATION.GROUP_COMBINATION_KEY RESOURCE_GROUP_COMBINATION.GROUP_KEY RESOURCE_GROUP_COMBINATION_Q.GROUP_COMBINATION_KEY RESOURCE_GROUP_FACT_GI2.END_TS RESOURCE_GROUP_FACT_GI2.END_TS_TIME RESOURCE_GROUP_FACT_GI2.GROUP_KEY RESOURCE_GROUP_FACT_GI2.RESOURCE_KEY RESOURCE_GROUP_FACT_GI2.START_DATE_TIME_KEY RESOURCE_GROUP_FACT_GI2.START_TS_TIME RESOURCE_IVR.RESOURCE_NAME RESOURCE_Q.RESOURCE_KEY RESOURCE_Q.RESOURCE_NAME (WHERE RESOURCE_TYPE_CODE='QUEUE') RESOURCE_Q.RESOURCE_NAME (WHERE RESOURCE_TYPE_CODE=’QUEUE’) RESOURCE_RCV_Q.RESOURCE_KEY RESOURCE_RCV_Q.RESOURCE_NAME RESOURCE_RCV_VQ.RESOURCE_NAME RESOURCE_STATE_REASON_GI2.HARDWARE_REASON RESOURCE_STATE_REASON_GI2.REASON_CODE RESOURCE_STATE_REASON_GI2.REASON_TYPE_CODE RESOURCE_STATE_REASON_GI2.SOFTWARE_REASON_KEY RESOURCE_STATE_REASON_GI2.SOFTWARE_REASON_VALUE RESOURCE_TARGET.RESOURCE_ID RESOURCE_TARGET.RESOURCE_KEY RESOURCE_TARGET.RESOURCE_NAME RESOURCE_TARGET.RESOURCE_TYPE RESOURCE_VQ.RESOURCE_KEY RESOURCE_VQ.RESOURCE_NAME RESOURCE_VQ.RESOURCE_NAME (WHERE RESOURCE_TYPE_CODE=’QUEUE’) RESULT_CODE.RESULT_CODE_NAME ROUTING_TARGET.AGENT_GROUP_NAME ROUTING_TARGET.ROUTING_TARGET_TYPE ROUTING_TARGET.TARGET_OBJECT_SELECTED SDR_ACTIVITIES_FACT.SDR_ACTIVITY_KEY SDR_ACTIVITY.ID SDR_ACTIVITY.NAME SDR_APPLICATION.APPLICATION_ID SDR_APPLICATION.APPLICATION_TITLE SDR_APPLICATION.CONCATBLANK(APPLICATION_TITLE SDR_APPLICATION.ID SDR_CALL_DISPOSITION.DISPOSITION_CATEGORY SDR_CALL_DISPOSITION.FINAL_DISPOSITION SDR_CALL_TYPE.CALL_TYPE SDR_ENTRY_POINT.DNIS SDR_EXIT_POINT.APPLICATION_EXIT_POINT SDR_GEO_LOCATION.COUNTRY.NAME SDR_GEO_LOCATION.REGION SDR_INPUT.INPUT_NAME SDR_LANGUAGE.LANGUAGE_NAME SDR_MILESTONE.MESSAGE_FILE SDR_MILESTONE.MILESTONE SDR_MILESTONE_BAILOUT.ID SDR_MILESTONE_DEFL.MILESTONE SDR_MILESTONE_MILESTONE SDR_SESSION_FACT*.SDR_APPLICATION_KEY SDR_SESSION_FACT.BAILOUT_SDR_MILESTONE_KEY SDR_SESSION_FACT.INTERACTION_ID SDR_SESSION_FACT.SESSION_DETAIL SDR_SESSION_FACT.SESSION_ID SDR_SESSION_FACT.START_DATE_TIME_KEY SDR_SESSION_FACT.STRIKEOUT_SDR_MILESTONE_KEY SDR_SURVEY_FACT.SESSION_ID SDR_SURVEY_FACT.START_DATE_TIME_KEY SDR_SURVEY_QUESTIONS.QUESTION SM_RES_SESSION_FACT_GI2.ACTIVE_FLAG SM_RES_SESSION_FACT_GI2.END_TS_TIME SM_RES_SESSION_FACT_GI2.RESOURCE_GROUP_COMBINATION_KEY SM_RES_SESSION_FACT_GI2.RESOURCE_KEY SM_RES_SESSION_FACT_GI2.SM_RES_SESSION_FACT_KEY SM_RES_SESSION_FACT_GI2.START_TS_TIME SM_RES_STATE_FACT_GI2.RESOURCE_GROUP_COMBINATION_KEY SM_RES_STATE_FACT_GI2.RESOURCE_KEY SM_RES_STATE_FACT_GI2.START_TS_TIME_ST SM_RES_STATE_REASON_FACT_GI2.RESOURCE_KEY SM_RES_STATE_RSN_FACT.ACTIVE_FLAG_RSN SM_RES_STATE_RSN_FACT.ACTIVE_FLAG_ST SM_RES_STATE_RSN_FACT.END_TS_TIME_ST SM_RES_STATE_RSN_FACT.RESOURCE_STATE_REASON_KEY SM_RES_STATE_RSN_FACT.START_TS_TIME_RSN STRATEGY.STRATEGY_NAME Shows data from the RESOURCE_ GIM table for resource_type_code=”QUEUE”. TASK_FACT.CAPTURE_ID TASK_WORK_FACT.CAPTURE_ID TECHNICAL_DESCRIPTOR.RESOURCE_ROLE TECHNICAL_DESCRIPTOR.RESULT_REASON TECHNICAL_DESCRIPTOR.ROLE_REASON TECHNICAL_DESCRIPTOR.TECHNICAL_RESULT TECHNICAL_DESCRIPTOR_RCV.RESOURCE_ROLE TECHNICAL_DESCRIPTOR_RCV.RESULT_REASON TECHNICAL_DESCRIPTOR_RCV.ROLE_REASON TECHNICAL_DESCRIPTOR_RCV.TECHNICAL_DESCRIPTOR_KEY TECHNICAL_DESCRIPTOR_RCV.TECHNICAL_RESULT USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_1 USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_2 USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_3 USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_4 USER_DATA_CUST_DIM_1.DIM_ATTRIBUTE_5 USER_DATA_CUST_DIM_2.DIM_ATTRIBUTE_1 USER_DATA_CUST_DIM_2.DIM_ATTRIBUTE_2 USER_DATA_CUST_DIM_2.DIM_ATTRIBUTE_3 USER_DATA_CUST_DIM_2.DIM_ATTRIBUTE_4 USER_DATA_CUST_DIM_2.DIM_ATTRIBUTE_5 USER_DATA_GEN_DIM_1.DIM_ATTRIBUTE_1 USER_DATA_GEN_DIM_1.DIM_ATTRIBUTE_2 USER_DATA_GEN_DIM_1.DIM_ATTRIBUTE_3 USER_DATA_GEN_DIM_1.DIM_ATTRIBUTE_4 USER_DATA_GEN_DIM_1.DIM_ATTRIBUTE_5 USER_DATA_GEN_DIM_2.DIM_ATTRIBUTE_1 USER_DATA_GEN_DIM_2.DIM_ATTRIBUTE_2 USER_DATA_GEN_DIM_2.DIM_ATTRIBUTE_3 USER_DATA_GEN_DIM_2.DIM_ATTRIBUTE_4 USER_DATA_GEN_DIM_2.DIM_ATTRIBUTE_5 USER_DATA_GEN_ES.CLASSIFY_ACTIONABILITY_CTGNAME USER_DATA_GEN_ES.CLASSIFY_SENTIMENT_CTGNAME USER_DATA_GEN_ES.CTGNAME USER_DATA_GEN_ES.GEN_ES_ID USER_DATA_GEN_ES.SCREEN_ACTIONABILITY_CTGNAME USER_DATA_GEN_ES.SCREEN_SENTIMENT_CTGNAME WHERE RESOURCE_TYPE_CODE=’QUEUE’ WORKBIN.WORKBIN_OWNER_NAME WORKBIN.WORKBIN_TYPE_CODE _SM_RES_STATE_FACT.RESOURCE_GROUP_COMBINATION_KEY _SM_RES_STATE_REASON_FAC.RESOURCE_KEY ag2_-_mn*.tenant_key ag2_agent*.tenant_key ag2_agent_bgs_session*.tenant_key ag2_agent_campaign*.tenant_key ag2_campaign*.tenant_key ag2_chat_agent*.tenant_key ag2_chat_stat*.tenant_key ag2_i_sess*.tenant_key ag2_i_state*.tenant_key ag2_id*.tenant_key ag2_queue*.tenant_key ag2_queue_abn*.time_range_key ag2_queue_acc*.time_range_key agr_scfg category.category_name ctl_schema_info.schema_name customer_segment.customer_segment_name media_channel.media_channel_name none one of the following or NULL: *ROUTING_TARGET.AGENT_GROUP_NAME *ROUTING_TARGET.PLACE_GROUP_NAME *ROUTING_TARGET.SKILL_EXPRESSION priority.priority_range_*_start process.process_name product.product_subtype product.product_type queue.queue_name scfg_key solution.solution_name source_process.source_process_subtype source_process.source_process_type source_tenant.source_tenant_name tenant.tenant_name ‘UNKNOWN’ ’NO VALUE’))

Agent State Details Report (2)

yes (2)

yes (2)

None (2)

None (2)

AgentDetailStateStartTimestamp (2)