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.