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 |