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
NameTypeConstraintsDescription
child__employee_payroll_item_KEYint (4)NOT NULLPrimary key for this table. The child employee payroll item in the relationship specified.
parent__employee_payroll_item_KEYint (4)NOT NULLThe parent employee payroll item for the corresponding child.
Primary key
NameColumnsDescription
PK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item$child__employee_payroll_item_KEYchild__employee_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item__Employee_Payroll_Item__child__employee_payroll_item_KEYchild__employee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item__Employee_Payroll_Item__parent__employee_payroll_item_KEYparent__employee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)

Schema diagram