Table: dbo.Employee_Payroll_Item_Distribution
Table that supports multiple rates/amount/percents as well as GL accounts for work location/payroll department combinations (for Employee_Payroll_Item).
Columns
Name | Type | Constraints | Description
employee_payroll_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table.
employee_payroll_item_KEY | int (4) | NOT NULL | Foreign key to the Employee_Payroll_Item table.
employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Foreign key to the Employee_Work_Location_Payroll_Department table. This table houses the a given Employee's work location/payroll departments.
amount | decimal (9, 2) | NOT NULL | Payroll item amount for this work location/payroll department combination.
rate | decimal (9, 4) | NOT NULL | Payroll item rate for this work location/payroll department combination.
percentage | decimal (5, 4) | NOT NULL | Payroll item percentage for this work location/payroll department combination.
liability__gl_account_KEY | int (4) |  | Optional liability gl account for this work location/payroll department combination
expense__gl_account_KEY | int (4) |  | Optional expense gl account for this work location/payroll department combination

Primary key
Name | Columns | Description
PK_Employee_Payroll_Item_Distribution | employee_payroll_item_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Payroll_Item_Distribution$employee_payroll_item_KEY$employee_work_location_payroll_department_KEY | employee_payroll_item_KEY, employee_work_location_payroll_department_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Payroll_Item_Distribution__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Employee_Payroll_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEY | employee_work_location_payroll_department_KEY | Employee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY) |
FK_Employee_Payroll_Item_Distribution__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Employee_Payroll_Item_Distribution__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |