Table: dbo.STE_State_Misc_Parameter_Allowed_Value
Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for parameters. It did not need a version added as that was driven a layer up.
Columns
Name | Type | Constraints | Description
allowed_value_id | int (4) | NOT NULL | Reverse engineered from no doc 2019-11-01: Used to link a parameter to one or more lists of allowed values. Duplicates are disambiguated via context via the allowed_value_user_id. Only item 11, corresponding to FILINGSTATUS has duplciates. All others use user 17, shared.
allowed_value_user_id | int (4) | NOT NULL | Reverse engineered from no doc 2019-11-01: Used to link a particular consumer of a parameter to one list of allowed values. Noteworthy values are 17, shared across all states via the magic "LL" state code, and 3, used by 2019 Fed, and 5, used by 2020 Fed.
allowed_value_pattern | nvarchar (200) | NOT NULL | Reverse engineered from no doc 2019-11-01: A regular expression (dialect uncertain) which describes the valid data option(s)
allowed_value_description | nvarchar (400) | NOT NULL | Reverse engineered from no doc 2019-11-01: A human-readable description of the allowed value(s)
ste_state_misc_parameter_allowed_value_KEY | int (4) | NOT NULL | Reverse engineered from no doc 2019-11-01: Surrogate integral primary key

Primary key
Name | Columns | Description
PK_STE_State_Misc_Parameter_Allowed_Value | ste_state_misc_parameter_allowed_value_KEY |