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.