Workday HCM コネクタ リファレンス

備考

ベータ版

この機能はベータ版です。ワークスペース管理者は、 プレビュー ページからこの機能へのアクセスを制御できます。「Databricks プレビューの管理」を参照してください。

このページには、Lakeflow ConnectのマネージドWorkday HCMコネクタのリファレンスドキュメントが含まれています。

サポートされているデータ

このコネクタは、20個の Workday オブジェクトから選択可能な137個の宛先テーブルをサポートしています。次の表では、ソース API ごとに宛先テーブルをグループ化し、それぞれの取り込みモードを示しています。同じ API から生成されたすべての宛先テーブルは、その API に示されている取り込みモードを共有します。

Workday オブジェクト	取り込みモード	宛先テーブル
ワーカー	インクリメンタル	worker_collective_agreement、worker_leave_status、worker_position_compensation、worker_position_end_employment_reason、worker_position_job_classification、worker_position_manager、worker_position_organization、worker_position_payroll_reporting_code、worker_positions、worker_probation_period、worker_secondary_termination_reason、 workers
民族	フルリフレッシュ	ethnicity
性自認	フルリフレッシュ	gender_identity
LGBTの識別	フルリフレッシュ	lgbt_identification
代名詞	フルリフレッシュ	pronoun
性的指向	フルリフレッシュ	sexual_orientation
組織	フルリフレッシュ	organization、organization_assignment、organization_leader、organization_role、 organization_role_worker
ジョブプロファイル	インクリメンタル	job_family_job_profile、job_profile、job_profile_certification、job_profile_classification、job_profile_company_insider、job_profile_competency、job_profile_education、job_profile_exempt、job_profile_language、job_profile_language_ability、job_profile_pay_rate、job_profile_responsibility、job_profile_restrict_to_country、job_profile_skill、job_profile_training、job_profile_work_experience、 job_profile_worker_compensation
位置	インクリメンタル	position、position_bonus_plan、position_certification、position_competency、position_education、position_job_family、position_job_profile、position_language、position_location、position_merit_plan、position_organization、position_pay_plan、position_responsibility、position_skill、position_stock_plan、position_training、position_work_experience、 position_worker_type_restriction
候補	フルリフレッシュ	candidate、candidate_certification、candidate_education、candidate_experience、candidate_language、candidate_name、candidate_pool_membership、candidate_skill、candidate_tag、 candidate_website
質問票	フルリフレッシュ	questionnaire, questionnaire_setup
インタビュー	フルリフレッシュ	interview、interview_competency、interview_questionnaire、interview_session、interview_session_detail、 interviewer
外部参照	フルリフレッシュ	external_reference_line、external_reference_participant、 questionnaire_answer
ジョブの求人	インクリメンタル	job_requisition、job_requisition_additional_job_posting_location、job_requisition_additional_job_profile、job_requisition_additional_location、job_requisition_allowance_plan、job_requisition_bonus_plan、job_requisition_calculated_plan、job_requisition_certification、job_requisition_commission_plan、job_requisition_compensation、job_requisition_competency、job_requisition_custom_organization、job_requisition_default_assessment_test、job_requisition_education、job_requisition_language、job_requisition_language_ability、job_requisition_merit_plan、job_requisition_organization、job_requisition_pay_plan、job_requisition_period_salary_plan、job_requisition_position、job_requisition_responsibility、job_requisition_skill、job_requisition_stock_plan、job_requisition_training、job_requisition_unit_allowance_plan、job_requisition_unit_salary_plan、 job_requisition_work_experience
給与計算結果	インクリメンタル	payroll_line、payroll_line_pay_component、payroll_line_related_calculation、payroll_line_withholding、payroll_local_city_authority_tax_worktag、payroll_local_county_authority_tax_worktag、payroll_national_id、payroll_result、 payroll_state_authority_tax_worktag
報酬プラン	フルリフレッシュ	compensation_allowance_plan_amount_profile、compensation_allowance_plan_percent_profile、compensation_bonus_plan_coverage_date_eligibility_rule、compensation_bonus_plan_performance_factor_scorecard、compensation_bonus_plan_replacement_percent、compensation_bonus_tranche、compensation_commission_plan_profile、compensation_future_payment_bonus_plan、compensation_merit_plan_replacement_percent、compensation_plan、compensation_stock_plan_amount_profile、compensation_stock_plan_grant、compensation_stock_plan_unit_profile、compensation_stock_profile_grant_split、 deferred_compensation_eligibility_rule
報酬グレード	フルリフレッシュ	compensation_grade、compensation_grade_profile、 compensation_step
欠損入力	フルリフレッシュ	absence_input
残高のオーバーライド	フルリフレッシュ	override_balance
休暇プランの残高	フルリフレッシュ	time_off_plan_balance, time_off_plan_balance_position

Workday オブジェクト	取り込みモード	宛先テーブル
ワーカー	インクリメンタル	worker_collective_agreement、worker_leave_status、worker_position_compensation、worker_position_end_employment_reason、worker_position_job_classification、worker_position_manager、worker_position_organization、worker_position_payroll_reporting_code、worker_positions、worker_probation_period、worker_secondary_termination_reason、 workers
民族	フルリフレッシュ	ethnicity
性自認	フルリフレッシュ	gender_identity
LGBTの識別	フルリフレッシュ	lgbt_identification
代名詞	フルリフレッシュ	pronoun
性的指向	フルリフレッシュ	sexual_orientation
組織	フルリフレッシュ	organization、organization_assignment、organization_leader、organization_role、 organization_role_worker
ジョブプロファイル	インクリメンタル	job_family_job_profile、job_profile、job_profile_certification、job_profile_classification、job_profile_company_insider、job_profile_competency、job_profile_education、job_profile_exempt、job_profile_language、job_profile_language_ability、job_profile_pay_rate、job_profile_responsibility、job_profile_restrict_to_country、job_profile_skill、job_profile_training、job_profile_work_experience、 job_profile_worker_compensation
位置	インクリメンタル	position、position_bonus_plan、position_certification、position_competency、position_education、position_job_family、position_job_profile、position_language、position_location、position_merit_plan、position_organization、position_pay_plan、position_responsibility、position_skill、position_stock_plan、position_training、position_work_experience、 position_worker_type_restriction
候補	フルリフレッシュ	candidate、candidate_certification、candidate_education、candidate_experience、candidate_language、candidate_name、candidate_pool_membership、candidate_skill、candidate_tag、 candidate_website
質問票	フルリフレッシュ	questionnaire, questionnaire_setup
インタビュー	フルリフレッシュ	interview、interview_competency、interview_questionnaire、interview_session、interview_session_detail、 interviewer
外部参照	フルリフレッシュ	external_reference_line、external_reference_participant、 questionnaire_answer
ジョブの求人	インクリメンタル	job_requisition、job_requisition_additional_job_posting_location、job_requisition_additional_job_profile、job_requisition_additional_location、job_requisition_allowance_plan、job_requisition_bonus_plan、job_requisition_calculated_plan、job_requisition_certification、job_requisition_commission_plan、job_requisition_compensation、job_requisition_competency、job_requisition_custom_organization、job_requisition_default_assessment_test、job_requisition_education、job_requisition_language、job_requisition_language_ability、job_requisition_merit_plan、job_requisition_organization、job_requisition_pay_plan、job_requisition_period_salary_plan、job_requisition_position、job_requisition_responsibility、job_requisition_skill、job_requisition_stock_plan、job_requisition_training、job_requisition_unit_allowance_plan、job_requisition_unit_salary_plan、 job_requisition_work_experience
給与計算結果	インクリメンタル	payroll_line、payroll_line_pay_component、payroll_line_related_calculation、payroll_line_withholding、payroll_local_city_authority_tax_worktag、payroll_local_county_authority_tax_worktag、payroll_national_id、payroll_result、 payroll_state_authority_tax_worktag
報酬プラン	フルリフレッシュ	compensation_allowance_plan_amount_profile、compensation_allowance_plan_percent_profile、compensation_bonus_plan_coverage_date_eligibility_rule、compensation_bonus_plan_performance_factor_scorecard、compensation_bonus_plan_replacement_percent、compensation_bonus_tranche、compensation_commission_plan_profile、compensation_future_payment_bonus_plan、compensation_merit_plan_replacement_percent、compensation_plan、compensation_stock_plan_amount_profile、compensation_stock_plan_grant、compensation_stock_plan_unit_profile、compensation_stock_profile_grant_split、 deferred_compensation_eligibility_rule
報酬グレード	フルリフレッシュ	compensation_grade、compensation_grade_profile、 compensation_step
欠損入力	フルリフレッシュ	absence_input
残高のオーバーライド	フルリフレッシュ	override_balance
休暇プランの残高	フルリフレッシュ	time_off_plan_balance, time_off_plan_balance_position

自動変換

Workday オブジェクト APIs は、深くネストされたレスポンスを返します。Databricks は各レスポンスを内部の未加工ステージング テーブルに取り込み、1 つ以上のフラット化された宛先テーブルに自動的に変換します。このページにリストされているフラット化された宛先テーブルを選択します。このコネクタでは、内部の未加工ステージング テーブルを選択可能なソース テーブルとして公開しません。

宛先テーブルのスキーマ

次のセクションでは、選択可能な各宛先テーブルの列を示します。データ型では Databricks SQL 表記を使用します。複合型には array<string> や struct<field: string> などの形式を使用します。

ワーカー

取り込みモード: インクリメンタル

宛先テーブル: 12

worker_collective_agreement

列	データ型
worker_id	string
position_id	string
collective_agreement_id	string
employee_collective_agreement_event_code	string
employee_collective_agreement_event_id	string
effective_date	date
end_assignment_date	date

列	データ型
worker_id	string
position_id	string
collective_agreement_id	string
employee_collective_agreement_event_code	string
employee_collective_agreement_event_id	string
effective_date	date
end_assignment_date	date

worker_leave_status

列	データ型
worker_id	string
leave_request_event_id	string
leave_status_code	string
description	string
leave_return_event	string
on_leave	boolean
leave_start_date	date
estimated_leave_end_date	date
leave_end_date	date
first_day_of_work	date
leave_last_day_of_work	date
leave_of_absence_type	string
leave_type_reason	string
benefits_effect	boolean
payroll_effect	boolean
paid_time_off_accrual_effect	boolean
continuous_service_accrual_effect	boolean
stock_vesting_effect	boolean
leave_request_additional_last_date_for_which_paid	date
leave_request_additional_expected_due_date	date
leave_request_additional_child_birth_date	date
leave_request_additional_stillbirth_baby_deceased	boolean
leave_request_additional_date_baby_arrived_home	date
leave_request_additional_adoption_placement_date	date
leave_request_additional_adoption_notification_date	date
leave_request_additional_date_child_entered_country	date
leave_request_additional_multiple_child_indicator	boolean
leave_request_additional_number_of_babies_adopted_children	decimal(2,0)
leave_request_additional_number_of_previous_births	decimal(2,0)
leave_request_additional_number_of_previous_maternity_leaves	decimal(2,0)
leave_request_additional_number_of_child_dependents	decimal(2,0)
leave_request_additional_single_parent_indicator	boolean
leave_request_additional_age_of_dependent	decimal(3,0)
leave_request_additional_child_disability_indicator	boolean
leave_request_additional_child_date_of_death	date
leave_request_additional_work_related	boolean
leave_request_additional_social_security_disability_code	string
leave_request_additional_caesarean_section_birth	boolean
leave_request_additional_week_of_confinement	date
leave_request_additional_neonatal_care_start_date	date
leave_request_additional_neonatal_care_discharge_date	date
leave_request_additional_location_during_leave	string
leave_request_additional_leave_percentage	decimal(5,2)
leave_request_additional_leave_entitlement_override	decimal(5,0)
leave_request_additional_stop_payment_date	date
leave_request_additional_date_of_recall	date

列	データ型
worker_id	string
leave_request_event_id	string
leave_status_code	string
description	string
leave_return_event	string
on_leave	boolean
leave_start_date	date
estimated_leave_end_date	date
leave_end_date	date
first_day_of_work	date
leave_last_day_of_work	date
leave_of_absence_type	string
leave_type_reason	string
benefits_effect	boolean
payroll_effect	boolean
paid_time_off_accrual_effect	boolean
continuous_service_accrual_effect	boolean
stock_vesting_effect	boolean
leave_request_additional_last_date_for_which_paid	date
leave_request_additional_expected_due_date	date
leave_request_additional_child_birth_date	date
leave_request_additional_stillbirth_baby_deceased	boolean
leave_request_additional_date_baby_arrived_home	date
leave_request_additional_adoption_placement_date	date
leave_request_additional_adoption_notification_date	date
leave_request_additional_date_child_entered_country	date
leave_request_additional_multiple_child_indicator	boolean
leave_request_additional_number_of_babies_adopted_children	decimal(2,0)
leave_request_additional_number_of_previous_births	decimal(2,0)
leave_request_additional_number_of_previous_maternity_leaves	decimal(2,0)
leave_request_additional_number_of_child_dependents	decimal(2,0)
leave_request_additional_single_parent_indicator	boolean
leave_request_additional_age_of_dependent	decimal(3,0)
leave_request_additional_child_disability_indicator	boolean
leave_request_additional_child_date_of_death	date
leave_request_additional_work_related	boolean
leave_request_additional_social_security_disability_code	string
leave_request_additional_caesarean_section_birth	boolean
leave_request_additional_week_of_confinement	date
leave_request_additional_neonatal_care_start_date	date
leave_request_additional_neonatal_care_discharge_date	date
leave_request_additional_location_during_leave	string
leave_request_additional_leave_percentage	decimal(5,2)
leave_request_additional_leave_entitlement_override	decimal(5,0)
leave_request_additional_stop_payment_date	date
leave_request_additional_date_of_recall	date

worker_position_compensation

列	データ型
worker_id	string
position_id	string
workers_compensation_code	string

列	データ型
worker_id	string
position_id	string
workers_compensation_code	string

worker_position_end_employment_reason

列	データ型
worker_id	string
position_id	string
end_employment_reason	string
end_employment_date	date

列	データ型
worker_id	string
position_id	string
end_employment_reason	string
end_employment_date	date

worker_position_job_classification

列	データ型
worker_id	string
position_id	string
job_classification_id	string
job_group_code	string

列	データ型
worker_id	string
position_id	string
job_classification_id	string
job_group_code	string

worker_position_manager

列	データ型
worker_id	string
position_id	string
manager_id	array<string>

列	データ型
worker_id	string
position_id	string
manager_id	array<string>

worker_position_organization

列	データ型
worker_id	string
position_id	string
organization_id	string
organization_type_id	string
organization_type_code	string
organization_name	string
date_of_pay_group_assignment	date
primary_business_site	string
used_in_change_organization_assignments	boolean
index	int

列	データ型
worker_id	string
position_id	string
organization_id	string
organization_type_id	string
organization_type_code	string
organization_name	string
date_of_pay_group_assignment	date
primary_business_site	string
used_in_change_organization_assignments	boolean
index	int

worker_position_payroll_reporting_code

列	データ型
worker_id	string
position_id	string
payroll_reporting_id	string
payroll_reporting_code	string
formatted_code	string
payroll_reporting_type	string

列	データ型
worker_id	string
position_id	string
payroll_reporting_id	string
payroll_reporting_code	string
formatted_code	string
payroll_reporting_type	string

worker_positions

列	データ型
worker_id	string
position_id	string
position_title	string
business_title	string
start_date	date
end_date	date
end_employment_date	date
pay_through_date	date
position_effective_date	date
is_primary_job	boolean
worker_type	string
worker_type_descriptor	string
position_time_type	string
job_exempt	boolean
exclude_from_headcount	boolean
headcount_id	string
job_profile_id	string
job_profile_name	string
job_family_id	array<string>
management_level_id	string
management_level_descriptor	string
job_category_id	string
work_shift_required	boolean
critical_job	boolean
difficulty_to_fill	string
scheduled_weekly_hours	decimal(5,2)
default_weekly_hours	decimal(5,2)
full_time_equivalent_percentage	decimal(12,2)
paid_fte	decimal(22,12)
working_fte	decimal(22,12)
specify_paid_fte	boolean
specify_working_fte	boolean
working_time_value	decimal(6,2)
working_time_frequency	string
working_time_unit	string
work_shift	string
work_hours_profile	string
worker_hours_profile_classification	string
regular_paid_equivalent_hours	decimal(5,2)
work_space	string
payroll_effective_date	date
pay_rate_type	string
pay_group	string
payroll_entity	string
employee_type	string
payroll_file_number	string
pay_frequency	string
federal_withholding_fein	string
business_site_name	string
location_id	string
time_profile	string
international_assignment_type	string
position_home_country	string
host_country	string
expected_assignment_end_date	date
start_international_assignment_reason	string

列	データ型
worker_id	string
position_id	string
position_title	string
business_title	string
start_date	date
end_date	date
end_employment_date	date
pay_through_date	date
position_effective_date	date
is_primary_job	boolean
worker_type	string
worker_type_descriptor	string
position_time_type	string
job_exempt	boolean
exclude_from_headcount	boolean
headcount_id	string
job_profile_id	string
job_profile_name	string
job_family_id	array<string>
management_level_id	string
management_level_descriptor	string
job_category_id	string
work_shift_required	boolean
critical_job	boolean
difficulty_to_fill	string
scheduled_weekly_hours	decimal(5,2)
default_weekly_hours	decimal(5,2)
full_time_equivalent_percentage	decimal(12,2)
paid_fte	decimal(22,12)
working_fte	decimal(22,12)
specify_paid_fte	boolean
specify_working_fte	boolean
working_time_value	decimal(6,2)
working_time_frequency	string
working_time_unit	string
work_shift	string
work_hours_profile	string
worker_hours_profile_classification	string
regular_paid_equivalent_hours	decimal(5,2)
work_space	string
payroll_effective_date	date
pay_rate_type	string
pay_group	string
payroll_entity	string
employee_type	string
payroll_file_number	string
pay_frequency	string
federal_withholding_fein	string
business_site_name	string
location_id	string
time_profile	string
international_assignment_type	string
position_home_country	string
host_country	string
expected_assignment_end_date	date
start_international_assignment_reason	string

worker_probation_period

列	データ型
worker_id	string
position_id	string
probation_period_id	string
employee_probation_period_code	string
effective_date	date
start_date	date
end_date	date
extended_end_date	date
probation_reason	string
probation_type	string
note	string

列	データ型
worker_id	string
position_id	string
probation_period_id	string
employee_probation_period_code	string
effective_date	date
start_date	date
end_date	date
extended_end_date	date
probation_reason	string
probation_type	string
note	string

worker_secondary_termination_reason

列	データ型
worker_id	string
secondary_reason	string
reason_category	string
index	int

列	データ型
worker_id	string
secondary_reason	string
reason_category	string
index	int

workers

列	データ型
academic_tenure_date	date
active	boolean
active_status_date	date
benefits_service_date	date
company_service_date	date
continuous_service_date	date
date_entered_workforce	date
days_unemployed	decimal(12,0)
eligible_for_hire	string
eligible_for_rehire_on_latest_termination	string
expected_date_of_return	date
expected_retirement_date	date
first_day_of_work	date
has_international_assignment	boolean
hire_date	date
hire_reason	string
hire_rescinded	boolean
home_country	string
months_continuous_prior_employment	decimal(14,2)
not_returning	boolean
original_hire_date	date
pay_through_date	date
probation_end_date	date
probation_start_date	date
rehire	boolean
resignation_date	date
retired	boolean
retirement_date	date
return_unknown	boolean
seniority_date	date
severance_date	date
time_off_service_date	date
vesting_date	date
compensation_grade_ids	array<string>
compensation_grade_profile_ids	array<string>
display_language_code	string
hour_clock_code	string
locale_code	string
preferred_language_code	string
time_zone_code	string
user_language_code	string
user_name	string
local_termination_reason	string
primary_termination_category	string
primary_termination_reason	string
regrettable_termination	boolean
terminated	boolean
termination_date	date
termination_involuntary	boolean
termination_last_day_of_work	date
id	string
universal_id	string
user_id	string

列	データ型
academic_tenure_date	date
active	boolean
active_status_date	date
benefits_service_date	date
company_service_date	date
continuous_service_date	date
date_entered_workforce	date
days_unemployed	decimal(12,0)
eligible_for_hire	string
eligible_for_rehire_on_latest_termination	string
expected_date_of_return	date
expected_retirement_date	date
first_day_of_work	date
has_international_assignment	boolean
hire_date	date
hire_reason	string
hire_rescinded	boolean
home_country	string
months_continuous_prior_employment	decimal(14,2)
not_returning	boolean
original_hire_date	date
pay_through_date	date
probation_end_date	date
probation_start_date	date
rehire	boolean
resignation_date	date
retired	boolean
retirement_date	date
return_unknown	boolean
seniority_date	date
severance_date	date
time_off_service_date	date
vesting_date	date
compensation_grade_ids	array<string>
compensation_grade_profile_ids	array<string>
display_language_code	string
hour_clock_code	string
locale_code	string
preferred_language_code	string
time_zone_code	string
user_language_code	string
user_name	string
local_termination_reason	string
primary_termination_category	string
primary_termination_reason	string
regrettable_termination	boolean
terminated	boolean
termination_date	date
termination_involuntary	boolean
termination_last_day_of_work	date
id	string
universal_id	string
user_id	string

人種

取り込みモード： 完全更新

宛先テーブル: 1

ethnicity

列	データ型
id	string
ethnicity_id	string
name	string
code	string
description	string
inactive	boolean
location_id	string
ethnicity_mapping_id	string

列	データ型
id	string
ethnicity_id	string
name	string
code	string
description	string
inactive	boolean
location_id	string
ethnicity_mapping_id	string

性別のアイデンティティ

取り込みモード： 完全更新

宛先テーブル: 1

gender_identity

列	データ型
id	string
gender_identity_id	string
order	string
name	string
code	string
description	string
inactive	boolean

列	データ型
id	string
gender_identity_id	string
order	string
name	string
code	string
description	string
inactive	boolean

LGBTの識別

取り込みモード： 完全更新

宛先テーブル: 1

lgbt_identification

列	データ型
id	string
lgbt_identification_id	string
name	string
description	string
inactive	boolean
location_id	string

列	データ型
id	string
lgbt_identification_id	string
name	string
description	string
inactive	boolean
location_id	string

代名詞

取り込みモード： 完全更新

宛先テーブル: 1

pronoun

列	データ型
id	string
pronoun_id	string
order	string
name	string
code	string
description	string
inactive	boolean

列	データ型
id	string
pronoun_id	string
order	string
name	string
code	string
description	string
inactive	boolean

性的指向

取り込みモード： 完全更新

宛先テーブル: 1

sexual_orientation

列	データ型
id	string
sexual_orientation_id	string
name	string
code	string
description	string
inactive	boolean

列	データ型
id	string
sexual_orientation_id	string
name	string
code	string
description	string
inactive	boolean

組織

取り込みモード： 完全更新

宛先テーブル: 5

organization

列	データ型
id	string
organization_code	string
name	string
description	string
include_manager_in_name	boolean
include_organization_code_in_name	boolean
type	string
sub_type	string
availability_date	timestamp
last_updated_date_time	timestamp
inactive	boolean
inactive_date	date
manager_id	string
organization_owner_id	string
visibility	string
external_url	string
top_level_organization_id	string
superior_organization_id	string
staffing_model	string
location	string
available_for_hire	boolean
hiring_freeze	boolean
supervisory_position_availability_date	date
supervisory_position_earliest_hire_date	date
supervisory_position_worker_type	string
supervisory_position_time_type	string
code	string

列	データ型
id	string
organization_code	string
name	string
description	string
include_manager_in_name	boolean
include_organization_code_in_name	boolean
type	string
sub_type	string
availability_date	timestamp
last_updated_date_time	timestamp
inactive	boolean
inactive_date	date
manager_id	string
organization_owner_id	string
visibility	string
external_url	string
top_level_organization_id	string
superior_organization_id	string
staffing_model	string
location	string
available_for_hire	boolean
hiring_freeze	boolean
supervisory_position_availability_date	date
supervisory_position_earliest_hire_date	date
supervisory_position_worker_type	string
supervisory_position_time_type	string
code	string

organization_assignment

列	データ型
organization_id	string
reference_organization_id	string
reference_organization_type	string

列	データ型
organization_id	string
reference_organization_id	string
reference_organization_type	string

organization_leader

列	データ型
organization_id	string
organization_manager_id	string

列	データ型
organization_id	string
organization_manager_id	string

organization_role

列	データ型
organization_id	string
role_id	string
organization_role_code	string

列	データ型
organization_id	string
role_id	string
organization_role_code	string

organization_role_worker

列	データ型
organization_id	string
role_id	string
associated_worker_id	string

列	データ型
organization_id	string
role_id	string
associated_worker_id	string

ジョブプロファイル

取り込みモード: インクリメンタル

宛先テーブル: 17

job_family_job_profile

列	データ型
job_profile_id	string
job_family_id	string

列	データ型
job_profile_id	string
job_family_id	string

job_profile

列	データ型
id	string
job_profile_code	string
effective_date	date
union_code	string
union_membership_requirement	string
work_study_award_source_code	string
work_study_requirement_option_code	string
compensation_grade_id	string
title	string
private_title	string
summary	string
description	string
additional_job_description	string
inactive	boolean
include_job_code_in_name	boolean
work_shift_required	boolean
public_job	boolean
critical_job	boolean
difficulty_to_fill	string
management_level	string
job_category_id	string
level	string
referral_payment_plan	string

列	データ型
id	string
job_profile_code	string
effective_date	date
union_code	string
union_membership_requirement	string
work_study_award_source_code	string
work_study_requirement_option_code	string
compensation_grade_id	string
title	string
private_title	string
summary	string
description	string
additional_job_description	string
inactive	boolean
include_job_code_in_name	boolean
work_shift_required	boolean
public_job	boolean
critical_job	boolean
difficulty_to_fill	string
management_level	string
job_category_id	string
level	string
referral_payment_plan	string

job_profile_certification

列	データ型
job_profile_id	string
certification_code	string
name	string
issuer	string
required	boolean
country_code	string
index	int

列	データ型
job_profile_id	string
certification_code	string
name	string
issuer	string
required	boolean
country_code	string
index	int

job_profile_classification

列	データ型
job_profile_id	string
job_classification_id	string

列	データ型
job_profile_id	string
job_classification_id	string

job_profile_company_insider

列	データ型
job_profile_id	string
company_insider_type	string
index	int

列	データ型
job_profile_id	string
company_insider_type	string
index	int

job_profile_competency

列	データ型
job_profile_id	string
competency_id	string
competency_code	string
required	boolean
proficiency_rating	string

列	データ型
job_profile_id	string
competency_id	string
competency_code	string
required	boolean
proficiency_rating	string

job_profile_education

列	データ型
job_profile_id	string
required	boolean
degree_code	string
field_of_study	string
index	int

列	データ型
job_profile_id	string
required	boolean
degree_code	string
field_of_study	string
index	int

job_profile_exempt

列	データ型
job_profile_id	string
is_job_exempt	boolean
location_context	string
index	int

列	データ型
job_profile_id	string
is_job_exempt	boolean
location_context	string
index	int

job_profile_language

列	データ型
job_profile_id	string
language_id	string
language_code	string
required	boolean

列	データ型
job_profile_id	string
language_id	string
language_code	string
required	boolean

job_profile_language_ability

列	データ型
job_profile_id	string
language_id	string
language_ability_type_code	string
language_proficiency_code	string
index	int

列	データ型
job_profile_id	string
language_id	string
language_ability_type_code	string
language_proficiency_code	string
index	int

job_profile_pay_rate

列	データ型
job_profile_id	string
country_code	string
pay_rate_code	string
index	int

列	データ型
job_profile_id	string
country_code	string
pay_rate_code	string
index	int

job_profile_responsibility

列	データ型
job_profile_id	string
description	string
required	boolean
index	int

列	データ型
job_profile_id	string
description	string
required	boolean
index	int

job_profile_restrict_to_country

列	データ型
job_profile_id	string
country_id	string
country_code	string

列	データ型
job_profile_id	string
country_id	string
country_code	string

job_profile_skill

列	データ型
job_profile_id	string
skill_code	string
name	string
required	boolean
index	int

列	データ型
job_profile_id	string
skill_code	string
name	string
required	boolean
index	int

job_profile_training

列	データ型
job_profile_id	string
name	string
description	string
required	boolean
training_type	string
index	int

列	データ型
job_profile_id	string
name	string
description	string
required	boolean
training_type	string
index	int

job_profile_work_experience

列	データ型
job_profile_id	string
work_experience_id	string
work_experience_code	string
required	boolean
work_experience_rating_id	string
work_experience_rating_code	string

列	データ型
job_profile_id	string
work_experience_id	string
work_experience_code	string
required	boolean
work_experience_rating_id	string
work_experience_rating_code	string

job_profile_worker_compensation

列	データ型
job_profile_id	string
worker_compensation_code	string
index	int

列	データ型
job_profile_id	string
worker_compensation_code	string
index	int

位置

取り込みモード: インクリメンタル

宛先テーブル： 18

position

列	データ型
id	string
supervisory_organization_id	string
effective_date	date
position_code	string
job_posting_title	string
academic_tenure_eligible	boolean
job_description_summary	string
job_description	string
available_for_hire	boolean
available_for_recruiting	boolean
hiring_freeze	boolean
work_shift_required	boolean
available_for_overlap	boolean
earliest_overlap_date	date
critical_job	boolean
difficulty_to_fill_code	string
availability_date	date
earliest_hire_date	date
worker_type_code	string
position_time_type_code	string
primary_compensation_basis	decimal(26,6)
primary_compensation_basis_amount_change	decimal(26,6)
primary_compensation_basis_percent_change	decimal(21,6)
compensation_package_code	string
compensation_grade_code	string
compensation_grade_profile_code	string
compensation_step_code	string
worker_for_filled_position_id	string
worker_position_id	string
closed	boolean

列	データ型
id	string
supervisory_organization_id	string
effective_date	date
position_code	string
job_posting_title	string
academic_tenure_eligible	boolean
job_description_summary	string
job_description	string
available_for_hire	boolean
available_for_recruiting	boolean
hiring_freeze	boolean
work_shift_required	boolean
available_for_overlap	boolean
earliest_overlap_date	date
critical_job	boolean
difficulty_to_fill_code	string
availability_date	date
earliest_hire_date	date
worker_type_code	string
position_time_type_code	string
primary_compensation_basis	decimal(26,6)
primary_compensation_basis_amount_change	decimal(26,6)
primary_compensation_basis_percent_change	decimal(21,6)
compensation_package_code	string
compensation_grade_code	string
compensation_grade_profile_code	string
compensation_step_code	string
worker_for_filled_position_id	string
worker_position_id	string
closed	boolean

position_bonus_plan

列	データ型
position_id	string
bonus_plan_id	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
percent_assigned	decimal(16,6)
bonus_plan_code	string
compensation_basis_override_amount	decimal(26,6)
inactive_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
position_id	string
bonus_plan_id	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
percent_assigned	decimal(16,6)
bonus_plan_code	string
compensation_basis_override_amount	decimal(26,6)
inactive_date	date
fixed_for_manage_by_basis_total	boolean

position_certification

列	データ型
position_id	string
id	string
certification_code	string
country	string
name	string
issuer	string
required	boolean
qualification_source	string

列	データ型
position_id	string
id	string
certification_code	string
country	string
name	string
issuer	string
required	boolean
qualification_source	string

position_competency

列	データ型
position_id	string
id	string
required	boolean
competency_code	string
proficiency_rating	string
qualification_source	string

列	データ型
position_id	string
id	string
required	boolean
competency_code	string
proficiency_rating	string
qualification_source	string

position_education

列	データ型
position_id	string
id	string
required	boolean
degree	string
field_of_study	string
qualification_source	string

列	データ型
position_id	string
id	string
required	boolean
degree	string
field_of_study	string
qualification_source	string

position_job_family

列	データ型
position_id	string
job_family_id	string

列	データ型
position_id	string
job_family_id	string

position_job_profile

列	データ型
position_id	string
job_profile_id	string
name	string
management_level_code	string
management_level_descriptor	string
job_category_code	string
work_shift_required	boolean
is_critical_job	boolean
difficulty_to_fill_code	string

列	データ型
position_id	string
job_profile_id	string
name	string
management_level_code	string
management_level_descriptor	string
job_category_code	string
work_shift_required	boolean
is_critical_job	boolean
difficulty_to_fill_code	string

position_language

列	データ型
position_id	string
id	string
language_code	string
required	boolean
qualification_source	string

列	データ型
position_id	string
id	string
language_code	string
required	boolean
qualification_source	string

position_location

列	データ型
position_id	string
location_id	string
location_code	string

列	データ型
position_id	string
location_id	string
location_code	string

position_merit_plan

列	データ型
position_id	string
merit_plan_id	string
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
merit_plan_code	string
individual_target_amount	decimal(26,6)
actual_end_date	date

列	データ型
position_id	string
merit_plan_id	string
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
merit_plan_code	string
individual_target_amount	decimal(26,6)
actual_end_date	date

position_organization

列	データ型
position_id	string
organization_id	string
type	string

列	データ型
position_id	string
organization_id	string
type	string

position_pay_plan

列	データ型
position_id	string
pay_plan_id	string
pay_plan_code	string
amount	decimal(26,6)
percent_change	decimal(21,6)
amount_change	decimal(26,6)
currency_code	string
frequency_code	string
expected_end_date	date
actual_end_date	date

列	データ型
position_id	string
pay_plan_id	string
pay_plan_code	string
amount	decimal(26,6)
percent_change	decimal(21,6)
amount_change	decimal(26,6)
currency_code	string
frequency_code	string
expected_end_date	date
actual_end_date	date

position_responsibility

列	データ型
position_id	string
id	string
responsibility	string
required	boolean
qualification_source	string

列	データ型
position_id	string
id	string
responsibility	string
required	boolean
qualification_source	string

position_skill

列	データ型
position_id	string
id	string
skill_code	string
name	string
required	boolean
qualification_source	string

列	データ型
position_id	string
id	string
skill_code	string
name	string
required	boolean
qualification_source	string

position_stock_plan

列	データ型
position_id	string
stock_plan_id	string
stock_plan_code	string
individual_target_shares	decimal(21,6)
individual_target_percent	decimal(18,6)
individual_target_amount	decimal(26,6)
currency_code	string
compensation_basis_override_amount	decimal(26,6)
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
position_id	string
stock_plan_id	string
stock_plan_code	string
individual_target_shares	decimal(21,6)
individual_target_percent	decimal(18,6)
individual_target_amount	decimal(26,6)
currency_code	string
compensation_basis_override_amount	decimal(26,6)
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

position_training

列	データ型
position_id	string
id	string
name	string
description	string
required	boolean
training_type	string
qualification_source	string

列	データ型
position_id	string
id	string
name	string
description	string
required	boolean
training_type	string
qualification_source	string

position_work_experience

列	データ型
position_id	string
id	string
work_experience_code	string
required	boolean
work_experience_rating	string
qualification_source	string

列	データ型
position_id	string
id	string
work_experience_code	string
required	boolean
work_experience_rating	string
qualification_source	string

position_worker_type_restriction

列	データ型
position_id	string
worker_type_id	string
worker_type_code	string

列	データ型
position_id	string
worker_type_id	string
worker_type_code	string

候補

取り込みモード： 完全更新

宛先テーブル： 10

candidate

列	データ型
id	string
candidate_code	string
pre_hire_id	string
worker_id	string
phone_device_type_code	string
phone_country_code	string
phone_number	string
phone_extension	string
email_address	string
country_code	string
address_line_1	string
address_line_2	string
address_line_3	string
address_line_4	string
address_line_5	string
address_line_6	string
address_line_7	string
address_line_8	string
address_line_9	string
address_line_1_local	string
address_line_2_local	string
address_line_3_local	string
address_line_4_local	string
address_line_5_local	string
address_line_6_local	string
city_code	string
country_region_code	string
region_subdivision_1	string
region_subdivision_2	string
region_subdivision_1_local	string
postal_code	string
do_not_hire	boolean
withdrawn	boolean
prospect	boolean
confidential	boolean
referral_consent_given	boolean
management_level_code	string
prospect_status_code	string
prospect_type_code	string
applicant_source	string
referred_by_worker_id	string
added_by_worker_id	string
candidate_owner_worker_id	string
ownership_start_date	timestamp
ownership_end_date	timestamp
user_language_code	string

列	データ型
id	string
candidate_code	string
pre_hire_id	string
worker_id	string
phone_device_type_code	string
phone_country_code	string
phone_number	string
phone_extension	string
email_address	string
country_code	string
address_line_1	string
address_line_2	string
address_line_3	string
address_line_4	string
address_line_5	string
address_line_6	string
address_line_7	string
address_line_8	string
address_line_9	string
address_line_1_local	string
address_line_2_local	string
address_line_3_local	string
address_line_4_local	string
address_line_5_local	string
address_line_6_local	string
city_code	string
country_region_code	string
region_subdivision_1	string
region_subdivision_2	string
region_subdivision_1_local	string
postal_code	string
do_not_hire	boolean
withdrawn	boolean
prospect	boolean
confidential	boolean
referral_consent_given	boolean
management_level_code	string
prospect_status_code	string
prospect_type_code	string
applicant_source	string
referred_by_worker_id	string
added_by_worker_id	string
candidate_owner_worker_id	string
ownership_start_date	timestamp
ownership_end_date	timestamp
user_language_code	string

candidate_certification

列	データ型
job_application_id	string
certification_code	string
removed	boolean
country	string
certification_number	string
exam_date	date
exam_score	string
issued_date	date
expiration_date	date
index	int

列	データ型
job_application_id	string
certification_code	string
removed	boolean
country	string
certification_number	string
exam_date	date
exam_score	string
issued_date	date
expiration_date	date
index	int

candidate_education

列	データ型
job_application_id	string
school_code	string
school_name	string
first_year_attended	decimal(4,0)
last_year_attended	decimal(4,0)
degree_code	string
field_of_study_code	string
grade_average	string
index	int

列	データ型
job_application_id	string
school_code	string
school_name	string
first_year_attended	decimal(4,0)
last_year_attended	decimal(4,0)
degree_code	string
field_of_study_code	string
grade_average	string
index	int

candidate_experience

列	データ型
job_application_id	string
company_code	string
company_name	string
title	string
location	string
start_month	decimal(2,0)
start_year	decimal(4,0)
end_month	decimal(2,0)
end_year	decimal(4,0)
currently_work_here	boolean
description	string
index	int

列	データ型
job_application_id	string
company_code	string
company_name	string
title	string
location	string
start_month	decimal(2,0)
start_year	decimal(4,0)
end_month	decimal(2,0)
end_year	decimal(4,0)
currently_work_here	boolean
description	string
index	int

candidate_language

列	データ型
job_application_id	string
language_code	string
index	int

列	データ型
job_application_id	string
language_code	string
index	int

candidate_name

列	データ型
candidate_id	string
title	string
salutation_suffix	string
first_name	string
middle_name	string
hereditary_suffix	string
last_name	string
secondary_last_name	string
tertiary_last_name	string
social_suffix	string
local_first_name	string
local_middle_name	string
local_last_name	string
local_secondary_last_name	string
type	string

列	データ型
candidate_id	string
title	string
salutation_suffix	string
first_name	string
middle_name	string
hereditary_suffix	string
last_name	string
secondary_last_name	string
tertiary_last_name	string
social_suffix	string
local_first_name	string
local_middle_name	string
local_last_name	string
local_secondary_last_name	string
type	string

candidate_pool_membership

列	データ型
candidate_id	string
candidate_pool_id	string
candidate_pool_code	string
readiness_status_id	string
readiness_status_code	string

列	データ型
candidate_id	string
candidate_pool_id	string
candidate_pool_code	string
readiness_status_id	string
readiness_status_code	string

candidate_skill

列	データ型
job_application_id	string
skill_code	string
skill_name	string
index	int

列	データ型
job_application_id	string
skill_code	string
skill_name	string
index	int

candidate_tag

列	データ型
candidate_id	string
tag_code	string
index	int

列	データ型
candidate_id	string
tag_code	string
index	int

candidate_website

列	データ型
candidate_id	string
url	string
index	int

列	データ型
candidate_id	string
url	string
index	int

アンケート

取り込みモード： 完全更新

宛先テーブル： 2

questionnaire

列	データ型
id	string
questionnaire_code	string
name	string
display_name	string
instructions	string
inactive	boolean

列	データ型
id	string
questionnaire_code	string
name	string
display_name	string
instructions	string
inactive	boolean

questionnaire_setup

列	データ型
questionnaire_id	string
questionnaire_setup_id	string
question_description	string
order	string
required	boolean

列	データ型
questionnaire_id	string
questionnaire_setup_id	string
question_description	string
order	string
required	boolean

インタビュー

取り込みモード： 完全更新

宛先テーブル: 6

interview

列	データ型
id	string
overall_comment	string
time_zone_code	string

列	データ型
id	string
overall_comment	string
time_zone_code	string

interview_competency

列	データ型
interview_session_detail_id	int
interview_session_id	string
competency_id	string
competency_code	string

列	データ型
interview_session_detail_id	int
interview_session_id	string
competency_id	string
competency_code	string

interview_questionnaire

列	データ型
interview_session_detail_id	int
interview_session_id	string
questionnaire_id	string

列	データ型
interview_session_detail_id	int
interview_session_id	string
questionnaire_id	string

interview_session

列	データ型
interview_id	string
interview_session_id	string
interview_session_code	string

列	データ型
interview_id	string
interview_session_id	string
interview_session_code	string

interview_session_detail

列	データ型
interview_session_id	string
interview_start_time	timestamp
interview_end_time	timestamp
location_code	string
interview_type_code	string
comment	string
index	int

列	データ型
interview_session_id	string
interview_start_time	timestamp
interview_end_time	timestamp
location_code	string
interview_type_code	string
comment	string
index	int

interviewer

列	データ型
interview_session_detail_id	int
interview_session_id	string
interviewer_id	string

列	データ型
interview_session_detail_id	int
interview_session_id	string
interviewer_id	string

外部参照

取り込みモード： 完全更新

宛先テーブル： 3

external_reference_line

列	データ型
id	string
job_application_id	string
candidate_id	string
job_requisition_id	string

列	データ型
id	string
job_application_id	string
candidate_id	string
job_requisition_id	string

external_reference_participant

列	データ型
external_reference_id	string
referee_id	string
referee_code	string
questionnaire_id	string

列	データ型
external_reference_id	string
referee_id	string
referee_code	string
questionnaire_id	string

questionnaire_answer

列	データ型
reference_id	string
question_order	string
date	date
answer_numeric	decimal(12,0)
answer_text	string
index	int

列	データ型
reference_id	string
question_order	string
date	date
answer_numeric	decimal(12,0)
answer_text	string
index	int

ジョブ申請

取り込みモード: インクリメンタル

宛先テーブル： 28

job_requisition

列	データ型
id	string
status_code	string
job_posting_title	string
positions_allocated	decimal(7,0)
positions_available	decimal(7,0)
academic_tenure_eligible	boolean
job_description_summary	string
job_description	string
additional_job_description	string
justification	string
recruiting_instruction_code	string
do_not_send_to_recruiting_system	boolean
available_for_recruiting	boolean
replacement_for_worker_id	string
confidential_job_requisition	boolean
job_application_template_code	string
recruiting_start_date	date
target_hire_date	date
target_end_date	date
job_profile_id	string
worker_type_code	string
position_worker_type_code	string
remote_type_code	string
primary_location_code	string
primary_job_posting_location_code	string
position_time_type_code	string
employee_contract_type_code	string
scheduled_weekly_hours	decimal(14,2)
work_shift_code	string
spotlight_job	boolean
referral_payment_plan_code	string
internal_career_site_questionnaire_id	string
internal_career_site_secondary_questionnaire_id	string
external_career_sites_questionnaire_id	string
external_career_site_secondary_questionnaire_id	string
inline_assessment_test_code	string
supervisory_organization_id	string
job_requisition_code	string
is_evergreen_job_requisition	boolean

列	データ型
id	string
status_code	string
job_posting_title	string
positions_allocated	decimal(7,0)
positions_available	decimal(7,0)
academic_tenure_eligible	boolean
job_description_summary	string
job_description	string
additional_job_description	string
justification	string
recruiting_instruction_code	string
do_not_send_to_recruiting_system	boolean
available_for_recruiting	boolean
replacement_for_worker_id	string
confidential_job_requisition	boolean
job_application_template_code	string
recruiting_start_date	date
target_hire_date	date
target_end_date	date
job_profile_id	string
worker_type_code	string
position_worker_type_code	string
remote_type_code	string
primary_location_code	string
primary_job_posting_location_code	string
position_time_type_code	string
employee_contract_type_code	string
scheduled_weekly_hours	decimal(14,2)
work_shift_code	string
spotlight_job	boolean
referral_payment_plan_code	string
internal_career_site_questionnaire_id	string
internal_career_site_secondary_questionnaire_id	string
external_career_sites_questionnaire_id	string
external_career_site_secondary_questionnaire_id	string
inline_assessment_test_code	string
supervisory_organization_id	string
job_requisition_code	string
is_evergreen_job_requisition	boolean

job_requisition_additional_job_posting_location

列	データ型
job_requisition_id	string
location_id	string
location_code	string

列	データ型
job_requisition_id	string
location_id	string
location_code	string

job_requisition_additional_job_profile

列	データ型
job_requisition_id	string
job_profile_id	string

列	データ型
job_requisition_id	string
job_profile_id	string

job_requisition_additional_location

列	データ型
job_requisition_id	string
location_id	string
location_code	string

列	データ型
job_requisition_id	string
location_id	string
location_code	string

job_requisition_allowance_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
allowance_plan_id	string
allowance_plan_code	string
percent	decimal(20,10)
amount	decimal(26,6)
compensation_basis_override_amount	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date
reimbursement_start_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
allowance_plan_id	string
allowance_plan_code	string
percent	decimal(20,10)
amount	decimal(26,6)
compensation_basis_override_amount	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date
reimbursement_start_date	date
fixed_for_manage_by_basis_total	boolean

job_requisition_bonus_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
bonus_plan_id	string
bonus_plan_code	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
compensation_basis_override_amount	decimal(26,6)
guaranteed_minimum	boolean
percent_assigned	decimal(16,6)
inactive_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
bonus_plan_id	string
bonus_plan_code	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
compensation_basis_override_amount	decimal(26,6)
guaranteed_minimum	boolean
percent_assigned	decimal(16,6)
inactive_date	date
fixed_for_manage_by_basis_total	boolean

job_requisition_calculated_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
calculated_plan_id	string
calculated_plan_code	string
amount_override	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
calculated_plan_id	string
calculated_plan_code	string
amount_override	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date

job_requisition_certification

列	データ型
job_requisition_id	string
id	string
certification_code	string
country	string
name	string
issuer	string
required	boolean
qualification_source	string

列	データ型
job_requisition_id	string
id	string
certification_code	string
country	string
name	string
issuer	string
required	boolean
qualification_source	string

job_requisition_commission_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
commission_plan_id	string
commission_plan_code	string
target_amount	decimal(26,6)
currency_code	string
frequency_code	string
draw_amount	decimal(21,6)
draw_frequency_code	string
draw_duration	string
recoverable	boolean
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
commission_plan_id	string
commission_plan_code	string
target_amount	decimal(26,6)
currency_code	string
frequency_code	string
draw_amount	decimal(21,6)
draw_frequency_code	string
draw_duration	string
recoverable	boolean
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

job_requisition_compensation

列	データ型
job_requisition_id	string
primary_compensation_basis	decimal(26,6)
primary_compensation_basis_amount_change	decimal(26,6)
primary_compensation_basis_percent_change	decimal(21,6)
compensation_package_code	string
compensation_grade_id	string
compensation_grade_profile_id	string
compensation_step_code	string
index	int

列	データ型
job_requisition_id	string
primary_compensation_basis	decimal(26,6)
primary_compensation_basis_amount_change	decimal(26,6)
primary_compensation_basis_percent_change	decimal(21,6)
compensation_package_code	string
compensation_grade_id	string
compensation_grade_profile_id	string
compensation_step_code	string
index	int

job_requisition_competency

列	データ型
job_requisition_id	string
id	string
required	boolean
competency_code	string
proficiency_rating	string
qualification_source	string

列	データ型
job_requisition_id	string
id	string
required	boolean
competency_code	string
proficiency_rating	string
qualification_source	string

job_requisition_custom_organization

列	データ型
job_requisition_id	string
custom_organization_id	string

列	データ型
job_requisition_id	string
custom_organization_id	string

job_requisition_default_assessment_test

列	データ型
job_requisition_id	string
id	string
default_assessment_test_code	string

列	データ型
job_requisition_id	string
id	string
default_assessment_test_code	string

job_requisition_education

列	データ型
job_requisition_id	string
id	string
required	boolean
degree	string
field_of_study	string
qualification_source	string

列	データ型
job_requisition_id	string
id	string
required	boolean
degree	string
field_of_study	string
qualification_source	string

job_requisition_language

列	データ型
job_requisition_id	string
id	string
language_code	string
required	boolean
qualification_source	string

列	データ型
job_requisition_id	string
id	string
language_code	string
required	boolean
qualification_source	string

job_requisition_language_ability

列	データ型
job_requisition_language_id	string
language_ability_type	string
language_proficiency	string
index	int

列	データ型
job_requisition_language_id	string
language_ability_type	string
language_proficiency	string
index	int

job_requisition_merit_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
merit_plan_id	string
merit_plan_code	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
actual_end_date	date

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
merit_plan_id	string
merit_plan_code	string
individual_target_amount	decimal(26,6)
individual_target_percent	decimal(16,6)
guaranteed_minimum	boolean
actual_end_date	date

job_requisition_organization

列	データ型
job_requisition_id	string
company_id	string
cost_center_id	string
region_id	string
business_unit_code	string
grant_code	string
program_code	string
fund_code	string
gift_code	string
index	int

列	データ型
job_requisition_id	string
company_id	string
cost_center_id	string
region_id	string
business_unit_code	string
grant_code	string
program_code	string
fund_code	string
gift_code	string
index	int

job_requisition_pay_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
pay_plan_id	string
pay_plan_code	string
amount	decimal(26,6)
percent_change	decimal(21,6)
amount_change	decimal(26,6)
currency_code	string
frequency_code	string
expected_end_date	date
actual_end_date	date

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
pay_plan_id	string
pay_plan_code	string
amount	decimal(26,6)
percent_change	decimal(21,6)
amount_change	decimal(26,6)
currency_code	string
frequency_code	string
expected_end_date	date
actual_end_date	date

job_requisition_period_salary_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
period_salary_plan_id	string
period_salary_plan_code	string
compensation_period_code	string
compensation_basis_override_amount	decimal(26,6)
currency_code	string
compensation_period_multiplier	decimal(18,6)
frequency_code	string
actual_end_date	date

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
period_salary_plan_id	string
period_salary_plan_code	string
compensation_period_code	string
compensation_basis_override_amount	decimal(26,6)
currency_code	string
compensation_period_multiplier	decimal(18,6)
frequency_code	string
actual_end_date	date

job_requisition_position

列	データ型
job_requisition_id	string
position_id	string

列	データ型
job_requisition_id	string
position_id	string

job_requisition_responsibility

列	データ型
job_requisition_id	string
id	string
responsibility	string
required	boolean
qualification_source	string

列	データ型
job_requisition_id	string
id	string
responsibility	string
required	boolean
qualification_source	string

job_requisition_skill

列	データ型
job_requisition_id	string
id	string
skill_code	string
name	string
required	boolean
qualification_source	string

列	データ型
job_requisition_id	string
id	string
skill_code	string
name	string
required	boolean
qualification_source	string

job_requisition_stock_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
stock_plan_id	string
stock_plan_code	string
individual_target_shares	decimal(21,6)
individual_target_percent	decimal(18,6)
individual_target_amount	decimal(26,6)
compensation_basis_override_amount	decimal(26,6)
currency_code	string
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
stock_plan_id	string
stock_plan_code	string
individual_target_shares	decimal(21,6)
individual_target_percent	decimal(18,6)
individual_target_amount	decimal(26,6)
compensation_basis_override_amount	decimal(26,6)
currency_code	string
actual_end_date	date
fixed_for_manage_by_basis_total	boolean

job_requisition_training

列	データ型
job_requisition_id	string
id	string
name	string
description	string
required	boolean
training_type	string
qualification_source	string

列	データ型
job_requisition_id	string
id	string
name	string
description	string
required	boolean
training_type	string
qualification_source	string

job_requisition_unit_allowance_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
unit_allowance_plan_id	string
unit_allowance_plan_code	string
number_of_units	decimal(21,6)
per_unit_amount	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date
reimbursement_start_date	date
fixed_for_manage_by_basis_total	boolean

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
unit_allowance_plan_id	string
unit_allowance_plan_code	string
number_of_units	decimal(21,6)
per_unit_amount	decimal(26,6)
currency_code	string
frequency_code	string
actual_end_date	date
reimbursement_start_date	date
fixed_for_manage_by_basis_total	boolean

job_requisition_unit_salary_plan

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
unit_salary_plan_id	string
unit_salary_plan_code	string
per_unit_amount	decimal(26,6)
currency_code	string
default_units	decimal(21,6)
frequency_code	string
actual_end_date	date

列	データ型
job_requisition_compensation_id	int
job_requisition_id	string
unit_salary_plan_id	string
unit_salary_plan_code	string
per_unit_amount	decimal(26,6)
currency_code	string
default_units	decimal(21,6)
frequency_code	string
actual_end_date	date

job_requisition_work_experience

列	データ型
job_requisition_id	string
id	string
work_experience_code	string
required	boolean
work_experience_rating	string
qualification_source	string

列	データ型
job_requisition_id	string
id	string
work_experience_code	string
required	boolean
work_experience_rating	string
qualification_source	string

給与計算結果

取り込みモード: インクリメンタル

宛先テーブル： 9

payroll_line

列	データ型
payroll_id	string
employee_id	string
company_id	string
costing_company_id	string
arrco_agirc_category_code	string
arrear_amount	decimal(18,6)
business_unit_worktag_code	string
amount	decimal(26,6)
custom_worktag_06_code	string
custom_worktag_07_code	string
custom_worktag_08_code	string
custom_worktag_09_code	string
custom_worktag_10_code	string
custom_worktag_11_code	string
custom_worktag_12_code	string
custom_worktag_13_code	string
custom_worktag_14_code	string
custom_worktag_15_code	string
exemption_code	string
fund_worktag_code	string
gift_worktag_code	string
grant_worktag_code	string
income_code	string
input_comment	string
ni_category_code	string
object_class_worktag_code	string
pay_frequency	decimal(18,6)
period_remaining	decimal(12,0)
program_worktag_code	string
project_phase_worktag_code	string
project_task_worktag_code	string
subperiod_end	date
subperiod_start	date
tax_residency_country_code	string
workers_compensation_code	string
index	int

列	データ型
payroll_id	string
employee_id	string
company_id	string
costing_company_id	string
arrco_agirc_category_code	string
arrear_amount	decimal(18,6)
business_unit_worktag_code	string
amount	decimal(26,6)
custom_worktag_06_code	string
custom_worktag_07_code	string
custom_worktag_08_code	string
custom_worktag_09_code	string
custom_worktag_10_code	string
custom_worktag_11_code	string
custom_worktag_12_code	string
custom_worktag_13_code	string
custom_worktag_14_code	string
custom_worktag_15_code	string
exemption_code	string
fund_worktag_code	string
gift_worktag_code	string
grant_worktag_code	string
income_code	string
input_comment	string
ni_category_code	string
object_class_worktag_code	string
pay_frequency	decimal(18,6)
period_remaining	decimal(12,0)
program_worktag_code	string
project_phase_worktag_code	string
project_task_worktag_code	string
subperiod_end	date
subperiod_start	date
tax_residency_country_code	string
workers_compensation_code	string
index	int

payroll_line_pay_component

列	データ型
payroll_id	string
payroll_line_index	int
earning	string
deduction	string
index	int

列	データ型
payroll_id	string
payroll_line_index	int
earning	string
deduction	string
index	int

payroll_line_related_calculation

列	データ型
payroll_id	string
payroll_line_index	int
amount	decimal(26,6)
calculation_code	string
workday_calculation_code	string
index	int

列	データ型
payroll_id	string
payroll_line_index	int
amount	decimal(26,6)
calculation_code	string
workday_calculation_code	string
index	int

payroll_line_withholding

列	データ型
payroll_id	string
begin_date	date
case_number	string
deduction_recepient	string
deduction_recepient_bank_account	string
end_date	date
memo	string
order_date	date
order_priority	decimal(6,0)
order_status	string
order_type	string
originating_entity	string
pay_frequency	string
pay_period_amount	decimal(26,6)
pay_period_amount_type	string
pay_period_percent	decimal(9,6)
received_date	timestamp
tax_authority	string
total_debt	decimal(26,6)
payroll_line_index	int

列	データ型
payroll_id	string
begin_date	date
case_number	string
deduction_recepient	string
deduction_recepient_bank_account	string
end_date	date
memo	string
order_date	date
order_priority	decimal(6,0)
order_status	string
order_type	string
originating_entity	string
pay_frequency	string
pay_period_amount	decimal(26,6)
pay_period_amount_type	string
pay_period_percent	decimal(9,6)
received_date	timestamp
tax_authority	string
total_debt	decimal(26,6)
payroll_line_index	int

payroll_local_city_authority_tax_worktag

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_local_city_authority_tax_code	string

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_local_city_authority_tax_code	string

payroll_local_county_authority_tax_worktag

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_local_county_authority_tax_code	string

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_local_county_authority_tax_code	string

payroll_national_id

列	データ型
payroll_id	string
id	string
type	string
country	string
issued_date	date
expiration_date	date
verification_date	date
series	string
issuing_agency	string
verified_by	string

列	データ型
payroll_id	string
id	string
type	string
country	string
issued_date	date
expiration_date	date
verification_date	date
series	string
issuing_agency	string
verified_by	string

payroll_result

列	データ型
id	string
employee_id	string
company_id	string
payroll_code	string
account_number	string
establishment	string
pay_group	string
run_category	string
pay_period_frequency	decimal(18,6)
off_cycle_type	string
for_additional_pay	boolean
result_completed_date	timestamp
period	string
period_start	date
period_end	date
subperiod_start	date
subperiod_end	date
payment_date	date
currency	string
original_payment_date	date
gross_amount	decimal(18,6)
net_amount	decimal(26,6)

列	データ型
id	string
employee_id	string
company_id	string
payroll_code	string
account_number	string
establishment	string
pay_group	string
run_category	string
pay_period_frequency	decimal(18,6)
off_cycle_type	string
for_additional_pay	boolean
result_completed_date	timestamp
period	string
period_start	date
period_end	date
subperiod_start	date
subperiod_end	date
payment_date	date
currency	string
original_payment_date	date
gross_amount	decimal(18,6)
net_amount	decimal(26,6)

payroll_state_authority_tax_worktag

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_state_authority_tax_code	string

列	データ型
payroll_id	string
payroll_line_id	int
id	string
payroll_state_authority_tax_code	string

報酬プラン

取り込みモード： 完全更新

宛先テーブル： 15

compensation_allowance_plan_amount_profile

列	データ型
compensation_plan_id	string
amount	decimal(26,6)
currency	string
compensation_eligibility_rule_id	string
index	int

列	データ型
compensation_plan_id	string
amount	decimal(26,6)
currency	string
compensation_eligibility_rule_id	string
index	int

compensation_allowance_plan_percent_profile

列	データ型
compensation_plan_id	string
percent	decimal(18,6)
ceiling_amount	decimal(26,6)
ceiling_currency	string
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

列	データ型
compensation_plan_id	string
percent	decimal(18,6)
ceiling_amount	decimal(26,6)
ceiling_currency	string
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

compensation_bonus_plan_coverage_date_eligibility_rule

列	データ型
compensation_plan_id	string
compensation_eligibility_rule_id	string

列	データ型
compensation_plan_id	string
compensation_eligibility_rule_id	string

compensation_bonus_plan_performance_factor_scorecard

列	データ型
compensation_plan_id	string
id	string
performance_scorecard_code	string
weight	decimal(10,4)
bonus_modifier	string

列	データ型
compensation_plan_id	string
id	string
performance_scorecard_code	string
weight	decimal(10,4)
bonus_modifier	string

compensation_bonus_plan_replacement_percent

列	データ型
compensation_plan_id	string
percentage	decimal(16,4)
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

列	データ型
compensation_plan_id	string
percentage	decimal(16,4)
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

compensation_bonus_tranche

列	データ型
compensation_plan_id	string
name	decimal(12,0)
percentage	decimal(18,6)

列	データ型
compensation_plan_id	string
name	decimal(12,0)
percentage	decimal(18,6)

compensation_commission_plan_profile

列	データ型
compensation_plan_id	string
currency	string
amount	decimal(26,6)
draw_amount	decimal(21,6)
compensation_eligibility_rule_id	string
index	int

列	データ型
compensation_plan_id	string
currency	string
amount	decimal(26,6)
draw_amount	decimal(21,6)
compensation_eligibility_rule_id	string
index	int

compensation_future_payment_bonus_plan

列	データ型
compensation_plan_id	string
bonus_plan_id	string

列	データ型
compensation_plan_id	string
bonus_plan_id	string

compensation_merit_plan_replacement_percent

列	データ型
compensation_plan_id	string
percentage	decimal(18,6)
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

列	データ型
compensation_plan_id	string
percentage	decimal(18,6)
compensation_eligibility_rule_id	string
compensation_basis	string
calculation_compensation	string
index	int

compensation_plan

列	データ型
id	string
compensation_plan_code	string
allowance_plan_element	string
allowance_plan_currency	string
allowance_plan_frequency	string
allowance_plan_no_individual_override	boolean
allowance_plan_exclude_from_merit	boolean
allowance_plan_apply_full_time_equivalent	boolean
allowance_plan_amount	decimal(26,6)
allowance_plan_percentage	decimal(16,6)
allowance_plan_compensation_basis	string
allowance_plan_calculation_compensation	string
allowance_plan_percent_ceiling_amount	decimal(26,6)
allowance_plan_percent_ceiling_currency	string
allowance_plan_default_units	decimal(21,6)
allowance_plan_per_unit_amount	decimal(26,6)
allowance_plan_unit_of_measure	string
allowance_plan_reimbursement_expense_item	string
allowance_plan_reimbursement_expense_accumulator	string
base_plan_exclude_from_merit	boolean
base_plan_currency	string
base_plan_frequency	string
base_plan_element	string
base_plan_salary_apply_full_time_equivalent	boolean
base_plan_hourly_amount	decimal(26,6)
base_plan_hourly_minimum_wage	boolean
base_plan_unit_salary_per_unit_amount	decimal(26,6)
base_plan_unit_salary_default_units	decimal(21,6)
base_plan_unit_salary_no_individual_override	boolean
base_plan_unit_salary_unit_of_measure	string
bonus_plan_currency	string
bonus_plan_frequency	string
bonus_plan_element	string
bonus_plan_allow_individual_targets	boolean
bonus_plan_apply_full_time_equivalent	boolean
bonus_plan_waiting_period	string
bonus_plan_time_proration	string
bonus_plan_include_active_employees_in_waiting_period	boolean
bonus_plan_rounding_rule	string
bonus_plan_performance_scorecard	string
bonus_plan_include_active_employees_assigned	boolean
bonus_plan_performance_matrix_compensation_matrix_id	string
bonus_plan_performance_matrix_use_matrix_as_reference_only	boolean
bonus_plan_performance_matrix_apply_net_attainment	boolean
bonus_plan_performance_matrix_bonus_modifier	string
bonus_plan_performance_factor_apply_net_attainment	boolean
bonus_plan_performance_factor_weight	decimal(10,4)
bonus_plan_performance_factor_compensation_matrix_id	string
bonus_plan_performance_factor_bonus_modifier	string
bonus_plan_amount	decimal(26,6)
bonus_plan_percentage	decimal(14,4)
bonus_plan_compensation_basis	string
bonus_plan_calculation_compensation	string
bonus_plan_deferred_compensation_calculation	string
bonus_plan_deferred_compensation_stock_plan	string
calculated_plan_element	string
calculated_plan_currency	string
calculated_plan_frequency	string
calculated_plan_calculation	string
calculated_plan_exclude_from_total_salary_and_allowance_compensation	boolean
calculated_plan_is_dynamic_calculated_plan	boolean
calculated_plan_is_event_driven_calculated_plan	boolean
commission_plan_element	string
commission_plan_currency	string
commission_plan_frequency	string
commission_plan_target_amount	decimal(26,6)
commission_plan_draw_amount	decimal(21,6)
commission_plan_draw_frequency	string
commission_plan_draw_duration	string
commission_plan_recoverable	boolean
description	string
effective_date	date
future_payment_plan_element	string
future_payment_plan_currency	string
future_payment_plan_frequency	string
future_payment_plan_allow_individual_targets	boolean
future_payment_plan_include_all_bonus_compensation_plan	boolean
future_payment_plan_include_one_time_payment_compensation_plan	boolean
future_payment_plan_amount	decimal(26,6)
inactive	boolean
merit_plan_currency	string
merit_plan_frequency	string
merit_plan_subject_to_statutory_minimum	boolean
merit_plan_allow_individual_targets	boolean
merit_plan_compensation_matrix_id	string
merit_plan_use_matrix_as_reference_only	boolean
merit_plan_waiting_period	string
merit_plan_include_active_employees_in_waiting_period	boolean
merit_plan_time_proration	string
merit_plan_rounding_rule	string
merit_plan_include_active_employess_assigned	boolean
merit_plan_target_percentage	decimal(16,6)
merit_plan_percentage_manage_by_compensation_basis	boolean
merit_plan_percentage_calculation_compensation	string
merit_plan_percentage_compensation_basis	string
merit_plan_required_amount	decimal(26,6)
merit_plan_amount_calculation_compensation	string
merit_plan_amount_compensation_basis	string
merit_plan_amount_manage_by_compensation_basis	boolean
name	string
period_plan_calculation_compensation	string
period_plan_compensation_basis	string
period_plan_element	string
period_plan_default_compensation_multiplier	decimal(18,6)
period_plan_unit_of_duration	string
stock_plan_allow_target_override	boolean
stock_plan_compensation_matrix_id	string
stock_plan_use_as_reference_only	boolean
stock_plan_unit_data_target_shares	decimal(15,0)
stock_plan_percent_data_calculation_compensation	string
stock_plan_percent_data_compensation_basis	string
stock_plan_percent_data_rounding_rule	string
stock_plan_percent_data_target_percent	decimal(19,4)
stock_plan_amount_data_rounding_rule	string
stock_plan_amount_data_use_target_currency	boolean
stock_plan_amount_data_target_amount	decimal(21,6)
stock_plan_amount_data_currency	string

列	データ型
id	string
compensation_plan_code	string
allowance_plan_element	string
allowance_plan_currency	string
allowance_plan_frequency	string
allowance_plan_no_individual_override	boolean
allowance_plan_exclude_from_merit	boolean
allowance_plan_apply_full_time_equivalent	boolean
allowance_plan_amount	decimal(26,6)
allowance_plan_percentage	decimal(16,6)
allowance_plan_compensation_basis	string
allowance_plan_calculation_compensation	string
allowance_plan_percent_ceiling_amount	decimal(26,6)
allowance_plan_percent_ceiling_currency	string
allowance_plan_default_units	decimal(21,6)
allowance_plan_per_unit_amount	decimal(26,6)
allowance_plan_unit_of_measure	string
allowance_plan_reimbursement_expense_item	string
allowance_plan_reimbursement_expense_accumulator	string
base_plan_exclude_from_merit	boolean
base_plan_currency	string
base_plan_frequency	string
base_plan_element	string
base_plan_salary_apply_full_time_equivalent	boolean
base_plan_hourly_amount	decimal(26,6)
base_plan_hourly_minimum_wage	boolean
base_plan_unit_salary_per_unit_amount	decimal(26,6)
base_plan_unit_salary_default_units	decimal(21,6)
base_plan_unit_salary_no_individual_override	boolean
base_plan_unit_salary_unit_of_measure	string
bonus_plan_currency	string
bonus_plan_frequency	string
bonus_plan_element	string
bonus_plan_allow_individual_targets	boolean
bonus_plan_apply_full_time_equivalent	boolean
bonus_plan_waiting_period	string
bonus_plan_time_proration	string
bonus_plan_include_active_employees_in_waiting_period	boolean
bonus_plan_rounding_rule	string
bonus_plan_performance_scorecard	string
bonus_plan_include_active_employees_assigned	boolean
bonus_plan_performance_matrix_compensation_matrix_id	string
bonus_plan_performance_matrix_use_matrix_as_reference_only	boolean
bonus_plan_performance_matrix_apply_net_attainment	boolean
bonus_plan_performance_matrix_bonus_modifier	string
bonus_plan_performance_factor_apply_net_attainment	boolean
bonus_plan_performance_factor_weight	decimal(10,4)
bonus_plan_performance_factor_compensation_matrix_id	string
bonus_plan_performance_factor_bonus_modifier	string
bonus_plan_amount	decimal(26,6)
bonus_plan_percentage	decimal(14,4)
bonus_plan_compensation_basis	string
bonus_plan_calculation_compensation	string
bonus_plan_deferred_compensation_calculation	string
bonus_plan_deferred_compensation_stock_plan	string
calculated_plan_element	string
calculated_plan_currency	string
calculated_plan_frequency	string
calculated_plan_calculation	string
calculated_plan_exclude_from_total_salary_and_allowance_compensation	boolean
calculated_plan_is_dynamic_calculated_plan	boolean
calculated_plan_is_event_driven_calculated_plan	boolean
commission_plan_element	string
commission_plan_currency	string
commission_plan_frequency	string
commission_plan_target_amount	decimal(26,6)
commission_plan_draw_amount	decimal(21,6)
commission_plan_draw_frequency	string
commission_plan_draw_duration	string
commission_plan_recoverable	boolean
description	string
effective_date	date
future_payment_plan_element	string
future_payment_plan_currency	string
future_payment_plan_frequency	string
future_payment_plan_allow_individual_targets	boolean
future_payment_plan_include_all_bonus_compensation_plan	boolean
future_payment_plan_include_one_time_payment_compensation_plan	boolean
future_payment_plan_amount	decimal(26,6)
inactive	boolean
merit_plan_currency	string
merit_plan_frequency	string
merit_plan_subject_to_statutory_minimum	boolean
merit_plan_allow_individual_targets	boolean
merit_plan_compensation_matrix_id	string
merit_plan_use_matrix_as_reference_only	boolean
merit_plan_waiting_period	string
merit_plan_include_active_employees_in_waiting_period	boolean
merit_plan_time_proration	string
merit_plan_rounding_rule	string
merit_plan_include_active_employess_assigned	boolean
merit_plan_target_percentage	decimal(16,6)
merit_plan_percentage_manage_by_compensation_basis	boolean
merit_plan_percentage_calculation_compensation	string
merit_plan_percentage_compensation_basis	string
merit_plan_required_amount	decimal(26,6)
merit_plan_amount_calculation_compensation	string
merit_plan_amount_compensation_basis	string
merit_plan_amount_manage_by_compensation_basis	boolean
name	string
period_plan_calculation_compensation	string
period_plan_compensation_basis	string
period_plan_element	string
period_plan_default_compensation_multiplier	decimal(18,6)
period_plan_unit_of_duration	string
stock_plan_allow_target_override	boolean
stock_plan_compensation_matrix_id	string
stock_plan_use_as_reference_only	boolean
stock_plan_unit_data_target_shares	decimal(15,0)
stock_plan_percent_data_calculation_compensation	string
stock_plan_percent_data_compensation_basis	string
stock_plan_percent_data_rounding_rule	string
stock_plan_percent_data_target_percent	decimal(19,4)
stock_plan_amount_data_rounding_rule	string
stock_plan_amount_data_use_target_currency	boolean
stock_plan_amount_data_target_amount	decimal(21,6)
stock_plan_amount_data_currency	string

compensation_stock_plan_amount_profile

列	データ型
compensation_plan_id	string
index	int
target_amount	decimal(26,6)
compensation_eligibility_rule_id	string
currency	string

列	データ型
compensation_plan_id	string
index	int
target_amount	decimal(26,6)
compensation_eligibility_rule_id	string
currency	string

compensation_stock_plan_grant

列	データ型
compensation_plan_id	string
index	int
grant_split_percent	decimal(10,4)
grant_type	string
stock_vesting_schedule	string
stock_date_rule	string
type	string

列	データ型
compensation_plan_id	string
index	int
grant_split_percent	decimal(10,4)
grant_type	string
stock_vesting_schedule	string
stock_date_rule	string
type	string

compensation_stock_plan_unit_profile

列	データ型
compensation_plan_id	string
index	int
target_shares	decimal(21,6)
compensation_eligibility_rule_id	string

列	データ型
compensation_plan_id	string
index	int
target_shares	decimal(21,6)
compensation_eligibility_rule_id	string

compensation_stock_profile_grant_split

列	データ型
compensation_plan_id	string
unit_profile_replacement_index	int
index	int
grant_split_percent	decimal(10,4)
grant_type	string
stock_vesting_schedule	string
stock_date_rule	string
type	string

列	データ型
compensation_plan_id	string
unit_profile_replacement_index	int
index	int
grant_split_percent	decimal(10,4)
grant_type	string
stock_vesting_schedule	string
stock_date_rule	string
type	string

deferred_compensation_eligibility_rule

列	データ型
compensation_plan_id	string
compensation_eligibility_rule_id	string

列	データ型
compensation_plan_id	string
compensation_eligibility_rule_id	string

報酬グレード

取り込みモード： 完全更新

宛先テーブル： 3

compensation_grade

列	データ型
id	string
compensation_grade_code	string
effective_date	date
name	string
description	string
number_of_segments	decimal(12,0)
minimum	decimal(21,6)
midpoint	decimal(21,6)
maximum	decimal(32,6)
spread	decimal(32,6)
segment_1_top	decimal(21,6)
segment_2_top	decimal(21,6)
segment_3_top	decimal(21,6)
segment_4_top	decimal(21,6)
segment_5_top	decimal(21,6)
currency_code	string
frequency_code	string
compensation_plan_id	string
is_override_allowed	boolean
is_first_step_during_compensation_proposal_assigned	boolean
pay_level	string
inactive	boolean

列	データ型
id	string
compensation_grade_code	string
effective_date	date
name	string
description	string
number_of_segments	decimal(12,0)
minimum	decimal(21,6)
midpoint	decimal(21,6)
maximum	decimal(32,6)
spread	decimal(32,6)
segment_1_top	decimal(21,6)
segment_2_top	decimal(21,6)
segment_3_top	decimal(21,6)
segment_4_top	decimal(21,6)
segment_5_top	decimal(21,6)
currency_code	string
frequency_code	string
compensation_plan_id	string
is_override_allowed	boolean
is_first_step_during_compensation_proposal_assigned	boolean
pay_level	string
inactive	boolean

compensation_grade_profile

列	データ型
compensation_grade_id	string
id	string
compensation_grade_profile_code	string
effective_date	date
name	string
description	string
inactive	boolean
number_of_segments	decimal(12,0)
minimum	decimal(21,6)
midpoint	decimal(21,6)
maximum	decimal(32,6)
spread	decimal(32,6)
segment_1_top	decimal(21,6)
segment_2_top	decimal(21,6)
segment_3_top	decimal(21,6)
segment_4_top	decimal(21,6)
segment_5_top	decimal(21,6)
currency_code	string
frequency_code	string
compensation_plan_id	string
is_override_allowed	boolean

列	データ型
compensation_grade_id	string
id	string
compensation_grade_profile_code	string
effective_date	date
name	string
description	string
inactive	boolean
number_of_segments	decimal(12,0)
minimum	decimal(21,6)
midpoint	decimal(21,6)
maximum	decimal(32,6)
spread	decimal(32,6)
segment_1_top	decimal(21,6)
segment_2_top	decimal(21,6)
segment_3_top	decimal(21,6)
segment_4_top	decimal(21,6)
segment_5_top	decimal(21,6)
currency_code	string
frequency_code	string
compensation_plan_id	string
is_override_allowed	boolean

compensation_step

列	データ型
compensation_grade_id	string
id	string
compensation_step_code	string
effective_date	date
sequence	string
name	string
amount	decimal(21,6)
interval	decimal(12,0)
progression_period_code	string
progression_rule_code	string

列	データ型
compensation_grade_id	string
id	string
compensation_step_code	string
effective_date	date
sequence	string
name	string
amount	decimal(21,6)
interval	decimal(12,0)
progression_period_code	string
progression_rule_code	string

欠勤入力

取り込みモード： 完全更新

宛先テーブル: 1

absence_input

列	データ型
id	string
absence_input_code	string
batch_code	string
worker_id	string
position_id	string
absence_component_code	string
start_date	date
end_date	date
reference_date	date
hours	decimal(18,6)
adjustment	boolean
comment	string

列	データ型
id	string
absence_input_code	string
batch_code	string
worker_id	string
position_id	string
absence_component_code	string
start_date	date
end_date	date
reference_date	date
hours	decimal(18,6)
adjustment	boolean
comment	string

残高のオーバーライド

取り込みモード： 完全更新

宛先テーブル: 1

override_balance

列	データ型
id	string
worker_id	string
batch_code	string
position_id	string
time_off_plan_code	string
override_balance_date	date
override_balance_units	decimal(18,6)
comments	string

列	データ型
id	string
worker_id	string
batch_code	string
position_id	string
time_off_plan_code	string
override_balance_date	date
override_balance_units	decimal(18,6)
comments	string

有給休暇プランの残高

取り込みモード： 完全更新

宛先テーブル： 2

time_off_plan_balance

列	データ型
worker_id	string
id	string
time_off_plan_code	string
time_off_plan_descriptor	string
unit_of_time_code	string

列	データ型
worker_id	string
id	string
time_off_plan_code	string
time_off_plan_descriptor	string
unit_of_time_code	string

time_off_plan_balance_position

列	データ型
time_off_plan_balance_id	string
worker_id	string
position_id	string
time_off_plan_balance	decimal(26,6)
index	int

列	データ型
time_off_plan_balance_id	string
worker_id	string
position_id	string
time_off_plan_balance	decimal(26,6)
index	int

接続プロパティ

Workday HCM に接続を作成する際は、以下のプロパティを指定する必要があります。これらの値を取得するには、Workday HCM への認証を構成するを参照してください。接続を作成するステップについては、「Workday HCM 接続を作成する」を参照してください。

属性	説明
クライアントID	Workday に登録された API クライアントからの OAuth クライアント ID。
クライアントのシークレット	Workday に登録された API クライアントからの OAuth クライアント シークレット。
更新する	統合システム ユーザー アカウント用に生成された OAuth 更新トークン。
テナント名	Workday テナント識別子。この値を見つけるには、Workday で [マイ アカウント] > [組織 ID] を選択します。
インスタンスURL	Workday インスタンスの URL (例: https://wd2-impl-services1.workday.com )。

属性	説明
クライアントID	Workday に登録された API クライアントからの OAuth クライアント ID。
クライアントのシークレット	Workday に登録された API クライアントからの OAuth クライアント シークレット。
更新する	統合システム ユーザー アカウント用に生成された OAuth 更新トークン。
テナント名	Workday テナント識別子。この値を見つけるには、Workday で [マイ アカウント] > [組織 ID] を選択します。
インスタンスURL	Workday インスタンスの URL (例: https://wd2-impl-services1.workday.com )。