# Bamboo HR schema ERD

Table and field reference for the Fivetran Bamboo HR connector.

## Table & Field Reference

### job_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| hiring_lead_employee_id | Int | FK |
| active_applicants_count | Int |  |
| department_id | Int |  |
| department_label | String |  |
| location_id | Int |  |
| location_label | String |  |
| new_applicants_count | Int |  |
| posted_date | Instant |  |
| posting_url | String |  |
| status_id | Int |  |
| status_label | String |  |
| title_id | Int |  |
| title_label | String |  |
| total_applicants_count | Int |  |

### employee_goal

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Int | PK, FK |
| goal_id | Int | PK, FK |

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| completed_at | Instant |  |
| description | String |  |
| due_date | LocalDate |  |
| percent_complete | Int |  |
| status | String |  |
| title | String |  |

### applicant

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| email | String |  |
| first_name | String |  |
| last_name | String |  |
| source | String |  |

### time_off_request_date

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| time_off_request_id | Int | PK, FK |
| amount | Float |  |

### time_off_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| type_id | Int | FK |
| effective_date | LocalDate |  |
| name | String |  |
| type | String |  |

### training_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |

### employee_time_off_policy

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Int | PK, FK |
| policy_id | Int | PK, FK |
| accrual_start_date | LocalDate |  |

### account_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| employee_id | Int | FK |
| email | String |  |
| first_name | String |  |
| last_login | Instant |  |
| last_name | String |  |
| status | String |  |

### time_off_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| employee_id | Int | FK |
| amount | Float |  |
| created_at | LocalDate |  |
| end_date | LocalDate |  |
| name | String |  |
| notes_employee | String |  |
| notes_manager | String |  |
| start_date | LocalDate |  |
| status | String |  |
| status_changed_at | LocalDate |  |
| status_changed_by | Int |  |
| type_id | Int |  |
| unit | String |  |

### time_off_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |
| units | String |  |

### employee_dependent

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| employee_id | Int | FK |
| address_line_1 | String |  |
| address_line_2 | String |  |
| city | String |  |
| country | String |  |
| date_of_birth | LocalDate |  |
| first_name | String |  |
| gender | String |  |
| is_student | String |  |
| is_us_citizen | String |  |
| last_name | String |  |
| masked_sin | String |  |
| masked_ssn | String |  |
| middle_name | String |  |
| relationship | String |  |
| state | String |  |
| zip_code | String |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| last_changed | Instant |  |

### milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| goal_id | Int | PK, FK |
| completed_at | Instant |  |
| current_value | Int |  |
| end_value | Int |  |
| start_value | Int |  |
| title | String |  |
| updated_at | Instant |  |
| updated_by | Int |  |

### training

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| employee_id | Int | FK |
| type_id | Int | FK |
| completed_at | LocalDate |  |
| cost | String |  |
| credits | Float |  |
| hours | Float |  |
| instructor | String |  |
| notes | String |  |

### training_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| category_id | Int | FK |
| description | String |  |
| due_from_hire_date_amount | Float |  |
| due_from_hire_date_unit | String |  |
| frequency | Int |  |
| link_url | String |  |
| name | String |  |
| renewable | Boolean |  |
| required | Boolean |  |

### job_application

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| applicant_id | Int | FK |
| job_id | Int | FK |
| applied_date | Instant |  |
| rating | Int |  |
| status_id | Int |  |
| status_label | String |  |

### timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| employee_id | Int | FK |
| approved | Boolean |  |
| approved_at | Instant |  |
| created_at | Instant |  |
| date | LocalDate |  |
| end_at | Instant |  |
| hours | Float |  |
| note | String |  |
| project_id | Int |  |
| start_at | Instant |  |
| task_id | Int |  |
| timezone | String |  |
| type | String |  |
| updated_at | Instant |  |

## Relationships

- job_summary(hiring_lead_employee_id) → employee(id)
- employee_goal(employee_id) → employee(id)
- employee_goal(goal_id) → goal(id)
- time_off_request_date(time_off_request_id) → time_off_request(id)
- time_off_policy(type_id) → time_off_type(id)
- employee_time_off_policy(employee_id) → employee(id)
- employee_time_off_policy(policy_id) → time_off_policy(id)
- account_user(employee_id) → employee(id)
- time_off_request(employee_id) → employee(id)
- employee_dependent(employee_id) → employee(id)
- milestone(goal_id) → goal(id)
- training(employee_id) → employee(id)
- training(type_id) → training_type(id)
- training_type(category_id) → training_category(id)
- job_application(job_id) → job_summary(id)
- job_application(applicant_id) → applicant(id)
- timesheet(employee_id) → employee(id)