Sage HR
Explore the interactive ERD
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 | PKFK |
employee_custom_field_id | Unknown | PKFK |
employee_custom_field_value
| Column | Type | Keys |
|---|---|---|
custom_field_value | Unknown | PK |
employee_custom_field_employee_id | Unknown | PKFK |
employee_custom_field_id | Unknown | PKFK |
employee_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
end_date | Unknown | |
start_date | Unknown |
employee_history
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
parent_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
policy_id | Unknown | PKFK |
carryover | Unknown | |
quantity | Unknown | |
unit | Unknown |
report_with_individual_allowance
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
full_name | Unknown |
team_employee
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_manager
| Column | Type | Keys |
|---|---|---|
manager_id | Unknown | PKFK |
team_id | Unknown | PKFK |
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 |