# Calabrio schema ERD

Table and field reference for the Fivetran Calabrio connector.

## 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 | PK, FK |
| name | Unknown |  |

### skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| role_id | Unknown | FK |

### role_available_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| role_id | Unknown | FK |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| global_level_authorization | Unknown |  |
| name | Unknown |  |

### workflow_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| skill_group_id | Unknown | PK, FK |
| name | Unknown |  |

### skill_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| name | Unknown |  |

### multiplicator_definition_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| multiplicator_type | Unknown |  |
| name | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| name | Unknown |  |
| short_name | Unknown |  |

### shift_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| name | Unknown |  |
| short_name | Unknown |  |

### shift_bag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| name | Unknown |  |

### day_off_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |

### people_skill

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| skill_id | Unknown | PK, FK |
| active | Unknown |  |
| proficiency | Unknown |  |

### people_role

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| role_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| default_scenario | Unknown |  |
| description | Unknown |  |
| enable_reporting | Unknown |  |
| restricted | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- rotation_day(day_off_template) → day_off_template(id)
- budget_group(business_unit_id) → business_unit(id)
- skill(activity_id) → activity(id)
- skill(business_unit_id) → business_unit(id)
- contract(business_unit_id) → business_unit(id)
- optional_column(business_unit_id) → business_unit(id)
- role_application_function_collection(role_id) → role(id)
- role_available_site(id) → site(id)
- role_available_site(role_id) → role(id)
- role_available_team(id) → team(id)
- role_available_team(role_id) → role(id)
- role(business_unit_id) → business_unit(id)
- workflow_control(business_unit_id) → business_unit(id)
- parttime_percentage(business_unit_id) → business_unit(id)
- employee_default(site_id) → site(id)
- employee_default(team_id) → team(id)
- employee_default(contract_id) → contract(id)
- employee_default(part_time_percentage_id) → parttime_percentage(id)
- employee_default(business_unit_id) → business_unit(id)
- absence(business_unit_id) → business_unit(id)
- skill_of_skill_group(id) → skill(id)
- skill_of_skill_group(skill_group_id) → skill_group(id)
- skill_group(business_unit_id) → business_unit(id)
- multiplicator_definition_set(business_unit_id) → business_unit(id)
- site(business_unit_id) → business_unit(id)
- shift_category(business_unit_id) → business_unit(id)
- shift_bag(business_unit_id) → business_unit(id)
- day_off_template(business_unit_id) → business_unit(id)
- schedule_change_shift(activity_id) → activity(id)
- schedule_change_shift(absence_id) → absence(id)
- schedule_change_shift(schedule_change_person_id) → schedule_change(person_id)
- schedule_change_shift(schedule_change_date) → schedule_change(date)
- schedule_change(shift_category_id) → shift_category(id)
- schedule_change(team_id) → team(id)
- schedule_change(business_unit_id) → business_unit(id)
- availability_day(business_unit_id) → business_unit(id)
- contract_schedule(business_unit_id) → business_unit(id)
- people_skill(skill_id) → skill(id)
- people_skill(people_id) → people(id)
- people_role(role_id) → role(id)
- people_role(business_unit_id) → business_unit(id)
- people_role(people_id) → people(id)
- people(contract_schedule_id) → contract_schedule(id)
- people(budget_group_id) → budget_group(id)
- people(shift_bag_id) → shift_bag(id)
- people(team_id) → team(id)
- people(business_unit_id) → business_unit(id)
- people(contract_id) → contract(id)
- people(workflow_control_set_id) → workflow_control(id)
- people(site_id) → site(id)
- people(part_time_percentage_id) → parttime_percentage(id)
- team(site_id) → site(id)
- team(business_unit_id) → business_unit(id)
- forecast_skill_detail(business_unit_id) → business_unit(id)
- scenario(business_unit_id) → business_unit(id)
- activity(business_unit_id) → business_unit(id)