Fivetran documentation

Search the docs

/

Employment Hero

Explore the interactive ERD

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	PKFK

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	PKFK
`amount`	Unknown
`leave_category_name`	Unknown
`unit_type`	Unknown

payslip_displayed_leave_balance

Column	Type	Keys
`index`	Unknown	PK
`payslip_id`	Unknown	PKFK
`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	PKFK
`organisation_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

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