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
NameTypeConstraintsDescription
state_idnvarchar (4)NOT NULLReverse engineered from no doc 2019-11-01: The STE State Code KEY
parameter_KEYnvarchar (100)NOT NULLReverse engineered from no doc 2019-11-01: The name of a parameter defined by Symmetry.
display_orderint (4)NOT NULLOrder the associated control is displayed in the W4 UI
ste_state_misc_parameter_usage_KEYint (4)NOT NULLReverse engineered from no doc 2019-11-01: Surrogate integral primary key
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_Usageste_state_misc_parameter_usage_KEY
Unique constraints
NameColumnsDescription
UK_STE_State_Misc_Parameter_Usage$state_id$data_version$display_orderstate_id, data_version, display_order
Foreign keys
NameColumnsReferenced tableDescription
FK_STE_State_Misc_Parameter_Usage__Ste_State_Code__state_id__ste_state_code_KEYstate_idSte_State_Code (ste_state_code_KEY)
FK_STE_State_Misc_Parameter_Usage__STE_State_Misc_Parameter__parameter_KEYparameter_KEYSTE_State_Misc_Parameter (parameter_KEY)Make sure we use a valid parameter_KEY.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_Employee_Data__STE_State_Misc_Parameter_Usage__ste_state_misc_parameter_usage_KEYste_state_misc_parameter_usage_KEYImport_Template_Column_Employee_Data

Schema diagram