Calabrio

Explore the interactive ERD

Table & Field Reference

rotation_day

Column	Type	Keys
`day`	Unknown	PK
`rotation_id`	Unknown	PK
`day_off_template`	Unknown	FK
`end_time_maximum`	Unknown
`end_time_minimum`	Unknown
`rotation_name`	Unknown
`shift_category`	Unknown
`start_time_maximum`	Unknown
`start_time_minimum`	Unknown
`work_time_maximum`	Unknown
`work_time_minimum`	Unknown

budget_group

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

skill

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`activity_id`	Unknown	FK
`activity_id`	Unknown
`description`	Unknown
`name`	Unknown
`resolution_minute`	Unknown
`skill_type_id`	Unknown
`skill_type_name`	Unknown
`skill_type_short_name`	Unknown
`staffing_threshold_critical_understaffing`	Unknown
`staffing_threshold_overstaffing`	Unknown
`staffing_threshold_understaffing`	Unknown
`staffing_threshold_understaffing_formax`	Unknown
`time_zone_id`	Unknown

contract

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

optional_column

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	FK
`name`	Unknown

role_application_function_collection

Column	Type	Keys
`id`	Unknown	PK
`role_id`	Unknown	FK
`description`	Unknown
`function_code`	Unknown
`function_path`	Unknown

role_available_site

Column	Type	Keys
`id`	Unknown	PKFK
`role_id`	Unknown	FK

role_available_team

Column	Type	Keys
`id`	Unknown	PKFK
`role_id`	Unknown	FK

role

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`global_level_authorization`	Unknown
`name`	Unknown

workflow_control

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`absence_request_expired_threshold`	Unknown
`name`	Unknown
`overtime_request_staffing_check_method_is_no`	Unknown

parttime_percentage

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

employee_default

Column	Type	Keys
`_fivetran_id`	String	PK
`business_unit_id`	Unknown	FK
`contract_id`	Unknown	FK
`part_time_percentage_id`	Unknown	FK
`site_id`	Unknown	FK
`team_id`	Unknown	FK
`first_day_of_week`	Unknown

absence

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`confidential`	Unknown
`in_contract_time`	Unknown
`in_paid_time`	Unknown
`in_work_time`	Unknown
`is_deleted`	Unknown
`name`	Unknown
`payroll_code`	Unknown
`priority`	Unknown
`requestable`	Unknown
`tracker_type`	Unknown

skill_of_skill_group

Column	Type	Keys
`id`	Unknown	PKFK
`skill_group_id`	Unknown	PKFK
`name`	Unknown

skill_group

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

multiplicator_definition_set

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`multiplicator_type`	Unknown
`name`	Unknown

site

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown
`short_name`	Unknown

shift_category

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown
`short_name`	Unknown

shift_bag

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

day_off_template

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

business_unit

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

schedule_change_shift

Column	Type	Keys
`_fivetran_id`	String	PK
`absence_id`	Unknown	FK
`activity_id`	Unknown	FK
`schedule_change_date`	Unknown	FK
`schedule_change_person_id`	Unknown	FK
`confidential`	Unknown
`display_color_hex`	Unknown
`external_meeting_id`	Unknown
`name`	Unknown
`overtime`	Unknown
`period_endtime`	Unknown
`period_starttime`	Unknown

schedule_change

Column	Type	Keys
`date`	Unknown	PK
`person_id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`shift_category_id`	Unknown	FK
`team_id`	Unknown	FK
`day_off_name`	Unknown
`day_off_template_id`	Unknown
`shift_category_name`	Unknown
`shift_category_short_name`	Unknown

availability_day

Column	Type	Keys
`availability_id`	Unknown	PK
`day`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`availability_name`	Unknown
`end_time_maximum`	Unknown
`is_available`	Unknown
`start_time_minimum`	Unknown
`work_time_maximum`	Unknown
`work_time_minimum`	Unknown

contract_schedule

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`name`	Unknown

people_skill

Column	Type	Keys
`people_id`	Unknown	PKFK
`skill_id`	Unknown	PKFK
`active`	Unknown
`proficiency`	Unknown

people_role

Column	Type	Keys
`people_id`	Unknown	PKFK
`role_id`	Unknown	PKFK
`business_unit_id`	Unknown	FK

people

Column	Type	Keys
`id`	Unknown	PK
`budget_group_id`	Unknown	FK
`business_unit_id`	Unknown	FK
`contract_id`	Unknown	FK
`contract_schedule_id`	Unknown	FK
`part_time_percentage_id`	Unknown	FK
`shift_bag_id`	Unknown	FK
`site_id`	Unknown	FK
`team_id`	Unknown	FK
`workflow_control_set_id`	Unknown	FK
`display_name`	Unknown
`email`	Unknown
`employment_number`	Unknown
`employment_start_date`	Unknown
`first_day_of_week`	Unknown
`first_name`	Unknown
`identities`	Unknown
`last_name`	Unknown
`note`	Unknown
`optional_columns`	Unknown
`part_time_percentage_id`	Unknown
`termination_date`	Unknown
`time_zone_id`	Unknown
`custom_`

team

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`site_id`	Unknown	FK
`name`	Unknown

forecast_skill_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`business_unit_id`	Unknown	FK
`agent`	Unknown
`average_after_task_time_second`	Unknown
`average_task_time_second`	Unknown
`campaign_after_task_time_percent`	Unknown
`campaign_task_time_percent`	Unknown
`campaign_tasks_percent`	Unknown
`forecast_id`	Unknown
`period_end_time`	Unknown
`period_start_time`	Unknown
`task`	Unknown

scenario

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`default_scenario`	Unknown
`description`	Unknown
`enable_reporting`	Unknown
`restricted`	Unknown

activity

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`allow_overwrite`	Unknown
`in_contract_time`	Unknown
`in_paid_time`	Unknown
`in_ready_time`	Unknown
`in_work_time`	Unknown
`is_deleted`	Unknown
`name`	Unknown
`payroll_code`	Unknown
`report_level_detail`	Unknown
`requires_seat`	Unknown
`requires_skill`	Unknown