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) |