Fivetran documentation

Search the docs

/

Personio

Explore the interactive ERD

Table & Field Reference

document_category

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`assigned_to_all`	Unknown
`billable`	Unknown
`client_name`	Unknown
`cost_center_id`	Unknown
`created_at`	Unknown
`description`	Unknown
`end_date`	Unknown
`name`	Unknown
`parent_project_id`	Unknown
`project_code`	Unknown
`project_type`	Unknown
`start_date`	Unknown
`status`	Unknown
`sub_projects_count`	Unknown
`sub_projects_tracked_minute`	Unknown
`tracked_minute`	Unknown
`tracked_periods_count`	Unknown
`updated_at`	Unknown

absence_entitlement

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`category`	Unknown
`entitlement`	Unknown
`name`	Unknown
`type`	Unknown

cost_center

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`name`	Unknown
`percentage`	Unknown
`type`	Unknown

employee

Column	Type	Keys
`id`	Unknown	PK
`supervisor_id`	Unknown	FK
`contract_end_date`	Unknown
`created_at`	Unknown
`department_id`	Unknown
`department_name`	Unknown
`email`	Unknown
`employment_type`	Unknown
`first_name`	Unknown
`fix_salary`	Unknown
`fix_salary_currency`	Unknown
`fix_salary_interval`	Unknown
`gender`	Unknown
`hire_date`	Unknown
`holiday_calendar_country`	Unknown
`holiday_calendar_id`	Unknown
`holiday_calendar_label`	Unknown
`holiday_calendar_name`	Unknown
`holiday_calendar_state`	Unknown
`hourly_salary`	Unknown
`hourly_salary_currency`	Unknown
`last_modified_at`	Unknown
`last_name`	Unknown
`last_working_day`	Unknown
`office_id`	Unknown
`office_name`	Unknown
`position`	Unknown
`probation_period_end`	Unknown
`profile_picture_url`	Unknown
`status`	Unknown
`subcompany_id`	Unknown
`subcompany_name`	Unknown
`team_id`	Unknown
`team_name`	Unknown
`termination_date`	Unknown
`termination_reason`	Unknown
`termination_type`	Unknown
`vacation_day_balance`	Unknown
`weekly_working_hours`	Unknown
`work_schedule_friday`	Unknown
`work_schedule_id`	Unknown
`work_schedule_monday`	Unknown
`work_schedule_name`	Unknown
`work_schedule_saturday`	Unknown
`work_schedule_sunday`	Unknown
`work_schedule_thursday`	Unknown
`work_schedule_tuesday`	Unknown
`work_schedule_type`	Unknown
`work_schedule_valid_from`	Unknown
`work_schedule_wednesday`	Unknown
`custom_`

time_off

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	FK
`time_off_type_id`	Unknown	FK
`certificate_status`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`days_count`	Unknown
`end_date`	Unknown
`half_day_end`	Unknown
`half_day_start`	Unknown
`start_date`	Unknown
`status`	Unknown
`updated_at`	Unknown

employee_absence_balance

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`balance`	Unknown
`category`	Json
`name`	Unknown

time_off_type

Column	Type	Keys
`id`	Unknown	PK
`approval_required`	Unknown
`category`	Unknown
`certification_required`	Unknown
`certification_submission_timeframe`	Unknown
`half_day_requests_enabled`	Unknown
`legacy_category`	Unknown
`name`	Unknown
`substitute_option`	Unknown
`unit`	Unknown

absence_period

Column	Type	Keys
`id`	Unknown	PK
`absence_type_id`	Unknown	FK
`employee_id`	Unknown	FK
`absence_type_name`	Unknown
`approved_at`	Unknown
`breakdowns`	Json
`certificate_status`	Unknown
`comment`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`effective_duration`	Unknown
`end_`	Unknown
`half_day_end`	Unknown
`half_day_start`	Unknown
`measurement_unit`	Unknown
`origin`	Unknown
`start`	Unknown
`status`	Unknown
`updated_at`	Unknown

report_column

Column	Type	Keys
`index`	Unknown	PK
`report_id`	Unknown	PKFK
`columns`	Unknown

report_filter

Column	Type	Keys
`index`	Unknown	PK
`report_id`	Unknown	PKFK
`columns`	Unknown
`comparison`	Unknown
`value`	Unknown

report_employee

Column	Type	Keys
`employee_id`	Unknown	PKFK
`report_id`	Unknown	PKFK

report

Column	Type	Keys
`id`	Unknown	PK
`author_first_name`	Unknown
`author_last_name`	Unknown
`created_at`	Unknown
`data_refreshed_at`	Unknown
`description`	Unknown
`end_date`	Unknown
`name`	Unknown
`period_type`	Unknown
`start_date`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown

report_employee_attribute_performance_target

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`employee_id`	Unknown
`performance_target`	Json

report_employee_attribute_text

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`employee_id`	Unknown
`value`	Unknown

report_employee_attribute_performance_kpi

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`employee_id`	Unknown
`performance_target_kpi`	Json

report_employee_attribute_entity

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`employee_id`	Unknown
`entity_id`	Unknown
`value`	Unknown

report_employee_attribute_absence_overview

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`duration_day`	Unknown
`duration_hour`	Unknown
`employee_id`	Unknown
`end_date`	Unknown
`start_date`	Unknown

report_employee_attribute_cost_center

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`cost_center`	Json
`employee_id`	Unknown

report_employee_attribute_absence_period

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`employee_id`	Unknown
`end_date`	Unknown
`half_day_at_end`	Unknown
`half_day_at_start`	Unknown
`start_date`	Unknown

report_employee_attribute_duration

Column	Type	Keys
`attribute_id`	Unknown	PK
`report_employee_employee_id`	Unknown	PKFK
`duration`	Unknown
`employee_id`	Unknown

compensation

Column	Type	Keys
`id`	Unknown	PK
`person_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`effective_from`	Unknown
`full_time_weekly_working_hours`	Unknown
`interval`	Unknown
`legal_entity_id`	Unknown
`type_category`	Unknown
`type_name`	Unknown
`weekly_working_hours`	Unknown

attendance

Column	Type	Keys
`id`	Unknown	PK
`person_id`	Unknown	FK
`project_id`	Unknown	FK
`attribution_date`	Unknown
`comment`	Unknown
`created_at`	Unknown
`end_date_time`	Unknown
`is_auto_generated`	Unknown
`start_date_time`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Instant