Zenefits
Explore the interactive ERD
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 | PKFK |
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 |