# UKG Pro schema ERD

Table and field reference for the Fivetran UKG Pro connector.

## Table & Field Reference

### employee_job_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| home_company_id | Unknown | FK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| organization_level_1_id | String | FK |
| organization_level_2_id | String | FK |
| organization_level_3_id | String | FK |
| organization_level_4_id | String | FK |
| pay_group_id | Unknown | FK |
| supervisor_id | Unknown | FK |
| annual_salary | Double |  |
| created_by_user_id | Unknown |  |
| date_time_created | LocalDateTime |  |
| employee_status | Unknown |  |
| employee_type | Unknown |  |
| flsa_category | Unknown |  |
| full_time_or_part_time | Unknown |  |
| hourly_pay_rate | Unknown |  |
| integration_effective_date | Unknown |  |
| is_job_change | Unknown |  |
| is_orgchange | Unknown |  |
| is_outside_guidelines | Unknown |  |
| is_outside_range | Unknown |  |
| is_promotion | Unknown |  |
| is_rate_change | Unknown |  |
| is_system | Unknown |  |
| is_transfer | Unknown |  |
| is_viewable_by_employee | Unknown |  |
| job_effective_date | Unknown |  |
| job_group_code | Unknown |  |
| job_title | Unknown |  |
| notes | Unknown |  |
| number_of_payments | Unknown |  |
| other_rate_1 | Unknown |  |
| other_rate_2 | Unknown |  |
| other_rate_3 | Unknown |  |
| other_rate_4 | Unknown |  |
| pay_period_code | Unknown |  |
| pay_scale_code | Unknown |  |
| percent_change | Unknown |  |
| period_pay_rate | Unknown |  |
| piece_pay_rate | Unknown |  |
| position_code | Unknown |  |
| project_code | Unknown |  |
| reason_code | Unknown |  |
| salary_grade | Unknown |  |
| salary_or_hourly | Unknown |  |
| scheduled_annual_hours | Unknown |  |
| scheduled_full_time_equivalency | Unknown |  |
| scheduled_work_hours | Unknown |  |
| shift_code | Unknown |  |
| shift_group_code | Unknown |  |
| step_number | Unknown |  |
| supervisor_name_first | Unknown |  |
| supervisor_name_last | Unknown |  |
| supervisor_name_suffix | Unknown |  |
| supervisor_not_in_list | Unknown |  |
| union_local | Unknown |  |
| union_national | Unknown |  |
| use_pay_scales | Unknown |  |
| weekly_hours | Unknown |  |
| weekly_pay_rate | Unknown |  |

### education

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| begin_date | Unknown |  |
| country | Unknown |  |
| end_date | Unknown |  |
| gpa | Unknown |  |
| is_graduate | Unknown |  |
| is_highest_level | Unknown |  |
| level | Unknown |  |
| major | Unknown |  |
| minor | Unknown |  |
| school | Unknown |  |

### employee_security_user

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| last_logon | Unknown |  |
| password_last_changed | Unknown |  |

### pay_register

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| location_id | Unknown | FK |
| organization_level_1_id | Unknown | FK |
| organization_level_2_id | Unknown | FK |
| organization_level_3_id | Unknown | FK |
| organization_level_4_id | Unknown | FK |
| pay_group | Unknown | FK |
| annual_salary | Double |  |
| auto_allocate | Unknown |  |
| bonus_total_hours | Unknown |  |
| bonus_total_ot_hours | Unknown |  |
| check_add_mode | Unknown |  |
| check_amount | Unknown |  |
| currency_code | Unknown |  |
| direct_deposit_amount | Unknown |  |
| document_number | Unknown |  |
| earning_tax_reporting_type | Unknown |  |
| employee_status | Unknown |  |
| hourly_pay_rate | Unknown |  |
| is_regular_pay_for_cumulative | Unknown |  |
| is_voided | Unknown |  |
| is_voiding_record | Unknown |  |
| job_code | Unknown |  |
| last_regular_pay_date | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| name_middle | Unknown |  |
| name_suffix | Unknown |  |
| net_amount | Unknown |  |
| original_pay_period_frequency | Unknown |  |
| pay_date | Unknown |  |
| pay_period_frequency | Unknown |  |
| project | Unknown |  |
| reconcile_date | Unknown |  |
| reconciled | Unknown |  |
| sequence_number | Unknown |  |
| shift | Unknown |  |
| ssn | Unknown |  |
| state_sui | Unknown |  |
| sui_gross | Unknown |  |
| tax_calculation_group_id | Unknown |  |
| tax_calculation_sequence | Unknown |  |
| total_deduction_amount | Unknown |  |
| total_earnings_amount | Unknown |  |
| total_hours | Unknown |  |
| total_hours_worked | Unknown |  |
| total_shift_amount | Unknown |  |
| total_tax_amount | Unknown |  |
| void_date | Unknown |  |

### earning_history_base_element

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| earning_id | Unknown | FK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| pay_group | Unknown | FK |
| accrual_code | Unknown |  |
| base_amount | Unknown |  |
| batch_id | Unknown |  |
| calculation_rule | Unknown |  |
| calculation_sequence | Unknown |  |
| current_amount | Unknown |  |
| current_hours | Unknown |  |
| gen_number | Unknown |  |
| gl_base_segment_id | Unknown |  |
| gl_follow_base_account_allocation | Unknown |  |
| gross_up | Unknown |  |
| gross_up_target | Unknown |  |
| gross_up_tax_calculation_method | Unknown |  |
| hourly_pay_rate | Unknown |  |
| include_in_deferred_compensation | Unknown |  |
| include_in_deferred_compensation_hours | Unknown |  |
| is_voided | Unknown |  |
| is_voiding_record | Unknown |  |
| job_premium_amount | Unknown |  |
| job_premium_rate_or_percent | Unknown |  |
| number_of_days | Unknown |  |
| number_of_games | Unknown |  |
| pay_date | Unknown |  |
| pay_rate | Unknown |  |
| pay_sheet_id | Unknown |  |
| payout_rate_type | Unknown |  |
| period_control | Unknown |  |
| period_pay_rate | Unknown |  |
| piece_count | Unknown |  |
| piece_pay_rate | Unknown |  |
| plan_year | Unknown |  |
| project | Unknown |  |
| report_category | Unknown |  |
| tax_calculation_group_id | Unknown |  |
| tax_category | Unknown |  |
| time_clock_code | Unknown |  |
| tip_credit | Unknown |  |
| tip_gross_receipts | Unknown |  |
| tip_type | Unknown |  |
| use_deduction_off_set | Unknown |  |
| ytd_amount | Unknown |  |
| ytd_shift_amount | Unknown |  |

### phone_number_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| home_phone_number | Unknown | FK |
| address_id | Unknown |  |
| address_is_different_from_employee | Unknown |  |
| city | Unknown |  |
| cobra_notes | Unknown |  |
| country_code | Unknown |  |
| county | Unknown |  |
| death_date | Unknown |  |
| divorce_date | Unknown |  |
| gender | Unknown |  |
| health_care_id | Unknown |  |
| home_phone_id | Unknown |  |
| import_id | Unknown |  |
| is_active | Unknown |  |
| is_beneficiary | Unknown |  |
| is_dependent | Unknown |  |
| is_disabled | Unknown |  |
| is_emergency_contact | Unknown |  |
| is_smoker | Unknown |  |
| is_student | Unknown |  |
| marriage_date | Unknown |  |
| name_suffix | Unknown |  |
| national_id | Unknown |  |
| national_id_expiration_date | Unknown |  |
| notes | Unknown |  |
| occupation | Unknown |  |
| other_insurance | Unknown |  |
| other_phone_country_code | Unknown |  |
| other_phone_id | Unknown |  |
| other_phone_number | Unknown |  |
| other_phone_type | Unknown |  |
| person_id | Unknown |  |
| preferred_phone_number | Unknown |  |
| relationship_code | Unknown |  |
| relationship_description | Unknown |  |
| row_last_changed | Unknown |  |
| ssn | Unknown |  |
| state | Unknown |  |
| status_as_of_date | Unknown |  |
| user_defined_field_0_1 | Unknown |  |
| work_phone_extension | Unknown |  |
| work_phone_id | Unknown |  |
| work_phone_number | Unknown |  |
| zip_code | Unknown |  |

### person_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_person

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### employee_user_defined_field_company

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| custom_** |  |  |

### employee_user_defined_field

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| custom_** |  |  |

### employee_multiple_job

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| job_id | Unknown | FK |
| annual_pay_rate | Unknown |  |
| date_in_job | Unknown |  |
| hourly_pay_rate | Unknown |  |
| is_in_active | Unknown |  |
| is_primary_job | Unknown |  |
| other_rate_1 | Unknown |  |
| other_rate_2 | Unknown |  |
| other_rate_3 | Unknown |  |
| other_rate_4 | Unknown |  |
| piece_pay_rate | Unknown |  |

### employee_status

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| as_of_date | Unknown |  |
| is_primary | Unknown |  |
| is_primary_effective_date | Unknown |  |
| original_hire_date | Unknown |  |
| status | Unknown |  |
| status_reason | Unknown |  |
| status_reason_desc | Unknown |  |
| status_start_date | Unknown |  |
| trigger_termination | Unknown |  |

### job_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_job

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### org_level_4_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_org_level_4

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### org_level_3_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_org_level_3

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### org_level_2_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_org_level_2

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### org_level_1_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_org_level_1

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### organization_reporting_category

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

### employee_demographic

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| integration_record_id | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| user_last_logon_date | Unknown |  |
| user_last_password_change_date | Unknown |  |

### employment_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_employment

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### general_ledger

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_code | Unknown | FK |
| job_id | Unknown | FK |
| organization_level_1_id | Unknown | FK |
| organization_level_2_id | Unknown | FK |
| organization_level_3_id | Unknown | FK |
| organization_level_4_id | Unknown | FK |
| pay_group | Unknown | FK |
| account_type | Unknown |  |
| base_segment | Unknown |  |
| block_id | Unknown |  |
| co_id | Unknown |  |
| credit_amt | Unknown |  |
| debit_amt | Unknown |  |
| description | Unknown |  |
| general_ledger_account | Unknown |  |
| gl_json | Unknown |  |
| gl_run_date_time | Unknown |  |
| job_desc | Unknown |  |
| location | Unknown |  |
| pay_period_end_date | Unknown |  |
| pay_period_start_date | Unknown |  |
| period_end_date | Unknown |  |
| period_start_date | Unknown |  |
| position_code | Unknown |  |
| position_desc | Unknown |  |
| project | Unknown |  |
| run_id | Unknown |  |
| system_id | Unknown |  |
| total_nr_of_blocks | Unknown |  |
| user_who_ran_this_gl | Unknown |  |

### national_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| date_time_changed | Unknown |  |
| date_time_created | Unknown |  |
| description | Unknown |  |
| document_code | Unknown |  |
| document_number | Unknown |  |
| issue_date | Unknown |  |
| issuing_country_code | Unknown |  |
| issuing_place | Unknown |  |

### pay_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_web_pyrl_after_ye_recon | Unknown |  |
| audit_key | Unknown |  |
| bring_in_payroll_batch_load | Unknown |  |
| bring_in_ppi_load | Unknown |  |
| bring_in_retro_pay_load | Unknown |  |
| combine_nacha_file_name | Unknown |  |
| combine_nacha_file_override | Unknown |  |
| date_time_changed | Unknown |  |
| date_time_created | Unknown |  |
| date_time_fiscal_end_done | Unknown |  |
| date_time_period_closed | Unknown |  |
| date_time_period_opened | Unknown |  |
| fiscal_year_end | Unknown |  |
| instant_check_move_rule | Unknown |  |
| is_active | Unknown |  |
| is_cts_created | Unknown |  |
| is_period_closed | Unknown |  |
| is_qtdob_per_control | Unknown |  |
| is_ytdob_per_control | Unknown |  |
| lmw_active | Unknown |  |
| monthly_pay_period_number | Unknown |  |
| mqy_end_flag | Unknown |  |
| notes | Unknown |  |
| ob_type | Unknown |  |
| pay_date | Unknown |  |
| pay_date_seq | Unknown |  |
| pay_group | Unknown |  |
| payroll_change_flags | Unknown |  |
| payroll_state_id | Unknown |  |
| payroll_transition_flags | Unknown |  |
| period_control | Unknown |  |
| period_end_date | Unknown |  |
| period_start_date | Unknown |  |
| period_type | Unknown |  |
| roe_pay_date | Unknown |  |
| susp_auto_pay | Unknown |  |
| susp_direct_deposit | Unknown |  |
| tax_arrears_collect_enabled | Unknown |  |
| tx_fil_app_date_time | Unknown |  |
| tx_fil_app_user_id | Unknown |  |
| user_id_changed | Unknown |  |
| user_id_created | Unknown |  |

### phone_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| audit_key | Unknown |  |
| country_code | Unknown |  |
| country_prefix | Unknown |  |
| extension | Unknown |  |
| is_private | Unknown |  |
| number | Unknown |  |
| type_code | Unknown |  |

### dependent_deduction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| contact_id | Unknown | FK |
| employee_id | Unknown | FK |
| benefit_amount | Unknown |  |
| benefit_start_date | Unknown |  |
| benefit_status | Unknown |  |
| benefit_status_date | Unknown |  |
| benefit_stop_date | Unknown |  |
| certificate_no | Unknown |  |
| code | Unknown |  |
| current_co_id | Unknown |  |
| date_time_changed | Unknown |  |
| date_time_created | Unknown |  |
| declined_by_carrier | Unknown |  |
| declined_by_carrier_date | Unknown |  |
| declined_by_carrier_reason | Unknown |  |
| dep_b_plan_tv_id | Unknown |  |
| eoi_date | Unknown |  |
| is_benefit_waived | Unknown |  |
| need_eoi | Unknown |  |
| notes | Unknown |  |
| primary_care_physician | Unknown |  |
| primary_care_physician_id | Unknown |  |
| type | Unknown |  |

### position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| pay_group_id | Unknown | FK |
| alternate_title | Unknown |  |
| date_time_changed | Unknown |  |
| date_time_created | Unknown |  |
| effective_start_date | Unknown |  |
| effective_stop_date | Unknown |  |
| employee_type | Unknown |  |
| fund_id | Unknown |  |
| integration_record_id | Unknown |  |
| is_approved | Unknown |  |
| is_eligible_for_benefits | Unknown |  |
| is_prorated | Unknown |  |
| notes | Unknown |  |
| organization_level_code_1 | Unknown |  |
| organization_level_code_2 | Unknown |  |
| organization_level_code_3 | Unknown |  |
| organization_level_code_4 | Unknown |  |
| overstaffing_allowed | Unknown |  |
| project_code | Unknown |  |
| shift_group_code | Unknown |  |
| status_as_of_date | Unknown |  |
| status_code | Unknown |  |
| user_defined_field_0_1 | Unknown |  |
| user_defined_field_0_2 | Unknown |  |
| user_defined_field_0_3 | Unknown |  |
| user_defined_field_0_4_is_null | Unknown |  |
| user_defined_field_0_4_value | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_code | Unknown |  |
| eeo_category | Unknown |  |
| flsa_type_code | Unknown |  |
| groups | Unknown |  |
| is_active | Unknown |  |
| job_family_code | Unknown |  |
| long_description | Unknown |  |
| title | Unknown |  |

### employee_supervisor

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| employment_id | Unknown | PK, FK |
| company_id | Unknown | FK |
| supervisor_company_id | Unknown | FK |
| supervisor_employee_id | Unknown | FK |
| supervisor_employment_id | Unknown | FK |
| supervisor_job_id | Unknown | FK |
| supervisor_position_id | Unknown | FK |
| supervisor_person_id | Unknown |  |

### position_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| position_id | Unknown | FK |
| date_time_changed | Unknown |  |
| date_time_created | Unknown |  |
| effective_start_date | Unknown |  |
| effective_stop_date | Unknown |  |
| reports_to_position_code | Unknown |  |

### organization_level

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| level | Unknown | PK |
| budget_group | Unknown |  |
| current_year_budget_fte | Unknown |  |
| current_year_budget_salary | Unknown |  |
| description | Unknown |  |
| gl_segment | Unknown |  |
| is_active | Unknown |  |
| last_year_budget_fte | Unknown |  |
| last_year_budget_salary | Unknown |  |
| level_description | Unknown |  |
| reporting_category | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_role | Unknown |  |
| default_role_terminated | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| rol_bi | Unknown |  |

### location_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_location

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### international_employee_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_international_employee

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| filter_company_id | Unknown | FK |
| filter_job_id | Unknown | FK |
| filter_location_id | Unknown | FK |
| filter_organization_level_1_id | Unknown | FK |
| filter_organization_level_2_id | Unknown | FK |
| filter_organization_level_3_id | Unknown | FK |
| filter_organization_level_4_id | Unknown | FK |
| filter_pay_group_id | Unknown | FK |
| filter_supervisor_id | Unknown | FK |
| home_company_id | Unknown | FK |
| master_company_id | Unknown | FK |
| role_id | Unknown | FK |
| email | Unknown |  |
| filter_deduction_group_code | Unknown |  |
| filter_employee_type | Unknown |  |
| filter_full_time_or_part_time | Unknown |  |
| filter_project_code | Unknown |  |
| filter_salary_or_hourly | Unknown |  |
| filter_shift_code | Unknown |  |
| filter_status | Unknown |  |
| filter_tax_calculation_group_id | Unknown |  |
| first_name | Unknown |  |
| integration_user_key | Unknown |  |
| last_name | Unknown |  |
| user_name | Unknown |  |
| user_status | Unknown |  |
| work_phone | Unknown |  |

### option_rate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| deduction_code | Unknown | FK |
| benefit_option | Unknown |  |
| effective_date | Unknown |  |
| employee_rate | Unknown |  |
| employer_rate | Unknown |  |
| pay_frequency | Unknown |  |
| rate_stop_date | Unknown |  |

### pto_plan

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| earned | Unknown |  |
| earned_through_date | Unknown |  |
| pending_balance | Unknown |  |
| pending_move_date | Unknown |  |
| pto_plan | Unknown |  |
| reset | Unknown |  |
| taken | Unknown |  |

### address_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_address

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### tax_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| country_code | Unknown |  |
| date_final_wages_paid | Unknown |  |
| date_month_reset | Unknown |  |
| date_quarter_reset | Unknown |  |
| date_year_reset | Unknown |  |
| deposit_frequency_code | Unknown |  |
| deposit_frequency_description | Unknown |  |
| description | Unknown |  |
| is_inactive | Unknown |  |
| is_not_paying_wages | Unknown |  |
| is_not_subject_to_soc_med_tax | Unknown |  |
| report_id | Unknown |  |
| type_description | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| master_company_id | Unknown | FK |
| tax_group_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_county | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_state | Unknown |  |
| address_zip_code | Unknown |  |
| code | Unknown |  |
| contract_number | Unknown |  |
| currency_code | Unknown |  |
| date_of_business_closure | Unknown |  |
| doing_business_as_name | Unknown |  |
| federal_tax_id | Unknown |  |
| gl_segment | Unknown |  |
| integration_record_id | Unknown |  |
| is_master_company | Unknown |  |
| name | Unknown |  |
| organization_level_1_label | Unknown |  |
| organization_level_2_label | Unknown |  |
| organization_level_3_label | Unknown |  |
| organization_level_4_label | Unknown |  |
| other_federal_tax_id | Unknown |  |
| phone_number | String |  |
| phone_number_extension | Unknown |  |
| use_multiple_job_groups | Unknown |  |
| use_position_management | Unknown |  |

### earning

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| block_federal_income_tax | Unknown |  |
| block_local_income_tax | Unknown |  |
| block_state_income_tax | Unknown |  |
| calculation_rule | Unknown |  |
| country_code | Unknown |  |
| display_in_pay_data_entry | Unknown |  |
| excel_in_total_hours | Unknown |  |
| exempt_from_earned_income_hours | Unknown |  |
| flat_hours | Unknown |  |
| include_flsa_average_pay_rate | Unknown |  |
| include_in_accruals | Unknown |  |
| include_in_allocations | Unknown |  |
| include_in_benefit_hours | Unknown |  |
| include_in_deferred_compensation | Unknown |  |
| include_in_deferred_compensation_hours | Unknown |  |
| include_in_earning_accumulation | Unknown |  |
| include_in_health_care_hours | Unknown |  |
| include_in_hours_accumulation | Unknown |  |
| include_in_manual_check | Unknown |  |
| include_in_miscellaneous_earning_1 | Unknown |  |
| include_in_miscellaneous_earning_2 | Unknown |  |
| include_in_miscellaneous_earning_3 | Unknown |  |
| include_in_miscellaneous_earning_4 | Unknown |  |
| include_in_miscellaneous_earning_5 | Unknown |  |
| include_in_miscellaneous_earning_6 | Unknown |  |
| include_in_pension_accumulation | Unknown |  |
| include_in_registered_pension_plan | Unknown |  |
| include_in_registered_retirement_savings_plan | Unknown |  |
| include_in_retro_pay | Unknown |  |
| include_in_shift_diffrential | Unknown |  |
| include_in_union_dues | Unknown |  |
| include_in_union_dues_hours | Unknown |  |
| is_productive_time | Unknown |  |
| is_supplimental_wages | Unknown |  |
| long_description | Unknown |  |
| monthly_pay_period_1 | Unknown |  |
| monthly_pay_period_2 | Unknown |  |
| monthly_pay_period_3 | Unknown |  |
| monthly_pay_period_4 | Unknown |  |
| monthly_pay_period_5 | Unknown |  |
| notes | Unknown |  |
| reduce_regular_dollars | Unknown |  |
| reduce_regular_hours | Unknown |  |
| report_category | Unknown |  |
| schedule_supplemental | Unknown |  |
| stub_description | Unknown |  |
| tax_calculation_rule | Unknown |  |
| tax_category | Unknown |  |
| time_clock_code | Unknown |  |
| use_deduction_offset | Unknown |  |
| verification_type_code | Unknown |  |
| verification_type_description | Unknown |  |

### contact_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_contact

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### job_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_code | Unknown |  |
| description | Unknown |  |
| notes | Unknown |  |

### employee_field_row

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| key_value | Unknown | PK, FK |
| field_value | Unknown |  |

### platform_config_employee

| Column | Type | Keys |
| --- | --- | --- |
| key_value | Unknown | PK, FK |
| class_name | Unknown |  |
| key_name | Unknown |  |

### insurance_rate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| deduction_code | Unknown | FK |
| effective_date | Unknown |  |
| employee_rate_non_smoker_female | Unknown |  |
| employee_rate_non_smoker_male | Unknown |  |
| employee_rate_non_smoker_not_specified | Unknown |  |
| employee_rate_smoker_female | Unknown |  |
| employee_rate_smoker_male | Unknown |  |
| employee_rate_smoker_not_specified | Unknown |  |
| employer_rate_non_smoker_female | Unknown |  |
| employer_rate_non_smoker_male | Unknown |  |
| employer_rate_non_smoker_not_specified | Unknown |  |
| employer_rate_smoker_female | Unknown |  |
| employer_rate_smoker_male | Unknown |  |
| employer_rate_smoker_not_specified | Unknown |  |
| maximum_age | Unknown |  |
| minimum_age | Unknown |  |
| pay_frequency | Unknown |  |
| stop_date | Unknown |  |

### payroll_deduction_history

| Column | Type | Keys |
| --- | --- | --- |
| record_id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| allow_partial_deduction | Unknown |  |
| batch_id | Unknown |  |
| benefit_amount | Unknown |  |
| benefit_option | Unknown |  |
| benefit_provider | Unknown |  |
| check_id | Unknown |  |
| child_support_type | Unknown |  |
| current_arrears_amount | Unknown |  |
| custom_amount_1 | Unknown |  |
| custom_amount_2 | Unknown |  |
| custom_date | Unknown |  |
| deduction_calculation_basis_amt | Unknown |  |
| deduction_code | Unknown |  |
| deduction_for_bonus_only | Unknown |  |
| deduction_plan_type | Unknown |  |
| deduction_type | Unknown |  |
| deferred_compensation_cap | Unknown |  |
| deferred_compensation_regular_cap | Unknown |  |
| dependent_record_id | Unknown |  |
| employee_calculaiton_rule | Unknown |  |
| employee_calculation_rate_or_percent | Unknown |  |
| employee_current_amount | Unknown |  |
| employee_deduction_last_paid | Unknown |  |
| employee_goal_amount | Unknown |  |
| employee_goal_rule | Unknown |  |
| employee_goal_to_date_amount | Unknown |  |
| employee_number | Unknown |  |
| employee_original_amount | Unknown |  |
| employer_annual_cap_calculation_rule | Unknown |  |
| employer_calculation_rate_or_percent | Unknown |  |
| employer_calculation_rule | Unknown |  |
| employer_current_amount | Unknown |  |
| employer_period_cap_calculation_rule | Unknown |  |
| exclude_from_workers_compensation | Unknown |  |
| general_ledger_expense_account | Unknown |  |
| general_ledger_pay_account | Unknown |  |
| is_401_k | Unknown |  |
| is_403_b | Unknown |  |
| is_408_k | Unknown |  |
| is_408_p | Unknown |  |
| is_457 | Unknown |  |
| is_457_b | Unknown |  |
| is_457_f | Unknown |  |
| is_501_c | Unknown |  |
| is_d_125 | Unknown |  |
| is_deduction_off_set | Unknown |  |
| is_deferred_compensation | Unknown |  |
| is_dependent_care | Unknown |  |
| is_housing | Unknown |  |
| is_non_qualified_plan | Unknown |  |
| is_prorated | Unknown |  |
| is_public_employee_retirement | Unknown |  |
| is_section_125 | Unknown |  |
| is_voided | Unknown |  |
| is_voiding_record | Unknown |  |
| pay_date | Unknown |  |
| pay_group | Unknown |  |
| payee_id | Unknown |  |
| period_control | Unknown |  |
| tax_calculation_group_id | Unknown |  |
| tax_category | Unknown |  |
| timeclock_code | Unknown |  |
| vendor | Unknown |  |
| wage_garnishment_additional_arrearage_amount | Unknown |  |
| wage_garnishment_allocate_as_arrears | Unknown |  |
| wage_garnishment_amount_exempt | Unknown |  |
| wage_garnishment_amount_exempt_from_levy | Unknown |  |
| wage_garnishment_amount_exemt_from_garn | Unknown |  |
| wage_garnishment_amount_subject_to_cs | Unknown |  |
| wage_garnishment_amount_subject_to_garnishment | Unknown |  |
| wage_garnishment_deduction_tax_category | Unknown |  |
| wage_garnishment_disposable_income | Unknown |  |
| wage_garnishment_minimum_wage_factor | Unknown |  |
| wage_garnishment_wage_code | Unknown |  |
| year_to_date_deferred_compensation_combined_amount | Unknown |  |

### compensation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| pay_group | Unknown | FK |
| primary_job_id | Unknown | FK |
| annual_salary | Unknown |  |
| avg_pay_rate_cur_per | Unknown |  |
| bonus_total_hrs | Unknown |  |
| bonus_total_ot_hrs | Unknown |  |
| currency_code | Unknown |  |
| date_in_job | LocalDateTime |  |
| date_last_paid | Unknown |  |
| date_last_worked | Unknown |  |
| date_of_last_salary_review | Unknown |  |
| date_of_next_salayr_review | Unknown |  |
| date_paid_thru | Unknown |  |
| distribution_center_code | Unknown |  |
| empl_status | Unknown |  |
| full_time_or_part_time_code | Unknown |  |
| hourly_pay_rate | Unknown |  |
| is_auto_allocated | Unknown |  |
| is_auto_paid | Unknown |  |
| is_highly_compensated | Unknown |  |
| is_multiple_job | Unknown |  |
| is_seasonal_worker | Unknown |  |
| job_change_reason_code | Unknown |  |
| job_group_code | Unknown |  |
| job_salary_grade | Unknown |  |
| job_title | Unknown |  |
| number_of_payments | Unknown |  |
| other_rate_1 | Unknown |  |
| other_rate_2 | Unknown |  |
| other_rate_3 | Unknown |  |
| other_rate_4 | Unknown |  |
| pay_group_description | Unknown |  |
| pay_period | Unknown |  |
| pay_period_pay_rate | Unknown |  |
| pay_scale_code | Unknown |  |
| performance_review_rating | Unknown |  |
| performance_review_type | Unknown |  |
| piece_pay_rate | Unknown |  |
| primary_shift_code | Unknown |  |
| primary_shift_group_code | Unknown |  |
| salary_or_hourly_code | Unknown |  |
| scheduled_annual_work_hours | Unknown |  |
| scheduled_full_time_equivalency | Unknown |  |
| scheduled_period_work_hours | Unknown |  |
| total_ann_salary | Unknown |  |
| weekly_hours | Unknown |  |
| weekly_pay_rate | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country_code | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| location_gl_segment | Unknown |  |
| state | Unknown |  |
| zip_or_postal_code | Unknown |  |

### employee_global_bank

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| pay_group | Unknown | FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| account_type_description | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| beneficiary_name | Unknown |  |
| branch | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| currency_code | Unknown |  |
| date_modified | Unknown |  |
| funding_method | Unknown |  |
| funding_method_description | Unknown |  |
| iban | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| request_code_1 | Unknown |  |
| request_code_2 | Unknown |  |
| request_code_3 | Unknown |  |
| request_label_1 | Unknown |  |
| request_label_2 | Unknown |  |
| request_label_3 | Unknown |  |
| requirement_1 | Unknown |  |
| requirement_2 | Unknown |  |
| requirement_3 | Unknown |  |
| state | Unknown |  |
| swift_code | Unknown |  |

### employee_global_localization_element

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| boolean_value | Unknown |  |
| created | Unknown |  |
| date_time_value | Unknown |  |
| effective | Unknown |  |
| field_id | Unknown |  |
| field_name | Unknown |  |
| numeric_value | Unknown |  |
| string_value | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| additional_name_1 | Unknown |  |
| additional_name_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_county | Unknown |  |
| address_id | Unknown |  |
| address_is_on_tax_boundary | Unknown |  |
| address_latitude | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| address_line_4 | Unknown |  |
| address_longitude | Unknown |  |
| address_sms | Unknown |  |
| address_state | Unknown |  |
| address_zip_code | Unknown |  |
| chk_cashing_inst_code | Unknown |  |
| cobra_export | Unknown |  |
| cobra_is_active | Unknown |  |
| cobra_notes | Unknown |  |
| cobra_reason | Unknown |  |
| cobra_status | Unknown |  |
| cobra_status_date | Unknown |  |
| community_broadcast_sms_code | Unknown |  |
| consent_electronic_w_2 | Unknown |  |
| consent_electronicw_2_pr | Unknown |  |
| date_deceased | Unknown |  |
| date_of_birth | Unknown |  |
| date_of_cobra_event | Unknown |  |
| date_of_cobra_export | Unknown |  |
| date_of_cobra_letter | Unknown |  |
| date_of_i_9_expiration | Unknown |  |
| date_time_changed | LocalDateTime |  |
| date_time_created | Unknown |  |
| disability_type | Unknown |  |
| email_address | Unknown |  |
| email_address_alternate | Unknown |  |
| ethnic_description | Unknown |  |
| ethnic_id_code | Unknown |  |
| first_name | Unknown |  |
| former_name | Unknown |  |
| gender | Unknown |  |
| health_blood_type | Unknown |  |
| health_eyes | Unknown |  |
| health_hair | Unknown |  |
| health_height_feet | Unknown |  |
| health_height_inches | Unknown |  |
| health_last_donate_date | Unknown |  |
| health_weight | Unknown |  |
| home_phone | Unknown |  |
| home_phone_country | Unknown |  |
| home_phone_is_private | Unknown |  |
| i_9_alien_number | Unknown |  |
| i_9_doc_a | Unknown |  |
| i_9_doc_b | Unknown |  |
| i_9_doc_c | Unknown |  |
| i_9_verified | Unknown |  |
| i_9_visa_expiration_date | Unknown |  |
| i_9_visa_type | Unknown |  |
| i_9_work_auth | Unknown |  |
| is_disabled | Unknown |  |
| is_multi_pay_group | Unknown |  |
| is_smoker | Unknown |  |
| last_name | Unknown |  |
| last_name_not_same_as_ss_card | Unknown |  |
| marital_status_code | Unknown |  |
| middle_name | Unknown |  |
| military_branch_served | Unknown |  |
| military_era | Unknown |  |
| military_is_active_wartime_vet | Unknown |  |
| military_is_disabled_vet | Unknown |  |
| military_is_medal_vet | Unknown |  |
| military_is_oth_elig_vet | Unknown |  |
| military_is_oth_elig_vet_basis | Unknown |  |
| military_separation_date | Unknown |  |
| military_service | Unknown |  |
| name_former | Unknown |  |
| name_prefix_code | Unknown |  |
| name_suffix_code | Unknown |  |
| national_id | Unknown |  |
| national_id_country | Unknown |  |
| nationality_1 | Unknown |  |
| nationality_2 | Unknown |  |
| nationality_3 | Unknown |  |
| origin_country | Unknown |  |
| origin_location | Unknown |  |
| person_id | Unknown |  |
| preferred_name | Unknown |  |
| previous_ssn | Unknown |  |
| sms_approvals | Unknown |  |
| sms_pay_notification | Unknown |  |
| ssn | Unknown |  |
| ssn_is_suppressed | Unknown |  |
| user_name | Unknown |  |
| w_2_is_deceased | Unknown |  |

### pay_detail_report_deduction

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| pay_detail_report_pay_id | Unknown | PK, FK |
| basis_amount | Unknown |  |
| deduction_description | Unknown |  |
| employee_amount | Unknown |  |
| employee_amount_ytd | Unknown |  |
| employer_amount | Unknown |  |
| employer_amount_ytd | Unknown |  |
| is_pension | Unknown |  |
| pre_tax | Unknown |  |

### pay_detail_report_accural

| Column | Type | Keys |
| --- | --- | --- |
| plan_code | Unknown | PK |
| pay_detail_report_pay_id | Unknown | PK, FK |
| amount_current | Unknown |  |
| amount_type | Unknown |  |
| balance | Unknown |  |
| plan_description | Unknown |  |

### pay_detail_report_net_pay

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pay_detail_report_pay_id | Unknown | PK, FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| amount | Unknown |  |

### pay_detail_report_tax

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| pay_detail_report_pay_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_ytd | Unknown |  |
| basis_amount | Unknown |  |
| is_employer_tax | Unknown |  |
| is_social_security | Unknown |  |
| tax_description | Unknown |  |

### pay_detail_report_earning

| Column | Type | Keys |
| --- | --- | --- |
| pay_code | Unknown | PK |
| pay_detail_report_pay_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_ytd | Unknown |  |
| hours | Unknown |  |
| pay_description | Unknown |  |
| pay_rate | Unknown |  |
| period_end | Unknown |  |
| period_start | Unknown |  |
| piece_count | Unknown |  |
| piece_pay_rate | Unknown |  |

### pay_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| pay_id | Unknown | PK |
| employee_company_id | Unknown | FK |
| employee_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| deductions_current | Unknown |  |
| document | Unknown |  |
| employee_identification_type | Unknown |  |
| employee_number | Unknown |  |
| employee_status | Unknown |  |
| federal_additional_amount_withheld | Unknown |  |
| federal_allowances_claimed | Unknown |  |
| full_name | Unknown |  |
| gross_wages_current | Unknown |  |
| job | Unknown |  |
| location | Unknown |  |
| net_pay_current | Unknown |  |
| org_level_1 | Unknown |  |
| org_level_2 | Unknown |  |
| org_level_3 | Unknown |  |
| org_level_4 | Unknown |  |
| pay_date | Unknown |  |
| pay_group | Unknown |  |
| pay_period_frequency | Unknown |  |
| pay_rate | Unknown |  |
| period_end_date | Unknown |  |
| period_start_date | Unknown |  |
| postal_code | Unknown |  |
| resident_state_allowances_claimed | Unknown |  |
| state_or_province | Unknown |  |
| taxes_current | Unknown |  |
| work_state_allowances_claimed | Unknown |  |

### direct_deposit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| account_is_inactive | Unknown |  |
| account_record_id | Unknown |  |
| account_type | Unknown |  |
| amount_or_percent | Unknown |  |
| country_code | Unknown |  |
| date_time_changed | LocalDateTime |  |
| deposit_rule | Unknown |  |
| description | Unknown |  |
| direct_deposit_or_prenote | Unknown |  |
| employee_bank_id | Unknown |  |
| employee_bank_name | Unknown |  |
| employee_bank_routing_number | Unknown |  |
| employee_institution_number | Unknown |  |
| first_prenote_pay_date | Unknown |  |
| foreign_account_number | Unknown |  |
| foreign_account_number_type | Unknown |  |
| sequence_number | Unknown |  |

### employee_change

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| employee_number | Unknown | FK |
| organization_level_1_id | Unknown | FK |
| organization_level_2_id | Unknown | FK |
| organization_level_3_id | Unknown | FK |
| organization_level_4_id | Unknown | FK |
| supervisor_id | Unknown | FK |
| work_location_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| alternate_email_address | Unknown |  |
| alternate_job_title | Unknown |  |
| date_in_job | Unknown |  |
| date_of_last_hire | Unknown |  |
| empl_status_start_date | Unknown |  |
| full_time_or_part_time | Unknown |  |
| gender | Unknown |  |
| hire_date | Unknown |  |
| is_active | Unknown |  |
| job_code | Unknown |  |
| job_group_code | Unknown |  |
| language_code | Unknown |  |
| prefix | Unknown |  |
| project_code | Unknown |  |
| salary_or_hourly | Unknown |  |
| status | Unknown |  |
| suffix | Unknown |  |
| supervisor_name | Unknown |  |
| termination_date | Unknown |  |
| type | Unknown |  |
| user_integration_key | Unknown |  |
| work_phone | Unknown |  |
| zip_code | Unknown |  |

### pay_statement_deduction

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| pay_statement_pay_id | Unknown | PK, FK |
| basis_amount | Unknown |  |
| deduction_description | Unknown |  |
| employee_amount | Unknown |  |
| employee_amount_ytd | Unknown |  |
| employer_amount | Unknown |  |
| employer_amount_ytd | Unknown |  |
| pre_tax | Unknown |  |

### pay_statement_accural

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| pay_statement_pay_id | Unknown | PK, FK |
| basis_amount | Unknown |  |
| deduction_description | Unknown |  |
| employee_amount | Unknown |  |
| employee_amount_ytd | Unknown |  |
| employer_amount | Unknown |  |
| employer_amount_ytd | Unknown |  |
| pre_tax | Unknown |  |

### pay_statement_net_pay

| Column | Type | Keys |
| --- | --- | --- |
| account_number | Unknown | PK |
| pay_statement_pay_id | Unknown | PK, FK |
| account_type | Unknown |  |
| amount | Unknown |  |

### pay_statement_tax

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| pay_statement_pay_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_ytd | Unknown |  |
| basis_amount | Unknown |  |
| tax_description | Unknown |  |

### pay_statement_earning

| Column | Type | Keys |
| --- | --- | --- |
| pay_code | Unknown | PK |
| pay_statement_pay_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_ytd | Unknown |  |
| hours | Unknown |  |
| hours_ytd | Unknown |  |
| pay_description | Unknown |  |
| pay_rate | Unknown |  |
| period_end | Unknown |  |
| period_start | Unknown |  |
| piece_count | Unknown |  |
| piece_pay_rate | Unknown |  |

### pay_statement

| Column | Type | Keys |
| --- | --- | --- |
| pay_id | Unknown | PK |
| employee_company_id | Unknown | FK |
| employee_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| deductions_current | Unknown |  |
| deductions_ytd | Unknown |  |
| document | Unknown |  |
| employee_identification_type | Unknown |  |
| employee_number | Unknown |  |
| federal_additional_amount_withheld | Double |  |
| federal_allowances_claimed | Unknown |  |
| federal_filing_status | Unknown |  |
| federal_taxable_wages_current | Unknown |  |
| federal_taxable_wages_ytd | Unknown |  |
| full_name | Unknown |  |
| gross_wages_current | Unknown |  |
| gross_wages_ytd | Unknown |  |
| job | Unknown |  |
| location | Unknown |  |
| net_pay_current | Unknown |  |
| net_pay_ytd | Unknown |  |
| org_level_1 | Unknown |  |
| org_level_2 | Unknown |  |
| org_level_3 | Unknown |  |
| org_level_4 | Unknown |  |
| pay_date | Unknown |  |
| pay_group | Unknown |  |
| pay_period_frequency | Unknown |  |
| pay_rate | Unknown |  |
| period_end_date | Unknown |  |
| period_start_date | Unknown |  |
| postal_code | Unknown |  |
| resident_state_allowances_claimed | Unknown |  |
| resident_state_filing_status | Unknown |  |
| state_or_province | Unknown |  |
| taxes_current | Unknown |  |
| taxes_ytd | Unknown |  |
| work_state_allowances_claimed | Unknown |  |
| work_state_filing_status | Unknown |  |

### employee_contract

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| contract_type_code | Unknown |  |
| date_time_created | Unknown |  |
| effective_date | Unknown |  |
| row_last_changed | LocalDateTime |  |

### employee_pay_deduction_element

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| employee_id | Unknown | FK |
| employment_id | Unknown | FK |
| pay_group | Unknown | FK |
| amount | Unknown |  |
| country | Unknown |  |
| end_date | Unknown |  |
| modified_date | LocalDateTime |  |
| notes | Unknown |  |
| pay_deduction_description | Unknown |  |
| pay_deduction_id | Unknown |  |
| pay_deduction_name | Unknown |  |
| payment_or_deduction_indicator | Unknown |  |
| period_end_id | Unknown |  |
| period_end_name | Unknown |  |
| period_start_id | Unknown |  |
| period_start_name | Unknown |  |
| project | Unknown |  |
| recurring | Unknown |  |
| start_date | Unknown |  |
| task | Unknown |  |

### employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | FK |
| organization_level_1_id | String | FK |
| organization_level_2_id | String | FK |
| organization_level_3_id | String | FK |
| organization_level_4_id | String | FK |
| pay_group | Unknown | FK |
| primary_job_id | Unknown | FK |
| primary_work_location_id | Unknown | FK |
| supervisor_id | Unknown | FK |
| auto_allocate | Unknown |  |
| clock_code | Unknown |  |
| date_in_job | Unknown |  |
| date_last_pay_date_paid | Unknown |  |
| date_last_worked | Unknown |  |
| date_of_benefit_seniority | Unknown |  |
| date_of_early_retirement | Unknown |  |
| date_of_local_union | Unknown |  |
| date_of_national_union | Unknown |  |
| date_of_retirement | Unknown |  |
| date_of_seniority | Unknown |  |
| date_of_suspension | Unknown |  |
| date_of_termination | Unknown |  |
| date_paid_thru | Unknown |  |
| date_time_changed | LocalDateTime |  |
| date_time_created | Unknown |  |
| deduction_group_code | Unknown |  |
| earning_group_code | Unknown |  |
| employee_status_code | Unknown |  |
| employee_type_code | Unknown |  |
| full_time_or_part_time_code | Unknown |  |
| hire_source | Unknown |  |
| is_auto_allocated | Unknown |  |
| is_autopaid | Unknown |  |
| is_multiple_job | Unknown |  |
| job_change_reason_code | Unknown |  |
| job_description | Unknown |  |
| job_group_code | Unknown |  |
| job_title | Unknown |  |
| language_code | Unknown |  |
| last_hire_date | Unknown |  |
| leave_reason_code | Unknown |  |
| mailstop | Unknown |  |
| ok_to_rehire | Unknown |  |
| original_hire_date | Unknown |  |
| pay_group_description | Unknown |  |
| pay_period | Unknown |  |
| planned_leave_reason | Unknown |  |
| position_code | Unknown |  |
| primary_project_code | Unknown |  |
| salary_or_hourly | Unknown |  |
| scheduled_annual_hrs | Unknown |  |
| scheduled_fte | Unknown |  |
| scheduled_work_hrs | Unknown |  |
| shift | Unknown |  |
| shift_group | Unknown |  |
| status_start_date | Unknown |  |
| supervisor_co_id | Unknown |  |
| supervisor_company_code | Unknown |  |
| supervisor_first_name | Unknown |  |
| supervisor_last_name | Unknown |  |
| term_reason | Unknown |  |
| term_type | Unknown |  |
| termination_reason_description | Unknown |  |
| time_clock_id | Unknown |  |
| union_local | Unknown |  |
| union_national | Unknown |  |
| weekly_hours | Unknown |  |
| work_phone_country | Unknown |  |
| work_phone_extension | Unknown |  |
| work_phone_number | Unknown |  |

## Relationships

- employee_job_history(organization_level_1_id) → organization_level(id)
- employee_job_history(organization_level_2_id) → organization_level(id)
- employee_job_history(organization_level_3_id) → organization_level(id)
- employee_job_history(organization_level_4_id) → organization_level(id)
- employee_job_history(home_company_id) → company(id)
- employee_job_history(job_id) → job(id)
- employee_job_history(employee_id) → employee(id)
- employee_job_history(supervisor_id) → employee(id)
- employee_job_history(location_id) → location(id)
- employee_job_history(company_id) → company(id)
- employee_job_history(pay_group_id) → pay_group(id)
- education(employment_id) → employment(id)
- education(employee_id) → employee(id)
- employee_security_user(user_id) → user_profile(user_id)
- employee_security_user(employee_id) → employee(id)
- pay_register(organization_level_1_id) → organization_level(id)
- pay_register(organization_level_2_id) → organization_level(id)
- pay_register(organization_level_3_id) → organization_level(id)
- pay_register(organization_level_4_id) → organization_level(id)
- pay_register(employment_id) → employment(id)
- pay_register(pay_group) → pay_group(pay_group)
- pay_register(employee_id) → employee(id)
- pay_register(location_id) → location(id)
- pay_register(company_id) → company(id)
- earning_history_base_element(earning_id) → earning(id)
- earning_history_base_element(job_id) → job(id)
- earning_history_base_element(employment_id) → employee(id)
- earning_history_base_element(pay_group) → pay_group(pay_group)
- earning_history_base_element(employee_id) → employee(id)
- earning_history_base_element(location_id) → location(id)
- earning_history_base_element(company_id) → company(id)
- phone_number_field_row(key_value) → platform_config_phone_number(key_value)
- platform_config_phone_number(key_value) → employee(id)
- contact(employee_id) → employee(id)
- contact(home_phone_number) → phone_number(number)
- person_field_row(key_value) → platform_config_person(key_value)
- platform_config_person(key_value) → employee(id)
- employee_user_defined_field_company(company_id) → company(id)
- employee_user_defined_field_company(employee_id) → employee_user_defined_field(employee_id)
- employee_user_defined_field(employee_id) → employee(id)
- employee_multiple_job(job_id) → job(id)
- employee_multiple_job(employee_id) → employee(id)
- employee_multiple_job(company_id) → company(id)
- employee_status(employee_id) → employee(id)
- employee_status(company_id) → company(id)
- job_field_row(key_value) → platform_config_job(key_value)
- platform_config_job(key_value) → job(id)
- org_level_4_field_row(key_value) → platform_config_org_level_4(key_value)
- platform_config_org_level_4(key_value) → organization_level(id)
- org_level_3_field_row(key_value) → platform_config_org_level_3(key_value)
- platform_config_org_level_3(key_value) → organization_level(id)
- org_level_2_field_row(key_value) → platform_config_org_level_2(key_value)
- platform_config_org_level_2(key_value) → organization_level(id)
- org_level_1_field_row(key_value) → platform_config_org_level_1(key_value)
- platform_config_org_level_1(key_value) → organization_level(id)
- employee_demographic(employee_id) → employee(id)
- employee_demographic(user_id) → user_profile(user_id)
- users(employee_id) → employee(id)
- employment_field_row(key_value) → platform_config_employment(key_value)
- general_ledger(organization_level_1_id) → organization_level(id)
- general_ledger(organization_level_2_id) → organization_level(id)
- general_ledger(organization_level_3_id) → organization_level(id)
- general_ledger(organization_level_4_id) → organization_level(id)
- general_ledger(job_id) → job(id)
- general_ledger(pay_group) → pay_group(pay_group)
- general_ledger(company_code) → company(code)
- national_document(employment_id) → employment(id)
- national_document(employee_id) → employee(id)
- national_document(contact_id) → contact(id)
- phone_number(employee_id) → employee(id)
- dependent_deduction(employee_id) → employee(id)
- dependent_deduction(company_id) → company(id)
- dependent_deduction(contact_id) → contact(id)
- position(job_id) → job(id)
- position(location_id) → location(id)
- position(company_id) → company(id)
- position(pay_group_id) → pay_group(id)
- employee_supervisor(supervisor_job_id) → job(id)
- employee_supervisor(employment_id) → employment(id)
- employee_supervisor(supervisor_position_id) → position(id)
- employee_supervisor(employee_id) → employee(id)
- employee_supervisor(supervisor_employee_id) → employee(id)
- employee_supervisor(supervisor_company_id) → company(id)
- employee_supervisor(supervisor_employment_id) → employee(id)
- employee_supervisor(company_id) → company(id)
- position_report(position_id) → position(id)
- location_field_row(key_value) → platform_config_location(key_value)
- platform_config_location(key_value) → location(id)
- international_employee_field_row(key_value) → platform_config_international_employee(key_value)
- user_profile(user_id) → users(id)
- user_profile(filter_organization_level_3_id) → organization_level(id)
- user_profile(filter_job_id) → job(id)
- user_profile(filter_supervisor_id) → employee(id)
- user_profile(filter_location_id) → location(id)
- user_profile(master_company_id) → company(id)
- user_profile(home_company_id) → company(id)
- user_profile(filter_pay_group_id) → pay_group(id)
- user_profile(filter_organization_level_1_id) → organization_level(id)
- user_profile(employee_id) → employee(id)
- user_profile(filter_organization_level_2_id) → organization_level(id)
- user_profile(role_id) → role(id)
- user_profile(filter_company_id) → company(id)
- user_profile(company_id) → company(id)
- user_profile(filter_organization_level_4_id) → organization_level(id)
- option_rate(deduction_code) → dependent_deduction(code)
- pto_plan(employee_id) → employee(id)
- pto_plan(company_id) → company(id)
- address_field_row(key_value) → platform_config_address(key_value)
- platform_config_address(key_value) → employee(id)
- company(tax_group_id) → tax_group(id)
- company(master_company_id) → company(id)
- contact_field_row(key_value) → platform_config_contact(key_value)
- platform_config_contact(key_value) → phone_number(id)
- employee_field_row(key_value) → platform_config_employee(key_value)
- platform_config_employee(key_value) → employee(id)
- insurance_rate(deduction_code) → dependent_deduction(code)
- payroll_deduction_history(employee_id) → employee(id)
- payroll_deduction_history(company_id) → company(id)
- compensation(primary_job_id) → job(id)
- compensation(pay_group) → pay_group(pay_group)
- compensation(employee_id) → employee(id)
- compensation(company_id) → company(id)
- employee_global_bank(employment_id) → employment(id)
- employee_global_bank(pay_group) → pay_group(pay_group)
- employee_global_bank(employee_id) → employee(id)
- employee_global_bank(company_id) → company(id)
- employee_global_localization_element(employee_id) → employee(id)
- employee_global_localization_element(company_id) → company(id)
- employee(company_id) → company(id)
- pay_detail_report_deduction(pay_detail_report_pay_id) → pay_detail_report(pay_id)
- pay_detail_report_accural(pay_detail_report_pay_id) → pay_detail_report(pay_id)
- pay_detail_report_net_pay(pay_detail_report_pay_id) → pay_detail_report(pay_id)
- pay_detail_report_tax(pay_detail_report_pay_id) → pay_detail_report(pay_id)
- pay_detail_report_earning(pay_detail_report_pay_id) → pay_detail_report(pay_id)
- pay_detail_report(employee_company_id) → company(id)
- pay_detail_report(employee_id) → employee(id)
- direct_deposit(employee_id) → employee(id)
- direct_deposit(company_id) → company(id)
- employee_change(organization_level_1_id) → organization_level(id)
- employee_change(organization_level_2_id) → organization_level(id)
- employee_change(work_location_id) → location(id)
- employee_change(organization_level_3_id) → organization_level(id)
- employee_change(organization_level_4_id) → organization_level(id)
- employee_change(employee_number) → employment(id)
- employee_change(employee_id) → employee(id)
- employee_change(supervisor_id) → employee(id)
- pay_statement_deduction(pay_statement_pay_id) → pay_statement(pay_id)
- pay_statement_accural(pay_statement_pay_id) → pay_statement(pay_id)
- pay_statement_net_pay(pay_statement_pay_id) → pay_statement(pay_id)
- pay_statement_tax(pay_statement_pay_id) → pay_statement(pay_id)
- pay_statement_earning(pay_statement_pay_id) → pay_statement(pay_id)
- pay_statement(employee_company_id) → company(id)
- pay_statement(employee_id) → employee(id)
- employee_contract(company_id) → company(id)
- employee_contract(employee_id) → employee(id)
- employee_pay_deduction_element(employment_id) → employment(id)
- employee_pay_deduction_element(pay_group) → pay_group(pay_group)
- employee_pay_deduction_element(employee_id) → employee(id)
- employee_pay_deduction_element(company_id) → company(id)
- employment(primary_job_id) → job(id)
- employment(organization_level_1_id) → organization_level(id)
- employment(primary_work_location_id) → location(id)
- employment(organization_level_2_id) → organization_level(id)
- employment(organization_level_3_id) → organization_level(id)
- employment(organization_level_4_id) → organization_level(id)
- employment(pay_group) → pay_group(pay_group)
- employment(employee_id) → employee(id)
- employment(supervisor_id) → employee(id)
- employment(company_id) → company(id)