# Sage HR schema ERD

Table and field reference for the Fivetran Sage HR connector.

## Table & Field Reference

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| position_id | Unknown | FK |
| reports_to_employee_id | Unknown | FK |
| team_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| employee_number | Unknown |  |
| employment_start_date | Unknown |  |
| employment_status | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| home_phone | Unknown |  |
| is_terminated | Unknown |  |
| last_name | Unknown |  |
| marital_status | Unknown |  |
| mobile_phone | Unknown |  |
| nationality | Unknown |  |
| personal_identification_number | Unknown |  |
| picture_url | Unknown |  |
| position | Unknown |  |
| post_code | Unknown |  |
| street_first | Unknown |  |
| street_second | Unknown |  |
| tax_number | Unknown |  |
| termination_date | Unknown |  |
| work_phone | Unknown |  |

### individual_team_quarterly_goal

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown | FK |
| progress_actual | Unknown |  |
| progress_to_date | Unknown |  |
| quarterly_data_progress_actual | Unknown |  |
| quarterly_data_progress_to_date | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| description | Unknown |  |
| title | Unknown |  |

### employee_custom_field_option

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_option | Unknown | PK |
| employee_custom_field_employee_id | Unknown | PK, FK |
| employee_custom_field_id | Unknown | PK, FK |

### employee_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_value | Unknown | PK |
| employee_custom_field_employee_id | Unknown | PK, FK |
| employee_custom_field_id | Unknown | PK, FK |

### employee_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| label | Unknown |  |
| type | Unknown |  |

### kit_day_of_employee_in_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| leave_policy_id | Unknown | FK |
| end_date | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |

### employee_team_history

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| end_date | Unknown |  |
| start_date | Unknown |  |

### employee_history

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| parent_id | Unknown | PK, FK |
| employment_status_name | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |

### time_off_request_field

| Column | Type | Keys |
| --- | --- | --- |
| title | Unknown | PK |
| time_off_request_id | Unknown | PK, FK |
| answer | Unknown |  |

### time_off_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| policy_id | Unknown | FK |
| approval_date | Unknown |  |
| details | Unknown |  |
| end_date | Unknown |  |
| first_part_of_day | Unknown |  |
| hours | Unknown |  |
| is_multi_date | Unknown |  |
| is_part_of_day | Unknown |  |
| is_single_day | Unknown |  |
| request_date | Unknown |  |
| second_part_of_day | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| status_code | Unknown |  |

### employee_compensation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| employee_id | Unknown | FK |
| amount | Unknown |  |
| category | Unknown |  |
| comment | Unknown |  |
| currency | Unknown |  |
| end_date | Unknown |  |
| period | Unknown |  |
| start_date | Unknown |  |

### quarterly_company_data

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| progress_actual | Unknown |  |
| progress_to_date | Unknown |  |
| title | Unknown |  |

### individual_allowance_eligibility

| Column | Type | Keys |
| --- | --- | --- |
| individual_allowance_id | Unknown | PK, FK |
| policy_id | Unknown | PK, FK |
| carryover | Unknown |  |
| quantity | Unknown |  |
| unit | Unknown |  |

### report_with_individual_allowance

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| full_name | Unknown |  |

### team_employee

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_manager

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team

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

### leave_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accrue_at_start | Unknown |  |
| accrue_type | Unknown |  |
| additional_field | Unknown |  |
| auto_approves | Unknown |  |
| blocks_enabled | Unknown |  |
| child_allowance_enabled | Unknown |  |
| color | Unknown |  |
| default_allowance | Unknown |  |
| do_not_accrue | Unknown |  |
| dont_allow_negative_amount | Unknown |  |
| enable_attachment | Unknown |  |
| enable_dependent_policy | Unknown |  |
| enable_details | Unknown |  |
| enable_duplicate_time_offs | Unknown |  |
| enable_employee_access | Unknown |  |
| enable_limited_days | Unknown |  |
| enable_minimum_days | Unknown |  |
| enable_monthly_expiration | Unknown |  |
| enable_negative_carryover | Unknown |  |
| enable_probation_period | Unknown |  |
| enable_replacement | Unknown |  |
| enable_replacement_away | Unknown |  |
| enable_scopped_replacement | Unknown |  |
| enable_service_accruals | Unknown |  |
| enable_specific_approvers | Unknown |  |
| max_accrual | Unknown |  |
| max_carryover | Unknown |  |
| name | Unknown |  |
| no_reset | Unknown |  |
| only_full_days | Unknown |  |
| override_approvers_enabled | Unknown |  |
| replacement_required | Unknown |  |
| requests_in_advance_required | Unknown |  |
| require_details | Unknown |  |
| starter_monthly_accrual_limitation | Unknown |  |
| starter_yearly_accrual_limitation | Unknown |  |
| termination_recalculation | Unknown |  |
| unit | Unknown |  |

## Relationships

- employee(position_id) → position(id)
- employee(team_id) → team(id)
- employee(reports_to_employee_id) → employee(id)
- individual_team_quarterly_goal(name) → team(name)
- employee_custom_field_option(employee_custom_field_id) → employee_custom_field(id)
- employee_custom_field_option(employee_custom_field_employee_id) → employee_custom_field(employee_id)
- employee_custom_field_value(employee_custom_field_id) → employee_custom_field(id)
- employee_custom_field_value(employee_custom_field_employee_id) → employee_custom_field(employee_id)
- employee_custom_field(employee_id) → employee(id)
- kit_day_of_employee_in_policy(leave_policy_id) → leave_policy(id)
- kit_day_of_employee_in_policy(employee_id) → employee(id)
- employee_team_history(team_id) → team(id)
- employee_team_history(employee_id) → employee(id)
- employee_history(parent_id) → position(id)
- employee_history(employee_id) → employee(id)
- time_off_request_field(time_off_request_id) → time_off_request(id)
- time_off_request(policy_id) → leave_policy(id)
- time_off_request(employee_id) → employee(id)
- employee_compensation(employee_id) → employee(id)
- individual_allowance_eligibility(policy_id) → leave_policy(id)
- individual_allowance_eligibility(individual_allowance_id) → report_with_individual_allowance(employee_id)
- report_with_individual_allowance(employee_id) → employee(id)
- team_employee(employee_id) → employee(id)
- team_employee(team_id) → team(id)
- team_manager(manager_id) → employee(id)
- team_manager(team_id) → team(id)