# SAP SuccessFactors schema ERD

Table and field reference for the Fivetran SAP SuccessFactors connector.

## 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 | PK, FK |
| section_description | String |  |
| section_index | Int |  |
| section_name | String |  |
| custom_** |  |  |

### background_memberships

| Column | Type | Keys |
| --- | --- | --- |
| background_element_id | String | PK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| offer_detail_id | String | PK, FK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

### 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 | PK, FK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| wotc_forms_url | String |  |
| wotc_id | String |  |
| wotc_screening_url | String |  |
| wotc_status | String |  |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| talent_pool_item_corp | String | FK |
| talent_pool_status | String | FK |
| last_modified_date_time | Instant |  |
| start_date | Instant |  |
| talent_pool_comments | String |  |
| 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 | PK, FK |
| 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_** |  |  |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| last_modified_date_time | Instant |  |
| start_date | Instant |  |
| talent_pool_comments | String |  |
| talent_pool_item | String |  |
| talent_pool_status | String |  |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

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

### 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 | PK, FK |
| 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 | PK, FK |
| scale_id | String | PK, FK |
| description | String |  |
| long_description | String |  |
| custom_** |  |  |

### employee_work_permit

| Column | Type | Keys |
| --- | --- | --- |
| document_number | String | PK |
| issue_date | Instant | PK |
| country | String | PK, FK |
| document_type | String | PK, FK |
| user_id | String | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

### emp_global_assignment

| Column | Type | Keys |
| --- | --- | --- |
| start_date | Instant | PK |
| user_id | String | PK, FK |
| created_by | String | FK |
| last_modified_by | String | FK |
| person_id_external | String | FK |
| assignment_class | String |  |
| assignment_type | String |  |
| created_date_time | Instant |  |
| created_on | Instant |  |
| end_date | Instant |  |
| last_modified_date_time | Instant |  |
| last_modified_on | Instant |  |
| operation | String |  |
| payroll_end_date | Instant |  |
| planned_end_date | Instant |  |
| custom_** |  |  |

### per_emergency_contact

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| relationship | String | PK |
| person_id_external | String | PK, FK |
| 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 | PK, FK |
| related_person_id_external | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- time_collector(user_id) → users(id)
- time_collector(last_modified_by) → users(id)
- time_collector(created_by) → users(id)
- candidate_background_education(candidate_id) → candidate(id)
- form_summary_section(form_content_id) → form_content(id)
- background_memberships(user_id) → users(id)
- background_community(user_id) → users(id)
- employee_compensation(user_id) → users(id)
- employee_compensation(last_modified_by) → users(id)
- employee_compensation(created_by) → users(id)
- admin_reassign_offer_approver(application_id) → job_application(id)
- admin_reassign_offer_approver(user_id) → users(id)
- admin_reassign_offer_approver(job_req_id) → job_requisition(id)
- admin_reassign_offer_approver(offer_detail_id) → job_offer(id)
- admin_reassign_offer_approver(target_user_id) → users(id)
- candidate_tags(candidate_id) → candidate(id)
- form_rating_scale(form_content_id) → form_content(id)
- employee_pay_comp_non_recurring(user_id) → users(id)
- employee_pay_comp_non_recurring(last_modified_by) → users(id)
- employee_pay_comp_non_recurring(created_by) → users(id)
- per_person(user_id) → users(id)
- per_person(last_modified_by) → users(id)
- per_person(created_by) → users(id)
- emp_cost_distribution_item(last_modified_by) → users(id)
- emp_cost_distribution_item(created_by) → users(id)
- emp_cost_distribution_item(emp_cost_distribution_users_sys_id) → users(id)
- job_application_question_response(application_id) → job_application(id)
- fo_job_function(last_modified_by) → users(id)
- fo_job_function(created_by) → users(id)
- form_signature(form_content_id) → form_content(id)
- job_requisition_screening_question(question_id) → job_requisition_question(id)
- job_requisition_screening_question(question_parent_id) → job_requisition_question(id)
- job_requisition_screening_question(job_req_id) → job_requisition(id)
- form_user_rating_comment(user_id) → users(id)
- background_inside_work_experience(user_id) → users(id)
- work_order(vendor) → vendor_info(id)
- work_order(last_modified_by) → users(id)
- work_order(created_by) → users(id)
- background_check_result(background_check_request_request_id) → background_check_request(id)
- form_objective_section(form_content_id) → form_content(id)
- fo_company(last_modified_by) → users(id)
- fo_company(created_by) → users(id)
- background_education(user_id) → users(id)
- background_education(degree) → pick_list_option(id)
- background_education(major) → pick_list_option(id)
- background_education(school_country) → pick_list_option(id)
- background_education(school_state) → pick_list_option(id)
- fo_department(last_modified_by) → users(id)
- fo_department(created_by) → users(id)
- fo_department(cost_center_nav_external_code) → fo_cost_center(external_code)
- candidate_background_inside_work_experience(candidate_id) → candidate(id)
- job_application_onboarding_status(onboarding_id) → job_application_onboarding(id)
- form_behavior_rating_comment(user_id) → users(id)
- form_behavior_rating_comment(form_content_id) → form_content(id)
- employment_termination(user_id) → users(id)
- employment_termination(last_modified_by) → users(id)
- employment_termination(created_by) → users(id)
- employee_workflow_request(wf_request_id) → workflow_request(id)
- job_requisition_posting(last_modified_by) → users(id)
- job_requisition_posting(posted_by) → users(id)
- job_requisition_posting(job_req_id) → job_requisition(id)
- work_schedule(user_id) → users(id)
- work_schedule(last_modified_by) → users(id)
- work_schedule(created_by) → users(id)
- background_award(user_id) → users(id)
- offer_letter(application_id) → job_application(id)
- offer_letter(last_modified_by) → users(id)
- offer_letter(created_by) → users(id)
- onboarding_process(last_modified_by) → users(id)
- onboarding_process(created_by) → users(id)
- workflow_request(last_modified_by) → users(id)
- workflow_request(created_by) → users(id)
- workflow_request(parent_id) → workflow_request(id)
- holiday(country) → country(id)
- holiday(last_modified_by) → users(id)
- holiday(created_by) → users(id)
- external_time_record(user_id) → users(id)
- external_time_record(last_modified_by) → users(id)
- external_time_record(created_by) → users(id)
- background_talent_pool(user_id) → users(id)
- background_talent_pool(talent_poolitem) → pick_list_option(id)
- work_opportunity_tax_credit(id) → job_application(id)
- per_personal(last_modified_by) → users(id)
- per_personal(created_by) → users(id)
- currency_conversion(last_modified_by) → users(id)
- currency_conversion(created_by) → users(id)
- currency_conversion(to_currency) → currency(code)
- employee_pay_comp_recurring(user_id) → users(id)
- employee_pay_comp_recurring(last_modified_by) → users(id)
- employee_pay_comp_recurring(created_by) → users(id)
- time_account_type(country) → country(id)
- time_account_type(last_modified_by) → users(id)
- time_account_type(created_by) → users(id)
- currency(last_modified_by) → users(id)
- currency(created_by) → users(id)
- job_application_status_label(id) → job_application_status(id)
- per_global_info_usa(last_modified_by) → users(id)
- per_global_info_usa(person_id_external) → per_person(person_id_external)
- per_global_info_usa(created_by) → users(id)
- candidate_background_talent_pool_corp(candidate_id) → candidate(id)
- candidate_background_talent_pool_corp(talent_pool_status) → pick_list_option(id)
- candidate_background_talent_pool_corp(talent_pool_item_corp) → pick_list_option(id)
- fo_translation(last_modified_by) → users(id)
- fo_translation(created_by) → users(id)
- form_objective(form_content_id) → form_content(id)
- job_requisition_operator(user_id) → pick_list_option(id)
- job_requisition_operator(job_req_id) → job_requisition(id)
- background_promotability(user_id) → users(id)
- job_application_audit(job_posting_id) → job_requisition_posting(job_posting_id)
- job_application_audit(last_modified_by) → users(id)
- job_application_audit(changed_by) → users(id)
- job_application_interview(application_id) → job_application(id)
- background_certificates(user_id) → users(id)
- background_certificates(license_state) → pick_list_option(id)
- background_certificates(license_country) → pick_list_option(id)
- position_matrix_relationship(position_id) → position(id)
- position_matrix_relationship(last_modified_by) → users(id)
- position_matrix_relationship(created_by) → users(id)
- position_matrix_relationship(user_id) → users(id)
- job_application(last_modified_by) → users(id)
- job_application(job_code) → employee_job(job_code)
- job_application(country_code) → country(id)
- job_application(candidate_id) → candidate(id)
- job_application(referred_by) → users(id)
- job_application(job_req_id) → job_requisition(id)
- job_application(app_status_set_id) → job_application_status(id)
- job_application(user_id) → users(id)
- external_time_data(user_id) → users(id)
- external_time_data(last_modified_by) → users(id)
- external_time_data(created_by) → users(id)
- job_requisition_locale(job_req_id) → job_requisition(id)
- form_objective_other_details_item(form_content_id) → form_content(id)
- job_offer_approver(offer_approval_id) → job_offer(id)
- job_offer_approver(last_modified_by) → users(id)
- job_offer_approver(created_by) → users(id)
- job_offer_approver(offer_approver_id) → users(id)
- fo_division(last_modified_by) → users(id)
- fo_division(created_by) → users(id)
- employee_time_calendar(last_modified_by) → users(id)
- employee_time_calendar(created_by) → users(id)
- employee_time_calendar(work_schedule_internal_id) → work_schedule(id)
- per_global_info_irl(last_modified_by) → users(id)
- per_global_info_irl(person_id_external) → per_person(person_id_external)
- per_global_info_irl(created_by) → users(id)
- pick_list_value(last_modified_by) → job_application(id)
- pick_list_value(created_by) → job_application(id)
- pick_list_value(parent_pick_list_value) → pick_list_value(id)
- holiday_calendar(last_modified_by) → users(id)
- holiday_calendar(created_by) → users(id)
- holiday_calendar(nominee_user_id) → users(id)
- country(last_modified_by) → users(id)
- country(currency) → currency(code)
- country(created_by) → users(id)
- background_languages(user_id) → users(id)
- job_application_onboarding(application_id) → job_application(id)
- job_application_onboarding(submitted_by) → users(id)
- team_goal_owner(user_id) → users(id)
- team_goal_owner(last_modified_by) → users(id)
- team_goal_owner(created_by) → users(id)
- candidate_comments(candidate_id) → candidate(id)
- background_check_request(application_id) → job_application(id)
- background_check_request(created_by) → users(id)
- position_right_to_return(user_id) → users(id)
- position_right_to_return(created_by) → users(id)
- position_right_to_return(position) → position(id)
- employee_beneficiary(user_id) → users(id)
- employee_beneficiary(last_modified_by) → users(id)
- employee_beneficiary(created_by) → users(id)
- employee_pension_payout(user_id) → users(id)
- employee_pension_payout(last_modified_by) → users(id)
- employee_pension_payout(person_id_external) → external_personal_info(id)
- employee_pension_payout(created_by) → users(id)
- form_objective_other_details_item_value_cell(form_content_id) → form_content(id)
- form_obj_comp_summary_section(form_content_id) → form_content(id)
- onboarding_process_task(process_id) → onboarding_process(process_id)
- onboarding_process_task(last_modified_by) → users(id)
- onboarding_process_task(created_by) → users(id)
- form_competency_behavior(form_content_id) → form_content(id)
- employee_time_sheet_entry(last_modified_by) → users(id)
- employee_time_sheet_entry(employee_time_sheet_id) → employee_time_sheet(id)
- employee_time_sheet_entry(created_by) → users(id)
- pick_list(last_modified_by) → users(id)
- pick_list(created_by) → users(id)
- pick_list(parent_pick_list_nav) → pick_list(id)
- form_objective_comment(user_id) → users(id)
- form_objective_comment(form_content_id) → form_content(id)
- candidate_background_talent_pool(candidate_id) → candidate(id)
- employee_time(user_id) → users(id)
- employee_time(last_modified_by) → users(id)
- employee_time(workflow_request_id) → workflow_request(id)
- employee_time(created_by) → users(id)
- job_requisition(status_set_id) → job_application_status(id)
- job_requisition(last_modified_by) → candidate(id)
- job_requisition(job_code) → employee_job(job_code)
- employee_job(user_id) → users(id)
- employee_job(last_modified_by) → users(id)
- employee_job(created_by) → users(id)
- employee_job(manager_id) → users(id)
- form_objective_other_details_item_col(form_content_id) → form_content(id)
- users(country) → country(id)
- users(onboarding_id) → job_application_onboarding(id)
- users(job_code) → employee_job(job_code)
- users(competency) → competency_rating(id)
- users(emp_id) → employment(id)
- users(hr_id) → users(id)
- users(manager_id) → users(id)
- fo_business_unit(last_modified_by) → users(id)
- fo_business_unit(created_by) → users(id)
- interview_individual_assessment(interview_overall_assessment_id) → interview_overall_assessment(id)
- form_audit_trail(form_content_id) → form_content(id)
- job_application_status(app_status_id) → job_application_status_label(id)
- position(last_modified_by) → users(id)
- position(job_code) → employee_job(job_code)
- position(created_by) → users(id)
- position(legacy_position_id) → position(id)
- form_user_information_section(form_content_id) → form_content(id)
- employee_time_account_balance(user_id) → users(id)
- employee_time_account_balance(time_account_type_id) → time_account_type(id)
- background_compensation(user_id) → users(id)
- candidate_background_certificate(candidate_id) → candidate(id)
- background_talent_pool_corp(talent_pool_status) → pick_list_option(id)
- background_talent_pool_corp(talent_pool_item_corp) → pick_list_option(id)
- background_talent_pool_corp(user_id) → users(id)
- fo_location(last_modified_by) → users(id)
- fo_location(created_by) → users(id)
- vendor_info(last_modified_by) → users(id)
- vendor_info(created_by) → users(id)
- fo_pay_grade(last_modified_by) → users(id)
- fo_pay_grade(created_by) → users(id)
- form_introduction_section(form_content_id) → form_content(id)
- per_global_info_fra(last_modified_by) → users(id)
- per_global_info_fra(person_id_external) → per_person(person_id_external)
- per_global_info_fra(created_by) → users(id)
- background_courses(user_id) → users(id)
- background_courses(instruction_type) → pick_list_option(id)
- per_global_info_gbr(last_modified_by) → users(id)
- per_global_info_gbr(person_id_external) → per_person(person_id_external)
- per_global_info_gbr(created_by) → users(id)
- job_requisition_group_operator(job_req_id) → job_requisition(id)
- candidate(user_id) → users(id)
- candidate_profile_extension(id) → candidate(id)
- candidate_profile_extension(created_by) → users(id)
- candidate_profile_extension(last_modified_by) → users(id)
- candidate_background_outside_work_experience(candidate_id) → candidate(id)
- candidate_background_outside_work_experience(employer_state) → pick_list_option(id)
- external_time_segment(last_modified_by) → users(id)
- external_time_segment(created_by) → users(id)
- external_time_segment(external_time_record_id) → external_time_record(id)
- per_email(last_modified_by) → users(id)
- per_email(person_id_external) → per_person(person_id_external)
- per_email(created_by) → users(id)
- background_special_assign(user_id) → pick_list_option(id)
- job_application_comments(application_id) → job_application(id)
- job_application_comments(associated_comment_id) → job_application_comments(id)
- job_application_comments(last_modified_by) → users(id)
- job_application_comments(user_id) → users(id)
- job_offer(last_modified_by) → users(id)
- job_offer(created_by) → users(id)
- holiday_category(last_modified_by) → users(id)
- holiday_category(created_by) → users(id)
- payment_information_detail(last_modified_by) → users(id)
- payment_information_detail(created_by) → users(id)
- payment_information_detail(worker_id) → employment(id)
- fo_cost_center(last_modified_by) → users(id)
- fo_cost_center(created_by) → users(id)
- form_perf_pot_summary_section(form_content_id) → form_content(id)
- employee_time_sheet(user_id) → users(id)
- employee_time_sheet(last_modified_by) → users(id)
- employee_time_sheet(workflow_request_id) → workflow_request(id)
- employee_time_sheet(created_by) → users(id)
- background_preferred_next_move(user_id) → users(id)
- background_preferred_next_move(last_modified_by) → users(id)
- background_preferred_next_move(to_currency) → currency(code)
- interview_overall_assessment(interview_ref_id) → job_application_interview(id)
- payroll_run_results_item(last_modified_by) → users(id)
- payroll_run_results_item(created_by) → users(id)
- payroll_run_results_item(payroll_run_results_external_id) → payroll_run_results(id)
- candidate_background_language(candidate_id) → candidate(id)
- fo_event_reason(last_modified_by) → users(id)
- fo_event_reason(created_by) → users(id)
- per_national_id(last_modified_by) → users(id)
- per_national_id(person_id_external) → per_person(person_id_external)
- per_national_id(created_by) → users(id)
- payroll_run_results(user_id) → users(id)
- payroll_run_results(last_modified_by) → users(id)
- payroll_run_results(created_by) → users(id)
- payroll_run_results(person_id) → external_personal_info(id)
- payroll_run_results(employment_id) → employment(id)
- employment(user_id) → users(id)
- employment(job_number) → employee_job(seq_number)
- employment(last_modified_by) → users(id)
- employment(created_by) → users(id)
- background_mobility(user_id) → users(id)
- background_mobility(willingness) → pick_list_option(id)
- form_objective_details(form_content_id) → form_content(id)
- time_zone(country) → country(id)
- time_zone(last_modified_by) → users(id)
- time_zone(created_by) → users(id)
- fo_job_code(last_modified_by) → users(id)
- fo_job_code(created_by) → users(id)
- job_application_status_audit_trail(last_modified_by) → users(id)
- job_application_status_audit_trail(created_by) → users(id)
- employee_time_valuation_result(last_modified_by) → users(id)
- employee_time_valuation_result(employee_time_sheet_id) → employee_time_sheet(id)
- employee_time_valuation_result(created_by) → users(id)
- successor(last_modified_by) → users(id)
- successor(nominee_user_id) → users(id)
- successor(created_by) → users(id)
- talent_pool(last_modified_by) → users(id)
- talent_pool(created_by) → users(id)
- competency_rating(user_id) → users(id)
- pick_list_option(parent_picklist_option) → pick_list_option(id)
- pick_list_option(picklist_id) → pick_list(legacy_pick_list_id)
- form_rating_scale_value(form_content_id) → form_content(id)
- form_rating_scale_value(scale_id) → form_rating_scale(scale_id)
- employee_work_permit(user_id) → users(id)
- employee_work_permit(country) → country(id)
- employee_work_permit(document_type) → pick_list_option(id)
- employee_work_permit(last_modified_by) → users(id)
- employee_work_permit(created_by) → users(id)
- position_requisition_status(position_id) → position(id)
- position_requisition_status(last_modified_by) → users(id)
- position_requisition_status(created_by) → users(id)
- position_requisition_status(requisition_id) → job_requisition(id)
- per_phone(last_modified_by) → users(id)
- per_phone(id) → per_person(person_id_external)
- per_phone(created_by) → users(id)
- calibration_session(last_modified_by) → users(id)
- emp_global_assignment(user_id) → users(id)
- emp_global_assignment(last_modified_by) → users(id)
- emp_global_assignment(person_id_external) → per_person(person_id_external)
- emp_global_assignment(created_by) → users(id)
- per_emergency_contact(last_modified_by) → users(id)
- per_emergency_contact(person_id_external) → per_person(person_id_external)
- per_emergency_contact(created_by) → users(id)
- per_person_relationship(last_modified_by) → users(id)
- per_person_relationship(person_id_external) → per_person(person_id_external)
- per_person_relationship(created_by) → users(id)
- per_person_relationship(related_person_id_external) → per_person(person_id_external)
- form_header(form_data_id) → form_content(form_data_id)
- emp_job_relationship(user_id) → users(id)
- emp_job_relationship(last_modified_by) → users(id)
- emp_job_relationship(created_by) → users(id)
- emp_job_relationship(rel_user_id) → users(id)
- calibration_template(last_modified_by) → users(id)
- calibration_template(created_by) → users(id)
- calibration_session_subject(last_modified_by) → users(id)
- calibration_session_subject(cal_session_id) → calibration_session(session_id)
- calibration_session_subject(created_by) → users(id)
- per_address_deflt(last_modified_by) → users(id)
- per_address_deflt(person_id_external) → per_person(person_id_external)
- per_address_deflt(created_by) → users(id)