# Ceridian Dayforce schema ERD

Table and field reference for the Fivetran Ceridian Dayforce connector.

## Table & Field Reference

### report_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| custom_** |  |  |

### work_location_override

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| work_location_id | Unknown | PK, FK |
| 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 | PK, FK |
| payee_operating_country_code | Unknown | PK, FK |
| 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 | PK, FK |
| payee_operating_country_code | Unknown | PK, FK |
| 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 | PK, FK |

### employee_employment_information

| Column | Type | Keys |
| --- | --- | --- |
| employee_employment_status_id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_unit_id | Unknown | PK, FK |
| 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 | PK, FK |
| organization_unit_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_unit_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_end | Unknown |  |
| time_start | Unknown |  |

### employee_schedule_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_schedule_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_schedule_segment_index | Unknown | PK, FK |
| code_id | Unknown |  |
| type_id | Unknown |  |

### employee_schedule_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_schedule_id | Unknown | PK, FK |
| 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 | PK, FK |
| project_id | Unknown | PK, FK |

### child_project

| Column | Type | Keys |
| --- | --- | --- |
| child_project_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### project_employee

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### project_department_job

| Column | Type | Keys |
| --- | --- | --- |
| department_job_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### project_department

| Column | Type | Keys |
| --- | --- | --- |
| department_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### project_pay_charge_to_hour

| Column | Type | Keys |
| --- | --- | --- |
| pay_charge_to_hour | Unknown | PK |
| project_id | Unknown | PK, FK |

### project_pay_charge_to_amount

| Column | Type | Keys |
| --- | --- | --- |
| pay_charge_to_amount | Unknown | PK |
| project_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| last_modified_timestamp | Unknown |  |
| login_name | Unknown |  |

### employee_marital_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_id | Unknown | PK, FK |
| effective_end | Unknown |  |
| effective_start | Unknown |  |

### report_metadata_column

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_metadata_report_id | Unknown | PK, FK |
| code_name | Unknown |  |
| data_type | Unknown |  |
| display_name | Unknown |  |

### report_metadata_parameter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_metadata_report_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_id | Unknown | PK, FK |
| employee_prgl_split_index | Unknown | PK, FK |
| 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 | PK, FK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 |  |

## Relationships

- report_data(report_id) → report_metadata(report_id)
- work_location_override(work_location_id) → work_location(id)
- work_location(location_address_id) → location_address(id)
- payee_parameter(payee_operating_country_code) → payee(operating_country_code)
- payee_parameter(payee_name) → payee(name)
- payee_state_coverage(payee_operating_country_code) → payee(operating_country_code)
- payee_state_coverage(payee_name) → payee(name)
- earning_statement_header(employee_id) → employee(id)
- employee_employment_information(pay_type_id) → pay_type(id)
- employee_employment_information(pay_class_id) → pay_class(id)
- employee_employment_information(employment_status_id) → employment_status(id)
- employee_employment_information(employment_status_reason_id) → employment_status_reason(id)
- employee_employment_information(pay_group_id) → employee_employment_information(pay_group_id)
- employee_employment_information(employee_id) → employee(id)
- employee_time_away_from_work(employee_id) → employee(id)
- organization_unit_legal_entity_item(organization_unit_id) → organization_unit(id)
- organization_unit_parent_item(organization_unit_id) → organization_unit(id)
- organization_unit_child_legal_entity_item(organization_unit_id) → organization_unit_child(organization_unit_id)
- organization_unit_child_legal_entity_item(organization_unit_child_id) → organization_unit_child(id)
- organization_unit_child_parent_item(organization_unit_id) → organization_unit_child(organization_unit_id)
- organization_unit_child_parent_item(organization_unit_child_id) → organization_unit_child(id)
- organization_unit_child_location_type_item(organization_unit_id) → organization_unit_child(organization_unit_id)
- organization_unit_child_location_type_item(organization_unit_child_id) → organization_unit_child(id)
- organization_unit_child(organization_unit_id) → organization_unit(id)
- organization_unit_location_type_item(organization_unit_id) → organization_unit(id)
- organization_unit(department_id) → department(id)
- job_position_assignment(organization_unit_id) → organization_unit(id)
- job_position_assignment(job_assignment_id) → job_assignment(id)
- job_assignment(pay_type_id) → pay_type(id)
- job_assignment(department_id) → department(id)
- job_assignment(pay_class_id) → pay_class(id)
- job_assignment(job_id) → job(id)
- job_assignment(pay_group_id) → employee_employment_information(pay_group_id)
- confidential_identification(employee_id) → employee(id)
- availability(employee_id) → employee(id)
- work_assignment_manager(manager_id) → employee_manager(id)
- work_assignment_manager(organization_unit_id) → organization_unit(id)
- work_assignment_manager(job_assignment_id) → job_assignment(id)
- work_assignment_manager(employee_id) → employee(id)
- work_assignment(work_location_override_id) → work_location_override(id)
- work_assignment(organization_unit_id) → organization_unit(id)
- work_assignment(job_assignment_id) → job_assignment(id)
- work_assignment(employment_status_reason_id) → employment_status_reason(id)
- work_assignment(employee_id) → employee(id)
- employee_schedule_break(employee_schedule_id) → employee_schedule(id)
- employee_schedule_activity(employee_schedule_id) → employee_schedule(id)
- employee_schedule_skill(employee_schedule_id) → employee_schedule(id)
- employee_schedule_labor_metric(employee_schedule_id) → employee_schedule(id)
- employee_schedule_segment_labor_metric(employee_schedule_id) → employee_schedule_segment(employee_schedule_id)
- employee_schedule_segment_labor_metric(employee_schedule_segment_index) → employee_schedule_segment(index)
- employee_schedule_segment(position_id) → job_assignment(id)
- employee_schedule_segment(department_id) → department(id)
- employee_schedule_segment(pay_adjustment_code) → employee_pay_adjustment(pay_adjustment_code)
- employee_schedule_segment(organization_unit_id) → organization_unit(id)
- employee_schedule_segment(job_id) → job(id)
- employee_schedule_segment(project_id) → project(id)
- employee_schedule_segment(employee_schedule_id) → employee_schedule(id)
- employee_schedule(position_id) → job_assignment(id)
- employee_schedule(department_id) → department(id)
- employee_schedule(site_organisation_unit_id) → organization_unit(id)
- employee_schedule(pay_adjustment_code) → employee_pay_adjustment(pay_adjustment_code)
- employee_schedule(organization_unit_id) → organization_unit(id)
- employee_schedule(job_id) → job(id)
- employee_schedule(employee_id) → employee(id)
- employee_schedule(project_id) → project(id)
- project_creation_organization_unit(creation_organization_unit_id) → organization_unit(id)
- project_creation_organization_unit(project_id) → project(id)
- child_project(child_project_id) → project(id)
- child_project(project_id) → project(id)
- project_employee(employee_id) → employee(id)
- project_employee(project_id) → project(id)
- project_department_job(department_job_id) → job(id)
- project_department_job(project_id) → project(id)
- project_department(department_id) → department(id)
- project_department(project_id) → project(id)
- project_pay_charge_to_hour(project_id) → project(id)
- project_pay_charge_to_amount(project_id) → project(id)
- project(parent_project_id) → project(id)
- employee_contact(employee_id) → employee(id)
- employee_address(employee_id) → employee(id)
- employee_role(employee_id) → employee(id)
- employee_sso_account(employee_id) → employee(id)
- employee_marital_status(employee_id) → employee(id)
- employee_religion(employee_id) → employee(id)
- employee_health_wellness_detail(employee_id) → employee(id)
- employee_property(employee_id) → employee(id)
- employee_volunteer_list(employee_id) → employee(id)
- employee(department_id) → department(id)
- employee(home_organization_id) → employee_organization(id)
- employee_balance_transaction_transaction(employee_balance_transaction_id) → employee_balance_transaction(id)
- employee_balance_transaction_transaction(employee_id) → employee_balance_transaction(employee_id)
- employee_balance_transaction_transaction(employee_balance_id) → employee_balance_transaction(id)
- employee_balance_transaction(employee_id) → employee(id)
- employee_balance_transaction(employee_balance_id) → employee_balance(id)
- report_metadata_column(report_metadata_report_id) → report_metadata(report_id)
- report_metadata_parameter(report_metadata_report_id) → report_metadata(report_id)
- compensation_summary(pay_type_id) → pay_type(id)
- compensation_summary(pay_class_id) → pay_class(id)
- compensation_summary(employment_status_reason_id) → employment_status_reason(id)
- compensation_summary(employee_id) → employee(id)
- employee_manager(id) → employee(id)
- employee_manager(employee_id) → employee(id)
- employee_organization(department_id) → department(id)
- employee_organization(organization_unit_parent_id) → organization_unit(id)
- employee_organization(employee_id) → employee(id)
- employment_type(employee_id) → employee(id)
- highly_compensated_employee(employee_id) → employee(id)
- analyst_report_data_column(analyst_report_fivetran_id) → analyst_report(_fivetran_id)
- analyst_report_data_filter(analyst_report_fivetran_id) → analyst_report(_fivetran_id)
- employee_prgl_split_matric_code(employee_gl_split_fivetran_id) → employee_prgl_split(employee_gl_split_fivetran_id)
- employee_prgl_split_matric_code(employee_id) → employee_prgl_split(employee_id)
- employee_prgl_split_matric_code(employee_prgl_split_index) → employee_prgl_split(index)
- employee_prgl_split(employee_gl_split_fivetran_id) → employee_gl_split(_fivetran_id)
- employee_prgl_split(employee_id) → employee_gl_split(employee_id)
- employee_gl_split(organization_unit_id) → organization_unit(id)
- employee_gl_split(job_assignment_id) → job_assignment(id)
- employee_gl_split(employee_id) → employee(id)
- pay_group_calendar_calendar(pay_group_calendar_id) → pay_group_calendar(id)
- employee_balance(employee_id) → employee(id)
- employee_pay_adjustment_labor_metric(employee_pay_adjustment_id) → employee_pay_adjustment(id)
- employee_pay_adjustment(department_id) → department(id)
- employee_pay_adjustment(organization_unit_id) → organization_unit(id)
- employee_pay_adjustment(job_id) → job(id)
- employee_pay_adjustment(employee_id) → employee(id)
- employee_pay_adjustment(project_id) → project(id)
- employee_pay_summary(position_id) → job_assignment(id)
- employee_pay_summary(department_id) → department(id)
- employee_pay_summary(job_id) → job(id)
- employee_pay_summary(employee_id) → employee(id)
- employee_pay_summary(project_id) → project(id)
- aus_superannuation(employee_id) → employee(id)
- employee_raw_punch_labor_metric(employee_raw_punch_id) → employee_raw_punch(id)
- employee_raw_punch(position_id) → job_assignment(id)
- employee_raw_punch(department_id) → department(id)
- employee_raw_punch(job_id) → job(id)
- employee_raw_punch(employee_id) → employee(id)
- employee_raw_punch(extra_data_position_id) → job_assignment(id)
- employee_raw_punch(extra_data_project_id) → project(id)
- employee_punch_meal_break(employee_punch_id) → employee_punch(id)
- employee_punch_transfer(position_id) → job_assignment(id)
- employee_punch_transfer(project_id) → project(id)
- employee_punch_transfer(pay_adjustment_id) → employee_pay_adjustment(id)
- employee_punch_transfer(employee_punch_id) → employee_punch(id)
- employee_punch_labor_metric(employee_punch_id) → employee_punch(id)
- employee_punch(position_id) → job_assignment(id)
- employee_punch(department_id) → department(id)
- employee_punch(job_id) → job(id)
- employee_punch(employee_id) → employee(id)
- employee_punch(project_id) → project(id)
- employee_punch(pay_adjustment_id) → employee_pay_adjustment(id)