| Table: dbo.Ste_State_Misc_Parameter_Droplist_Item | |||
| Columns | |||
| Name | Type | Constraints | Description |
| ste_state_misc_parameter_droplist_item_KEY | int (4) | NOT NULL | Primary Key |
| ste_state_code_KEY | nvarchar (4) | State Code of of the state requiring this item | |
| allowed_value_id | int (4) | NOT NULL | Allowed Value ID - used by the system to selected proper control type for item display |
| description | nvarchar (120) | NOT NULL | Textual description of item. |
| ste_state_misc_parameter_KEY | nvarchar (40) | NOT NULL | Actual state misc parameter name used by the system. |
| default_item | bit (1) | NOT NULL | Set if this is the default item in the drop list |
| used_by_independent_contractor | bit (1) | NOT NULL | True if this row is used for Independent Contractors. |
| 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_Ste_State_Misc_Parameter_Droplist_Item | ste_state_misc_parameter_droplist_item_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Ste_State_Misc_Parameter_Droplist_Item__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) | |