Ceridian Dayforce

Explore the interactive ERD

Table & Field Reference

report_data

Column	Type	Keys
`index`	Unknown	PK
`report_id`	Unknown	PKFK
`custom_`

work_location_override

Column	Type	Keys
`id`	Unknown	PK
`work_location_id`	Unknown	PKFK
`bank_branch_address_id`	Unknown
`bank_branch_address_name`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`legal_entity_name`	Unknown
`override_customer_funding_identifer_id`	Unknown
`override_customer_funding_identifer_name`	Unknown
`work_site_id`	Unknown
`work_site_name`	Unknown
`work_site_state_code`	Unknown

work_location

Column	Type	Keys
`id`	Unknown	PK
`location_address_id`	Unknown	FK
`address`	Unknown
`address_2`	Unknown
`allow_legal_entity_override`	Unknown
`city_name`	Unknown
`country_code`	Unknown
`country_name`	Unknown
`county`	Unknown
`description`	Unknown
`jedd_taxes`	Unknown
`location_name`	Unknown
`postal_code`	Unknown
`state_code`	Unknown
`state_name`	Unknown

payee_parameter

Column	Type	Keys
`id`	Unknown	PK
`payee_name`	Unknown	PKFK
`payee_operating_country_code`	Unknown	PKFK
`access_type_code`	Unknown
`access_type_name`	Unknown
`data_type_code`	Unknown
`description`	Unknown
`max_length`	Unknown
`name`	Unknown
`parameter_type_id`	Unknown
`parameter_type_name`	Unknown
`pattern`	Unknown
`required`	Unknown

payee_state_coverage

Column	Type	Keys
`index`	Unknown	PK
`payee_name`	Unknown	PKFK
`payee_operating_country_code`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`state_code`	Unknown
`state_name`	Unknown

payee

Column	Type	Keys
`name`	Unknown	PK
`operating_country_code`	Unknown	PK
`active`	Unknown
`address_city`	Unknown
`address_country_code`	Unknown
`address_country_name`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_line_3`	Unknown
`address_postal_code`	Unknown
`address_state_province_code`	Unknown
`address_state_province_name`	Unknown
`business_number`	Unknown
`deduction_payee`	Unknown
`description`	Unknown
`earning_payee`	Unknown
`electronic_service_address`	Unknown
`health_care_provider_additional_contribution_percentage`	Unknown
`health_care_provider_business_number`	Unknown
`health_care_provider_data_collection_point`	Unknown
`health_care_provider_effective_from`	Unknown
`health_care_provider_effective_to`	Unknown
`health_care_provider_forwarding_office`	Unknown
`health_care_provider_institution_code`	Unknown
`health_care_provider_insurance_type`	Unknown
`health_care_provider_successor_business_number`	Unknown
`health_care_provider_u_1_percentage`	Unknown
`health_care_provider_u_2_percentage`	Unknown
`id`	Unknown
`operating_country_name`	Unknown
`payee_category_id`	Unknown
`payee_category_name`	Unknown
`payment_method_account_number`	Unknown
`payment_method_account_type_code`	Unknown
`payment_method_account_type_name`	Unknown
`payment_method_allow_negative_amount`	Unknown
`payment_method_bank_name`	Unknown
`payment_method_bank_number`	Unknown
`payment_method_building_society_number`	Unknown
`payment_method_combine_earning_and_deduction`	Unknown
`payment_method_combine_employee`	Unknown
`payment_method_id`	Unknown
`payment_method_name`	Unknown
`payment_method_payable_to`	Unknown
`payment_method_payee_code`	Unknown
`payment_method_payee_reference_number`	Unknown
`payment_method_payment_frequency_id`	Unknown
`payment_method_payment_frequency_name`	Unknown
`payment_method_schedule_end_date`	Unknown
`payment_method_schedule_pay_date`	Unknown
`payment_method_schedule_start_date`	Unknown
`payment_method_show_employee_detail`	Unknown
`payment_method_statement_language_code`	Unknown
`payment_method_statement_language_name`	Unknown
`payment_method_statement_message`	Unknown
`payment_method_suppress_print_of_advice_statement`	Unknown
`payment_method_transit_number`	Unknown
`system_payee`	Unknown
`unique_super_identifier`	Unknown

earning_statement_header

Column	Type	Keys
`earning_statement_header`	Unknown	PK
`employee_id`	Unknown	PKFK

employee_employment_information

Column	Type	Keys
`employee_employment_status_id`	Unknown	PK
`employee_id`	Unknown	PKFK
`employment_status_id`	Unknown	FK
`employment_status_reason_id`	Unknown	FK
`pay_class_id`	Unknown	FK
`pay_group_id`	Unknown	FK
`pay_type_id`	Unknown	FK
`alternate_rate`	Unknown
`attendance_policy_id`	Unknown
`attendance_policy_last_modified_timestamp`	Unknown
`attendance_policy_long_name`	Unknown
`attendance_policy_short_name`	Unknown
`attendance_policy_tracking_based_on`	Unknown
`authorization_policy_id`	Unknown
`authorization_policy_last_modified_timestamp`	Unknown
`authorization_policy_long_name`	Unknown
`authorization_policy_short_name`	Unknown
`average_daily_hours`	Unknown
`average_overtime_rate`	Unknown
`base_rate`	Unknown
`base_rate_manually_set`	Unknown
`base_salary`	Unknown
`create_shift_rotation_shift`	Unknown
`daily_rate`	Unknown
`deu_hours_change_reason_id`	Unknown
`deu_hours_change_reason_itsg_code`	Unknown
`deu_hours_change_reason_last_modified_timestamp`	Unknown
`deu_hours_change_reason_long_name`	Unknown
`deu_hours_change_reason_short_name`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`employee_group_id`	Unknown
`employee_group_last_modified_timestamp`	Unknown
`employee_group_long_name`	Unknown
`employee_group_short_name`	Unknown
`employee_number`	Unknown
`employment_status_group_id`	Unknown
`employment_status_group_last_modified_timestamp`	Unknown
`employment_status_group_long_name`	Unknown
`employment_status_group_short_name`	Unknown
`employment_status_long_name`	Unknown
`employment_status_short_name`	Unknown
`entitlement_policy_id`	Unknown
`entitlement_policy_last_modified_timestamp`	Unknown
`entitlement_policy_long_name`	Unknown
`entitlement_policy_short_name`	Unknown
`job_step_policy_id`	Unknown
`job_step_policy_last_modified_timestamp`	Unknown
`job_step_policy_long_name`	Unknown
`job_step_policy_short_name`	Unknown
`last_modified_timestamp`	Unknown
`last_pay_edit_date`	Unknown
`monthly_hour`	Unknown
`normal_semi_monthly_hours_bottom`	Unknown
`normal_semi_monthly_hours_top`	Unknown
`normal_weekly_hours`	Unknown
`original_effective_end`	Unknown
`original_effective_start`	Unknown
`original_employment_status_id`	Unknown
`original_employment_status_is_benefit_arrears_enabled`	Unknown
`original_employment_status_last_modified_timestamp`	Unknown
`original_employment_status_long_name`	Unknown
`original_employment_status_short_name`	Unknown
`overtime_group_id`	Unknown
`overtime_group_last_modified_timestamp`	Unknown
`overtime_group_long_name`	Unknown
`overtime_group_short_name`	Unknown
`pay_frequency_id`	Unknown
`pay_frequency_last_modified_timestamp`	Unknown
`pay_frequency_long_name`	Unknown
`pay_frequency_pay_frequency_type`	Unknown
`pay_frequency_short_name`	Unknown
`pay_group_last_modified_timestamp`	Unknown
`pay_group_long_name`	Unknown
`pay_group_pay_frequency_long_name`	Unknown
`pay_group_pay_frequency_short_name`	Unknown
`pay_group_short_name`	Unknown
`pay_holiday_group_id`	Unknown
`pay_holiday_group_last_modified_timestamp`	Unknown
`pay_holiday_group_long_name`	Unknown
`pay_holiday_group_short_name`	Unknown
`pay_policy_id`	Unknown
`pay_policy_last_modified_timestamp`	Unknown
`pay_policy_long_name`	Unknown
`pay_policy_short_name`	Unknown
`pay_type_group_id`	Unknown
`pay_type_group_last_modified_timestamp`	Unknown
`pay_type_group_long_name`	Unknown
`pay_type_group_short_name`	Unknown
`payroll_policy_id`	Unknown
`payroll_policy_last_modified_timestamp`	Unknown
`payroll_policy_long_name`	Unknown
`payroll_policy_short_name`	Unknown
`periodic_salary`	Unknown
`punch_policy_id`	Unknown
`punch_policy_last_modified_timestamp`	Unknown
`punch_policy_long_name`	Unknown
`punch_policy_short_name`	Unknown
`schedule_change_policy_id`	Unknown
`schedule_change_policy_last_modified_timestamp`	Unknown
`schedule_change_policy_long_name`	Unknown
`schedule_change_policy_short_name`	Unknown
`schedule_policy_id`	Unknown
`schedule_policy_last_modified_timestamp`	Unknown
`schedule_policy_long_name`	Unknown
`schedule_policy_short_name`	Unknown
`shift_rotation_day_offset`	Unknown
`shift_rotation_id`	Unknown
`shift_rotation_last_modified_timestamp`	Unknown
`shift_rotation_long_name`	Unknown
`shift_rotation_short_name`	Unknown
`shift_rotation_start_date`	Unknown
`shift_trade_policy_id`	Unknown
`shift_trade_policy_last_modified_timestamp`	Unknown
`shift_trade_policy_long_name`	Unknown
`shift_trade_policy_short_name`	Unknown
`target_bonus`	Unknown
`time_off_policy_id`	Unknown
`time_off_policy_last_modified_timestamp`	Unknown
`time_off_policy_long_name`	Unknown
`time_off_policy_short_name`	Unknown
`vacation_rate`	Unknown
`work_contract_premium_policy_id`	Unknown
`work_contract_premium_policy_last_modified_timestamp`	Unknown
`work_contract_premium_policy_long_name`	Unknown
`work_contract_premium_policy_short_name`	Unknown

employee_time_away_from_work

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`all_day`	Unknown
`daily_elapsed_hours`	Unknown
`date_of_request`	Unknown
`employee_comment`	Unknown
`half_day`	Unknown
`manager_comment`	Unknown
`net_hour`	Unknown
`net_unit`	Unknown
`net_units_type`	Unknown
`reason_name`	Unknown
`status`	Unknown
`tafw_xref_code`	Unknown
`time_end`	Unknown
`time_start`	Unknown

organization_unit_legal_entity_item

Column	Type	Keys
`id`	Unknown	PK
`organization_unit_id`	Unknown	PKFK
`effective_start`	Unknown
`legal_entity_long_name`	Unknown
`legal_entity_short_name`	Unknown
`legal_entity_work_site_state_id`	Unknown
`legal_entity_work_site_state_last_modified_timestamp`	Unknown
`legal_entity_work_site_state_long_name`	Unknown
`legal_entity_work_site_state_short_name`	Unknown
`override_customer_funding_identifier_id`	Unknown
`override_customer_funding_identifier_last_modified_timestamp`	Unknown
`override_customer_funding_identifier_long_name`	Unknown
`override_customer_funding_identifier_short_name`	Unknown

organization_unit_parent_item

Column	Type	Keys
`id`	Unknown	PK
`organization_unit_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`organization_unit_parent_item_id`	Unknown
`parent_long_name`	Unknown
`parent_short_name`	Unknown
`short_name`	Unknown

organization_unit_child_legal_entity_item

Column	Type	Keys
`id`	Unknown	PK
`organization_unit_child_id`	Unknown	PKFK
`organization_unit_id`	Unknown	PKFK
`effective_start`	Unknown
`legal_entity_long_name`	Unknown
`legal_entity_short_name`	Unknown
`legal_entity_work_site_state_id`	Unknown
`legal_entity_work_site_state_last_modified_timestamp`	Unknown
`legal_entity_work_site_state_long_name`	Unknown
`legal_entity_work_site_state_short_name`	Unknown
`override_customer_funding_identifier_id`	Unknown
`override_customer_funding_identifier_last_modified_timestamp`	Unknown
`override_customer_funding_identifier_long_name`	Unknown
`override_customer_funding_identifier_short_name`	Unknown

organization_unit_child_parent_item

Column	Type	Keys
`id`	Unknown	PK
`organization_unit_child_id`	Unknown	PKFK
`organization_unit_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`organization_unit_child_parent_item_id`	Unknown
`parent_long_name`	Unknown
`parent_short_name`	Unknown
`short_name`	Unknown

organization_unit_child_location_type_item

Column	Type	Keys
`_fivetran_id`	String	PK
`organization_unit_child_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`last_modified_timestamp`	Unknown
`location_type_id`	Unknown
`location_type_last_modified_timestamp`	Unknown
`location_type_long_name`	Unknown
`location_type_short_name`	Unknown

organization_unit_child

Column	Type	Keys
`id`	Unknown	PK
`organization_unit_id`	Unknown	PKFK
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`org_level_id`	Unknown
`org_level_last_modified_timestamp`	Unknown
`org_level_long_name`	Unknown
`org_level_short_name`	Unknown
`short_name`	Unknown

organization_unit_location_type_item

Column	Type	Keys
`location_type_id`	Unknown	PK
`organization_unit_id`	Unknown	PKFK
`last_modified_timestamp`	Unknown
`location_type_last_modified_timestamp`	Unknown
`location_type_long_name`	Unknown
`location_type_short_name`	Unknown

organization_unit

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`address`	Unknown
`address_2`	Unknown
`business_phone`	Unknown
`child_org_units`	Unknown
`clock_transfer_code`	Unknown
`closing_date`	Unknown
`comparable_location_id`	Unknown
`comparable_location_long_name`	Unknown
`comparable_location_short_name`	Unknown
`contact_business_phone`	Unknown
`contact_cell_phone`	Unknown
`contact_email`	Unknown
`contact_name`	Unknown
`country_code`	Unknown
`county`	Unknown
`geo_city_last_modified_timestamp`	Unknown
`geo_city_long_name`	Unknown
`geo_city_short_name`	Unknown
`is_mobile_org`	Unknown
`is_org_managed`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`legal_entity`	Unknown
`legal_entity_address_address_1`	Unknown
`legal_entity_address_address_2`	Unknown
`legal_entity_address_address_3`	Unknown
`legal_entity_address_address_4`	Unknown
`legal_entity_address_address_5`	Unknown
`legal_entity_address_address_6`	Unknown
`legal_entity_address_city`	Unknown
`legal_entity_address_country_id`	Unknown
`legal_entity_address_country_last_modified_timestamp`	Unknown
`legal_entity_address_country_long_name`	Unknown
`legal_entity_address_country_name`	Unknown
`legal_entity_address_country_short_name`	Unknown
`legal_entity_address_last_modified_timestamp`	Unknown
`legal_entity_address_postal_code`	Unknown
`legal_entity_address_state_id`	Unknown
`legal_entity_address_state_last_modified_timestamp`	Unknown
`legal_entity_address_state_long_name`	Unknown
`legal_entity_address_state_name`	Unknown
`legal_entity_address_state_short_name`	Unknown
`legal_entity_country_id`	Unknown
`legal_entity_country_last_modified_timestamp`	Unknown
`legal_entity_country_long_name`	Unknown
`legal_entity_country_name`	Unknown
`legal_entity_country_short_name`	Unknown
`legal_entity_id`	Unknown
`legal_entity_last_modified_timestamp`	Unknown
`legal_entity_legal_entity_address`	Unknown
`legal_entity_legal_id_number`	Unknown
`legal_entity_long_name`	Unknown
`legal_entity_short_name`	Unknown
`long_name`	Unknown
`opening_date`	Unknown
`org_level_id`	Unknown
`org_level_last_modified_timestamp`	Unknown
`org_level_long_name`	Unknown
`org_level_short_name`	Unknown
`org_unit_location_type`	Unknown
`org_unit_parents`	Unknown
`physical_location`	Unknown
`postal_code`	Unknown
`public_name`	Unknown
`short_name`	Unknown
`start_day_of_week`	Unknown
`state_code`	Unknown
`timezone_id`	Unknown
`timezone_last_modified_timestamp`	Unknown
`timezone_long_name`	Unknown
`timezone_short_name`	Unknown
`zone_id`	Unknown
`zone_last_modified_timestamp`	Unknown
`zone_long_name`	Unknown
`zone_short_name`	Unknown

job_position_assignment

Column	Type	Keys
`job_assignment_id`	Unknown	PKFK
`organization_unit_id`	Unknown	PKFK

job_assignment

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`job_id`	Unknown	FK
`pay_class_id`	Unknown	FK
`pay_group_id`	Unknown	FK
`pay_type_id`	Unknown	FK
`average_daily_hours`	Unknown
`clock_transfer_code`	Unknown
`default_target_bonus`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`employment_indicator_id`	Unknown
`employment_indicator_last_modified_timestamp`	Unknown
`employment_indicator_long_name`	Unknown
`employment_indicator_short_name`	Unknown
`executive`	Unknown
`fte`	Unknown
`is_non_service`	Unknown
`is_wcb_exempt`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`officer`	Unknown
`position_term_id`	Unknown
`position_term_last_modified_timestamp`	Unknown
`position_term_long_name`	Unknown
`position_term_short_name`	Unknown
`ppaca_full_time`	Unknown
`semi_monthly_bottom_hours`	Unknown
`semi_monthly_top_hours`	Unknown
`short_name`	Unknown
`standard_cost_rate`	Unknown
`weekly_hours`	Unknown

confidential_identification

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`confidential_identification_type_last_modified_timestamp`	Unknown
`confidential_identification_type_long_name`	Unknown
`confidential_identification_type_short_name`	Unknown
`country_code`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`expiry_date`	Unknown
`id_number`	Unknown
`issue_date`	Unknown
`last_modified_timestamp`	Unknown
`place_of_issue`	Unknown
`rtw_doc_review`	Unknown
`rtw_doc_review_on`	Unknown
`use_for_rtw`	Unknown

availability

Column	Type	Keys
`date_of_request`	Unknown	PK
`employee_id`	Unknown	PKFK
`end_time_1`	Unknown
`end_time_2`	Unknown
`is_default`	Unknown
`start_time_1`	Unknown
`start_time_2`	Unknown
`un_available`	Unknown

work_assignment_manager

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`job_assignment_id`	Unknown	FK
`manager_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`effective_end`	Unknown
`effective_start`	Unknown
`employment_status_group_id`	Unknown
`last_modified_timestamp`	Unknown
`manager_name`	Unknown
`termination_date`	Unknown

pay_run_status

Column	Type	Keys
`_fivetran_id`	String	PK
`country_code`	Unknown
`country_name`	Unknown
`currency`	Unknown
`pay_date`	Unknown
`pay_group_id`	Unknown
`pay_group_name`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`ppn`	Unknown
`rejection_reason`	Unknown
`rejection_reason_category`	Unknown
`rejection_reason_category_id`	Unknown
`rejection_reason_description`	Unknown
`rejection_reason_id`	Unknown
`status`	Unknown

work_assignment

Column	Type	Keys
`effective_start`	Unknown	PK
`is_primary`	Unknown	PK
`employee_id`	Unknown	PKFK
`employment_status_reason_id`	Unknown	FK
`job_assignment_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`work_location_override_id`	Unknown	FK
`business_title`	Unknown
`business_unit_effective_end`	Unknown
`business_unit_effective_start`	Unknown
`business_unit_global_id`	Unknown
`business_unit_id`	Unknown
`business_unit_last_modified_timestamp`	Unknown
`business_unit_ledger_code`	Unknown
`business_unit_long_name`	Unknown
`business_unit_parent`	Json
`business_unit_short_name`	Unknown
`effective_end`	Unknown
`employment_indicator_id`	Unknown
`employment_indicator_last_modified_timestamp`	Unknown
`employment_indicator_long_name`	Unknown
`employment_indicator_short_name`	Unknown
`flat_amount`	Unknown
`fte`	Unknown
`is_pa_primary_work_site`	Unknown
`is_statutory`	Unknown
`is_virtual`	Unknown
`job_classification_global_id`	Unknown
`job_classification_global_last_modified_timestamp`	Unknown
`job_classification_global_long_name`	Unknown
`job_classification_global_short_name`	Unknown
`job_rate`	Unknown
`job_set_grade`	Unknown
`job_set_id`	Unknown
`job_set_last_modified_timestamp`	Unknown
`job_set_level_id`	Unknown
`job_set_level_last_modified_timestamp`	Unknown
`job_set_level_long_name`	Unknown
`job_set_level_short_name`	Unknown
`job_set_long_name`	Unknown
`job_set_short_name`	Unknown
`labor_percentage`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`multi_j_salary_allocation_percent`	Unknown
`participate_in_reciprocal_tax_calculation`	Unknown
`pm_position_assignment_effective_end`	Unknown
`pm_position_assignment_effective_start`	Unknown
`pm_position_assignment_is_interim`	Unknown
`pm_position_assignment_is_primary`	Unknown
`pm_position_assignment_last_modified_timestamp`	Unknown
`pm_position_assignment_position_assignment_global_id`	Unknown
`pm_position_effective_end`	Unknown
`pm_position_effective_start`	Unknown
`pm_position_fte`	Unknown
`pm_position_id`	Unknown
`pm_position_last_modified_timestamp`	Unknown
`pm_position_ledger_code`	Unknown
`pm_position_long_name`	Unknown
`pm_position_number`	Unknown
`pm_position_position_global_id`	Unknown
`pm_position_short_name`	Unknown
`position_term_id`	Unknown
`position_term_last_modified_timestamp`	Unknown
`position_term_long_name`	Unknown
`position_term_short_name`	Unknown
`pr_bank_account_branch_address_id`	Unknown
`pr_bank_account_branch_address_last_modified_timestamp`	Unknown
`pr_bank_account_branch_address_long_name`	Unknown
`pr_bank_account_branch_address_short_name`	Unknown
`rank`	Unknown
`telecommuter_percentage`	Unknown
`tip_type_group_id`	Unknown
`tip_type_group_last_modified_timestamp`	Unknown
`tip_type_group_long_name`	Unknown
`tip_type_group_short_name`	Unknown

employment_status_reason

Column	Type	Keys
`id`	Unknown	PK
`is_comp_change_reason`	Unknown
`is_leave_reason`	Unknown
`is_position_change_reason`	Unknown
`is_termination_reason`	Unknown
`is_voluntary_reason`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`short_name`	Unknown

employee_schedule_break

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_schedule_id`	Unknown	FK
`net_hour`	Unknown
`time_end`	Unknown
`time_start`	Unknown
`type`	Unknown

employee_schedule_activity

Column	Type	Keys
`id`	Unknown	PK
`employee_schedule_id`	Unknown	PKFK
`time_end`	Unknown
`time_start`	Unknown

employee_schedule_skill

Column	Type	Keys
`id`	Unknown	PK
`employee_schedule_id`	Unknown	PKFK
`is_mandatory`	Unknown
`skill_level_id`	Unknown

employee_schedule_labor_metric

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_schedule_id`	Unknown	FK
`code_id`	Unknown
`type_id`	Unknown

employee_schedule_segment_labor_metric

Column	Type	Keys
`index`	Unknown	PK
`employee_schedule_id`	Unknown	PKFK
`employee_schedule_segment_index`	Unknown	PKFK
`code_id`	Unknown
`type_id`	Unknown

employee_schedule_segment

Column	Type	Keys
`index`	Unknown	PK
`employee_schedule_id`	Unknown	PKFK
`department_id`	Unknown	FK
`job_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`pay_adjustment_code`	Unknown	FK
`position_id`	Unknown	FK
`project_id`	Unknown	FK
`comment`	Unknown
`docket_id`	Unknown
`net_hour`	Unknown
`organization_location_type_id`	Unknown
`time_end`	Unknown
`time_start`	Unknown

employee_schedule

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`employee_id`	Unknown	FK
`job_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`pay_adjustment_code`	Unknown	FK
`position_id`	Unknown	FK
`project_id`	Unknown	FK
`site_organisation_unit_id`	Unknown	FK
`comment`	Unknown
`docket_id`	Unknown
`is_posted_shift_bid`	Unknown
`net_hour`	Unknown
`organisation_location_type_id`	Unknown
`published`	Unknown
`time_end`	Unknown
`time_start`	Unknown

contact_information_type

Column	Type	Keys
`id`	Unknown	PK
`contact_information_type_group`	Unknown
`contact_information_type_group_last_modified_timestamp`	Unknown
`contact_information_type_group_long_name`	Unknown
`contact_information_type_group_short_name`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`short_name`	Unknown

project_creation_organization_unit

Column	Type	Keys
`creation_organization_unit_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

child_project

Column	Type	Keys
`child_project_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_employee

Column	Type	Keys
`employee_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_department_job

Column	Type	Keys
`department_job_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_department

Column	Type	Keys
`department_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_pay_charge_to_hour

Column	Type	Keys
`pay_charge_to_hour`	Unknown	PK
`project_id`	Unknown	PKFK

project_pay_charge_to_amount

Column	Type	Keys
`pay_charge_to_amount`	Unknown	PK
`project_id`	Unknown	PKFK

project

Column	Type	Keys
`id`	Unknown	PK
`parent_project_id`	Unknown	FK
`account_num`	Unknown
`budget_amount`	Unknown
`budget_hours`	Unknown
`certified_payroll_project_number`	Unknown
`clock_transfer_code`	Unknown
`completed_date`	Unknown
`deleted`	Unknown
`department_is_assigned_all`	Unknown
`department_job_is_assigned_all`	Unknown
`due_date`	Unknown
`employee_is_assigned_all`	Unknown
`ifrs_classification`	Unknown
`is_coe_project`	Unknown
`is_resident_address_used_for_taxation`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`pay_charge_to_amount_is_assigned_all`	Unknown
`pay_charge_to_hours_is_assigned_all`	Unknown
`pct_complete`	Unknown
`product_group_id`	Unknown
`product_module_id`	Unknown
`project_client_id`	Unknown
`project_phase_id`	Unknown
`project_priority`	Unknown
`project_type_id`	Unknown
`short_name`	Unknown
`start_date`	Unknown
`tax_location_address_id`	Unknown

employee_contact

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`contact_information_type_group_last_modified_timestamp`	Unknown
`contact_information_type_group_long_name`	Unknown
`contact_information_type_group_short_name`	Unknown
`contact_information_type_group_xref_code`	Unknown
`contact_information_type_last_modified_timestamp`	Unknown
`contact_information_type_long_name`	Unknown
`contact_information_type_short_name`	Unknown
`contact_information_type_xref_code`	Unknown
`contact_number`	Unknown
`country_last_modified_timestamp`	Unknown
`country_long_name`	Unknown
`country_name`	Unknown
`country_short_name`	Unknown
`country_xref_code`	Unknown
`effective_start`	Unknown
`electronic_address`	Unknown
`extension`	Unknown
`formatted_number`	Unknown
`is_for_system_communication`	Unknown
`is_preferred_contact_method`	Unknown
`is_rejected`	Unknown
`is_unlisted_number`	Unknown
`is_verified`	Unknown
`last_modified_timestamp`	Unknown
`number_of_verification_request`	Unknown
`person_contact_id`	Unknown
`show_rejected_warning`	Unknown

employee_address

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`address_5`	Unknown
`address_6`	Unknown
`city`	Unknown
`contact_information_type_group_long_name`	Unknown
`contact_information_type_group_short_name`	Unknown
`contact_information_type_group_xref_code`	Unknown
`contact_information_type_long_name`	Unknown
`contact_information_type_short_name`	Unknown
`contact_information_type_xref_code`	Unknown
`country_long_name`	Unknown
`country_name`	Unknown
`country_short_name`	Unknown
`country_xref_code`	Unknown
`county`	Unknown
`display_on_earning_statement`	Unknown
`display_on_tax_form`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`is_payroll_mailing`	Unknown
`last_modified_timestamp`	Unknown
`person_address_id`	Unknown
`postal_code`	Unknown
`state_long_name`	Unknown
`state_name`	Unknown
`state_short_name`	Unknown
`state_xref_code`	Unknown

employee_role

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`is_default`	Unknown
`is_prestart_role`	Unknown
`last_modified_timestamp`	Unknown
`role_long_name`	Unknown
`role_short_name`	Unknown
`role_xref_code`	Unknown

employee_sso_account

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`last_modified_timestamp`	Unknown
`login_name`	Unknown

employee_marital_status

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`marital_status_long_name`	Unknown
`marital_status_short_name`	Unknown
`marital_status_xref_code`	Unknown

employee_religion

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`is_default`	Unknown
`last_modified_timestamp`	Unknown
`religion_long_name`	Unknown
`religion_short_name`	Unknown
`religion_xref_code`	Unknown

employee_health_wellness_detail

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`date_last_smoked`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`tobacco_user`	Unknown

employee_property

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`bit_value`	Unknown
`data_type`	Unknown
`data_type_param`	Unknown
`date_time_value`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`employee_cardinality`	Unknown
`generate_hr_event`	Unknown
`id`	Unknown
`is_editable`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`number_value`	Unknown
`option_value_last_modified_timestamp`	Unknown
`option_value_long_name`	Unknown
`option_value_short_name`	Unknown
`option_value_xref_code`	Unknown
`property_last_modified_timestamp`	Unknown
`sequence`	Unknown
`short_name`	Unknown
`string_value`	Unknown

employee_volunteer_list

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`volunteer_list_long_name`	Unknown
`volunteer_list_short_name`	Unknown
`volunteer_list_xref_code`	Unknown

employee

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`home_organization_id`	Unknown	FK
`aus_federal_taxes`	Json
`aus_superannuation_rules`	Json
`authorization_assignments`	Json
`avatar_uri`	Unknown
`badge_number`	Unknown
`bio_exempt`	Unknown
`bio_sensitivity_level_last_modified_timestamp`	Unknown
`bio_sensitivity_level_long_name`	Unknown
`bio_sensitivity_level_short_name`	Unknown
`bio_sensitivity_level_x_ref_code`	Unknown
`birth_city`	Unknown
`birth_country`	Unknown
`birth_date`	Unknown
`birth_state`	Unknown
`can_federal_taxes`	Json
`can_state_taxes`	Json
`can_tax_statuses`	Json
`checksum_timestamp`	Unknown
`citizenship_type_last_modified_timestamp`	Unknown
`citizenship_type_long_name`	Unknown
`citizenship_type_short_name`	Unknown
`citizenship_type_x_ref_code`	Unknown
`clock_device_group`	Json
`clock_supervisor`	Unknown
`cobra_notification_sent_date`	Unknown
`cobra_notification_status`	Unknown
`common_name`	Unknown
`continuous_employment_start_date`	Unknown
`courses`	Json
`culture_last_modified_timestamp`	Unknown
`culture_long_name`	Unknown
`culture_short_name`	Unknown
`culture_x_ref_code`	Unknown
`date_of_death`	Unknown
`deduction_elections`	Json
`dependents_beneficiaries`	Json
`deu_employee_accident_insurance`	Json
`deu_employee_wage_tax`	Json
`deu_tax_social_insurance`	Json
`direct_deposit`	Json
`disability`	Json
`display_name`	Unknown
`document_management_security_group`	Json
`earning_elections`	Json
`ei_rates`	Json
`eligible_for_df_wallet_pay_card`	Unknown
`eligible_for_on_demand_pay`	Unknown
`eligible_for_pre_tax_tips`	Unknown
`eligible_for_rehire`	Unknown
`emergency_contact`	Json
`employee_assigned_sex_and_gender_identities`	Json
`employee_badge_effective_end`	Unknown
`employee_badge_effective_start`	Unknown
`employee_badge_last_modified_timestamp`	Unknown
`employee_badge_number`	Unknown
`employee_certifications`	Json
`employee_id`	Unknown
`employee_latest_updated_timestamp`	Unknown
`employee_pay_adjust_code_group`	Json
`employee_payroll_tax_parameters`	Json
`employee_payroll_taxes`	Json
`employee_pin`	Unknown
`employee_short_time_work`	Json
`employee_uk_irregular_payment_details`	Json
`employment_agreements`	Json
`entitlement_override_date`	Unknown
`estimated_return_date`	Unknown
`ethnicity`	Json
`export_date`	Unknown
`federated_id`	Unknown
`first_name`	Unknown
`first_time_access_email_sent_count`	Unknown
`first_time_access_verification_attempt`	Unknown
`first_time_access_verification_attempts`	Unknown
`gender`	Unknown
`gender_identity_last_modified_timestamp`	Unknown
`gender_identity_long_name`	Unknown
`gender_identity_short_name`	Unknown
`gender_identity_x_ref_code`	Unknown
`global_property`	Json
`has_managed_employee`	Unknown
`hire_date`	Unknown
`home_phone`	Unknown
`hr_incident`	Json
`hr_policies`	Json
`initials`	Unknown
`irl_tax_ewss_info`	Json
`irl_tax_payee_exclusion_info`	Json
`irl_tax_prsi_info`	Json
`irl_tax_rpn_info`	Json
`is_aboriginal`	Unknown
`is_visible_minority`	Unknown
`labor_default`	Json
`last_active_managers`	Json
`last_modified_timestamp`	Unknown
`last_name`	Unknown
`last_name_prefix_at_birth_last_modified_timestamp`	Unknown
`last_name_prefix_at_birth_long_name`	Unknown
`last_name_prefix_at_birth_short_name`	Unknown
`last_name_prefix_at_birth_x_ref_code`	Unknown
`last_name_prefix_last_modified_timestamp`	Unknown
`last_name_prefix_long_name`	Unknown
`last_name_prefix_short_name`	Unknown
`last_name_prefix_x_ref_code`	Unknown
`last_payroll_new_hire_export_date`	Unknown
`login_id`	Unknown
`lsl_eligibility_date`	Unknown
`maiden_name`	Unknown
`managed_employees`	Json
`middle_name`	Unknown
`mus_taxes`	Json
`name_affix_at_birth_last_modified_timestamp`	Unknown
`name_affix_at_birth_long_name`	Unknown
`name_affix_at_birth_short_name`	Unknown
`name_affix_at_birth_x_ref_code`	Unknown
`name_affix_last_modified_timestamp`	Unknown
`name_affix_long_name`	Unknown
`name_affix_short_name`	Unknown
`name_affix_x_ref_code`	Unknown
`nationality`	Unknown
`new_hire_approval_date`	Unknown
`new_hire_approved`	Unknown
`new_hire_approved_by`	Unknown
`new_xref_code`	Unknown
`nzl_kiwi_saver`	Json
`onboarding_policies`	Json
`original_hire_date`	Unknown
`pay_grade_rate`	Json
`pay_period_information`	Json
`pay_roll_key`	Unknown
`performance_rating`	Json
`photo_exempt`	Unknown
`ppaca_override_date`	Unknown
`pre_start_date`	Unknown
`preferred_last_name`	Unknown
`previous_last_name`	Unknown
`professional_title`	Unknown
`pronouns`	Unknown
`registered_disabled`	Unknown
`requires_exit_interview`	Unknown
`retirement_request_date`	Unknown
`school_year_last_modified_timestamp`	Unknown
`school_year_long_name`	Unknown
`school_year_short_name`	Unknown
`school_year_x_ref_code`	Unknown
`second_last_name`	Unknown
`send_first_time_access_email`	Unknown
`seniority_date`	Unknown
`social_security_number`	Unknown
`ssn_country_code`	Unknown
`ssn_expiry_date`	Unknown
`start_date`	Unknown
`suffix`	Unknown
`tax_exempt`	Unknown
`termination_notice_date`	Unknown
`title`	Unknown
`training_programs`	Json
`uk_ni_details`	Json
`uk_postgraduate_loan`	Json
`uk_student_loan`	Json
`uk_tax_details`	Json
`union_memberships`	Json
`unknown_birth_date`	Unknown
`us_federal_taxes`	Json
`us_state_taxes`	Json
`us_tax_statuses`	Json
`user_account_allow_native_authentication`	Unknown
`user_account_display_24_hour_time`	Unknown
`user_account_is_approved`	Unknown
`user_pay_adjust_code_group`	Json
`vac_bid_group`	Json
`veteran_separation_date`	Unknown
`veteran_status`	Json
`work_contract`	Json
`zone_last_modified_timestamp`	Unknown
`zone_long_name`	Unknown
`zone_short_name`	Unknown
`zone_x_ref_code`	Unknown
`custom_`

employee_balance_transaction_transaction

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_balance_id`	Unknown	FK
`employee_balance_transaction_id`	Unknown	FK
`employee_id`	Unknown	FK
`approval_status`	Unknown
`comment`	Unknown
`deltas`	Unknown
`expiry_date`	Unknown
`grant_delta`	Unknown
`tafw_id`	Unknown
`transaction_date`	Unknown
`transaction_source`	Unknown

employee_balance_transaction

Column	Type	Keys
`id`	Unknown	PK
`employee_balance_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`effective_end`	Unknown
`effective_start`	Unknown

report_metadata_column

Column	Type	Keys
`index`	Unknown	PK
`report_metadata_report_id`	Unknown	PKFK
`code_name`	Unknown
`data_type`	Unknown
`display_name`	Unknown

report_metadata_parameter

Column	Type	Keys
`index`	Unknown	PK
`report_metadata_report_id`	Unknown	PKFK
`available_values`	Json
`data_type`	Unknown
`default_value`	Unknown
`display_name`	Unknown
`is_required`	Unknown
`name`	Unknown
`operator`	Unknown
`report_parameter_metadata_id`	Unknown

report_metadata

Column	Type	Keys
`report_id`	Unknown	PK
`description`	Unknown
`max_rows`	Unknown
`name`	Unknown

location_address

Column	Type	Keys
`_fivetran_id`	String	PK
`address`	Unknown
`address_line_two`	Unknown
`city`	Unknown
`country_code`	Unknown
`country_name`	Unknown
`county`	Unknown
`description`	Unknown
`id`	Unknown
`is_taxation`	Unknown
`jedd_taxes`	Unknown
`last_modified_timestamp`	Unknown
`location_in_jt_economic_dev_dist_area_jedd`	Unknown
`long_name`	Unknown
`short_name`	Unknown
`state_province`	Unknown
`state_province_code`	Unknown
`tax_authority_instance`	Unknown
`zip_postal_code`	Unknown

compensation_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`employment_status_reason_id`	Unknown	FK
`pay_class_id`	Unknown	FK
`pay_type_id`	Unknown	FK
`alternate_rate`	Unknown
`average_daily_hours`	Unknown
`average_overtime_rate`	Unknown
`base_rate`	Unknown
`base_rate_manually_set`	Unknown
`base_salary`	Unknown
`change_percent`	Unknown
`change_value`	Unknown
`comp_ratio`	Unknown
`control_rate`	Unknown
`control_salary`	Unknown
`daily_rate`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`employee_number`	Unknown
`last_modified_timestamp`	Unknown
`last_pay_edit_date`	Unknown
`maximum_rate`	Unknown
`maximum_salary`	Unknown
`minimum_rate`	Unknown
`minimum_salary`	Unknown
`normal_semi_monthly_hours_bottom`	Unknown
`normal_semi_monthly_hours_top`	Unknown
`normal_weekly_hours`	Unknown
`pay_grade_id`	Unknown
`pay_grade_last_modified_timestamp`	Unknown
`pay_grade_long_name`	Unknown
`pay_grade_short_name`	Unknown
`pay_group_frequency_id`	Unknown
`pay_group_frequency_last_modified_timestamp`	Unknown
`pay_group_frequency_long_name`	Unknown
`pay_group_frequency_short_name`	Unknown
`pay_group_frequency_type`	Unknown
`pay_group_id`	Unknown
`pay_group_last_modified_timestamp`	Unknown
`pay_group_long_name`	Unknown
`pay_group_short_name`	Unknown
`pay_policy_id`	Unknown
`pay_policy_last_modified_timestamp`	Unknown
`pay_policy_long_name`	Unknown
`pay_policy_short_name`	Unknown
`previous_base_rate`	Unknown
`previous_base_salary`	Unknown
`rate_mid_point`	Unknown
`rate_policy_id`	Unknown
`rate_policy_last_modified_timestamp`	Unknown
`rate_policy_long_name`	Unknown
`rate_policy_short_name`	Unknown
`salary_mid_point`	Unknown
`vacation_rate`	Unknown

employee_manager

Column	Type	Keys
`effective_start`	Unknown	PK
`employee_id`	Unknown	PKFK
`id`	Unknown	PKFK
`derivation_method`	Unknown
`effective_end`	Unknown
`last_modified_timestamp`	Unknown

job

Column	Type	Keys
`id`	Unknown	PK
`effective_end`	Unknown
`effective_start`	Unknown
`employee_eeo_id`	Unknown
`employee_eeo_last_modified_timestamp`	Unknown
`employee_eeo_long_name`	Unknown
`employee_eeo_short_name`	Unknown
`flsa_status_id`	Unknown
`flsa_status_last_modified_timestamp`	Unknown
`flsa_status_long_name`	Unknown
`flsa_status_short_name`	Unknown
`is_union_job`	Unknown
`job_classification_id`	Unknown
`job_classification_last_modified_timestamp`	Unknown
`job_classification_long_name`	Unknown
`job_classification_short_name`	Unknown
`job_family_id`	Unknown
`job_family_last_modified_timestamp`	Unknown
`job_family_long_name`	Unknown
`job_family_short_name`	Unknown
`job_function_id`	Unknown
`job_function_last_modified_timestamp`	Unknown
`job_function_level`	Unknown
`job_function_long_name`	Unknown
`job_function_short_name`	Unknown
`job_function_usable_for_external_posting`	Unknown
`job_qualification`	Unknown
`job_rank`	Unknown
`job_soc_id`	Unknown
`job_soc_last_modified_timestamp`	Unknown
`job_soc_long_name`	Unknown
`job_soc_short_name`	Unknown
`job_udf_string_1`	Unknown
`job_udf_string_2`	Unknown
`job_udf_string_3`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`noc`	Unknown
`pay_grade_id`	Unknown
`pay_grade_last_modified_timestamp`	Unknown
`pay_grade_long_name`	Unknown
`pay_grade_short_name`	Unknown
`short_name`	Unknown
`union_id`	Unknown
`union_last_modified_timestamp`	Unknown
`union_long_name`	Unknown
`union_short_name`	Unknown

employee_organization

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`department_id`	Unknown	FK
`organization_unit_parent_id`	Unknown	FK
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`address_5`	Unknown
`address_6`	Unknown
`address_last_modified_timestamp`	Unknown
`city`	Unknown
`country_id`	Unknown
`country_last_modified_timestamp`	Unknown
`country_long_name`	Unknown
`country_name`	Unknown
`country_short_name`	Unknown
`last_modified_timestamp`	Unknown
`org_level_id`	Unknown
`org_level_last_modified_timestamp`	Unknown
`org_level_long_name`	Unknown
`org_level_short_name`	Unknown
`org_unit_detail_child_sort_order`	Unknown
`org_unit_detail_effective_end`	Unknown
`org_unit_detail_effective_start`	Unknown
`org_unit_detail_is_physical_location`	Unknown
`org_unit_detail_is_primary`	Unknown
`org_unit_detail_last_modified_timestamp`	Unknown
`org_unit_detail_ledger_code`	Unknown
`org_unit_detail_long_name`	Unknown
`org_unit_detail_parent_sort_order`	Unknown
`org_unit_detail_short_name`	Unknown
`organization_unit_parent_effective_end`	Unknown
`organization_unit_parent_effective_start`	Unknown
`organization_unit_parent_last_modified_timestamp`	Unknown
`organization_unit_parent_long_name`	Unknown
`organization_unit_parent_short_name`	Unknown
`postal_code`	Unknown
`state_id`	Unknown
`state_last_modified_timestamp`	Unknown
`state_long_name`	Unknown
`state_name`	Unknown
`state_short_name`	Unknown
`tax_location_address_1`	Unknown
`tax_location_address_2`	Unknown
`tax_location_address_country_id`	Unknown
`tax_location_address_country_last_modified_timestamp`	Unknown
`tax_location_address_country_long_name`	Unknown
`tax_location_address_country_name`	Unknown
`tax_location_address_country_short_name`	Unknown
`tax_location_address_state_id`	Unknown
`tax_location_address_state_last_modified_timestamp`	Unknown
`tax_location_address_state_long_name`	Unknown
`tax_location_address_state_name`	Unknown
`tax_location_address_state_short_name`	Unknown
`tax_location_city`	Unknown
`tax_location_country`	Unknown
`tax_location_county`	Unknown
`tax_location_id`	Unknown
`tax_location_last_modified_timestamp`	Unknown
`tax_location_long_name`	Unknown
`tax_location_postal_code`	Unknown
`tax_location_short_name`	Unknown
`tax_location_state`	Unknown
`timezone_id`	Unknown
`timezone_last_modified_timestamp`	Unknown
`timezone_long_name`	Unknown
`timezone_short_name`	Unknown

employment_type

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`contractor_tax_form_type`	Unknown
`dba_name`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`employment_type_last_modified_timestamp`	Unknown
`employment_type_long_name`	Unknown
`employment_type_short_name`	Unknown
`gaming_profits_distribution`	Unknown
`ir_35`	Unknown
`last_modified_timestamp`	Unknown
`pension_type_id`	Unknown
`pension_type_last_modified_timestamp`	Unknown
`pension_type_long_name`	Unknown
`pension_type_short_name`	Unknown
`tax_payer_id`	Unknown

highly_compensated_employee

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`effective_end`	Unknown
`effective_start`	Unknown
`is_hce`	Unknown
`last_modified_timestamp`	Unknown

analyst_report_data_column

Column	Type	Keys
`_fivetran_id`	String	PK
`analyst_report_fivetran_id`	Unknown	FK
`data_type`	Unknown
`description`	Unknown
`name`	Unknown

analyst_report_data_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`analyst_report_fivetran_id`	Unknown	FK
`available_values`	Json
`data_type`	Unknown
`description`	Unknown
`editable`	Unknown
`is_required`	Unknown
`name`	Unknown
`operator`	Unknown
`sequence`	Unknown
`value`	Unknown

analyst_report

Column	Type	Keys
`_fivetran_id`	String	PK
`description`	Unknown
`max_row`	Unknown
`name`	Unknown
`only_include_unique_record`	Unknown
`report_id`	Unknown
`x_ref_code`	Unknown

pay_type

Column	Type	Keys
`id`	Unknown	PK
`hide_pay_on_timesheet`	Unknown
`is_payroll_auto_pay`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`maximum_rate`	Unknown
`maximum_salary`	Unknown
`short_name`	Unknown
`sort_order`	Unknown

employment_status

Column	Type	Keys
`id`	Unknown	PK
`effective_starting_point_of_day`	Unknown
`is_benefit_arrears_enabled`	Unknown
`last_modified_timestamp`	Unknown
`long_name`	Unknown
`short_name`	Unknown

department

Column	Type	Keys
`id`	Unknown	PK
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`short_name`	Unknown

employee_prgl_split_matric_code

Column	Type	Keys
`id`	Unknown	PK
`employee_gl_split_fivetran_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`employee_prgl_split_index`	Unknown	PKFK
`clock_transfer_code`	Unknown
`labor_metrics_type_clock_transfer_code`	Unknown
`labor_metrics_type_id`	Unknown
`labor_metrics_type_last_modified_timestamp`	Unknown
`labor_metrics_type_ledger_code`	Unknown
`labor_metrics_type_long_name`	Unknown
`labor_metrics_type_short_name`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`short_name`	Unknown

employee_prgl_split

Column	Type	Keys
`index`	Unknown	PK
`employee_gl_split_fivetran_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`is_primary`	Unknown
`labor_percentage`	Unknown
`last_modified_timestamp`	Unknown

employee_gl_split

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`job_assignment_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown

pay_group_calendar_calendar

Column	Type	Keys
`_fivetran_id`	String	PK
`pay_group_calendar_id`	Unknown	FK
`approve_by_date`	Unknown
`approved`	Unknown
`approved_by`	Unknown
`approved_date`	Unknown
`arrears_end`	Unknown
`arrears_start`	Unknown
`auto_lock_date`	Unknown
`checklist_closed`	Unknown
`checklist_closed_by`	Unknown
`checklist_closed_date`	Unknown
`closed`	Unknown
`closed_by`	Unknown
`closed_date`	Unknown
`commit_by_date`	Unknown
`contract_pay_date`	Unknown
`data_gate_close`	Unknown
`data_gate_open`	Unknown
`future_punches_enabled`	Unknown
`gl_accrual_percent`	Unknown
`impound_by`	Unknown
`ledger_code_1`	Unknown
`ledger_code_2`	Unknown
`lock_date`	Unknown
`locked`	Unknown
`locked_by`	Unknown
`offset_pay_period_end_date`	Unknown
`offset_pay_period_start_date`	Unknown
`pay_date`	Unknown
`pay_period`	Unknown
`pay_period_suffix`	Unknown
`payroll_committed`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`supervisor_date`	Unknown
`time_collection_end_date`	Unknown
`time_collection_start_date`	Unknown
`transmit_by_date`	Unknown
`transmitted`	Unknown
`transmitted_by`	Unknown
`transmitted_date`	Unknown

pay_group_calendar

Column	Type	Keys
`id`	Unknown	PK
`collection_frequency`	Unknown
`country`	Unknown
`day_start_of_week`	Unknown
`frequency`	Unknown
`pay_group_id`	Unknown
`pay_group_name`	Unknown
`payroll_frequency`	Unknown

employee_balance

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`balance_name`	Unknown
`current_accrued_value`	Unknown
`current_grant_value`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`initial_accrued_value`	Unknown
`initial_grant_value`	Unknown
`maximum_value`	Unknown
`minimum_value`	Unknown

employee_pay_adjustment_labor_metric

Column	Type	Keys
`labor_metrics_code_id`	Unknown	PK
`labor_metrics_type_id`	Unknown	PK
`employee_pay_adjustment_id`	Unknown	PKFK

employee_pay_adjustment

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`employee_id`	Unknown	FK
`job_id`	Unknown	FK
`organization_unit_id`	Unknown	FK
`project_id`	Unknown	FK
`adjust_period_end_date`	Unknown
`adjust_period_start_date`	Unknown
`amount`	Unknown
`docket_id`	Unknown
`employee_authorized`	Unknown
`employee_comment`	Unknown
`hour`	Unknown
`is_deleted`	Unknown
`is_premium`	Unknown
`last_modified_timestamp_utc`	Unknown
`manager_authorized`	Unknown
`manager_comment`	Unknown
`pay_adjustment_code`	Unknown
`pay_category_id`	Unknown
`pay_date`	Unknown
`piece_quantity`	Unknown
`rate`	Unknown
`reference_date`	Unknown
`time_end`	Unknown
`time_start`	Unknown

pay_class

Column	Type	Keys
`id`	Unknown	PK
`default_normal_weekly_hours`	Unknown
`last_modified_timestamp`	Unknown
`ledger_code`	Unknown
`long_name`	Unknown
`pay_class_frequency_id`	Unknown
`pay_class_frequency_last_modified_timestamp`	Unknown
`pay_class_frequency_long_name`	Unknown
`pay_class_frequency_short_name`	Unknown
`pay_class_group_id`	Unknown
`pay_class_group_last_modified_timestamp`	Unknown
`pay_class_group_long_name`	Unknown
`pay_class_group_short_name`	Unknown
`short_name`	Unknown
`sort_order`	Unknown

employee_pay_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`department_id`	Unknown	FK
`employee_id`	Unknown	FK
`job_id`	Unknown	FK
`position_id`	Unknown	FK
`project_id`	Unknown	FK
`business_date`	Unknown
`docket_id`	Unknown
`is_premium`	Unknown
`labor_metrics_code_0`	Unknown
`labor_metrics_code_1`	Unknown
`labor_metrics_code_2`	Unknown
`labor_metrics_code_3`	Unknown
`labor_metrics_code_4`	Unknown
`labor_metrics_code_5`	Unknown
`labor_metrics_code_6`	Unknown
`labor_metrics_code_7`	Unknown
`labor_metrics_code_8`	Unknown
`labor_metrics_code_9`	Unknown
`location_id`	Unknown
`minute_duration`	Unknown
`net_hour`	Unknown
`pay_amount`	Unknown
`pay_category_id`	Unknown
`pay_code_id`	Unknown
`pay_date`	Unknown
`pay_export_id`	Unknown
`piece_quantity`	Unknown
`punch_segment_start`	Unknown
`rate`	Unknown
`time_end`	Unknown
`time_start`	Unknown

aus_superannuation

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_id`	Unknown	FK
`category_id`	Unknown
`category_last_modified_timestamp`	Unknown
`category_long_name`	Unknown
`category_short_name`	Unknown
`contribution_calc_value`	Unknown
`contribution_calculation_type_id`	Unknown
`contribution_calculation_type_last_modified_timestamp`	Unknown
`contribution_calculation_type_long_name`	Unknown
`contribution_calculation_type_short_name`	Unknown
`contribution_type_id`	Unknown
`contribution_type_last_modified_timestamp`	Unknown
`contribution_type_long_name`	Unknown
`contribution_type_short_name`	Unknown
`effective_end`	Unknown
`effective_start`	Unknown
`last_modified_timestamp`	Unknown
`membership_number`	Unknown
`payment_method_id`	Unknown
`payment_method_last_modified_timestamp`	Unknown
`payment_method_long_name`	Unknown
`payment_method_short_name`	Unknown
`payroll_deduction_id`	Unknown
`payroll_deduction_last_modified_timestamp`	Unknown
`payroll_deduction_long_name`	Unknown
`payroll_deduction_short_name`	Unknown
`payroll_payee_abn`	Unknown
`payroll_payee_account_number`	Unknown
`payroll_payee_address_line_1`	Unknown
`payroll_payee_address_line_2`	Unknown
`payroll_payee_address_line_3`	Unknown
`payroll_payee_allow_negative_amounts`	Unknown
`payroll_payee_bsb_code`	Unknown
`payroll_payee_city`	Unknown
`payroll_payee_combine_earningsand_deductions`	Unknown
`payroll_payee_combine_employees`	Unknown
`payroll_payee_country_code`	Unknown
`payroll_payee_esa`	Unknown
`payroll_payee_id`	Unknown
`payroll_payee_is_active`	Unknown
`payroll_payee_is_deduction_payee`	Unknown
`payroll_payee_last_modified_timestamp`	Unknown
`payroll_payee_long_name`	Unknown
`payroll_payee_postal_code`	Unknown
`payroll_payee_short_name`	Unknown
`payroll_payee_show_employee_details`	Unknown
`payroll_payee_state`	Unknown
`payroll_payee_usi`	Unknown
`type_id`	Unknown
`type_last_modified_timestamp`	Unknown
`type_long_name`	Unknown
`type_short_name`	Unknown

employee_raw_punch_labor_metric

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_raw_punch_id`	Unknown	FK
`clock_transfer_code`	Unknown
`code_id`	Unknown
`type_clock_transfer_code`	Unknown
`type_id`	Unknown

employee_raw_punch

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`employee_id`	Unknown	FK
`extra_data_position_id`	Unknown	FK
`extra_data_project_id`	Unknown	FK
`job_id`	Unknown	FK
`position_id`	Unknown	FK
`accuracy`	Unknown
`comment`	Unknown
`extra_data_bio_failure`	Unknown
`extra_data_break_attestation`	Unknown
`extra_data_docket_clock_transfer_code`	Unknown
`extra_data_docket_id`	Unknown
`extra_data_face_verification_failure`	Unknown
`extra_data_location_clock_transfer_code`	Unknown
`extra_data_location_id`	Unknown
`extra_data_meal_waiver`	Unknown
`extra_data_position_clock_transfer_code`	Unknown
`extra_data_project_clock_transfer_code`	Unknown
`extra_data_quantity`	Unknown
`ip_address`	Unknown
`is_duplicate`	Unknown
`latitude`	Unknown
`location_id`	Unknown
`longitude`	Unknown
`pay_date`	Unknown
`punch_device`	Unknown
`punch_id`	Unknown
`punch_origin`	Unknown
`punch_state`	Unknown
`punch_type`	Unknown
`raw_punch_time`	Unknown
`rejected_reason`	Unknown
`supervisor_badge`	Unknown
`was_offline_punch`	Unknown

employee_punch_meal_break

Column	Type	Keys
`index`	Unknown	PK
`employee_punch_id`	Unknown	PKFK
`end_exception_code`	Unknown
`is_auto_injected`	Unknown
`last_modified_timestamp_utc`	Unknown
`net_hour`	Unknown
`start_exception_code`	Unknown
`time_end`	Unknown
`time_end_raw`	Unknown
`time_start`	Unknown
`time_start_raw`	Unknown
`type`	Unknown

employee_punch_transfer

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_punch_id`	Unknown	FK
`pay_adjustment_id`	Unknown	FK
`position_id`	Unknown	FK
`project_id`	Unknown	FK
`docket_id`	Unknown
`docket_quantity`	Unknown
`employee_comment`	Unknown
`location_id`	Unknown
`manager_comment`	Unknown
`time_start`	Unknown
`time_start_raw`	Unknown

employee_punch_labor_metric

Column	Type	Keys
`_fivetran_id`	String	PK
`employee_punch_id`	Unknown	FK
`labor_metrics_code_id`	Unknown
`labor_metrics_type_id`	Unknown

employee_punch

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`employee_id`	Unknown	FK
`job_id`	Unknown	FK
`pay_adjustment_id`	Unknown	FK
`position_id`	Unknown	FK
`project_id`	Unknown	FK
`assumed_time_end`	Unknown
`assumed_time_start`	Unknown
`business_date`	Unknown
`docket_id`	Unknown
`docket_quantity`	Unknown
`employee_comment`	Unknown
`end_exception_code`	Unknown
`future_punch`	Unknown
`is_deleted`	Unknown
`is_on_call`	Unknown
`last_modified_timestamp_utc`	Unknown
`location_id`	Unknown
`manager_comment`	Unknown
`net_hour`	Unknown
`punch_status`	Unknown
`start_exception_code`	Unknown
`time_end`	Unknown
`time_end_raw`	Unknown
`time_start`	Unknown
`time_start_raw`	Unknown