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. |
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. |