# Zenefits schema ERD

Table and field reference for the Fivetran Zenefits connector.

## Table & Field Reference

### locations

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| company_url | Unknown | FK |
| labor_group_url | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| name | Unknown |  |
| people_url | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| url | Unknown |  |
| zip | Unknown |  |

### labor_group_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| labor_group_id | Unknown | PK, FK |
| url | Unknown | FK |
| is_primary | Unknown |  |

### labor_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| labor_group_type_id | Unknown | FK |
| labor_group_type_url | Unknown | FK |
| code | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| company_url | Unknown | FK |
| labor_group_url | Unknown |  |
| name | Unknown |  |
| people_url | Unknown |  |
| url | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_url | Unknown | FK |
| can_manager_view_field | Unknown |  |
| can_person_edit_field | Unknown |  |
| can_person_view_field | Unknown |  |
| company_during_hiring | Unknown |  |
| custom_field_type | Unknown |  |
| custom_field_values_url | Unknown |  |
| help_text | Unknown |  |
| help_url | Unknown |  |
| help_url_media | Unknown |  |
| is_field_completer_person | Unknown |  |
| is_field_required | Unknown |  |
| is_sensitive | Unknown |  |
| media_file_type | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| person_during_onboarding | Unknown |  |
| url | Unknown |  |

### time_duration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approver_url | Unknown | FK |
| person_url | Unknown | FK |
| activity | Unknown |  |
| approved_date_time | Unknown |  |
| date | Unknown |  |
| end_date | Unknown |  |
| hours | Unknown |  |
| is_approved | Unknown |  |
| is_overnight | Unknown |  |
| labor_group_ids | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| valid_status | Unknown |  |

### labor_group_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_url | Unknown | FK |
| labor_groups_url | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### vacation_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_url | Unknown | FK |
| counts_as | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |
| vacation_requests_url | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_banks_url | Unknown |  |
| departments_url | Unknown |  |
| ein | Unknown |  |
| legal_city | Unknown |  |
| legal_name | Unknown |  |
| legal_state | Unknown |  |
| legal_street_1 | Unknown |  |
| legal_street_2 | Unknown |  |
| legal_zips | Unknown |  |
| locations_url | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| people_url | Unknown |  |
| url | Unknown |  |

### company_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| company_url | Unknown | FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| bank_name | Unknown |  |
| routing_number | Unknown |  |

### emp_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| people_id | Unknown | FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| amount_per_paycheck | Unknown |  |
| bank_name | Unknown |  |
| is_primary_account | Unknown |  |
| is_salary_account | Unknown |  |
| percentage_per_paycheck | Unknown |  |
| priority | Unknown |  |
| routing_number | Unknown |  |

### custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_field_url | Unknown | FK |
| people_id | Unknown | FK |
| person_url | Unknown | FK |
| url | Unknown |  |
| value | Unknown |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| company_url | Unknown | FK |
| department_url | Unknown | FK |
| location_url | Unknown | FK |
| manager_url | Unknown | FK |
| bank_url | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| date_of_birth | Unknown |  |
| employee_number | Unknown |  |
| federal_filing_status | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| is_admin | Unknown |  |
| is_full_admin | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| personal_email | Unknown |  |
| personal_phone | Unknown |  |
| personal_pronoun | Unknown |  |
| photo_thumbnail_url | Unknown |  |
| photo_url | Unknown |  |
| postal_code | Unknown |  |
| preferred_name | Unknown |  |
| social_security_number | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| subordinates_url | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| work_email | Unknown |  |
| work_phone | Unknown |  |

### vacation_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_url | Unknown | FK |
| person_url | Unknown | FK |
| vacation_type_url | Unknown | FK |
| approved_date | Unknown |  |
| created_date | Unknown |  |
| deny_reason | Unknown |  |
| end_date | Unknown |  |
| hours | Unknown |  |
| reason | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| people_id | Unknown | FK |
| person_url | Unknown | FK |
| amount_type | Unknown |  |
| annual_salary | Unknown |  |
| comp_type | Unknown |  |
| employment_sub_type | Unknown |  |
| employment_type | Unknown |  |
| hire_date | Unknown |  |
| is_active | Unknown |  |
| is_flsa_exempt | Unknown |  |
| pay_rate | Unknown |  |
| termination_date | Unknown |  |
| termination_type | Unknown |  |
| working_hours_per_week | Unknown |  |

## Relationships

- locations(company_url) → company(url)
- locations(labor_group_url) → labor_group(url)
- locations(company_id) → company(id)
- labor_group_data(url) → people(url)
- labor_group_data(labor_group_id) → labor_group(id)
- labor_group(labor_group_type_url) → labor_group_type(url)
- labor_group(labor_group_type_id) → labor_group_type(id)
- department(company_url) → company(url)
- department(company_id) → company(id)
- custom_field(company_url) → company(url)
- time_duration(approver_url) → people(url)
- time_duration(person_url) → people(url)
- labor_group_type(company_url) → company(url)
- vacation_type(company_url) → company(url)
- company_bank_account(company_url) → company(url)
- company_bank_account(company_id) → company(id)
- emp_bank_account(people_id) → people(id)
- custom_field_value(person_url) → people(url)
- custom_field_value(custom_field_url) → custom_field(url)
- custom_field_value(people_id) → people(id)
- people(location_url) → locations(url)
- people(company_url) → company(url)
- people(manager_url) → people(url)
- people(department_url) → department(url)
- people(company_id) → company(id)
- vacation_request(vacation_type_url) → vacation_type(url)
- vacation_request(creator_url) → people(url)
- vacation_request(person_url) → people(url)
- employment(person_url) → people(url)
- employment(people_id) → people(id)