# Workday HCM schema ERD

Table and field reference for the Fivetran Workday HCM connector.

## Table & Field Reference

### worker_collective_agreement

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| effective_date | LocalDate |  |
| employee_collective_agreement_event_code | String |  |
| employee_collective_agreement_event_id | String |  |
| end_assignment_date | LocalDate |  |

### learning_course_offering_data

| Column | Type | Keys |
| --- | --- | --- |
| course_id | String | PK |
| learning_course_offering_id | String | PK, FK |
| course | String |  |
| course_code | String |  |

### worker_commission_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| commission_plan_code | String |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| draw_amount | Double |  |
| draw_duration | String |  |
| draw_frequency_code | String |  |
| frequency_code | String |  |
| recoverable | Boolean |  |
| target_amount | Double |  |

### goal_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| net_attainment | Double |  |

### project_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| project_code | String |  |

### payroll_line_pay_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| payroll_id | String | PK, FK |
| payroll_line_index | Long | PK, FK |
| deduction | String |  |
| earning | String |  |

### pre_hire_resume

| Column | Type | Keys |
| --- | --- | --- |
| resume_id | String | PK |
| pre_hire_id | String | PK, FK |
| comments | String |  |
| file_code | String |  |
| file_name | String |  |

### compensation_allowance_plan_percent_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| ceiling_amount | Double |  |
| ceiling_currency | String |  |
| compensation_basis | String |  |
| percent | Double |  |

### review_question_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| in_use | Int |  |
| name | String |  |
| question_category_code | String |  |

### compensation_matrix_amount

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_matrix_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| compa_ratio_range | String |  |
| currency | String |  |
| frequency | String |  |
| max_amount | Double |  |
| min_amount | Double |  |
| pay_range | String |  |
| performance_evaluation | String |  |
| potential | String |  |
| quartile | String |  |
| retention | String |  |

### additional_manager_accomplishment_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### person_contact_web_address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_info_system_id | String | PK, FK |
| web_address | String |  |
| web_address_code | String |  |
| web_address_comment | String |  |

### employee_contract_detail

| Column | Type | Keys |
| --- | --- | --- |
| employee_contract_code | String | PK |
| worker_id | String | PK, FK |
| position_id | String | FK |
| collective_agreement_code | String |  |
| contract_code | String |  |
| contract_description | String |  |
| contract_end_date | LocalDate |  |
| contract_reasons | Json |  |
| contract_review_date | LocalDate |  |
| contract_start_date | LocalDate |  |
| contract_status_code | String |  |
| contract_type_code | String |  |
| date_employee_signed | LocalDate |  |
| date_employer_signed | LocalDate |  |
| effective_date | LocalDate |  |
| maximum_weekly_hours | Double |  |
| minimum_weekly_hours | Double |  |
| worker_documen_reference_list | Json |  |

### qualification_training

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| training_code | String | PK |
| worker_id | String | PK, FK |
| completion_date | LocalDate |  |
| description | String |  |
| remove_training | Boolean |  |
| training | String |  |
| training_duration | String |  |
| training_type_code | String |  |

### job_requisition_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| qualification_source | String |  |
| required | Boolean |  |
| work_experience_code | String |  |
| work_experience_rating | String |  |

### position_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supervisory_organization_id | String | FK |
| worker_for_filled_position_id | String | FK |
| academic_tenure_eligible | Boolean |  |
| availability_date | LocalDate |  |
| available_for_hire | Boolean |  |
| available_for_overlap | Boolean |  |
| available_for_recruiting | Boolean |  |
| closed | Boolean |  |
| compensation_grade_code | String |  |
| compensation_grade_profile_code | String |  |
| compensation_package_code | String |  |
| compensation_step_code | String |  |
| critical_job | Boolean |  |
| difficulty_to_fill_code | String |  |
| earliest_hire_date | LocalDate |  |
| earliest_overlap_date | LocalDate |  |
| effective_date | LocalDate |  |
| hiring_freeze | Boolean |  |
| job_description | String |  |
| job_description_summary | String |  |
| job_posting_title | String |  |
| position_code | String |  |
| position_time_type_code | String |  |
| primary_compensation_basis | Double |  |
| primary_compensation_basis_amount_change | Double |  |
| primary_compensation_basis_percent_change | Double |  |
| work_shift_required | Boolean |  |
| worker_position_id | String |  |
| worker_type_code | String |  |

### position_period_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| period_salary_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| compensation_basis_override_amount | Double |  |
| compensation_period_code | String |  |
| compensation_period_multiplier | Double |  |
| currency_code | String |  |
| frequency_code | String |  |
| period_salary_plan_code | String |  |

### job_requisition_additional_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| job_profile_id | String | PK, FK |
| job_requisition_id | String | PK, FK |

### multiple_choice_answer

| Column | Type | Keys |
| --- | --- | --- |
| question_multiple_choice_answer_id | String | PK |
| questionnaire_answer_id | Long | PK, FK |
| reference_id | String | PK, FK |
| multiple_choice_answer_text | String |  |
| question_multiple_choice_answer_code | String |  |

### qualification_professional_affiliation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| professional_affiliation_skill_id | String | PK |
| worker_id | String | PK, FK |
| affiliation | String |  |
| end_date | LocalDate |  |
| professional_affiliation | String |  |
| professional_affiliation_relationship_type_code | String |  |
| professional_affiliation_type_code | String |  |
| remove_professional_affiliation | Boolean |  |
| start_date | LocalDate |  |

### person_identity_document

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| personal_info_system_id | String | PK, FK |
| authority | String |  |
| country | String |  |
| country_region | String |  |
| country_region_code | String |  |
| custom_description | String |  |
| document_id | String |  |
| expiration_date | LocalDate |  |
| id_type | String |  |
| issued_date | LocalDate |  |
| issuing_agency | String |  |
| license_class | String |  |
| series | String |  |
| verification_date | LocalDate |  |
| verified_by_worker | String |  |

### additional_manager_feedback_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### pre_hire_job_history

| Column | Type | Keys |
| --- | --- | --- |
| job_hire_id | String | PK |
| pre_hire_id | String | PK, FK |
| company | String |  |
| contact | String |  |
| end_date | LocalDate |  |
| job_exempt | Boolean |  |
| job_history_code | String |  |
| job_reference | String |  |
| job_title | String |  |
| location | String |  |
| responsibilities_and_achievements | String |  |
| start_date | LocalDate |  |

### organization_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| job_profile_id | String | PK, FK |
| organization_id | String | PK, FK |
| job_category_reference_id | String | FK |

### job_family_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| job_family_id | String | PK, FK |
| value | String |  |

### benchmark_amount_replacement

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| benchmark_composite_category_id | String | PK, FK |
| amount | Double |  |
| benchmark_percentile | String |  |

### qualification_internal_project_experience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| internal_project_experience_code | String | PK |
| worker_id | String | PK, FK |
| description | String |  |
| end_date | LocalDate |  |
| internal_project | String |  |
| project_leader | String |  |
| remove_internal_project_experience | Boolean |  |
| start_date | LocalDate |  |

### job_requisition_position

| Column | Type | Keys |
| --- | --- | --- |
| job_requisition_id | String | PK, FK |
| position_id | String | PK, FK |

### learning_course_sales_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| code | String |  |

### job_requisition_unit_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| unit_allowance_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| number_of_units | Double |  |
| per_unit_amount | Double |  |
| reimbursement_start_date | LocalDate |  |
| unit_allowance_plan_code | String |  |

### additional_manager_competency_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### responsibility_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |
| responsibility | String |  |
| weight | Double |  |

### accomplishment_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### compensation_bonus_plan_coverage_date_eligibility_rule

| Column | Type | Keys |
| --- | --- | --- |
| compensation_eligibility_rule_id | String | PK, FK |
| compensation_plan_id | String | PK, FK |

### question_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |
| weight | Double |  |

### position_document_field_result

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| position_id | String | PK, FK |
| value | String |  |

### job_requisition_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| job_requisition_id | String | PK, FK |
| value | String |  |

### organization_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| manager_id | String | FK |
| organization_owner_id | String | FK |
| superior_organization_id | String | FK |
| top_level_organization_id | String | FK |
| availability_date | Instant |  |
| available_for_hire | Boolean |  |
| code | String |  |
| description | String |  |
| external_url | String |  |
| hiring_freeze | Boolean |  |
| inactive | Boolean |  |
| inactive_date | LocalDate |  |
| include_manager_in_name | Boolean |  |
| include_organization_code_in_name | Boolean |  |
| last_updated_date_time | Instant |  |
| location | String |  |
| name | String |  |
| organization_code | String |  |
| staffing_model | String |  |
| sub_type | String |  |
| supervisory_position_availability_date | LocalDate |  |
| supervisory_position_earliest_hire_date | LocalDate |  |
| supervisory_position_time_type | String |  |
| supervisory_position_worker_type | String |  |
| type | String |  |
| visibility | String |  |

### relative_name

| Column | Type | Keys |
| --- | --- | --- |
| relative_name_reference_id | String | PK |
| country_personal_information_id | String | PK, FK |
| academic_suffix_code | String |  |
| country_code | String |  |
| first_name | String |  |
| full_name_for_singapore_and_malaysia | String |  |
| hereditary_suffix_code | String |  |
| honorary_suffix_code | String |  |
| last_name | String |  |
| local_first_name | String |  |
| local_first_name_2 | String |  |
| local_last_name | String |  |
| local_last_name_2 | String |  |
| local_middle_name | String |  |
| local_middle_name_2 | String |  |
| local_secondary_last_name | String |  |
| local_secondary_last_name_2 | String |  |
| middle_name | String |  |
| prefix_salutation_code | String |  |
| prefix_title_code | String |  |
| prefix_title_descriptor | String |  |
| professional_suffix_code | String |  |
| relative_name_reference_code | String |  |
| relative_type_code | String |  |
| religious_suffix_code | String |  |
| royal_suffix_code | String |  |
| secondary_last_name | String |  |
| social_suffix_code | String |  |
| social_suffix_descriptor | String |  |
| tertiary_last_name | String |  |

### job_requisition_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| certification_code | String |  |
| country | String |  |
| issuer | String |  |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### organization_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | String | PK |
| organization_id | String | PK, FK |
| organization_role_code | String |  |

### goal_milestone_detail

| Column | Type | Keys |
| --- | --- | --- |
| goal_reference_code | String | PK |
| component_index | Long | PK, FK |
| review_id | String | PK, FK |
| due_date | LocalDate |  |
| goal_milestone_completion_code | String |  |
| goal_milestone_name | String |  |

### candidate_national_id

| Column | Type | Keys |
| --- | --- | --- |
| national_id | String | PK |
| candidate_id | String | PK, FK |
| verified_by_worker_id | String | FK |
| country | String |  |
| expiration_date | LocalDate |  |
| issued_date | LocalDate |  |
| issuing_agency | String |  |
| national_code | String |  |
| national_id_shared_code | String |  |
| national_id_type_code | String |  |
| series | String |  |
| verification_date | LocalDate |  |

### job_requisition_certification_specialty

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_certification_id | String | PK, FK |
| specialty | String |  |
| sub_specialty | Json |  |

### position_organization_history

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| organization_id | String | PK, FK |
| position_id | String | PK, FK |

### worker_position_job_classification

| Column | Type | Keys |
| --- | --- | --- |
| job_classification_id | String | PK, FK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| job_group_code | String |  |

### compensation_allowance_plan_unit_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| currency | String |  |
| default_units | Double |  |
| per_unit_amount | Double |  |

### organization_role_worker_history

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | String | PK, FK |
| role_id | String | PK, FK |
| worker_id | String | PK, FK |

### worker_unit_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| default_units | Double |  |
| frequency_code | String |  |
| unit_salary_plan_code | String |  |
| units | Double |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_info_system_id | String | PK, FK |
| position_id | String | PK, FK |
| address_code | String |  |
| city | String |  |
| country | String |  |
| country_alpha_2_code | String |  |
| country_region | String |  |
| country_region_code | String |  |
| effective_date | LocalDate |  |
| last_modified | Instant |  |
| municipality | String |  |
| municipality_local | String |  |
| number_of_days | Double |  |
| postal_code | String |  |
| type | String |  |

### personal_information

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| id | String | PK, FK |
| tobacco_use | Boolean |  |

### job_requisition_additional_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| job_requisition_id | String | PK, FK |
| location_code | String |  |

### pre_hire_positions_considered

| Column | Type | Keys |
| --- | --- | --- |
| position_id | String | PK |
| pre_hire_id | String | PK, FK |
| position_code | String |  |

### compensation_bonus_tranche

| Column | Type | Keys |
| --- | --- | --- |
| name | Double | PK |
| compensation_plan_id | String | PK, FK |
| percentage | Double |  |

### compensation_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| bonus_plan_performance_factor_compensation_matrix_id | String | FK |
| bonus_plan_performance_matrix_compensation_matrix_id | String | FK |
| merit_plan_compensation_matrix_id | String | FK |
| stock_plan_compensation_matrix_id | String | FK |
| allowance_plan_amount | Double |  |
| allowance_plan_apply_full_time_equivalent | Boolean |  |
| allowance_plan_calculation_compensation | String |  |
| allowance_plan_compensation_basis | String |  |
| allowance_plan_currency | String |  |
| allowance_plan_default_units | Double |  |
| allowance_plan_element | String |  |
| allowance_plan_exclude_from_merit | Boolean |  |
| allowance_plan_frequency | String |  |
| allowance_plan_no_individual_override | Boolean |  |
| allowance_plan_per_unit_amount | Double |  |
| allowance_plan_percent_ceiling_amount | Double |  |
| allowance_plan_percent_ceiling_currency | String |  |
| allowance_plan_percentage | Double |  |
| allowance_plan_reimbursement_expense_accumulator | String |  |
| allowance_plan_reimbursement_expense_item | String |  |
| allowance_plan_unit_of_measure | String |  |
| base_plan_currency | String |  |
| base_plan_element | String |  |
| base_plan_exclude_from_merit | Boolean |  |
| base_plan_frequency | String |  |
| base_plan_hourly_amount | Double |  |
| base_plan_hourly_minimum_wage | Boolean |  |
| base_plan_salary_apply_full_time_equivalent | Boolean |  |
| base_plan_unit_salary_default_units | Double |  |
| base_plan_unit_salary_no_individual_override | Boolean |  |
| base_plan_unit_salary_per_unit_amount | Double |  |
| base_plan_unit_salary_unit_of_measure | String |  |
| bonus_plan_allow_individual_targets | Boolean |  |
| bonus_plan_amount | Double |  |
| bonus_plan_apply_full_time_equivalent | Boolean |  |
| bonus_plan_calculation_compensation | String |  |
| bonus_plan_compensation_basis | String |  |
| bonus_plan_currency | String |  |
| bonus_plan_deferred_compensation_calculation | String |  |
| bonus_plan_deferred_compensation_stock_plan | String |  |
| bonus_plan_element | String |  |
| bonus_plan_frequency | String |  |
| bonus_plan_include_active_employees_assigned | Boolean |  |
| bonus_plan_include_active_employees_in_waiting_period | Boolean |  |
| bonus_plan_percentage | Double |  |
| bonus_plan_performance_factor_apply_net_attainment | Boolean |  |
| bonus_plan_performance_factor_bonus_modifier | String |  |
| bonus_plan_performance_factor_weight | Double |  |
| bonus_plan_performance_matrix_apply_net_attainment | Boolean |  |
| bonus_plan_performance_matrix_bonus_modifier | String |  |
| bonus_plan_performance_matrix_use_matrix_as_reference_only | Boolean |  |
| bonus_plan_performance_scorecard | String |  |
| bonus_plan_rounding_rule | String |  |
| bonus_plan_time_proration | String |  |
| bonus_plan_waiting_period | String |  |
| calculated_plan_calculation | String |  |
| calculated_plan_currency | String |  |
| calculated_plan_element | String |  |
| calculated_plan_exclude_from_total_salary_and_allowance_compensation | Boolean |  |
| calculated_plan_frequency | String |  |
| calculated_plan_is_dynamic_calculated_plan | Boolean |  |
| calculated_plan_is_event_driven_calculated_plan | Boolean |  |
| commission_plan_currency | String |  |
| commission_plan_draw_amount | Double |  |
| commission_plan_draw_duration | String |  |
| commission_plan_draw_frequency | String |  |
| commission_plan_element | String |  |
| commission_plan_frequency | String |  |
| commission_plan_recoverable | Boolean |  |
| commission_plan_target_amount | Double |  |
| compensation_plan_code | String |  |
| description | String |  |
| effective_date | LocalDate |  |
| future_payment_plan_allow_individual_targets | Boolean |  |
| future_payment_plan_amount | Double |  |
| future_payment_plan_currency | String |  |
| future_payment_plan_element | String |  |
| future_payment_plan_frequency | String |  |
| future_payment_plan_include_all_bonus_compensation_plan | Boolean |  |
| future_payment_plan_include_one_time_payment_compensation_plan | Boolean |  |
| inactive | Boolean |  |
| merit_plan_allow_individual_targets | Boolean |  |
| merit_plan_amount_calculation_compensation | String |  |
| merit_plan_amount_compensation_basis | String |  |
| merit_plan_amount_manage_by_compensation_basis | Boolean |  |
| merit_plan_currency | String |  |
| merit_plan_frequency | String |  |
| merit_plan_include_active_employees_in_waiting_period | Boolean |  |
| merit_plan_include_active_employess_assigned | Boolean |  |
| merit_plan_percentage_calculation_compensation | String |  |
| merit_plan_percentage_compensation_basis | String |  |
| merit_plan_percentage_manage_by_compensation_basis | Boolean |  |
| merit_plan_required_amount | Double |  |
| merit_plan_rounding_rule | String |  |
| merit_plan_subject_to_statutory_minimum | Boolean |  |
| merit_plan_target_percentage | Double |  |
| merit_plan_time_proration | String |  |
| merit_plan_use_matrix_as_reference_only | Boolean |  |
| merit_plan_waiting_period | String |  |
| name | String |  |
| period_plan_calculation_compensation | String |  |
| period_plan_compensation_basis | String |  |
| period_plan_default_compensation_multiplier | Double |  |
| period_plan_element | String |  |
| period_plan_unit_of_duration | String |  |
| stock_plan_allow_target_override | Boolean |  |
| stock_plan_amount_data_currency | String |  |
| stock_plan_amount_data_rounding_rule | String |  |
| stock_plan_amount_data_target_amount | Double |  |
| stock_plan_amount_data_use_target_currency | Boolean |  |
| stock_plan_percent_data_calculation_compensation | String |  |
| stock_plan_percent_data_compensation_basis | String |  |
| stock_plan_percent_data_rounding_rule | String |  |
| stock_plan_percent_data_target_percent | Double |  |
| stock_plan_unit_data_target_shares | Double |  |
| stock_plan_use_as_reference_only | Boolean |  |

### scorecard_goal

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| scorecard_id | String | PK, FK |
| description | String |  |
| name | String |  |
| weight | Double |  |

### position_worker_type_restriction

| Column | Type | Keys |
| --- | --- | --- |
| worker_type_id | String | PK |
| position_id | String | PK, FK |
| worker_type_code | String |  |

### worker_leave_request_detail

| Column | Type | Keys |
| --- | --- | --- |
| leave_request_event_id | String | PK |
| worker_id | String | PK, FK |
| adoption_notification_date | LocalDate |  |
| adoption_placement_date | LocalDate |  |
| age_of_dependent | Double |  |
| benefits_effect | Boolean |  |
| caesarean_section_birth | Boolean |  |
| child_birth_date | LocalDate |  |
| child_sdate_of_death | LocalDate |  |
| continuous_service_accrual_effect | Boolean |  |
| date_baby_arrived_home_from_hospital | LocalDate |  |
| date_child_entered_country | LocalDate |  |
| date_of_recall | LocalDate |  |
| description | String |  |
| estimated_leave_end_date | LocalDate |  |
| expected_due_date | LocalDate |  |
| first_day_of_work | LocalDate |  |
| last_date_for_which_paid | LocalDate |  |
| leave_end_date | LocalDate |  |
| leave_entitlement_override | Double |  |
| leave_last_day_of_work | LocalDate |  |
| leave_percentage | Double |  |
| leave_request_code | String |  |
| leave_return_id | String |  |
| leave_start_date | LocalDate |  |
| leave_type_reason | String |  |
| leaveof_absence_type | String |  |
| location_during_leave | String |  |
| multiple_child_indicator | Boolean |  |
| number_of_babies_adopted_children | Double |  |
| number_of_child_dependents | Double |  |
| number_of_previous_births | Double |  |
| number_of_previous_maternity_leaves | Double |  |
| on_leave | Boolean |  |
| paid_time_off_accrual_effect | Boolean |  |
| payroll_effect | Boolean |  |
| prior_event | String |  |
| single_parent_indicator | Boolean |  |
| social_security_disability_code | String |  |
| stillbirth_baby_deceased | Boolean |  |
| stock_vesting_effect | Boolean |  |
| stop_payment_date | LocalDate |  |
| week_of_confinement | LocalDate |  |
| work_related | Boolean |  |

### position_bonus_plan

| Column | Type | Keys |
| --- | --- | --- |
| bonus_plan_id | String | PK |
| position_id | String | PK, FK |
| bonus_plan_code | String |  |
| compensation_basis_override_amount | Double |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| guaranteed_minimum | Boolean |  |
| inactive_date | LocalDate |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| percent_assigned | Double |  |

### review_question

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| question_category_id | String | FK |
| question | String |  |
| question_code | String |  |
| used_in_templates_count | Int |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| manager_id | String | FK |
| organization_owner_id | String | FK |
| superior_organization_id | String | FK |
| top_level_organization_id | String | FK |
| availability_date | Instant |  |
| available_for_hire | Boolean |  |
| code | String |  |
| description | String |  |
| external_url | String |  |
| hiring_freeze | Boolean |  |
| inactive | Boolean |  |
| inactive_date | LocalDate |  |
| include_manager_in_name | Boolean |  |
| include_organization_code_in_name | Boolean |  |
| last_updated_date_time | Instant |  |
| location | String |  |
| name | String |  |
| organization_code | String |  |
| staffing_model | String |  |
| sub_type | String |  |
| supervisory_position_availability_date | LocalDate |  |
| supervisory_position_earliest_hire_date | LocalDate |  |
| supervisory_position_time_type | String |  |
| supervisory_position_worker_type | String |  |
| type | String |  |
| visibility | String |  |

### military_service

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| personal_information_common_id | String | PK, FK |
| discharge_date | LocalDate |  |
| discharge_type | String |  |
| notes | String |  |
| rank | String |  |
| service | String |  |
| service_type | String |  |
| status_begin_date | LocalDate |  |
| status_id | String |  |

### job_profile_language_ability

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| language_id | String | PK, FK |
| language_ability_type_code | String |  |
| language_proficiency_code | String |  |

### responsibility_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### time_off_plan_balance

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| time_off_plan_code | String |  |
| time_off_plan_descriptor | String |  |
| unit_of_time_code | String |  |

### address_use_for_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address_id | String | PK, FK |
| communication_usage_behaviour | String |  |

### qualification_competency_achievement

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assessed_by_person_id | String | FK |
| assessed_by_person_code | String |  |
| assessed_by_worker_descriptor | String |  |
| assessed_on | LocalDate |  |
| assessment_comment | String |  |
| competency_code | String |  |
| competency_level_behavior_code | String |  |
| competency_level_behaviour_descriptor | String |  |
| comptency_descriptor | String |  |

### address_use_for_tenanted_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address_id | String | PK, FK |
| communication_usage_behaviour_tenanted | String |  |

### scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| effective_date | LocalDate |  |
| name | String |  |
| scorecard_code | String |  |

### pre_hire_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| work_experience_id | String | PK |
| pre_hire_id | String | PK, FK |
| comment | String |  |
| rating_code | String |  |
| removed | Boolean |  |
| work_experience_code | String |  |

### learning_lesson

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| description | String |  |
| exclude_from_recommendations | Boolean |  |
| exclude_from_search_and_browse | Boolean |  |
| image_attachment | String |  |
| image_attachment_code | String |  |
| image_attachment_content_type | String |  |
| image_attachment_file_name | String |  |
| image_code | String |  |
| image_file_code | String |  |
| image_id | String |  |
| image_work_drive_document_file_code | String |  |
| image_work_drive_document_id | String |  |
| image_work_drive_document_item_code | String |  |
| image_work_drive_document_migrateable_code | String |  |
| inactive | Boolean |  |
| media_code | String |  |
| media_id | String |  |
| media_migrateable_code | String |  |
| media_workdrive_item_code | String |  |
| title | String |  |
| workdrive_file_code | String |  |
| workdrive_item_id | String |  |
| workdrive_media_code | String |  |
| workdrive_migrateable_code | String |  |

### candidate_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| candidate_id | String | PK, FK |
| tag_code | String |  |

### carryover_override

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | FK |
| worker_id | String | FK |
| absence_plan_code | String |  |
| carry_override_code | String |  |
| carryover_date | LocalDate |  |
| carryover_expiration_date | LocalDate |  |
| carryover_override_amount | Double |  |
| comments | String |  |

### location_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| location_id | String | PK, FK |
| value | String |  |

### job_requisition_language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| language_code | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### position_unit_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| unit_salary_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| currency_code | String |  |
| default_units | Double |  |
| frequency_code | String |  |
| per_unit_amount | Double |  |
| unit_salary_plan_code | String |  |

### pre_hire_background_check_status

| Column | Type | Keys |
| --- | --- | --- |
| background_check_status_id | String | PK |
| pre_hire_id | String | PK, FK |
| background_check_status_code | String |  |
| status_comment | String |  |
| status_date | LocalDate |  |

### compensation_eligibility_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_eligibility_rule_id | String | PK, FK |
| and_or_operator_name | String |  |
| close_parentheses | String |  |
| condition_entry_option | String |  |
| filter_boolean | Boolean |  |
| filter_date | LocalDate |  |
| filter_date_time | Instant |  |
| filter_date_time_zone | String |  |
| filter_number | Double |  |
| filter_text | String |  |
| filter_time | Instant |  |
| open_parentheses | String |  |
| order | String |  |
| relational_operator | String |  |
| source_condition_rule | String |  |
| source_external_field | String |  |
| target_external_field | String |  |

### position_unit_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| unit_allowance_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| number_of_units | Double |  |
| per_unit_amount | Double |  |
| reimbursement_start_date | LocalDate |  |
| unit_allowance_plan_code | String |  |

### worker_merit_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| default_target_percent | Double |  |
| guaranteed_minimum | Boolean |  |
| individual_target_percent | Double |  |
| merit_increase_matrix_code | String |  |
| merit_plan_code | String |  |

### lgbt_identification

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| inactive | Boolean |  |
| lgbt_identification_id | String |  |
| location_id | String |  |
| name | String |  |

### assess_talent

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| achievable_level_code | String |  |
| employee_potential_field_1_value | String |  |
| employee_potential_field_2_value | String |  |
| loss_impact_code | String |  |
| notes | String |  |
| potential_code | String |  |
| retention_risk_code | String |  |
| review_rating | String |  |
| talent_matrix_placement_rating | String |  |

### candidate_certification

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| certification_code | String |  |
| certification_number | String |  |
| country | String |  |
| exam_date | LocalDate |  |
| exam_score | String |  |
| expiration_date | LocalDate |  |
| issued_date | LocalDate |  |
| removed | Boolean |  |

### questionnaire

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| inactive | Boolean |  |
| instructions | String |  |
| name | String |  |
| questionnaire_code | String |  |

### interviewer

| Column | Type | Keys |
| --- | --- | --- |
| interview_session_detail_id | Long | PK, FK |
| interview_session_id | String | PK, FK |
| interviewer_id | String | PK, FK |

### career_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| career_preference_code | String |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| job_profile_codes | Json |  |
| long_term_relocation | String |  |
| long_term_relocation_area_codes | Json |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| mobility_choice_code | String |  |
| relocation_additional_information | String |  |
| short_term_relocation | String |  |
| short_term_relocation_area_codes | Json |  |
| travel_additional_information | String |  |
| travel_amount_code | String |  |

### organization_role_worker

| Column | Type | Keys |
| --- | --- | --- |
| associated_worker_id | String | PK, FK |
| organization_id | String | PK, FK |
| role_id | String | PK, FK |

### job_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| inactive | Boolean |  |
| name | String |  |

### candidate_government_id

| Column | Type | Keys |
| --- | --- | --- |
| government_id | String | PK |
| candidate_id | String | PK, FK |
| verified_by_worker_id | String | FK |
| country | String |  |
| expiration_date | LocalDate |  |
| government_code | String |  |
| government_id_shared_code | String |  |
| government_id_type_code | String |  |
| issued_date | LocalDate |  |
| verification_date | LocalDate |  |

### job_requisition_compensation_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_id | String | PK, FK |
| compensation_grade_id | String | FK |
| compensation_grade_profile_id | String | FK |
| compensation_package_code | String |  |
| compensation_step_code | String |  |
| primary_compensation_basis | Double |  |
| primary_compensation_basis_amount_change | Double |  |
| primary_compensation_basis_percent_change | Double |  |

### job_profile_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| job_profile_code | String |  |

### job_profile_exempt

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| is_job_exempt | Boolean |  |
| location_context | String |  |

### job_requisition_role_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| organization_role_id | String | FK |
| effective_date | LocalDate |  |
| requisition_role_code | String |  |

### compensation_stock_profile_grant_split

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| compensation_plan_id | String | PK, FK |
| unit_profile_replacement_index | Long | PK, FK |
| grant_split_percent | Double |  |
| grant_type | String |  |
| stock_date_rule | String |  |
| stock_vesting_schedule | String |  |

### compensation_stock_plan_amount_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| currency | String |  |
| target_amount | Double |  |

### person_contact_email_address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_info_system_id | String | PK, FK |
| email_address | String |  |
| email_code | String |  |
| email_comment | String |  |

### organization_assignment

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | String | PK, FK |
| reference_organization_id | String | PK, FK |
| reference_organization_type | String |  |

### job_profile_training

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| description | String |  |
| name | String |  |
| required | Boolean |  |
| training_type | String |  |

### worker_collective_agreement_factor

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| collective_agreement_id | String | PK, FK |
| collective_agreement_factor_code | String |  |
| collective_agreement_factor_id | String |  |
| order_number | String |  |

### candidate_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| language_code | String |  |

### pronoun

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| description | String |  |
| inactive | Boolean |  |
| name | String |  |
| order | String |  |
| pronoun_id | String |  |

### external_reference_participant

| Column | Type | Keys |
| --- | --- | --- |
| referee_id | String | PK |
| external_reference_id | String | PK, FK |
| questionnaire_id | String | FK |
| referee_code | String |  |

### compensation_stock_plan_grant

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| compensation_plan_id | String | PK, FK |
| grant_split_percent | Double |  |
| grant_type | String |  |
| stock_date_rule | String |  |
| stock_vesting_schedule | String |  |

### position_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| job_profile_id | String | PK |
| position_id | String | PK, FK |
| difficulty_to_fill_code | String |  |
| is_critical_job | Boolean |  |
| job_category_code | String |  |
| management_level_code | String |  |
| management_level_descriptor | String |  |
| name | String |  |
| work_shift_required | Boolean |  |

### interview_session

| Column | Type | Keys |
| --- | --- | --- |
| interview_session_id | String | PK |
| interview_id | String | PK, FK |
| interview_session_code | String |  |

### job_requisition_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| allowance_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| allowance_plan_code | String |  |
| amount | Double |  |
| compensation_basis_override_amount | Double |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| percent | Double |  |
| reimbursement_start_date | LocalDate |  |

### development_item_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| additional_information | String |  |
| category_codes | Json |  |
| completion_date | LocalDate |  |
| development_item_title | String |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| last_updated_date | Instant |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |
| start_date | LocalDate |  |
| status_code | String |  |
| status_note | String |  |
| tag_reference_code | String |  |

### learning_lesson_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_lesson_id | String | PK, FK |
| code | String |  |

### competency_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### pre_hire_language_ability

| Column | Type | Keys |
| --- | --- | --- |
| language_ability_type_id | String | PK |
| language_achievement_id | String | PK, FK |
| language_ability_type_code | String |  |
| language_proficiency_code | String |  |

### additional_manager_accomplishment_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### talent_pool

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| exclude_from_termination | Boolean |  |
| inactive | Boolean |  |
| name | String |  |
| restricted_view | Boolean |  |
| talent_pool_code | String |  |

### payroll_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| payroll_id | String | PK, FK |
| costing_company_id | String | FK |
| amount | Double |  |
| arrco_agirc_category_code | String |  |
| arrear_amount | Double |  |
| business_unit_worktag_code | String |  |
| custom_worktag_06_code | String |  |
| custom_worktag_07_code | String |  |
| custom_worktag_08_code | String |  |
| custom_worktag_09_code | String |  |
| custom_worktag_10_code | String |  |
| custom_worktag_11_code | String |  |
| custom_worktag_12_code | String |  |
| custom_worktag_13_code | String |  |
| custom_worktag_14_code | String |  |
| custom_worktag_15_code | String |  |
| exemption_code | String |  |
| fund_worktag_code | String |  |
| gift_worktag_code | String |  |
| grant_worktag_code | String |  |
| income_code | String |  |
| input_comment | String |  |
| ni_category_code | String |  |
| object_class_worktag_code | String |  |
| pay_frequency | Double |  |
| period_remaining | Double |  |
| program_worktag_code | String |  |
| project_phase_worktag_code | String |  |
| project_task_worktag_code | String |  |
| subperiod_end | LocalDate |  |
| subperiod_start | LocalDate |  |
| tax_residency_country_code | String |  |
| workers_compensation_code | String |  |

### learning_course_offering

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| delivery_mode_code | String |  |
| delivery_mode_id | String |  |

### location_address_submunicipality

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| submunicipality_data | String |  |
| type | String |  |

### compensation_step

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_grade_id | String | PK, FK |
| amount | Double |  |
| compensation_step_code | String |  |
| effective_date | LocalDate |  |
| interval | Double |  |
| name | String |  |
| progression_period_code | String |  |
| progression_rule_code | String |  |
| sequence | String |  |

### score_for_multiple_choice

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | String | PK |
| questions_for_questionnaire_id | String | PK, FK |
| answer_code | String |  |
| score | Int |  |

### job_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_grade_id | String | FK |
| job_category_id | String | FK |
| additional_job_description | String |  |
| critical_job | Boolean |  |
| description | String |  |
| difficulty_to_fill | String |  |
| effective_date | LocalDate |  |
| inactive | Boolean |  |
| include_job_code_in_name | Boolean |  |
| job_profile_code | String |  |
| level | String |  |
| management_level | String |  |
| private_title | String |  |
| public_job | Boolean |  |
| referral_payment_plan | String |  |
| summary | String |  |
| title | String |  |
| union_code | String |  |
| union_membership_requirement | String |  |
| work_shift_required | Boolean |  |
| work_study_award_source_code | String |  |
| work_study_requirement_option_code | String |  |

### worker_unit_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| frequency_code | String |  |
| number_of_units | Double |  |
| per_unit_amount | Double |  |
| unit_allowance_plan_code | String |  |
| unit_common_code | String |  |
| unit_edicode | String |  |

### position_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| qualification_source | String |  |
| required | Boolean |  |
| work_experience_code | String |  |
| work_experience_rating | String |  |

### location_address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| location_id | String | PK, FK |
| address_code | String |  |
| city | String |  |
| country | String |  |
| country_region | String |  |
| country_region_code | String |  |
| effective_date | LocalDate |  |
| last_modified | Instant |  |
| municipality | String |  |
| municipality_local | String |  |
| number_of_days | Double |  |
| postal_code | String |  |

### pay_accumulation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| amount | Double |  |
| pay_accumulation_code | String |  |

### candidate_pool_membership

| Column | Type | Keys |
| --- | --- | --- |
| candidate_pool_id | String | PK |
| candidate_id | String | PK, FK |
| candidate_pool_code | String |  |
| readiness_status_code | String |  |
| readiness_status_id | String |  |

### additional_manager_question_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### job_profile_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| job_profile_id | String | PK, FK |
| value | String |  |

### rating_scale

| Column | Type | Keys |
| --- | --- | --- |
| rating_scale_id | String | PK |
| description | String |  |
| inactive | Boolean |  |
| rating_scale_code | String |  |
| rating_scale_name | String |  |

### pre_hire

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| comments | String |  |
| eligible_for_rehire | String |  |
| eligible_for_rehire_comments | String |  |
| entered_date | LocalDate |  |
| marked_as_no_show | String |  |
| pre_hire_code | String |  |
| source_code | String |  |

### worker_position_organization

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| organization_id | String | FK |
| date_of_pay_group_assignment | LocalDate |  |
| organization_name | String |  |
| organization_type_code | String |  |
| organization_type_id | String |  |
| primary_business_site | String |  |
| used_in_change_organization_assignments | Boolean |  |

### worker_salary_and_hourly

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| amount | Double |  |
| assignment_effective_date | LocalDate |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| frequency_code | String |  |
| salary_and_hourly_plan_code | String |  |

### additional_manager_overall_evaluation

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### worker

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_grade_id | String | FK |
| compensation_grade_profile_id | String | FK |
| academic_tenure_date | LocalDate |  |
| active | Boolean |  |
| active_status_date | LocalDate |  |
| annual_currency_summary_currency | String |  |
| annual_currency_summary_frequency | String |  |
| annual_currency_summary_primary_compensation_basis | Double |  |
| annual_currency_summary_total_base_pay | Double |  |
| annual_currency_summary_total_salary_and_allowances | Double |  |
| annual_summary_currency | String |  |
| annual_summary_frequency | String |  |
| annual_summary_primary_compensation_basis | Double |  |
| annual_summary_total_base_pay | Double |  |
| annual_summary_total_salary_and_allowances | Double |  |
| benefits_service_date | LocalDate |  |
| company_service_date | LocalDate |  |
| compensation_effective_date | LocalDate |  |
| continuous_service_date | LocalDate |  |
| contract_assignment_details | String |  |
| contract_currency_code | String |  |
| contract_end_date | LocalDate |  |
| contract_frequency_name | String |  |
| contract_pay_rate | Double |  |
| contract_supplier_reference_code | String |  |
| contract_vendor_name | String |  |
| currency_code | String |  |
| currency_numeric_code | String |  |
| date_entered_workforce | LocalDate |  |
| days_unemployed | Double |  |
| display_language_code | String |  |
| eligible_for_hire | String |  |
| eligible_for_rehire_on_latest_termination | String |  |
| employee_compensation_currency | String |  |
| employee_compensation_frequency | String |  |
| employee_compensation_primary_compensation_basis | Double |  |
| employee_compensation_total_base_pay | Double |  |
| employee_compensation_total_salary_and_allowances | Double |  |
| end_employment_date | LocalDate |  |
| expected_date_of_return | LocalDate |  |
| expected_retirement_date | LocalDate |  |
| first_day_of_work | LocalDate |  |
| has_international_assignment | Boolean |  |
| hire_date | LocalDate |  |
| hire_reason | String |  |
| hire_reason_descriptor | String |  |
| hire_rescinded | Boolean |  |
| home_country | String |  |
| hour_clock_code | String |  |
| hourly_frequency_currency | String |  |
| hourly_frequency_frequency | String |  |
| hourly_frequency_primary_compensation_basis | Double |  |
| hourly_frequency_total_base_pay | Double |  |
| hourly_frequency_total_salary_and_allowances | Double |  |
| last_datefor_which_paid | LocalDate |  |
| local_termination_reason | String |  |
| locale_code | String |  |
| months_continuous_prior_employment | Double |  |
| not_returning | Boolean |  |
| original_hire_date | LocalDate |  |
| pay_group_frequency_currency | String |  |
| pay_group_frequency_frequency | String |  |
| pay_group_frequency_primary_compensation_basis | Double |  |
| pay_group_frequency_total_base_pay | Double |  |
| pay_group_frequency_total_salary_and_allowances | Double |  |
| pay_through_date | LocalDate |  |
| preferred_language_code | String |  |
| primary_termination_category | String |  |
| primary_termination_category_descriptor | String |  |
| primary_termination_reason | String |  |
| primary_termination_reason_descriptor | String |  |
| probation_end_date | LocalDate |  |
| probation_start_date | LocalDate |  |
| reason_reference_descriptor | String |  |
| reason_reference_id | String |  |
| regrettable_termination | Boolean |  |
| rehire | Boolean |  |
| resignation_date | LocalDate |  |
| retired | Boolean |  |
| retirement_date | LocalDate |  |
| retirement_eligibility_date | LocalDate |  |
| return_unknown | Boolean |  |
| seniority_date | LocalDate |  |
| severance_date | LocalDate |  |
| simplified_view | Boolean |  |
| terminated | Boolean |  |
| termination_date | LocalDate |  |
| termination_involuntary | Boolean |  |
| termination_last_day_of_work | LocalDate |  |
| time_off_service_date | LocalDate |  |
| time_zone_code | String |  |
| universal_id | String |  |
| user_id | String |  |
| user_language_code | String |  |
| user_name | String |  |
| vesting_date | LocalDate |  |
| worker_code | String |  |

### calibration_program

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| allow_update_of_assess_potential_during_calibration | Boolean |  |
| autocomplete_first_participant | Boolean |  |
| calibration_program_code | String |  |
| calibration_program_description | String |  |
| calibration_program_name | String |  |
| column_default_value_crf_code | String |  |
| error_on_target_percentage_population | Boolean |  |
| error_on_unplotted_worker | Boolean |  |
| hide_nbox_summary_view | Boolean |  |
| initiate_population_unplotted | Boolean |  |
| n_box_cell_limit | Double |  |
| nbox_custom_report_code | String |  |
| nbox_id | String |  |
| program_due_date | LocalDate |  |
| program_status | Boolean |  |
| restricted_to_rule_code | String |  |
| row_default_value_crf_code | String |  |
| warning_on_target_percentage_population | Boolean |  |
| warning_on_unplotted_worker | Boolean |  |

### job_requisition_additional_job_posting_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| job_requisition_id | String | PK, FK |
| location_code | String |  |

### personal_information_gender_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_information_common_id | String | PK, FK |
| gender_code | String |  |

### compensation_bonus_plan_replacement_amount

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| amount | Double |  |
| currency | String |  |

### job_requisition_merit_plan

| Column | Type | Keys |
| --- | --- | --- |
| merit_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| guaranteed_minimum | Boolean |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| merit_plan_code | String |  |

### development_area_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| development_area | String |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |

### address_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| line_data | String |  |
| type | String |  |

### supervisory_organization_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| organization_id | String | PK, FK |
| location_code | String |  |

### organization_position_group_position

| Column | Type | Keys |
| --- | --- | --- |
| position_worker_type_id | String | PK |
| organization_id | String | PK, FK |
| position_worker_type_code | String |  |

### pre_hire_award_and_activity

| Column | Type | Keys |
| --- | --- | --- |
| award_and_activity_id | String | PK |
| pre_hire_id | String | PK, FK |
| award_and_activity_code | String |  |
| description | String |  |
| end_date | LocalDate |  |
| position_element_code | String |  |
| removed | Boolean |  |
| sponsor_issuer | String |  |
| start_date | LocalDate |  |
| title | String |  |
| type_code | String |  |
| url | String |  |

### country_personal_information

| Column | Type | Keys |
| --- | --- | --- |
| fivetran_id | String | PK |
| personal_information_common_id | String | PK, FK |
| aboriginal_indigenous_identification_code | String |  |
| aboriginal_indigenous_identification_details_ids | Json |  |
| active_military_uniformed_service_code | String |  |
| country_code | String |  |
| disabled_veteran_leave_date | LocalDate |  |
| ethnicity_visual_survey_ids | Json |  |
| gender | String |  |
| hispanic_or_latino | Boolean |  |
| hispanic_or_latino_visual_survey | Boolean |  |
| hukou_locality | String |  |
| hukou_postal_code | String |  |
| hukou_region_code | String |  |
| hukou_subregion_code | String |  |
| hukou_type_code | String |  |
| local_hukou | Boolean |  |
| marital_status | String |  |
| marital_status_date | LocalDate |  |
| marital_status_descriptor | String |  |
| native_region | Json |  |
| native_region_descriptor | String |  |
| personnel_file_agencyfor_person | String |  |
| political_affiliation_code | String |  |
| race_ethnicity_detail_id | Json |  |
| religion | String |  |
| reporting_gender | String |  |
| selective_service_registration | String |  |
| social_benefits_locality | String |  |
| uniform_service_reserve_status | String |  |
| veterans_preference_code | Json |  |
| veterans_preference_for_rif | String |  |

### compensation_matrix_percent

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| compensation_matrix_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| compa_ratio_range | String |  |
| max_percent | Double |  |
| min_percent | Double |  |
| pay_range_segment | String |  |
| performance_evaluation | String |  |
| potential | String |  |
| quartile_placement | String |  |
| retention | String |  |

### additional_manager_career_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### worker_pay_group_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| index | Long | PK |
| worker_id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| completed_on | Instant |  |
| effective_date | LocalDate |  |
| event_corrected | Boolean |  |
| event_rescinded | Boolean |  |
| original_pay_group | String |  |
| proposed_pay_group | String |  |

### job_requisition_role_assignee

| Column | Type | Keys |
| --- | --- | --- |
| role_assignee_id | String | PK |
| job_requisition_id | String | PK, FK |
| job_requisition_role_assignment_id | String | PK, FK |
| worker_id | String | FK |
| role_assignee_code | String |  |

### job_requisition_period_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| period_salary_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| compensation_basis_override_amount | Double |  |
| compensation_period_code | String |  |
| compensation_period_multiplier | Double |  |
| currency_code | String |  |
| frequency_code | String |  |
| period_salary_plan_code | String |  |

### position_stock_plan

| Column | Type | Keys |
| --- | --- | --- |
| stock_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| compensation_basis_override_amount | Double |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| individual_target_shares | Double |  |
| stock_plan_code | String |  |

### job_requisition_bonus_plan

| Column | Type | Keys |
| --- | --- | --- |
| bonus_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| bonus_plan_code | String |  |
| compensation_basis_override_amount | Double |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| guaranteed_minimum | Boolean |  |
| inactive_date | LocalDate |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| percent_assigned | Double |  |

### ethnicity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| description | String |  |
| ethnicity_id | String |  |
| ethnicity_mapping_id | String |  |
| inactive | Boolean |  |
| location_id | String |  |
| name | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| altitude | Float |  |
| code | String |  |
| currency | String |  |
| currency_code | String |  |
| inactive | Boolean |  |
| latitude | Float |  |
| locale | String |  |
| longitude | Float |  |
| name | String |  |
| time_profile | String |  |
| time_zone | String |  |

### rating_scale_review_rating

| Column | Type | Keys |
| --- | --- | --- |
| review_rating_id | String | PK |
| rating_scale_id | String | PK, FK |
| description | String |  |
| exclude_from_calculations | Boolean |  |
| range_begin | Double |  |
| range_end | Double |  |
| rating | String |  |
| rating_order | String |  |
| rating_value | Double |  |
| review_rating_code | String |  |

### job_requisition_responsibility

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| qualification_source | String |  |
| required | Boolean |  |
| responsibility | String |  |

### benchmark_job

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| benchmark_job_code | String |  |
| currency | String |  |
| description | String |  |
| effective_date | LocalDate |  |
| frequency | String |  |
| inactive | Boolean |  |
| name | String |  |
| survey_date | LocalDate |  |

### interview_session_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| interview_session_id | String | PK, FK |
| comment | String |  |
| interview_end_time | Instant |  |
| interview_start_time | Instant |  |
| interview_type_code | String |  |
| location_code | String |  |

### learning_lesson_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_lesson_id | String | PK, FK |
| code | String |  |
| remote_skill_code | String |  |

### region_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| organization_id | String | FK |
| region_code | String |  |

### question_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### job_requisition_custom_organization

| Column | Type | Keys |
| --- | --- | --- |
| custom_organization_id | String | PK, FK |
| job_requisition_id | String | PK, FK |

### worker_position_compensation_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| id | String | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| workers_compensation_code | String |  |

### job_requisition_role_assignee_history

| Column | Type | Keys |
| --- | --- | --- |
| role_assignee_id | String | PK |
| job_requisition_id | String | PK, FK |
| job_requisition_role_assignment_id | String | PK, FK |
| worker_id | String | FK |
| role_assignee_code | String |  |

### position_organization

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| organization_id | String | PK, FK |
| position_id | String | PK, FK |

### pre_hire_internal_project_experience

| Column | Type | Keys |
| --- | --- | --- |
| internal_project_id | String | PK |
| pre_hire_id | String | PK, FK |
| description | String |  |
| end_date | LocalDate |  |
| internal_project | String |  |
| internal_project_code | String |  |
| project_leader | String |  |
| removed | Boolean |  |
| start_date | LocalDate |  |

### sexual_orientation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| description | String |  |
| inactive | Boolean |  |
| name | String |  |
| sexual_orientation_id | String |  |

### worker_costing_allocation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| position_id | String | FK |
| position_restrictions_id | String | FK |
| worker_id | String | FK |
| earning_code | String |  |

### worker_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| allowance_plan_code | String |  |
| amount | Double |  |
| assignment_effective_date | LocalDate |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| frequency_code | String |  |
| percent | Double |  |

### payroll_local_city_authority_tax_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| payroll_local_city_authority_tax_code | String |  |

### position_calculated_plan

| Column | Type | Keys |
| --- | --- | --- |
| calculated_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| amount_override | Double |  |
| calculated_plan_code | String |  |
| currency_code | String |  |
| frequency_code | String |  |

### compensation_merit_plan_replacement_amount

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| compensation_basis | String |  |
| currency | String |  |
| target_amount | Double |  |

### job_classification_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| effective_date | LocalDate |  |
| global_setup_data_mapping | String |  |
| inactive | Boolean |  |
| job_classification_group_code | String |  |
| job_classification_group_name | String |  |
| location | String |  |

### job_profile_certification_specialty

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| certification_index | Long | PK, FK |
| job_profile_id | String | PK, FK |
| specialty_code | String |  |

### compensation_bonus_plan_replacement_percent

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| compensation_basis | String |  |
| percentage | Double |  |

### job_profile_worker_compensation

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| worker_compensation_code | String |  |

### pre_hire_professional_affiliation

| Column | Type | Keys |
| --- | --- | --- |
| professional_affiliation_id | String | PK |
| pre_hire_id | String | PK, FK |
| affiliation | String |  |
| begin_date | LocalDate |  |
| end_date | LocalDate |  |
| name | String |  |
| professional_affiliation_code | String |  |
| reference_code | String |  |
| relationship_type_code | String |  |
| removed | Boolean |  |
| type_all_code | String |  |

### worker_future_payment_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| comment | String |  |
| currency_code | String |  |
| future_payment_plan_code | String |  |
| individual_target_amount | Double |  |
| individual_target_payment_date | LocalDate |  |

### interview_feedback_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| interview_feedback_id | String | PK, FK |
| comment | String |  |
| rating_code | String |  |

### compensation_stock_plan_unit_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| target_shares | Double |  |

### feedback_competency_assessment

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| interview_feedback_detail_id | Long | PK, FK |
| interview_feedback_id | String | PK, FK |
| comment | String |  |
| competency_code | String |  |
| proficiency_rating | String |  |

### payroll_state_authority_tax_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| payroll_state_authority_tax_code | String |  |

### personal_information_sexual_orientation_and_gender_identity

| Column | Type | Keys |
| --- | --- | --- |
| lgbt_identification_id | String | PK |
| country_personal_information_id | String | PK, FK |
| lgbt_identification_code | String |  |

### personal_information_sexual_orientation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_information_common_data_id | String | PK, FK |
| sexual_orientation_code | String |  |

### worker_position_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| position_id | String | PK |
| worker_id | String | PK, FK |
| job_family_id | String | FK |
| job_profile_id | String | FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| business_title | String |  |
| critical_job | Boolean |  |
| default_weekly_hours | Double |  |
| difficulty_to_fill | String |  |
| effective_date | LocalDate |  |
| employee_type | String |  |
| end_date | LocalDate |  |
| end_employment_date | LocalDate |  |
| exclude_from_head_count | Boolean |  |
| expected_assignment_end_date | LocalDate |  |
| external_employee | String |  |
| federal_withholding_fein | String |  |
| frequency | String |  |
| full_time_equivalent_percentage | Double |  |
| headcount_restriction_code | String |  |
| home_country | String |  |
| host_country | String |  |
| international_assignment_type | String |  |
| is_primary_job | Boolean |  |
| job_exempt | Boolean |  |
| management_level_code | String |  |
| management_level_descriptor | String |  |
| paid_fte | Double |  |
| pay_group | String |  |
| pay_rate | String |  |
| pay_rate_type | String |  |
| pay_through_date | LocalDate |  |
| payroll_entity | String |  |
| payroll_file_number | String |  |
| position_code | String |  |
| position_time_type | String |  |
| position_worker_type | String |  |
| regular_paid_equivalent_hours | Double |  |
| scheduled_weekly_hours | Double |  |
| specify_paid_fte | Boolean |  |
| specify_working_fte | Boolean |  |
| start_date | LocalDate |  |
| start_international_assignment_reason | String |  |
| work_hours_profile | String |  |
| work_shift | String |  |
| work_shift_required | Boolean |  |
| work_space | String |  |
| worker_hours_profile_classification | String |  |
| worker_type | String |  |
| working_fte | Double |  |
| working_time_frequency | String |  |
| working_time_unit | String |  |
| working_time_value | Double |  |
| academic_pay_setup_data_** |  |  |
| business_site_summary_** |  |  |

### calculation_tag

| Column | Type | Keys |
| --- | --- | --- |
| time_calculation_tag_id | String | PK |
| calculated_time_block_id | String | PK, FK |
| descriptor | String |  |
| time_calculation_tag_code | String |  |

### learning_course_offering_data_from_course

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| learning_course_offering_id | String | PK, FK |
| attachment_file_code | String |  |
| attachment_id | String |  |
| attachment_image_code | String |  |
| description | String |  |
| skill_level_code | String |  |
| skill_level_id | String |  |
| title | String |  |
| topics | Json |  |

### learning_course_offering_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_id | String | PK, FK |
| additional_details | String |  |
| course_effective_date | LocalDate |  |
| enable_auto_enrollment_from_waitlist | Boolean |  |
| max_enrollment_capacity | String |  |
| min_enrollment_capacity | String |  |
| offering_number | String |  |
| price_in_training_credits | Double |  |
| pricing_enabled | Boolean |  |
| primary_learning_assessors_code | Json |  |
| primary_learning_instructor_code | Json |  |
| primary_location_code | String |  |
| primary_location_id | String |  |
| registerable_status_code | String |  |
| registerable_status_id | String |  |
| unlimited_capacity | Boolean |  |
| update_status_from_offering_dates | Boolean |  |
| version_label | String |  |
| waitlist_capacity | String |  |

### interview_feedback

| Column | Type | Keys |
| --- | --- | --- |
| interview_id | String | PK, FK |
| interviewer_id | String | PK, FK |

### compensation_eligibility_compensation_package

| Column | Type | Keys |
| --- | --- | --- |
| compensation_package_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### payroll_local_county_authority_tax_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| payroll_local_county_authority_tax_code | String |  |

### qualification_award_and_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| award_and_activity_code | String |  |
| award_and_activity_type_code | String |  |
| description | String |  |
| end_date | LocalDate |  |
| related_position_code | String |  |
| remove_award_and_activity | Boolean |  |
| sponsor_issuer | String |  |
| start_date | LocalDate |  |
| title | String |  |
| url | String |  |

### job_profile_certification

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| certification_code | String |  |
| country_code | String |  |
| issuer | String |  |
| name | String |  |
| required | Boolean |  |

### worker_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| id | String | PK |
| compensation_grade_id | String | FK |
| compensation_grade_profile_id | String | FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| academic_tenure_date | LocalDate |  |
| active | Boolean |  |
| active_status_date | LocalDate |  |
| annual_currency_summary_currency | String |  |
| annual_currency_summary_frequency | String |  |
| annual_currency_summary_primary_compensation_basis | Double |  |
| annual_currency_summary_total_base_pay | Double |  |
| annual_currency_summary_total_salary_and_allowances | Double |  |
| annual_summary_currency | String |  |
| annual_summary_frequency | String |  |
| annual_summary_primary_compensation_basis | Double |  |
| annual_summary_total_base_pay | Double |  |
| annual_summary_total_salary_and_allowances | Double |  |
| as_of_effective_date | Instant |  |
| benefits_service_date | LocalDate |  |
| company_service_date | LocalDate |  |
| compensation_effective_date | LocalDate |  |
| continuous_service_date | LocalDate |  |
| contract_assignment_details | String |  |
| contract_currency_code | String |  |
| contract_end_date | LocalDate |  |
| contract_frequency_name | String |  |
| contract_pay_rate | Double |  |
| contract_supplier_reference_code | String |  |
| contract_vendor_name | String |  |
| currency_code | String |  |
| currency_numeric_code | String |  |
| date_entered_workforce | LocalDate |  |
| days_unemployed | Double |  |
| display_language_code | String |  |
| eligible_for_hire | String |  |
| eligible_for_rehire_on_latest_termination | String |  |
| employee_compensation_currency | String |  |
| employee_compensation_frequency | String |  |
| employee_compensation_primary_compensation_basis | Double |  |
| employee_compensation_total_base_pay | Double |  |
| employee_compensation_total_salary_and_allowances | Double |  |
| end_employment_date | LocalDate |  |
| expected_date_of_return | LocalDate |  |
| expected_retirement_date | LocalDate |  |
| first_day_of_work | LocalDate |  |
| has_international_assignment | Boolean |  |
| hire_date | LocalDate |  |
| hire_reason | String |  |
| hire_reason_descriptor | String |  |
| hire_rescinded | Boolean |  |
| home_country | String |  |
| hour_clock_code | String |  |
| hourly_frequency_currency | String |  |
| hourly_frequency_frequency | String |  |
| hourly_frequency_primary_compensation_basis | Double |  |
| hourly_frequency_total_base_pay | Double |  |
| hourly_frequency_total_salary_and_allowances | Double |  |
| last_datefor_which_paid | LocalDate |  |
| local_termination_reason | String |  |
| locale_code | String |  |
| months_continuous_prior_employment | Double |  |
| not_returning | Boolean |  |
| original_hire_date | LocalDate |  |
| pay_group_frequency_currency | String |  |
| pay_group_frequency_frequency | String |  |
| pay_group_frequency_primary_compensation_basis | Double |  |
| pay_group_frequency_total_base_pay | Double |  |
| pay_group_frequency_total_salary_and_allowances | Double |  |
| pay_through_date | LocalDate |  |
| preferred_language_code | String |  |
| primary_termination_category | String |  |
| primary_termination_category_descriptor | String |  |
| primary_termination_reason | String |  |
| primary_termination_reason_descriptor | String |  |
| probation_end_date | LocalDate |  |
| probation_start_date | LocalDate |  |
| reason_reference_descriptor | String |  |
| reason_reference_id | String |  |
| regrettable_termination | Boolean |  |
| rehire | Boolean |  |
| resignation_date | LocalDate |  |
| retired | Boolean |  |
| retirement_date | LocalDate |  |
| retirement_eligibility_date | LocalDate |  |
| return_unknown | Boolean |  |
| seniority_date | LocalDate |  |
| severance_date | LocalDate |  |
| simplified_view | Boolean |  |
| terminated | Boolean |  |
| termination_date | LocalDate |  |
| termination_involuntary | Boolean |  |
| termination_last_day_of_work | LocalDate |  |
| time_off_service_date | LocalDate |  |
| time_zone_code | String |  |
| universal_id | String |  |
| user_id | String |  |
| user_language_code | String |  |
| user_name | String |  |
| vesting_date | LocalDate |  |
| worker_code | String |  |

### candidate_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| candidate_id | String | PK, FK |
| first_name | String |  |
| hereditary_suffix | String |  |
| last_name | String |  |
| middle_name | String |  |
| salutation_suffix | String |  |
| secondary_last_name | String |  |
| social_suffix | String |  |
| tertiary_last_name | String |  |
| title | String |  |
| local_** |  |  |

### job_requisition_role_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| organization_role_id | String | FK |
| effective_date | LocalDate |  |
| requisition_role_code | String |  |

### qualification_language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assessed_by | String | FK |
| assessed_on | LocalDate |  |
| language_code | String |  |
| native_language | Boolean |  |
| note | String |  |
| remove_language | Boolean |  |

### job_profile_restriction_job_family

| Column | Type | Keys |
| --- | --- | --- |
| job_family_id | String | PK, FK |
| job_profile_id | String | PK, FK |

### location_usage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| location_id | String | PK, FK |
| usage | String |  |

### payroll_line_related_calculation

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| payroll_id | String | PK, FK |
| payroll_line_index | Long | PK, FK |
| amount | Double |  |
| calculation_code | String |  |
| workday_calculation_code | String |  |

### worker_pay_group_assignment

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| worker_id | String | PK, FK |
| completed_on | Instant |  |
| effective_date | LocalDate |  |
| event_corrected | Boolean |  |
| event_rescinded | Boolean |  |
| original_pay_group | String |  |
| proposed_pay_group | String |  |

### job_requisition_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| external_career_site_secondary_questionnaire_id | String | FK |
| external_career_sites_questionnaire_id | String | FK |
| internal_career_site_questionnaire_id | String | FK |
| internal_career_site_secondary_questionnaire_id | String | FK |
| job_profile_id | String | FK |
| replacement_for_worker_id | String | FK |
| supervisory_organization_id | String | FK |
| academic_tenure_eligible | Boolean |  |
| additional_job_description | String |  |
| available_for_recruiting | Boolean |  |
| confidential_job_requisition | Boolean |  |
| do_not_send_to_recruiting_system | Boolean |  |
| employee_contract_type_code | String |  |
| inline_assessment_test_code | String |  |
| is_evergreen_job_requisition | Boolean |  |
| job_application_template_code | String |  |
| job_description | String |  |
| job_description_summary | String |  |
| job_posting_title | String |  |
| job_requisition_code | String |  |
| justification | String |  |
| position_time_type_code | String |  |
| position_worker_type_code | String |  |
| positions_allocated | Double |  |
| positions_available | Double |  |
| primary_job_posting_location_code | String |  |
| primary_location_code | String |  |
| recruiting_instruction_code | String |  |
| recruiting_start_date | LocalDate |  |
| referral_payment_plan_code | String |  |
| remote_type_code | String |  |
| scheduled_weekly_hours | Double |  |
| spotlight_job | Boolean |  |
| status_code | String |  |
| target_end_date | LocalDate |  |
| target_hire_date | LocalDate |  |
| work_shift_code | String |  |
| worker_type_code | String |  |

### compensation_future_payment_bonus_plan

| Column | Type | Keys |
| --- | --- | --- |
| bonus_plan_id | String | PK |
| compensation_plan_id | String | PK, FK |

### compensation_future_one_time_payment_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_plan_id | String | PK, FK |
| one_time_payment_plan_code | String |  |

### location_address_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| line_data | String |  |
| type | String |  |

### worker_costing_allocation_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| worker_costing_allocation_id | String | PK, FK |
| costing_override_code | String |  |
| end_date | LocalDate |  |
| start_date | LocalDate |  |

### position_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |
| skill_code | String |  |

### worker_position_compensation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| workers_compensation_code | String |  |

### organization_hierarchy_detail

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| linked_organization_id | String | PK, FK |
| organization_id | String | PK, FK |

### deferred_compensation_eligibility_rule

| Column | Type | Keys |
| --- | --- | --- |
| compensation_eligibility_rule_id | String | PK, FK |
| compensation_plan_id | String | PK, FK |

### learning_course_advanced_pricing_rule

| Column | Type | Keys |
| --- | --- | --- |
| order | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| price_in_training_credits | Double |  |
| price_rule_code | String |  |
| price_rule_id | String |  |

### position_commission_plan

| Column | Type | Keys |
| --- | --- | --- |
| commission_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| commission_plan_code | String |  |
| currency_code | String |  |
| draw_amount | Double |  |
| draw_duration | String |  |
| draw_frequency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| recoverable | Boolean |  |
| target_amount | Double |  |

### communication_usage

| Column | Type | Keys |
| --- | --- | --- |
| contact_type | String | PK |
| index | Long | PK |
| person_contact_id | String | PK |
| comment | String |  |
| is_primary | Boolean |  |
| usage_type | String |  |
| use_for | Json |  |
| use_for_tenanted | Json |  |
| visibility | String |  |

### benchmark_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| benchmark_job_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| currency | String |  |
| frequency | String |  |

### job_family_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| job_family_id | String | PK, FK |
| job_profile_id | String | PK, FK |

### job_requisition_competency

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| competency_code | String |  |
| proficiency_rating | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### organization_leader

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | String | PK, FK |
| organization_manager_id | String | PK, FK |

### organization_role_history

| Column | Type | Keys |
| --- | --- | --- |
| role_id | String | PK |
| organization_id | String | PK, FK |
| organization_role_code | String |  |

### position_competency

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| competency_code | String |  |
| proficiency_rating | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### additional_manager_goal_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### job_profile_compensation_grade_profile

| Column | Type | Keys |
| --- | --- | --- |
| compensation_grade_profile_id | String | PK, FK |
| job_profile_id | String | PK, FK |

### pre_hire_certification_achievement

| Column | Type | Keys |
| --- | --- | --- |
| certification_id | String | PK |
| pre_hire_id | String | PK, FK |
| certification_achievement_code | String |  |
| certification_name | String |  |
| certification_number | String |  |
| certification_ref_code | String |  |
| country_code | String |  |
| examination_date | LocalDate |  |
| examination_score | String |  |
| expiration_date | LocalDate |  |
| issued_date | LocalDate |  |
| issuer | String |  |
| removed | Boolean |  |

### worker_costing_allocation_detail

| Column | Type | Keys |
| --- | --- | --- |
| order_code | String | PK |
| worker_costing_allocation_id | String | PK, FK |
| worker_costing_allocation_interval_index | Long | PK, FK |
| costing_override_company_code | String |  |
| default_from_organization_assignment | Boolean |  |
| distribution_percent | Double |  |

### job_profile_responsibility

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| description | String |  |
| required | Boolean |  |

### job_profile_language

| Column | Type | Keys |
| --- | --- | --- |
| language_id | String | PK |
| job_profile_id | String | PK, FK |
| language_code | String |  |
| required | Boolean |  |

### worker_secondary_termination_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| worker_id | String | PK, FK |
| secondary_termination_reason | String |  |
| secondary_termination_reason_category | String |  |

### position_merit_plan

| Column | Type | Keys |
| --- | --- | --- |
| merit_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| guaranteed_minimum | Boolean |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| merit_plan_code | String |  |

### compensation_matrix

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_matrix_code | String |  |
| description | String |  |
| effective_date | LocalDate |  |
| name | String |  |
| rating_scale | String |  |

### payroll_custom_organization_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| organization_id | String | FK |
| custom_organization_reference_code | String |  |
| type_code | String |  |

### additional_manager_competency_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### calculated_time_block

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_profile_id | String | FK |
| worker_id | String | FK |
| business_unit_code | String |  |
| calculated_date | LocalDate |  |
| calculated_quantity | Double |  |
| cost_center_code | String |  |
| custom_organization_01 | String |  |
| custom_organization_02 | String |  |
| custom_organization_03 | String |  |
| custom_organization_04 | String |  |
| custom_organization_05 | String |  |
| custom_organization_06 | String |  |
| custom_organization_07 | String |  |
| custom_organization_08 | String |  |
| custom_organization_09 | String |  |
| custom_organization_10 | String |  |
| custom_worktag_01 | String |  |
| custom_worktag_02 | String |  |
| custom_worktag_03 | String |  |
| custom_worktag_04 | String |  |
| custom_worktag_05 | String |  |
| custom_worktag_06 | String |  |
| custom_worktag_07 | String |  |
| custom_worktag_08 | String |  |
| custom_worktag_09 | String |  |
| custom_worktag_10 | String |  |
| custom_worktag_11 | String |  |
| custom_worktag_12 | String |  |
| custom_worktag_13 | String |  |
| custom_worktag_14 | String |  |
| custom_worktag_15 | String |  |
| fund_code | String |  |
| gift_code | String |  |
| grant_code | String |  |
| in_time | Instant |  |
| is_deleted | Boolean |  |
| last_updated | Instant |  |
| location_code | String |  |
| out_time | Instant |  |
| program_code | String |  |
| region_code | String |  |
| shift_date | LocalDate |  |
| time_tracking_set_up_option_code | String |  |
| worker_time_block_code | String |  |

### job_family_job_family_group

| Column | Type | Keys |
| --- | --- | --- |
| job_family_group_id | String | PK, FK |
| job_family_id | String | PK, FK |

### personal_information_ethnicity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| country_personal_information_id | String | PK, FK |
| ethnicity_code | String |  |
| ethnicity_code_descriptor | String |  |

### payroll_local_school_district_authority_tax_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| payroll_local_school_district_authority_code | String |  |

### compensation_plan_eligibility_rule

| Column | Type | Keys |
| --- | --- | --- |
| compensation_eligibility_rule_id | String | PK, FK |
| compensation_plan_id | String | PK, FK |

### deferred_compensation_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| calculation_compensation | String |  |
| stock_plan | String |  |

### compensation_eligibility_rule_condition_category

| Column | Type | Keys |
| --- | --- | --- |
| condition_rule_category_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### worker_position_end_employment_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| end_employment_reason | String |  |

### person_contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_info_system_id | String | PK, FK |
| country_isocode | String |  |
| device_type | String |  |
| international_phone_code | String |  |
| phone_code | String |  |
| phone_extension | String |  |
| phone_number | String |  |

### additional_manager_responsibility_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### scorecard_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| scorecard_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |

### talent_pool_worker

| Column | Type | Keys |
| --- | --- | --- |
| talent_pool_id | String | PK, FK |
| worker_id | String | PK, FK |

### gender_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| code | String |  |
| description | String |  |
| gender_identity_id | String |  |
| inactive | Boolean |  |
| name | String |  |
| order | String |  |

### override_balance

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | FK |
| worker_id | String | FK |
| batch_code | String |  |
| comments | String |  |
| override_balance_date | LocalDate |  |
| override_balance_units | Double |  |
| time_off_plan_code | String |  |

### external_reference_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| candidate_id | String | FK |
| job_application_id | String | FK |
| job_requisition_id | String | FK |

### competency_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |
| weight | Double |  |

### job_requisition_default_assessment_test

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| default_assessment_test_code | String |  |

### location_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| location_code | String |  |

### job_profile_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| work_experience_id | String | PK |
| job_profile_id | String | PK, FK |
| required | Boolean |  |
| work_experience_code | String |  |
| work_experience_rating_code | String |  |
| work_experience_rating_id | String |  |

### job_applied_to

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| added_by_worker_id | String | FK |
| job_requisition_id | String | FK |
| applicant_source_code | String |  |
| application_date | Instant |  |
| disability_status | String |  |
| disability_status_last_updated_on | LocalDate |  |
| ethnicity | Json |  |
| gender | String |  |
| hispanic_or_latino | Boolean |  |
| recruiting_disposition_code | String |  |
| recruiting_stage_code | String |  |
| skills_match_score_code | String |  |
| status_timestamp | Instant |  |
| veterans_status | Json |  |
| workflow_step_code | String |  |

### time_off_plan_balance_position

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| time_off_plan_balance_id | String | PK, FK |
| worker_id | String | PK, FK |
| position_id | String | FK |
| time_off_plan_balance | Double |  |

### compensation_matrix_target_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| compensation_matrix_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |

### worker_period_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| compensation_period_multiplier | Double |  |
| currency_code | String |  |
| frequency_code | String |  |
| period_salary_plan_code | String |  |

### location_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| location_id | String | PK, FK |
| type | String |  |

### time_off_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| comment | String |  |
| position_descriptor | String |  |
| position_href | String |  |
| position_id | String |  |
| quantity | Double |  |
| reason_descriptor | String |  |
| reason_href | String |  |
| reason_id | String |  |
| status_descriptor | String |  |
| status_href | String |  |
| status_id | String |  |
| time_off_date | LocalDate |  |
| time_off_type_descriptor | String |  |
| time_off_type_href | String |  |
| time_off_type_id | String |  |
| unit_descriptor | String |  |
| unit_href | String |  |
| unit_id | String |  |
| worker_descriptor | String |  |
| worker_href | String |  |
| worker_id | String |  |

### compensation_merit_plan_replacement_percent

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| compensation_basis | String |  |
| percentage | Double |  |

### compensation_grade

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_plan_id | String | FK |
| compensation_grade_code | String |  |
| currency_code | String |  |
| description | String |  |
| effective_date | LocalDate |  |
| frequency_code | String |  |
| inactive | Boolean |  |
| is_first_step_during_compensation_proposal_assigned | Boolean |  |
| is_override_allowed | Boolean |  |
| maximum | Double |  |
| midpoint | Double |  |
| minimum | Double |  |
| name | String |  |
| number_of_segments | Double |  |
| pay_level | String |  |
| segment_1_top | Double |  |
| segment_2_top | Double |  |
| segment_3_top | Double |  |
| segment_4_top | Double |  |
| segment_5_top | Double |  |
| spread | Double |  |

### employee_review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| manager_id | String | FK |
| worker_id | String | FK |
| completed | Boolean |  |
| employee_review_template_code | String |  |
| initiation_date | Instant |  |
| review_code | String |  |
| review_period_end_date | LocalDate |  |
| review_period_start_date | LocalDate |  |

### interview

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| overall_comment | String |  |
| time_zone_code | String |  |

### job_family

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| effective_date | LocalDate |  |
| inactive | Boolean |  |
| job_family_code | String |  |
| job_family_short_code | String |  |
| summary | String |  |

### job_requisition_additional_location_history

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| job_requisition_id | String | PK, FK |
| location_code | String |  |

### job_profile_classification

| Column | Type | Keys |
| --- | --- | --- |
| job_classification_id | String | PK, FK |
| job_profile_id | String | PK, FK |

### candidate_social_media_account

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| candidate_id | String | PK, FK |
| social_network_type_code | String |  |
| url | String |  |
| user_name | String |  |

### job_requisition_education

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| degree | String |  |
| field_of_study | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### job_profile_competency

| Column | Type | Keys |
| --- | --- | --- |
| competency_id | String | PK |
| job_profile_id | String | PK, FK |
| competency_code | String |  |
| proficiency_rating | String |  |
| required | Boolean |  |

### accomplishment_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| accomplishment | String |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |
| weight | Double |  |

### payroll_line_withholding

| Column | Type | Keys |
| --- | --- | --- |
| payroll_id | String | PK, FK |
| payroll_line_index | Long | PK, FK |
| begin_date | LocalDate |  |
| case_number | String |  |
| deduction_recepient | String |  |
| deduction_recepient_bank_account | String |  |
| end_date | LocalDate |  |
| memo | String |  |
| order_date | LocalDate |  |
| order_priority | Double |  |
| order_status | String |  |
| order_type | String |  |
| originating_entity | String |  |
| pay_frequency | String |  |
| pay_period_amount | Double |  |
| pay_period_amount_type | String |  |
| pay_period_percent | Double |  |
| received_date | LocalDate |  |
| tax_authority | String |  |
| total_debt | Double |  |

### compensation_allowance_plan_amount_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| amount | Double |  |
| currency | String |  |

### worker_stock_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| compensation_matrix_code | String |  |
| currency_code | String |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| individual_target_shares | Double |  |
| percent_of_target_as_option | Double |  |
| percent_of_target_as_stock | Double |  |
| stock_plan_code | String |  |
| target_amount | Double |  |
| target_percent | Double |  |
| target_shares | Double |  |
| vesting_schedule_code | String |  |

### additional_manager_development_item_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### company_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| company_id | String | FK |
| organization_id | String | FK |

### job_requisition_stock_plan

| Column | Type | Keys |
| --- | --- | --- |
| stock_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| compensation_basis_override_amount | Double |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| individual_target_shares | Double |  |
| stock_plan_code | String |  |

### position_allowance_plan

| Column | Type | Keys |
| --- | --- | --- |
| allowance_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| allowance_plan_code | String |  |
| amount | Double |  |
| compensation_basis_override_amount | Double |  |
| currency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| percent | Double |  |
| reimbursement_start_date | LocalDate |  |

### position_job_profile_history

| Column | Type | Keys |
| --- | --- | --- |
| job_profile_id | String | PK |
| position_id | String | PK, FK |
| difficulty_to_fill_code | String |  |
| is_critical_job | Boolean |  |
| job_category_code | String |  |
| management_level_code | String |  |
| management_level_descriptor | String |  |
| name | String |  |
| work_shift_required | Boolean |  |

### pre_hire_language_achievement

| Column | Type | Keys |
| --- | --- | --- |
| language_id | String | PK |
| pre_hire_id | String | PK, FK |
| assessed_by | String | FK |
| assessed_on | LocalDate |  |
| is_native_language | Boolean |  |
| language_code | String |  |
| note | String |  |
| removed | Boolean |  |

### worker_document_field_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| integration_document_field | String | PK |
| worker_id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| value | String |  |

### candidate

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| added_by_worker_id | String | FK |
| candidate_owner_worker_id | String | FK |
| pre_hire_id | String | FK |
| referred_by_worker_id | String | FK |
| worker_id | String | FK |
| address_line_1 | String |  |
| address_line_1_local | String |  |
| address_line_2 | String |  |
| address_line_2_local | String |  |
| address_line_3 | String |  |
| address_line_3_local | String |  |
| address_line_4 | String |  |
| address_line_4_local | String |  |
| address_line_5 | String |  |
| address_line_5_local | String |  |
| address_line_6 | String |  |
| address_line_6_local | String |  |
| address_line_7 | String |  |
| address_line_8 | String |  |
| address_line_9 | String |  |
| applicant_source | String |  |
| candidate_code | String |  |
| city | String |  |
| city_code | String |  |
| confidential | Boolean |  |
| country_code | String |  |
| country_region_code | String |  |
| do_not_hire | Boolean |  |
| email_address | String |  |
| management_level_code | String |  |
| ownership_end_date | Instant |  |
| ownership_start_date | Instant |  |
| phone_country_code | String |  |
| phone_device_type_code | String |  |
| phone_extension | String |  |
| phone_number | String |  |
| postal_code | String |  |
| prospect | Boolean |  |
| prospect_status_code | String |  |
| prospect_type_code | String |  |
| referral_consent_given | Boolean |  |
| region_subdivision_1 | String |  |
| region_subdivision_1_local | String |  |
| region_subdivision_2 | String |  |
| user_language_code | String |  |
| withdrawn | Boolean |  |

### job_profile_company_insider

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| company_insider_type | String |  |

### worker_bonus_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| assignment_effective_date | LocalDate |  |
| bonus_plan_code | String |  |
| compensation_element_code | String |  |
| currency_code | String |  |
| default_target_amount | Double |  |
| default_target_percent | Double |  |
| frequency_code | String |  |
| guaranteed_minimum | Boolean |  |
| individual_target_amount | Double |  |
| individual_target_percent | Double |  |
| percent_assigned | Double |  |

### compensation_commission_plan_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| amount | Double |  |
| currency | String |  |
| draw_amount | Double |  |

### job_requisition_calculated_plan

| Column | Type | Keys |
| --- | --- | --- |
| calculated_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| amount_override | Double |  |
| calculated_plan_code | String |  |
| currency_code | String |  |
| frequency_code | String |  |

### feedback_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### job_requisition_organization_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_id | String | PK, FK |
| company_id | String | FK |
| cost_center_id | String | FK |
| region_id | String | FK |
| business_unit_code | String |  |
| fund_code | String |  |
| gift_code | String |  |
| grant_code | String |  |
| program_code | String |  |

### compensation_bonus_plan_performance_factor_scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_plan_id | String | PK, FK |
| bonus_modifier | String |  |
| performance_scorecard_code | String |  |
| weight | Double |  |

### position_certification_specialty

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| position_certification_id | String | PK, FK |
| specialty | String |  |
| sub_specialty | Json |  |

### job_requisition_language_ability

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_language_id | String | PK, FK |
| language_ability_type | String |  |
| language_proficiency | String |  |

### questionnaire_setup

| Column | Type | Keys |
| --- | --- | --- |
| questionnaire_setup_id | String | PK |
| questionnaire_id | String | PK, FK |
| order | String |  |
| question_description | String |  |
| required | Boolean |  |

### qualification_certification_attachment

| Column | Type | Keys |
| --- | --- | --- |
| file_name | String | PK |
| certification_code | String | PK, FK |
| certification_id | String | PK, FK |
| worker_id | String | PK, FK |
| comment | String |  |
| content_type | String |  |
| document_category_code | String |  |
| file | String |  |

### organization_document_field_result

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| organization_id | String | PK, FK |
| value | String |  |

### payroll

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| employee_id | String | FK |
| account_number | String |  |
| currency | String |  |
| establishment | String |  |
| for_additional_pay | Boolean |  |
| gross_amount | Double |  |
| net_amount | Double |  |
| off_cycle_type | String |  |
| original_payment_date | LocalDate |  |
| pay_group | String |  |
| pay_period_frequency | Double |  |
| payment_date | LocalDate |  |
| payroll_code | String |  |
| period | String |  |
| period_end | LocalDate |  |
| period_start | LocalDate |  |
| result_completed_date | Instant |  |
| run_category | String |  |
| subperiod_end | LocalDate |  |
| subperiod_start | LocalDate |  |

### compensation_grade_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| compensation_grade_id | String | PK, FK |
| compensation_plan_id | String | FK |
| compensation_grade_profile_code | String |  |
| currency_code | String |  |
| description | String |  |
| effective_date | LocalDate |  |
| frequency_code | String |  |
| inactive | Boolean |  |
| is_override_allowed | Boolean |  |
| maximum | Double |  |
| midpoint | Double |  |
| minimum | Double |  |
| name | String |  |
| number_of_segments | Double |  |
| segment_1_top | Double |  |
| segment_2_top | Double |  |
| segment_3_top | Double |  |
| segment_4_top | Double |  |
| segment_5_top | Double |  |
| spread | Double |  |

### learning_course_other_unit_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| code | String |  |
| other_unit_value | Double |  |

### candidate_website

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| candidate_id | String | PK, FK |
| url | String |  |

### development_item_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |

### applicant_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| applicant_id | String | PK, FK |
| value | String |  |

### worker_position

| Column | Type | Keys |
| --- | --- | --- |
| position_id | String | PK |
| worker_id | String | PK, FK |
| job_family_id | String | FK |
| job_profile_id | String | FK |
| business_title | String |  |
| critical_job | Boolean |  |
| default_weekly_hours | Double |  |
| difficulty_to_fill | String |  |
| effective_date | LocalDate |  |
| employee_type | String |  |
| end_date | LocalDate |  |
| end_employment_date | LocalDate |  |
| exclude_from_head_count | Boolean |  |
| expected_assignment_end_date | LocalDate |  |
| external_employee | String |  |
| federal_withholding_fein | String |  |
| frequency | String |  |
| full_time_equivalent_percentage | Double |  |
| headcount_restriction_code | String |  |
| home_country | String |  |
| host_country | String |  |
| international_assignment_type | String |  |
| is_primary_job | Boolean |  |
| job_exempt | Boolean |  |
| management_level_code | String |  |
| management_level_descriptor | String |  |
| paid_fte | Double |  |
| pay_group | String |  |
| pay_rate | String |  |
| pay_rate_type | String |  |
| pay_through_date | LocalDate |  |
| payroll_entity | String |  |
| payroll_file_number | String |  |
| position_code | String |  |
| position_time_type | String |  |
| position_title | String |  |
| position_worker_type | String |  |
| regular_paid_equivalent_hours | Double |  |
| scheduled_weekly_hours | Double |  |
| specify_paid_fte | Boolean |  |
| specify_working_fte | Boolean |  |
| start_date | LocalDate |  |
| start_international_assignment_reason | String |  |
| work_hours_profile | String |  |
| work_shift | String |  |
| work_shift_required | Boolean |  |
| work_space | String |  |
| worker_hours_profile_classification | String |  |
| worker_type | String |  |
| working_fte | Double |  |
| working_time_frequency | String |  |
| working_time_unit | String |  |
| working_time_value | Double |  |
| academic_pay_setup_data_** |  |  |
| business_site_summary_** |  |  |

### career_interest_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| career_interest | String |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| reference_code | String |  |

### review_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| initiated_by_employee | Boolean |  |
| initiated_for_employee | Boolean |  |
| name | String |  |
| review_category_code | String |  |
| type_code | String |  |
| used_by_templates_count | Int |  |

### payroll_deduction_instant_messenger

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| payroll_id | String | PK, FK |
| payroll_line_index | Long | PK, FK |
| instant_messenger_id | String |  |

### position_job_family

| Column | Type | Keys |
| --- | --- | --- |
| job_family_id | String | PK |
| position_id | String | PK, FK |

### job_requisition_training

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| description | String |  |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |
| training_type | String |  |

### worker_position_payroll_reporting_code_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| payroll_reporting_id | String | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| formatted_code | String |  |
| name | String |  |
| payroll_reporting_code | String |  |
| payroll_reporting_type | String |  |

### compensation_eligibility_compensation_grade_profile

| Column | Type | Keys |
| --- | --- | --- |
| compensation_grade_profile_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### job_requisition_unit_salary_plan

| Column | Type | Keys |
| --- | --- | --- |
| unit_salary_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| currency_code | String |  |
| default_units | Double |  |
| frequency_code | String |  |
| per_unit_amount | Double |  |
| unit_salary_plan_code | String |  |

### payroll_custom_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| worktag_code | String |  |
| worktag_type | String |  |

### additional_manager_goal_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### personal_information_pronoun

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_information_common_id | String | PK, FK |
| pronoun_code | String |  |

### assess_talent_nomination

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| worker_id | String | PK, FK |
| job_profile_id | String | FK |
| succession_readiness_code | String |  |

### job_requisition

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| external_career_site_secondary_questionnaire_id | String | FK |
| external_career_sites_questionnaire_id | String | FK |
| internal_career_site_questionnaire_id | String | FK |
| internal_career_site_secondary_questionnaire_id | String | FK |
| job_profile_id | String | FK |
| replacement_for_worker_id | String | FK |
| supervisory_organization_id | String | FK |
| academic_tenure_eligible | Boolean |  |
| additional_job_description | String |  |
| available_for_recruiting | Boolean |  |
| confidential_job_requisition | Boolean |  |
| do_not_send_to_recruiting_system | Boolean |  |
| employee_contract_type_code | String |  |
| inline_assessment_test_code | String |  |
| is_evergreen_job_requisition | Boolean |  |
| job_application_template_code | String |  |
| job_description | String |  |
| job_description_summary | String |  |
| job_posting_title | String |  |
| job_requisition_code | String |  |
| justification | String |  |
| position_time_type_code | String |  |
| position_worker_type_code | String |  |
| positions_allocated | Double |  |
| positions_available | Double |  |
| primary_job_posting_location_code | String |  |
| primary_location_code | String |  |
| recruiting_instruction_code | String |  |
| recruiting_start_date | LocalDate |  |
| referral_payment_plan_code | String |  |
| remote_type_code | String |  |
| scheduled_weekly_hours | Double |  |
| spotlight_job | Boolean |  |
| status_code | String |  |
| target_end_date | LocalDate |  |
| target_hire_date | LocalDate |  |
| work_shift_code | String |  |
| worker_type_code | String |  |

### position_location_history

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| position_id | String | PK, FK |
| location_code | String |  |

### learning_course_offering_lesson

| Column | Type | Keys |
| --- | --- | --- |
| order | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| external_content_description | String |  |
| external_content_learning_course_lesson_title | String |  |
| external_content_url | String |  |
| instructor_led_lesson_ad_hoc_location_address | String |  |
| instructor_led_lesson_ad_hoc_location_name | String |  |
| instructor_led_lesson_ad_hoc_location_room | String |  |
| instructor_led_lesson_ad_hoc_location_time_zone_code | String |  |
| instructor_led_lesson_ad_hoc_location_time_zone_id | String |  |
| instructor_led_lesson_course_title | String |  |
| instructor_led_lesson_course_title_code | String |  |
| instructor_led_lesson_course_title_id | String |  |
| instructor_led_lesson_description | String |  |
| instructor_led_lesson_end_date | LocalDate |  |
| instructor_led_lesson_grade_scheme_code | String |  |
| instructor_led_lesson_grade_scheme_id | String |  |
| instructor_led_lesson_instructor_code | Json |  |
| instructor_led_lesson_location_code | String |  |
| instructor_led_lesson_location_id | String |  |
| instructor_led_lesson_start_date | LocalDate |  |
| instructor_led_lesson_unit_track_attendance | Boolean |  |
| instructor_led_lesson_unit_track_grades | Boolean |  |
| media_code | String |  |
| media_content_description | String |  |
| media_id | String |  |
| media_learning_course_lesson_title | String |  |
| media_learning_workdrive_content_id | String |  |
| media_provide_course_grade | Boolean |  |
| required_learning_course_content | Boolean |  |
| survey_code | String |  |
| survey_description | String |  |
| survey_id | String |  |
| training_activity_grading_scheme_code | String |  |
| training_activity_grading_scheme_id | String |  |
| training_activity_type_id | String |  |
| training_activity_unit_track_attendance | Boolean |  |
| training_activity_unit_track_grades | Boolean |  |
| training_course_assessors | Json |  |
| training_course_lesson_code | String |  |
| training_course_lesson_id | String |  |
| training_course_lesson_title | String |  |
| training_details | String |  |
| webinar_end_date | LocalDate |  |
| webinar_grade_scheme_code | String |  |
| webinar_grade_scheme_id | String |  |
| webinar_instructor_code | Json |  |
| webinar_lesson_code | String |  |
| webinar_lesson_description | String |  |
| webinar_lesson_id | String |  |
| webinar_lesson_title | String |  |
| webinar_start_date | LocalDate |  |
| webinar_time_zone_code | String |  |
| webinar_time_zone_id | String |  |
| webinar_virtual_classroom_additional_information | String |  |
| webinar_virtual_classroom_integration_system_code | String |  |
| webinar_virtual_classroom_integration_system_id | String |  |
| webinar_virtual_classroom_login_details | String |  |
| webinar_virtual_classroom_password | String |  |
| webinar_virtual_classroom_unit_track_attendance | Boolean |  |
| webinar_virtual_classroom_unit_track_grades | Boolean |  |
| webinar_virtual_classroom_url | String |  |

### personal_information_common_data

| Column | Type | Keys |
| --- | --- | --- |
| fivetran_id | String | PK |
| worker_id | String | PK, FK |
| additional_nationality_code | Json |  |
| blood_type | String |  |
| citizenship_status | Json |  |
| city_of_birth | String |  |
| city_of_birth_code | String |  |
| country_of_birth | String |  |
| country_region_of_birth | String |  |
| date_of_birth | LocalDate |  |
| date_of_death | LocalDate |  |
| last_medical_exam_date | LocalDate |  |
| last_medical_exam_valid_to | LocalDate |  |
| medical_exam_notes | String |  |
| primary_nationality | String |  |
| region_of_birth | String |  |

### position_training

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| description | String |  |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |
| training_type | String |  |

### benchmark_job_and_job_profile

| Column | Type | Keys |
| --- | --- | --- |
| benchmark_job_id | String | PK, FK |
| job_profile_id | String | PK, FK |

### worker_document_field

| Column | Type | Keys |
| --- | --- | --- |
| integration_document_field | String | PK |
| worker_id | String | PK, FK |
| value | String |  |

### salary_over_the_cap_costing_allocation_detail

| Column | Type | Keys |
| --- | --- | --- |
| soc_order | String | PK |
| order_code | String | PK, FK |
| worker_costing_allocation_id | String | PK, FK |
| worker_costing_allocation_interval_index | Long | PK, FK |
| soc_costing_override_company_code | String |  |
| soc_default_from_organization_assignment | Boolean |  |
| soc_distribution_percent | Double |  |
| soc_override_worktag_codes | Json |  |

### position_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| position_id | String | PK, FK |
| location_code | String |  |

### location_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| superior_organization_id | String | PK |
| location_id | String | PK, FK |
| organization_reference_id | String |  |

### job_classification

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| group_id | String | PK, FK |
| description | String |  |
| inactive | Boolean |  |
| job_classification_code | String |  |

### compensation_eligibility_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| comment | String |  |
| compensation_eligibilty_code | String |  |
| description | String |  |
| effective_date | LocalDate |  |

### overall_evaluation

| Column | Type | Keys |
| --- | --- | --- |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_overall_rating_override | Double |  |
| employee_review_rating_code | String |  |
| manager_comment | String |  |
| manager_overall_rating_override | Double |  |
| manager_review_rating_code | String |  |

### cell_target_percentage

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| calibration_program_id | String | PK, FK |
| nbox_view_column_code | String |  |
| nbox_view_column_id | String |  |
| nbox_view_row_code | String |  |
| nbox_view_row_id | String |  |
| target_percentage | Double |  |

### interview_competency

| Column | Type | Keys |
| --- | --- | --- |
| competency_id | String | PK |
| interview_session_detail_id | Long | PK, FK |
| interview_session_id | String | PK, FK |
| competency_code | String |  |

### organization_job_family

| Column | Type | Keys |
| --- | --- | --- |
| job_family_id | String | PK, FK |
| organization_id | String | PK, FK |
| job_family_group_id | String | FK |

### person_disability

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| country_personal_information_id | String | PK, FK |
| accommodations_provided | String |  |
| accommodations_requested | String |  |
| certification_authority | String |  |
| certification_authority_code | String |  |
| certification_basis_code | String |  |
| certification_code | String |  |
| certified_at | String |  |
| code | String |  |
| date_known | LocalDate |  |
| degree | Double |  |
| end_date | LocalDate |  |
| fte_toward_quota | Double |  |
| grade | String |  |
| note | String |  |
| rehabilitation_provided | String |  |
| rehabilitation_requested | String |  |
| remaining_capacity | Double |  |
| severity_recognition_date | LocalDate |  |
| status | String |  |
| status_date | LocalDate |  |
| work_restrictions | String |  |
| worker_document_ids | Json |  |

### position_language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| language_code | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### benchmark_job_composite

| Column | Type | Keys |
| --- | --- | --- |
| benchmark_composite_category_id | String | PK |
| benchmark_job_id | String | PK, FK |
| category_type | String |  |
| target_percentile | String |  |
| target_spread | Double |  |

### compensation_period_plan_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| compensation_basis | String |  |
| default_compensation_multiplier | Double |  |

### payroll_national_id

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| verified_by | String | FK |
| country | String |  |
| expiration_date | LocalDate |  |
| issued_date | LocalDate |  |
| issuing_agency | String |  |
| series | String |  |
| type | String |  |
| verification_date | LocalDate |  |

### job_requisition_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_requisition_id | String | PK, FK |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |
| skill_code | String |  |

### worker_position_organization_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| index | Long | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| organization_id | String | FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| date_of_pay_group_assignment | LocalDate |  |
| organization_type_code | String |  |
| organization_type_id | String |  |
| primary_business_site | String |  |
| used_in_change_organization_assignments | Boolean |  |

### candidate_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| skill_code | String |  |
| skill_name | String |  |

### job_profile_education

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| degree_code | String |  |
| field_of_study | String |  |
| required | Boolean |  |

### additional_manager_development_item_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### linked_job_requisition

| Column | Type | Keys |
| --- | --- | --- |
| job_requisition_id | String | PK, FK |
| linked_job_requisition_id | String | PK, FK |

### worker_position_payroll_reporting_code

| Column | Type | Keys |
| --- | --- | --- |
| payroll_reporting_id | String | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| formatted_code | String |  |
| name | String |  |
| payroll_reporting_code | String |  |
| payroll_reporting_type | String |  |

### absence_input

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | FK |
| worker_id | String | FK |
| absence_component_code | String |  |
| absence_input_code | String |  |
| adjustment | Boolean |  |
| batch_code | String |  |
| comment | String |  |
| end_date | LocalDate |  |
| hours | Double |  |
| reference_date | LocalDate |  |
| start_date | LocalDate |  |

### worker_costing_allocation_detail_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| order_code | String | PK, FK |
| worker_costing_allocation_id | String | PK, FK |
| worker_costing_allocation_interval_index | Long | PK, FK |
| code | Json |  |

### calibration_value_map

| Column | Type | Keys |
| --- | --- | --- |
| nbox_axis_segment_id | String | PK |
| calibration_program_id | String | PK, FK |
| calibration_value_id | String |  |
| nbox_axis_segment_code | String |  |

### compensation_eligibility_compensation_grade

| Column | Type | Keys |
| --- | --- | --- |
| compensation_grade_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### address_subregion

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| subregion_data | String |  |
| type | String |  |

### position

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supervisory_organization_id | String | FK |
| worker_for_filled_position_id | String | FK |
| academic_tenure_eligible | Boolean |  |
| availability_date | LocalDate |  |
| available_for_hire | Boolean |  |
| available_for_overlap | Boolean |  |
| available_for_recruiting | Boolean |  |
| closed | Boolean |  |
| compensation_grade_code | String |  |
| compensation_grade_profile_code | String |  |
| compensation_package_code | String |  |
| compensation_step_code | String |  |
| critical_job | Boolean |  |
| difficulty_to_fill_code | String |  |
| earliest_hire_date | LocalDate |  |
| earliest_overlap_date | LocalDate |  |
| effective_date | LocalDate |  |
| hiring_freeze | Boolean |  |
| job_description | String |  |
| job_description_summary | String |  |
| job_posting_title | String |  |
| position_code | String |  |
| position_time_type_code | String |  |
| primary_compensation_basis | Double |  |
| primary_compensation_basis_amount_change | Double |  |
| primary_compensation_basis_percent_change | Double |  |
| work_shift_required | Boolean |  |
| worker_position_id | String |  |
| worker_type_code | String |  |

### compensation_stock_plan_percent_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| compensation_plan_id | String | PK, FK |
| compensation_eligibility_rule_id | String | FK |
| calculation_compensation | String |  |
| compensation_basis | String |  |
| target_percent | Double |  |

### learning_lesson_language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_lesson_id | String | PK, FK |
| code | String |  |

### address_submunicipality

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| submunicipality_data | String |  |
| type | String |  |

### job_profile_restrict_to_country

| Column | Type | Keys |
| --- | --- | --- |
| country_id | String | PK |
| job_profile_id | String | PK, FK |
| country_code | String |  |

### worker_position_job_classification_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| job_classification_id | String | PK, FK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| as_of_effective_date | Instant |  |
| job_group_code | String |  |

### job_profile_pay_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| country_code | String |  |
| pay_rate_code | String |  |

### pre_hire_training_achievement

| Column | Type | Keys |
| --- | --- | --- |
| training_id | String | PK |
| pre_hire_id | String | PK, FK |
| completion_date | LocalDate |  |
| description | String |  |
| duration | String |  |
| removed | Boolean |  |
| training | String |  |
| training_code | String |  |

### qualification_speciality_achievement

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| certification_code | String | PK, FK |
| certification_id | String | PK, FK |
| worker_id | String | PK, FK |
| end_date | LocalDate |  |
| speciality_code | String |  |
| start_date | LocalDate |  |
| sub_speciality_codes | Json |  |

### job_requisition_certification_subspecialty

| Column | Type | Keys |
| --- | --- | --- |
| sub_specialty_id | String | PK |
| job_requisition_certification_id | String | PK, FK |
| job_requisition_certification_specialty_id | Long | PK, FK |
| sub_specialty_code | String |  |

### pre_hire_education

| Column | Type | Keys |
| --- | --- | --- |
| education_id | String | PK |
| pre_hire_id | String | PK, FK |
| country_code | String |  |
| date_degree_received | LocalDate |  |
| degree_code | String |  |
| degree_completed_code | String |  |
| education_qualification_code | String |  |
| field_of_study_code | String |  |
| first_day_attended | LocalDate |  |
| first_year_attended | LocalDate |  |
| grade_average | String |  |
| is_highest_level_of_education | Boolean |  |
| last_day_attended | LocalDate |  |
| last_year_attended | LocalDate |  |
| location | String |  |
| removed | Boolean |  |
| school_name | String |  |
| school_type_code | String |  |

### employee_probation_period_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |
| effective_date | LocalDate |  |
| employee_probation_period_code | String |  |
| end_date | LocalDate |  |
| extended_end_date | LocalDate |  |
| note | String |  |
| probation_reason | String |  |
| probation_type | String |  |
| start_date | LocalDate |  |

### qualification_certification

| Column | Type | Keys |
| --- | --- | --- |
| certification_code | String | PK |
| certification_id | String | PK |
| worker_id | String | PK, FK |
| certification_name | String |  |
| certification_number | String |  |
| country_code | String |  |
| examination_date | LocalDate |  |
| examination_score | String |  |
| expiration_date | LocalDate |  |
| issued_date | LocalDate |  |
| issuer | String |  |
| removed | Boolean |  |

### scorecard_profile_goal

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| scorecard_profile_id | String | PK, FK |
| description | String |  |
| name | String |  |
| weight | Double |  |

### worker_leave_status

| Column | Type | Keys |
| --- | --- | --- |
| leave_request_event_id | String | PK |
| worker_id | String | PK, FK |
| adoption_notification_date | LocalDate |  |
| adoption_placement_date | LocalDate |  |
| age_of_dependent | Double |  |
| benefits_effect | Boolean |  |
| caesarean_section_birth | Boolean |  |
| child_birth_date | LocalDate |  |
| child_sdate_of_death | LocalDate |  |
| continuous_service_accrual_effect | Boolean |  |
| date_baby_arrived_home_from_hospital | LocalDate |  |
| date_child_entered_country | LocalDate |  |
| date_of_recall | LocalDate |  |
| description | String |  |
| estimated_leave_end_date | LocalDate |  |
| expected_due_date | LocalDate |  |
| first_day_of_work | LocalDate |  |
| last_date_for_which_paid | LocalDate |  |
| leave_end_date | LocalDate |  |
| leave_entitlement_override | Double |  |
| leave_last_day_of_work | LocalDate |  |
| leave_of_absence_type | String |  |
| leave_percentage | Double |  |
| leave_return_event | String |  |
| leave_start_date | LocalDate |  |
| leave_status_code | String |  |
| leave_type_reason | String |  |
| location_during_leave | String |  |
| multiple_child_indicator | Boolean |  |
| number_of_babies_adopted_children | Double |  |
| number_of_child_dependents | Double |  |
| number_of_previous_births | Double |  |
| number_of_previous_maternity_leaves | Double |  |
| on_leave | Boolean |  |
| paid_time_off_accrual_effect | Boolean |  |
| payroll_effect | Boolean |  |
| single_parent_indicator | Boolean |  |
| social_security_disability_code | String |  |
| stillbirth_baby_deceased | Boolean |  |
| stock_vesting_effect | Boolean |  |
| stop_payment_date | LocalDate |  |
| week_of_confinement | LocalDate |  |
| work_related | Boolean |  |

### goal_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| actual_amount | Double |  |
| actual_percent | Double |  |
| actual_unit_value | Double |  |
| archived | Boolean |  |
| component_completion_code | String |  |
| description | String |  |
| due_date | LocalDate |  |
| employee_comment | String |  |
| employee_proficiency_rating_code | String |  |
| employee_review_rating_code | String |  |
| goal | String |  |
| goal_category_code | String |  |
| goal_completion_date | LocalDate |  |
| goal_currency_code | String |  |
| goal_targets_and_actuals_amount_id | String |  |
| goal_targets_and_actuals_percent_id | String |  |
| goal_unit_code | String |  |
| manager_comment | String |  |
| manager_proficiency_rating_code | String |  |
| manager_review_rating_code | String |  |
| maximum_amount | Double |  |
| maximum_percent | Double |  |
| maximum_unit_value | Double |  |
| minimum_amount | Double |  |
| minimum_percent | Double |  |
| minimum_unit_value | Double |  |
| organization_goal_code | String |  |
| reference_code | String |  |
| relates_to_competency_code | String |  |
| target_amount | Double |  |
| target_percent | Double |  |
| target_unit_value | Double |  |
| weight | Double |  |

### cost_center_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| cost_center_id | String | FK |
| organization_id | String | FK |

### compensation_eligibility_rule_countries

| Column | Type | Keys |
| --- | --- | --- |
| country_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### job_requisition_pay_plan

| Column | Type | Keys |
| --- | --- | --- |
| pay_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| amount | Double |  |
| amount_change | Double |  |
| currency_code | String |  |
| expected_end_date | LocalDate |  |
| frequency_code | String |  |
| pay_plan_code | String |  |
| percent_change | Double |  |

### learning_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| attendance_duration | Double |  |
| attendance_status_code | String |  |
| attendance_status_id | String |  |
| content_code | String |  |
| content_id | String |  |
| content_numeric_version | Double |  |
| course_offering_code | String |  |
| course_vendor_code | String |  |
| expiration_date | LocalDate |  |
| grade_code | String |  |
| grade_id | String |  |
| learner_code | String |  |
| learner_id | String |  |
| learning_enrollment_code | String |  |
| learning_enrollment_completion_date | Instant |  |
| manual_expiration_override | Boolean |  |
| overall_course_score | Double |  |
| registered_date | Instant |  |
| rescind_enrollment | Boolean |  |
| time_unit_code | String |  |
| time_unit_id | String |  |
| version_label | String |  |

### learning_course_contact_person

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| contingent_worker_code | String |  |
| employee_code | String |  |

### job_profile_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_profile_id | String | PK, FK |
| name | String |  |
| required | Boolean |  |
| skill_code | String |  |

### candidate_experience

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| company_code | String |  |
| company_name | String |  |
| currently_work_here | Boolean |  |
| description | String |  |
| end_month | Int |  |
| end_year | Int |  |
| location | String |  |
| start_month | Int |  |
| start_year | Int |  |
| title | String |  |

### qualification_education

| Column | Type | Keys |
| --- | --- | --- |
| education_id | String | PK |
| education_qualification_code | String | PK |
| worker_id | String | PK, FK |
| country_code | String |  |
| date_degree_received | LocalDate |  |
| degree_code | String |  |
| degree_completed_code | String |  |
| field_of_study_code | String |  |
| first_day_attended | LocalDate |  |
| first_year_attended | LocalDate |  |
| grade_average | String |  |
| is_highest_level_of_education | Boolean |  |
| last_day_attended | LocalDate |  |
| last_year_attended | LocalDate |  |
| location | String |  |
| removed | Boolean |  |
| school_code | String |  |
| school_name | String |  |
| school_type_code | String |  |

### qualification_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | PK, FK |
| experience_comment | String |  |
| experience_rating_code | String |  |
| remove_experience | Boolean |  |
| work_experience_code | String |  |

### position_language_ability

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| position_language_id | String | PK, FK |
| language_ability_type | String |  |
| language_proficiency | String |  |

### interview_questionnaire

| Column | Type | Keys |
| --- | --- | --- |
| interview_session_detail_id | Long | PK, FK |
| interview_session_id | String | PK, FK |
| questionnaire_id | String | PK, FK |

### person_contact_im

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| personal_info_system_id | String | PK, FK |
| im_address | String |  |
| im_comment | String |  |
| im_type | String |  |
| instant_messenger_code | String |  |

### worker_position_manager

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| position_id | String | PK, FK |
| worker_id | String | PK, FK |

### position_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| certification_code | String |  |
| country | String |  |
| issuer | String |  |
| name | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### job_family_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| effective_date | LocalDate |  |
| inactive | Boolean |  |
| job_family_group_code | String |  |
| summary | String |  |

### job_requisition_commission_plan

| Column | Type | Keys |
| --- | --- | --- |
| commission_plan_id | String | PK |
| job_requisition_compensation_id | Long | PK, FK |
| job_requisition_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| commission_plan_code | String |  |
| currency_code | String |  |
| draw_amount | Double |  |
| draw_duration | String |  |
| draw_frequency_code | String |  |
| fixed_for_manage_by_basis_total | Boolean |  |
| frequency_code | String |  |
| recoverable | Boolean |  |
| target_amount | Double |  |

### additional_manager_question_section

| Column | Type | Keys |
| --- | --- | --- |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| section_index | Long | PK, FK |
| manager_comment | String |  |

### position_pay_plan

| Column | Type | Keys |
| --- | --- | --- |
| pay_plan_id | String | PK |
| position_id | String | PK, FK |
| actual_end_date | LocalDate |  |
| amount | Double |  |
| amount_change | Double |  |
| currency_code | String |  |
| expected_end_date | LocalDate |  |
| frequency_code | String |  |
| pay_plan_code | String |  |
| percent_change | Double |  |

### worker_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| worker_id | String | FK |
| completed_date_time | Instant |  |
| description | String |  |
| effective_date | LocalDate |  |
| event_type | String |  |

### position_responsibility

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| qualification_source | String |  |
| required | Boolean |  |
| responsibility | String |  |

### compensation_eligibility_compensation_plan

| Column | Type | Keys |
| --- | --- | --- |
| compensation_plan_id | String | PK |
| compensation_eligibility_rule_id | String | PK, FK |

### job_requisition_organization

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_id | String | PK, FK |
| company_id | String | FK |
| cost_center_id | String | FK |
| region_id | String | FK |
| business_unit_code | String |  |
| fund_code | String |  |
| gift_code | String |  |
| grant_code | String |  |
| program_code | String |  |

### person_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| type | String | PK |
| personal_info_system_id | String | PK, FK |
| academic_suffix | String |  |
| additional_name_type | String |  |
| country | String |  |
| first_name | String |  |
| full_name_singapore_malaysia | String |  |
| hereditary_suffix | String |  |
| honorary_suffix | String |  |
| last_name | String |  |
| middle_name | String |  |
| prefix_salutation | String |  |
| prefix_title | String |  |
| prefix_title_code | String |  |
| professional_suffix | String |  |
| religious_suffix | String |  |
| royal_suffix | String |  |
| secondary_last_name | String |  |
| social_suffix | String |  |
| social_suffix_id | String |  |
| tertiary_last_name | String |  |
| local_** |  |  |

### questionnaire_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| reference_id | String | PK, FK |
| answer_numeric | Int |  |
| answer_text | String |  |
| date | LocalDate |  |
| question_order | String |  |

### position_education

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| position_id | String | PK, FK |
| degree | String |  |
| field_of_study | String |  |
| qualification_source | String |  |
| required | Boolean |  |

### address_usage_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address_id | String | PK, FK |
| communication_usage_type | String |  |

### candidate_education

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_application_id | String | PK, FK |
| degree_code | String |  |
| field_of_study_code | String |  |
| first_year_attended | Int |  |
| grade_average | String |  |
| last_year_attended | Int |  |
| school_code | String |  |
| school_name | String |  |

### location_address_subregion

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| address_id | String | PK, FK |
| subregion_data | String |  |
| type | String |  |

### job_application

| Column | Type | Keys |
| --- | --- | --- |
| job_application_id | String | PK |
| candidate_id | String | PK, FK |
| job_application_code | String |  |
| summary | String |  |

### additional_manager_responsibility_component

| Column | Type | Keys |
| --- | --- | --- |
| component_index | Long | PK, FK |
| manager_id | String | PK, FK |
| review_id | String | PK, FK |
| manager_comment | String |  |

### pre_hire_referred_by_worker

| Column | Type | Keys |
| --- | --- | --- |
| pre_hire_id | String | PK, FK |
| worker_id | String | PK, FK |

### qualification_job_history_achievement

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_history_code | String | PK |
| worker_id | String | PK, FK |
| company | String |  |
| contact | String |  |
| end_date | LocalDate |  |
| job_history_company_code | String |  |
| job_reference | String |  |
| job_title | String |  |
| location | String |  |
| remove_job_history | Boolean |  |
| responsibilities_and_achievements | String |  |
| start_date | LocalDate |  |

### withholding_order_case_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| withholding_order_case_code | String |  |

### job_requisition_compensation

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| job_requisition_id | String | PK, FK |
| compensation_grade_id | String | FK |
| compensation_grade_profile_id | String | FK |
| compensation_package_code | String |  |
| compensation_step_code | String |  |
| primary_compensation_basis | Double |  |
| primary_compensation_basis_amount_change | Double |  |
| primary_compensation_basis_percent_change | Double |  |

### post_evaluation_feedback

| Column | Type | Keys |
| --- | --- | --- |
| review_id | String | PK, FK |
| employee_comment | String |  |
| employee_evaluation_feedback_status_code | String |  |
| manager_comment | String |  |
| manager_evaluation_feedback_status_code | String |  |

### payroll_local_other_authority_tax_worktag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payroll_id | String | PK, FK |
| payroll_line_id | Long | PK, FK |
| payroll_local_other_authority_tax_code | String |  |

### pre_hire_competency_achievement

| Column | Type | Keys |
| --- | --- | --- |
| competency_id | String | PK |
| pre_hire_id | String | PK, FK |
| assessed_by_worker_descriptor | String |  |
| assessed_on | LocalDate |  |
| assessment_comment | String |  |
| competency_code | String |  |
| competency_level | String |  |
| proficiency_rating | String |  |
| role_code | String |  |

### qualification_language_ability

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| index | Long | PK |
| language_id | String | PK, FK |
| worker_id | String | PK, FK |
| language_ability_type_code | String |  |
| language_proficiency_code | String |  |

### carryover_override_balance

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| override_balance_id | String | PK, FK |
| carry_over_date | LocalDate |  |
| carry_over_expiration_date | LocalDate |  |
| carry_override_balance_data | Double |  |

### learning_course_language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| learning_course_offering_data_id | String | PK, FK |
| learning_course_offering_detail_id | Long | PK, FK |
| learning_course_offering_id | String | PK, FK |
| code | String |  |

### personal_information_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_start | Instant | PK |
| type | String | PK |
| id | String | PK, FK |
| _fivetran_active | Boolean |  |
| _fivetran_end | Instant |  |
| additional_nationality | Json |  |
| as_of_effective_date | Instant |  |
| blood_type | String |  |
| citizenship_status | Json |  |
| city_of_birth | String |  |
| city_of_birth_code | String |  |
| country_of_birth | String |  |
| date_of_birth | LocalDate |  |
| date_of_death | LocalDate |  |
| gender | String |  |
| hispanic_or_latino | Boolean |  |
| hukou_locality | String |  |
| hukou_postal_code | String |  |
| hukou_region | String |  |
| hukou_subregion | String |  |
| hukou_type | String |  |
| last_medical_exam_date | LocalDate |  |
| last_medical_exam_valid_to | LocalDate |  |
| local_hukou | Boolean |  |
| marital_status | String |  |
| marital_status_date | LocalDate |  |
| marital_status_descriptor | String |  |
| medical_exam_notes | String |  |
| native_region | String |  |
| native_region_code | String |  |
| personnel_file_agency | String |  |
| political_affiliation | String |  |
| primary_nationality | String |  |
| region_of_birth | String |  |
| region_of_birth_code | String |  |
| religion | String |  |
| social_benefit | String |  |
| tobacco_use | Boolean |  |

## Relationships

- worker_collective_agreement(position_id) → worker_position(position_id)
- worker_collective_agreement(worker_id) → worker(id)
- learning_course_offering_data(learning_course_offering_id) → learning_course_offering(id)
- worker_commission_plan(worker_id) → worker(id)
- goal_section(review_id) → employee_review(id)
- project_worktag(payroll_id) → payroll(id)
- project_worktag(payroll_line_id) → payroll_line(index)
- payroll_line_pay_component(payroll_line_index) → payroll_line(index)
- payroll_line_pay_component(payroll_id) → payroll(id)
- pre_hire_resume(pre_hire_id) → pre_hire(id)
- compensation_allowance_plan_percent_profile(compensation_plan_id) → compensation_plan(id)
- compensation_allowance_plan_percent_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- compensation_matrix_amount(compensation_matrix_id) → compensation_matrix(id)
- compensation_matrix_amount(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- additional_manager_accomplishment_section(review_id) → employee_review(id)
- additional_manager_accomplishment_section(manager_id) → worker(id)
- additional_manager_accomplishment_section(section_index) → accomplishment_section(index)
- person_contact_web_address(personal_info_system_id) → personal_information(id)
- employee_contract_detail(worker_id) → worker(id)
- employee_contract_detail(position_id) → position(id)
- qualification_training(worker_id) → worker(id)
- job_requisition_work_experience(job_requisition_id) → job_requisition(id)
- position_history(supervisory_organization_id) → organization(id)
- position_history(worker_for_filled_position_id) → worker(id)
- position_period_salary_plan(position_id) → position(id)
- job_requisition_additional_job_profile(job_requisition_id) → job_requisition(id)
- job_requisition_additional_job_profile(job_profile_id) → job_profile(id)
- multiple_choice_answer(questionnaire_answer_id) → questionnaire_answer(reference_id)
- multiple_choice_answer(reference_id) → external_reference_participant(external_reference_id)
- qualification_professional_affiliation(worker_id) → worker(id)
- person_identity_document(personal_info_system_id) → personal_information(id)
- additional_manager_feedback_section(review_id) → employee_review(id)
- additional_manager_feedback_section(manager_id) → worker(id)
- additional_manager_feedback_section(section_index) → feedback_section(index)
- pre_hire_job_history(pre_hire_id) → pre_hire(id)
- organization_job_profile(organization_id) → organization(id)
- organization_job_profile(job_profile_id) → job_profile(id)
- organization_job_profile(job_category_reference_id) → job_category(id)
- job_family_document_field(job_family_id) → job_family(id)
- benchmark_amount_replacement(benchmark_composite_category_id) → benchmark_job_composite(benchmark_composite_category_id)
- qualification_internal_project_experience(worker_id) → worker(id)
- job_requisition_position(job_requisition_id) → job_requisition(id)
- job_requisition_position(position_id) → position(id)
- learning_course_sales_item(learning_course_offering_id) → learning_course_offering(id)
- learning_course_sales_item(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_sales_item(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- job_requisition_unit_allowance_plan(job_requisition_id) → job_requisition(id)
- job_requisition_unit_allowance_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- additional_manager_competency_section(review_id) → employee_review(id)
- additional_manager_competency_section(manager_id) → worker(id)
- additional_manager_competency_section(section_index) → competency_section(index)
- responsibility_component(review_id) → employee_review(id)
- responsibility_component(section_index) → responsibility_section(index)
- accomplishment_section(review_id) → employee_review(id)
- compensation_bonus_plan_coverage_date_eligibility_rule(compensation_plan_id) → compensation_plan(id)
- compensation_bonus_plan_coverage_date_eligibility_rule(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- question_component(review_id) → employee_review(id)
- question_component(section_index) → question_section(index)
- position_document_field_result(position_id) → position(id)
- job_requisition_document_field(job_requisition_id) → job_requisition(id)
- organization_history(manager_id) → worker(id)
- organization_history(organization_owner_id) → worker(id)
- organization_history(top_level_organization_id) → organization(id)
- organization_history(superior_organization_id) → organization(id)
- relative_name(country_personal_information_id) → country_personal_information(fivetran_id)
- job_requisition_certification(job_requisition_id) → job_requisition(id)
- organization_role(organization_id) → organization(id)
- goal_milestone_detail(review_id) → employee_review(id)
- goal_milestone_detail(component_index) → goal_component(index)
- candidate_national_id(candidate_id) → candidate(id)
- candidate_national_id(verified_by_worker_id) → worker(id)
- job_requisition_certification_specialty(job_requisition_certification_id) → job_requisition_certification(id)
- position_organization_history(organization_id) → organization(id)
- position_organization_history(position_id) → position(id)
- worker_position_job_classification(position_id) → worker_position(position_id)
- worker_position_job_classification(worker_id) → worker(id)
- worker_position_job_classification(job_classification_id) → job_classification(id)
- compensation_allowance_plan_unit_profile(compensation_plan_id) → compensation_plan(id)
- compensation_allowance_plan_unit_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- organization_role_worker_history(organization_id) → organization(id)
- organization_role_worker_history(role_id) → organization_role(role_id)
- organization_role_worker_history(worker_id) → worker(id)
- worker_unit_salary_plan(worker_id) → worker(id)
- address(personal_info_system_id) → personal_information(id)
- address(position_id) → worker_position(position_id)
- personal_information(id) → worker(id)
- job_requisition_additional_location(job_requisition_id) → job_requisition(id)
- pre_hire_positions_considered(pre_hire_id) → pre_hire(id)
- compensation_bonus_tranche(compensation_plan_id) → compensation_plan(id)
- compensation_plan(bonus_plan_performance_matrix_compensation_matrix_id) → compensation_matrix(id)
- compensation_plan(bonus_plan_performance_factor_compensation_matrix_id) → compensation_matrix(id)
- compensation_plan(merit_plan_compensation_matrix_id) → compensation_matrix(id)
- compensation_plan(stock_plan_compensation_matrix_id) → compensation_matrix(id)
- scorecard_goal(scorecard_id) → scorecard(id)
- position_worker_type_restriction(position_id) → position(id)
- worker_leave_request_detail(worker_id) → worker(id)
- position_bonus_plan(position_id) → position(id)
- review_question(question_category_id) → review_question_category(id)
- organization(manager_id) → worker(id)
- organization(organization_owner_id) → worker(id)
- organization(top_level_organization_id) → organization(id)
- organization(superior_organization_id) → organization(id)
- military_service(personal_information_common_id) → personal_information_common_data(worker_id)
- job_profile_language_ability(language_id) → job_profile_language(language_id)
- job_profile_language_ability(job_profile_id) → job_profile(id)
- responsibility_section(review_id) → employee_review(id)
- time_off_plan_balance(worker_id) → worker(id)
- address_use_for_reference(address_id) → location_address(id)
- qualification_competency_achievement(worker_id) → worker(id)
- qualification_competency_achievement(assessed_by_person_id) → worker(id)
- address_use_for_tenanted_reference(address_id) → location_address(id)
- pre_hire_work_experience(pre_hire_id) → pre_hire(id)
- candidate_tag(candidate_id) → candidate(id)
- carryover_override(worker_id) → worker(id)
- carryover_override(position_id) → position(id)
- location_document_field(location_id) → location(id)
- job_requisition_language(job_requisition_id) → job_requisition(id)
- position_unit_salary_plan(position_id) → position(id)
- pre_hire_background_check_status(pre_hire_id) → pre_hire(id)
- compensation_eligibility_rule_condition(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- position_unit_allowance_plan(position_id) → position(id)
- worker_merit_plan(worker_id) → worker(id)
- assess_talent(id) → worker(id)
- candidate_certification(job_application_id) → job_application(candidate_id)
- interviewer(interview_session_detail_id) → interview_session_detail(interview_session_id)
- interviewer(interview_session_id) → interview_session(interview_id)
- interviewer(interviewer_id) → worker(id)
- career_section(review_id) → employee_review(id)
- organization_role_worker(role_id) → organization_role(role_id)
- organization_role_worker(organization_id) → organization(id)
- organization_role_worker(associated_worker_id) → worker(id)
- candidate_government_id(candidate_id) → candidate(id)
- candidate_government_id(verified_by_worker_id) → worker(id)
- job_requisition_compensation_history(job_requisition_id) → job_requisition_history(id)
- job_requisition_compensation_history(compensation_grade_id) → compensation_grade(id)
- job_requisition_compensation_history(compensation_grade_profile_id) → compensation_grade_profile(compensation_grade_id)
- job_profile_worktag(payroll_id) → payroll(id)
- job_profile_worktag(payroll_line_id) → payroll_line(index)
- job_profile_exempt(job_profile_id) → job_profile(id)
- job_requisition_role_assignment_history(job_requisition_id) → job_requisition_history(id)
- job_requisition_role_assignment_history(organization_role_id) → organization_role(role_id)
- compensation_stock_profile_grant_split(compensation_plan_id) → compensation_plan(id)
- compensation_stock_profile_grant_split(unit_profile_replacement_index) → compensation_stock_plan_unit_profile(index)
- compensation_stock_plan_amount_profile(compensation_plan_id) → compensation_plan(id)
- compensation_stock_plan_amount_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- person_contact_email_address(personal_info_system_id) → personal_information(id)
- organization_assignment(organization_id) → organization(id)
- organization_assignment(reference_organization_id) → organization(id)
- job_profile_training(job_profile_id) → job_profile(id)
- worker_collective_agreement_factor(collective_agreement_id) → worker_collective_agreement(position_id)
- candidate_language(job_application_id) → job_application(candidate_id)
- external_reference_participant(external_reference_id) → external_reference_line(id)
- external_reference_participant(questionnaire_id) → questionnaire(id)
- compensation_stock_plan_grant(compensation_plan_id) → compensation_plan(id)
- position_job_profile(position_id) → position(id)
- interview_session(interview_id) → interview(id)
- job_requisition_allowance_plan(job_requisition_id) → job_requisition(id)
- job_requisition_allowance_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- development_item_component(review_id) → employee_review(id)
- learning_lesson_topic(learning_lesson_id) → learning_lesson(id)
- competency_section(review_id) → employee_review(id)
- pre_hire_language_ability(language_achievement_id) → pre_hire_language_achievement(pre_hire_id)
- additional_manager_accomplishment_component(review_id) → employee_review(id)
- additional_manager_accomplishment_component(manager_id) → worker(id)
- additional_manager_accomplishment_component(component_index) → accomplishment_component(index)
- payroll_line(payroll_id) → payroll(id)
- payroll_line(costing_company_id) → organization(id)
- location_address_submunicipality(address_id) → location_address(id)
- compensation_step(compensation_grade_id) → compensation_grade(id)
- score_for_multiple_choice(questions_for_questionnaire_id) → questionnaire_setup(questionnaire_id)
- job_profile(compensation_grade_id) → compensation_grade(id)
- job_profile(job_category_id) → job_category(id)
- worker_unit_allowance_plan(worker_id) → worker(id)
- position_work_experience(position_id) → position(id)
- location_address(location_id) → location(id)
- pay_accumulation(payroll_id) → payroll(id)
- candidate_pool_membership(candidate_id) → candidate(id)
- additional_manager_question_component(review_id) → employee_review(id)
- additional_manager_question_component(manager_id) → worker(id)
- additional_manager_question_component(component_index) → question_component(index)
- job_profile_document_field(job_profile_id) → job_profile(id)
- worker_position_organization(worker_id) → worker(id)
- worker_position_organization(organization_id) → organization(id)
- worker_position_organization(position_id) → worker_position(position_id)
- worker_salary_and_hourly(worker_id) → worker(id)
- additional_manager_overall_evaluation(review_id) → employee_review(id)
- additional_manager_overall_evaluation(manager_id) → worker(id)
- worker(compensation_grade_id) → compensation_grade(id)
- worker(compensation_grade_profile_id) → compensation_grade_profile(compensation_grade_id)
- job_requisition_additional_job_posting_location(job_requisition_id) → job_requisition(id)
- personal_information_gender_identity(personal_information_common_id) → personal_information_common_data(worker_id)
- compensation_bonus_plan_replacement_amount(compensation_plan_id) → compensation_plan(id)
- compensation_bonus_plan_replacement_amount(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_requisition_merit_plan(job_requisition_id) → job_requisition(id)
- job_requisition_merit_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- development_area_component(review_id) → employee_review(id)
- address_line(address_id) → address(id)
- supervisory_organization_location(organization_id) → organization(id)
- organization_position_group_position(organization_id) → organization(id)
- pre_hire_award_and_activity(pre_hire_id) → pre_hire(id)
- country_personal_information(personal_information_common_id) → personal_information_common_data(worker_id)
- compensation_matrix_percent(compensation_matrix_id) → compensation_matrix(id)
- compensation_matrix_percent(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- additional_manager_career_section(review_id) → employee_review(id)
- additional_manager_career_section(manager_id) → worker(id)
- additional_manager_career_section(section_index) → career_section(index)
- worker_pay_group_assignment_history(worker_id) → worker(id)
- job_requisition_role_assignee(job_requisition_id) → job_requisition(id)
- job_requisition_role_assignee(job_requisition_role_assignment_id) → job_requisition_role_assignment(job_requisition_id)
- job_requisition_role_assignee(worker_id) → worker(id)
- job_requisition_period_salary_plan(job_requisition_id) → job_requisition(id)
- job_requisition_period_salary_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- position_stock_plan(position_id) → position(id)
- job_requisition_bonus_plan(job_requisition_id) → job_requisition(id)
- job_requisition_bonus_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- rating_scale_review_rating(rating_scale_id) → rating_scale(rating_scale_id)
- job_requisition_responsibility(job_requisition_id) → job_requisition(id)
- interview_session_detail(interview_session_id) → interview_session(interview_id)
- learning_lesson_skill(learning_lesson_id) → learning_lesson(id)
- region_worktag(payroll_id) → payroll(id)
- region_worktag(payroll_line_id) → payroll_line(index)
- region_worktag(organization_id) → organization(id)
- question_section(review_id) → employee_review(id)
- job_requisition_custom_organization(job_requisition_id) → job_requisition(id)
- job_requisition_custom_organization(custom_organization_id) → organization(id)
- worker_position_compensation_history(worker_id) → worker(id)
- worker_position_compensation_history(position_id) → worker_position(position_id)
- job_requisition_role_assignee_history(job_requisition_id) → job_requisition_history(id)
- job_requisition_role_assignee_history(job_requisition_role_assignment_id) → job_requisition_role_assignment_history(job_requisition_id)
- job_requisition_role_assignee_history(worker_id) → worker(id)
- position_organization(organization_id) → organization(id)
- position_organization(position_id) → position(id)
- pre_hire_internal_project_experience(pre_hire_id) → pre_hire(id)
- worker_costing_allocation(worker_id) → worker(id)
- worker_costing_allocation(position_restrictions_id) → position(id)
- worker_costing_allocation(position_id) → position(id)
- worker_allowance_plan(worker_id) → worker(id)
- payroll_local_city_authority_tax_worktag(payroll_id) → payroll(id)
- payroll_local_city_authority_tax_worktag(payroll_line_id) → payroll_line(index)
- position_calculated_plan(position_id) → position(id)
- compensation_merit_plan_replacement_amount(compensation_plan_id) → compensation_plan(id)
- compensation_merit_plan_replacement_amount(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_profile_certification_specialty(certification_index) → job_profile_certification(index)
- job_profile_certification_specialty(job_profile_id) → job_profile(id)
- compensation_bonus_plan_replacement_percent(compensation_plan_id) → compensation_plan(id)
- compensation_bonus_plan_replacement_percent(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_profile_worker_compensation(job_profile_id) → job_profile(id)
- pre_hire_professional_affiliation(pre_hire_id) → pre_hire(id)
- worker_future_payment_plan(worker_id) → worker(id)
- interview_feedback_detail(interview_feedback_id) → interview_feedback(interview_id)
- compensation_stock_plan_unit_profile(compensation_plan_id) → compensation_plan(id)
- compensation_stock_plan_unit_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- feedback_competency_assessment(interview_feedback_detail_id) → interview_feedback_detail(interview_feedback_id)
- feedback_competency_assessment(interview_feedback_id) → interview_feedback(interview_id)
- payroll_state_authority_tax_worktag(payroll_id) → payroll(id)
- payroll_state_authority_tax_worktag(payroll_line_id) → payroll_line(index)
- personal_information_sexual_orientation_and_gender_identity(country_personal_information_id) → country_personal_information(fivetran_id)
- personal_information_sexual_orientation(personal_information_common_data_id) → personal_information_common_data(worker_id)
- worker_position_history(worker_id) → worker(id)
- worker_position_history(job_profile_id) → job_profile(id)
- worker_position_history(job_family_id) → job_family(id)
- calculation_tag(calculated_time_block_id) → calculated_time_block(id)
- learning_course_offering_data_from_course(learning_course_offering_id) → learning_course_offering(id)
- learning_course_offering_detail(learning_course_offering_id) → learning_course_offering(id)
- learning_course_offering_detail(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- interview_feedback(interview_id) → interview(id)
- interview_feedback(interviewer_id) → worker(id)
- compensation_eligibility_compensation_package(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- payroll_local_county_authority_tax_worktag(payroll_id) → payroll(id)
- payroll_local_county_authority_tax_worktag(payroll_line_id) → payroll_line(index)
- qualification_award_and_activity(worker_id) → worker(id)
- job_profile_certification(job_profile_id) → job_profile(id)
- worker_history(compensation_grade_id) → compensation_grade(id)
- worker_history(compensation_grade_profile_id) → compensation_grade_profile(compensation_grade_id)
- candidate_name(candidate_id) → candidate(id)
- job_requisition_role_assignment(job_requisition_id) → job_requisition(id)
- job_requisition_role_assignment(organization_role_id) → organization_role(role_id)
- qualification_language(worker_id) → worker(id)
- qualification_language(assessed_by) → worker(id)
- job_profile_restriction_job_family(job_profile_id) → position_job_profile(position_id)
- job_profile_restriction_job_family(job_family_id) → position_job_family(position_id)
- location_usage(location_id) → location(id)
- payroll_line_related_calculation(payroll_line_index) → payroll_line(index)
- payroll_line_related_calculation(payroll_id) → payroll(id)
- worker_pay_group_assignment(worker_id) → worker(id)
- job_requisition_history(replacement_for_worker_id) → worker(id)
- job_requisition_history(job_profile_id) → job_profile(id)
- job_requisition_history(internal_career_site_questionnaire_id) → questionnaire(id)
- job_requisition_history(internal_career_site_secondary_questionnaire_id) → questionnaire(id)
- job_requisition_history(external_career_sites_questionnaire_id) → questionnaire(id)
- job_requisition_history(external_career_site_secondary_questionnaire_id) → questionnaire(id)
- job_requisition_history(supervisory_organization_id) → organization(id)
- compensation_future_payment_bonus_plan(compensation_plan_id) → compensation_plan(id)
- compensation_future_one_time_payment_plan(compensation_plan_id) → compensation_plan(id)
- location_address_line(address_id) → location_address(id)
- worker_costing_allocation_interval(worker_costing_allocation_id) → worker_costing_allocation(_fivetran_id)
- position_skill(position_id) → position(id)
- worker_position_compensation(worker_id) → worker(id)
- worker_position_compensation(position_id) → worker_position(position_id)
- organization_hierarchy_detail(organization_id) → organization(id)
- organization_hierarchy_detail(linked_organization_id) → organization(id)
- deferred_compensation_eligibility_rule(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- deferred_compensation_eligibility_rule(compensation_plan_id) → compensation_plan(id)
- learning_course_advanced_pricing_rule(learning_course_offering_id) → learning_course_offering(id)
- learning_course_advanced_pricing_rule(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_advanced_pricing_rule(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- position_commission_plan(position_id) → position(id)
- benchmark_job_profile(benchmark_job_id) → benchmark_job(id)
- benchmark_job_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_family_job_profile(job_family_id) → job_family(id)
- job_family_job_profile(job_profile_id) → job_profile(id)
- job_requisition_competency(job_requisition_id) → job_requisition(id)
- organization_leader(organization_id) → organization(id)
- organization_leader(organization_manager_id) → worker(id)
- organization_role_history(organization_id) → organization(id)
- position_competency(position_id) → position(id)
- additional_manager_goal_component(review_id) → employee_review(id)
- additional_manager_goal_component(manager_id) → worker(id)
- additional_manager_goal_component(component_index) → goal_component(index)
- job_profile_compensation_grade_profile(job_profile_id) → job_profile(id)
- job_profile_compensation_grade_profile(compensation_grade_profile_id) → compensation_grade_profile(compensation_grade_id)
- pre_hire_certification_achievement(pre_hire_id) → pre_hire(id)
- worker_costing_allocation_detail(worker_costing_allocation_id) → worker_costing_allocation(_fivetran_id)
- worker_costing_allocation_detail(worker_costing_allocation_interval_index) → worker_costing_allocation_interval(worker_costing_allocation_id)
- job_profile_responsibility(job_profile_id) → job_profile(id)
- job_profile_language(job_profile_id) → job_profile(id)
- worker_secondary_termination_reason(worker_id) → worker(id)
- position_merit_plan(position_id) → position(id)
- payroll_custom_organization_worktag(payroll_id) → payroll(id)
- payroll_custom_organization_worktag(payroll_line_id) → payroll_line(index)
- payroll_custom_organization_worktag(organization_id) → organization(id)
- additional_manager_competency_component(review_id) → employee_review(id)
- additional_manager_competency_component(manager_id) → worker(id)
- additional_manager_competency_component(component_index) → competency_component(index)
- calculated_time_block(worker_id) → worker(id)
- calculated_time_block(job_profile_id) → job_profile(id)
- job_family_job_family_group(job_family_id) → job_family(id)
- job_family_job_family_group(job_family_group_id) → job_family_group(id)
- personal_information_ethnicity(country_personal_information_id) → country_personal_information(fivetran_id)
- payroll_local_school_district_authority_tax_worktag(payroll_id) → payroll(id)
- payroll_local_school_district_authority_tax_worktag(payroll_line_id) → payroll_line(index)
- compensation_plan_eligibility_rule(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- compensation_plan_eligibility_rule(compensation_plan_id) → compensation_plan(id)
- deferred_compensation_profile(compensation_plan_id) → compensation_plan(id)
- compensation_eligibility_rule_condition_category(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- worker_position_end_employment_reason(worker_id) → worker(id)
- worker_position_end_employment_reason(position_id) → worker_position(position_id)
- person_contact_phone(personal_info_system_id) → personal_information(id)
- additional_manager_responsibility_section(review_id) → employee_review(id)
- additional_manager_responsibility_section(manager_id) → worker(id)
- additional_manager_responsibility_section(section_index) → responsibility_section(index)
- scorecard_profile(scorecard_id) → scorecard(id)
- scorecard_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- talent_pool_worker(talent_pool_id) → talent_pool(id)
- talent_pool_worker(worker_id) → worker(id)
- override_balance(worker_id) → worker(id)
- override_balance(position_id) → position(id)
- external_reference_line(job_application_id) → job_application(candidate_id)
- external_reference_line(candidate_id) → candidate(id)
- external_reference_line(job_requisition_id) → job_requisition(id)
- competency_component(review_id) → employee_review(id)
- competency_component(section_index) → competency_section(index)
- job_requisition_default_assessment_test(job_requisition_id) → job_requisition(id)
- location_worktag(payroll_id) → payroll(id)
- location_worktag(payroll_line_id) → payroll_line(index)
- job_profile_work_experience(job_profile_id) → job_profile(id)
- job_applied_to(job_application_id) → job_application(candidate_id)
- job_applied_to(job_requisition_id) → job_requisition(id)
- job_applied_to(added_by_worker_id) → worker(id)
- time_off_plan_balance_position(time_off_plan_balance_id) → time_off_plan_balance(id)
- time_off_plan_balance_position(worker_id) → worker(id)
- time_off_plan_balance_position(position_id) → position(id)
- compensation_matrix_target_rule(compensation_matrix_id) → compensation_matrix(id)
- compensation_matrix_target_rule(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- worker_period_salary_plan(worker_id) → worker(id)
- location_type(location_id) → location(id)
- compensation_merit_plan_replacement_percent(compensation_plan_id) → compensation_plan(id)
- compensation_merit_plan_replacement_percent(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- compensation_grade(compensation_plan_id) → compensation_plan(id)
- employee_review(worker_id) → worker(id)
- employee_review(manager_id) → worker(id)
- job_requisition_additional_location_history(job_requisition_id) → job_requisition_history(id)
- job_profile_classification(job_profile_id) → job_profile(id)
- job_profile_classification(job_classification_id) → job_classification(id)
- candidate_social_media_account(candidate_id) → candidate(id)
- job_requisition_education(job_requisition_id) → job_requisition(id)
- job_profile_competency(job_profile_id) → job_profile(id)
- accomplishment_component(review_id) → employee_review(id)
- accomplishment_component(section_index) → accomplishment_section(index)
- payroll_line_withholding(payroll_line_index) → payroll_line(index)
- payroll_line_withholding(payroll_id) → payroll(id)
- compensation_allowance_plan_amount_profile(compensation_plan_id) → compensation_plan(id)
- compensation_allowance_plan_amount_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- worker_stock_plan(worker_id) → worker(id)
- additional_manager_development_item_section(review_id) → employee_review(id)
- additional_manager_development_item_section(manager_id) → worker(id)
- additional_manager_development_item_section(section_index) → development_item_section(index)
- company_worktag(payroll_id) → payroll(id)
- company_worktag(payroll_line_id) → payroll_line(index)
- company_worktag(organization_id) → organization(id)
- company_worktag(company_id) → organization(id)
- job_requisition_stock_plan(job_requisition_id) → job_requisition(id)
- job_requisition_stock_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- position_allowance_plan(position_id) → position(id)
- position_job_profile_history(position_id) → position(id)
- pre_hire_language_achievement(pre_hire_id) → pre_hire(id)
- pre_hire_language_achievement(assessed_by) → worker(id)
- worker_document_field_history(worker_id) → worker(id)
- candidate(pre_hire_id) → pre_hire(id)
- candidate(worker_id) → worker(id)
- candidate(referred_by_worker_id) → worker(id)
- candidate(added_by_worker_id) → worker(id)
- candidate(candidate_owner_worker_id) → worker(id)
- job_profile_company_insider(job_profile_id) → job_profile(id)
- worker_bonus_plan(worker_id) → worker(id)
- compensation_commission_plan_profile(compensation_plan_id) → compensation_plan(id)
- compensation_commission_plan_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_requisition_calculated_plan(job_requisition_id) → job_requisition(id)
- job_requisition_calculated_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- feedback_section(review_id) → employee_review(id)
- job_requisition_organization_history(job_requisition_id) → job_requisition_history(id)
- job_requisition_organization_history(company_id) → organization(id)
- job_requisition_organization_history(cost_center_id) → organization(id)
- job_requisition_organization_history(region_id) → organization(id)
- compensation_bonus_plan_performance_factor_scorecard(compensation_plan_id) → compensation_plan(id)
- position_certification_specialty(position_certification_id) → position_certification(id)
- job_requisition_language_ability(job_requisition_language_id) → job_requisition_language(id)
- questionnaire_setup(questionnaire_id) → questionnaire(id)
- qualification_certification_attachment(worker_id) → worker(id)
- qualification_certification_attachment(certification_id) → qualification_certification(certification_id)
- qualification_certification_attachment(certification_code) → qualification_certification(certification_id)
- organization_document_field_result(organization_id) → organization(id)
- payroll(employee_id) → worker(id)
- payroll(company_id) → organization(id)
- compensation_grade_profile(compensation_grade_id) → compensation_grade(id)
- compensation_grade_profile(compensation_plan_id) → compensation_plan(id)
- learning_course_other_unit_type(learning_course_offering_id) → learning_lesson(id)
- learning_course_other_unit_type(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_other_unit_type(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- candidate_website(candidate_id) → candidate(id)
- development_item_section(review_id) → employee_review(id)
- applicant_document_field(applicant_id) → pre_hire(id)
- worker_position(worker_id) → worker(id)
- worker_position(job_profile_id) → job_profile(id)
- worker_position(job_family_id) → job_family(id)
- career_interest_component(review_id) → employee_review(id)
- payroll_deduction_instant_messenger(payroll_line_index) → payroll_line(index)
- payroll_deduction_instant_messenger(payroll_id) → payroll(id)
- position_job_family(position_id) → position(id)
- job_requisition_training(job_requisition_id) → job_requisition(id)
- worker_position_payroll_reporting_code_history(worker_id) → worker(id)
- worker_position_payroll_reporting_code_history(position_id) → worker_position(position_id)
- compensation_eligibility_compensation_grade_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_requisition_unit_salary_plan(job_requisition_id) → job_requisition(id)
- job_requisition_unit_salary_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- payroll_custom_worktag(payroll_id) → payroll(id)
- payroll_custom_worktag(payroll_line_id) → payroll_line(index)
- additional_manager_goal_section(review_id) → employee_review(id)
- additional_manager_goal_section(manager_id) → worker(id)
- additional_manager_goal_section(section_index) → goal_section(index)
- personal_information_pronoun(personal_information_common_id) → personal_information_common_data(worker_id)
- assess_talent_nomination(worker_id) → worker(id)
- assess_talent_nomination(job_profile_id) → job_profile(id)
- job_requisition(replacement_for_worker_id) → worker(id)
- job_requisition(job_profile_id) → job_profile(id)
- job_requisition(internal_career_site_questionnaire_id) → questionnaire(id)
- job_requisition(internal_career_site_secondary_questionnaire_id) → questionnaire(id)
- job_requisition(external_career_sites_questionnaire_id) → questionnaire(id)
- job_requisition(external_career_site_secondary_questionnaire_id) → questionnaire(id)
- job_requisition(supervisory_organization_id) → organization(id)
- position_location_history(position_id) → position(id)
- learning_course_offering_lesson(learning_course_offering_id) → learning_course_offering(id)
- learning_course_offering_lesson(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_offering_lesson(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- personal_information_common_data(worker_id) → worker(id)
- position_training(position_id) → position(id)
- benchmark_job_and_job_profile(benchmark_job_id) → benchmark_job(id)
- benchmark_job_and_job_profile(job_profile_id) → job_profile(id)
- worker_document_field(worker_id) → worker(id)
- salary_over_the_cap_costing_allocation_detail(worker_costing_allocation_id) → worker_costing_allocation(_fivetran_id)
- salary_over_the_cap_costing_allocation_detail(worker_costing_allocation_interval_index) → worker_costing_allocation_interval(worker_costing_allocation_id)
- salary_over_the_cap_costing_allocation_detail(order_code) → worker_costing_allocation_detail(worker_costing_allocation_id)
- position_location(position_id) → position(id)
- location_hierarchy(location_id) → location(id)
- job_classification(group_id) → job_classification_group(id)
- overall_evaluation(review_id) → employee_review(id)
- cell_target_percentage(calibration_program_id) → calibration_program(id)
- interview_competency(interview_session_detail_id) → interview_session_detail(interview_session_id)
- interview_competency(interview_session_id) → interview_session(interview_id)
- organization_job_family(organization_id) → organization(id)
- organization_job_family(job_family_id) → job_family(id)
- organization_job_family(job_family_group_id) → job_family_group(id)
- person_disability(country_personal_information_id) → country_personal_information(fivetran_id)
- position_language(position_id) → position(id)
- benchmark_job_composite(benchmark_job_id) → benchmark_job(id)
- compensation_period_plan_profile(compensation_plan_id) → compensation_plan(id)
- compensation_period_plan_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- payroll_national_id(payroll_id) → payroll(id)
- payroll_national_id(verified_by) → worker(id)
- job_requisition_skill(job_requisition_id) → job_requisition(id)
- worker_position_organization_history(worker_id) → worker(id)
- worker_position_organization_history(position_id) → worker_position(position_id)
- worker_position_organization_history(organization_id) → organization(id)
- candidate_skill(job_application_id) → job_application(candidate_id)
- job_profile_education(job_profile_id) → job_profile(id)
- additional_manager_development_item_component(review_id) → employee_review(id)
- additional_manager_development_item_component(manager_id) → worker(id)
- additional_manager_development_item_component(component_index) → development_item_component(index)
- linked_job_requisition(job_requisition_id) → job_requisition(id)
- linked_job_requisition(linked_job_requisition_id) → job_requisition(id)
- worker_position_payroll_reporting_code(worker_id) → worker(id)
- worker_position_payroll_reporting_code(position_id) → worker_position(position_id)
- absence_input(worker_id) → worker(id)
- absence_input(position_id) → position(id)
- worker_costing_allocation_detail_worktag(order_code) → worker_costing_allocation_detail(worker_costing_allocation_id)
- worker_costing_allocation_detail_worktag(worker_costing_allocation_id) → worker_costing_allocation(_fivetran_id)
- worker_costing_allocation_detail_worktag(worker_costing_allocation_interval_index) → worker_costing_allocation_interval(worker_costing_allocation_id)
- calibration_value_map(calibration_program_id) → calibration_program(id)
- compensation_eligibility_compensation_grade(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- address_subregion(address_id) → address(id)
- position(supervisory_organization_id) → organization(id)
- position(worker_for_filled_position_id) → worker(id)
- compensation_stock_plan_percent_profile(compensation_plan_id) → compensation_plan(id)
- compensation_stock_plan_percent_profile(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- learning_lesson_language(learning_lesson_id) → learning_lesson(id)
- address_submunicipality(address_id) → address(id)
- job_profile_restrict_to_country(job_profile_id) → job_profile(id)
- worker_position_job_classification_history(worker_id) → worker(id)
- worker_position_job_classification_history(position_id) → worker_position(position_id)
- worker_position_job_classification_history(job_classification_id) → job_classification(id)
- job_profile_pay_rate(job_profile_id) → job_profile(id)
- pre_hire_training_achievement(pre_hire_id) → pre_hire(id)
- qualification_speciality_achievement(worker_id) → worker(id)
- qualification_speciality_achievement(certification_id) → qualification_certification(certification_id)
- qualification_speciality_achievement(certification_code) → qualification_certification(certification_id)
- job_requisition_certification_subspecialty(job_requisition_certification_specialty_id) → job_requisition_certification_specialty(index)
- job_requisition_certification_subspecialty(job_requisition_certification_id) → job_requisition_certification(id)
- pre_hire_education(pre_hire_id) → pre_hire(id)
- employee_probation_period_detail(position_id) → worker_position(position_id)
- employee_probation_period_detail(worker_id) → worker(id)
- qualification_certification(worker_id) → worker(id)
- scorecard_profile_goal(scorecard_profile_id) → scorecard_profile(id)
- worker_leave_status(worker_id) → worker(id)
- goal_component(review_id) → employee_review(id)
- goal_component(section_index) → goal_section(index)
- cost_center_worktag(payroll_id) → payroll(id)
- cost_center_worktag(payroll_line_id) → payroll_line(index)
- cost_center_worktag(organization_id) → organization(id)
- cost_center_worktag(cost_center_id) → organization(id)
- compensation_eligibility_rule_countries(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_requisition_pay_plan(job_requisition_id) → job_requisition(id)
- job_requisition_pay_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- learning_course_contact_person(learning_course_offering_id) → learning_course_offering(id)
- learning_course_contact_person(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_contact_person(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- job_profile_skill(job_profile_id) → job_profile(id)
- candidate_experience(job_application_id) → job_application(candidate_id)
- qualification_education(worker_id) → worker(id)
- qualification_work_experience(worker_id) → worker(id)
- position_language_ability(position_language_id) → position_language(id)
- interview_questionnaire(interview_session_detail_id) → interview_session_detail(interview_session_id)
- interview_questionnaire(questionnaire_id) → questionnaire(id)
- interview_questionnaire(interview_session_id) → interview_session(interview_id)
- person_contact_im(personal_info_system_id) → personal_information(id)
- worker_position_manager(manager_id) → worker(id)
- worker_position_manager(position_id) → worker_position(position_id)
- worker_position_manager(worker_id) → worker(id)
- position_certification(position_id) → position(id)
- job_requisition_commission_plan(job_requisition_id) → job_requisition(id)
- job_requisition_commission_plan(job_requisition_compensation_id) → job_requisition_compensation(job_requisition_id)
- additional_manager_question_section(review_id) → employee_review(id)
- additional_manager_question_section(manager_id) → worker(id)
- additional_manager_question_section(section_index) → question_section(index)
- position_pay_plan(position_id) → position(id)
- worker_event(worker_id) → worker(id)
- position_responsibility(position_id) → position(id)
- compensation_eligibility_compensation_plan(compensation_eligibility_rule_id) → compensation_eligibility_rule(id)
- job_requisition_organization(job_requisition_id) → job_requisition(id)
- job_requisition_organization(company_id) → organization(id)
- job_requisition_organization(cost_center_id) → organization(id)
- job_requisition_organization(region_id) → organization(id)
- person_name(personal_info_system_id) → personal_information(id)
- questionnaire_answer(reference_id) → external_reference_participant(external_reference_id)
- position_education(position_id) → position(id)
- address_usage_type(address_id) → location_address(id)
- candidate_education(job_application_id) → job_application(candidate_id)
- location_address_subregion(address_id) → location_address(id)
- job_application(candidate_id) → candidate(id)
- additional_manager_responsibility_component(review_id) → employee_review(id)
- additional_manager_responsibility_component(manager_id) → worker(id)
- additional_manager_responsibility_component(component_index) → responsibility_component(index)
- pre_hire_referred_by_worker(pre_hire_id) → pre_hire(id)
- pre_hire_referred_by_worker(worker_id) → worker(id)
- qualification_job_history_achievement(worker_id) → worker(id)
- withholding_order_case_worktag(payroll_id) → payroll(id)
- withholding_order_case_worktag(payroll_line_id) → payroll_line(index)
- job_requisition_compensation(job_requisition_id) → job_requisition(id)
- job_requisition_compensation(compensation_grade_id) → compensation_grade(id)
- job_requisition_compensation(compensation_grade_profile_id) → compensation_grade_profile(compensation_grade_id)
- post_evaluation_feedback(review_id) → employee_review(id)
- payroll_local_other_authority_tax_worktag(payroll_id) → payroll(id)
- payroll_local_other_authority_tax_worktag(payroll_line_id) → payroll_line(index)
- pre_hire_competency_achievement(pre_hire_id) → pre_hire(id)
- qualification_language_ability(worker_id) → worker(id)
- qualification_language_ability(language_id) → qualification_language(worker_id)
- carryover_override_balance(override_balance_id) → override_balance(id)
- learning_course_language(learning_course_offering_id) → learning_course_offering(id)
- learning_course_language(learning_course_offering_data_id) → learning_course_offering_data(learning_course_offering_id)
- learning_course_language(learning_course_offering_detail_id) → learning_course_offering_detail(learning_course_offering_id)
- personal_information_history(id) → worker(id)