# KeyPay schema ERD

Table and field reference for the Fivetran KeyPay connector.

## Table & Field Reference

### roster_shift_qualification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| roster_shift_id | Unknown | PK, FK |
| name | Unknown |  |

### roster_shift_break

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| roster_shift_id | Unknown | PK, FK |
| end_time | Unknown |  |
| is_paid_break | Unknown |  |
| start_time | Unknown |  |

### roster_shift

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| location_id | Unknown | FK |
| pending_swap_from_employee_id | Unknown | FK |
| pending_swap_to_employee_id | Unknown | FK |
| work_type_id | Unknown | FK |
| accepted | Unknown |  |
| biddable | Unknown |  |
| classification_id | Unknown |  |
| classification_name | Unknown |  |
| date_published | Unknown |  |
| employee_name | Unknown |  |
| end_time | Unknown |  |
| note | Unknown |  |
| pending_swap_date_created | Unknown |  |
| pending_swap_from_employee | Unknown |  |
| pending_swap_id | Unknown |  |
| pending_swap_note | Unknown |  |
| pending_swap_rejected_reason | Unknown |  |
| pending_swap_status | Unknown |  |
| pending_swap_status_description | Unknown |  |
| pending_swap_to_employee | Unknown |  |
| published | Unknown |  |
| role_class_name | Unknown |  |
| role_hex_colour_code | Unknown |  |
| role_id | Unknown |  |
| role_name | Unknown |  |
| shift_assignment_status | Unknown |  |
| shift_swap_cutoff_time | Unknown |  |
| start_time | Unknown |  |
| token | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employing_entity_id | Unknown | FK |
| afs_debt | Unknown |  |
| anniversary_date | Unknown |  |
| australian_resident | Unknown |  |
| automatically_pay_employee | Unknown |  |
| bank_account_1_account_name | Unknown |  |
| bank_account_1_account_number | Unknown |  |
| bank_account_1_allocated_percentage | Unknown |  |
| bank_account_1_bsb | Unknown |  |
| bank_account_1_fixed_amount | Unknown |  |
| bank_account_2_account_name | Unknown |  |
| bank_account_2_account_number | Unknown |  |
| bank_account_2_allocated_percentage | Unknown |  |
| bank_account_2_bsb | Unknown |  |
| bank_account_2_fixed_amount | Unknown |  |
| bank_account_3_account_name | Unknown |  |
| bank_account_3_account_number | Unknown |  |
| bank_account_3_allocated_percentage | Unknown |  |
| bank_account_3_bsb | Unknown |  |
| bank_account_3_fixed_amount | Unknown |  |
| business_award_package | Unknown |  |
| claim_medicare_levy_reduction | Unknown |  |
| claim_tax_free_threshold | Unknown |  |
| closely_held_employee | Unknown |  |
| closely_held_reporting | Unknown |  |
| contractor_abn | Unknown |  |
| date_created | Unknown |  |
| date_of_birth | Unknown |  |
| date_tax_file_declaration_reported | Unknown |  |
| date_tax_file_declaration_signed | Unknown |  |
| dvl_pay_slip_description | Unknown |  |
| email_address | Unknown |  |
| emergency_contact_1_address | Unknown |  |
| emergency_contact_1_alternate_contact_number | Unknown |  |
| emergency_contact_1_contact_number | Unknown |  |
| emergency_contact_1_name | Unknown |  |
| emergency_contact_1_relationship | Unknown |  |
| emergency_contact_2_address | Unknown |  |
| emergency_contact_2_alternate_contact_number | Unknown |  |
| emergency_contact_2_contact_number | Unknown |  |
| emergency_contact_2_name | Unknown |  |
| emergency_contact_2_relationship | Unknown |  |
| employing_entity_a_b_n | Unknown |  |
| employment_agreement | Unknown |  |
| employment_type | Unknown |  |
| end_date | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| full_time_equivalent | Unknown |  |
| gender | Unknown |  |
| has_approved_working_holiday_visa | Unknown |  |
| has_withholding_variation | Unknown |  |
| help_debt | Unknown |  |
| home_phone | Unknown |  |
| hours_per_day | Unknown |  |
| hours_per_week | Unknown |  |
| is_enabled_for_timesheet | Unknown |  |
| is_exempt_from_flood_levy | Unknown |  |
| is_exempt_from_payroll_tax | Unknown |  |
| is_seasonal_worker | Unknown |  |
| job_title | Unknown |  |
| leave_accrual_start_date_type | Unknown |  |
| leave_template | Unknown |  |
| leave_year_start | Unknown |  |
| location | Unknown |  |
| maximum_quarterly_super_contributions_base | Unknown |  |
| medicare_levy_exemption | Unknown |  |
| medicare_levy_reduction_dependent_count | Unknown |  |
| medicare_levy_reduction_spouse | Unknown |  |
| medicare_levy_surcharge_withholding_tier | Unknown |  |
| middle_name | Unknown |  |
| mobile_phone | Unknown |  |
| other_tax_offset | Unknown |  |
| override_template_rate | Unknown |  |
| pay_condition_rule_set | Unknown |  |
| pay_rate_template | Unknown |  |
| pay_schedule | Unknown |  |
| pay_slip_notification_type | Unknown |  |
| portable_long_service_leave_id | Unknown |  |
| postal_address_is_overseas | Unknown |  |
| postal_address_line_2 | Unknown |  |
| postal_country | Unknown |  |
| postal_post_code | Unknown |  |
| postal_state | Unknown |  |
| postal_street_address | Unknown |  |
| postal_suburb | Unknown |  |
| preferred_name | Unknown |  |
| previous_surname | Unknown |  |
| primary_location | Unknown |  |
| primary_pay_category | Unknown |  |
| rate | Unknown |  |
| rate_unit | Unknown |  |
| reporting_dimension_value | Unknown |  |
| residential_address_is_overseas | Unknown |  |
| residential_address_line_2 | Unknown |  |
| residential_country | Unknown |  |
| residential_post_code | Unknown |  |
| residential_state | Unknown |  |
| residential_street_address | Unknown |  |
| residential_suburb | Unknown |  |
| rostering_notification_choice | Unknown |  |
| seniors_tax_offset | Unknown |  |
| single_touch_payroll | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| stsl_debt | Unknown |  |
| super_fund_1_allocated_percentage | Unknown |  |
| super_fund_1_employer_nominated_fund | Unknown |  |
| super_fund_1_fixed_amount | Unknown |  |
| super_fund_1_fund_name | Unknown |  |
| super_fund_1_member_number | Unknown |  |
| super_fund_1_product_code | Unknown |  |
| super_fund_2_allocated_percentage | Unknown |  |
| super_fund_2_employer_nominated_fund | Unknown |  |
| super_fund_2_fixed_amount | Unknown |  |
| super_fund_2_fund_name | Unknown |  |
| super_fund_2_member_number | Unknown |  |
| super_fund_2_product_code | Unknown |  |
| super_fund_3_allocated_percentage | Unknown |  |
| super_fund_3_employer_nominated_fund | Unknown |  |
| super_fund_3_fixed_amount | Unknown |  |
| super_fund_3_fund_name | Unknown |  |
| super_fund_3_member_number | Unknown |  |
| super_fund_3_product_code | Unknown |  |
| super_threshold_amount | Unknown |  |
| surname | Unknown |  |
| tags | Unknown |  |
| tax_category | Unknown |  |
| tax_file_number | Unknown |  |
| tax_variation | Unknown |  |
| termination_reason | Unknown |  |
| title | Unknown |  |
| work_phone | Unknown |  |
| work_type | Unknown |  |
| working_holiday_visa_country | Unknown |  |
| working_holiday_visa_start_date | Unknown |  |

### employee_additional_earning

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| pay_category_id | Unknown | FK |
| amount | Double |  |
| expiration_type | Unknown |  |
| expiry_date | Unknown |  |
| is_active | Unknown |  |
| maximum_amount_paid | Double |  |
| name | Unknown |  |
| note | Unknown |  |
| override_super_rate | Unknown |  |
| start_date | Unknown |  |
| super_rate | Double |  |
| total_amount_paid | Double |  |
| unit | Double |  |

### employee_tax_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| adjustment_type | Unknown |  |
| amount | Double |  |
| expiry_date | Unknown |  |
| from_date | Unknown |  |
| is_active | Unknown |  |
| maximum_amount_paid | Double |  |
| note | Unknown |  |
| total_amount_paid | Double |  |

### employee_portal_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| business_id | Unknown | FK |
| allow_employee_bank_account_self_service | Unknown |  |
| allow_employee_expenses_self_service | Unknown |  |
| allow_employee_leave_self_service | Unknown |  |
| allow_employee_override_tax_code | Unknown |  |
| allow_employee_satisfaction_survey | Unknown |  |
| allow_employee_self_editing | Unknown |  |
| allow_employee_shift_selection | Unknown |  |
| allow_employee_super_fund_self_service | Unknown |  |
| allow_employee_to_set_unavailability | Unknown |  |
| allow_employees_to_upload_profile_picture | Unknown |  |
| allow_employees_to_view_all_approved_leave | Unknown |  |
| can_specify_higher_classification | Unknown |  |
| clock_off_reminder_notification_minute | Unknown |  |
| clock_off_window_minute | Unknown |  |
| clock_on_reminder_notification_minute | Unknown |  |
| clock_on_window_minute | Unknown |  |
| enable_work_zone_clock_on | Unknown |  |
| require_photo | Unknown |  |
| send_employee_details_update_notification | Unknown |  |
| show_pay_days_in_employee_calendar | Unknown |  |
| timesheet_setting | Unknown |  |
| unavailability_cut_off | Unknown |  |

### business_qualification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| name | Unknown |  |

### super_fund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| business_id | Unknown | FK |
| allocate_balance | Unknown |  |
| allocated_percentage | Double |  |
| can_be_deleted | Unknown |  |
| fixed_amount | Double |  |
| is_employer_nominated_fund | Unknown |  |
| member_number | Unknown |  |
| name | Unknown |  |
| super_product_abn | Unknown |  |
| super_product_account_name | Unknown |  |
| super_product_account_number | Unknown |  |
| super_product_bsb | Unknown |  |
| super_product_business_name | Unknown |  |
| super_product_code | Unknown |  |
| super_product_display_name | Unknown |  |
| super_product_electronic_service_address | Unknown |  |
| super_product_email | Unknown |  |
| super_product_external_reference_id | Unknown |  |
| super_product_id | Unknown |  |
| super_product_name | Unknown |  |
| super_product_source | Unknown |  |
| super_product_type | Unknown |  |

### pay_slip_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| alphabetise_pay_category | Unknown |  |
| email_body_message | Unknown |  |
| email_from | Unknown |  |
| employees_must_login_to_download_payslip | Unknown |  |
| show_base_pay_rate | Unknown |  |
| show_classification | Unknown |  |
| show_employee_external_id | Unknown |  |
| show_employee_id | Unknown |  |
| show_leave_accrual | Unknown |  |
| show_line_note | Unknown |  |
| show_location_in_line_note | Unknown |  |
| show_rate_for_annual_earning | Unknown |  |
| super_contribution_processing_frequency_text_option | Unknown |  |

### pay_rate_adjustment_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| commencement_date | Unknown |  |
| rate | Unknown |  |
| rate_unit | Unknown |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| account_name | Unknown |  |
| account_number | Unknown |  |
| account_type | Unknown |  |
| allocate_balance | Unknown |  |
| allocated_percentage | Unknown |  |
| bsb | Unknown |  |
| can_be_deleted | Unknown |  |
| external_reference_id | Unknown |  |
| fixed_amount | Unknown |  |
| is_employee_editable | Unknown |  |

### public_holiday_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| public_holiday_fivetran_id | Unknown | PK, FK |

### public_holiday

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| business_id | Unknown | FK |
| date | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| is_system | Unknown |  |
| mondayised_alternative_to_id | Unknown |  |
| not_a_public_holiday | Unknown |  |
| note | Unknown |  |
| states | Json |  |

### employment_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| award_name | Unknown |  |
| classification | Unknown |  |
| employment_type | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| rank | Unknown |  |

### employee_expense

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| expense_category_id | Unknown | FK |
| location_id | Unknown | FK |
| amount | Unknown |  |
| expiry_date | Unknown |  |
| from_date | Unknown |  |
| is_active | Unknown |  |
| maximum_amount_paid | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| tax_code | Unknown |  |
| tax_code_display_name | Unknown |  |
| tax_rate | Unknown |  |
| total_amount_paid | Unknown |  |

### work_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| leave_category_id | Unknown | FK |
| pay_category_id | Unknown | FK |
| accrues_leave | Unknown |  |
| award_package_id | Unknown |  |
| award_package_name | Unknown |  |
| employment_types | Json |  |
| external_id | Unknown |  |
| mapping_type | Unknown |  |
| name | Unknown |  |
| short_code | Unknown |  |
| source | Unknown |  |

### employee_deduction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| deduction_category_id | Unknown | FK |
| paid_to_account_id | Unknown | FK |
| additional_data | Unknown |  |
| amount | Double |  |
| carry_forward_unpaid_deduction | Unknown |  |
| carry_forward_unused_preserved_earning | Unknown |  |
| deduction_type | Unknown |  |
| deleted | Unknown |  |
| expiry_date | Unknown |  |
| external_reference_id | Unknown |  |
| from_date | Unknown |  |
| is_active | Unknown |  |
| maximum_amount_paid | Double |  |
| name | Unknown |  |
| note | Unknown |  |
| paid_to | Unknown |  |
| payment_reference | Unknown |  |
| preserved_earning | Unknown |  |
| preserved_earnings_amount | Double |  |
| preserved_earnings_amount_not_reached_action | Unknown |  |
| priority | Unknown |  |
| total_amount_paid | Double |  |

### pay_schedule_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| pay_schedule_id | Unknown | PK, FK |

### pay_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| aba_details_id | Unknown |  |
| auto_pay_configuration_adjust_date_paid_to_work_day | Unknown |  |
| auto_pay_configuration_adjust_run_date_to_work_day | Unknown |  |
| auto_pay_configuration_day_of_week | Unknown |  |
| auto_pay_configuration_enabled | Unknown |  |
| auto_pay_configuration_export_journal | Unknown |  |
| auto_pay_configuration_finalise | Unknown |  |
| auto_pay_configuration_initial_date_paid | Unknown |  |
| auto_pay_configuration_initial_pay_period_ending | Unknown |  |
| auto_pay_configuration_initial_pay_run_creation_date_time | Unknown |  |
| auto_pay_configuration_lodge_pay_run | Unknown |  |
| auto_pay_configuration_next_scheduled_creation_date_time_utc | Unknown |  |
| auto_pay_configuration_paused | Unknown |  |
| auto_pay_configuration_publish_pay_slip | Unknown |  |
| auto_pay_configuration_publish_pay_slips_hour | Unknown |  |
| auto_pay_configuration_report_packs_to_run | Json |  |
| auto_pay_configuration_run_on_specific_day_of_month | Unknown |  |
| auto_pay_configuration_scheduled_end_date | Unknown |  |
| auto_pay_configuration_specific_day_of_month | Unknown |  |
| auto_pay_configuration_suppress_notification | Unknown |  |
| auto_pay_configuration_timesheet_import_option | Unknown |  |
| auto_pay_configuration_users_to_notify | Json |  |
| auto_pay_configuration_week_of_month | Unknown |  |
| default_finalise_settings_export_journal | Unknown |  |
| default_finalise_settings_export_journals_day | Unknown |  |
| default_finalise_settings_export_journals_time_of_day | Unknown |  |
| default_finalise_settings_export_journals_timeline | Unknown |  |
| default_finalise_settings_lodge_pay_run | Unknown |  |
| default_finalise_settings_lodge_pay_run_day | Unknown |  |
| default_finalise_settings_lodge_pay_run_time_of_day | Unknown |  |
| default_finalise_settings_lodge_pay_run_timeline | Unknown |  |
| default_finalise_settings_publish_pay_slip | Unknown |  |
| default_finalise_settings_publish_pay_slips_day | Unknown |  |
| default_finalise_settings_publish_pay_slips_time_of_day | Unknown |  |
| default_finalise_settings_publish_pay_slips_timeline | Unknown |  |
| default_finalise_settings_report_packs_to_run | Json |  |
| default_finalise_settings_run_report_pack | Unknown |  |
| default_finalise_settings_run_report_packs_day | Unknown |  |
| default_finalise_settings_run_report_packs_time_of_day | Unknown |  |
| default_finalise_settings_run_report_packs_timeline | Unknown |  |
| default_finalise_settings_submit_to_pension_sync | Unknown |  |
| default_finalise_settings_submit_to_pension_sync_day | Unknown |  |
| default_finalise_settings_submit_to_pension_sync_time_of_day | Unknown |  |
| default_finalise_settings_submit_to_pension_sync_timeline | Unknown |  |
| default_finalise_settings_super_payment | Unknown |  |
| default_finalise_settings_suppress_notification | Unknown |  |
| employee_selection_strategy | Unknown |  |
| equal_monthly_payment | Unknown |  |
| external_id | Unknown |  |
| frequency | Unknown |  |
| ignored_pay_run_warning | Json |  |
| last_date_paid | Unknown |  |
| last_pay_run | Unknown |  |
| name | Unknown |  |
| pay_schedule_approval_settings_approvers_to_notify | Json |  |
| pay_schedule_approval_settings_notification_subject | Unknown |  |
| pay_schedule_approval_settings_notification_template | Unknown |  |
| pay_schedule_approval_settings_reminder_day | Unknown |  |
| pay_schedule_approval_settings_reminder_subject | Unknown |  |
| pay_schedule_approval_settings_reminder_template | Unknown |  |
| pay_schedule_approval_settings_require_approval | Unknown |  |
| pay_schedule_approval_settings_send_reminder | Unknown |  |
| pay_schedule_payment_approval_settings_approvers_to_notify | Json |  |
| pay_schedule_payment_approval_settings_notification_subject | Unknown |  |
| pay_schedule_payment_approval_settings_notification_template | Unknown |  |
| pay_schedule_payment_approval_settings_reminder_day | Unknown |  |
| pay_schedule_payment_approval_settings_reminder_subject | Unknown |  |
| pay_schedule_payment_approval_settings_reminder_template | Unknown |  |
| pay_schedule_payment_approval_settings_require_approval | Unknown |  |
| pay_schedule_payment_approval_settings_send_reminder | Unknown |  |
| payg_account_bsb | Unknown |  |
| payg_account_name | Unknown |  |
| payg_account_number | Unknown |  |
| payg_reference | Unknown |  |
| source | Unknown |  |

### qualification_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| qualification_qualification_id | Unknown | PK, FK |
| date_created | Unknown |  |
| name | Unknown |  |
| visible | Unknown |  |

### qualification

| Column | Type | Keys |
| --- | --- | --- |
| qualification_id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| expiry_date | Unknown |  |
| issue_date | Unknown |  |
| name | Unknown |  |
| reference_number | Unknown |  |

### expense_request_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expense_request_id | Unknown | PK, FK |
| date_created | Unknown |  |
| date_scanned | Unknown |  |
| friendly_name | Unknown |  |
| is_infected | Unknown |  |
| url | Unknown |  |

### expense_request_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expense_request_id | Unknown | PK, FK |
| expense_category_id | Unknown | FK |
| location_id | Unknown | FK |
| amount | Unknown |  |
| date_incurred | Unknown |  |
| expense_category_name | Unknown |  |
| notes | Unknown |  |
| tax_code | Unknown |  |
| tax_code_display_name | Unknown |  |
| tax_rate | Unknown |  |

### expense_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| date_created | Unknown |  |
| date_status_updated | Unknown |  |
| description | Unknown |  |
| status | Unknown |  |
| status_update_note | Unknown |  |
| status_updated_by_user | Unknown |  |

### leave_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| leave_category_id | Unknown | FK |
| attachment_id | Unknown |  |
| from_date | Unknown |  |
| hours_applied | Unknown |  |
| note | Unknown |  |
| status | Unknown |  |
| to_date | Unknown |  |
| total_hour | Unknown |  |

### leave_liability_report

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| business_id | Unknown | FK |
| accrued_amount | Unknown |  |
| accrued_amount_in_hour | Unknown |  |
| approved_leave_amount | Unknown |  |
| approved_leave_amount_in_hour | Unknown |  |
| calculated_week | Unknown |  |
| external_id | Unknown |  |
| last_paid_date | Unknown |  |
| last_pay_period_ending | Unknown |  |
| leave_category_name | Unknown |  |
| leave_loading_dollar_value | Unknown |  |
| leave_value | Unknown |  |
| location | Unknown |  |
| start_date | Unknown |  |
| unit_type | Unknown |  |

### pay_rate

| Column | Type | Keys |
| --- | --- | --- |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| pay_category_id | Unknown | PK, FK |
| accrues_leave | Unknown |  |
| calculated_rate | Double |  |
| has_super_rate_override | Unknown |  |
| is_primary_pay_category | Unknown |  |
| rate | Double |  |
| rate_unit | Unknown |  |
| super_rate | Unknown |  |

### employer_liability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| amount | Double |  |
| employer_liability_category_id | Unknown |  |
| employer_liability_category_name | Unknown |  |
| expiry_date | Unknown |  |
| external_reference_id | Unknown |  |
| from_date | Unknown |  |
| is_active | Unknown |  |
| liability_type | Unknown |  |
| maximum_amount_paid | Double |  |
| note | Unknown |  |
| source | Unknown |  |
| total_amount_paid | Double |  |

### pay_run_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| pay_run_id | Unknown | PK, FK |
| employee_id | Unknown | FK |
| earliest_termination_date | Unknown |  |
| employee_expenses_total | Unknown |  |
| employee_external_reference_id | Unknown |  |
| employer_contribution | Unknown |  |
| employer_contribution_adjustments_amount | Unknown |  |
| employer_liabilities_total | Unknown |  |
| is_complete | Unknown |  |
| is_employee_under_18 | Unknown |  |
| is_excluded | Unknown |  |
| is_termination | Unknown |  |
| member_voluntary_super_amount | Unknown |  |
| non_super_deduction_total | Unknown |  |
| pay_condition_rule_set_name | Unknown |  |
| payg_adjustments_amount | Unknown |  |
| payg_payment_total | Unknown |  |
| previous_termination_date | Unknown |  |
| salary_sacrifice_super_amount | Unknown |  |
| super_contributions_cap_applied | Unknown |  |
| termination_date | Unknown |  |

### pay_run_detail_total

| Column | Type | Keys |
| --- | --- | --- |
| business_id | Unknown | PK, FK |
| pay_run_id | Unknown | PK, FK |
| grand_total_employee_expense_total | Double |  |
| grand_total_employer_contribution | Double |  |
| grand_total_employer_liability_total | Double |  |
| grand_total_gross_earning | Double |  |
| grand_total_help_amount | Double |  |
| grand_total_net_earning | Double |  |
| grand_total_number_of_employee | Unknown |  |
| grand_total_payg_withholding_amount | Double |  |
| grand_total_post_tax_deduction_amount | Double |  |
| grand_total_pre_tax_deduction_amount | Double |  |
| grand_total_sfss_amount | Double |  |
| grand_total_super_contribution | Double |  |
| grand_total_taxable_earning | Double |  |
| grand_total_total_hour | Double |  |

### pay_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| parent_id | Unknown | FK |
| accrues_leave | Unknown |  |
| allowance_description | Unknown |  |
| award_id | Unknown |  |
| award_name | Unknown |  |
| default_super_rate | Unknown |  |
| external_id | Unknown |  |
| general_ledger_mapping_code | Unknown |  |
| hide_units_on_pay_slip | Unknown |  |
| is_payroll_tax_exempt | Unknown |  |
| is_primary | Unknown |  |
| is_system_pay_category | Unknown |  |
| is_tax_exempt | Unknown |  |
| name | Unknown |  |
| number_of_decimal_place | Unknown |  |
| pay_category_type | Unknown |  |
| payment_summary_classification | Unknown |  |
| penalty_loading_percent | Unknown |  |
| rate_loading_percent | Unknown |  |
| rate_unit | Unknown |  |
| rounding_method | Unknown |  |
| source | Unknown |  |
| super_expense_mapping_code | Unknown |  |
| super_liability_mapping_code | Unknown |  |

### unavailability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| business_id | Unknown | FK |
| employee_id | Unknown |  |
| end_date | Unknown |  |
| from_date | Unknown |  |
| is_all_day | Unknown |  |
| reason | Unknown |  |
| recurring | Unknown |  |
| recurring_day | Unknown |  |
| recurring_days | Unknown |  |
| recurring_days_csv | Unknown |  |
| to_date | Unknown |  |
| view_only | Unknown |  |

### pay_run_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| date_finalised | Unknown |  |
| date_paid | Unknown |  |
| external_id | Unknown |  |
| is_finalised | Unknown |  |
| notation | Unknown |  |
| pay_period_ending | Unknown |  |
| pay_period_starting | Unknown |  |
| pay_schedule_id | Unknown |  |
| pay_slips_published | Unknown |  |
| total_gross_wage | Unknown |  |
| total_hour | Unknown |  |
| total_net_wage | Unknown |  |

### leave_allowance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| leave_category_id | Unknown | FK |
| automatically_accrue | Unknown |  |
| can_apply_for_leave | Unknown |  |
| hours_per_year | Unknown |  |
| leave_accrual_rule_accrue_in_advance | Unknown |  |
| leave_accrual_rule_cap_type | Unknown |  |
| leave_accrual_rule_carry_over_amount | Unknown |  |
| leave_accrual_rule_carry_over_behaviour | Unknown |  |
| leave_accrual_rule_id | Unknown |  |
| leave_accrual_rule_leave_year_offset_amount | Unknown |  |
| leave_accrual_rule_type | Unknown |  |
| leave_accrual_rule_unit_cap | Unknown |  |
| leave_loading | Unknown |  |
| leave_unit_type | Unknown |  |
| unit_type | Unknown |  |
| units | Unknown |  |

### leave_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| transfer_on_termination_to_pay_category_id | Unknown | FK |
| transfer_to_pay_category_id | Unknown | FK |
| accrues_first_pay_run_per_period_only | Unknown |  |
| automatically_accrue | Unknown |  |
| contingent_period | Unknown |  |
| deduct_from_pay_category_id | Unknown |  |
| deduct_from_primary_pay_category | Unknown |  |
| entitlement_period | Unknown |  |
| exclude_from_termination_payout | Unknown |  |
| external_id | Unknown |  |
| hide_accruals_on_payslip | Unknown |  |
| is_balance_untracked | Unknown |  |
| is_name_private | Unknown |  |
| is_private | Unknown |  |
| leave_accrual_rule | Json |  |
| leave_category_type | Unknown |  |
| leave_loading | Unknown |  |
| leave_unit_type | Unknown |  |
| name | Unknown |  |
| payout_as_etp | Unknown |  |
| prevent_negative_balance_unpaid_leave_category_id | Unknown |  |
| source | Unknown |  |
| unit | Unknown |  |
| unit_type | Unknown |  |
| use_deduct_from_pay_category_rate | Unknown |  |

### pay_slip_super_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| fund_name | Unknown |  |
| member_number | Unknown |  |

### pay_slip_bank_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| account_name | Unknown |  |
| account_number | Unknown |  |
| amount | Unknown |  |
| bsb | Unknown |  |
| lodgement_reference | Unknown |  |

### pay_slip_earnings_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| gross_earning | Unknown |  |
| is_fixed | Unknown |  |
| is_tax_exempt | Unknown |  |
| location_name | Unknown |  |
| note | Unknown |  |
| pay_category_name | Unknown |  |
| rate | Unknown |  |
| super_contribution | Unknown |  |
| taxable_earning | Unknown |  |
| unit | Unknown |  |

### pay_slip_accrued_leave

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| leave_category | Unknown |  |
| note | Unknown |  |

### pay_slip_gross_ytd_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| gross_earning | Unknown |  |
| pay_category_name | Unknown |  |

### pay_slip_deduction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| tax_status | Unknown |  |

### pay_slip_leave_taken

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| leave_category | Unknown |  |
| note | Unknown |  |

### pay_slip_payg_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| note | Unknown |  |

### pay_slip_super_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_slip_id | Unknown | PK, FK |
| amount | Unknown |  |
| note | Unknown |  |

### pay_slip

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| pay_run_id | Unknown | FK |
| abn | Unknown |  |
| employee_base_rate | Unknown |  |
| employee_base_rate_unit | Unknown |  |
| help_amount | Unknown |  |
| help_ytd | Unknown |  |
| hourly_rate | Unknown |  |
| is_published | Unknown |  |
| message | Unknown |  |
| net_earning | Unknown |  |
| net_ytd | Unknown |  |
| notation | Unknown |  |
| pay_period_ending | Unknown |  |
| pay_period_starting | Unknown |  |
| payg_withholding_amount | Unknown |  |
| payg_ytd | Unknown |  |
| post_tax_deduction_amount | Unknown |  |
| post_tax_deductions_ytd | Unknown |  |
| pre_tax_deduction_amount | Unknown |  |
| pre_tax_deductions_ytd | Unknown |  |
| sfss_amount | Unknown |  |
| sfss_ytd | Unknown |  |
| super_contribution | Unknown |  |
| super_ytd | Unknown |  |
| taxable_earning | Unknown |  |
| total_hour | Unknown |  |
| withholding_ytd | Unknown |  |

### pay_rate_template_pay_category

| Column | Type | Keys |
| --- | --- | --- |
| pay_category_id | Unknown | PK, FK |
| pay_rate_template_id | Unknown | PK, FK |
| calculated_rate | Unknown |  |
| standard_weekly_hour | Unknown |  |
| user_supplied_rate | Unknown |  |

### pay_rate_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| primary_pay_category_id | Unknown | FK |
| external_id | Unknown |  |
| maximum_quarterly_super_contribution_base | Unknown |  |
| name | Unknown |  |
| reapply_to_linked_employee | Unknown |  |
| source | Unknown |  |
| super_threshold_amount | Unknown |  |

### employee_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| leave_request_id | Unknown | FK |
| date_created | Unknown |  |
| friendly_name | Unknown |  |
| timesheet_line_id | Unknown |  |
| visible | Unknown |  |

### aba

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| account_name | Unknown |  |
| account_number | Unknown |  |
| balance_additional_content | Unknown |  |
| balance_lodgement_reference | Unknown |  |
| bsb | Unknown |  |
| financial_institution_code | Unknown |  |
| include_self_balancing_transaction | Unknown |  |
| lodgement_reference | Unknown |  |
| merge_multiple_account_payment | Unknown |  |
| payment_additional_content | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |

### leave_balance

| Column | Type | Keys |
| --- | --- | --- |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| leave_category_id | Unknown | PK, FK |
| accrued_amount | Double |  |
| unit_type | Unknown |  |

### pay_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| pay_schedule_id | Unknown | FK |
| date_finalised | Unknown |  |
| date_paid | Unknown |  |
| external_id | Unknown |  |
| is_finalised | Unknown |  |
| notation | Unknown |  |
| pay_period_ending | Unknown |  |
| pay_period_starting | Unknown |  |
| pay_slips_published | Unknown |  |

### business

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| abn | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| budget_entry_method | Unknown |  |
| budget_warning_percent | Unknown |  |
| contact_email_address | Unknown |  |
| contact_fax_number | Unknown |  |
| contact_name | Unknown |  |
| contact_phone_number | Unknown |  |
| date_created | Unknown |  |
| default_super_rate | Unknown |  |
| end_of_week | Unknown |  |
| external_id | Unknown |  |
| foreign_entity_country | Unknown |  |
| industry_name | Unknown |  |
| initial_financial_year_start | Unknown |  |
| is_foreign_entity | Unknown |  |
| journal_service | Unknown |  |
| leave_accrual_start_date_type | Unknown |  |
| leave_year_start | Unknown |  |
| legal_name | Unknown |  |
| management_software_id | Unknown |  |
| managers_can_edit_roster_budget | Unknown |  |
| name | Unknown |  |
| number_of_employees | Unknown |  |
| pay_cycle_frequency | Unknown |  |
| post_code | Unknown |  |
| promo_code | Unknown |  |
| region | Unknown |  |
| sbr_software_id | Unknown |  |
| sbr_software_provider | Unknown |  |
| source | Unknown |  |
| standard_hours_per_day | Unknown |  |
| state | Unknown |  |
| suburb | Unknown |  |
| white_label_id | Unknown |  |
| white_label_name | Unknown |  |

### employee_standard_hour_work_day

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| work_type_id | Unknown | FK |
| break_end_time | Unknown |  |
| break_start_time | Unknown |  |
| day_name | Unknown |  |
| day_of_week | Unknown |  |
| end_time | Unknown |  |
| hours | Unknown |  |
| start_time | Unknown |  |
| week | Unknown |  |
| work_day_type | Unknown |  |

### employee_standard_hour

| Column | Type | Keys |
| --- | --- | --- |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| advanced_work_week_configuration | Unknown |  |
| full_time_equivalent_hour | Unknown |  |
| standard_hours_per_day | Unknown |  |
| standard_hours_per_week | Unknown |  |
| standard_hours_reference_date | Unknown |  |
| use_advanced_work_week | Unknown |  |

### business_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| name | Unknown |  |

### timesheet_break

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| timesheet_id | Unknown | PK, FK |
| end_time | Unknown |  |
| is_paid_break | Unknown |  |
| start_time | Unknown |  |

### timesheet_shift_condition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| timesheet_id | Unknown | PK, FK |
| name | Unknown |  |

### timesheet_dimension_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| timesheet_id | Unknown | PK, FK |
| name | Unknown |  |
| reporting_dimension_id | Unknown |  |

### timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | FK |
| business_id | Unknown | FK |
| employee_id | Unknown | FK |
| leave_category_id | Unknown | FK |
| location_id | Unknown | FK |
| pay_category_id | Unknown | FK |
| work_type_id | Unknown | FK |
| attachment_data | Unknown |  |
| attachment_date_created | Unknown |  |
| attachment_date_scanned | Unknown |  |
| attachment_friendly_name | Unknown |  |
| attachment_is_deleted | Unknown |  |
| attachment_is_infected | Unknown |  |
| attachment_url | Unknown |  |
| classification | Unknown |  |
| classification_id | Unknown |  |
| comment | Unknown |  |
| end_time | Unknown |  |
| external_id | Unknown |  |
| fully_qualified_location_name | Unknown |  |
| hidden_comment | Unknown |  |
| location_is_deleted | Unknown |  |
| rate | Unknown |  |
| shift_condition_ids | Json |  |
| source | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| submitted_by_user | Unknown |  |
| unit | Unknown |  |
| work_type | Unknown |  |

### employee_super_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| adjustment_type | Unknown |  |
| amount | Double |  |
| contribution_type | Unknown |  |
| expiry_date | Unknown |  |
| from_date | Unknown |  |
| is_active | Unknown |  |
| maximum_amount_paid | Double |  |
| note | Unknown |  |
| total_amount_paid | Double |  |

### employee_group_filter

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| employee_group_id | Unknown | FK |
| filter_type | Unknown |  |
| operator | Unknown |  |
| value | Unknown |  |

### employee_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| filter_combination_strategy | Unknown |  |
| name | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| parent_id | Unknown | FK |
| country | Unknown |  |
| default_shift_condition_ids | Json |  |
| external_accounting_location_id | Unknown |  |
| external_id | Unknown |  |
| fully_qualified_name | Unknown |  |
| general_ledger_mapping_code | Unknown |  |
| is_global | Unknown |  |
| is_rollup_reporting_location | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |

### employing_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | PK, FK |
| abn | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| branch_code | Unknown |  |
| contact_email_address | Unknown |  |
| contact_fax_number | Unknown |  |
| contact_name | Unknown |  |
| contact_phone_number | Unknown |  |
| external_reference_id | Unknown |  |
| fbt_exempt_organisation_type | Unknown |  |
| foreign_entity_country | Unknown |  |
| has_separate_entertainment_fringe_benefits_cap | Unknown |  |
| is_exempt_from_fringe_benefits_tax | Unknown |  |
| is_foreign_entity | Unknown |  |
| name | Unknown |  |
| pay_slip_from_email_address | Unknown |  |
| postcode | Unknown |  |
| signatory_name | Unknown |  |
| state | Unknown |  |
| suburb | Unknown |  |

### invoice_line_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| invoice_id | Unknown | FK |
| invoice_line_item_index | Unknown | FK |
| description | Unknown |  |
| group_name | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| business_id | Unknown | FK |
| billing_plan | Unknown |  |
| brand_name | Unknown |  |
| business_number | Unknown |  |
| description | Unknown |  |
| quantity | Unknown |  |
| total_including_gst | Unknown |  |
| unit_price_including_gst | Unknown |  |
| white_label_name | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| culture_name | Unknown |  |
| currency | Unknown |  |
| date | Instant |  |
| gst | Unknown |  |
| invoice_number | Unknown |  |
| total_excluding_gst | Unknown |  |
| total_including_gst | Unknown |  |

### deduction_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| expense_general_ledger_mapping_code | Unknown |  |
| external_id | Unknown |  |
| is_resc | Unknown |  |
| is_system | Unknown |  |
| liability_general_ledger_mapping_code | Unknown |  |
| name | Unknown |  |
| payment_summary_classification | Unknown |  |
| sgc_calculation_impact | Unknown |  |
| source | Unknown |  |
| tax_exempt | Unknown |  |

### leave_allowance_template_leave_category

| Column | Type | Keys |
| --- | --- | --- |
| leave_allowance_template_id | Unknown | PK, FK |
| leave_category_id | Unknown | PK, FK |
| accrual_rule_leave_year_offset_amount | Unknown |  |
| leave_accrual_rule_accrual_type | Unknown |  |
| leave_accrual_rule_accrue_in_advance | Unknown |  |
| leave_accrual_rule_cap_type | Unknown |  |
| leave_accrual_rule_carry_over_amount | Unknown |  |
| leave_accrual_rule_carry_over_behaviour | Unknown |  |
| leave_accrual_rule_unit_cap | Unknown |  |

### leave_allowance_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| leave_loading_calculated_from_pay_category_id | Unknown | FK |
| award_id | Unknown |  |
| award_name | Unknown |  |
| external_id | Unknown |  |
| leave_year_start | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |

### employee_expense_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| description | Unknown |  |
| external_id | Unknown |  |
| external_reference_id | Unknown |  |
| external_tax_code_id | Unknown |  |
| general_ledger_mapping_code | Unknown |  |
| name | Unknown |  |
| tax_code | Unknown |  |
| tax_rate | Unknown |  |

## Relationships

- roster_shift_qualification(id) → qualification(qualification_id)
- roster_shift_qualification(roster_shift_id) → roster_shift(id)
- roster_shift_break(roster_shift_id) → roster_shift(id)
- roster_shift(employee_id) → employee(id)
- roster_shift(location_id) → location(id)
- roster_shift(work_type_id) → work_type(id)
- roster_shift(pending_swap_to_employee_id) → employee(id)
- roster_shift(pending_swap_from_employee_id) → employee(id)
- roster_shift(business_id) → business(id)
- employee(employing_entity_id) → employing_entity(id)
- employee(business_id) → business(id)
- employee_additional_earning(employee_id) → employee(id)
- employee_additional_earning(location_id) → location(id)
- employee_additional_earning(pay_category_id) → pay_category(id)
- employee_additional_earning(business_id) → employee(business_id)
- employee_tax_adjustment(employee_id) → employee(id)
- employee_tax_adjustment(business_id) → employee(business_id)
- employee_portal_setting(business_id) → business(id)
- business_qualification(business_id) → business(id)
- super_fund(employee_id) → employee(id)
- super_fund(business_id) → employee(business_id)
- pay_slip_configuration(business_id) → business(id)
- pay_rate_adjustment_schedule(employee_id) → employee(id)
- pay_rate_adjustment_schedule(business_id) → business(id)
- bank_account(employee_id) → employee(id)
- bank_account(business_id) → employee(business_id)
- public_holiday_location(id) → location(id)
- public_holiday_location(public_holiday_fivetran_id) → public_holiday(_fivetran_id)
- public_holiday(business_id) → business(id)
- employment_agreement(business_id) → business(id)
- employee_expense(employee_id) → employee(id)
- employee_expense(expense_category_id) → employee_expense_category(id)
- employee_expense(location_id) → location(id)
- employee_expense(business_id) → business(id)
- work_type(pay_category_id) → pay_category(id)
- work_type(leave_category_id) → leave_category(id)
- work_type(business_id) → business(id)
- employee_deduction(deduction_category_id) → deduction_category(id)
- employee_deduction(paid_to_account_id) → bank_account(id)
- employee_deduction(employee_id) → employee(id)
- employee_deduction(business_id) → employee(business_id)
- pay_schedule_location(id) → location(id)
- pay_schedule_location(pay_schedule_id) → pay_schedule(id)
- pay_schedule(business_id) → business(id)
- qualification_document(qualification_qualification_id) → qualification(qualification_id)
- qualification(employee_id) → employee(id)
- qualification(business_id) → business(id)
- expense_request_attachment(expense_request_id) → expense_request(id)
- expense_request_line_item(expense_category_id) → employee_expense_category(id)
- expense_request_line_item(location_id) → location(id)
- expense_request_line_item(expense_request_id) → expense_request(id)
- expense_request(employee_id) → employee(id)
- expense_request(business_id) → employee(business_id)
- leave_request(employee_id) → employee(id)
- leave_request(leave_category_id) → leave_category(id)
- leave_request(business_id) → business(id)
- leave_liability_report(employee_id) → employee(id)
- leave_liability_report(business_id) → business(id)
- pay_rate(pay_category_id) → pay_category(id)
- pay_rate(employee_id) → employee(id)
- pay_rate(business_id) → employee(business_id)
- employer_liability(employee_id) → employee(id)
- employer_liability(business_id) → employee(business_id)
- pay_run_detail(employee_id) → employee(id)
- pay_run_detail(pay_run_id) → pay_run_detail_total(pay_run_id)
- pay_run_detail(business_id) → pay_run_detail_total(business_id)
- pay_run_detail_total(pay_run_id) → pay_run(id)
- pay_run_detail_total(business_id) → pay_run(business_id)
- pay_category(parent_id) → pay_category(id)
- pay_category(business_id) → business(id)
- unavailability(id) → employee(id)
- unavailability(business_id) → business(id)
- pay_run_summary(business_id) → business(id)
- leave_allowance(leave_category_id) → leave_category(id)
- leave_allowance(employee_id) → employee(id)
- leave_allowance(business_id) → business(id)
- leave_category(transfer_on_termination_to_pay_category_id) → pay_category(id)
- leave_category(transfer_to_pay_category_id) → pay_category(id)
- leave_category(business_id) → business(id)
- pay_slip_super_payment(pay_slip_id) → pay_slip(id)
- pay_slip_bank_payment(pay_slip_id) → pay_slip(id)
- pay_slip_earnings_line(pay_slip_id) → pay_slip(id)
- pay_slip_accrued_leave(pay_slip_id) → pay_slip(id)
- pay_slip_gross_ytd_detail(pay_slip_id) → pay_slip(id)
- pay_slip_deduction(pay_slip_id) → pay_slip(id)
- pay_slip_leave_taken(pay_slip_id) → pay_slip(id)
- pay_slip_payg_adjustment(pay_slip_id) → pay_slip(id)
- pay_slip_super_adjustment(pay_slip_id) → pay_slip(id)
- pay_slip(employee_id) → employee(id)
- pay_slip(business_id) → pay_run(business_id)
- pay_slip(pay_run_id) → pay_run(id)
- pay_rate_template_pay_category(pay_category_id) → pay_category(id)
- pay_rate_template_pay_category(pay_rate_template_id) → pay_rate_template(id)
- pay_rate_template(primary_pay_category_id) → pay_category(id)
- pay_rate_template(business_id) → business(id)
- employee_document(leave_request_id) → leave_request(id)
- employee_document(employee_id) → employee(id)
- employee_document(business_id) → employee(business_id)
- aba(business_id) → business(id)
- leave_balance(leave_category_id) → leave_category(id)
- leave_balance(employee_id) → employee(id)
- leave_balance(business_id) → employee(business_id)
- pay_run(pay_schedule_id) → pay_schedule(id)
- pay_run(business_id) → business(id)
- employee_standard_hour_work_day(location_id) → location(id)
- employee_standard_hour_work_day(work_type_id) → work_type(id)
- employee_standard_hour_work_day(employee_id) → employee_standard_hour(employee_id)
- employee_standard_hour_work_day(business_id) → employee_standard_hour(business_id)
- employee_standard_hour(employee_id) → employee(id)
- employee_standard_hour(business_id) → employee(business_id)
- business_tag(business_id) → business(id)
- timesheet_break(timesheet_id) → timesheet(id)
- timesheet_shift_condition(timesheet_id) → timesheet(id)
- timesheet_dimension_value(timesheet_id) → timesheet(id)
- timesheet(employee_id) → employee(id)
- timesheet(location_id) → location(id)
- timesheet(work_type_id) → work_type(id)
- timesheet(pay_category_id) → pay_category(id)
- timesheet(leave_category_id) → leave_category(id)
- timesheet(attachment_id) → leave_request(attachment_id)
- timesheet(business_id) → business(id)
- employee_super_adjustment(employee_id) → employee(id)
- employee_super_adjustment(business_id) → employee(business_id)
- employee_group_filter(employee_group_id) → employee_group(id)
- employee_group(business_id) → business(id)
- location(parent_id) → location(id)
- location(business_id) → business(id)
- employing_entity(business_id) → business(id)
- invoice_line_item_detail(invoice_line_item_index) → invoice_line_item(index)
- invoice_line_item_detail(invoice_id) → invoice_line_item(invoice_id)
- invoice_line_item(business_id) → business(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice(business_id) → business(id)
- deduction_category(business_id) → business(id)
- leave_allowance_template_leave_category(leave_category_id) → leave_category(id)
- leave_allowance_template_leave_category(leave_allowance_template_id) → leave_allowance_template(id)
- leave_allowance_template(leave_loading_calculated_from_pay_category_id) → pay_category(id)
- leave_allowance_template(business_id) → business(id)
- employee_expense_category(business_id) → business(id)