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. |
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 |