Workday HCM

Explore the interactive ERD

Table & Field Reference

worker_collective_agreement

Column	Type	Keys
`index`	Long	PK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`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	PKFK
`course`	String
`course_code`	String

worker_commission_plan

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`project_code`	String

payroll_line_pay_component

Column	Type	Keys
`index`	Long	PK
`payroll_id`	String	PKFK
`payroll_line_index`	Long	PKFK
`deduction`	String
`earning`	String

pre_hire_resume

Column	Type	Keys
`resume_id`	String	PK
`pre_hire_id`	String	PKFK
`comments`	String
`file_code`	String
`file_name`	String

compensation_allowance_plan_percent_profile

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

person_contact_web_address

Column	Type	Keys
`id`	String	PK
`personal_info_system_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK

multiple_choice_answer

Column	Type	Keys
`question_multiple_choice_answer_id`	String	PK
`questionnaire_answer_id`	Long	PKFK
`reference_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

pre_hire_job_history

Column	Type	Keys
`job_hire_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`organization_id`	String	PKFK
`job_category_reference_id`	String	FK

job_family_document_field

Column	Type	Keys
`integration_document_field`	String	PK
`job_family_id`	String	PKFK
`value`	String

benchmark_amount_replacement

Column	Type	Keys
`index`	Long	PK
`benchmark_composite_category_id`	String	PKFK
`amount`	Double
`benchmark_percentile`	String

qualification_internal_project_experience

Column	Type	Keys
`id`	String	PK
`internal_project_experience_code`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`position_id`	String	PKFK

learning_course_sales_item

Column	Type	Keys
`id`	String	PK
`learning_course_offering_data_id`	String	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`code`	String

job_requisition_unit_allowance_plan

Column	Type	Keys
`unit_allowance_plan_id`	String	PK
`job_requisition_compensation_id`	Long	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

responsibility_component

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`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	PKFK
`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	PKFK
`compensation_plan_id`	String	PKFK

question_component

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`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	PKFK
`value`	String

job_requisition_document_field

Column	Type	Keys
`integration_document_field`	String	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`organization_role_code`	String

goal_milestone_detail

Column	Type	Keys
`goal_reference_code`	String	PK
`component_index`	Long	PKFK
`review_id`	String	PKFK
`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	PKFK
`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	PKFK
`specialty`	String
`sub_specialty`	Json

position_organization_history

Column	Type	Keys
`type`	String	PK
`organization_id`	String	PKFK
`position_id`	String	PKFK

worker_position_job_classification

Column	Type	Keys
`job_classification_id`	String	PKFK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`job_group_code`	String

compensation_allowance_plan_unit_profile

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`role_id`	String	PKFK
`worker_id`	String	PKFK

worker_unit_salary_plan

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`position_id`	String	PKFK
`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	PKFK
`tobacco_use`	Boolean

job_requisition_additional_location

Column	Type	Keys
`location_id`	String	PK
`job_requisition_id`	String	PKFK
`location_code`	String

pre_hire_positions_considered

Column	Type	Keys
`position_id`	String	PK
`pre_hire_id`	String	PKFK
`position_code`	String

compensation_bonus_tranche

Column	Type	Keys
`name`	Double	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`description`	String
`name`	String
`weight`	Double

position_worker_type_restriction

Column	Type	Keys
`worker_type_id`	String	PK
`position_id`	String	PKFK
`worker_type_code`	String

worker_leave_request_detail

Column	Type	Keys
`leave_request_event_id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`language_id`	String	PKFK
`language_ability_type_code`	String
`language_proficiency_code`	String

responsibility_section

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`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	PKFK
`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	PKFK
`communication_usage_behaviour`	String

qualification_competency_achievement

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`value`	String

job_requisition_language

Column	Type	Keys
`id`	String	PK
`job_requisition_id`	String	PKFK
`language_code`	String
`qualification_source`	String
`required`	Boolean

position_unit_salary_plan

Column	Type	Keys
`unit_salary_plan_id`	String	PK
`position_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`interview_session_id`	String	PKFK
`interviewer_id`	String	PKFK

career_section

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`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	PKFK
`organization_id`	String	PKFK
`role_id`	String	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`job_profile_code`	String

job_profile_exempt

Column	Type	Keys
`index`	Long	PK
`job_profile_id`	String	PKFK
`is_job_exempt`	Boolean
`location_context`	String

job_requisition_role_assignment_history

Column	Type	Keys
`id`	String	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`unit_profile_replacement_index`	Long	PKFK
`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	PKFK
`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	PKFK
`email_address`	String
`email_code`	String
`email_comment`	String

organization_assignment

Column	Type	Keys
`organization_id`	String	PKFK
`reference_organization_id`	String	PKFK
`reference_organization_type`	String

job_profile_training

Column	Type	Keys
`index`	Long	PK
`job_profile_id`	String	PKFK
`description`	String
`name`	String
`required`	Boolean
`training_type`	String

worker_collective_agreement_factor

Column	Type	Keys
`index`	Long	PK
`collective_agreement_id`	String	PKFK
`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	PKFK
`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	PKFK
`questionnaire_id`	String	FK
`referee_code`	String

compensation_stock_plan_grant

Column	Type	Keys
`index`	Long	PK
`type`	String	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`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	PKFK
`interview_session_code`	String

job_requisition_allowance_plan

Column	Type	Keys
`allowance_plan_id`	String	PK
`job_requisition_compensation_id`	Long	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`code`	String

competency_section

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`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	PKFK
`language_ability_type_code`	String
`language_proficiency_code`	String

additional_manager_accomplishment_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`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	PKFK
`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	PKFK
`submunicipality_data`	String
`type`	String

compensation_step

Column	Type	Keys
`id`	String	PK
`compensation_grade_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`qualification_source`	String
`required`	Boolean
`work_experience_code`	String
`work_experience_rating`	String

location_address

Column	Type	Keys
`id`	String	PK
`location_id`	String	PKFK
`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	PKFK
`amount`	Double
`pay_accumulation_code`	String

candidate_pool_membership

Column	Type	Keys
`candidate_pool_id`	String	PK
`candidate_id`	String	PKFK
`candidate_pool_code`	String
`readiness_status_code`	String
`readiness_status_id`	String

additional_manager_question_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`manager_comment`	String

job_profile_document_field

Column	Type	Keys
`integration_document_field`	String	PK
`job_profile_id`	String	PKFK
`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	PKFK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`review_id`	String	PKFK
`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	PKFK
`location_code`	String

personal_information_gender_identity

Column	Type	Keys
`id`	String	PK
`personal_information_common_id`	String	PKFK
`gender_code`	String

compensation_bonus_plan_replacement_amount

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`line_data`	String
`type`	String

supervisory_organization_location

Column	Type	Keys
`location_id`	String	PK
`organization_id`	String	PKFK
`location_code`	String

organization_position_group_position

Column	Type	Keys
`position_worker_type_id`	String	PK
`organization_id`	String	PKFK
`position_worker_type_code`	String

pre_hire_award_and_activity

Column	Type	Keys
`award_and_activity_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

worker_pay_group_assignment_history

Column	Type	Keys
`_fivetran_start`	Instant	PK
`index`	Long	PK
`worker_id`	String	PKFK
`_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	PKFK
`job_requisition_role_assignment_id`	String	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`code`	String
`remote_skill_code`	String

region_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`organization_id`	String	FK
`region_code`	String

question_section

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK

worker_position_compensation_history

Column	Type	Keys
`_fivetran_start`	Instant	PK
`id`	String	PK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`_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	PKFK
`job_requisition_role_assignment_id`	String	PKFK
`worker_id`	String	FK
`role_assignee_code`	String

position_organization

Column	Type	Keys
`type`	String	PK
`organization_id`	String	PKFK
`position_id`	String	PKFK

pre_hire_internal_project_experience

Column	Type	Keys
`internal_project_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`payroll_local_city_authority_tax_code`	String

position_calculated_plan

Column	Type	Keys
`calculated_plan_id`	String	PK
`position_id`	String	PKFK
`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	PKFK
`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	PKFK
`job_profile_id`	String	PKFK
`specialty_code`	String

compensation_bonus_plan_replacement_percent

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`worker_compensation_code`	String

pre_hire_professional_affiliation

Column	Type	Keys
`professional_affiliation_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`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	PKFK
`comment`	String
`rating_code`	String

compensation_stock_plan_unit_profile

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`compensation_eligibility_rule_id`	String	FK
`target_shares`	Double

feedback_competency_assessment

Column	Type	Keys
`index`	Long	PK
`interview_feedback_detail_id`	Long	PKFK
`interview_feedback_id`	String	PKFK
`comment`	String
`competency_code`	String
`proficiency_rating`	String

payroll_state_authority_tax_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`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	PKFK
`lgbt_identification_code`	String

personal_information_sexual_orientation

Column	Type	Keys
`id`	String	PK
`personal_information_common_data_id`	String	PKFK
`sexual_orientation_code`	String

worker_position_history

Column	Type	Keys
`_fivetran_start`	Instant	PK
`position_id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`descriptor`	String
`time_calculation_tag_code`	String

learning_course_offering_data_from_course

Column	Type	Keys
`index`	Long	PK
`learning_course_offering_id`	String	PKFK
`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	PKFK
`learning_course_offering_id`	String	PKFK
`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	PKFK
`interviewer_id`	String	PKFK

compensation_eligibility_compensation_package

Column	Type	Keys
`compensation_package_id`	String	PK
`compensation_eligibility_rule_id`	String	PKFK

payroll_local_county_authority_tax_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`payroll_local_county_authority_tax_code`	String

qualification_award_and_activity

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`organization_role_id`	String	FK
`effective_date`	LocalDate
`requisition_role_code`	String

qualification_language

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`job_profile_id`	String	PKFK

location_usage

Column	Type	Keys
`id`	String	PK
`location_id`	String	PKFK
`usage`	String

payroll_line_related_calculation

Column	Type	Keys
`index`	Long	PK
`payroll_id`	String	PKFK
`payroll_line_index`	Long	PKFK
`amount`	Double
`calculation_code`	String
`workday_calculation_code`	String

worker_pay_group_assignment

Column	Type	Keys
`index`	Long	PK
`worker_id`	String	PKFK
`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	PKFK

compensation_future_one_time_payment_plan

Column	Type	Keys
`id`	String	PK
`compensation_plan_id`	String	PKFK
`one_time_payment_plan_code`	String

location_address_line

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`line_data`	String
`type`	String

worker_costing_allocation_interval

Column	Type	Keys
`index`	Long	PK
`worker_costing_allocation_id`	String	PKFK
`costing_override_code`	String
`end_date`	LocalDate
`start_date`	LocalDate

position_skill

Column	Type	Keys
`id`	String	PK
`position_id`	String	PKFK
`name`	String
`qualification_source`	String
`required`	Boolean
`skill_code`	String

worker_position_compensation

Column	Type	Keys
`id`	String	PK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`workers_compensation_code`	String

organization_hierarchy_detail

Column	Type	Keys
`type`	String	PK
`linked_organization_id`	String	PKFK
`organization_id`	String	PKFK

deferred_compensation_eligibility_rule

Column	Type	Keys
`compensation_eligibility_rule_id`	String	PKFK
`compensation_plan_id`	String	PKFK

learning_course_advanced_pricing_rule

Column	Type	Keys
`order`	String	PK
`learning_course_offering_data_id`	String	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`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	PKFK
`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	PKFK
`compensation_eligibility_rule_id`	String	FK
`currency`	String
`frequency`	String

job_family_job_profile

Column	Type	Keys
`job_family_id`	String	PKFK
`job_profile_id`	String	PKFK

job_requisition_competency

Column	Type	Keys
`id`	String	PK
`job_requisition_id`	String	PKFK
`competency_code`	String
`proficiency_rating`	String
`qualification_source`	String
`required`	Boolean

organization_leader

Column	Type	Keys
`organization_id`	String	PKFK
`organization_manager_id`	String	PKFK

organization_role_history

Column	Type	Keys
`role_id`	String	PK
`organization_id`	String	PKFK
`organization_role_code`	String

position_competency

Column	Type	Keys
`id`	String	PK
`position_id`	String	PKFK
`competency_code`	String
`proficiency_rating`	String
`qualification_source`	String
`required`	Boolean

additional_manager_goal_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`manager_comment`	String

job_profile_compensation_grade_profile

Column	Type	Keys
`compensation_grade_profile_id`	String	PKFK
`job_profile_id`	String	PKFK

pre_hire_certification_achievement

Column	Type	Keys
`certification_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`worker_costing_allocation_interval_index`	Long	PKFK
`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	PKFK
`description`	String
`required`	Boolean

job_profile_language

Column	Type	Keys
`language_id`	String	PK
`job_profile_id`	String	PKFK
`language_code`	String
`required`	Boolean

worker_secondary_termination_reason

Column	Type	Keys
`index`	Long	PK
`worker_id`	String	PKFK
`secondary_termination_reason`	String
`secondary_termination_reason_category`	String

position_merit_plan

Column	Type	Keys
`merit_plan_id`	String	PK
`position_id`	String	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`organization_id`	String	FK
`custom_organization_reference_code`	String
`type_code`	String

additional_manager_competency_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`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	PKFK
`job_family_id`	String	PKFK

personal_information_ethnicity

Column	Type	Keys
`id`	String	PK
`country_personal_information_id`	String	PKFK
`ethnicity_code`	String
`ethnicity_code_descriptor`	String

payroll_local_school_district_authority_tax_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`payroll_local_school_district_authority_code`	String

compensation_plan_eligibility_rule

Column	Type	Keys
`compensation_eligibility_rule_id`	String	PKFK
`compensation_plan_id`	String	PKFK

deferred_compensation_profile

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK

worker_position_end_employment_reason

Column	Type	Keys
`index`	Long	PK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`end_employment_reason`	String

person_contact_phone

Column	Type	Keys
`id`	String	PK
`personal_info_system_id`	String	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

scorecard_profile

Column	Type	Keys
`id`	String	PK
`scorecard_id`	String	PKFK
`compensation_eligibility_rule_id`	String	FK

talent_pool_worker

Column	Type	Keys
`talent_pool_id`	String	PKFK
`worker_id`	String	PKFK

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	PKFK
`section_index`	Long	PKFK
`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	PKFK
`default_assessment_test_code`	String

location_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`location_code`	String

job_profile_work_experience

Column	Type	Keys
`work_experience_id`	String	PK
`job_profile_id`	String	PKFK
`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	PKFK
`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	PKFK
`worker_id`	String	PKFK
`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	PKFK
`compensation_eligibility_rule_id`	String	FK

worker_period_salary_plan

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`location_code`	String

job_profile_classification

Column	Type	Keys
`job_classification_id`	String	PKFK
`job_profile_id`	String	PKFK

candidate_social_media_account

Column	Type	Keys
`index`	Long	PK
`candidate_id`	String	PKFK
`social_network_type_code`	String
`url`	String
`user_name`	String

job_requisition_education

Column	Type	Keys
`id`	String	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`competency_code`	String
`proficiency_rating`	String
`required`	Boolean

accomplishment_component

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`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	PKFK
`payroll_line_index`	Long	PKFK
`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	PKFK
`compensation_eligibility_rule_id`	String	FK
`amount`	Double
`currency`	String

worker_stock_plan

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

company_worktag

Column	Type	Keys
`id`	String	PK
`payroll_id`	String	PKFK
`payroll_line_id`	Long	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`_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	PKFK
`company_insider_type`	String

worker_bonus_plan

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`bonus_modifier`	String
`performance_scorecard_code`	String
`weight`	Double

position_certification_specialty

Column	Type	Keys
`index`	Long	PK
`position_certification_id`	String	PKFK
`specialty`	String
`sub_specialty`	Json

job_requisition_language_ability

Column	Type	Keys
`index`	Long	PK
`job_requisition_language_id`	String	PKFK
`language_ability_type`	String
`language_proficiency`	String

questionnaire_setup

Column	Type	Keys
`questionnaire_setup_id`	String	PK
`questionnaire_id`	String	PKFK
`order`	String
`question_description`	String
`required`	Boolean

qualification_certification_attachment

Column	Type	Keys
`file_name`	String	PK
`certification_code`	String	PKFK
`certification_id`	String	PKFK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`code`	String
`other_unit_value`	Double

candidate_website

Column	Type	Keys
`index`	Long	PK
`candidate_id`	String	PKFK
`url`	String

development_item_section

Column	Type	Keys
`index`	Long	PK
`review_id`	String	PKFK
`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	PKFK
`value`	String

worker_position

Column	Type	Keys
`position_id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`payroll_line_index`	Long	PKFK
`instant_messenger_id`	String

position_job_family

Column	Type	Keys
`job_family_id`	String	PK
`position_id`	String	PKFK

job_requisition_training

Column	Type	Keys
`id`	String	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`worker_id`	String	PKFK
`_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	PKFK

job_requisition_unit_salary_plan

Column	Type	Keys
`unit_salary_plan_id`	String	PK
`job_requisition_compensation_id`	Long	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`worktag_code`	String
`worktag_type`	String

additional_manager_goal_section

Column	Type	Keys
`manager_id`	String	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

personal_information_pronoun

Column	Type	Keys
`id`	String	PK
`personal_information_common_id`	String	PKFK
`pronoun_code`	String

assess_talent_nomination

Column	Type	Keys
`index`	Long	PK
`worker_id`	String	PKFK
`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	PKFK
`location_code`	String

learning_course_offering_lesson

Column	Type	Keys
`order`	String	PK
`learning_course_offering_data_id`	String	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`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	PKFK
`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	PKFK
`description`	String
`name`	String
`qualification_source`	String
`required`	Boolean
`training_type`	String

benchmark_job_and_job_profile

Column	Type	Keys
`benchmark_job_id`	String	PKFK
`job_profile_id`	String	PKFK

worker_document_field

Column	Type	Keys
`integration_document_field`	String	PK
`worker_id`	String	PKFK
`value`	String

salary_over_the_cap_costing_allocation_detail

Column	Type	Keys
`soc_order`	String	PK
`order_code`	String	PKFK
`worker_costing_allocation_id`	String	PKFK
`worker_costing_allocation_interval_index`	Long	PKFK
`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	PKFK
`location_code`	String

location_hierarchy

Column	Type	Keys
`superior_organization_id`	String	PK
`location_id`	String	PKFK
`organization_reference_id`	String

job_classification

Column	Type	Keys
`id`	String	PK
`group_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`interview_session_id`	String	PKFK
`competency_code`	String

organization_job_family

Column	Type	Keys
`job_family_id`	String	PKFK
`organization_id`	String	PKFK
`job_family_group_id`	String	FK

person_disability

Column	Type	Keys
`id`	String	PK
`country_personal_information_id`	String	PKFK
`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	PKFK
`language_code`	String
`qualification_source`	String
`required`	Boolean

benchmark_job_composite

Column	Type	Keys
`benchmark_composite_category_id`	String	PK
`benchmark_job_id`	String	PKFK
`category_type`	String
`target_percentile`	String
`target_spread`	Double

compensation_period_plan_profile

Column	Type	Keys
`index`	Long	PK
`compensation_plan_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`worker_id`	String	PKFK
`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	PKFK
`skill_code`	String
`skill_name`	String

job_profile_education

Column	Type	Keys
`index`	Long	PK
`job_profile_id`	String	PKFK
`degree_code`	String
`field_of_study`	String
`required`	Boolean

additional_manager_development_item_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`manager_comment`	String

linked_job_requisition

Column	Type	Keys
`job_requisition_id`	String	PKFK
`linked_job_requisition_id`	String	PKFK

worker_position_payroll_reporting_code

Column	Type	Keys
`payroll_reporting_id`	String	PK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`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	PKFK
`worker_costing_allocation_id`	String	PKFK
`worker_costing_allocation_interval_index`	Long	PKFK
`code`	Json

calibration_value_map

Column	Type	Keys
`nbox_axis_segment_id`	String	PK
`calibration_program_id`	String	PKFK
`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	PKFK

address_subregion

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`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	PKFK
`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	PKFK
`code`	String

address_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`submunicipality_data`	String
`type`	String

job_profile_restrict_to_country

Column	Type	Keys
`country_id`	String	PK
`job_profile_id`	String	PKFK
`country_code`	String

worker_position_job_classification_history

Column	Type	Keys
`_fivetran_start`	Instant	PK
`job_classification_id`	String	PKFK
`position_id`	String	PKFK
`worker_id`	String	PKFK
`_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	PKFK
`country_code`	String
`pay_rate_code`	String

pre_hire_training_achievement

Column	Type	Keys
`training_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`certification_id`	String	PKFK
`worker_id`	String	PKFK
`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	PKFK
`job_requisition_certification_specialty_id`	Long	PKFK
`sub_specialty_code`	String

pre_hire_education

Column	Type	Keys
`education_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`worker_id`	String	PKFK
`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	PKFK
`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	PKFK
`description`	String
`name`	String
`weight`	Double

worker_leave_status

Column	Type	Keys
`leave_request_event_id`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`section_index`	Long	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`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	PKFK

job_requisition_pay_plan

Column	Type	Keys
`pay_plan_id`	String	PK
`job_requisition_compensation_id`	Long	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`contingent_worker_code`	String
`employee_code`	String

job_profile_skill

Column	Type	Keys
`index`	Long	PK
`job_profile_id`	String	PKFK
`name`	String
`required`	Boolean
`skill_code`	String

candidate_experience

Column	Type	Keys
`index`	Long	PK
`job_application_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`language_ability_type`	String
`language_proficiency`	String

interview_questionnaire

Column	Type	Keys
`interview_session_detail_id`	Long	PKFK
`interview_session_id`	String	PKFK
`questionnaire_id`	String	PKFK

person_contact_im

Column	Type	Keys
`id`	String	PK
`personal_info_system_id`	String	PKFK
`im_address`	String
`im_comment`	String
`im_type`	String
`instant_messenger_code`	String

worker_position_manager

Column	Type	Keys
`manager_id`	String	PKFK
`position_id`	String	PKFK
`worker_id`	String	PKFK

position_certification

Column	Type	Keys
`id`	String	PK
`position_id`	String	PKFK
`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	PKFK
`job_requisition_id`	String	PKFK
`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	PKFK
`review_id`	String	PKFK
`section_index`	Long	PKFK
`manager_comment`	String

position_pay_plan

Column	Type	Keys
`pay_plan_id`	String	PK
`position_id`	String	PKFK
`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	PKFK
`qualification_source`	String
`required`	Boolean
`responsibility`	String

compensation_eligibility_compensation_plan

Column	Type	Keys
`compensation_plan_id`	String	PK
`compensation_eligibility_rule_id`	String	PKFK

job_requisition_organization

Column	Type	Keys
`index`	Long	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`answer_numeric`	Int
`answer_text`	String
`date`	LocalDate
`question_order`	String

position_education

Column	Type	Keys
`id`	String	PK
`position_id`	String	PKFK
`degree`	String
`field_of_study`	String
`qualification_source`	String
`required`	Boolean

address_usage_type

Column	Type	Keys
`id`	String	PK
`address_id`	String	PKFK
`communication_usage_type`	String

candidate_education

Column	Type	Keys
`index`	Long	PK
`job_application_id`	String	PKFK
`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	PKFK
`subregion_data`	String
`type`	String

job_application

Column	Type	Keys
`job_application_id`	String	PK
`candidate_id`	String	PKFK
`job_application_code`	String
`summary`	String

additional_manager_responsibility_component

Column	Type	Keys
`component_index`	Long	PKFK
`manager_id`	String	PKFK
`review_id`	String	PKFK
`manager_comment`	String

pre_hire_referred_by_worker

Column	Type	Keys
`pre_hire_id`	String	PKFK
`worker_id`	String	PKFK

qualification_job_history_achievement

Column	Type	Keys
`id`	String	PK
`job_history_code`	String	PK
`worker_id`	String	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`withholding_order_case_code`	String

job_requisition_compensation

Column	Type	Keys
`index`	Long	PK
`job_requisition_id`	String	PKFK
`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	PKFK
`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	PKFK
`payroll_line_id`	Long	PKFK
`payroll_local_other_authority_tax_code`	String

pre_hire_competency_achievement

Column	Type	Keys
`competency_id`	String	PK
`pre_hire_id`	String	PKFK
`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	PKFK
`worker_id`	String	PKFK
`language_ability_type_code`	String
`language_proficiency_code`	String

carryover_override_balance

Column	Type	Keys
`index`	Long	PK
`override_balance_id`	String	PKFK
`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	PKFK
`learning_course_offering_detail_id`	Long	PKFK
`learning_course_offering_id`	String	PKFK
`code`	String

personal_information_history

Column	Type	Keys
`_fivetran_start`	Instant	PK
`type`	String	PK
`id`	String	PKFK
`_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