Table: dbo.Employee_W4_Setting_Parameter
Columns
NameTypeConstraintsDescription
employee_w4_setting_parameter_KEYint (4)NOT NULLPrimary key for this table
employee_w4_setting_KEYint (4)NOT NULLReference to employee W4 setting
parameter_KEYnvarchar (100)NOT NULLForeign Key to a Symmetry Tax Engine state miscellaneous W4 parameter
parameter_valuenvarchar (100)NOT NULLSymmetry Tax Engine W4 value thats currently selected for the W4 parameter
data_versiontinyint (1)NOT NULLAllows 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
NameColumnsDescription
PK_Employee_W4_Setting_Parameteremployee_w4_setting_parameter_KEY
Unique constraints
NameColumnsDescription
UK_Employee_W4_Setting_Parameter$employee_w4_setting_KEY$data_version$parameter_KEYemployee_w4_setting_KEY, data_version, parameter_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W4_Setting_Parameter__Employee_W4_Setting__employee_w4_setting_KEYemployee_w4_setting_KEYEmployee_W4_Setting (employee_w4_setting_KEY)
FK_Employee_W4_Setting_Parameter__STE_State_Misc_Parameter__parameter_KEYparameter_KEYSTE_State_Misc_Parameter (parameter_KEY)

Schema diagram