Table: dbo.Employee_W4_Setting_Parameter
Columns
Name | Type | Constraints | Description
employee_w4_setting_parameter_KEY | int (4) | NOT NULL | Primary key for this table
employee_w4_setting_KEY | int (4) | NOT NULL | Reference to employee W4 setting
parameter_KEY | nvarchar (100) | NOT NULL | Foreign Key to a Symmetry Tax Engine state miscellaneous W4 parameter
parameter_value | nvarchar (100) | NOT NULL | Symmetry Tax Engine W4 value thats currently selected for the W4 parameter
data_version | tinyint (1) | NOT NULL | Allows different versions of information to coexist. As of 2019-11-01, 1 for all cases except the 2020 Federal W4, which is 2.

Primary key
Name | Columns | Description
PK_Employee_W4_Setting_Parameter | employee_w4_setting_parameter_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_W4_Setting_Parameter$employee_w4_setting_KEY$data_version$parameter_KEY | employee_w4_setting_KEY, data_version, parameter_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_W4_Setting_Parameter__Employee_W4_Setting__employee_w4_setting_KEY | employee_w4_setting_KEY | Employee_W4_Setting (employee_w4_setting_KEY) |
FK_Employee_W4_Setting_Parameter__STE_State_Misc_Parameter__parameter_KEY | parameter_KEY | STE_State_Misc_Parameter (parameter_KEY) |