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
Name | Type | Constraints | Description
allowed_value_user_id | int (4) | NOT NULL | Reverse 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_id | nvarchar (4) | NOT NULL | Reverse 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_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.
denormalized__ste_state_code_KEY | nvarchar (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
Name | Columns | Description
PK_STE_Filing_Status_State | ste_filing_status_state_KEY |
Unique constraints
Name | Columns | Description
UK_STE_Filing_Status_State$allowed_value_state_id$data_version | allowed_value_state_id, data_version |

Foreign keys
Name | Columns | Referenced table | Description
FK_STE_Filing_Status_State__Ste_State_Code__denormalized__ste_state_code_KEY | denormalized__ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |