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 |