# Breathe HR schema ERD

Table and field reference for the Fivetran Breathe HR connector.

## Table & Field Reference

### company_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| complete | Unknown |  |
| created_at | Unknown |  |
| due_on | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### employee_expense

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| employee_expense_claim_id | Unknown | FK |
| employee_id | Unknown | FK |
| amount | Unknown |  |
| chargeable_to_client | Unknown |  |
| client_name | Unknown |  |
| company_expense_type_id | Unknown |  |
| company_mileage_rate_id | Unknown |  |
| company_project_id | Unknown |  |
| description | Unknown |  |
| expense_date | Unknown |  |
| miles | Unknown |  |
| payable_to_employee | Unknown |  |
| vat | Unknown |  |

### holiday_allowance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| carryover_allowed | Unknown |  |
| created_at | Unknown |  |
| depends_on_service | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| negative_carryover_allowed | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |
| year_1 | Unknown |  |
| year_10 | Unknown |  |
| year_2 | Unknown |  |
| year_3 | Unknown |  |
| year_4 | Unknown |  |
| year_5 | Unknown |  |
| year_6 | Unknown |  |
| year_7 | Unknown |  |
| year_8 | Unknown |  |
| year_9 | Unknown |  |

### bonus

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| award_date | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| updated_at | Unknown |  |

### company_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| nice_name | Unknown |  |
| updated_at | Unknown |  |

### employee_expense_claim

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| approver_id | Unknown | FK |
| closed_by_id | Unknown | FK |
| employee_id | Unknown | FK |
| paid_by_id | Unknown | FK |
| rejected_by_id | Unknown | FK |
| approved_date | Unknown |  |
| closed_date | Unknown |  |
| description | Unknown |  |
| employee_expense | Unknown |  |
| old_claim_status | Unknown |  |
| paid | Unknown |  |
| paid_date | Unknown |  |
| reject_reason | Unknown |  |
| rejected_date | Unknown |  |
| remuneration_currency_id | Unknown |  |
| state | Unknown |  |
| submitted_date | Unknown |  |
| third_party_email | Unknown |  |

### working_pattern

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| fri | Unknown |  |
| fri_hr | Unknown |  |
| is_default | Unknown |  |
| mon | Unknown |  |
| mon_hr | Unknown |  |
| name | Unknown |  |
| sat | Unknown |  |
| sat_hr | Unknown |  |
| sun | Unknown |  |
| sun_hr | Unknown |  |
| thu | Unknown |  |
| thu_hr | Unknown |  |
| tue | Unknown |  |
| tue_hr | Unknown |  |
| updated_at | Unknown |  |
| wed | Unknown |  |
| wed_hr | Unknown |  |

### salary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| basis | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| department_id | Unknown | FK |
| division_id | Unknown | FK |
| holiday_allowance_id | Unknown | FK |
| location_id | Unknown | FK |
| working_pattern_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_3 | Unknown |  |
| age | Unknown |  |
| bank_branch | Unknown |  |
| bank_name | Unknown |  |
| building_society | Unknown |  |
| city | Unknown |  |
| contract_provider | Unknown |  |
| contract_type | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| created_at | Unknown |  |
| ddi | Unknown |  |
| dob | Unknown |  |
| driving_license | Unknown |  |
| duties | Json |  |
| email | Unknown |  |
| employee_ref | Unknown |  |
| ethnicity | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| full_or_part_time | Unknown |  |
| gender | Unknown |  |
| holiday_approver | Unknown |  |
| home_telephone | Unknown |  |
| hr | Unknown |  |
| hr_partner_id | Unknown |  |
| is_line_manager | Unknown |  |
| job_start_date | Unknown |  |
| job_title | Unknown |  |
| join_date | Unknown |  |
| known_as | Unknown |  |
| last_name | Unknown |  |
| leaving_date | Unknown |  |
| length_of_service_in_month | Unknown |  |
| line_manager | Unknown |  |
| linked_in | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| national_insurance_no | Unknown |  |
| nationality | Unknown |  |
| notice_period | Unknown |  |
| person_type | Unknown |  |
| personal_email | Unknown |  |
| personal_mobile | Unknown |  |
| postcode | Unknown |  |
| probation_date | Unknown |  |
| receives_statutory_holiday | Unknown |  |
| ref_number | Unknown |  |
| remuneration_currency_created_at | Unknown |  |
| remuneration_currency_currency_code | Unknown |  |
| remuneration_currency_currency_symbol | Unknown |  |
| remuneration_currency_deleted_at | Unknown |  |
| remuneration_currency_description | Unknown |  |
| remuneration_currency_id | Unknown |  |
| remuneration_currency_updated_at | Unknown |  |
| salary | Unknown |  |
| skype | Unknown |  |
| sort_code | Unknown |  |
| status | Unknown |  |
| statutory_holiday_country | Unknown |  |
| total_working_hour | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |
| work_ext | Unknown |  |
| work_mobile | Unknown |  |
| custom_field_** |  |  |

### benefit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| created_at | Unknown |  |
| employee_contribution | Unknown |  |
| employer_contribution | Unknown |  |
| end_date | Unknown |  |
| pension_opt_out | Unknown |  |
| provider | Unknown |  |
| review_date | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

### division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### statutory_holiday_country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### company_training_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### employee_training_course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| company_training_category | Unknown |  |
| company_training_provider | Unknown |  |
| company_training_type | Unknown |  |
| cost | Unknown |  |
| end_on | Unknown |  |
| expires_on | Unknown |  |
| follow_up_date | Unknown |  |
| half_day | Unknown |  |
| half_day_am_pm | Unknown |  |
| hour | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| outcome | Unknown |  |
| rejection_reason | Unknown |  |
| remuneration_currency_id | Unknown |  |
| start_on | Unknown |  |
| status | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| start_date | Unknown | FK |
| contract_end_date | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| full_time_part_time | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### other_leave_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| domain | Unknown |  |
| health_and_safety_enabled | Unknown |  |
| name | Unknown |  |
| using_rta | Unknown |  |
| uuid | Unknown |  |

### change_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved | Unknown |  |
| approved_at | Unknown |  |
| created_at | Unknown |  |
| field_name | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### absence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| approved_by | Unknown |  |
| cancelled | Unknown |  |
| created_at | Unknown |  |
| deducted | Unknown |  |
| end_date | Unknown |  |
| half_end | Unknown |  |
| half_end_am_pm | Unknown |  |
| half_start | Unknown |  |
| half_start_am_pm | Unknown |  |
| leave_reason | Unknown |  |
| note | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| work_unit | Unknown |  |

### sickness

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| company_sickness_type | Unknown |  |
| deducted | Unknown |  |
| end_date | Unknown |  |
| fit_note_required | Unknown |  |
| half_end | Unknown |  |
| half_end_am_pm | Unknown |  |
| half_start | Unknown |  |
| half_start_am_pm | Unknown |  |
| reason | Unknown |  |
| review_note | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |

### leave_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| half_end | Unknown |  |
| half_end_am_pm | Unknown |  |
| half_start | Unknown |  |
| half_start_am_pm | Unknown |  |
| note | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- company_project(id) → employee_expense(company_project_id)
- employee_expense(employee_expense_claim_id) → employee_expense_claim(id)
- employee_expense(employee_id) → employee(id)
- employee_expense(account_id) → account(id)
- employee_expense_claim(approver_id) → employee(id)
- employee_expense_claim(employee_id) → employee(id)
- employee_expense_claim(account_id) → account(id)
- employee_expense_claim(rejected_by_id) → employee(id)
- employee_expense_claim(closed_by_id) → employee(id)
- employee_expense_claim(paid_by_id) → employee(id)
- employee(working_pattern_id) → working_pattern(id)
- employee(department_id) → department(id)
- employee(division_id) → division(id)
- employee(location_id) → location(id)
- employee(holiday_allowance_id) → holiday_allowance(id)
- employee(account_id) → account(id)
- company_training_type(id) → employee_training_course(company_training_type)
- employee_training_course(employee_id) → employee(id)
- location(id) → employee(location_id)
- job(employee_id) → employee(id)
- job(start_date) → employee(job_start_date)
- absence(employee_id) → employee(id)
- sickness(employee_id) → employee(id)