Data sets

A data set is a container that holds data and information about that data’s structure, layout, and format. It is a single store of related data in the data model. This table lists the data sets that are part of the Calabrio ONE data model and the data fields (columns) that belong in each data set.

Data as of 20 May 2022

Data set name	Column name	Column type	Formula text	Included	Mapped	Mapped to
Absence Dimension	absence_code	STRING	[absence_code]	Yes	No
Absence Dimension	absence_id	NUMBER	[absence_id]	Yes	No
Absence Dimension	absence_name	STRING	[absence_name]	Yes	No
Absence Dimension	absence_shortname	STRING	[absence_shortname]	Yes	No
Absence Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Absence Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Absence Dimension	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Absence Dimension	display_color	STRING	[display_color]	Yes	No
Absence Dimension	display_color_html	STRING	[display_color_html]	Yes	No
Absence Dimension	in_contract_time	BOOLEAN	[in_contract_time]	Yes	No
Absence Dimension	in_contract_time_name	STRING	[in_contract_time_name]	Yes	No
Absence Dimension	in_paid_time	BOOLEAN	[in_paid_time]	Yes	No
Absence Dimension	in_paid_time_name	STRING	[in_paid_time_name]	Yes	No
Absence Dimension	in_work_time	BOOLEAN	[in_work_time]	Yes	No
Absence Dimension	in_work_time_name	STRING	[in_work_time_name]	Yes	No
Absence Dimension	insert_date	DATE	[insert_date]	Yes	No
Absence Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Absence Dimension	update_date	DATE	[update_date]	Yes	No
Activity Dimension	activity_code	STRING	[activity_code]	Yes	No
Activity Dimension	activity_id	NUMBER	[activity_id]	Yes	No
Activity Dimension	activity_name	STRING	[activity_name]	Yes	No
Activity Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Activity Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Activity Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Activity Dimension	display_color	NUMBER	[display_color]	Yes	No
Activity Dimension	display_color_html	STRING	[display_color_html]	Yes	No
Activity Dimension	in_contract_time	BOOLEAN	[in_contract_time]	Yes	No
Activity Dimension	in_contract_time_name	STRING	[in_contract_time_name]	Yes	No
Activity Dimension	in_paid_time	BOOLEAN	[in_paid_time]	Yes	No
Activity Dimension	in_paid_time_name	STRING	[in_paid_time_name]	Yes	No
Activity Dimension	in_ready_time	BOOLEAN	[in_ready_time]	Yes	No
Activity Dimension	in_ready_time_name	STRING	[in_ready_time_name]	Yes	No
Activity Dimension	in_work_time	BOOLEAN	[in_work_time]	Yes	No
Activity Dimension	in_work_time_name	STRING	[in_work_time_name]	Yes	No
Activity Dimension	insert_date	DATE	[insert_date]	Yes	No
Activity Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Activity Dimension	update_date	DATE	[update_date]	Yes	No
Adherence	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Adherence	insert_date	DATE	[insert_date]	Yes	No
Adherence	is_deleted	NUMBER	[is_deleted]	Yes	No
Adherence	last_updated	DATE	[last_updated]	Yes	No
Adherence	person_code	STRING	[person_code]	Yes	No
Adherence	person_id	NUMBER	[person_id]	Yes	No
Adherence	seconds_in_adherence	NUMBER	[seconds_in_adherence]	Yes	No
Adherence	seconds_in_neutral_adherence	NUMBER	[seconds_in_neutral_adherence]	Yes	No
Adherence	seconds_in_shift	NUMBER	[seconds_in_shift]	Yes	No
Adherence	seconds_late_for_work	NUMBER	[seconds_late_for_work]	Yes	No
Adherence	seconds_out_of_adherence	NUMBER	[seconds_out_of_adherence]	Yes	No
Adherence	shift_startdate_local	DATE	[shift_startdate_local]	Yes	No
Adherence	shift_startdate_local_id	NUMBER	[shift_startdate_local_id]	Yes	Yes	shift_startdate_local_id
Adherence	update_date	DATE	[update_date]	Yes	No
Adherence Details	absence_code	STRING	[absence_code]	Yes	No
Adherence Details	absence_id	NUMBER	[absence_id]	Yes	No
Adherence Details	activity_code	STRING	[activity_code]	Yes	No
Adherence Details	activity_end	DATE	[activity_end]	Yes	No
Adherence Details	activity_id	NUMBER	[activity_id]	Yes	No
Adherence Details	activity_start	DATE	[activity_start]	Yes	No
Adherence Details	adherence_change_id	NUMBER	[adherence_change_id]	Yes	No
Adherence Details	adherence_type	STRING	[adherence_type]	Yes	No
Adherence Details	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Adherence Details	in_adherence_duration_seconds	NUMBER	[in_adherence_duration_seconds]	Yes	No
Adherence Details	insert_date	DATE	[insert_date]	Yes	No
Adherence Details	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Adherence Details	last_updated	DATE	[last_updated]	Yes	No
Adherence Details	neutral_adherence_duration_seconds	NUMBER	[neutral_adherence_duration_seconds]	Yes	No
Adherence Details	out_of_adherence_duration_seconds	NUMBER	[out_of_adherence_duration_seconds]	Yes	No
Adherence Details	person_code	STRING	[person_code]	Yes	No
Adherence Details	person_id	NUMBER	[person_id]	Yes	No
Adherence Details	shift_startdate_local	DATE	[shift_startdate_local]	Yes	No
Adherence Details	shift_starttime	DATE	[shift_starttime]	Yes	Yes	Shift Starttime
Adherence Details	state_duration_seconds	NUMBER	[state_duration_seconds]	Yes	No
Adherence Details	stategroup_end	DATE	[stategroup_end]	Yes	No
Adherence Details	stategroup_id	STRING	[stategroup_id]	Yes	No
Adherence Details	stategroup_name	STRING	[stategroup_name]	Yes	No
Adherence Details	stategroup_start	DATE	[stategroup_start]	Yes	No
Adherence Details	update_date	DATE	[update_date]	Yes	No
Agent Queue Stats	acd_login_id	NUMBER	[acd_login_id]	Yes	No
Agent Queue Stats	after_call_work_time_s	NUMBER	[after_call_work_time_s]	Yes	No
Agent Queue Stats	answered_calls	NUMBER	[answered_calls]	Yes	No
Agent Queue Stats	completed_calls	NUMBER	[completed_calls]	Yes	No
Agent Queue Stats	datasource_id	NUMBER	[datasource_id]	Yes	No
Agent Queue Stats	date_interval	DATE	[date_interval]	Yes	No
Agent Queue Stats	hold_time_s	NUMBER	[hold_time_s]	Yes	No
Agent Queue Stats	insert_date	DATE	[insert_date]	Yes	No
Agent Queue Stats	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Agent Queue Stats	last_updated	DATE	[last_updated]	Yes	No
Agent Queue Stats	queue_id	NUMBER	[queue_id]	Yes	No
Agent Queue Stats	talk_time_s	NUMBER	[talk_time_s]	Yes	No
Agent Queue Stats	transfered_calls	NUMBER	[transfered_calls]	Yes	No
Agent Skills	active	BOOLEAN	[active]	Yes	No
Agent Skills	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Agent Skills	datasource_id	NUMBER	[datasource_id]	Yes	No
Agent Skills	has_skill	NUMBER	[has_skill]	Yes	No
Agent Skills	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Agent Skills	last_updated	DATE	[last_updated]	Yes	No
Agent Skills	person_id	NUMBER	[person_id]	Yes	No
Agent Skills	skill_id	NUMBER	[skill_id]	Yes	No
Agent Stats	acd_login_id	NUMBER	[acd_login_id]	Yes	No
Agent Stats	admin_time_s	NUMBER	[admin_time_s]	Yes	No
Agent Stats	datasource_id	NUMBER	[datasource_id]	Yes	No
Agent Stats	date_interval	DATE	[date_interval]	Yes	No
Agent Stats	direct_incoming_calls	NUMBER	[direct_incoming_calls]	Yes	No
Agent Stats	direct_incoming_calls_talk_time_s	NUMBER	[direct_incoming_calls_talk_time_s]	Yes	No
Agent Stats	direct_outbound_calls	NUMBER	[direct_outbound_calls]	Yes	No
Agent Stats	direct_outbound_talk_time_s	NUMBER	[direct_outbound_talk_time_s]	Yes	No
Agent Stats	idle_time_s	NUMBER	[idle_time_s]	Yes	No
Agent Stats	insert_date	DATE	[insert_date]	Yes	No
Agent Stats	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Agent Stats	last_updated	DATE	[last_updated]	Yes	No
Agent Stats	logged_in_time_s	NUMBER	[logged_in_time_s]	Yes	No
Agent Stats	not_ready_time_s	NUMBER	[not_ready_time_s]	Yes	No
Agent Stats	ready_time_s	NUMBER	[ready_time_s]	Yes	Yes	Ready Time (hh:mm:ss)
Bridge Acd Login Person	acd_login_id	NUMBER	[acd_login_id]	Yes	No
Bridge Acd Login Person	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Bridge Acd Login Person	datasource_id	NUMBER	[datasource_id]	Yes	No
Bridge Acd Login Person	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Bridge Acd Login Person	insert_date	DATE	[insert_date]	Yes	No
Bridge Acd Login Person	person_id	NUMBER	[person_id]	Yes	No
Bridge Acd Login Person	team_id	NUMBER	[team_id]	Yes	No
Bridge Acd Login Person	update_date	DATE	[update_date]	Yes	No
Bridge Group Page Person	datasource_id	NUMBER	[datasource_id]	Yes	No
Bridge Group Page Person	group_page_id	NUMBER	[group_page_id]	Yes	No
Bridge Group Page Person	insert_date	DATE	[insert_date]	Yes	No
Bridge Group Page Person	person_id	NUMBER	[person_id]	Yes	No
Bridge Queue Workload	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Bridge Queue Workload	datasource_id	NUMBER	[datasource_id]	Yes	No
Bridge Queue Workload	datasource_update_date	DATE	[datasource_update_date]	No	No
Bridge Queue Workload	insert_date	DATE	[insert_date]	Yes	No
Bridge Queue Workload	queue_id	NUMBER	[queue_id]	Yes	No
Bridge Queue Workload	skill_id	NUMBER	[skill_id]	Yes	No
Bridge Queue Workload	update_date	DATE	[update_date]	Yes	No
Bridge Queue Workload	workload_id	NUMBER	[workload_id]	Yes	No
Business Unit Dimension	business_unit_code	STRING	[business_unit_code]	Yes	No
Business Unit Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Business Unit Dimension	business_unit_name	STRING	[business_unit_name]	Yes	No
Business Unit Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Business Unit Dimension	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Business Unit Dimension	insert_date	DATE	[insert_date]	Yes	No
Business Unit Dimension	update_date	DATE	[update_date]	Yes	No
Day Off Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Day Off Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Day Off Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Day Off Dimension	day_off_code	STRING	[day_off_code]	Yes	No
Day Off Dimension	day_off_id	NUMBER	[day_off_id]	Yes	No
Day Off Dimension	day_off_name	STRING	[day_off_name]	Yes	No
Day Off Dimension	day_off_shortname	STRING	[day_off_shortname]	Yes	No
Day Off Dimension	display_color	STRING	[display_color]	Yes	No
Day Off Dimension	display_color_html	STRING	[display_color_html]	Yes	No
Day Off Dimension	insert_date	DATE	[insert_date]	Yes	No
Day Off Dimension	update_date	DATE	[update_date]	Yes	No
External Logon Dimension	acd_login_agg_id	NUMBER	[acd_login_agg_id]	Yes	No
External Logon Dimension	acd_login_id	NUMBER	[acd_login_id]	Yes	No
External Logon Dimension	acd_login_name	STRING	[acd_login_name]	Yes	No
External Logon Dimension	acd_login_original_id	STRING	[acd_login_original_id]	Yes	No
External Logon Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
External Logon Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
External Logon Dimension	insert_date	DATE	[insert_date]	Yes	No
External Logon Dimension	is_active	BOOLEAN	[is_active]	Yes	No
External Logon Dimension	log_object_name	STRING	[log_object_name]	Yes	No
External Logon Dimension	time_zone_id	NUMBER	[time_zone_id]	Yes	No
External Logon Dimension	update_date	DATE	[update_date]	Yes	No
Forecast Skill vs Schedule	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Forecast Skill vs Schedule	datasource_id	NUMBER	[datasource_id]	Yes	No
Forecast Skill vs Schedule	date_interval	DATE	[date_interval]	Yes	No
Forecast Skill vs Schedule	estimated_tasks_answered_within_sl	NUMBER	[estimated_tasks_answered_within_sl]	Yes	No
Forecast Skill vs Schedule	estimated_tasks_answered_within_sl_incl_shrinkage	NUMBER	[estimated_tasks_answered_within_sl_incl_shrinkage]	Yes	No
Forecast Skill vs Schedule	forecasted_resources	NUMBER	[forecasted_resources]	Yes	No
Forecast Skill vs Schedule	forecasted_resources_incl_shrinkage	NUMBER	[forecasted_resources_incl_shrinkage]	Yes	No
Forecast Skill vs Schedule	forecasted_resources_incl_shrinkage_m	NUMBER	[forecasted_resources_incl_shrinkage_m]	Yes	No
Forecast Skill vs Schedule	forecasted_resources_m	NUMBER	[forecasted_resources_m]	Yes	No
Forecast Skill vs Schedule	forecasted_tasks	NUMBER	[forecasted_tasks]	Yes	No
Forecast Skill vs Schedule	forecasted_tasks_incl_shrinkage	NUMBER	[forecasted_tasks_incl_shrinkage]	Yes	No
Forecast Skill vs Schedule	insert_date	DATE	[insert_date]	Yes	No
Forecast Skill vs Schedule	intraday_deviation_m	NUMBER	[intraday_deviation_m]	Yes	No
Forecast Skill vs Schedule	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Forecast Skill vs Schedule	last_updated	DATE	[last_updated]	Yes	No
Forecast Skill vs Schedule	relative_difference	NUMBER	[relative_difference]	Yes	No
Forecast Skill vs Schedule	scenario_id	NUMBER	[scenario_id]	Yes	No
Forecast Skill vs Schedule	scheduled_resources	NUMBER	[scheduled_resources]	Yes	No
Forecast Skill vs Schedule	scheduled_resources_incl_shrinkage	NUMBER	[scheduled_resources_incl_shrinkage]	Yes	No
Forecast Skill vs Schedule	scheduled_resources_incl_shrinkage_m	NUMBER	[scheduled_resources_incl_shrinkage_m]	Yes	No
Forecast Skill vs Schedule	scheduled_resources_m	NUMBER	[scheduled_resources_m]	Yes	No
Forecast Skill vs Schedule	skill_id	NUMBER	[skill_id]	Yes	No
Forecast Skill vs Schedule	update_date	DATE	[update_date]	Yes	No
Forecast Workload	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Forecast Workload	datasource_id	NUMBER	[datasource_id]	Yes	No
Forecast Workload	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Forecast Workload	date_interval	DATE	[date_interval]	Yes	No
Forecast Workload	end_time	DATE	[end_time]	Yes	No
Forecast Workload	forecasted_after_call_work_excl_campaign_s	NUMBER	[forecasted_after_call_work_excl_campaign_s]	Yes	No
Forecast Workload	forecasted_after_call_work_s	NUMBER	[forecasted_after_call_work_s]	Yes	No
Forecast Workload	forecasted_backoffice_tasks	NUMBER	[forecasted_backoffice_tasks]	Yes	No
Forecast Workload	forecasted_calls	NUMBER	[forecasted_calls]	Yes	No
Forecast Workload	forecasted_calls_excl_campaign	NUMBER	[forecasted_calls_excl_campaign]	Yes	Yes	Forecasted Calls excl Campaign
Forecast Workload	forecasted_campaign_after_call_work_s	NUMBER	[forecasted_campaign_after_call_work_s]	Yes	Yes	forecasted_campaign_after_call_work_s
Forecast Workload	forecasted_campaign_calls	NUMBER	[forecasted_campaign_calls]	Yes	Yes	forecasted_campaign_calls
Forecast Workload	forecasted_campaign_handling_time_s	NUMBER	[forecasted_campaign_handling_time_s]	Yes	Yes	forecasted_campaign_handling_time_s
Forecast Workload	forecasted_campaign_talk_time_s	NUMBER	[forecasted_campaign_talk_time_s]	Yes	Yes	forecasted_campaign_talk_time_s
Forecast Workload	forecasted_emails	NUMBER	[forecasted_emails]	Yes	No
Forecast Workload	forecasted_handling_time_excl_campaign_s	NUMBER	[forecasted_handling_time_excl_campaign_s]	Yes	No
Forecast Workload	forecasted_handling_time_s	NUMBER	[forecasted_handling_time_s]	Yes	No
Forecast Workload	forecasted_talk_time_excl_campaign_s	NUMBER	[forecasted_talk_time_excl_campaign_s]	Yes	No
Forecast Workload	forecasted_talk_time_s	NUMBER	[forecasted_talk_time_s]	Yes	No
Forecast Workload	insert_date	STRING	[insert_date]	Yes	No
Forecast Workload	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Forecast Workload	last_updated	STRING	[last_updated]	Yes	No
Forecast Workload	period_length_min	NUMBER	[period_length_min]	Yes	No
Forecast Workload	scenario_id	NUMBER	[scenario_id]	Yes	No
Forecast Workload	skill_id	NUMBER	[skill_id]	Yes	No
Forecast Workload	update_date	STRING	[update_date]	Yes	No
Forecast Workload	workload_id	NUMBER	[workload_id]	Yes	No
Group Page Dimension	business_unit_code	STRING	[business_unit_code]	Yes	No
Group Page Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Group Page Dimension	business_unit_name	STRING	[business_unit_name]	Yes	No
Group Page Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Group Page Dimension	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Group Page Dimension	group_code	STRING	[group_code]	Yes	No
Group Page Dimension	group_id	NUMBER	[group_id]	Yes	No
Group Page Dimension	group_is_custom	NUMBER	[group_is_custom]	Yes	No
Group Page Dimension	group_name	STRING	[group_name]	Yes	No
Group Page Dimension	group_page_code	STRING	[group_page_code]	Yes	No
Group Page Dimension	group_page_id	NUMBER	[group_page_id]	Yes	No
Group Page Dimension	group_page_name	STRING	[group_page_name]	Yes	No
Group Page Dimension	group_page_name_resource_key	STRING	[group_page_name_resource_key]	Yes	No
Group Page Dimension	insert_date	STRING	[insert_date]	Yes	No
Hourly Availability	available_days	NUMBER	[available_days]	Yes	No
Hourly Availability	available_time_m	NUMBER	[available_time_m]	Yes	No
Hourly Availability	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Hourly Availability	datasource_id	NUMBER	[datasource_id]	Yes	No
Hourly Availability	date	DATE	[date]	Yes	No
Hourly Availability	date_id	STRING	[date_id]	Yes	No
Hourly Availability	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Hourly Availability	last_updated	DATE	[last_updated]	Yes	No
Hourly Availability	person_id	NUMBER	[person_id]	Yes	No
Hourly Availability	scenario_id	NUMBER	[scenario_id]	Yes	No
Hourly Availability	scheduled_days	NUMBER	[scheduled_days]	Yes	No
Hourly Availability	scheduled_time_m	NUMBER	[scheduled_time_m]	Yes	No
Overtime Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Overtime Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Overtime Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Overtime Dimension	insert_date	DATE	[insert_date]	Yes	No
Overtime Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Overtime Dimension	overtime_code	STRING	[overtime_code]	Yes	No
Overtime Dimension	overtime_id	NUMBER	[overtime_id]	Yes	No
Overtime Dimension	overtime_name	STRING	[overtime_name]	Yes	No
Overtime Dimension	update_date	DATE	[update_date]	Yes	No
Person Dimension	business_unit_code	STRING	[business_unit_code]	Yes	No
Person Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Person Dimension	business_unit_name	STRING	[business_unit_name]	Yes	No
Person Dimension	contract_code	STRING	[contract_code]	Yes	No
Person Dimension	contract_name	STRING	[contract_name]	Yes	No
Person Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Person Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Person Dimension	email	STRING	[email]	Yes	No
Person Dimension	employment_end_date	DATE	[employment_end_date]	Yes	No
Person Dimension	employment_number	STRING	[employment_number]	Yes	No
Person Dimension	employment_start_date	DATE	[employment_start_date]	Yes	No
Person Dimension	employment_type_code	STRING	[employment_type_code]	Yes	No
Person Dimension	employment_type_name	STRING	[employment_type_name]	Yes	No
Person Dimension	first_name	STRING	[first_name]	Yes	No
Person Dimension	insert_date	DATE	[insert_date]	Yes	No
Person Dimension	is_agent	NUMBER	[is_agent]	Yes	No
Person Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Person Dimension	is_user	NUMBER	[is_user]	Yes	No
Person Dimension	last_name	STRING	[last_name]	Yes	No
Person Dimension	last_updated	STRING	[last_updated]	Yes	No
Person Dimension	note	STRING	[note]	Yes	No
Person Dimension	parttime_code	STRING	[parttime_code]	Yes	No
Person Dimension	parttime_percentage	STRING	[parttime_percentage]	Yes	No
Person Dimension	person_code	STRING	[person_code]	Yes	No
Person Dimension	person_id	NUMBER	[person_id]	Yes	No
Person Dimension	person_name	STRING	[person_name]	Yes	No
Person Dimension	person_period_code	STRING	[person_period_code]	Yes	No
Person Dimension	site_code	STRING	[site_code]	Yes	No
Person Dimension	site_id	NUMBER	[site_id]	Yes	No
Person Dimension	site_name	STRING	[site_name]	Yes	No
Person Dimension	skillset_id	NUMBER	[skillset_id]	Yes	No
Person Dimension	team_code	STRING	[team_code]	Yes	No
Person Dimension	team_id	NUMBER	[team_id]	Yes	No
Person Dimension	team_name	STRING	[team_name]	Yes	No
Person Dimension	time_zone_id	NUMBER	[time_zone_id]	Yes	No
Person Dimension	to_be_deleted	NUMBER	[to_be_deleted]	Yes	No
Person Dimension	update_date	DATE	[update_date]	Yes	No
Person Dimension	valid_from_date	DATE	[valid_from_date]	Yes	No
Person Dimension	valid_from_date_local	DATE	[valid_from_date_local]	Yes	No
Person Dimension	valid_to_date	DATE	[valid_to_date]	Yes	No
Person Dimension	valid_to_date_local	DATE	[valid_to_date_local]	Yes	No
Person Dimension	windows_domain	STRING	[windows_domain]	Yes	No
Person Dimension	windows_username	STRING	[windows_username]	Yes	No
Preference Type Dimension	preference_type_id	NUMBER	[preference_type_id]	Yes	No
Preference Type Dimension	preference_type_name	STRING	[preference_type_name]	Yes	No
Preference Type Dimension	resource_key	STRING	[resource_key]	Yes	No
Preferences	absence_id	NUMBER	[absence_id]	Yes	No
Preferences	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Preferences	datasource_id	NUMBER	[datasource_id]	Yes	No
Preferences	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Preferences	date_id	STRING	[date_id]	Yes	No
Preferences	date_interval	DATE	[date_interval]	Yes	No
Preferences	day_off_id	NUMBER	[day_off_id]	Yes	No
Preferences	insert_date	DATE	[insert_date]	Yes	No
Preferences	interval_id	STRING	[interval_id]	Yes	No
Preferences	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Preferences	last_updated	STRING	[last_updated]	Yes	No
Preferences	must_haves	NUMBER	[must_haves]	Yes	No
Preferences	person_id	NUMBER	[person_id]	Yes	No
Preferences	preference_type_id	NUMBER	[preference_type_id]	Yes	No
Preferences	preferences_fulfilled	NUMBER	[preferences_fulfilled]	Yes	No
Preferences	preferences_requested	NUMBER	[preferences_requested]	Yes	No
Preferences	preferences_unfulfilled	NUMBER	[preferences_unfulfilled]	Yes	No
Preferences	scenario_id	NUMBER	[scenario_id]	Yes	No
Preferences	shift_category_id	NUMBER	[shift_category_id]	Yes	No
Preferences	update_date	DATE	[update_date]	Yes	No
Queue Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Queue Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Queue Dimension	insert_date	DATE	[insert_date]	Yes	No
Queue Dimension	log_object_name	STRING	[log_object_name]	Yes	No
Queue Dimension	queue_agg_id	NUMBER	[queue_agg_id]	Yes	No
Queue Dimension	queue_description	STRING	[queue_description]	Yes	No
Queue Dimension	queue_id	NUMBER	[queue_id]	Yes	No
Queue Dimension	queue_name	STRING	[queue_name]	Yes	No
Queue Dimension	queue_original_id	STRING	[queue_original_id]	Yes	No
Queue Dimension	update_date	DATE	[update_date]	Yes	No
Queue Stats	abandoned_calls	NUMBER	[abandoned_calls]	Yes	No
Queue Stats	abandoned_calls_within_sl	NUMBER	[abandoned_calls_within_sl]	Yes	Yes	Abandoned Calls Within SL
Queue Stats	abandoned_calls_within_SL	STRING	[abandoned_calls_within_SL]	Yes	No
Queue Stats	abandoned_short_calls	NUMBER	[abandoned_short_calls]	Yes	Yes	Abandoned Short Calls
Queue Stats	after_call_work_s	NUMBER	[after_call_work_s]	Yes	No
Queue Stats	answered_calls	NUMBER	[answered_calls]	Yes	No
Queue Stats	answered_calls_within_sl	NUMBER	[answered_calls_within_sl]	Yes	Yes	Answered Volume Within SL
Queue Stats	answered_calls_within_SL	STRING	[answered_calls_within_SL]	Yes	No
Queue Stats	completed_calls	NUMBER	[completed_calls]	Yes	No
Queue Stats	datasource_id	NUMBER	[datasource_id]	Yes	No
Queue Stats	date_id	NUMBER	[date_id]	Yes	No
Queue Stats	date_interval	DATE	[date_interval]	Yes	No
Queue Stats	handle_time_s	NUMBER	[handle_time_s]	Yes	No
Queue Stats	hold_time_s	NUMBER	[hold_time_s]	Yes	No
Queue Stats	insert_date	DATE	[insert_date]	Yes	No
Queue Stats	interval_id	NUMBER	[interval_id]	Yes	No
Queue Stats	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Queue Stats	last_updated	DATE	[last_updated]	Yes	No
Queue Stats	longest_delay_in_queue_abandoned_s	NUMBER	[longest_delay_in_queue_abandoned_s]	Yes	No
Queue Stats	longest_delay_in_queue_answered_s	NUMBER	[longest_delay_in_queue_answered_s]	Yes	No
Queue Stats	offered_calls	NUMBER	[offered_calls]	Yes	No
Queue Stats	overflow_in_calls	NUMBER	[overflow_in_calls]	Yes	No
Queue Stats	overflow_out_calls	NUMBER	[overflow_out_calls]	Yes	No
Queue Stats	queue_id	NUMBER	[queue_id]	Yes	No
Queue Stats	speed_of_answer_s	NUMBER	[speed_of_answer_s]	Yes	No
Queue Stats	talk_time_s	NUMBER	[talk_time_s]	Yes	No
Queue Stats	time_to_abandon_s	NUMBER	[time_to_abandon_s]	Yes	No
Queue Stats	update_date	STRING	[update_date]	Yes	No
Request Status Dimension	request_status_id	NUMBER	[request_status_id]	Yes	No
Request Status Dimension	request_status_name	STRING	[request_status_name]	Yes	No
Request Status Dimension	resource_key	STRING	[resource_key]	Yes	No
Request Type Dimension	request_type_id	NUMBER	[request_type_id]	Yes	No
Request Type Dimension	request_type_name	STRING	[request_type_name]	Yes	No
Request Type Dimension	resource_key	STRING	[resource_key]	Yes	No
Requested Days	absence_id	NUMBER	[absence_id]	Yes	No
Requested Days	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Requested Days	datasource_id	NUMBER	[datasource_id]	Yes	No
Requested Days	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Requested Days	insert_date	STRING	[insert_date]	Yes	No
Requested Days	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Requested Days	last_updated	STRING	[last_updated]	Yes	No
Requested Days	person_id	NUMBER	[person_id]	Yes	No
Requested Days	request_code	STRING	[request_code]	Yes	No
Requested Days	request_date	STRING	[request_date]	Yes	No
Requested Days	request_date_id	STRING	[request_date_id]	Yes	No
Requested Days	request_day_count	NUMBER	[request_day_count]	Yes	No
Requested Days	request_status_id	NUMBER	[request_status_id]	Yes	No
Requested Days	request_type_id	NUMBER	[request_type_id]	Yes	No
Requested Days	update_date	STRING	[update_date]	Yes	No
Requests	absence_id	NUMBER	[absence_id]	Yes	No
Requests	application_datetime	DATE	[application_datetime]	Yes	No
Requests	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Requests	datasource_id	NUMBER	[datasource_id]	Yes	No
Requests	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Requests	insert_date	DATE	[insert_date]	Yes	No
Requests	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Requests	last_updated	DATE	[last_updated]	Yes	No
Requests	person_id	NUMBER	[person_id]	Yes	No
Requests	request_code	STRING	[request_code]	Yes	No
Requests	request_day_count	NUMBER	[request_day_count]	Yes	No
Requests	request_enddate	DATE	[request_enddate]	Yes	No
Requests	request_endtime	DATE	[request_endtime]	Yes	No
Requests	request_start_date_count	NUMBER	[request_start_date_count]	Yes	No
Requests	request_startdate	DATE	[request_startdate]	Yes	No
Requests	request_starttime	DATE	[request_starttime]	Yes	No
Requests	request_status_id	NUMBER	[request_status_id]	Yes	No
Requests	request_type_id	NUMBER	[request_type_id]	Yes	No
Requests	requested_time_m	NUMBER	[requested_time_m]	Yes	No
Requests	update_date	DATE	[update_date]	Yes	No
Scenario Dimension	business_unit_code	STRING	[business_unit_code]	Yes	No
Scenario Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Scenario Dimension	business_unit_name	STRING	[business_unit_name]	Yes	No
Scenario Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Scenario Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Scenario Dimension	default_scenario	BOOLEAN	[default_scenario]	Yes	No
Scenario Dimension	insert_date	DATE	[insert_date]	Yes	No
Scenario Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Scenario Dimension	scenario_code	STRING	[scenario_code]	Yes	No
Scenario Dimension	scenario_id	NUMBER	[scenario_id]	Yes	No
Scenario Dimension	scenario_name	STRING	[scenario_name]	Yes	No
Scenario Dimension	update_date	DATE	[update_date]	Yes	No
Schedule Deviation	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Schedule Deviation	contract_time_s	NUMBER	[contract_time_s]	Yes	No
Schedule Deviation	datasource_id	NUMBER	[datasource_id]	Yes	No
Schedule Deviation	date_interval	DATE	[date_interval]	Yes	No
Schedule Deviation	deviation_contract_s	NUMBER	[deviation_contract_s]	Yes	No
Schedule Deviation	deviation_schedule_ready_s	NUMBER	[deviation_schedule_ready_s]	Yes	No
Schedule Deviation	deviation_schedule_s	NUMBER	[deviation_schedule_s]	Yes	No
Schedule Deviation	insert_date	DATE	[insert_date]	Yes	No
Schedule Deviation	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Schedule Deviation	is_logged_in	STRING	[is_logged_in]	Yes	No
Schedule Deviation	last_updated	DATE	[last_updated]	Yes	No
Schedule Deviation	person_id	NUMBER	[person_id]	Yes	No
Schedule Deviation	ready_time_s	NUMBER	[ready_time_s]	Yes	Yes	Ready Time (hh:mm:ss)
Schedule Deviation	scheduled_ready_time_s	NUMBER	[scheduled_ready_time_s]	Yes	No
Schedule Deviation	shift_startdate_interval	DATE	[shift_startdate_interval]	Yes	No
Schedule Deviation	update_date	DATE	[update_date]	Yes	No
Scheduled Agent Days	absence_id	NUMBER	[absence_id]	Yes	No
Scheduled Agent Days	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Scheduled Agent Days	datasource_id	NUMBER	[datasource_id]	Yes	No
Scheduled Agent Days	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Scheduled Agent Days	day_count	NUMBER	[day_count]	Yes	No
Scheduled Agent Days	day_off_id	NUMBER	[day_off_id]	Yes	No
Scheduled Agent Days	insert_date	DATE	[insert_date]	Yes	No
Scheduled Agent Days	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Scheduled Agent Days	last_updated	DATE	[last_updated]	Yes	No
Scheduled Agent Days	person_id	NUMBER	[person_id]	Yes	No
Scheduled Agent Days	projection_version	STRING	[projection_version]	Yes	No
Scheduled Agent Days	scenario_id	NUMBER	[scenario_id]	Yes	No
Scheduled Agent Days	shift_category_id	NUMBER	[shift_category_id]	Yes	No
Scheduled Agent Days	shift_startdate_local	DATE	[shift_startdate_local]	Yes	No
Scheduled Agent Days	shift_startdate_local_id	NUMBER	[shift_startdate_local_id]	Yes	Yes	shift_startdate_local_id
Scheduled Agent Days	starttime	DATE	[starttime]	Yes	No
Scheduled Agent Days	update_date	DATE	[update_date]	Yes	No
Scheduled Agent Time	absence_id	NUMBER	[absence_id]	Yes	No
Scheduled Agent Time	activity_endtime	DATE	[activity_endtime]	Yes	No
Scheduled Agent Time	activity_id	NUMBER	[activity_id]	Yes	No
Scheduled Agent Time	activity_starttime	DATE	[activity_starttime]	Yes	Yes	Activity Starttime
Scheduled Agent Time	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Scheduled Agent Time	datasource_id	NUMBER	[datasource_id]	Yes	No
Scheduled Agent Time	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Scheduled Agent Time	insert_date	DATE	[insert_date]	Yes	No
Scheduled Agent Time	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Scheduled Agent Time	last_updated	DATE	[last_updated]	Yes	No
Scheduled Agent Time	overtime_id	NUMBER	[overtime_id]	Yes	No
Scheduled Agent Time	person_id	NUMBER	[person_id]	Yes	No
Scheduled Agent Time	planned_overtime_m	NUMBER	[planned_overtime_m]	Yes	No
Scheduled Agent Time	projection_version	STRING	[projection_version]	Yes	No
Scheduled Agent Time	scenario_id	NUMBER	[scenario_id]	Yes	No
Scheduled Agent Time	schedule_date_interval	DATE	[schedule_date_interval]	Yes	No
Scheduled Agent Time	scheduled_contract_time_absence_m	NUMBER	[scheduled_contract_time_absence_m]	Yes	No
Scheduled Agent Time	scheduled_contract_time_activity_m	NUMBER	[scheduled_contract_time_activity_m]	Yes	No
Scheduled Agent Time	scheduled_contract_time_m	NUMBER	[scheduled_contract_time_m]	Yes	No
Scheduled Agent Time	scheduled_over_time_m	NUMBER	[scheduled_over_time_m]	Yes	No
Scheduled Agent Time	scheduled_paid_time_absence_m	NUMBER	[scheduled_paid_time_absence_m]	Yes	No
Scheduled Agent Time	scheduled_paid_time_activity_m	NUMBER	[scheduled_paid_time_activity_m]	Yes	No
Scheduled Agent Time	scheduled_paid_time_m	NUMBER	[scheduled_paid_time_m]	Yes	No
Scheduled Agent Time	scheduled_ready_time_m	NUMBER	[scheduled_ready_time_m]	Yes	No
Scheduled Agent Time	scheduled_time_absence_m	NUMBER	[scheduled_time_absence_m]	Yes	No
Scheduled Agent Time	scheduled_time_activity_m	NUMBER	[scheduled_time_activity_m]	Yes	No
Scheduled Agent Time	scheduled_time_m	NUMBER	[scheduled_time_m]	Yes	No
Scheduled Agent Time	scheduled_work_time_absence_m	NUMBER	[scheduled_work_time_absence_m]	Yes	No
Scheduled Agent Time	scheduled_work_time_activity_m	NUMBER	[scheduled_work_time_activity_m]	Yes	No
Scheduled Agent Time	scheduled_work_time_m	NUMBER	[scheduled_work_time_m]	Yes	No
Scheduled Agent Time	shift_category_id	NUMBER	[shift_category_id]	Yes	No
Scheduled Agent Time	shift_endtime	DATE	[shift_endtime]	Yes	No
Scheduled Agent Time	shift_length_id	NUMBER	[shift_length_id]	Yes	No
Scheduled Agent Time	shift_starttime	DATE	[shift_starttime]	Yes	Yes	Shift Starttime
Scheduled Agent Time	update_date	DATE	[update_date]	Yes	No
Shift Category Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Shift Category Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Shift Category Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Shift Category Dimension	display_color	STRING	[display_color]	Yes	No
Shift Category Dimension	insert_date	DATE	[insert_date]	Yes	No
Shift Category Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Shift Category Dimension	shift_category_code	STRING	[shift_category_code]	Yes	No
Shift Category Dimension	shift_category_id	NUMBER	[shift_category_id]	Yes	No
Shift Category Dimension	shift_category_name	STRING	[shift_category_name]	Yes	No
Shift Category Dimension	shift_category_shortname	STRING	[shift_category_shortname]	Yes	No
Shift Category Dimension	update_date	DATE	[update_date]	Yes	No
Shift Length Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Shift Length Dimension	insert_date	DATE	[insert_date]	Yes	No
Shift Length Dimension	shift_length_h	NUMBER	[shift_length_h]	Yes	No
Shift Length Dimension	shift_length_id	NUMBER	[shift_length_id]	Yes	No
Shift Length Dimension	shift_length_m	NUMBER	[shift_length_m]	Yes	No
Shift Length Dimension	update_date	DATE	[update_date]	Yes	No
Site Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Site Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Site Dimension	datasource_update_date	STRING	[datasource_update_date]	No	No
Site Dimension	insert_date	DATE	[insert_date]	Yes	No
Site Dimension	site_code	STRING	[site_code]	Yes	No
Site Dimension	site_id	NUMBER	[site_id]	Yes	No
Site Dimension	site_name	STRING	[site_name]	Yes	No
Site Dimension	update_date	DATE	[update_date]	Yes	No
Skill Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Skill Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Skill Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Skill Dimension	forecast_method_code	STRING	[forecast_method_code]	Yes	Yes	forecast_method_code
Skill Dimension	forecast_method_name	STRING	[forecast_method_name]	Yes	Yes	Forecast Method
Skill Dimension	insert_date	DATE	[insert_date]	Yes	No
Skill Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Skill Dimension	skill_code	STRING	[skill_code]	Yes	Yes	skill_code
Skill Dimension	skill_id	NUMBER	[skill_id]	Yes	No
Skill Dimension	skill_name	STRING	[skill_name]	Yes	No
Skill Dimension	time_zone_id	NUMBER	[time_zone_id]	Yes	No
Skill Dimension	update_date	DATE	[update_date]	Yes	No
Skillset Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Skillset Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Skillset Dimension	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Skillset Dimension	insert_date	STRING	[insert_date]	Yes	No
Skillset Dimension	skillset_code	STRING	[skillset_code]	Yes	No
Skillset Dimension	skillset_code_hash	STRING	[skillset_code_hash]	Yes	No
Skillset Dimension	skillset_id	NUMBER	[skillset_id]	Yes	No
Skillset Dimension	skillset_name	STRING	[skillset_name]	Yes	No
Skillset Dimension	update_date	STRING	[update_date]	Yes	No
Team Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Team Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Team Dimension	datasource_update_date	STRING	[datasource_update_date]	Yes	No
Team Dimension	insert_date	DATE	[insert_date]	Yes	No
Team Dimension	scorecard_id	NUMBER	[scorecard_id]	Yes	No
Team Dimension	site_id	NUMBER	[site_id]	Yes	No
Team Dimension	team_code	STRING	[team_code]	Yes	No
Team Dimension	team_id	NUMBER	[team_id]	Yes	No
Team Dimension	team_name	STRING	[team_name]	Yes	No
Team Dimension	update_date	DATE	[update_date]	Yes	No
Workload Dimension	business_unit_id	NUMBER	[business_unit_id]	Yes	No
Workload Dimension	datasource_id	NUMBER	[datasource_id]	Yes	No
Workload Dimension	datasource_update_date	DATE	[datasource_update_date]	Yes	No
Workload Dimension	forecast_method_code	STRING	[forecast_method_code]	Yes	Yes	forecast_method_code
Workload Dimension	forecast_method_name	STRING	[forecast_method_name]	Yes	Yes	Forecast Method
Workload Dimension	insert_date	DATE	[insert_date]	Yes	No
Workload Dimension	is_deleted	BOOLEAN	[is_deleted]	Yes	No
Workload Dimension	percentage_abandoned	NUMBER	[percentage_abandoned]	Yes	No
Workload Dimension	percentage_abandoned_after_service_level	NUMBER	[percentage_abandoned_after_service_level]	Yes	No
Workload Dimension	percentage_abandoned_short	NUMBER	[percentage_abandoned_short]	Yes	No
Workload Dimension	percentage_abandoned_within_service_level	NUMBER	[percentage_abandoned_within_service_level]	Yes	No
Workload Dimension	percentage_offered	NUMBER	[percentage_offered]	Yes	No
Workload Dimension	percentage_overflow_in	NUMBER	[percentage_overflow_in]	Yes	No
Workload Dimension	percentage_overflow_out	NUMBER	[percentage_overflow_out]	Yes	No
Workload Dimension	skill_code	STRING	[skill_code]	Yes	Yes	skill_code
Workload Dimension	skill_id	NUMBER	[skill_id]	Yes	No
Workload Dimension	skill_name	STRING	[skill_name]	Yes	No
Workload Dimension	time_zone_id	NUMBER	[time_zone_id]	Yes	No
Workload Dimension	update_date	DATE	[update_date]	Yes	No
Workload Dimension	workload_code	STRING	[workload_code]	Yes	No
Workload Dimension	workload_id	NUMBER	[workload_id]	Yes	No
Workload Dimension	workload_name	STRING	[workload_name]	Yes	No