SAP SuccessFactors

Explore the interactive ERD

Table & Field Reference

time_collector

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`booking_date`	Instant
`change_value`	String
`collector_value`	String
`created_date_time`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`start_date`	Instant
`system_record_status`	String
`time_collector_type`	String
`custom_`

candidate_background_education

Column	Type	Keys
`background_element_id`	String	PK
`candidate_id`	String	FK
`background_order_position`	String
`degree`	String
`degree_date`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`major`	String
`present_student`	String
`school`	String
`school_address`	String
`school_city`	String
`school_country`	String
`school_phone`	String
`school_state`	String
`school_type`	String
`school_zip`	String
`start_date`	Instant
`custom_`

form_summary_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

background_memberships

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`end_date`	Instant
`last_modified_date`	Instant
`organization`	String
`role`	String
`start_date`	Instant
`custom_`

background_community

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`end_date`	Instant
`last_modified_date`	Instant
`name`	String
`role`	String
`start_date`	Instant
`custom_`

employee_compensation

Column	Type	Keys
`start_date`	Instant	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`benefits_rate`	Double
`bonus_target`	Double
`created_date_time`	Instant
`end_date`	Instant
`event`	String
`event_reason`	String
`is_eligible_for_benefits`	Boolean
`is_eligible_for_car`	Boolean
`is_highly_compensated_employee`	Boolean
`is_insider`	Boolean
`last_modified_date_time`	Instant
`pay_grade`	String
`pay_group`	String
`payroll_system_id`	String
`custom_`

admin_reassign_offer_approver

Column	Type	Keys
`application_id`	String	PKFK
`offer_detail_id`	String	PKFK
`user_id`	String	PKFK
`job_req_id`	String	FK
`target_user_id`	String	FK
`candidate_name`	String
`job_req_title`	String
`custom_`

candidate_tags

Column	Type	Keys
`id`	String	PK
`candidate_id`	String	FK
`label`	String
`locale`	String
`custom_`

form_rating_scale

Column	Type	Keys
`form_data_id`	String	PK
`section_index`	Int	PK
`form_content_id`	String	PKFK
`name`	String
`reverse_scale`	Boolean
`scale_id`	String
`scale_type`	String
`show_value`	Boolean
`custom_`

employee_pay_comp_non_recurring

Column	Type	Keys
`pay_component_code`	String	PK
`pay_date`	Instant	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`alternative_cost_center`	String
`created_date_time`	Instant
`currency_code`	String
`last_modified_date_time`	Instant
`notes`	String
`operation`	String
`value`	Double
`custom_`

per_person

Column	Type	Keys
`person_id_external`	Unknown	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`user_id`	Unknown	FK
`birth_name`	Unknown
`country_of_birth`	Unknown
`created_date_time`	Instant
`created_on`	Instant
`date_of_birth`	Unknown
`include_all_record`	Unknown
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`per_person_uuid`	Unknown
`person_id`	Unknown
`region_of_birth`	Unknown
`custom_`

emp_cost_distribution_item

Column	Type	Keys
`emp_cost_distribution_effective_start_date`	Instant	PK
`external_code`	String	PK
`emp_cost_distribution_users_sys_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`cost_center`	String
`created_date_time`	Instant
`last_modified_date_time`	Instant
`mdf_system_created_by`	String
`mdf_system_created_date`	Instant
`mdf_system_effective_end_date`	Instant
`mdf_system_effective_start_date`	Instant
`mdf_system_entity_id`	String
`mdf_system_last_modified_by`	String
`mdf_system_last_modified_date`	Instant
`mdf_system_last_modified_date_with_tz`	String
`mdf_system_object_type`	String
`mdf_system_record_id`	String
`mdf_system_record_status`	String
`mdf_system_status`	String
`mdf_system_transaction_sequence`	String
`mdf_system_version_id`	String
`percentage`	String
`custom_`

job_application_question_response

Column	Type	Keys
`order_id`	String	PK
`application_id`	String	PKFK
`answer`	String
`expected_answer`	String
`expected_answer_value`	Double
`high_low`	String
`max_length`	Double
`question`	String
`question_response`	String
`type`	String
`custom_`

fo_job_function

Column	Type	Keys
`external_code`	String	PK
`start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`description`	String
`description_de_de`	String
`description_default_value`	String
`description_en_debug`	String
`description_en_gb`	String
`description_en_us`	String
`description_es_es`	String
`description_fr_fr`	String
`description_ja_jp`	String
`description_ko_kr`	String
`description_localized`	String
`description_nl_nl`	String
`description_pt_br`	String
`description_pt_pt`	String
`description_ru_ru`	String
`description_zh_cn`	String
`description_zh_tw`	String
`end_date`	Instant
`job_function_type`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`mdf_system_record_id`	String
`name`	String
`name_de_de`	String
`name_default_value`	String
`name_en_debug`	String
`name_en_gb`	String
`name_en_us`	String
`name_es_es`	String
`name_fr_fr`	String
`name_ja_jp`	String
`name_ko_kr`	String
`name_localized`	String
`name_nl_nl`	String
`name_pt_br`	String
`name_pt_pt`	String
`name_ru_ru`	String
`name_zh_cn`	String
`name_zh_tw`	String
`parent_function_code`	String
`status`	String
`type`	String
`custom_`

form_signature

Column	Type	Keys
`form_data_id`	String	PK
`section_index`	Int	PK
`step_id`	String	PK
`form_content_id`	String	PKFK
`action_information`	String
`role_type`	String
`signed_by`	String
`signed_date`	String
`status`	String
`step_order`	Int
`custom_`

job_requisition_screening_question

Column	Type	Keys
`locale`	String	PK
`order_id`	String	PK
`job_req_id`	String	PKFK
`question_id`	String	FK
`question_parent_id`	String	FK
`disqualifier`	Boolean
`expected_answer_value`	Double
`expected_dir`	String
`job_req_content`	String
`max_length`	String
`question_description`	String
`question_parent_response`	String
`question_weight`	Double
`rating_scale`	String
`required`	Boolean
`score`	Boolean
`custom_`

form_user_rating_comment

Column	Type	Keys
`form_content_id`	String	PK
`form_data_id`	String	PK
`item_id`	String	PK
`rating_type`	String	PK
`section_index`	Int	PK
`user_id`	String	PKFK
`comment`	String
`comment_key`	String
`comment_label`	String
`comment_permission`	String
`first_name`	String
`full_name`	String
`last_name`	String
`rating`	String
`rating_key`	String
`rating_label`	String
`rating_permission`	String
`text_rating`	String
`custom_`

background_inside_work_experience

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`department`	String
`end_date`	Instant
`last_modified_date`	Instant
`start_date`	Instant
`title`	String
`custom_`

work_order

Column	Type	Keys
`effective_start_date`	Instant	PK
`user_id`	String	PK
`work_order_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`vendor`	String	FK
`billing_amount`	Double
`billing_rate`	String
`created_date`	Instant
`created_date_time`	Instant
`currency`	String
`effective_end_date`	Instant
`effective_status`	String
`end_date`	Instant
`last_modified_date_time`	Instant
`start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`work_order_name`	String
`work_order_owner_id`	String
`worker_type`	String
`custom_`

background_check_result

Column	Type	Keys
`id`	String	PK
`background_check_request_request_id`	Unknown	FK
`created_date_time`	Instant
`final_step`	Boolean
`report_url`	String
`step_message`	String
`step_name`	String
`step_status`	String
`vendor_code`	String
`vendor_order_no`	String
`custom_`

calibration_subject_rank

Column	Type	Keys
`subject_rank_id`	String	PK
`data_type`	Int
`rank`	Int
`rating_value`	Double
`custom_`

form_objective_section

Column	Type	Keys
`form_data_id`	String	PK
`section_index`	Int	PK
`form_content_id`	String	PKFK
`obj_plan_id`	String
`obj_plan_type`	String
`section_description`	String
`section_name`	String
`section_weight`	String
`section_weight_key`	String
`custom_`

fo_company

Column	Type	Keys
`external_code`	String	PK
`start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`country`	String
`created_date_time`	Instant
`created_on`	Instant
`currency`	String
`default_location`	String
`default_pay_group`	String
`description`	String
`description_de_de`	String
`description_default_value`	String
`description_en_gb`	String
`description_en_us`	String
`description_es_es`	String
`description_fr_fr`	String
`description_ja_jp`	String
`description_ko_kr`	String
`description_localized`	String
`description_nl_nl`	String
`description_pt_br`	String
`description_pt_pt`	String
`description_ru_ru`	String
`description_zh_cn`	String
`description_zh_tw`	String
`end_date`	Instant
`entity_oid`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`mdf_system_record_id`	String
`name`	String
`name_de_de`	String
`name_default_value`	String
`name_en_debug`	String
`name_en_gb`	String
`name_en_us`	String
`name_es_es`	String
`name_fr_fr`	String
`name_ja_jp`	String
`name_ko_kr`	String
`name_localized`	String
`name_nl_nl`	String
`name_pt_br`	String
`name_pt_pt`	String
`name_ru_ru`	String
`name_zh_cn`	String
`name_zh_tw`	String
`standard_hours`	Double
`status`	String
`custom_`

background_education

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`degree`	String	FK
`major`	String	FK
`school_country`	String	FK
`school_state`	String	FK
`background_order_position`	String
`degree_date`	Instant
`end_date`	Instant
`last_modified_date`	Instant
`school`	String
`school_address`	String
`school_city`	String
`school_type`	String
`school_zip`	String
`start_date`	Instant
`custom_`

form_360_participant

Column	Type	Keys
`form_data_id`	String	PK
`participant_id`	String	PK
`form_content_id`	String	PKFK
`is_external_user`	Boolean
`is_fixed_category`	Boolean
`is_removable`	Boolean
`participant_category`	String
`participant_category_key`	String
`participant_order`	Int
`participant_username`	String
`custom_`

fo_department

Column	Type	Keys
`external_code`	Unknown	PK
`start_date`	Instant	PK
`cost_center_nav_external_code`	Unknown	FK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`address_address_1`	Unknown
`address_address_2`	Unknown
`address_address_3`	Unknown
`address_address_4`	Unknown
`address_address_5`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_county`	Unknown
`address_province`	Unknown
`address_state`	Unknown
`address_zip_code`	Unknown
`company_flx`	Unknown
`cost_center`	Unknown
`created_date_time`	Unknown
`created_on`	Instant
`cust_to_legal_entity_prop`	Unknown
`description`	Unknown
`description_de_de`	Unknown
`description_default_value`	Unknown
`description_en_gb`	Unknown
`description_en_us`	Unknown
`description_es_es`	Unknown
`description_fr_fr`	Unknown
`description_ja_jp`	Unknown
`description_ko_kr`	Unknown
`description_localized`	Unknown
`description_nl_nl`	Unknown
`description_pt_br`	Unknown
`description_pt_pt`	Unknown
`description_ru_ru`	Unknown
`description_zh_cn`	Unknown
`description_zh_tw`	Unknown
`division_flx`	Unknown
`end_date`	Instant
`geozone_flx`	Unknown
`head_of_unit`	Unknown
`last_modified_date_time`	Unknown
`last_modified_on`	Instant
`location_group`	Unknown
`name`	Unknown
`name_de_de`	Unknown
`name_default_value`	Unknown
`name_en_gb`	Unknown
`name_en_us`	Unknown
`name_es_es`	Unknown
`name_fr_fr`	Unknown
`name_ja_jp`	Unknown
`name_ko_kr`	Unknown
`name_localized`	Unknown
`name_nl_nl`	Unknown
`name_pt_br`	Unknown
`name_pt_pt`	Unknown
`name_ru_ru`	Unknown
`name_zh_cn`	Unknown
`name_zh_tw`	Unknown
`parent`	Unknown
`standard_hours`	Unknown
`status`	Unknown
`timezone`	Unknown
`custom_`

candidate_background_inside_work_experience

Column	Type	Keys
`background_element_id`	String	PK
`candidate_id`	String	FK
`background_order_position`	String
`department`	String
`end_date`	Instant
`last_modified_date_time`	Instant
`start_date`	Instant
`title`	String
`custom_`

job_application_onboarding_status

Column	Type	Keys
`id`	String	PK
`onboarding_id`	String	FK
`created_date`	Instant
`last_modified_date`	Instant
`message`	String
`name`	String
`status`	String
`status_type`	String
`type`	String
`url`	String
`custom_`

form_behavior_rating_comment

Column	Type	Keys
`behavior_id`	String	PK
`form_data_id`	String	PK
`item_id`	String	PK
`rating_type`	String	PK
`section_index`	Int	PK
`form_content_id`	String	PKFK
`user_id`	String	PKFK
`comment`	String
`comment_key`	String
`comment_label`	String
`comment_permission`	String
`first_name`	String
`full_name`	String
`last_name`	String
`rating`	String
`rating_key`	String
`rating_label`	String
`rating_permission`	String
`text_rating`	String
`custom_`

background_var_pay_employee_hist_data

Column	Type	Keys
`background_element_id`	String	PK
`basis`	Double
`business_goal_code`	String
`country`	String
`currency_code`	String
`department`	String
`division`	String
`end_date`	Instant
`incentive_plan_code`	String
`job_title`	String
`last_modified_date`	Instant
`location`	String
`pay_grade`	String
`salary`	String
`start_date`	Instant
`tgt_pct`	Double
`user_id`	String
`var_pay_program_name`	String

employment_termination

Column	Type	Keys
`end_date`	Instant	PK
`id`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`benefits_end_date`	Instant
`bonus_pay_expiration_date`	Instant
`created_date_time`	Instant
`eligible_for_sal_continuation`	Boolean
`event_reason`	String
`last_date_worked`	String
`last_modified_date_time`	Instant
`new_main_employment_id`	String
`notes`	String
`ok_to_rehire`	Boolean
`payroll_end_date`	Instant
`regret_termination`	Boolean
`salary_end_date`	Instant
`stock_end_date`	Instant
`custom_`

employee_workflow_request

Column	Type	Keys
`id`	String	PK
`wf_request_id`	String	FK
`action_type`	String
`effective_date`	Instant
`entity_type`	String
`event_reason`	String
`request_type`	String
`subject_id`	String
`wf_config`	String
`custom_`

job_requisition_posting

Column	Type	Keys
`job_posting_id`	String	PK
`job_req_id`	String	PKFK
`last_modified_by`	String	FK
`posted_by`	String	FK
`agency_comments`	String
`board_name`	String
`channel_id`	String
`external_partner_account_id`	String
`last_modified_date_time`	Instant
`post_end_date`	Instant
`post_end_date_offset`	Instant
`post_start_date`	Instant
`post_start_date_offset`	Instant
`status`	String
`custom_`

work_schedule

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`average_hours_per_day`	String
`average_hours_per_month`	String
`average_hours_per_week`	String
`average_hours_per_year`	String
`average_working_days_per_week`	String
`country`	String
`created_date`	Instant
`created_date_time`	Instant
`external_name_default_value`	String
`external_name_localized`	String
`flexible_requesting_allowed`	Boolean
`individual_work_schedule`	Boolean
`last_modified_date_time`	Instant
`model_category`	String
`period_model`	String
`period_model_nav`	String
`search_string`	String
`shift_classification`	String
`starting_date`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`time_recording_variant`	String
`custom_`

background_award

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`description`	String
`institution`	String
`issue_date`	Instant
`last_modified_date`	Instant
`name`	String
`custom_`

offer_letter

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`body`	String
`body_locale`	String
`body_template_id`	String
`bonus_payout_freq`	String
`cand_response_comments`	String
`cand_response_date`	Instant
`comment`	String
`country_code`	String
`country_name`	String
`create_date`	Instant
`currency_code`	String
`job_start_date`	Instant
`job_title`	String
`last_modified_date`	Instant
`locale`	String
`locale_code`	String
`mailboxes`	String
`offer_expiration_date`	Instant
`offer_letter`	String
`offer_sent_date`	Instant
`overtime_rate`	String
`salary_rate`	String
`salary_rate_type`	String
`send_mode`	String
`status`	String
`stock_grant`	String
`stock_option`	String
`subject`	String
`target_bonus_amount`	Double
`target_bonus_percent`	String
`template_id`	String
`template_name`	String
`tokens`	String
`custom_`

onboarding_process

Column	Type	Keys
`process_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`activities_config`	String
`activities_status`	String
`bpe_process_instance_id`	String
`cancel_event_reason`	String
`cancel_offboarding_reason`	String
`cancel_onboarding_reason`	String
`cancellation_comment`	String
`cancellation_date`	Instant
`cancellation_source`	String
`cancelled_due_to_restart`	Boolean
`created_date_time`	Instant
`employee_person_id`	String
`end_date`	Instant
`last_modified_date_time`	Instant
`locale`	String
`manager`	String
`manager_person_id`	String
`mdf_system_record_status`	String
`offboarding_activities_config`	String
`onb_2_master_id`	String
`onboarding_auto_hire_status`	Unknown
`onboarding_hire_status`	String
`onboarding_hired_date`	Instant
`onboarding_internal_hire`	Boolean
`process_restart_needed`	Boolean
`process_restarted`	Boolean
`process_status`	String
`process_trigger`	String
`process_type`	String
`process_variant`	String
`stable_id`	String
`start_date`	Instant
`target_date`	Instant
`target_system`	String
`user`	String
`custom_`

workflow_request

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_id`	String	FK
`created_date_time`	Instant
`current_step_num`	String
`last_modified_date_time`	Instant
`module`	String
`parent_wf_request_nav`	String
`reminder_sent_date`	Instant
`status`	String
`total_steps`	String
`url`	String
`custom_`

holiday

Column	Type	Keys
`id`	String	PK
`country`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`last_modified_date_time`	Instant
`name_default_value`	String
`name_localized`	String
`old_name`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

external_time_record

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`date`	Instant
`delete_external_time`	Boolean
`last_modified_date_time`	Instant
`status`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

background_talent_pool

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`talent_poolitem`	Unknown	FK
`background_order_position`	String
`last_modified_date`	Instant
`start_date`	Instant
`talent_pool_comments`	String
`talent_pool_item`	String
`talent_pool_status`	String
`custom_`

work_opportunity_tax_credit

Column	Type	Keys
`id`	String	PKFK
`wotc_forms_url`	String
`wotc_id`	String
`wotc_screening_url`	String
`wotc_status`	String
`custom_`

form_360_participant_config

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`custom_`

per_personal

Column	Type	Keys
`person_id_external`	Unknown	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`attachment_id`	Unknown
`business_first_name`	Unknown
`business_last_name`	Unknown
`created_date_time`	Instant
`created_on`	Instant
`display_name`	Unknown
`end_date`	Unknown
`first_name`	Unknown
`gender`	Unknown
`include_all_records`	Unknown
`initials`	Unknown
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`last_name`	Unknown
`marital_status`	Unknown
`middle_name`	Unknown
`nationality`	Unknown
`native_preferred_lang`	Unknown
`operation`	Unknown
`person_nav_birth_name`	Unknown
`person_nav_country_of_birth`	Unknown
`person_nav_created_by`	Unknown
`person_nav_created_date_time`	Unknown
`person_nav_created_on`	Unknown
`person_nav_date_of_birth`	Unknown
`person_nav_include_all_records`	Unknown
`person_nav_last_modified_by`	Unknown
`person_nav_last_modified_date_time`	Unknown
`person_nav_last_modified_on`	Unknown
`person_nav_per_person_uuid`	Unknown
`person_nav_person_id`	Unknown
`person_nav_person_id_external`	Unknown
`person_nav_region_of_birth`	Unknown
`person_nav_user_id`	Unknown
`preferred_name`	Unknown
`salutation`	Unknown
`script`	Unknown
`since`	Unknown
`start_date`	Unknown
`title`	Unknown
`custom_`

currency_conversion

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`to_currency`	String	FK
`base_currency`	String
`conversion_rate`	String
`created_date_time`	Instant
`effective_end_date`	Instant
`effective_status`	String
`exchange_rate_type`	String
`external_name_default_value`	String
`external_name_localized`	String
`last_modified_date_time`	Instant
`system_created_by`	String
`system_created_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

employee_pay_comp_recurring

Column	Type	Keys
`pay_component`	String	PK
`seq_number`	String	PK
`start_date`	Instant	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`currency_code`	String
`end_date`	Instant
`frequency`	String
`last_modified_date_time`	Instant
`notes`	String
`operation`	String
`paycompvalue`	Double
`custom_`

time_account_type

Column	Type	Keys
`id`	String	PK
`country`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`account_booking_offset_in_months`	String
`account_creation_automation_level`	String
`account_creation_day`	String
`account_creation_month`	String
`account_creation_offset_in_months`	String
`account_detail_retention_group`	String
`account_retention_group`	String
`accrual_automation_level`	String
`accrual_calculation_method`	String
`accrual_creation_offset`	String
`accrual_frequency`	String
`accrual_period_start_day`	String
`accrual_period_start_month`	String
`accrual_recalculation_posting_method`	String
`accrual_rule`	String
`accrual_transfer_date_rule`	String
`accrual_transfer_rule`	String
`accrual_waiting_period`	String
`accrual_waiting_period_unit`	String
`advances_allowed`	Boolean
`allow_payout_with_simulation`	String
`calculate_snapshot_approved_absence_balance`	Boolean
`created_date`	Instant
`created_date_time`	Instant
`creation`	String
`entitlement_method`	String
`external_name_default_value`	String
`external_name_localized`	String
`hire_rule`	String
`initial_accrual_transfer_date_rule`	String
`initial_flexible_account_start_date_rule`	String
`interim_rule`	String
`last_modified_date_time`	Instant
`level_of_simulation_precision`	String
`maximum_simulation_horizon_in_months`	String
`minimum_balance_allowed`	String
`pay_component`	String
`pay_component_accrual_separated`	String
`pay_component_group`	String
`pay_component_termination`	String
`pay_component_termination_accrual_separated`	String
`payout_eligibility`	String
`pep_calendar_automation_level`	String
`period_end_processing_rule`	String
`posting_order`	String
`second_accrual_creation_offset`	String
`simulate_accruals`	Boolean
`simulation_rule`	String
`snapshots_allowed`	Boolean
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`termination_rule`	String
`termination_rule_data_effective_date`	Instant
`unit`	String
`custom_`

currency

Column	Type	Keys
`code`	String	PK
`effective_start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`default_decimals`	String
`description_default_value`	String
`description_localized`	String
`effective_end_date`	Instant
`external_name_default_value`	String
`external_name_localized`	String
`last_modified_date_time`	Instant
`status`	String
`symbol`	String
`system_created_by`	String
`system_created_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

job_application_status_label

Column	Type	Keys
`id`	String	PKFK
`candidate_label`	String
`locale`	String
`status_label`	String
`custom_`

per_global_info_usa

Column	Type	Keys
`country`	String	PK
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`generic_date_1`	Instant
`generic_date_10`	Instant
`generic_date_2`	Instant
`generic_date_3`	Instant
`generic_date_4`	Instant
`generic_date_5`	Instant
`generic_date_6`	Instant
`generic_date_7`	Instant
`generic_number_1`	String
`generic_number_10`	String
`generic_number_11`	String
`generic_number_12`	String
`generic_number_13`	String
`generic_number_14`	String
`generic_number_15`	String
`generic_number_16`	String
`generic_number_2`	String
`generic_number_3`	String
`generic_number_4`	String
`generic_number_5`	String
`generic_number_6`	String
`generic_number_7`	String
`generic_number_8`	String
`generic_number_9`	String
`generic_string_1`	String
`generic_string_10`	String
`generic_string_11`	String
`generic_string_12`	String
`generic_string_13`	String
`generic_string_14`	String
`generic_string_15`	String
`generic_string_16`	String
`generic_string_2`	String
`generic_string_3`	String
`generic_string_4`	String
`generic_string_5`	String
`generic_string_6`	String
`generic_string_7`	String
`generic_string_8`	String
`generic_string_9`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`custom_`

candidate_background_talent_pool_corp

Column	Type	Keys
`background_element_id`	String	PK
`background_order_position`	String	PK
`candidate_id`	String	PKFK
`talent_pool_item_corp`	String	FK
`talent_pool_status`	String	FK
`last_modified_date_time`	Instant
`start_date`	Instant
`talent_pool_comments`	String
`custom_`

form_360_participant_category

Column	Type	Keys
`category_value`	String	PK
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`category_label`	String
`category_order`	Int
`custom_`

fo_translation

Column	Type	Keys
`external_code`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`fo_field`	String
`fo_objectid`	String
`fo_type`	String
`last_modified_date`	Instant
`last_modified_date_time`	Instant
`last_modified_date_with_tz`	Instant
`mdf_system_effective_end_date`	Instant
`mdf_system_effective_start_date`	Instant
`mdf_system_entity_id`	String
`mdf_system_object_type`	String
`mdf_system_record_id`	String
`mdf_system_record_status`	String
`mdf_system_status`	String
`mdf_system_transaction_sequence`	String
`mdf_system_version_id`	String
`value_de_de`	String
`value_default_value`	String
`value_en_debug`	String
`value_en_gb`	String
`value_en_us`	String
`value_es_es`	String
`value_fr_fr`	String
`value_ja_jp`	String
`value_ko_kr`	String
`value_localized`	String
`value_nl_nl`	String
`value_pt_br`	String
`value_pt_pt`	String
`value_ru_ru`	String
`value_zh_cn`	String
`value_zh_tw`	String
`custom_`

form_objective

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`form_content_id`	String	PKFK
`category`	String
`done`	String
`item_order`	Int
`metric`	String
`name`	String
`state`	String
`state_color`	String
`use_mlt_rating`	Boolean
`weight`	String
`weight_key`	String
`custom_`

form_360_participant_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

external_personal_info

Column	Type	Keys
`id`	String	PK
`first_name`	String
`last_modified_date_time`	Instant
`last_name`	String
`middle_name`	String

job_requisition_operator

Column	Type	Keys
`operator_role_id`	String	PK
`job_req_id`	String	PKFK
`user_id`	String	FK
`admin_selected_user_to_be_removed`	Boolean
`email`	String
`fax`	String
`first_name`	String
`is_admin_selected`	Boolean
`last_name`	String
`phone`	String
`user_name`	String
`custom_`

background_promotability

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`comment`	String
`function`	String
`last_modified_date`	Instant
`level`	String
`timeframe`	String
`custom_`

job_application_audit

Column	Type	Keys
`field_order_position`	String	PK
`rev_number`	String	PK
`changed_by`	String	FK
`job_posting_id`	String	FK
`last_modified_by`	String	FK
`clob_field_ref`	String
`clob_new_value`	String
`clob_old_value`	String
`date_new_value`	String
`date_old_value`	String
`field_id`	String
`field_type`	String
`job_post_end_date`	Instant
`job_post_start_date`	Instant
`last_modified_date`	Instant
`last_modified_external_id`	String
`merged_from`	String
`new_value`	String
`old_value`	String
`ref_type`	String
`rev_type`	String
`source`	String
`custom_`

form_template

Column	Type	Keys
`id`	String	PK
`name`	String
`type`	String
`custom_`

job_application_interview

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`cand_slot_map_id`	String
`end_date`	Instant
`is_time_set`	Int
`notes`	String
`recruit_event_staff_id`	String
`source`	String
`start_date`	Instant
`status`	String
`template_type`	String
`custom_`

background_certificates

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`license_country`	String	FK
`license_state`	String	FK
`background_order_position`	String
`description`	String
`end_date`	Instant
`institution`	String
`last_modified_date`	Instant
`license_name`	String
`license_number`	String
`name`	String
`start_date`	Instant
`custom_`

position_matrix_relationship

Column	Type	Keys
`matrix_relationship_type`	String	PK
`position_effective_start_date`	Instant	PK
`position_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	Unknown	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`related_position`	String
`system_created_by`	String
`system_created_date`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

job_application

Column	Type	Keys
`id`	String	PK
`app_status_set_id`	Unknown	FK
`candidate_id`	String	FK
`country_code`	String	FK
`job_code`	String	FK
`job_req_id`	String	FK
`last_modified_by`	String	FK
`referred_by`	String	FK
`user_id`	Unknown	FK
`address`	String
`address_2`	String
`agency_info`	String
`app_locale`	String
`app_status_set_item_id`	String
`average_rating`	String
`base_salary`	String
`cand_conversion_processed`	String
`cand_just`	String
`cand_type_when_hired`	String
`cell_phone`	String
`city`	String
`conf_number`	String
`contact_email`	String
`conviction_details`	String
`country`	String
`criminal_conviction_instructions`	String
`criminal_conviction_label`	String
`current_location`	String
`current_title`	String
`cust_ref_check_first_name`	String
`cust_ref_check_last_name`	String
`cust_ref_check_org`	String
`cust_ref_check_phone`	String
`cust_ref_check_title`	String
`data_source`	String
`date_avail`	String
`date_of_birth`	Instant
`duplicate_profile`	String
`exported_on`	String
`external_title`	String
`first_name`	String
`former_employee`	Boolean
`gender`	String
`have_you_been_convicted`	String
`hire_date`	Instant
`hired_on`	String
`home_phone`	String
`induction_add`	String
`induction_date`	Instant
`instr_additional_documents`	String
`instr_app_additional_info`	String
`instr_app_advice`	String
`instr_app_return`	String
`instr_cand_app_details`	String
`instr_cand_approval`	String
`instr_cand_assess`	String
`instr_cand_fields`	String
`instr_cand_pers_info`	String
`instr_cand_screen`	String
`instr_eeoinstructions`	String
`instr_eeolable`	String
`instr_wotc`	String
`job_app_guid`	String
`job_offer_date`	String
`job_rate_of_pay`	String
`job_start_date`	Instant
`known_as`	String
`last_modified_by_proxy`	String
`last_modified_date_time`	Instant
`last_name`	String
`med_date`	Instant
`med_loc`	String
`med_time`	String
`middle_name`	String
`non_applicant_status`	String
`owner`	String
`ownership_date`	Instant
`phone_screen_date`	Instant
`phone_screen_details`	String
`please_select`	String
`pos_title`	String
`profile_updated`	String
`psych_test_date`	String
`psych_test_time`	String
`rating`	String
`reasonable_accomodation`	String
`reference`	String
`reference_comments`	String
`resume_upload_date`	Instant
`screen_date`	String
`snap_shot_date`	Instant
`source`	String
`source_label`	String
`ssn`	String
`start_date`	Instant
`state_other`	String
`status`	String
`status_comments`	String
`time_to_hire`	Double
`title`	String
`user_system_id`	String
`visa_num`	String
`zip`	String
`custom_`

external_time_data

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`category`	String
`cost_center`	String
`created_date_time`	Instant
`delete_external_time`	Boolean
`end_date`	Instant
`end_time`	String
`hours`	String
`last_modified_date_time`	Instant
`logical_date`	Instant
`start_date`	Instant
`start_time`	String
`status`	String
`system_record_status`	String
`time_type`	String
`custom_`

job_requisition_locale

Column	Type	Keys
`id`	String	PK
`job_req_id`	String	FK
`external_job_desc_footer`	String
`external_job_desc_header`	String
`external_job_description`	String
`external_title`	String
`internal_job_desc_footer`	String
`internal_job_desc_header`	String
`job_description`	String
`job_title`	String
`locale`	String
`status`	String
`template_header_footer`	String
`custom_`

form_objective_other_details_item

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`type`	Int	PK
`form_content_id`	String	PKFK
`title`	String
`custom_`

job_offer_approver

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`offer_approval_id`	String	FK
`offer_approver_id`	Unknown	FK
`approval_step_id`	String
`approver_action`	String
`approver_action_date`	Instant
`approver_first_name`	String
`approver_last_name`	String
`approver_order`	String
`comment`	String
`created_date`	Instant
`last_modified_date`	Instant
`username`	String
`custom_`

fo_division

Column	Type	Keys
`external_code`	Unknown	PK
`start_date`	Instant	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`business_unit_flx`	Unknown
`created_date_time`	Instant
`created_on`	Instant
`description`	Unknown
`description_de_de`	Unknown
`description_default_value`	Unknown
`description_en_gb`	Unknown
`description_en_us`	Unknown
`description_es_es`	Unknown
`description_fr_fr`	Unknown
`description_ja_jp`	Unknown
`description_ko_kr`	Unknown
`description_localized`	Unknown
`description_nl_nl`	Unknown
`description_pt_br`	Unknown
`description_pt_pt`	Unknown
`description_ru_ru`	Unknown
`description_zh_cn`	Unknown
`description_zh_tw`	Unknown
`end_date`	Instant
`head_of_unit`	Unknown
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`name`	Unknown
`name_de_de`	Unknown
`name_default_value`	Unknown
`name_en_gb`	Unknown
`name_en_us`	Unknown
`name_es_es`	Unknown
`name_fr_fr`	Unknown
`name_ja_jp`	Unknown
`name_ko_kr`	Unknown
`name_localized`	Unknown
`name_nl_nl`	Unknown
`name_pt_br`	Unknown
`name_pt_pt`	Unknown
`name_ru_ru`	Unknown
`name_zh_cn`	Unknown
`name_zh_tw`	Unknown
`parent`	Unknown
`status`	Unknown
`custom_`

employee_time_calendar

Column	Type	Keys
`employee_time_id`	String	PK
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`work_schedule_internal_id`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`date`	Instant
`deduction_quantity`	String
`end_time`	String
`last_modified_date_time`	Instant
`quantity_in_days`	String
`quantity_in_hours`	String
`start_time`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

per_global_info_irl

Column	Type	Keys
`country`	String	PK
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`attachment_id`	String
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`generic_date_1`	Instant
`generic_number_1`	String
`generic_string_1`	String
`generic_string_2`	String
`generic_string_3`	String
`generic_string_4`	String
`generic_string_5`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`custom_`

pick_list_value

Column	Type	Keys
`id`	String	PK
`pick_list_v_2_effective_start_date`	Instant	PK
`pick_list_v_2_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_pick_list_value`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`l_value`	String
`label_default_value`	String
`label_localized`	String
`last_modified_date_time`	Instant
`legacy_status`	String
`max_val`	String
`min_val`	String
`non_unique_external_code`	String
`opt_value`	String
`option_id`	String
`r_value`	String
`status`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

holiday_calendar

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`nominee_user_id`	Unknown	FK
`country`	String
`created_date`	Instant
`created_date_time`	Instant
`last_modified_date_time`	Instant
`name_default_value`	String
`name_localized`	String
`old_name`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

country

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`created_by`	String	FK
`currency`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`effective_end_date`	Instant
`external_name_default_value`	String
`external_name_localized`	String
`is_drm_enabled`	Boolean
`is_set_by_migrate`	Boolean
`last_modified_date_time`	Instant
`numeric_country_code`	String
`status`	String
`system_created_by`	String
`system_created_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`territory_id`	String
`two_char_country_code`	String
`custom_`

background_languages

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`language_id`	String
`last_modified_date`	Instant
`reading_prof`	String
`speaking_prof`	String
`variant`	String
`writing_prof`	String
`custom_`

job_application_onboarding

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`submitted_by`	String	FK
`status`	String
`submitted_on`	Instant
`custom_`

form_route_step

Column	Type	Keys
`form_data_id`	String	PK
`step_order`	Int	PK
`completed`	Boolean
`current`	Boolean
`due_date`	String
`over_due`	Boolean
`stage_name`	String
`stage_type`	String
`step_description`	String
`step_name`	String
`user_full_name`	String
`user_role`	String
`custom_`

team_goal_owner

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`obj_id`	String
`owner_type`	String
`system_created_by`	String
`system_created_date`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

candidate_comments

Column	Type	Keys
`id`	String	PK
`candidate_id`	String	FK
`associated_comment_id`	String
`associated_id`	String
`commentator`	String
`content`	String
`has_associated_comment`	String
`migrated_commentator_user_name`	String
`ref_type`	String
`custom_`

form_review_feedback

Column	Type	Keys
`feedback_id`	String	PK
`appraiser_user_email`	String
`appraiser_user_id`	String
`company_id`	String
`digi_code`	String
`form_data_id`	String
`pm_feedback`	String
`request_date`	Instant
`request_user_email`	String
`request_user_id`	String
`request_user_role`	String
`response_date`	Instant
`response_id`	String
`subject_user_email`	String
`subject_user_id`	String
`custom_`

background_check_request

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`created_by`	String	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`order_status`	String
`response_code`	String
`response_detail`	String
`vendor_code`	String
`vendor_order_no`	String
`custom_`

position_right_to_return

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`position`	String	FK
`user_id`	String	FK
`created_date_time`	Instant
`effective_status`	String
`end_date`	Instant
`ga_end_job_info_id`	String
`ga_event_reason`	String
`ga_start_job_info_id`	String
`last_modified_by`	String
`last_modified_date_time`	Instant
`loa_time_type`	String
`pos_tbhend_row_id`	String
`pos_tbhstart_row_id`	String
`reason`	String
`root_object_id`	String
`start_date`	Instant
`system_record_status`	String
`custom_`

employee_beneficiary

Column	Type	Keys
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`payroll_end_date`	Instant
`person_id_external`	String
`planned_end_date`	Instant
`start_date`	Instant
`custom_`

employee_pension_payout

Column	Type	Keys
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`person_id_external`	String	FK
`created_date_time`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`payroll_end_date`	Instant
`planned_end_date`	Instant
`start_date`	Instant
`custom_`

form_objective_other_details_item_value_cell

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`type`	Int	PK
`form_content_id`	String	PKFK
`col_id`	String
`col_index`	Int
`datatype`	String
`row_index`	Int
`value`	String
`custom_`

form_obj_comp_summary_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_comments_label`	String
`section_description`	String
`section_index`	String
`section_name`	String
`custom_`

onboarding_process_task

Column	Type	Keys
`task_id`	String	PK
`process_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`comment`	Unknown
`completed_by`	String
`created_date_time`	Instant
`end_date`	Instant
`extension_task_ref_id`	Unknown
`last_modified_date_time`	Instant
`mdf_system_record_status`	String
`responsibility_config`	String
`start_date`	Instant
`status`	String
`task_due_date`	Instant
`type`	String
`custom_`

form_competency_behavior

Column	Type	Keys
`behavior_id`	String	PK
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`form_content_id`	String	PKFK
`behavior_index`	String
`behavior_name`	String
`category`	String
`description`	String
`expected_rating`	String
`weight`	String
`weight_key`	String
`custom_`

employee_time_sheet_entry

Column	Type	Keys
`id`	String	PK
`employee_time_sheet_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`cost_center`	String
`created_date`	Instant
`created_date_time`	Instant
`employee_time`	String
`end_time`	String
`last_modified_date_time`	Instant
`quantity_in_hours`	String
`start_date`	Instant
`start_time`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`time_type_name`	String
`custom_`

pick_list

Column	Type	Keys
`_fivetran_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_pick_list_nav`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`display_order`	String
`effective_end_date`	Instant
`effective_start_date`	Instant
`id`	String
`last_modified_date_time`	Instant
`legacy_pick_list_id`	String
`name`	String
`parent_pick_list`	String
`picklist_creation_source`	String
`status`	String
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

form_objective_comment

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`type`	Int	PK
`form_content_id`	String	PKFK
`user_id`	String	PKFK
`comment_date`	String
`comment_text`	String
`field_data_type`	String
`label`	String
`objective_comment_order`	Int
`custom_`

candidate_background_talent_pool

Column	Type	Keys
`background_element_id`	String	PK
`background_order_position`	String	PK
`candidate_id`	String	PKFK
`last_modified_date_time`	Instant
`start_date`	Instant
`talent_pool_comments`	String
`talent_pool_item`	String
`talent_pool_status`	String
`custom_`

form_360_participant_column

Column	Type	Keys
`column_key`	String	PK
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`column_label`	String
`column_order`	Int
`custom_`

employee_time

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`workflow_request_id`	String	FK
`approval_status`	String
`cancellation_workflow_request_id`	String
`comment`	String
`created_date`	Instant
`created_date_time`	Instant
`cust_deliverytype`	String
`cust_expectedweek`	String
`cust_notificationdate`	String
`deduction_quantity`	String
`editable`	Boolean
`end_date`	Instant
`end_time`	String
`flexible_requesting`	Boolean
`fraction_quantity`	String
`last_modified_date_time`	Instant
`loa_actual_return_date`	Instant
`loa_end_job_info_id`	String
`loa_expected_return_date`	Instant
`loa_start_job_info_id`	String
`original_quantity_in_days`	String
`quantity_in_days`	String
`quantity_in_hours`	String
`recurrence_group`	String
`start_date`	Instant
`start_time`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`time_record_origin`	String
`time_type`	String
`undetermined_end_date`	Boolean
`workflow_initiated_by_admin`	Boolean
`custom_`

job_requisition

Column	Type	Keys
`id`	String	PK
`job_code`	String	FK
`last_modified_by`	String	FK
`status_set_id`	String	FK
`accommodation_cost`	String
`age`	String
`agency_fee`	String
`annual_cash_pay`	String
`annual_fb`	String
`annual_gratuity`	String
`annual_pf`	String
`annual_retirals`	String
`annual_sa`	String
`app_template_id`	String
`assess_rating_scale_name`	String
`candidate_progress`	String
`city`	String
`classification_time`	String
`classification_type`	String
`closed_date_time`	Instant
`comment`	String
`comment_equip`	String
`commission`	String
`corporate_posting`	Boolean
`cost_center_id`	String
`cost_of_hire`	String
`country`	String
`created_date_time`	Instant
`currency`	String
`default_language`	String
`deleted`	String
`department`	String
`division`	String
`erp_amount`	Double
`facility`	String
`form_data_id`	String
`form_due_date`	Instant
`function`	String
`hiring_manager_note`	String
`industry`	String
`instr_cost_hire`	String
`instr_equest`	String
`instr_equipment`	String
`instr_ers`	String
`instr_interview`	String
`instr_involved_parties`	String
`instr_managernote`	String
`instr_overall_comments`	String
`instr_pd`	String
`instr_rec_cost`	String
`instr_req`	String
`instr_req_dates`	String
`instr_req_details`	String
`instr_req_justify`	String
`instr_req_require`	String
`instr_salary`	String
`internal_status`	String
`intranet_posting`	Boolean
`is_draft`	Boolean
`job_req_guid`	String
`job_role`	String
`job_start_date`	Instant
`last_modified_date_time`	Instant
`last_modified_proxy_user_id`	String
`legentity`	String
`location`	String
`misc_cost`	String
`monthly_cash_pay`	String
`monthly_fb`	String
`monthly_gratuity`	String
`monthly_pf`	String
`monthly_retirals`	String
`monthly_sa`	String
`monthly_salary`	String
`number_openings`	String
`openings_filled`	String
`other_bonus`	String
`other_comms`	String
`other_compensation`	String
`other_equip`	String
`overall_scale_name`	String
`position_number`	String
`postalcode`	String
`rated_applicant_count`	String
`recruit_just`	String
`replacement_for_whom`	String
`restore_hiring_manager_team_admin_defaults`	Boolean
`restore_recruiter_team_admin_defaults`	Boolean
`restore_sourcer_team_admin_defaults`	Boolean
`restore_vp_of_staffing_team_admin_defaults`	Boolean
`reverse_scale`	String
`sal_rate_type`	String
`salary_base`	String
`salary_comment`	String
`salary_max`	String
`salary_min`	String
`state_province`	String
`stock_package`	String
`target_bonus_amount`	Double
`temp_date`	Instant
`template_id`	String
`template_type`	String
`time_to_fill`	String
`total_earnings`	String
`total_fixed_pay`	String
`total_hire_cost`	String
`travel_cost`	String
`work_hours`	String
`custom_`

employee_job

Column	Type	Keys
`seq_number`	String	PK
`start_date`	Instant	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`manager_id`	String	FK
`assedic_cert_initial_state_num`	String
`assedic_cert_object_num`	String
`business_unit`	String
`company`	String
`contract_reference_for_aed`	String
`contract_type`	String
`cost_center`	String
`country_of_company`	String
`created_date_time`	Instant
`default_overtime_compensation_variant`	String
`department`	String
`division`	String
`eeo_1_job_category`	String
`eeo_4_job_category`	String
`eeo_5_job_category`	String
`eeo_6_job_category`	String
`eeo_class`	String
`electoral_college_for_workers_representatives`	String
`electoral_college_for_works_council`	String
`emp_relationship`	String
`empl_status`	String
`employee_class`	String
`employee_workgroup_membership`	String
`employment_type`	String
`end_date`	Instant
`event`	String
`event_reason`	String
`excl_executive_sector`	Boolean
`family_relationship_with_employer`	String
`fgts_date`	Instant
`fgts_percent`	Double
`flsa_status`	String
`fte`	Double
`harmful_agent_exposure`	String
`health_risk`	Boolean
`holiday_calendar_code`	String
`is_competition_clause_active`	Boolean
`is_fulltime_employee`	Boolean
`is_side_line_job_allowed`	Boolean
`job_code`	String
`job_title`	String
`labor_protection`	Boolean
`last_modified_date_time`	Instant
`location`	String
`municipal_insee_code`	String
`notes`	String
`pay_grade`	String
`pay_scale_area`	String
`pay_scale_group`	String
`pay_scale_level`	String
`pay_scale_type`	String
`position`	String
`position_entry_date`	Instant
`probation_period_end_date`	Instant
`regular_temp`	String
`resident_vote`	Boolean
`sick_pay_supplement`	String
`standard_hours`	Double
`teachers_pension`	Boolean
`time_recording_admissibility_code`	String
`time_recording_profile_code`	String
`time_recording_variant`	String
`time_type_profile_code`	String
`timezone`	String
`travel_distance`	Double
`work_location`	String
`worker_category`	String
`working_days_per_week`	Double
`workschedule_code`	String
`custom_`

form_objective_other_details_item_col

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`type`	Int	PK
`form_content_id`	String	PKFK
`data_type`	String
`description`	String
`id`	String
`index`	Int
`label`	String
`custom_`

users

Column	Type	Keys
`id`	String	PK
`competency`	Double	FK
`country`	String	FK
`emp_id`	String	FK
`hr_id`	String	FK
`job_code`	String	FK
`manager_id`	String	FK
`onboarding_id`	String	FK
`address_line_1`	String
`address_line_2`	String
`address_line_3`	String
`assignment_uuid`	Unknown
`bench_strength`	String
`bonus_budget_amount`	Double
`bonus_target`	Double
`business_phone`	String
`business_segment`	String
`cell_phone`	String
`citizenship`	String
`city`	String
`critical_talent_comments`	String
`date_of_birth`	Instant
`date_of_current_position`	String
`date_of_position`	String
`default_full_name`	String
`default_locale`	String
`department`	String
`display_name`	Unknown
`division`	String
`email`	String
`employee_class`	String
`ethnicity`	String
`fax`	String
`final_job_code`	String
`final_job_family`	String
`final_job_role`	String
`first_name`	String
`future_leader`	Boolean
`gender`	String
`hire_date`	Instant
`home_phone`	String
`impact_of_loss`	String
`impact_of_loss_comments`	String
`issue_comments`	String
`job_family`	String
`job_level`	String
`job_role`	String
`job_title`	String
`key_position`	Boolean
`last_modified_date_time`	Instant
`last_name`	String
`last_review_date`	Instant
`level`	String
`local_currency_code`	String
`location`	String
`lumpsum_2_target`	Double
`lumpsum_target`	Double
`married`	Boolean
`matrix_1_label`	String
`matrix_2_label`	String
`matrix_managed`	Boolean
`merit_effective_date`	Instant
`merit_target`	String
`mi`	String
`minority`	Boolean
`nationality`	String
`new_to_position`	Boolean
`nickname`	String
`objective`	Double
`orig_hire_date`	Instant
`pay_grade`	String
`performance`	Double
`potential`	Double
`promotion_amount`	Double
`raise_prorating`	Double
`reason_for_leaving`	String
`relo_comments`	String
`relo_location`	String
`relo_willing`	String
`review_freq`	String
`risk_of_loss`	String
`salary`	Double
`salary_budget_extra_2_percentage`	Double
`salary_budget_extra_percentage`	Double
`salary_budget_final_salary_percentage`	Double
`salary_budget_lumpsum_percentage`	Double
`salary_budget_merit_percentage`	Double
`salary_budget_promotion_percentage`	Double
`salary_budget_total_raise_percentage`	Double
`salary_local`	Double
`salary_prorating`	Double
`salutation`	String
`sci_last_modified`	Instant
`seating_chart`	String
`service_date`	Instant
`ssn`	String
`state`	String
`status`	String
`stock_budget_option_amount`	Double
`stock_budget_other_1_amount`	Double
`stock_budget_other_2_amount`	Double
`stock_budget_other_3_amount`	Double
`stock_budget_stock_amount`	Double
`stock_budget_unit_amount`	Double
`suffix`	String
`system_cost_of_source`	Double
`system_source`	String
`system_starting_salary`	Double
`time_zone`	String
`title`	String
`username`	String
`veteran_disabled`	Boolean
`veteran_medal`	Boolean
`veteran_protected`	Boolean
`veteran_separated`	Boolean
`zip_code`	String
`custom_`

fo_business_unit

Column	Type	Keys
`external_code`	Unknown	PK
`start_date`	Instant	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`created_date_time`	Instant
`created_on`	Instant
`description`	Unknown
`description_de_de`	Unknown
`description_default_value`	Unknown
`description_en_gb`	Unknown
`description_en_us`	Unknown
`description_es_es`	Unknown
`description_fr_fr`	Unknown
`description_ja_jp`	Unknown
`description_ko_kr`	Unknown
`description_localized`	Unknown
`description_nl_nl`	Unknown
`description_pt_br`	Unknown
`description_pt_pt`	Unknown
`description_ru_ru`	Unknown
`description_zh_cn`	Unknown
`description_zh_tw`	Unknown
`end_date`	Instant
`head_of_unit`	Unknown
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`name`	Unknown
`name_de_de`	Unknown
`name_default_value`	Unknown
`name_en_gb`	Unknown
`name_en_us`	Unknown
`name_es_es`	Unknown
`name_fr_fr`	Unknown
`name_ja_jp`	Unknown
`name_ko_kr`	Unknown
`name_localized`	Unknown
`name_nl_nl`	Unknown
`name_pt_br`	Unknown
`name_pt_pt`	Unknown
`name_ru_ru`	Unknown
`name_zh_cn`	Unknown
`name_zh_tw`	Unknown
`status`	Unknown
`custom_`

interview_individual_assessment

Column	Type	Keys
`id`	String	PK
`interview_overall_assessment_id`	String	FK
`comment`	String
`is_deleted`	String
`rating`	String
`ref_id`	String
`type`	String
`custom_`

form_audit_trail

Column	Type	Keys
`audit_trail_id`	String	PK
`form_content_id`	String	FK
`audit_trail_action`	String
`audit_trail_co_sender`	String
`audit_trail_comment`	String
`audit_trail_last_modified`	Instant
`audit_trail_recipient`	String
`audit_trail_send_proxy`	String
`audit_trail_sender`	String
`form_content_associated_step_id`	String
`form_data_id`	String
`custom_`

job_application_status

Column	Type	Keys
`id`	String	PK
`app_status_id`	String	FK
`app_status_name`	String
`custom_`

position

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`created_by`	String	FK
`job_code`	String	FK
`last_modified_by`	String	FK
`legacy_position_id`	String	FK
`business_unit`	String
`change_reason`	String
`comment`	String
`company`	String
`cost_center`	String
`created_date`	Instant
`created_date_time`	Instant
`creation_source`	String
`criticality`	String
`department`	String
`description`	String
`division`	String
`effective_end_date`	Instant
`effective_status`	String
`employee_class`	String
`external_name_default_value`	String
`external_name_localized`	String
`incumbent`	String
`job_level`	String
`job_title`	String
`last_modified_date_time`	Instant
`location`	String
`multiple_incumbents_allowed`	Boolean
`parent_position`	String
`pay_grade`	String
`pay_range`	String
`position_controlled`	Boolean
`position_criticality`	String
`position_title`	String
`regular_temporary`	String
`standard_hours`	String
`system_entity_id`	String
`system_object_type`	String
`system_optimistic_lock_uuid`	String
`system_record_id`	String
`system_record_status`	String
`system_version_id`	String
`target_fte`	String
`technical_parameters`	String
`transaction_sequence`	String
`type`	String
`vacant`	Boolean
`custom_`

form_user_information_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

employee_time_account_balance

Column	Type	Keys
`time_account_id`	String	PK
`time_account_type_id`	String	PKFK
`user_id`	String	PKFK
`account_closed`	Boolean
`balance`	String
`time_account_type`	String
`time_unit`	String
`custom_`

background_compensation

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`comparison_ratio`	Double
`cur_salary`	String
`fin_salary`	String
`job_title`	String
`last_modified_date`	Instant
`lump_sum`	Double
`merit`	String
`options`	String
`pm_rating`	String
`stock`	String
`system_comp_template_name`	String
`system_review_end_date`	Instant
`system_review_start_date`	Instant
`total_comp`	String
`custom_`

candidate_background_certificate

Column	Type	Keys
`background_element_id`	String	PK
`candidate_id`	String	FK
`background_order_position`	String
`description`	String
`end_date`	Instant
`institution`	String
`last_modified_date_time`	Instant
`license_country`	String
`license_name`	String
`license_number`	String
`license_state`	String
`license_type`	String
`name`	String
`start_date`	Instant
`custom_`

background_talent_pool_corp

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`talent_pool_item_corp`	String	FK
`talent_pool_status`	String	FK
`background_order_position`	String
`last_modified_date`	Instant
`start_date`	Instant
`talent_pool_comments`	String
`custom_`

fo_location

Column	Type	Keys
`external_code`	Unknown	PK
`start_date`	Unknown	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`created_date_time`	Unknown
`created_on`	Unknown
`description`	Unknown
`description_de_de`	Unknown
`description_default_value`	Unknown
`description_en_gb`	Unknown
`description_en_us`	Unknown
`description_es_es`	Unknown
`description_fr_fr`	Unknown
`description_ja_jp`	Unknown
`description_ko_kr`	Unknown
`description_localized`	Unknown
`description_nl_nl`	Unknown
`description_pt_br`	Unknown
`description_pt_pt`	Unknown
`description_ru_ru`	Unknown
`description_zh_cn`	Unknown
`description_zh_tw`	Unknown
`end_date`	Unknown
`head_of_unit`	Unknown
`last_modified_date_time`	Unknown
`last_modified_on`	Unknown
`name`	Unknown
`name_de_de`	Unknown
`name_default_value`	Unknown
`name_en_gb`	Unknown
`name_en_us`	Unknown
`name_es_es`	Unknown
`name_fr_fr`	Unknown
`name_ja_jp`	Unknown
`name_ko_kr`	Unknown
`name_localized`	Unknown
`name_nl_nl`	Unknown
`name_pt_br`	Unknown
`name_pt_pt`	Unknown
`name_ru_ru`	Unknown
`name_zh_cn`	Unknown
`name_zh_tw`	Unknown
`status`	Unknown
`custom_`

vendor_info

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`description_default_value`	String
`description_localized`	String
`effective_status`	String
`last_modified_date_time`	Instant
`system_created_by`	String
`system_created_date`	Instant
`system_effective_end_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`vendor_name`	String
`custom_`

fo_pay_grade

Column	Type	Keys
`external_code`	String	PK
`start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`description`	String
`end_date`	Instant
`internal_code`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`name`	String
`object_id`	String
`paygrade_level`	String
`status`	String
`custom_`

form_introduction_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

job_requisition_question

Column	Type	Keys
`id`	String	PK
`question_category`	String
`question_name`	String
`question_source`	String
`question_type`	String

per_global_info_fra

Column	Type	Keys
`country`	String	PK
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`generic_date_1`	Instant
`generic_date_10`	Instant
`generic_date_2`	Instant
`generic_date_3`	Instant
`generic_date_4`	Instant
`generic_date_5`	Instant
`generic_date_6`	Instant
`generic_date_7`	Instant
`generic_number_1`	String
`generic_number_10`	String
`generic_number_11`	String
`generic_number_12`	String
`generic_number_13`	String
`generic_number_14`	String
`generic_number_15`	String
`generic_number_16`	String
`generic_number_2`	String
`generic_number_3`	String
`generic_number_4`	String
`generic_number_5`	String
`generic_number_6`	String
`generic_number_7`	String
`generic_number_8`	String
`generic_number_9`	String
`generic_string_1`	String
`generic_string_10`	String
`generic_string_11`	String
`generic_string_12`	String
`generic_string_13`	String
`generic_string_14`	String
`generic_string_15`	String
`generic_string_16`	String
`generic_string_17`	String
`generic_string_18`	String
`generic_string_19`	String
`generic_string_2`	String
`generic_string_20`	String
`generic_string_21`	String
`generic_string_22`	String
`generic_string_3`	String
`generic_string_4`	String
`generic_string_5`	String
`generic_string_6`	String
`generic_string_7`	String
`generic_string_8`	String
`generic_string_9`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`custom_`

background_courses

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`instruction_type`	String	FK
`background_order_position`	String
`course`	String
`end_date`	Instant
`institution`	String
`last_modified_date`	Instant
`length`	String
`custom_`

per_global_info_gbr

Column	Type	Keys
`country`	String	PK
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`generic_date_1`	Instant
`generic_date_10`	Instant
`generic_date_2`	Instant
`generic_date_3`	Instant
`generic_date_4`	Instant
`generic_date_5`	Instant
`generic_date_6`	Instant
`generic_date_7`	Instant
`generic_number_1`	String
`generic_number_10`	String
`generic_number_11`	String
`generic_number_12`	String
`generic_number_13`	String
`generic_number_14`	String
`generic_number_15`	String
`generic_number_16`	String
`generic_number_2`	String
`generic_number_3`	String
`generic_number_4`	String
`generic_number_5`	String
`generic_number_6`	String
`generic_number_7`	String
`generic_number_8`	String
`generic_number_9`	String
`generic_string_1`	String
`generic_string_10`	String
`generic_string_11`	String
`generic_string_12`	String
`generic_string_13`	String
`generic_string_14`	String
`generic_string_15`	String
`generic_string_16`	String
`generic_string_17`	String
`generic_string_18`	String
`generic_string_19`	String
`generic_string_2`	String
`generic_string_20`	String
`generic_string_21`	String
`generic_string_22`	String
`generic_string_3`	String
`generic_string_4`	String
`generic_string_5`	String
`generic_string_6`	String
`generic_string_7`	String
`generic_string_8`	String
`generic_string_9`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`custom_`

job_requisition_group_operator

Column	Type	Keys
`operator_role`	String	PK
`user_group_id`	String	PK
`job_req_id`	String	PKFK
`admin_selected_group_to_be_removed`	Boolean
`is_admin_selected`	Boolean
`is_disabled`	Boolean
`user_group_name`	String
`custom_`

candidate

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`address`	String
`address_2`	String
`agree_to_privacy_statement`	String
`anonymized`	String
`anonymized_date_time`	Instant
`candidate_locale`	String
`cell_phone`	String
`city`	String
`contact_email`	String
`country`	String
`creation_date_time`	Instant
`current_title`	String
`data_privacy_id`	String
`dateof_availability`	String
`external_candidate`	Boolean
`first_name`	String
`home_phone`	String
`last_login_date_time`	Instant
`last_modified_date_time`	Instant
`last_name`	String
`middle_name`	String
`partner_member_id`	String
`partner_source`	String
`password`	String
`primary_email`	String
`privacy_accept_date_time`	Instant
`public_intranet`	Boolean
`share_profile`	String
`visibility_option`	Boolean
`zip`	String
`custom_`

candidate_profile_extension

Column	Type	Keys
`id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`system_record_status`	String
`custom_`

candidate_background_outside_work_experience

Column	Type	Keys
`background_element_id`	String	PK
`candidate_id`	String	FK
`employer_state`	String	FK
`background_order_position`	String
`business_type`	String
`employer`	String
`employer_address`	String
`employer_city`	String
`employer_contact`	String
`employer_country`	String
`employer_email`	String
`employer_phone`	String
`employer_zip`	String
`end_date`	Instant
`last_modified_date_time`	Instant
`present_employer`	String
`start_date`	Instant
`start_title`	String
`custom_`

external_time_segment

Column	Type	Keys
`id`	String	PK
`external_time_record_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date`	Instant
`created_date_time`	Instant
`hours`	String
`last_modified_date_time`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

per_email

Column	Type	Keys
`email_type`	String	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`email_address`	String
`include_all_records`	Boolean
`is_primary`	Boolean
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`custom_`

background_special_assign

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`background_order_position`	String
`description`	String
`end_date`	Instant
`last_modified_date`	Instant
`project`	String
`start_date`	Instant
`custom_`

job_application_comments

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`associated_comment_id`	String	FK
`last_modified_by`	Unknown	FK
`user_id`	Unknown	FK
`associated_id`	String
`commentator`	String
`content`	String
`has_associated_comment`	String
`migrated_commentator_user_name`	String
`ref_type`	String
`custom_`

job_offer

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`annual_cash_pay`	String
`annual_fb`	String
`annual_gratuity`	String
`annual_pf`	String
`annual_retirals`	String
`annual_sa`	String
`anonymized_date`	Instant
`anonymized_flag`	String
`application_id`	String
`cand_just`	String
`candidate_name`	String
`commission`	String
`created_date`	Instant
`currency`	String
`current_location`	String
`form_data_id`	String
`form_template_id`	String
`initial_comment`	String
`internal_status`	String
`job_rate_of_pay`	String
`last_modified_date`	Instant
`location`	String
`monthly_cash_pay`	String
`monthly_fb`	String
`monthly_gratuity`	String
`monthly_pf`	String
`monthly_retirals`	String
`monthly_sa`	String
`monthly_salary`	String
`redefine_template_approvers`	Boolean
`salary_base`	String
`stock_package`	String
`target_bonus_amount`	Double
`temp_date`	Instant
`template_id`	String
`total_earnings`	String
`total_fixed_pay`	String
`version`	String
`custom_`

form_360_participant_detail

Column	Type	Keys
`column_key`	String	PK
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`participant_id`	String	PKFK
`column_value`	String
`custom_`

holiday_category

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`amount`	String
`created_date`	Instant
`created_date_time`	Instant
`employee_payroll_run_results_external_code`	String
`employee_payroll_run_results_system_effective_start_date`	Instant
`end_date_when_earned`	Instant
`external_name`	String
`grouping_reason`	String
`last_modified_date_time`	Instant
`payroll_provider_grouping_reason`	String
`payroll_provider_grouping_value`	String
`payroll_provider_unit_of_measurement`	String
`payroll_provider_wage_type`	String
`quantity`	String
`start_date_when_earned`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`unit_of_measurement`	String
`wage_type`	String
`custom_`

payment_information_detail

Column	Type	Keys
`effective_start_date`	Instant	PK
`external_code`	String	PK
`worker_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`account_number`	String
`account_owner`	String
`amount`	String
`bank`	String
`bank_country`	String
`business_identifier_code`	String
`created_date`	Instant
`created_date_time`	Instant
`currency`	String
`iban`	String
`last_modified_date`	Instant
`last_modified_date_time`	Instant
`last_modified_date_with_tz`	Instant
`mdf_system_effective_end_date`	Instant
`mdf_system_effective_start_date`	Instant
`mdf_system_entity_id`	String
`mdf_system_object_type`	String
`mdf_system_record_id`	String
`mdf_system_record_status`	String
`mdf_system_status`	String
`mdf_system_transaction_sequence`	String
`mdf_system_version_id`	String
`pay_sequence`	String
`pay_type`	String
`payment_method`	String
`percent`	String
`purpose`	String
`routing_number`	String
`custom_`

fo_cost_center

Column	Type	Keys
`external_code`	Unknown	PK
`start_date`	Unknown	PK
`created_by`	Unknown	FK
`last_modified_by`	Unknown	FK
`cost_center_external_object_id`	Unknown
`cost_center_manager`	Unknown
`created_date_time`	Unknown
`created_on`	Unknown
`cust_legal_entity_prop`	Unknown
`description`	Unknown
`description_de_de`	Unknown
`description_default_value`	Unknown
`description_en_gb`	Unknown
`description_en_us`	Unknown
`description_es_es`	Unknown
`description_fr_fr`	Unknown
`description_ja_jp`	Unknown
`description_ko_kr`	Unknown
`description_localized`	Unknown
`description_nl_nl`	Unknown
`description_pt_br`	Unknown
`description_pt_pt`	Unknown
`description_ru_ru`	Unknown
`description_zh_cn`	Unknown
`description_zh_tw`	Unknown
`end_date`	Unknown
`gl_statement_code`	Unknown
`last_modified_date_time`	Unknown
`last_modified_on`	Unknown
`name`	Unknown
`name_de_de`	Unknown
`name_default_value`	Unknown
`name_en_gb`	Unknown
`name_en_us`	Unknown
`name_es_es`	Unknown
`name_fr_fr`	Unknown
`name_ja_jp`	Unknown
`name_ko_kr`	Unknown
`name_localized`	Unknown
`name_nl_nl`	Unknown
`name_pt_br`	Unknown
`name_pt_pt`	Unknown
`name_ru_ru`	Unknown
`name_zh_cn`	Unknown
`name_zh_tw`	Unknown
`parent`	Unknown
`status`	Unknown
`custom_`

form_perf_pot_summary_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

employee_time_sheet

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`workflow_request_id`	String	FK
`approval_status`	String
`comment`	String
`created_date`	Instant
`created_date_time`	Instant
`editable`	Boolean
`end_date`	Instant
`last_modified_date_time`	Instant
`planned_working_time`	String
`recorded_working_time`	String
`replaced_by`	String
`replaced_by_nav`	String
`replaces`	String
`replaces_nav`	String
`start_date`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`workflow_action`	String
`working_time_account`	String
`custom_`

background_preferred_next_move

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`last_modified_by`	Unknown	FK
`to_currency`	Unknown	FK
`background_order_position`	String
`comments`	String
`function`	String
`last_modified_date`	Instant
`level`	String
`timeframe`	String
`title`	String
`custom_`

interview_overall_assessment

Column	Type	Keys
`id`	String	PK
`interview_ref_id`	String	FK
`average_rating`	Double
`comments`	String
`overall_rating`	String
`type`	String
`custom_`

payroll_run_results_item

Column	Type	Keys
`external_id`	String	PK
`payroll_run_results_system_effective_start_date`	Instant	PK
`payroll_run_results_external_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`amount`	Double
`created_date`	Instant
`created_date_time`	Instant
`end_date_when_earned`	Instant
`external_name`	String
`grouping_reason`	String
`last_modified_date_time`	Instant
`payroll_provider_grouping_reason`	String
`payroll_provider_grouping_value`	String
`payroll_provider_unit_of_measurement`	String
`payroll_provider_wage_type`	String
`quantity`	String
`start_date_when_earned`	Instant
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`unit_of_measurement`	String
`wage_type`	String
`custom_`

candidate_background_language

Column	Type	Keys
`background_element_id`	String	PK
`candidate_id`	String	FK
`background_order_position`	String
`languages`	String
`last_modified_date_time`	Instant
`reading_prof`	String
`speaking_prof`	String
`writing_prof`	String
`custom_`

fo_event_reason

Column	Type	Keys
`external_code`	String	PK
`start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`delete_records_after_termination`	String
`description`	String
`empl_status`	String
`end_date`	Instant
`event`	String
`implicit_position_action`	String
`include_in_work_experience`	String
`internal_code`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`name`	String
`object_id`	String
`payroll_event`	String
`status`	String
`custom_`

per_national_id

Column	Type	Keys
`card_type`	String	PK
`country`	String	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`attachment_id`	String
`created_date_time`	Instant
`created_on`	Instant
`is_primary`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`national_id`	String
`notes`	String
`operation`	String
`custom_`

payroll_run_results

Column	Type	Keys
`id`	String	PK
`system_effective_start_date`	Instant	PK
`created_by`	String	FK
`employment_id`	String	FK
`last_modified_by`	String	FK
`person_id`	String	FK
`user_id`	String	FK
`client_id`	String
`company_id`	String
`created_date`	Instant
`created_date_time`	Instant
`currency`	String
`end_date_when_paid`	Instant
`external_name`	String
`is_void`	Boolean
`last_modified_date_time`	Instant
`pay_date`	Instant
`payroll_id`	String
`payroll_provider_id`	String
`payroll_provider_payroll_run_type`	String
`payroll_run_type`	String
`sequence_number`	String
`start_date_when_paid`	Instant
`system_effective_end_date`	Instant
`system_entity_id`	String
`system_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`custom_`

employment

Column	Type	Keys
`id`	String	PK
`person_id`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`job_number`	String	FK
`last_modified_by`	String	FK
`assignment_class`	String
`benefits_eligibility_start_date`	Instant
`benefits_end_date`	Instant
`bonus_pay_expiration_date`	Instant
`created_date_time`	Instant
`eligible_for_sal_continuation`	Boolean
`eligible_for_stock`	Boolean
`employee_first_employment`	Boolean
`end_date`	Instant
`first_date_worked`	Instant
`include_all_records`	Boolean
`initial_option_grant`	Double
`initial_stock_grant`	Double
`is_contingent_worker`	Boolean
`is_ecrecord`	Boolean
`last_date_worked`	String
`last_modified_date_time`	Instant
`ok_to_rehire`	Boolean
`original_start_date`	Instant
`payroll_end_date`	Instant
`prev_employee_id`	String
`professional_service_date`	Instant
`regret_termination`	Boolean
`salary_end_date`	Instant
`seniority_date`	Instant
`service_date`	Instant
`start_date`	Instant
`stock_end_date`	Instant
`custom_`

background_mobility

Column	Type	Keys
`background_element_id`	String	PK
`user_id`	String	PKFK
`willingness`	String	FK
`background_order_position`	String
`last_modified_date`	Instant
`location`	String
`custom_`

form_objective_details

Column	Type	Keys
`form_data_id`	String	PK
`item_id`	String	PK
`section_index`	Int	PK
`type`	Int	PK
`form_content_id`	String	PKFK
`field_data_type`	String
`field_id`	String
`label`	String
`value`	String
`custom_`

time_zone

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`country`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`comment`	String
`created_date_time`	Instant
`effective_status`	String
`last_modified_date_time`	Instant
`name_default_value`	String
`name_localized`	String
`supported`	Boolean
`system_created_by`	String
`system_created_date`	Instant
`system_effective_end_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`utc_dst_offset`	String
`utc_offset`	String
`custom_`

form_content

Column	Type	Keys
`form_data_id`	String	PK
`id`	String	PK
`form_subject_id`	String
`last_modified_date`	Instant
`status`	String
`custom_`

form_customized_weighted_rating_section

Column	Type	Keys
`form_data_id`	String	PK
`form_content_id`	String	PKFK
`section_description`	String
`section_index`	Int
`section_name`	String
`custom_`

fo_job_code

Column	Type	Keys
`external_code`	String	PK
`start_date`	Instant	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`cust_bonus_plan`	String
`cust_eng_non`	String
`cust_global_jobgrade`	String
`default_employee_class`	String
`default_job_level`	String
`default_supervisor_level`	String
`description`	String
`description_de_de`	String
`description_default_value`	String
`description_en_debug`	String
`description_en_gb`	String
`description_en_us`	String
`description_es_es`	String
`description_fr_fr`	String
`description_ja_jp`	String
`description_ko_kr`	String
`description_localized`	String
`description_nl_nl`	String
`description_pt_br`	String
`description_pt_pt`	String
`description_ru_ru`	String
`description_zh_cn`	String
`description_zh_tw`	String
`employee_class`	String
`end_date`	Instant
`entity_oid`	String
`entity_uuid`	String
`grade`	String
`is_fulltime_employee`	Boolean
`is_regular`	String
`job_function`	String
`job_level`	String
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`mdf_system_record_id`	String
`name`	String
`name_de_de`	String
`name_default_value`	String
`name_en_debug`	String
`name_en_gb`	String
`name_en_us`	String
`name_es_es`	String
`name_fr_fr`	String
`name_ja_jp`	String
`name_ko_kr`	String
`name_localized`	String
`name_nl_nl`	String
`name_pt_br`	String
`name_pt_pt`	String
`name_ru_ru`	String
`name_zh_cn`	String
`name_zh_tw`	String
`parent_job_code`	String
`regular_temporary`	String
`standard_hours`	Double
`status`	String
`supervisor_level`	String
`worker_comp_code`	String
`custom_`

job_application_status_audit_trail

Column	Type	Keys
`rev_number`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`last_modified_proxy_user`	String
`rev_type`	Int
`skipped_status`	String
`status_comment`	String
`custom_`

employee_time_valuation_result

Column	Type	Keys
`id`	String	PK
`employee_time_sheet_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`allowance_type`	String
`approval_status`	String
`booking_date`	Instant
`cost_center`	String
`created_date`	Instant
`created_date_time`	Instant
`hours`	String
`last_modified_date_time`	Instant
`pay_type_external_name`	String
`pay_type_name`	String
`posting_target`	String
`system_effective_end_date`	Instant
`system_effective_start_date`	Instant
`system_entity_id`	String
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_status`	String
`system_transaction_sequence`	String
`system_version_id`	String
`time_type_group`	String
`custom_`

successor

Column	Type	Keys
`id`	String	PK
`created_by`	Unknown	FK
`last_modified_by`	String	FK
`nominee_user_id`	String	FK
`last_modified_date_time`	Instant
`note`	String
`readiness`	Double
`readiness_label`	String
`status`	String
`status_label`	String
`custom_`

talent_pool

Column	Type	Keys
`effective_start_date`	Instant	PK
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`description_default_value`	String
`description_localized`	String
`effective_end_date`	Instant
`effective_status`	String
`enable_readiness`	Boolean
`last_modified_date_time`	Instant
`name_default_value`	String
`name_localized`	String
`owner`	String
`system_created_by`	String
`system_created_date`	Instant
`system_entity_id`	String
`system_last_modified_by`	String
`system_last_modified_date`	Instant
`system_object_type`	String
`system_record_id`	String
`system_record_status`	String
`system_version_id`	String
`transaction_sequence`	String
`type`	String
`custom_`

competency_rating

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`form_content_id`	String
`form_data_id`	String
`guid`	String
`last_modified`	Instant
`last_modified_date_time`	Instant
`module`	Int
`rater`	String
`rater_category`	String
`rating`	Double
`scale_max`	String
`scale_min`	String
`source`	Int
`status`	String
`type`	Int
`valid_from`	Instant
`valid_to`	Instant
`custom_`

pick_list_option

Column	Type	Keys
`id`	String	PK
`parent_picklist_option`	String	FK
`picklist_id`	Unknown	FK
`external_code`	String
`max_value`	Double
`min_value`	Double
`option_value`	Double
`sort_order`	Int
`status`	String
`custom_`

form_rating_scale_value

Column	Type	Keys
`form_data_id`	String	PK
`section_index`	Int	PK
`value`	String	PK
`form_content_id`	String	PKFK
`scale_id`	String	PKFK
`description`	String
`long_description`	String
`custom_`

employee_work_permit

Column	Type	Keys
`document_number`	String	PK
`issue_date`	Instant	PK
`country`	String	PKFK
`document_type`	String	PKFK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`attachment`	String
`attachment_file_name`	String
`attachment_file_size`	String
`attachment_file_type`	String
`attachment_id`	String
`attachment_mime_type`	String
`attachment_status`	String
`created_date_time`	Instant
`document_title`	String
`expiration_date`	Instant
`is_validated`	Boolean
`issue_place`	String
`issuing_authority`	String
`last_modified_date_time`	Instant
`notes`	String
`custom_`

position_requisition_status

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`position_id`	String	FK
`requisition_id`	String	FK
`created_date_time`	Instant
`last_modified_date_time`	Instant
`processing_status`	String
`system_record_status`	String
`custom_`

per_phone

Column	Type	Keys
`phone_type`	String	PK
`id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`area_code`	String
`country_code`	String
`created_date_time`	Instant
`created_on`	Instant
`extension`	String
`include_all_records`	Boolean
`is_primary`	Boolean
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`phone_number`	String
`custom_`

calibration_session

Column	Type	Keys
`session_id`	String	PK
`last_modified_by`	String	FK
`activation_date`	Instant
`last_modified_date_time`	Instant
`session_date`	Instant
`session_location`	String
`session_name`	String
`status`	Int
`custom_`

per_emergency_contact

Column	Type	Keys
`name`	String	PK
`relationship`	String	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`address_1`	String
`address_2`	String
`address_3`	String
`address_city`	String
`address_country`	String
`address_county`	String
`address_province`	String
`address_state`	String
`address_zip_code`	String
`created_date_time`	Instant
`created_on`	Instant
`email`	String
`is_add_same_as_employee`	Boolean
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`phone`	String
`primary_flag`	String
`second_phone`	String
`custom_`

per_person_relationship

Column	Type	Keys
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`related_person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`address_1`	String
`address_2`	String
`address_3`	String
`address_city`	String
`address_country`	String
`address_county`	String
`address_province`	String
`address_state`	String
`address_zip_code`	String
`attachment_id`	String
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`first_name`	String
`is_accompanying_dependent`	Boolean
`is_address_same_as_person`	Boolean
`is_beneficiary`	Boolean
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`last_name`	String
`operation`	String
`relationship_type`	String
`custom_`

form_header

Column	Type	Keys
`form_data_id`	String	PKFK
`creation_date`	Instant
`current_step`	String
`date_assigned`	Instant
`form_data_status`	String
`form_last_modified_date`	Instant
`form_originator`	String
`form_review_due_date`	Instant
`form_review_end_date`	Instant
`form_review_start_date`	Instant
`form_template_id`	String
`form_template_type`	String
`form_title`	String
`is_rated`	Boolean
`rating`	String
`sender`	String
`step_due_date`	Instant
`custom_`

emp_job_relationship

Column	Type	Keys
`relationship_type`	String	PK
`start_date`	Instant	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`rel_user_id`	String	FK
`created_date_time`	Instant
`created_on`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`operation`	String
`custom_`

calibration_template

Column	Type	Keys
`template_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_date_time`	Instant
`end_date`	Instant
`last_modified_date_time`	Instant
`start_date`	Instant
`status`	Int
`template_name`	String
`custom_`

calibration_session_subject

Column	Type	Keys
`session_subject_id`	String	PK
`cal_session_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`authorized_by`	String
`calibrated_flag`	Boolean
`comments`	String
`created_date_time`	Instant
`external_comments`	String
`last_modified_date_time`	Instant
`pm_folder_map_id`	String
`pm_form_data_id`	String
`pm_form_owner_id`	String
`reason`	String
`reason_id`	String
`status`	Int
`user_id`	String
`custom_`

per_address_deflt

Column	Type	Keys
`address_type`	String	PK
`start_date`	Instant	PK
`person_id_external`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`address_1`	String
`address_2`	String
`address_3`	String
`address_4`	String
`address_5`	String
`city`	String
`country`	String
`county`	String
`created_date_time`	Instant
`created_on`	Instant
`emp_users_sys_id`	String
`end_date`	Instant
`include_all_records`	Boolean
`last_modified_date_time`	Instant
`last_modified_on`	Instant
`notes`	String
`operation`	String
`province`	String
`state`	String
`zip_code`	String
`custom_`