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