# Employment Hero schema ERD

Table and field reference for the Fivetran Employment Hero connector.

## Table & Field Reference

### tax_declaration

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| tax_au_resident | Unknown |  |
| tax_file_number | Unknown |  |
| tax_financial_supplement_debt | Unknown |  |
| tax_foreign_resident | Unknown |  |
| tax_free | Unknown |  |
| tax_help_debt | Unknown |  |
| working_holiday_maker | Unknown |  |

### payroll_admin_email

| Column | Type | Keys |
| --- | --- | --- |
| payroll_admin_email | Unknown | PK |
| organisation_id | Unknown | PK, FK |

### organisation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_employees_count | Unknown |  |
| business_account_id | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| employees_count | Unknown |  |
| end_of_week | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| pending_employees_count | Unknown |  |
| phone | Unknown |  |
| primary_address | Unknown |  |
| subscription_plan | Unknown |  |
| superfund_name | Unknown |  |
| time_zone | Unknown |  |
| typical_work_day | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| name | Unknown |  |
| status | Unknown |  |

### employee_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| contract_type | Unknown |  |
| employment_type | Unknown |  |
| end_date | Unknown |  |
| industry_standard_job_title | Unknown |  |
| start_date | Unknown |  |
| title | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| primary_manager_id | Unknown | FK |
| secondary_manager_id | Unknown | FK |
| abn | Unknown |  |
| account_email | Unknown |  |
| address | Unknown |  |
| avatar_url | Unknown |  |
| business_detail_business_type | Unknown |  |
| business_detail_country | Unknown |  |
| business_detail_number | Unknown |  |
| code | Unknown |  |
| company_email | Unknown |  |
| company_landline | Unknown |  |
| company_mobile | Unknown |  |
| country | Unknown |  |
| date_of_birth | Unknown |  |
| employing_entity | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| home_phone | Unknown |  |
| job_title | Unknown |  |
| known_as | Unknown |  |
| last_name | Unknown |  |
| location | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| nationality | Unknown |  |
| personal_email | Unknown |  |
| personal_mobile_number | Unknown |  |
| primary_cost_centre_id | Unknown |  |
| primary_cost_centre_name | Unknown |  |
| role | Unknown |  |
| secondary_cost_centres | Json |  |
| start_date | Unknown |  |
| termination_date | Unknown |  |
| termination_summary | Unknown |  |
| title | Unknown |  |
| trading_name | Unknown |  |
| uk_tax_and_national_insurance_id | Unknown |  |
| uk_tax_and_national_insurance_national_insurance_number | Unknown |  |
| uk_tax_and_national_insurance_unique_taxpayer_reference | Unknown |  |

### certification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| name | Unknown |  |
| type | Unknown |  |

### employee_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| certification_id | Unknown | FK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| completion_date | Unknown |  |
| driver_details | Unknown |  |
| driver_problem | Unknown |  |
| expiry_date | Unknown |  |
| name | Unknown |  |
| reason | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### payslip_displayed_accrued_leave

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payslip_id | Unknown | PK, FK |
| amount | Unknown |  |
| leave_category_name | Unknown |  |
| unit_type | Unknown |  |

### payslip_displayed_leave_balance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payslip_id | Unknown | PK, FK |
| amount | Unknown |  |
| leave_category_name | Unknown |  |
| unit_type | Unknown |  |

### payslip

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_state | Unknown |  |
| base_rate | Unknown |  |
| base_rate_unit | Unknown |  |
| business_abn | Unknown |  |
| business_address | Unknown |  |
| business_name | Unknown |  |
| employment_type | Unknown |  |
| hourly_rate | Unknown |  |
| name | Unknown |  |
| net_pay | Unknown |  |
| note | Unknown |  |
| pay_period_ending | Unknown |  |
| pay_period_starting | Unknown |  |
| payment_date | Unknown |  |
| payroll_type | Unknown |  |
| post_tax_deduction | Unknown |  |
| postcode | Unknown |  |
| pre_tax_deduction | Unknown |  |
| reimbursements | Unknown |  |
| suburb | Unknown |  |
| super | Unknown |  |
| tax | Unknown |  |
| total_deduction | Unknown |  |
| wages | Unknown |  |

### superannuation_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| electronic_service_address | Unknown |  |
| employer_nominated_fund | Unknown |  |
| fund_abn | Unknown |  |
| fund_email | Unknown |  |
| fund_name | Unknown |  |
| member_number | Unknown |  |
| product_code | Unknown |  |

### leave_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| comment | Unknown |  |
| end_date | Unknown |  |
| leave_balance_amount | Unknown |  |
| leave_category_name | Unknown |  |
| reason | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| total_hours | Unknown |  |

### team_employee

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

### timesheet_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| comment | Unknown |  |
| date | Unknown |  |
| end_time | Unknown |  |
| reason | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| time | Unknown |  |
| units | Unknown |  |

### emergency_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| after_hours_no | Unknown |  |
| after_mobile_no | Unknown |  |
| contact_name | Unknown |  |
| contact_type | Unknown |  |
| daytime_contact_number | Unknown |  |
| relationship | Unknown |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| account_name | Unknown |  |
| account_number | Unknown |  |
| amount | Unknown |  |
| bsb | Unknown |  |
| external_id | Unknown |  |
| primary_account | Unknown |  |

### policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| created_at | Unknown |  |
| induction | Unknown |  |
| name | Unknown |  |

### pay_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| organisation_id | Unknown | FK |
| anniversary_date | Unknown |  |
| change_reason | Unknown |  |
| classification | Unknown |  |
| comment | Unknown |  |
| currency | Unknown |  |
| days_per_week | Unknown |  |
| effective_from | Unknown |  |
| employee_work_hours | Unknown |  |
| full_time_equivalent_units | Unknown |  |
| hours_per_week | Unknown |  |
| in_review | Unknown |  |
| industrial_instrument | Unknown |  |
| leave_allowance_template | Unknown |  |
| pay_category | Unknown |  |
| pay_rate_template | Unknown |  |
| pay_unit | Unknown |  |
| salary | Unknown |  |
| salary_type | Unknown |  |
| zero_hour_based | Unknown |  |

## Relationships

- tax_declaration(organisation_id) → organisation(id)
- tax_declaration(employee_id) → employee(id)
- payroll_admin_email(organisation_id) → organisation(id)
- team(organisation_id) → organisation(id)
- employee_history(organisation_id) → organisation(id)
- employee_history(employee_id) → employee(id)
- employee(secondary_manager_id) → employee(id)
- employee(primary_manager_id) → employee(id)
- employee(organisation_id) → organisation(id)
- certification(organisation_id) → organisation(id)
- employee_certification(certification_id) → certification(id)
- employee_certification(organisation_id) → organisation(id)
- employee_certification(employee_id) → employee(id)
- payslip_displayed_accrued_leave(payslip_id) → payslip(id)
- payslip_displayed_leave_balance(payslip_id) → payslip(id)
- payslip(organisation_id) → organisation(id)
- payslip(employee_id) → employee(id)
- superannuation_detail(organisation_id) → organisation(id)
- superannuation_detail(employee_id) → employee(id)
- leave_request(employee_id) → employee(id)
- leave_request(organisation_id) → organisation(id)
- team_employee(employee_id) → employee(id)
- team_employee(organisation_id) → organisation(id)
- team_employee(team_id) → team(id)
- timesheet_entry(employee_id) → employee(id)
- timesheet_entry(organisation_id) → organisation(id)
- emergency_contact(organisation_id) → organisation(id)
- emergency_contact(employee_id) → employee(id)
- bank_account(organisation_id) → organisation(id)
- bank_account(employee_id) → superannuation_detail(_fivetran_id)
- policy(organisation_id) → organisation(id)
- pay_detail(organisation_id) → organisation(id)
- pay_detail(employee_id) → employee(id)