Table: dbo.STE_Filing_Status_State
Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for states.
Columns
NameTypeConstraintsDescription
allowed_value_user_idint (4)NOT NULLReverse engineered from no doc 2019-11-01: The value of the same-named column in dbo.STE_State_Misc_Parameter_Allowed_Value to use for the state
allowed_value_state_idnvarchar (4)NOT NULLReverse engineered from no doc 2019-11-01: The STE State code KEY for the state in question; exception "LL" maps to all.
ste_filing_status_state_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.
denormalized__ste_state_code_KEYnvarchar (4)Added 2019-11-01: Would have been a computed column but those cannot have foreign key constraints. Added because there is no such thing as a filtered foreign key constraint; for the "LL" be NULL, else be the allowed_value_state_id. Foreign key into the proper table.
Primary key
NameColumnsDescription
PK_STE_Filing_Status_Stateste_filing_status_state_KEY
Unique constraints
NameColumnsDescription
UK_STE_Filing_Status_State$allowed_value_state_id$data_versionallowed_value_state_id, data_version
Foreign keys
NameColumnsReferenced tableDescription
FK_STE_Filing_Status_State__Ste_State_Code__denormalized__ste_state_code_KEYdenormalized__ste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram