Deputy
Explore the interactive ERD
Table & Field Reference
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
created | Unknown | |
email | Unknown | |
email_1 | Unknown | |
email_1_type | Unknown | |
email_2 | Unknown | |
email_2_type | Unknown | |
fax | Unknown | |
im_1 | Unknown | |
im_1_type | Unknown | |
im_2 | Unknown | |
im_2_type | Unknown | |
mobile | Unknown | |
modified | Instant | |
note | Unknown | |
phone_1 | Unknown | |
phone_1_type | Unknown | |
phone_2 | Unknown | |
phone_2_type | Unknown | |
phone_3 | Unknown | |
phone_3_type | Unknown | |
primary_email | Unknown | |
primary_phone | Unknown | |
saved | Unknown | |
web | Unknown |
employment_condition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
avg_hours_per_day | Unknown | |
award_level | Unknown | |
created | Unknown | |
description | Unknown | |
employment_basis | Unknown | |
employment_category | Unknown | |
employment_period | Unknown | |
employment_status | Unknown | |
min_hours_for_leave | Unknown | |
min_hours_per_day | Unknown | |
modified | Instant | |
name | Unknown | |
probationary_period | Unknown | |
usual_finish_time | Unknown | |
usual_meal_break | Unknown | |
usual_start_time | Unknown | |
working_days_per_period | Unknown |
agreed_hour
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
employee_id | Unknown | FK |
apply_threshold | Unknown | |
threshold | Unknown | |
work_period_cycle | Unknown | |
work_period_day_of_week | Unknown | |
work_period_end_cycle_date | Unknown | |
work_period_start_cycle_date | Unknown | |
work_period_start_date | Unknown | |
working_days_per_cycle | Unknown |
news_feed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
active | Unknown | |
confirm_text | Unknown | |
content | Unknown | |
created | Unknown | |
disable_comment | Unknown | |
file | Unknown | |
keyword | Unknown | |
modified | Unknown | |
show_from | Unknown | |
show_till | Unknown | |
title | Unknown | |
type | Unknown | |
url | Unknown |
comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
comment | Unknown | |
created | Unknown | |
file | Unknown | |
ignore_permission | Unknown | |
in_feed | Unknown | |
modified | Instant | |
orm | Unknown | |
rec_id | Unknown |
employee_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
creator_id | Unknown | FK |
emergency_address | Unknown | FK |
employee_id | Unknown | FK |
main_address_id | Unknown | FK |
postal_address | Unknown | FK |
role_id | Unknown | FK |
active | Unknown | |
created | Unknown | |
date_of_birth | Unknown | |
display_name | Unknown | |
first_name | Unknown | |
gender | Unknown | |
job_app_id | Unknown | |
last_name | Unknown | |
modified | Instant | |
other_name | Unknown | |
photo | Unknown | |
position | Unknown | |
salutation | Unknown | |
start_date | Unknown | |
termination_date | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
category | Unknown | |
created | Unknown | |
groups | Unknown | |
modified | Instant | |
sort_order | Unknown | |
staff_log | Unknown | |
systems | Unknown |
pay_period
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
active | Unknown | |
created | Unknown | |
cycle | Unknown | |
modified | Instant | |
name | Unknown | |
start_date | Unknown |
employee_availability
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
comment | Unknown | |
created | Unknown | |
date | Unknown | |
end_time | Unknown | |
end_time_localized | Unknown | |
max_date_recurring_generated | Unknown | |
modified | Instant | |
schedule | Unknown | |
start_time | Unknown | |
start_time_localized | Unknown | |
type | Unknown |
operational_unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_id | Unknown | FK |
company_id | Unknown | FK |
contact_id | Unknown | FK |
creator_id | Unknown | FK |
parent_operational_unit | Unknown | FK |
active | Unknown | |
colour | Unknown | |
created | Unknown | |
daily_roster_budget | Unknown | |
modified | Instant | |
operational_unit_name | Unknown | |
operational_unit_type | Unknown | |
payroll_export_name | Unknown | |
roster_active_hours_schedule | Unknown | |
roster_sort_order | Unknown | |
show_on_roster | Unknown | |
work_type | Unknown |
stress_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
created | Unknown | |
custom_rules | Unknown | |
gap_hours_between_shifts | Unknown | |
max_days_per_period | Unknown | |
max_hours_per_day | Unknown | |
max_hours_per_period | Unknown | |
max_hours_per_shift | Unknown | |
modified | Instant | |
name | Unknown |
employee_workplace
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
agreement_1 | Unknown | |
agreement_2 | Unknown | |
agreement_3 | Unknown | |
created | Unknown | |
modified | Unknown | |
sort_order | Unknown |
employee_leave_accrual
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
comment | Unknown | |
days | Unknown | |
hours | Unknown | |
leave_rule_id | Unknown | |
transaction_date | Unknown | |
type | Unknown |
contract_pay_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
advanced_calculation | Unknown | |
annual_salary | Unknown | |
comment | Unknown | |
config | Unknown | |
cr_id | Unknown | |
created | Unknown | |
ct_id | Unknown | |
dexml_script | Unknown | |
dexml_script_param | Unknown | |
hourly_rate | Unknown | |
is_exported | Unknown | |
is_multiplier | Unknown | |
maximum_shift_length | Unknown | |
maximum_type | Unknown | |
maximum_value | Unknown | |
minimum_shift_length | Unknown | |
minimum_type | Unknown | |
minimum_value | Unknown | |
modified | Unknown | |
multiplier_base_rate | Unknown | |
multiplier_value | Unknown | |
pay_portion_rule | Unknown | |
pay_title | Unknown | |
payroll_category | Unknown | |
period_type | Unknown | |
rate_tag | Unknown | |
rate_type | Unknown | |
recommend_with | Unknown | |
remuneration_by | Unknown | |
remuneration_type | Unknown | |
schedule | Unknown | |
unit_value | Unknown |
contract_leave_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
base_pay_rule | Unknown | |
contract_id | Unknown | |
created | Unknown | |
leave_rule_id | Unknown | |
loading_pay_rule_1 | Unknown | |
loading_pay_rule_2 | Unknown | |
loading_pay_rule_3 | Unknown | |
modified | Unknown |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
contract_stress_profile_id | Unknown | FK |
history_id | Unknown | FK |
stress_profile_id | Unknown | FK |
user_id | Unknown | FK |
allow_appraisal | Unknown | |
allow_log_in | Unknown | |
analytics_id | Unknown | |
can_ask_to_show_pin | Unknown | |
contract_award | Unknown | |
contract_award_start_date | Unknown | |
contract_base_pay_rule | Unknown | |
contract_code | Unknown | |
contract_country_id | Unknown | |
contract_created | Unknown | |
contract_creator_id | Unknown | |
contract_description | Unknown | |
contract_employment_basis | Unknown | |
contract_employment_category | Unknown | |
contract_employment_condition | Unknown | |
contract_employment_status | Unknown | |
contract_employment_sub_type | Unknown | |
contract_end_date | Unknown | |
contract_file | Unknown | |
contract_id | Unknown | |
contract_migrate_to | Unknown | |
contract_modified | Unknown | |
contract_name | Unknown | |
contract_period_type | Unknown | |
contract_pp_id | Unknown | |
contract_start_date | Unknown | |
contract_strict_leave_approval | Unknown | |
contract_third_party_sync | Unknown | |
created | Unknown | |
custom_field_data | Unknown | |
custom_pronouns | Unknown | |
email | Unknown | |
employee_hourly_rate | Unknown | |
has_android_token | Unknown | |
has_enabled_2_fa | Unknown | |
has_iphone_token | Unknown | |
higher_duty | Unknown | |
image | Unknown | |
is_subordinate | Unknown | |
mobile | Unknown | |
modified | Instant | |
onboarding_id | Unknown | |
payroll_id | Unknown | |
photo_link_id | Unknown | |
pronouns | Unknown | |
salary_distribution_config | Unknown | |
status | Unknown | |
training_array | Json | |
training_file_array | Json | |
user_name | Unknown |
roster_slot
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
roster_id | Unknown | FK |
bln_empty_slot | Unknown | |
int_end | Unknown | |
int_start | Unknown | |
int_unix_end | Unknown | |
int_unix_start | Unknown | |
mixed_activity_bln_can_end_early | Unknown | |
mixed_activity_bln_can_start_early | Unknown | |
mixed_activity_bln_is_mandatory | Unknown | |
mixed_activity_int_state | Unknown | |
mixed_activity_str_break_type | Unknown | |
str_state | Unknown | |
str_type | Unknown | |
str_type_name | Unknown |
roster
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
confirm_by | Unknown | FK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
matched_by_timesheet | Unknown | FK |
operational_unit_id | Unknown | FK |
approval_required | Unknown | |
bids_count | Unknown | |
comment | Unknown | |
confirm_comment | Unknown | |
confirm_status | Unknown | |
confirm_time | Unknown | |
connect_creator | Unknown | |
connect_status | Unknown | |
cost | Unknown | |
created | Unknown | |
custom_field_data | Unknown | |
date | Unknown | |
end_time | Unknown | |
end_time_localized | Unknown | |
external_id | Unknown | |
meal_break | Unknown | |
modified | Unknown | |
on_cost | Unknown | |
opens | Unknown | |
parent_id | Unknown | |
published | Unknown | |
shift_template | Unknown | |
start_time | Unknown | |
start_time_localized | Unknown | |
swap_manage_by | Unknown | |
swap_status | Unknown | |
total_time | Unknown | |
warning | Unknown | |
warning_override_comment | Unknown |
timesheet_pay_retrun
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
pay_rule_id | Unknown | FK |
timesheet_id | Unknown | FK |
cost | Unknown | |
created | Unknown | |
event_ids | Json | |
modified | Instant | |
overridden | Unknown | |
override_comment | Unknown | |
value | Unknown |
employee_agreement_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_id | Unknown | FK |
creator_id | Unknown | FK |
active | Unknown | |
company_name | Unknown | |
contract_file | Unknown | |
contract_id | Unknown | |
created | Unknown | |
emp_type | Unknown | |
modified | Instant | |
pay_period | Unknown | |
pay_point | Unknown | |
payroll_id | Unknown | |
salary_pay_rule | Unknown | |
start_date | Unknown |
company_period
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
creator_id | Unknown | FK |
pay_period | Unknown | FK |
created | Unknown | |
date_end | Unknown | |
date_start | Unknown | |
ends | Unknown | |
modified | Instant | |
start | Unknown |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_id | Unknown | FK |
contact_id | Unknown | FK |
creator_id | Unknown | FK |
parent_company | Unknown | FK |
active | Unknown | |
business_number | Unknown | |
code | Unknown | |
company_name | Unknown | |
company_number | Unknown | |
created | Unknown | |
is_payroll_entity | Unknown | |
is_workplace | Unknown | |
modified | Instant | |
payroll_export_code | Unknown | |
portfolio | Unknown | |
trading_name | Unknown |
employee_agreement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
history_id | Unknown | FK |
base_rate | Unknown | |
config | Json | |
created | Unknown | |
end_date | Unknown | |
modified | Instant |
notification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
created | Unknown | |
expiry_date | Unknown | |
link | Unknown | |
message | Unknown | |
modified | Unknown | |
orm | Unknown | |
recid | Unknown | |
ts_created | Unknown |
award_library
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
award_code | Unknown | |
country_code | Unknown | |
employment_term | Unknown | |
name | Unknown |
address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
city | Unknown | |
contact_name | Unknown | |
country | Unknown | |
created | Unknown | |
format | Unknown | |
modified | Instant | |
note | Unknown | |
phone | Unknown | |
po_box | Unknown | |
post_code | Unknown | |
print | Unknown | |
saved | Unknown | |
state | Unknown | |
street_1 | Unknown | |
street_2 | Unknown | |
street_number | Unknown | |
suite_number | Unknown | |
unit_no | Unknown |
leave_pay_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_id | Unknown | PKFK |
employee_agreement_id | Unknown | FK |
timesheet_id | Unknown | FK |
comment | Unknown | |
cost | Unknown | |
created | Unknown | |
creator | Unknown | |
date | Unknown | |
end_time | Unknown | |
end_time_localized | Unknown | |
hours | Unknown | |
leave_rule | Unknown | |
modified | Unknown | |
recalculate_with_reference_period | Unknown | |
start_time | Unknown | |
start_time_localized | Unknown | |
timezone | Unknown |
employee_leave
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
approver_pay | Unknown | FK |
company_id | Unknown | FK |
creator_id | Unknown | FK |
employee_history_id | Unknown | FK |
employee_id | Unknown | FK |
approval_comment | Unknown | |
approver_time | Unknown | |
comment | Unknown | |
created | Unknown | |
date_end | Unknown | |
date_end_all_day | Unknown | |
date_start | Unknown | |
date_start_all_day | Unknown | |
days | Unknown | |
end_time_localized | Unknown | |
ends | Unknown | |
external_id | Unknown | |
leave_rule_id | Unknown | |
modified | Instant | |
notify_manager | Json | |
start | Unknown | |
start_time_localized | Unknown | |
status | Unknown | |
timezone | Unknown | |
total_hours | Unknown |
timesheet_slot
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
resource_timesheet_id | Unknown | FK |
bln_empty_slot | Unknown | |
int_end | Unknown | |
int_start | Unknown | |
int_unix_end | Unknown | |
int_unix_start | Unknown | |
mixed_activity_bln_can_end_early | Unknown | |
mixed_activity_bln_can_start_early | Unknown | |
mixed_activity_bln_is_mandatory | Unknown | |
mixed_activity_int_state | Unknown | |
mixed_activity_str_break_type | Unknown | |
str_state | Unknown | |
str_type | Unknown | |
str_type_name | Unknown |
resource_timesheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_id | Unknown | FK |
creator_id | Unknown | FK |
employee_id | Unknown | FK |
history_id | Unknown | FK |
leave_id | Unknown | FK |
parent_id | Unknown | FK |
roster_id | Unknown | FK |
accrual_attempts | Unknown | |
accrual_state | Unknown | |
accrual_state_changed_at | Unknown | |
auto_pay_rule_approved | Unknown | |
auto_processed | Unknown | |
auto_rounded | Unknown | |
auto_time_approved | Unknown | |
cost | Unknown | |
created | Unknown | |
custom_field_data | Json | |
date | Unknown | |
discarded | Unknown | |
disputed | Unknown | |
employee_comment | Unknown | |
end_time | Unknown | |
end_time_localized | Unknown | |
exported | Unknown | |
file | Unknown | |
invoice_comment | Unknown | |
invoiced | Unknown | |
is_in_progress | Unknown | |
is_leave | Unknown | |
leave_rule_id | Unknown | |
marked_paid_unpaid_at | Unknown | |
meal_break | Unknown | |
meal_break_slots | Json | |
metadata | Json | |
modified | Instant | |
on_cost | Unknown | |
operational_unit | Unknown | |
pay_cycle_id | Unknown | |
pay_rule_approved | Unknown | |
pay_staged | Unknown | |
real_time | Unknown | |
staging_id | Unknown | |
start_time | Unknown | |
start_time_localized | Unknown | |
supervisor | Unknown | |
supervisor_comment | Unknown | |
time_approved | Unknown | |
time_approver | Unknown | |
total_time | Unknown | |
total_time_inv | Unknown | |
validation_flag | Unknown |
employee_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
created | Unknown | |
modified | Instant | |
permission | Unknown | |
ranking | Unknown | |
report_to | Unknown | |
require_2_fa | Unknown | |
role | Unknown |