# Deputy schema ERD

Table and field reference for the Fivetran Deputy connector.

## 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 | PK, FK |
| 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 |  |

## Relationships

- contact(creator_id) → employee(id)
- employment_condition(creator_id) → employee(id)
- agreed_hour(employee_id) → employee(id)
- news_feed(creator_id) → employee(id)
- comment(creator_id) → employee(id)
- employee_history(postal_address) → address(id)
- employee_history(main_address_id) → address(id)
- employee_history(emergency_address) → address(id)
- employee_history(employee_id) → employee(id)
- employee_history(role_id) → employee_role(id)
- employee_history(company_id) → company(id)
- employee_history(creator_id) → employee(id)
- category(creator_id) → employee(id)
- pay_period(creator_id) → employee(id)
- employee_availability(employee_id) → employee(id)
- employee_availability(creator_id) → employee(id)
- operational_unit(parent_operational_unit) → operational_unit(id)
- operational_unit(address_id) → address(id)
- operational_unit(company_id) → company(id)
- operational_unit(creator_id) → employee(id)
- operational_unit(contact_id) → contact(id)
- stress_profile(creator_id) → employee(id)
- employee_workplace(employee_id) → employee(id)
- employee_workplace(company_id) → company(id)
- employee_workplace(creator_id) → employee(id)
- employee_leave_accrual(employee_id) → employee(id)
- contract_pay_rule(creator_id) → employee(id)
- contract_pay_rule(employee_id) → employee(id)
- contract_leave_rule(creator_id) → employee(id)
- contract_leave_rule(employee_id) → employee(id)
- employee(user_id) → employee(id)
- employee(stress_profile_id) → stress_profile(id)
- employee(history_id) → employee_history(id)
- employee(contact_id) → contact(id)
- employee(contract_stress_profile_id) → stress_profile(id)
- roster_slot(roster_id) → roster(id)
- roster(confirm_by) → employee(id)
- roster(operational_unit_id) → operational_unit(id)
- roster(employee_id) → employee(id)
- roster(matched_by_timesheet) → resource_timesheet(id)
- roster(creator_id) → employee(id)
- timesheet_pay_retrun(pay_rule_id) → contract_pay_rule(id)
- timesheet_pay_retrun(creator_id) → employee(id)
- timesheet_pay_retrun(timesheet_id) → resource_timesheet(id)
- employee_agreement_history(agreement_id) → employee_agreement(id)
- employee_agreement_history(creator_id) → employee(id)
- company_period(pay_period) → pay_period(id)
- company_period(company_id) → company(id)
- company_period(creator_id) → employee(id)
- company(parent_company) → company(id)
- company(address_id) → address(id)
- company(creator_id) → employee(id)
- company(contact_id) → contact(id)
- employee_agreement(employee_id) → employee(id)
- employee_agreement(history_id) → employee_agreement_history(id)
- notification(creator_id) → employee(id)
- address(creator_id) → employee(id)
- leave_pay_line(employee_agreement_id) → employee_agreement(id)
- leave_pay_line(leave_id) → employee_leave(id)
- leave_pay_line(timesheet_id) → resource_timesheet(id)
- employee_leave(approver_pay) → employee(id)
- employee_leave(employee_history_id) → employee_history(id)
- employee_leave(employee_id) → employee(id)
- employee_leave(company_id) → company(id)
- employee_leave(creator_id) → employee(id)
- timesheet_slot(resource_timesheet_id) → resource_timesheet(id)
- resource_timesheet(history_id) → employee_history(id)
- resource_timesheet(agreement_id) → employee_agreement(id)
- resource_timesheet(roster_id) → roster(id)
- resource_timesheet(leave_id) → employee_leave(id)
- resource_timesheet(employee_id) → employee(id)
- resource_timesheet(parent_id) → resource_timesheet(id)
- resource_timesheet(creator_id) → employee(id)
- employee_role(creator_id) → employee(id)