Table: dbo.STE_State_Misc_Parameter
Columns
NameTypeConstraintsDescription
parameter_KEYnvarchar (100)NOT NULLPrimary key of this table. Value provided by Symmetry.
parameter_descriptionnvarchar (100)NOT NULLDescription. Value provided by Symmetry. Take care and be sure to NOT add a colon at the end of a description.
allowed_value_idint (4)NOT NULLvalue ID. Value provided by Symmetry.
used_by_independent_contractorbit (1)NOT NULLTrue if this row is used for Independent Contractors.
Primary key
NameColumnsDescription
PK_STE_State_Misc_Parameter$parameter_KEYparameter_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_STE_State_Misc_Parameter_Usage__STE_State_Misc_Parameter__parameter_KEYparameter_KEYSTE_State_Misc_Parameter_UsageMake sure we use a valid parameter_KEY.
FK_Employee_W4_Setting_Parameter__STE_State_Misc_Parameter__parameter_KEYparameter_KEYEmployee_W4_Setting_Parameter

Schema diagram