CategoriesLookup table
The CategoriesLookup table surfaces the categorical value labels.
Columns
VariableID
Key: Yes
Column type: Integer
Question identifier, that is the same as the identifier in the Variables table.
CategoryID
Key: Yes
Column type: Integer
Category value for each category item.
CategoryIndex
Key: No
Column type: Integer
Sequential order for each category item.
Label
Key: No
Column type: Nvarchar(4000)
Category description for each category item.
LabelId
Key: Yes
Column type: Integer
Defined LabelID that is used for referring to LCL, MDMVersion, and Project name.
See also