Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
LABOR_GROUP_DATA ⇱
index 🔑
labor_group_id 🔑 ▶ LABOR_GROUP
url ▶ PEOPLE.url
is_primary
LABOR_GROUP ⇱
id 🔑
labor_group_type_id ▶ LABOR_GROUP_TYPE
labor_group_type_url ▶ LABOR_GROUP_TYPE.url
code
name
url
COMPANY_BANK_ACCOUNT ⇱
id 🔑
company_id ▶ COMPANY
company_url ▶ COMPANY.url
account_number
account_type
bank_name
routing_number
DEPARTMENT ⇱
id 🔑
company_id ▶ COMPANY
company_url ▶ COMPANY.url
name
url
CUSTOM_FIELD ⇱
id 🔑
company_url ▶ COMPANY.url
can_manager_view_field
can_person_edit_field
can_person_view_field
company_during_hiring
custom_field_type
help_text
help_url
help_url_media
is_field_completer_person
is_field_required
is_sensitive
media_file_type
name
object
person_during_onboarding
url
TIME_DURATION ⇱
id 🔑
approver_url ▶ PEOPLE.url
person_url ▶ PEOPLE.url
activity
approved_date_time
date
end_date
hours
is_approved
is_overnight
labor_group_ids
start_date
state
valid_status
LABOR_GROUP_TYPE ⇱
id 🔑
company_url ▶ COMPANY.url
name
url
VACATION_TYPE ⇱
id 🔑
company_url ▶ COMPANY.url
counts_as
name
status
url
COMPANY ⇱
id 🔑
ein
company_banks_url
departments_url
legal_city
legal_name
legal_state
legal_street_1
legal_street_2
legal_zip
Logo_url
locations_url
name
Object
people_url
url
CUSTOM_FIELD_VALUE ⇱
id 🔑
custom_field_url ▶ CUSTOM_FIELD.url
people_id ▶ PEOPLE
person_url ▶ PEOPLE.url
url
value
PEOPLE ⇱
id 🔑
company_id ▶ COMPANY
company_url ▶ COMPANY.url
department_url ▶ DEPARTMENT.url
location_url ▶ LOCATIONS.url
manager_url ▶ PEOPLE.url
bank_url
city
country
date_of_birth
employee_number
federal_filing_status
first_name
gender
is_admin
is_full_admin
last_name
middle_name
personal_pronoun
personal_email
personal_phone
photo_url
photo_thumbnail_url
postal_code
preferred_name
social_security_number
state
status
street_1
street_2
subordinates_url
title
type
url
work_email
work_phone
VACATION_REQUEST ⇱
id 🔑
creator_url ▶ PEOPLE.url
person_url ▶ PEOPLE.url
vacation_type_url ▶ VACATION_TYPE.url
approved_date
created_date
deny_reason
end_date
hours
reason
start_date
status
url
EMPLOYMENT ⇱
id 🔑
people_id ▶ PEOPLE
person_url ▶ PEOPLE.url
amount_type
annual_salary
comp_type
employment_sub_type
employment_type
hire_date
is_active
is_flsa_exempt
pay_rate
termination_date
termination_type
working_hours_per_week
EMP_BANK_ACCOUNT ⇱
id 🔑
people_id ▶ PEOPLE
account_number
account_type
amount_per_paycheck
bank_name
is_primary_account
is_salary_account
percentage_per_paycheck
priority
routing_number
LOCATIONS ⇱
id 🔑
company_id ▶ COMPANY
company_url ▶ COMPANY.url
labor_group_url ▶ LABOR_GROUP.url
city
country
name
phone
state
street_1
street_2
url
zip