Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for states. |
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. |