Fourth schema and ERD

33 tables

Loading diagram…

budget

contractor_shift

employee

employee_id

long

payroll_id

long

payroll_number

string

faid

string

company_id

long

company_name

string

paybasis

string

first_name

string

middle_name

string

last_name

string

employee_absence

employee_id

long

employee_number

string

reference

string

start_date

date

end_date

date

type

string

days

double

status

string

paid

string

employee_accrual

employee_id

long

element_name

string

element_type

string

start_date_time

date

units

double

unit_type

string

is_flexible

string

avg_summary

double

avg_time

double

avg_days

double

day_rate

double

_weld_synced

date

employee_address

employee_id

long

reference

string

effective_date

date

address_line_1

string

address_line_2

string

address_line_3

string

address_line_4

string

address_town

string

address_municipality

string

employee_country_specific

employee_id

long

country

string

property

string

value

string

_weld_synced

date

employee_division

division_id

long

division_name

string

accounting_system_code

string

division_guid

string

_weld_synced

date

employee_document

employee_id

long

reference

string

type

string

number

string

country

string

issue_date

date

arrival_date

date

expiry_date

date

holiday_start

date

holiday_end

date

is_required

boolean

processed

string

_weld_synced

date

employee_import_log

long

import_type

string

xml_type

string

reference_number

string

xml

string

status

string

date_created_utc

date

error

string

submission_id

string

result

string

client_id

long

_weld_synced

date

employee_location

location_id

long

description

string

country

string

area

string

accounting_system_code

string

location_guid

string

_weld_synced

date

employee_next_of_kin

employee_id

long

next_of_kin_reference

string

name

string

relationship

string

address_reference

string

address_effective_date

date

address_line1

string

address_line2

string

address_line3

string

employee_passport

employee_id

long

passport_text

string

passport_reference

string

passport_number

string

issuing_country

string

issue_date

date

expiry_date

date

_weld_synced

date

employee_pay_part

employee_id

long

element_name

string

element_local_ref

string

start_date_time

date

end_date_time

date

units

double

unit_type

string

rate

double

value

double

employee_payment_details

employee_id

long

pay_method

string

account_details

string

account_name

string

account_number

string

iban

string

branch_code

string

bic_swift

string

branch_name

string

employee_payroll_period

payroll_id

long

company_name

string

period_name

string

period_number

long

period_tax_year

long

pay_date

date

period_start_date

date

period_end_date

date

_weld_synced

date

employee_payslip

employee_id

long

payslip_reference

string

payslip_date

date

payment_date

date

tax_category

string

tax_rate

string

social_security_category

string

social_security_rate

string

pay_group

string

employee_source

source_description

string

_weld_synced

date

employment

employee_id

long

employment_reference

string

employment_start_date

date

employment_end_date

date

assignment_start_date

date

assignment_end_date

date

termination_reason

string

rehire

boolean

employment_type

string

budget

location_code

string

location_name

string

location_foreign_id

string

location_id

string

department_name

string

department_foreign_id

string

department_id

string

week_start

date

sales_type

string

location_id

string

department_id

string

week_start

date

week_end

date

name

string

sales_budget

double

labour_budget

double

forecast_or_actual_sales

double

flex_up

double

flex_down

double

_weld_synced

date

contractor_shift

contract_id

string

location_id

string

location_canonical_id

string

location_name

string

department_id

string

department_name

string

worker_id

string

worker_name

string

contractor_shift_expense

contract_id

string

value

double

expense_type_name

string

_weld_synced

date

fixed_cost

department_id

string

department_name

string

department_code

string

department_foreign_id

string

type_id

string

type_name

string

value

double

date

string

_weld_synced

date

fixed_task

location_code

string

location_name

string

location_foreign_id

string

location_id

string

department_name

string

department_foreign_id

string

department_id

string

role

string

labour_daily_summary

location_id

string

location_code

string

location_foreign_id

string

location_name

string

date

correctly_staffed_hours

double

understaffed_hours

double

overstaffed_hours

double

passive_hours

double

_weld_synced

date

minimum_staffing

location_code

string

location_name

string

location_id

string

location_foreign_id

string

department_id

string

department_name

string

department_foreign_id

string

role

string

payroll

employee_id

string

department_id

string

department_foreign_id

string

department_code

string

department_name

string

employee_foreign_id

string

employee_personnel_number

string

employee_forename

string

employee_surname

string

payroll_forecast

employee_id

string

department_id

string

department_foreign_id

string

department_code

string

department_name

string

employee_foreign_id

string

employee_personnel_number

string

employee_forename

string

employee_surname

string

productivity_analysis

date

location_code

string

location_name

string

correct_hours

double

overstaffed_hours

double

understaffed_hours

double

correct_percentage

double

understaffed_percentage

double

overstaffed_percentage

double

_weld_synced

date

sales

department_id

string

department_name

string

department_code

string

department_foreign_id

string

type_id

string

type_name

string

system_forecast

double

system_forecast_items

double

sales_forecast

department_id

string

department_name

string

department_code

string

department_foreign_id

string

type_id

string

type_name

string

system_forecast

double

system_forecast_items

double

shift

employee_id

string

location_id

string

location_code

string

location_name

string

location_foreign_id

string

department_id

string

department_code

string

department_name

string

department_foreign_id

string

shift_forecast

employee_id

string

location_id

string

location_code

string

location_name

string

location_foreign_id

string

department_id

string

department_code

string

department_name

string

department_foreign_id

string

staff_skill

employee_id

string

employee_personnel_number

string

job_role_id

string

skill_score

long

main_assignment_location_id

string

main_assignment_location_name

string

role_assignment_location_id

string

role_assignment_location_name

string

updated_by

string

update_source

string

updated_date

date

_weld_synced

date