Référence du connecteur Workday HCM

info

Bêta

Cette fonctionnalité est en Bêta. Les administrateurs du Workspace peuvent contrôler l'accès à cette fonctionnalité à partir de la page Previews . Consultez Gérer les aperçus Databricks.

Cette page contient la documentation de référence pour le connecteur Workday HCM géré dans Lakeflow Connect.

Données prises en charge

Le connecteur prend en charge 137 tables de destination sélectionnables à partir de 20 objets Workday. Le tableau suivant regroupe les tables de destination par API source et indique leur mode d'ingestion. Toutes les tables de destination générées à partir de la même API partagent le mode d'ingestion indiqué pour cette API.

Objet Workday	Mode d’ingestion	Tables de destination
Workers	Incrémentiel	`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`
Origines ethniques	refresh complète	`ethnicity`
Identités de genre	refresh complète	`gender_identity`
Identification de personnes LGBT	refresh complète	`lgbt_identification`
Pronoms	refresh complète	`pronoun`
Orientations sexuelles	refresh complète	`sexual_orientation`
Organisations	refresh complète	`organization`, `organization_assignment`, `organization_leader`, `organization_role`, `organization_role_worker`
Profils de job	Incrémentiel	`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`
Postes	Incrémentiel	`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`
Candidates	refresh complète	`candidate`, `candidate_certification`, `candidate_education`, `candidate_experience`, `candidate_language`, `candidate_name`, `candidate_pool_membership`, `candidate_skill`, `candidate_tag`, `candidate_website`
Questionnaires	refresh complète	`questionnaire`, `questionnaire_setup`
Entretiens	refresh complète	`interview`, `interview_competency`, `interview_questionnaire`, `interview_session`, `interview_session_detail`, `interviewer`
Référence externe	refresh complète	`external_reference_line`, `external_reference_participant`, `questionnaire_answer`
Demandes de job	Incrémentiel	`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`
Résultats de paie	Incrémentiel	`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`
Plans de compensation	refresh complète	`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`
Grades de rémunération	refresh complète	`compensation_grade`, `compensation_grade_profile`, `compensation_step`
Absence d'entrées	refresh complète	`absence_input`
Remplacer les soldes	refresh complète	`override_balance`
Soldes de congés	refresh complète	`time_off_plan_balance`, `time_off_plan_balance_position`

Objet Workday	Mode d’ingestion	Tables de destination
Workers	Incrémentiel	`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`
Origines ethniques	refresh complète	`ethnicity`
Identités de genre	refresh complète	`gender_identity`
Identification de personnes LGBT	refresh complète	`lgbt_identification`
Pronoms	refresh complète	`pronoun`
Orientations sexuelles	refresh complète	`sexual_orientation`
Organisations	refresh complète	`organization`, `organization_assignment`, `organization_leader`, `organization_role`, `organization_role_worker`
Profils de job	Incrémentiel	`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`
Postes	Incrémentiel	`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`
Candidates	refresh complète	`candidate`, `candidate_certification`, `candidate_education`, `candidate_experience`, `candidate_language`, `candidate_name`, `candidate_pool_membership`, `candidate_skill`, `candidate_tag`, `candidate_website`
Questionnaires	refresh complète	`questionnaire`, `questionnaire_setup`
Entretiens	refresh complète	`interview`, `interview_competency`, `interview_questionnaire`, `interview_session`, `interview_session_detail`, `interviewer`
Référence externe	refresh complète	`external_reference_line`, `external_reference_participant`, `questionnaire_answer`
Demandes de job	Incrémentiel	`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`
Résultats de paie	Incrémentiel	`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`
Plans de compensation	refresh complète	`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`
Grades de rémunération	refresh complète	`compensation_grade`, `compensation_grade_profile`, `compensation_step`
Absence d'entrées	refresh complète	`absence_input`
Remplacer les soldes	refresh complète	`override_balance`
Soldes de congés	refresh complète	`time_off_plan_balance`, `time_off_plan_balance_position`

Transformations automatisées

Les APIs Workday Object renvoient des réponses profondément imbriquées. Databricks ingère chaque réponse dans une table de staging brute interne et la transforme automatiquement en une ou plusieurs tables de destination aplaties. Vous sélectionnez les tables de destination aplaties répertoriées sur cette page. Le connecteur n'expose pas les tables de staging brutes internes en tant que tables sources sélectionnables.

Schémas de tables de destination

Les sections suivantes répertorient les colonnes de chaque table de destination sélectionnable. Les types de données utilisent la notation Databricks SQL. Les types composites utilisent des formulaires tels que array<string> et struct<field: string>.

Worker

Ingestion mode: Incremental

Tables de destination : 12

`worker_collective_agreement`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`worker_id`	`string`
`position_id`	`string`
`workers_compensation_code`	`string`

`worker_position_end_employment_reason`

Colonne	Type de données
`worker_id`	`string`
`position_id`	`string`
`end_employment_reason`	`string`
`end_employment_date`	`date`

`worker_position_job_classification`

Colonne	Type de données
`worker_id`	`string`
`position_id`	`string`
`job_classification_id`	`string`
`job_group_code`	`string`

`worker_position_manager`

Colonne	Type de données
`worker_id`	`string`
`position_id`	`string`
`manager_id`	`array<string>`

`worker_position_organization`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`worker_id`	`string`
`position_id`	`string`
`payroll_reporting_id`	`string`
`payroll_reporting_code`	`string`
`formatted_code`	`string`
`payroll_reporting_type`	`string`

`worker_positions`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`worker_id`	`string`
`secondary_reason`	`string`
`reason_category`	`string`
`index`	`int`

`workers`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Ethnies

Mode d’ingestion : refresh

Tables de destination : 1

`ethnicity`

Colonne	Type de données
`id`	`string`
`ethnicity_id`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`
`location_id`	`string`
`ethnicity_mapping_id`	`string`

Identités de genre

Mode d’ingestion : refresh

Tables de destination : 1

`gender_identity`

Colonne	Type de données
`id`	`string`
`gender_identity_id`	`string`
`order`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

Identifications LGBT

Mode d’ingestion : refresh

Tables de destination : 1

`lgbt_identification`

Colonne	Type de données
`id`	`string`
`lgbt_identification_id`	`string`
`name`	`string`
`description`	`string`
`inactive`	`boolean`
`location_id`	`string`

Pronoms

Mode d’ingestion : refresh

Tables de destination : 1

`pronoun`

Colonne	Type de données
`id`	`string`
`pronoun_id`	`string`
`order`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

Orientations sexuelles

Mode d’ingestion : refresh

Tables de destination : 1

`sexual_orientation`

Colonne	Type de données
`id`	`string`
`sexual_orientation_id`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

Organisations

Mode d’ingestion : refresh

Tables de destination : 5

`organization`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`organization_id`	`string`
`reference_organization_id`	`string`
`reference_organization_type`	`string`

`organization_leader`

Colonne	Type de données
`organization_id`	`string`
`organization_manager_id`	`string`

`organization_role`

Colonne	Type de données
`organization_id`	`string`
`role_id`	`string`
`organization_role_code`	`string`

`organization_role_worker`

Colonne	Type de données
`organization_id`	`string`
`role_id`	`string`
`associated_worker_id`	`string`

Profils de job

Ingestion mode: Incremental

Tables de destination : 17

`job_family_job_profile`

Colonne	Type de données
`job_profile_id`	`string`
`job_family_id`	`string`

`job_profile`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_profile_id`	`string`
`certification_code`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`country_code`	`string`
`index`	`int`

`job_profile_classification`

Colonne	Type de données
`job_profile_id`	`string`
`job_classification_id`	`string`

`job_profile_company_insider`

Colonne	Type de données
`job_profile_id`	`string`
`company_insider_type`	`string`
`index`	`int`

`job_profile_competency`

Colonne	Type de données
`job_profile_id`	`string`
`competency_id`	`string`
`competency_code`	`string`
`required`	`boolean`
`proficiency_rating`	`string`

`job_profile_education`

Colonne	Type de données
`job_profile_id`	`string`
`required`	`boolean`
`degree_code`	`string`
`field_of_study`	`string`
`index`	`int`

`job_profile_exempt`

Colonne	Type de données
`job_profile_id`	`string`
`is_job_exempt`	`boolean`
`location_context`	`string`
`index`	`int`

`job_profile_language`

Colonne	Type de données
`job_profile_id`	`string`
`language_id`	`string`
`language_code`	`string`
`required`	`boolean`

`job_profile_language_ability`

Colonne	Type de données
`job_profile_id`	`string`
`language_id`	`string`
`language_ability_type_code`	`string`
`language_proficiency_code`	`string`
`index`	`int`

`job_profile_pay_rate`

Colonne	Type de données
`job_profile_id`	`string`
`country_code`	`string`
`pay_rate_code`	`string`
`index`	`int`

`job_profile_responsibility`

Colonne	Type de données
`job_profile_id`	`string`
`description`	`string`
`required`	`boolean`
`index`	`int`

`job_profile_restrict_to_country`

Colonne	Type de données
`job_profile_id`	`string`
`country_id`	`string`
`country_code`	`string`

`job_profile_skill`

Colonne	Type de données
`job_profile_id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`index`	`int`

`job_profile_training`

Colonne	Type de données
`job_profile_id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`index`	`int`

`job_profile_work_experience`

Colonne	Type de données
`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`

Colonne	Type de données
`job_profile_id`	`string`
`worker_compensation_code`	`string`
`index`	`int`

Postes

Ingestion mode: Incremental

Tables de destination : 18

`position`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`certification_code`	`string`
`country`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_competency`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`required`	`boolean`
`competency_code`	`string`
`proficiency_rating`	`string`
`qualification_source`	`string`

`position_education`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`required`	`boolean`
`degree`	`string`
`field_of_study`	`string`
`qualification_source`	`string`

`position_job_family`

Colonne	Type de données
`position_id`	`string`
`job_family_id`	`string`

`position_job_profile`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`language_code`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_location`

Colonne	Type de données
`position_id`	`string`
`location_id`	`string`
`location_code`	`string`

`position_merit_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`position_id`	`string`
`organization_id`	`string`
`type`	`string`

`position_pay_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`responsibility`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_skill`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_stock_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`qualification_source`	`string`

`position_work_experience`

Colonne	Type de données
`position_id`	`string`
`id`	`string`
`work_experience_code`	`string`
`required`	`boolean`
`work_experience_rating`	`string`
`qualification_source`	`string`

`position_worker_type_restriction`

Colonne	Type de données
`position_id`	`string`
`worker_type_id`	`string`
`worker_type_code`	`string`

Candidats

Mode d’ingestion : refresh

Tables de destination : 10

`candidate`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_application_id`	`string`
`language_code`	`string`
`index`	`int`

`candidate_name`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`candidate_id`	`string`
`candidate_pool_id`	`string`
`candidate_pool_code`	`string`
`readiness_status_id`	`string`
`readiness_status_code`	`string`

`candidate_skill`

Colonne	Type de données
`job_application_id`	`string`
`skill_code`	`string`
`skill_name`	`string`
`index`	`int`

`candidate_tag`

Colonne	Type de données
`candidate_id`	`string`
`tag_code`	`string`
`index`	`int`

`candidate_website`

Colonne	Type de données
`candidate_id`	`string`
`url`	`string`
`index`	`int`

Questionnaires

Mode d’ingestion : refresh

Destination tables : 2

`questionnaire`

Colonne	Type de données
`id`	`string`
`questionnaire_code`	`string`
`name`	`string`
`display_name`	`string`
`instructions`	`string`
`inactive`	`boolean`

`questionnaire_setup`

Colonne	Type de données
`questionnaire_id`	`string`
`questionnaire_setup_id`	`string`
`question_description`	`string`
`order`	`string`
`required`	`boolean`

Entretiens

Mode d’ingestion : refresh

Tables de destination : 6

`interview`

Colonne	Type de données
`id`	`string`
`overall_comment`	`string`
`time_zone_code`	`string`

`interview_competency`

Colonne	Type de données
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`competency_id`	`string`
`competency_code`	`string`

`interview_questionnaire`

Colonne	Type de données
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`questionnaire_id`	`string`

`interview_session`

Colonne	Type de données
`interview_id`	`string`
`interview_session_id`	`string`
`interview_session_code`	`string`

`interview_session_detail`

Colonne	Type de données
`interview_session_id`	`string`
`interview_start_time`	`timestamp`
`interview_end_time`	`timestamp`
`location_code`	`string`
`interview_type_code`	`string`
`comment`	`string`
`index`	`int`

`interviewer`

Colonne	Type de données
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`interviewer_id`	`string`

Référence externe

Mode d’ingestion : refresh

Tables de destination : 3

`external_reference_line`

Colonne	Type de données
`id`	`string`
`job_application_id`	`string`
`candidate_id`	`string`
`job_requisition_id`	`string`

`external_reference_participant`

Colonne	Type de données
`external_reference_id`	`string`
`referee_id`	`string`
`referee_code`	`string`
`questionnaire_id`	`string`

`questionnaire_answer`

Colonne	Type de données
`reference_id`	`string`
`question_order`	`string`
`date`	`date`
`answer_numeric`	`decimal(12,0)`
`answer_text`	`string`
`index`	`int`

Demandes de job

Ingestion mode: Incremental

Tables de destination : 28

`job_requisition`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`location_id`	`string`
`location_code`	`string`

`job_requisition_additional_job_profile`

Colonne	Type de données
`job_requisition_id`	`string`
`job_profile_id`	`string`

`job_requisition_additional_location`

Colonne	Type de données
`job_requisition_id`	`string`
`location_id`	`string`
`location_code`	`string`

`job_requisition_allowance_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`certification_code`	`string`
`country`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_commission_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`required`	`boolean`
`competency_code`	`string`
`proficiency_rating`	`string`
`qualification_source`	`string`

`job_requisition_custom_organization`

Colonne	Type de données
`job_requisition_id`	`string`
`custom_organization_id`	`string`

`job_requisition_default_assessment_test`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`default_assessment_test_code`	`string`

`job_requisition_education`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`required`	`boolean`
`degree`	`string`
`field_of_study`	`string`
`qualification_source`	`string`

`job_requisition_language`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`language_code`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_language_ability`

Colonne	Type de données
`job_requisition_language_id`	`string`
`language_ability_type`	`string`
`language_proficiency`	`string`
`index`	`int`

`job_requisition_merit_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`position_id`	`string`

`job_requisition_responsibility`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`responsibility`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_skill`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_stock_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`qualification_source`	`string`

`job_requisition_unit_allowance_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`job_requisition_id`	`string`
`id`	`string`
`work_experience_code`	`string`
`required`	`boolean`
`work_experience_rating`	`string`
`qualification_source`	`string`

Résultats de paie

Ingestion mode: Incremental

Tables de destination : 9

`payroll_line`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`payroll_id`	`string`
`payroll_line_index`	`int`
`earning`	`string`
`deduction`	`string`
`index`	`int`

`payroll_line_related_calculation`

Colonne	Type de données
`payroll_id`	`string`
`payroll_line_index`	`int`
`amount`	`decimal(26,6)`
`calculation_code`	`string`
`workday_calculation_code`	`string`
`index`	`int`

`payroll_line_withholding`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_local_city_authority_tax_code`	`string`

`payroll_local_county_authority_tax_worktag`

Colonne	Type de données
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_local_county_authority_tax_code`	`string`

`payroll_national_id`

Colonne	Type de données
`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`

Colonne	Type de données
`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)`

Colonne	Type de données
`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`

Colonne	Type de données
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_state_authority_tax_code`	`string`

Plans de rémunération

Mode d’ingestion : refresh

Tables de destination : 15

`compensation_allowance_plan_amount_profile`

Colonne	Type de données
`compensation_plan_id`	`string`
`amount`	`decimal(26,6)`
`currency`	`string`
`compensation_eligibility_rule_id`	`string`
`index`	`int`

`compensation_allowance_plan_percent_profile`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`compensation_plan_id`	`string`
`compensation_eligibility_rule_id`	`string`

`compensation_bonus_plan_performance_factor_scorecard`

Colonne	Type de données
`compensation_plan_id`	`string`
`id`	`string`
`performance_scorecard_code`	`string`
`weight`	`decimal(10,4)`
`bonus_modifier`	`string`

`compensation_bonus_plan_replacement_percent`

Colonne	Type de données
`compensation_plan_id`	`string`
`percentage`	`decimal(16,4)`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

`compensation_bonus_tranche`

Colonne	Type de données
`compensation_plan_id`	`string`
`name`	`decimal(12,0)`
`percentage`	`decimal(18,6)`

`compensation_commission_plan_profile`

Colonne	Type de données
`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`

Colonne	Type de données
`compensation_plan_id`	`string`
`bonus_plan_id`	`string`

`compensation_merit_plan_replacement_percent`

Colonne	Type de données
`compensation_plan_id`	`string`
`percentage`	`decimal(18,6)`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

`compensation_plan`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`compensation_plan_id`	`string`
`index`	`int`
`target_amount`	`decimal(26,6)`
`compensation_eligibility_rule_id`	`string`
`currency`	`string`

`compensation_stock_plan_grant`

Colonne	Type de données
`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`

Colonne	Type de données
`compensation_plan_id`	`string`
`index`	`int`
`target_shares`	`decimal(21,6)`
`compensation_eligibility_rule_id`	`string`

`compensation_stock_profile_grant_split`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`compensation_plan_id`	`string`
`compensation_eligibility_rule_id`	`string`

Échelles de rémunération

Mode d’ingestion : refresh

Tables de destination : 3

`compensation_grade`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Absence d'entrées

Mode d’ingestion : refresh

Tables de destination : 1

`absence_input`

Colonne	Type de données
`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`

Colonne	Type de données
`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`

Remplacer les soldes

Mode d’ingestion : refresh

Tables de destination : 1

`override_balance`

Colonne	Type de données
`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`

Soldes des plans de congé

Mode d’ingestion : refresh

Destination tables : 2

`time_off_plan_balance`

Colonne	Type de données
`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`

Colonne	Type de données
`time_off_plan_balance_id`	`string`
`worker_id`	`string`
`position_id`	`string`
`time_off_plan_balance`	`decimal(26,6)`
`index`	`int`

Propriétés de connexion

Lorsque vous créez une connexion à Workday HCM, vous devez fournir les propriétés suivantes. Pour récupérer ces valeurs, consultez Configurer l’authentification auprès de Workday HCM. Pour connaître les étapes de création de la connexion, consultez Créer une connexion Workday HCM.

Propriété	Description
ID client	L'ID client OAuth du client API enregistré dans Workday.
Secret du client	Le secret client OAuth issu du client API enregistré dans Workday.
Refresh Token	Le jeton OAuth refresh généré pour le compte utilisateur du système d'intégration.
Nom du tenant	Votre identifiant de tenant Workday. Pour trouver cette valeur, sélectionnez Mon compte > Identifiant de l'organisation dans Workday.
URL de l'instance	L'URL de votre instance Workday (par exemple, `https://wd2-impl-services1.workday.com`).

Propriété	Description
ID client	L'ID client OAuth du client API enregistré dans Workday.
Secret du client	Le secret client OAuth issu du client API enregistré dans Workday.
Refresh Token	Le jeton OAuth refresh généré pour le compte utilisateur du système d'intégration.
Nom du tenant	Votre identifiant de tenant Workday. Pour trouver cette valeur, sélectionnez Mon compte > Identifiant de l'organisation dans Workday.
URL de l'instance	L'URL de votre instance Workday (par exemple, `https://wd2-impl-services1.workday.com`).

Sur cette page

Données prises en charge
Transformations automatisées
Schémas de tables de destination
Worker
- 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
Ethnies
- ethnicity
Identités de genre
- gender_identity
Identifications LGBT
- lgbt_identification
Pronoms
- pronoun
Orientations sexuelles
- sexual_orientation
Organisations
- organization
- organization_assignment
- organization_leader
- organization_role
- organization_role_worker
Profils de job
- 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
Postes
- 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
Candidats
- candidate
- candidate_certification
- candidate_education
- candidate_experience
- candidate_language
- candidate_name
- candidate_pool_membership
- candidate_skill
- candidate_tag
- candidate_website
Questionnaires
- questionnaire
- questionnaire_setup
Entretiens
- interview
- interview_competency
- interview_questionnaire
- interview_session
- interview_session_detail
- interviewer
Référence externe
- external_reference_line
- external_reference_participant
- questionnaire_answer
Demandes de job
- 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
Résultats de paie
- 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
Plans de rémunération
- 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
Échelles de rémunération
- compensation_grade
- compensation_grade_profile
- compensation_step
Absence d'entrées
- absence_input
Remplacer les soldes
- override_balance
Soldes des plans de congé
- time_off_plan_balance
- time_off_plan_balance_position
Propriétés de connexion

Données prises en charge​

Transformations automatisées​

Schémas de tables de destination​

Worker​

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​

Ethnies​

ethnicity​

Identités de genre​

gender_identity​

Identifications LGBT​

lgbt_identification​

Pronoms​

pronoun​

Orientations sexuelles​

sexual_orientation​

Organisations​

organization​

organization_assignment​

organization_leader​

organization_role​

organization_role_worker​

Profils de job​

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​

Postes​

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​

Candidats​

candidate​

candidate_certification​

candidate_education​

candidate_experience​

candidate_language​

candidate_name​

candidate_pool_membership​

candidate_skill​

candidate_tag​

candidate_website​

Données prises en charge

Transformations automatisées

Schémas de tables de destination

Worker

`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`

Ethnies

`ethnicity`

Identités de genre

`gender_identity`

Identifications LGBT

`lgbt_identification`

Pronoms

`pronoun`

Orientations sexuelles

`sexual_orientation`

Organisations

`organization`

`organization_assignment`

`organization_leader`

`organization_role`

`organization_role_worker`

Profils de job

`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`

Postes

`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`

Candidats

`candidate`

`candidate_certification`

`candidate_education`

`candidate_experience`

`candidate_language`

`candidate_name`

`candidate_pool_membership`

`candidate_skill`

`candidate_tag`

`candidate_website`