Table: dbo.Secure_2_Roth_Catch_Up
Linker from child employee payroll item to parent employee payroll item for SECURE Act 2.0 Roth catch-up requirements. The child payroll item is the Roth catch-up payroll item, either Roth 401(k) or Roth 403(b), and the parent payroll item is either 401(k) or 403(b). The child and parent values cannot be the same. Both employee payroll items in this table must be for the same employee. A 401(k) deduction item can only be a parent to a Roth 401(k) deduction item. A 403(b) deduction item can only be a parent to a Roth 403(b) deduction item. The child payroll item must have a calculation type of Fixed Amount with rate, amount, and percentage set to zero.
Columns
Name | Type | Constraints | Description
parent__employee_payroll_item_KEY | int (4) | NOT NULL | Primary key for this table. The parent employee payroll item that is either 401(k) or 403(b) for the corresponding Roth catch-up child.
child__employee_payroll_item_KEY | int (4) | NOT NULL | The child employee payroll item that is the Roth catch-up payroll item, either Roth 401(k) or Roth 403(b), in the relationship specified.

Primary key
Name | Columns | Description
PK_Secure_2_Roth_Catch_Up$parent__employee_payroll_item_KEY | parent__employee_payroll_item_KEY |
Unique constraints
Name | Columns | Description
UK_Secure_2_Roth_Catch_Up$child__employee_payroll_item_KEY | child__employee_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Secure_2_Roth_Catch_Up__Employee_Payroll_Item__parent__employee_payroll_item_KEY | parent__employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) | FOREIGN KEY constraint of parent__employee_payroll_item_KEY for the Secure_2_Roth_Catch_Up table.
FK_Secure_2_Roth_Catch_Up__Employee_Payroll_Item__child__employee_payroll_item_KEY | child__employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) | FOREIGN KEY constraint of child__employee_payroll_item_KEY for the Secure_2_Roth_Catch_Up table.