Table: dbo.Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item
Linker from child employee payroll item to parent employee payroll item. Child employee payroll items get the values for calculation type and rates from the parent employee payroll item. The child and parent values cannot be the same. Parent items cannot also be children. Only pay type payroll items can be represented in this table. The employee payroll items in this table must be for the same employee. Parent items cannot be of special type weighted average overtime. The calculation types and rates must match between employee payroll items in the table as well as their distributions.
Columns
Name | Type | Constraints | Description
child__employee_payroll_item_KEY | int (4) | NOT NULL | Primary key for this table. The child employee payroll item in the relationship specified.
parent__employee_payroll_item_KEY | int (4) | NOT NULL | The parent employee payroll item for the corresponding child.

Primary key
Name | Columns | Description
PK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item$child__employee_payroll_item_KEY | child__employee_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item__Employee_Payroll_Item__child__employee_payroll_item_KEY | child__employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item__Employee_Payroll_Item__parent__employee_payroll_item_KEY | parent__employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |