Fivetran documentation

Search the docs

/

Bamboo HR

Explore the interactive ERD

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	PKFK
`goal_id`	Int	PKFK

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	PKFK
`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	PKFK
`policy_id`	Int	PKFK
`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	PKFK
`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