DoorLoop
Explore the interactive ERD
Table & Field Reference
vendor_bill_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_bill_id | Unknown | PKFK |
account_id | Unknown | FK |
linked_resource_id | Unknown | FK |
property_id | Unknown | FK |
unit_id | Unknown | FK |
amount | Unknown | |
balance | Unknown | |
memo | Unknown |
vendor_bill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
vendor_id | Unknown | FK |
batch | Unknown | |
created_at | Unknown | |
date | Unknown | |
due_date | Unknown | |
memo | Unknown | |
reference | Unknown | |
register | Json | |
total_amount | Unknown | |
total_balance | Unknown | |
updated_at | Unknown |
lease_reversed_payment_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_reversed_payment_id | Unknown | PKFK |
account_id | Unknown | FK |
amount | Unknown | |
balance | Unknown | |
memo | Unknown |
lease_reversed_payment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_id | Unknown | FK |
lease_payment_id | Unknown | FK |
batch | Unknown | |
created_at | Unknown | |
date | Unknown | |
deposit_status | Unknown | |
memo | Unknown | |
processor_fee | Unknown | |
reference | Unknown | |
register | Json | |
updated_at | Unknown |
report_cash_flow_statement
| Column | Type | Keys |
|---|---|---|
_fivetran_id | Unknown | PK |
account_id | Unknown | FK |
parent_account_id | Unknown | FK |
abs_total_with_sub_accounts | Unknown | |
group_by | Unknown | |
root_account | Unknown | |
total | Unknown | |
total_with_sub_accounts | Unknown | |
type | Unknown |
owner_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
owner_id | Unknown | PKFK |
address | Unknown | |
type | Unknown |
owner_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
owner_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
company | Unknown | |
company_name | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
federal_tax_info_address_city | Unknown | |
federal_tax_info_address_country | Unknown | |
federal_tax_info_address_for_1099_same_as_primary_address | Unknown | |
federal_tax_info_address_latitude | Unknown | |
federal_tax_info_address_longitude | Unknown | |
federal_tax_info_address_street_1 | Unknown | |
federal_tax_info_address_street_2 | Unknown | |
federal_tax_info_address_zip | Unknown | |
federal_tax_info_payer_id | Unknown | |
federal_tax_info_payer_name | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
gender | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
management_end_date | Unknown | |
management_start_date | Unknown | |
middle_name | Unknown | |
name | Unknown | |
notes | Unknown | |
picture_url | Unknown | |
portal_info_allow_access | Unknown | |
portal_info_login_email | Unknown | |
portal_info_mobile_phone | Unknown | |
primary_address_city | Unknown | |
primary_address_country | Unknown | |
primary_address_latitude | Unknown | |
primary_address_longitude | Unknown | |
primary_address_street_1 | Unknown | |
primary_address_street_2 | Unknown | |
primary_address_zip | Unknown | |
properties | Json | |
timezone | Unknown | |
updated_at | Unknown |
default_account_for
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
account_id | Unknown | PKFK |
account_action | Unknown |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
cash_flow_activity | Unknown | |
class | Unknown | |
created_at | Unknown | |
description | Unknown | |
fully_qualified_name | Unknown | |
name | Unknown | |
system_account | Unknown | |
type | Unknown | |
updated_at | Unknown |
lease_charge_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_charge_id | Unknown | PKFK |
account_id | Unknown | FK |
amount | Unknown | |
balance | Unknown | |
memo | Unknown |
lease_charge
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
lease_id | Unknown | FK |
updated_by_id | Unknown | FK |
batch | Unknown | |
created_at | Unknown | |
date | Unknown | |
last_late_fees_processed_date | Unknown | |
memo | Unknown | |
recurring_transaction | Unknown | |
reference | Unknown | |
register | Json | |
total_amount | Unknown | |
total_balance | Unknown | |
updated_at | Unknown |
task_assigned_to_user
| Column | Type | Keys |
|---|---|---|
assigned_to_user_id | Unknown | PKFK |
task_id | Unknown | PKFK |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
linked_resource_id | Unknown | FK |
property_id | Unknown | FK |
requested_by_owner_id | Unknown | FK |
requested_by_tenant_id | Unknown | FK |
requested_by_user_id | Unknown | FK |
unit_id | Unknown | FK |
updated_by_id | Unknown | FK |
vendor_bill_id | Unknown | FK |
vendor_id | Unknown | FK |
work_order_assigned_vendor_id | Unknown | FK |
work_order_vendor_bill_id | Unknown | FK |
completed_at | Unknown | |
created_at | Unknown | |
date_type | Unknown | |
description | Unknown | |
due_date | Unknown | |
entry_notes | Unknown | |
entry_permission | Unknown | |
notify_assignees | Unknown | |
notify_tenant | Unknown | |
priority | Unknown | |
reference | Unknown | |
status | Unknown | |
subject | Unknown | |
type | Unknown | |
updated_at | Unknown | |
work_order_approved_by_owner | Unknown | |
work_order_billed | Unknown | |
work_order_instructions_to_vendor | Unknown | |
work_order_vendor_id | Unknown |
unit_picture
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
unit_id | Unknown | PKFK |
rank | Unknown | |
url | Unknown |
unit_amenity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
unit_id | Unknown | PKFK |
amenity | Unknown |
unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
property_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
active_listing | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_latitude | Unknown | |
address_longitude | Unknown | |
address_same_as_property | Unknown | |
address_street_1 | Unknown | |
address_street_2 | Unknown | |
address_zip | Unknown | |
batch | Unknown | |
baths | Unknown | |
beds | Unknown | |
created_at | Unknown | |
description | Unknown | |
in_eviction | Unknown | |
listing_contact | Unknown | |
listing_date_available | Unknown | |
listing_deposit | Unknown | |
listing_lease_length | Unknown | |
listing_listing | Unknown | |
listing_rent | Unknown | |
market_rent | Unknown | |
name | Unknown | |
size | Unknown | |
updated_at | Unknown |
property_owner
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
property_id | Unknown | PKFK |
user_id | Unknown | FK |
ownership_percentage | Unknown |
property_picture
| Column | Type | Keys |
|---|---|---|
file_id | Unknown | PK |
property_id | Unknown | PKFK |
rank | Unknown | |
url | Unknown |
property_amenity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
property_id | Unknown | PKFK |
amenity | Unknown |
property_setting
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
property_id | Unknown | PKFK |
value | Unknown |
property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_latitude | Unknown | |
address_longitude | Unknown | |
address_street_1 | Unknown | |
address_street_2 | Unknown | |
address_zip | Unknown | |
batch | Unknown | |
class | Unknown | |
created_at | Unknown | |
description | Unknown | |
name | Unknown | |
num_active_units | Unknown | |
type | Unknown | |
updated_at | Unknown |
report_rent_roll_picture
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
file | Unknown | |
rank | Unknown | |
url | Unknown |
report_rent_roll
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
lease_id | Unknown | FK |
next_lease_id | Unknown | FK |
property_id | Unknown | FK |
unit_id | Unknown | FK |
active | Unknown | |
baths | Unknown | |
beds | Unknown | |
end_date | Unknown | |
last_payment_amount | Unknown | |
last_payment_date | Unknown | |
last_returned_payment_amount | Unknown | |
last_returned_payment_date | Unknown | |
market_rent | Unknown | |
occupied | Unknown | |
renewal_stage | Unknown | |
rent_per_size | Unknown | |
rollover_to_at_will | Unknown | |
size | Unknown | |
start | Unknown | |
term | Unknown | |
total_balance_due | Unknown | |
total_deposits_held | Unknown | |
total_recurring_charges | Unknown | |
total_recurring_credits | Unknown | |
total_recurring_payments | Unknown | |
total_recurring_rent | Unknown | |
custom_** |
user_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
address | Unknown | |
type | Unknown |
user_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
bank_accounts | Json | |
company | Unknown | |
company_name | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
gender | Unknown | |
invitation_last_sent_at | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
last_seen_at | Unknown | |
login_email | Unknown | |
middle_name | Unknown | |
name | Unknown | |
notes | Unknown | |
owner | Unknown | |
picture_url | Unknown | |
primary_address_city | Unknown | |
primary_address_country | Unknown | |
primary_address_latitude | Unknown | |
primary_address_longitude | Unknown | |
primary_address_street_1 | Unknown | |
primary_address_street_2 | Unknown | |
primary_address_zip | Unknown | |
properties | Json | |
property_groups | Json | |
role | Unknown | |
status | Unknown | |
timezone | Unknown | |
updated_at | Unknown |
communication_clicked_at
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
communication_id | Unknown | PKFK |
clicked_at | Unknown |
communication_opened_at
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
communication_id | Unknown | PKFK |
opened_at | Unknown |
communication_bcc
| Column | Type | Keys |
|---|---|---|
communication_id | Unknown | PKFK |
linked_to_id | Unknown | PKFK |
address | Unknown | |
display_name | Unknown |
communication_cc
| Column | Type | Keys |
|---|---|---|
communication_id | Unknown | PKFK |
linked_to_id | Unknown | PKFK |
address | Unknown | |
display_name | Unknown |
communication_to
| Column | Type | Keys |
|---|---|---|
communication_id | Unknown | PKFK |
linked_to_id | Unknown | PKFK |
address | Unknown | |
display_name | Unknown |
communication
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
announcement | Unknown | |
body_html | Unknown | |
body_preview | Unknown | |
bounced_at | Unknown | |
created_at | Unknown | |
external_id | Unknown | |
from_address | Unknown | |
from_display_name | Unknown | |
from_linked_to_type | Unknown | |
sent_at | Unknown | |
status | Unknown | |
subject | Unknown | |
thread_id | Unknown | |
type | Unknown | |
updated_at | Unknown |
report_balance_sheet_summary
| Column | Type | Keys |
|---|---|---|
_fivetran_id | Unknown | PK |
account_id | Unknown | FK |
parent_account_id | Unknown | FK |
abs_total_with_sub_accounts | Unknown | |
group_by | Unknown | |
root_account | Unknown | |
total | Unknown | |
total_with_sub_accounts | Unknown | |
type | Unknown |
report_profit_and_loss_summary
| Column | Type | Keys |
|---|---|---|
_fivetran_id | Unknown | PK |
account_id | Unknown | FK |
parent_account_id | Unknown | FK |
abs_total_with_sub_accounts | Unknown | |
group_by | Unknown | |
root_account | Unknown | |
total | Unknown | |
total_with_sub_accounts | Unknown | |
type | Unknown |
lease_credit_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_credit_id | Unknown | PKFK |
account_id | Unknown | FK |
amount | Unknown | |
balance | Unknown | |
memo | Unknown |
lease_credit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
lease_id | Unknown | FK |
updated_by_id | Unknown | FK |
batch | Unknown | |
created_at | Unknown | |
date | Unknown | |
memo | Unknown | |
reference | Unknown | |
register | Json | |
total_amount | Unknown | |
total_balance | Unknown | |
updated_at | Unknown |
lease_tenant_unit
| Column | Type | Keys |
|---|---|---|
lease_tenant_id | Unknown | PKFK |
unit_id | Unknown | PKFK |
lease_tenant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_id | Unknown | FK |
property_id | Unknown | FK |
tenant_id | Unknown | FK |
move_in_at | Unknown | |
move_out_at | Unknown | |
move_out_notice_at | Unknown | |
name | Unknown | |
portal_enabled | Unknown | |
status | Unknown |
note_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
note_id | Unknown | PKFK |
tags | Unknown |
note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
linked_resource_id | Unknown | FK |
body | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
linked_resource_type | Unknown | |
title | Unknown |
portfolio_property
| Column | Type | Keys |
|---|---|---|
portfolio_id | Unknown | PKFK |
property_id | Unknown | PKFK |
portfolio
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
updated_at | Unknown |
vendor_credit_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_credit_id | Unknown | PKFK |
account_id | Unknown | FK |
linked_resource_id | Unknown | FK |
amount | Unknown | |
balance | Unknown | |
memo | Unknown |
vendor_credit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | FK |
batch | Unknown | |
date | Unknown | |
due_date | Unknown | |
memo | Unknown | |
reference | Unknown | |
total_amount | Unknown | |
total_balance | Unknown |
tenant_dependant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
date_of_birth | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
middle_name | Unknown | |
relationship | Unknown |
tenant_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
address | Unknown | |
type | Unknown |
tenant_emergency_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
email | Unknown | |
name | Unknown | |
phone | Unknown | |
relationship | Unknown |
tenant_pet
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
age | Unknown | |
breed | Unknown | |
color | Unknown | |
gender | Unknown | |
is_service_animal | Unknown | |
is_spayed_or_neutered | Unknown | |
name | Unknown | |
notes | Unknown | |
type | Unknown | |
weight | Unknown |
tenant_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
tenant_prospect_info_interest
| Column | Type | Keys |
|---|---|---|
property_id | Unknown | PKFK |
tenant_id | Unknown | PKFK |
unit_id | Unknown | PKFK |
tenant_vehicle
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tenant_id | Unknown | PKFK |
color | Unknown | |
license_platae | Unknown | |
make | Unknown | |
model | Unknown | |
notes | Unknown | |
state | Unknown | |
year | Unknown |
tenant_unit
| Column | Type | Keys |
|---|---|---|
tenant_id | Unknown | PKFK |
unit_id | Unknown | PKFK |
tenant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
batch | Unknown | |
company | Unknown | |
company_name | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
first_name | Unknown | |
gender | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
middle_name | Unknown | |
name | Unknown | |
notes | Unknown | |
picture_url | Unknown | |
portal_info_allow_access | Unknown | |
portal_info_invitation_last_sent_at | Unknown | |
portal_info_last_seen_at | Unknown | |
portal_info_login_email | Unknown | |
portal_info_mobile_phone | Unknown | |
portal_info_status | Unknown | |
primary_address_city | Unknown | |
primary_address_country | Unknown | |
primary_address_latitude | Unknown | |
primary_address_longitude | Unknown | |
primary_address_street_1 | Unknown | |
primary_address_street_2 | Unknown | |
primary_address_zip | Unknown | |
prospect_info_assigned_to_user | Unknown | |
prospect_info_campaign_content | Unknown | |
prospect_info_campaign_medium | Unknown | |
prospect_info_campaign_name | Unknown | |
prospect_info_campaign_source | Unknown | |
prospect_info_campaign_term | Unknown | |
prospect_info_credit_score | Unknown | |
prospect_info_expected_move_in_date | Unknown | |
prospect_info_lead_source | Unknown | |
prospect_info_max_rent | Unknown | |
prospect_info_min_bathrooms | Unknown | |
prospect_info_min_bedrooms | Unknown | |
prospect_info_monthly_income | Unknown | |
prospect_info_next_task_date | Unknown | |
prospect_info_status | Unknown | |
timezone | Unknown | |
type | Unknown | |
updated_at | Unknown |
lease_payment_linked_charge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lease_payment_id | Unknown | PKFK |
account_id | Unknown | FK |
amount | Unknown | |
linked_transaction | Unknown | |
linked_transaction_line | Unknown |
lease_payment_e_pay
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
lease_payment_id | Unknown | PKFK |
value | Unknown |
lease_payment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
deposit_to_account_id | Unknown | FK |
lease_id | Unknown | FK |
received_from_tenant_id | Unknown | FK |
updated_by_id | Unknown | FK |
amount_applied_to_charges | Unknown | |
amount_applied_to_credits | Unknown | |
amount_not_applied_to_charges | Unknown | |
amount_received | Unknown | |
auto_apply_payment_on_charges | Unknown | |
auto_deposit | Unknown | |
check_info | Json | |
created_at | Unknown | |
deposit_entry | Unknown | |
deposit_status | Unknown | |
is_files_shared_with_tenant | Unknown | |
linked_credits | Json | |
payment_method | Unknown | |
reference | Unknown | |
register | Json | |
reversed_payment | Unknown | |
updated_at | Unknown |
lease_unit
| Column | Type | Keys |
|---|---|---|
lease_id | Unknown | PKFK |
unit_id | Unknown | PKFK |
lease_renewal_history
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lease_id | Unknown | PKFK |
unit_id | Unknown | FK |
new_rent | Unknown | |
previous_rent | Unknown | |
renewal_date | Unknown |
lease_setting
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
lease_id | Unknown | PKFK |
value | Unknown |
lease
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
property_id | Unknown | FK |
updated_by_id | Unknown | FK |
created_at | Unknown | |
ends | Unknown | |
evicton_pending | Unknown | |
last_late_fees_processed_date | Unknown | |
name | Unknown | |
notes | Unknown | |
proof_of_insurance_required | Unknown | |
recurring_rent_frequency | Unknown | |
reference | Unknown | |
renewal_stage | Unknown | |
rollover_to_at_will | Unknown | |
start | Unknown | |
status | Unknown | |
term | Unknown | |
total_balance_due | Unknown | |
total_deposits_held | Unknown | |
total_recurring_charges | Unknown | |
total_recurring_credits | Unknown | |
total_recurring_payments | Unknown | |
total_recurring_rent | Unknown | |
updated_at | Unknown |
expense_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
expense_id | Unknown | PKFK |
account_id | Unknown | FK |
linked_resource_id | Unknown | FK |
property_id | Unknown | FK |
amount | Unknown | |
balance | Unknown |
expense_register
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
expense_id | Unknown | PKFK |
cleared | Unknown | |
plaid_transaction | Unknown |
expense
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
batch | Unknown | |
check_info | Json | |
created_at | Unknown | |
date | Unknown | |
memo | Unknown | |
pay_from_account | Unknown | |
pay_to_resource_id | Unknown | |
pay_to_resource_type | Unknown | |
payment_method | Unknown | |
recurring_transaction | Unknown | |
reference | Unknown | |
register | Json | |
total_amount | Unknown | |
total_balance | Unknown | |
updated_at | Unknown |
vendor_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_id | Unknown | PKFK |
address | Unknown | |
type | Unknown |
vendor_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
vendor_property
| Column | Type | Keys |
|---|---|---|
property_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
active | Unknown | |
balance | Unknown | |
company | Unknown | |
company_name | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
federal_tax_info_address_city | Unknown | |
federal_tax_info_address_country | Unknown | |
federal_tax_info_address_for_1099_same_as_primary_address | Unknown | |
federal_tax_info_address_latitude | Unknown | |
federal_tax_info_address_longitude | Unknown | |
federal_tax_info_address_street_1 | Unknown | |
federal_tax_info_address_street_2 | Unknown | |
federal_tax_info_address_zip | Unknown | |
federal_tax_info_payer_id | Unknown | |
federal_tax_info_payer_name | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
gender | Unknown | |
insurance_info_coverage | Unknown | |
insurance_info_effective_date | Unknown | |
insurance_info_expiration_date | Unknown | |
insurance_info_policy_number | Unknown | |
insurance_info_provider | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
management_end_date | Unknown | |
management_start_date | Unknown | |
middle_name | Unknown | |
name | Unknown | |
notes | Unknown | |
picture_url | Unknown | |
primary_address_city | Unknown | |
primary_address_country | Unknown | |
primary_address_latitude | Unknown | |
primary_address_longitude | Unknown | |
primary_address_street_1 | Unknown | |
primary_address_street_2 | Unknown | |
primary_address_zip | Unknown | |
timezone | Unknown | |
updated_at | Unknown |