| Table that supports multiple rates/amount/percents as well as GL accounts for work location/payroll department combinations (for Employee_Payroll_Item). |
| 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 |