Table: dbo.STE_State_Misc_Parameter_Usage
Reverse engineered from no doc 2019-11-01: This table helps data-driven UI for the Withholding in Employee Self Service, and possibly in ACS.
Columns
Name | Type | Constraints | Description
state_id | nvarchar (4) | NOT NULL | Reverse engineered from no doc 2019-11-01: The STE State Code KEY
parameter_KEY | nvarchar (100) | NOT NULL | Reverse engineered from no doc 2019-11-01: The name of a parameter defined by Symmetry.
display_order | int (4) | NOT NULL | Order the associated control is displayed in the W4 UI
ste_state_misc_parameter_usage_KEY | int (4) | NOT NULL | Reverse engineered from no doc 2019-11-01: Surrogate integral primary key
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_Usage | ste_state_misc_parameter_usage_KEY |
Unique constraints
Name | Columns | Description
UK_STE_State_Misc_Parameter_Usage$state_id$data_version$display_order | state_id, data_version, display_order |

Foreign keys
Name | Columns | Referenced table | Description
FK_STE_State_Misc_Parameter_Usage__Ste_State_Code__state_id__ste_state_code_KEY | state_id | Ste_State_Code (ste_state_code_KEY) |
FK_STE_State_Misc_Parameter_Usage__STE_State_Misc_Parameter__parameter_KEY | parameter_KEY | STE_State_Misc_Parameter (parameter_KEY) | Make sure we use a valid parameter_KEY.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Import_Template_Column_Employee_Data__STE_State_Misc_Parameter_Usage__ste_state_misc_parameter_usage_KEY | ste_state_misc_parameter_usage_KEY | Import_Template_Column_Employee_Data |