Table: dbo.Ste_State_Misc_Parameter_Droplist_Item
Columns
NameTypeConstraintsDescription
ste_state_misc_parameter_droplist_item_KEYint (4)NOT NULLPrimary Key
ste_state_code_KEYnvarchar (4)State Code of of the state requiring this item
allowed_value_idint (4)NOT NULLAllowed Value ID - used by the system to selected proper control type for item display
descriptionnvarchar (120)NOT NULLTextual description of item.
ste_state_misc_parameter_KEYnvarchar (40)NOT NULLActual state misc parameter name used by the system.
default_itembit (1)NOT NULLSet if this is the default item in the drop list
used_by_independent_contractorbit (1)NOT NULLTrue if this row is used for Independent Contractors.
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_Ste_State_Misc_Parameter_Droplist_Itemste_state_misc_parameter_droplist_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ste_State_Misc_Parameter_Droplist_Item__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram