109 tables
| Table | Description |
|---|---|
activity_code |
Catalog of Workforce Management (WFM) activity codes in Genesys Cloud. |
agent_schedules |
Weekly agent schedules in Genesys Cloud WFM. |
agent_schedules__shifts |
Shifts belonging “to” weekly agent schedules. |
agent_schedules__shifts__activities |
Planned activities within each agent schedule shift. |
agents_schedules |
Agent schedules returned by an alternative WFM endpoint. |
agents_schedules__full_day_time_off_markers |
Child table derived from the nested structure of agents_schedules extracted from Genesys Cloud. |
agents_schedules__shifts |
Child table derived from the nested structure of agents_schedules extracted from Genesys Cloud. |
agents_schedules__shifts__activities |
Child table derived from the nested structure of agents_schedules extracted from Genesys Cloud. |
bu_agent_schedules |
Table extracted from Genesys Cloud: bu_agent_schedules. |
bu_agent_schedules__shifts |
Child table derived from the nested structure of bu_agent_schedules extracted from Genesys Cloud. |
bu_agent_schedules__shifts__activities |
Child table derived from the nested structure of bu_agent_schedules extracted from Genesys Cloud. |
business_units |
Business units in Genesys Cloud Workforce Management. |
calibrations |
Quality calibrations associated with interaction evaluations. |
calibrations__evaluations |
Child table derived from the nested structure of calibrations extracted from Genesys Cloud. |
calibrations__evaluations__answers__question_group_scores |
Child table derived from the nested structure of calibrations extracted from Genesys Cloud. |
calibrations__evaluators |
Child table derived from the nested structure of calibrations extracted from Genesys Cloud. |
campaigns |
Outbound campaigns registered in Genesys Cloud. |
contact_lists |
Contact lists used in outbound campaigns. |
conversation_uni_yyyy_mm |
Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data. |
conversation_uni_yyyy_mm__division_ids |
Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data. |
conversation_uni_yyyy_mm__flow_outcomes |
Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data. |
conversations_messages |
Digital media conversations and messages. |
conversations_messages__messaging_transcript |
Child table derived from the nested structure of conversations_messages extracted from Genesys Cloud. |
conversations_messages__transcript |
Child table derived from the nested structure of conversations_messages extracted from Genesys Cloud. |
divisions |
Genesys Cloud organizational divisions. |
evaluation |
Interaction quality evaluations. |
evaluation__question_group_score |
Child table derived from the nested structure of evaluation extracted from Genesys Cloud. |
evaluation__question_group_score__question_scores |
Child table derived from the nested structure of evaluation extracted from Genesys Cloud. |
flow_outcomes |
Results of architected flows in Genesys Cloud Architect. |
form |
Quality evaluation forms. |
form__question_groups |
Child table derived from the nested structure of form extracted from Genesys Cloud. |
form__question_groups__questions |
Child table derived from the nested structure of form extracted from Genesys Cloud. |
form__question_groups__questions__answer_options |
Child table derived from the nested structure of form extracted from Genesys Cloud. |
genesys_queues |
Tabela auxiliar simplificada de queues from Genesys Cloud. |
genesys_users |
Tabela auxiliar simplificada de users from Genesys Cloud. |
groups |
Genesys Cloud groups. |
historical_adherence |
WFM adherence history by agent and interval. |
historical_adherence__daymetrics |
Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud. |
historical_adherence__exceptioninfo |
Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud. |
historical_adherence__offline_status |
Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud. |
intraday |
Intraday planning, forecast, and performance data. |
intraday__intraday_data_groupings |
Child table derived from the nested structure of intraday extracted from Genesys Cloud. |
intraday__intraday_data_groupings__forecast_data_per_interval |
Child table derived from the nested structure of intraday extracted from Genesys Cloud. |
intraday__intraday_data_groupings__performance_prediction_data_ |
Child table derived from the nested structure of intraday extracted from Genesys Cloud. |
intraday__intraday_data_groupings__schedule_data_per_interval |
Child table derived from the nested structure of intraday extracted from Genesys Cloud. |
management_unit |
Unidades de gerenciamento do Workforce Management. |
management_unit_adherences |
Current adherence state by user and management unit. |
management_unit_adherences__active_queues |
Child table derived from the nested structure of management_unit_adherences extracted from Genesys Cloud. |
management_unit_agent |
Vínculo do agent com management unit, work plan e rotação. |
management_unit_agent__languages |
Child table derived from the nested structure of management_unit_agent extracted from Genesys Cloud. |
management_unit_agent__queues |
Child table derived from the nested structure of management_unit_agent extracted from Genesys Cloud. |
management_unit_agent__skills |
Child table derived from the nested structure of management_unit_agent extracted from Genesys Cloud. |
management_unit_shift_trades_users |
Usuários elegíveis a trocas de turno. |
management_unit_users |
Relationship between users and management units. |
management_unit_week_shift_trades |
Trocas de turno weekly em management units. |
management_unit_week_shift_trades__acceptable_intervals |
Child table derived from the nested structure of management_unit_week_shift_trades extracted from Genesys Cloud. |
managementunit_agent_shift_trades |
Trocas de turno by agent em management unit. |
managementunit_agent_shift_trades__acceptable_intervals |
Child table derived from the nested structure of managementunit_agent_shift_trades extracted from Genesys Cloud. |
planning_group |
WFM planning groups. |
planning_group__route_paths |
Child table derived from the nested structure of planning_group extracted from Genesys Cloud. |
planning_group__route_paths__skills |
Child table derived from the nested structure of planning_group extracted from Genesys Cloud. |
planning_group_results |
Forecast results by planning group. |
planning_group_results__metric_results |
Child table derived from the nested structure of planning_group_results extracted from Genesys Cloud. |
presence |
Genesys Cloud presence definitions. |
queue_membership |
Relationship between queues and member users. |
queue_wrapup_code |
Wrap-up codes configured on queues. |
queues |
Genesys Cloud ACD queues. |
scheduling_runs |
Schedule generation engine runs. |
service_goal_template |
Templates de metas de serviço para forecast e WFM. |
short_term_forecast_planning_groups |
Planning groups returned in the short-term forecast context. |
short_term_forecast_planning_groups__route_paths |
Child table derived from the nested structure of short_term_forecast_planning_groups extracted from Genesys Cloud. |
short_term_forecast_planning_groups__route_paths__skills |
Child table derived from the nested structure of short_term_forecast_planning_groups extracted from Genesys Cloud. |
short_term_forecasts |
WFM short-term forecasts. |
short_term_forecasts_data |
Detailed short-term forecast data by planning group. |
speech_agents_empathy |
Agent empathy metrics by conversation. |
speech_participants |
Conversation participants analyzed by speech analytics. |
speech_topics |
Tópicos detectados nas conversations pelo speech analytics. |
speech_transcript_text |
Utterances detalhadas da transcrição textual. |
speech_transcript_text__topics |
Child table derived from the nested structure of speech_transcript_text extracted from Genesys Cloud. |
speech_transcripts |
Resumo analítico de speech and text analytics by conversation. |
speech_transcripts__topics |
Child table derived from the nested structure of speech_transcripts extracted from Genesys Cloud. |
speech_transcripts_text |
Text transcript collection metadata. |
status_script |
Script execution status control. |
superiors |
Hierarchical information about agents and their supervisors. |
user_adherence |
Current user adherence state. |
user_adherence__active_queues |
Child table derived from the nested structure of user_adherence extracted from Genesys Cloud. |
user_state |
User temporal states. |
users |
Genesys Cloud users. |
users__groups |
Child table derived from the nested structure of users extracted from Genesys Cloud. |
users__languages |
Child table derived from the nested structure of users extracted from Genesys Cloud. |
users__profile_skills |
Child table derived from the nested structure of users extracted from Genesys Cloud. |
users__skills |
Child table derived from the nested structure of users extracted from Genesys Cloud. |
users_aggregates |
User metric aggregates. |
users_aggregates__data |
Child table derived from the nested structure of users_aggregates extracted from Genesys Cloud. |
users_aggregates__data__metrics |
Child table derived from the nested structure of users_aggregates extracted from Genesys Cloud. |
users_state_metrics |
Aggregated user state metrics. |
week_schedule_generation_results |
Weekly schedule generation result. |
week_schedule_generation_results__messages |
Child table derived from the nested structure of week_schedule_generation_results extracted from Genesys Cloud. |
week_schedule_generation_results__messages__arguments |
Child table derived from the nested structure of week_schedule_generation_results extracted from Genesys Cloud. |
week_schedule_metadata |
Weekly schedule metadata. |
week_schedule_metadata__management_units |
Child table derived from the nested structure of week_schedule_metadata extracted from Genesys Cloud. |
week_schedule_metadata__management_units__agents |
Child table derived from the nested structure of week_schedule_metadata extracted from Genesys Cloud. |
week_schedules |
Weekly WFM schedules. |
work_plans |
WFM work plans. |
work_plans__agents |
Child table derived from the nested structure of work_plans extracted from Genesys Cloud. |
work_plans_rotations |
Work plan rotations. |
work_plans_rotations__agents |
Child table derived from the nested structure of work_plans_rotations extracted from Genesys Cloud. |
work_plans_rotations__pattern__work_plans |
Child table derived from the nested structure of work_plans_rotations extracted from Genesys Cloud. |
wrapup_code_mappings |
Wrap-up mappings for contact classifications. |

