EnumTypeItems
The EnumTypeItems dataset contains data regarding value lists, such as file plans and keywords.
Importing to a BI database
Value lists can change continuously. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted. Delete the existing table in your BI database and import the latest version.
Column overview
The following table describes the columns available in the dataset. The table includes the following information about each column:
-
Dataset name: The column’s name in the dataset.
-
Description: Describes the column’s content and function.
-
Reference to other dataset: Specifies references to other datasets, if any.
-
Format: Specifies the format of the returned values.
-
Length: Specifies the length of the returned values, if any.
-
Examples: Examples of returned values.
| Dataset name | Description | Reference to other dataset | Format | Length | Examples |
|---|---|---|---|---|---|
InternalEnumItemId |
The internal database ID of the value list item. |
int identity |
6 98 |
||
Active |
The state of the item, i.e. whether it is assignable. Inactive items can still show up on old data records. |
bit |
1: Active 0: Inactive |
||
TypeId |
Name of the value list. |
nvarchar |
40 |
Keyword File plan |
|
Title |
Name of the value list item. |
nvarchar |
256 |
||
InternalParentEnumItemId |
The InternalEnumItemId of the parent node (e.g. subject area for keywords). |
int |
128 |