# Leapsome schema ERD

Table and field reference for the Fivetran Leapsome connector.

## Table & Field Reference

### review_participant_manager

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| average_rating | Unknown |  |
| last_modified_on | Unknown |  |
| preferred_name | Unknown |  |

### review_participant_additional_manager

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| average_rating | Unknown |  |
| last_modified_on | Unknown |  |
| preferred_name | Unknown |  |

### review_participant_peer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| average_rating | Unknown |  |
| last_modified_on | Unknown |  |
| preferred_name | Unknown |  |

### review_participant_direct_report

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| average_rating | Unknown |  |
| last_modified_on | Unknown |  |
| preferred_name | Unknown |  |

### review_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| review_id | Unknown | FK |
| reviewee_user_id | Unknown | FK |
| last_modified_on | Instant |  |
| reviewee_average_rating | Unknown |  |
| reviewee_last_modified_on | Unknown |  |
| reviewee_preferred_name | Unknown |  |
| signature_manager | Instant |  |
| signature_reviewee | Instant |  |

### absence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| absence_end | Instant |  |
| absence_start | Instant |  |
| absence_type | Unknown |  |
| activity_type | Unknown |  |
| created_at | Instant |  |
| status | Unknown |  |
| time_unit | Unknown |  |
| updated_at | Instant |  |

### document_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### employee_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_cost_center

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_other_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_additional_compensation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_type | Unknown |  |
| comment | Unknown |  |
| effective_at | Instant |  |
| name | Unknown |  |
| recurrence | Unknown |  |
| valid_until | Instant |  |

### employee_additional_manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee_indirect_manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| compensation_currency | Unknown |  |
| compensation_frequency | Unknown |  |
| compensation_salary | Unknown |  |
| displayed_name | Unknown |  |
| email | Unknown |  |
| end_date | Instant |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_name | Unknown |  |
| level | Unknown |  |
| lifecycle_status | Unknown |  |
| manager_name | Unknown |  |
| middle_name | Unknown |  |
| phone | Unknown |  |
| start_date | Instant |  |
| status | Unknown |  |
| title | Unknown |  |
| work_location_id | Unknown |  |
| custom_attribute_** |  |  |

### work_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| administrative_division | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |
| remote | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| updated_at | Instant |  |
| zip | Unknown |  |

### payroll_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approval_start_at | Instant |  |
| approved_at | Instant |  |
| approved_by | Unknown |  |
| compensations_base_salary_custom_name | Unknown |  |
| compensations_compensable_time_custom_name | Unknown |  |
| compensations_hours_worked_custom_name | Unknown |  |
| compensations_paid_absences_custom_name | Unknown |  |
| compensations_salary_per_hour_custom_name | Unknown |  |
| compensations_salary_type_custom_name | Unknown |  |
| created_at | Instant |  |
| custom_period_end_at | Instant |  |
| custom_period_start_at | Instant |  |
| end_at | Instant |  |
| name | Unknown |  |
| prorate_type | Unknown |  |
| review_start_at | Instant |  |
| start_at | Instant |  |
| status | Unknown |  |
| updated_at | Instant |  |

### feedback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| receiver_id | Unknown | FK |
| sender_id | Unknown | FK |
| badge_icon | Unknown |  |
| badge_name | Unknown |  |
| comments_count | Unknown |  |
| created_at | Instant |  |
| likes_count | Unknown |  |
| message | Unknown |  |
| type | Unknown |  |
| visibility | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| kickoff_date | Instant |  |
| last_modified_on | Instant |  |
| name | Unknown |  |
| status | Unknown |  |
| template | Unknown |  |

### goal_key_result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| metric_current | Unknown |  |
| metric_end | Unknown |  |
| metric_start | Unknown |  |
| metric_type | Unknown |  |
| name | Unknown |  |
| weight | Unknown |  |

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contributor_id | Unknown | FK |
| managed_by_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| parent_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| deadline | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| progress | Unknown |  |
| progress_status | Unknown |  |
| status | Unknown |  |
| tag_id | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### time_tracking_timesheet_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| time_tracking_timesheet_id | Unknown | PK, FK |
| title | Unknown |  |

### time_tracking_timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| compensable_hour | Unknown |  |
| end_date | Instant |  |
| hours_worked | Unknown |  |
| overtime_hour | Unknown |  |
| start_date | Instant |  |
| status | Unknown |  |
| work_duration | Unknown |  |

### review_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| get_review_id | Unknown | PK, FK |
| name | Unknown |  |

### get_review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| timeline_conversations_deadline | Instant |  |
| timeline_manager_reviews_deadline | Instant |  |
| timeline_peer_approval_deadline | Instant |  |
| timeline_peer_nominations_deadline | Instant |  |
| timeline_peer_reviews_deadline | Instant |  |
| timeline_start | Instant |  |

### goal_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| sender_id | Unknown | FK |
| content | Unknown |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### payroll_cycle_participant_compensation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payroll_cycle_participant_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_type | Unknown |  |
| comment | Unknown |  |
| effective_at | Instant |  |
| name | Unknown |  |
| recurrence | Unknown |  |
| valid_until | Instant |  |

### payroll_cycle_participant_salary_info_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payroll_cycle_participant_id | Unknown | PK, FK |
| base_salary | Unknown |  |
| compensation_type | Unknown |  |
| currency | Unknown |  |
| salary | Unknown |  |
| salary_remuneration_period | Unknown |  |

### payroll_cycle_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payroll_cycle_id | Unknown | PK, FK |
| email | Unknown |  |
| is_active_participant | Unknown |  |

### goal_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_at | Instant |  |
| name | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

## Relationships

- review_participant_manager(user_id) → employee(id)
- review_participant_manager(review_participant_id) → review_participant(id)
- review_participant_additional_manager(user_id) → employee(id)
- review_participant_additional_manager(review_participant_id) → review_participant(id)
- review_participant_peer(user_id) → employee(id)
- review_participant_peer(review_participant_id) → review_participant(id)
- review_participant_direct_report(user_id) → employee(id)
- review_participant_direct_report(review_participant_id) → review_participant(id)
- review_participant(reviewee_user_id) → employee(id)
- review_participant(review_id) → review(id)
- absence(user_id) → employee(id)
- employee_team(employee_id) → employee(id)
- employee_department(employee_id) → employee(id)
- employee_business_unit(employee_id) → employee(id)
- employee_cost_center(employee_id) → employee(id)
- employee_division(employee_id) → employee(id)
- employee_other_group(employee_id) → employee(id)
- employee_additional_compensation(employee_id) → employee(id)
- employee_additional_manager(employee_id) → employee(id)
- employee_indirect_manager(employee_id) → employee(id)
- employee(manager_id) → employee(id)
- work_location(id) → employee(work_location_id)
- feedback(sender_id) → employee(id)
- feedback(receiver_id) → employee(id)
- goal_key_result(goal_id) → goal(id)
- goal(user_id) → employee(id)
- goal(owner_user_id) → employee(id)
- goal(contributor_id) → employee(id)
- goal(managed_by_id) → employee(id)
- goal(parent_id) → goal(id)
- time_tracking_timesheet_project(time_tracking_timesheet_id) → time_tracking_timesheet(id)
- time_tracking_timesheet(user_id) → employee(id)
- review_question(get_review_id) → get_review(id)
- get_review(id) → review(id)
- goal_comment(sender_id) → employee(id)
- goal_comment(goal_id) → goal(id)
- payroll_cycle_participant_compensation(payroll_cycle_participant_id) → payroll_cycle_participant(id)
- payroll_cycle_participant_salary_info_period(payroll_cycle_participant_id) → payroll_cycle_participant(id)
- payroll_cycle_participant(payroll_cycle_id) → payroll_cycle(id)
- goal_tag(id) → goal(tag_id)