FWDataSetValue

This table is related to both the FWDataSetGroup and the FWDataSetNesting tables. It bridges the gap between the problem set definition and the different tables and their nested attributes by providing the actual attribute values used to glue them together. The DataSetValue table records link the other two DataSet tables together. It provides the link between ”many to many” relationships and provides the ability to specify value-level definitions needed to perform specific problem set extractions.

Attribute Name	Type	Field Size	Description	Required
DataSetValueID	int	4	Unique internal DB Identifier of the DataSetValue record.	Required
DataSetGroupID	int	4	Unique internal DB Identifier of the DataSetGroup record. Must exist on the FWDataSetGroup table.	Required
DataSetNestingID	int	4	Unique internal DB Identifier of the DataSetNesting record. Must exist on the FWDataSetNesting table.	Required
DataSetGroupKey	nvarchar	50	Business key to identify the DataSetGroup this DataSetValue refers to. Must exist on the FWDataSetGroup table.	Required
DataSetNestingKey	nvarchar	50	Business key to identify the DataSetNesting this DataSetValue refers to. Must exist on the FWDataSetNesting table.	Required
EndLevel	tinyint	1	Since we only have six levels, the valid values are 1 through 6 only. A value of zero (0) is not allowed. Once a value has been entered, it needs to be validated against the FWDataSetNesting table Level 1 &endash; 6 Attributes. *For example*: If the EndLevel is set to two, then the Level one and two Attributes must be defined on the FWDataSetNesting table. If it is set to five, then one through five must be set, and so on. The EndLevel attribute allows you to define a fully nested definition at the nesting table level and control the execution level at the value table definition. The default is 1. *For example*: You can specify all six levels but only extract to level 1 if this value is set to 1. This provides a certain reuse capability with fewer definitions. See the FWDataSetNesting table for additional level details.	Required
Level1Value	nvarchar	10000	Level one is always required, whereas the other Level Attributes are optional. The concept here is to start at level one and work deeper into the table by being more specific with each level using different attribute values. The user will provide the actual attribute value. It should be a valid data setting for that attribute, otherwise no results is returned.
Level2Value	nvarchar	1000	If the EndLevel attribute is one.	Required - If the EndLevel attribute is two or higher. If level two is specified, then level one must also be specified.
Level3Value	nvarchar	1000	If the EndLevel attribute is two or lower.	Required - If the EndLevel attribute is three or higher. If level three is specified, then level one and two must also be specified.
Level4Value	nvarchar	1000	If the EndLevel attribute is three or lower.	Required - If the EndLevel attribute is four or higher. If level four is specified, then level one, two, and three must also be specified.
Level5Value	nvarchar	1000	If the EndLevel attribute is four or lower.	Required - If the EndLevel attribute is five or higher. If level five is specified, then level one, two, three, and four must also be specified.
Level6Value	nvarchar	1000	If the EndLevel attribute is five or lower.	Required - If the EndLevel attribute is six. If level six is specified, then level one, two, three, four, and five must also be specified.
Comment	nvarchar	255	See Comment.
CreatedBy	int	4	See CreatedBy.
CreatedDate	datetime	8	See CreatedDate.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.