Table: dbo.Employee_Work_Location_Payroll_Department
Columns
NameTypeConstraintsDescription
employee_work_location_payroll_department_KEYint (4)NOT NULLPrimary key for he record.
work_location_KEYint (4)NOT NULLParent work location record
payroll_department_KEYint (4)Optional payroll department key.
employee_KEYint (4)NOT NULLParent employee record
is_primarybit (1)NOT NULLIndicates if this is the primary work location for the employee
pay_distribution_percentdecimal (5, 2)NOT NULLPercentage of pay distributed to this work location/payroll department
employee_work_location_payroll_department_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
Primary key
NameColumnsDescription
PK_Employee_Work_Location_Payroll_Departmentemployee_work_location_payroll_department_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Work_Location_Payroll_Department$employee_KEY$work_location_KEY$payroll_department_KEYemployee_KEY, work_location_KEY, payroll_department_KEY
UK_Employee_Work_Location_Payroll_Department$employee_work_location_payroll_department_guidemployee_work_location_payroll_department_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Work_Location_Payroll_Department__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Work_Location_Payroll_Department__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Employee_Work_Location_Payroll_Department__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Payroll_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYPayroll_Check_Payroll_Item_Import
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_depemployee_work_location_payroll_department_KEYEmployee_Worker_Compensation_Item_Distribution
FK_Payroll_Check_Sales_Amount_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYPayroll_Check_Sales_Amount_Import
FK_Employee_Payroll_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYEmployee_Payroll_Item_Distribution
FK_Payroll_Check_Tax_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYPayroll_Check_Tax_Item_Import
FK_Employee_Tax_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYEmployee_Tax_Item_Distribution

Schema diagram