UKG Pro

Explore the interactive ERD

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	PKFK
`user_id`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_phone_number

Column	Type	Keys
`key_value`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_person

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

employee_user_defined_field_company

Column	Type	Keys
`company_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`custom_`

employee_user_defined_field

Column	Type	Keys
`employee_id`	Unknown	PKFK
`custom_`

employee_multiple_job

Column	Type	Keys
`company_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`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	PKFK
`employee_id`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_job

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

org_level_4_field_row

Column	Type	Keys
`field_name`	Unknown	PK
`key_value`	Unknown	PKFK
`field_value`	Unknown

platform_config_org_level_4

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

org_level_3_field_row

Column	Type	Keys
`field_name`	Unknown	PK
`key_value`	Unknown	PKFK
`field_value`	Unknown

platform_config_org_level_3

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

org_level_2_field_row

Column	Type	Keys
`field_name`	Unknown	PK
`key_value`	Unknown	PKFK
`field_value`	Unknown

platform_config_org_level_2

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

org_level_1_field_row

Column	Type	Keys
`field_name`	Unknown	PK
`key_value`	Unknown	PKFK
`field_value`	Unknown

platform_config_org_level_1

Column	Type	Keys
`key_value`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`employment_id`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_location

Column	Type	Keys
`key_value`	Unknown	PKFK
`class_name`	Unknown
`key_name`	Unknown

international_employee_field_row

Column	Type	Keys
`field_name`	Unknown	PK
`key_value`	Unknown	PKFK
`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	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_address

Column	Type	Keys
`key_value`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_contact

Column	Type	Keys
`key_value`	Unknown	PKFK
`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	PKFK
`field_value`	Unknown

platform_config_employee

Column	Type	Keys
`key_value`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`account_number`	Unknown
`account_type`	Unknown
`amount`	Unknown

pay_detail_report_tax

Column	Type	Keys
`code`	Unknown	PK
`pay_detail_report_pay_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`account_type`	Unknown
`amount`	Unknown

pay_statement_tax

Column	Type	Keys
`code`	Unknown	PK
`pay_statement_pay_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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