A downloadable PDF version is available at the bottom of the page together with the Excel import template.
Rules. (Required fields are marked with a Red background color)
Field Name | Description | Rules | Exception Handling | Values to be placed | Default Values | Field Type |
Name | This field contains the full name of the VDT Node. | Alphanumeric value | N/A | N/A | N/A | Variable Character (100) |
Parent | This field contains the name of the Parent VDT Node. | Alphanumeric value | The specified name needs to have been captured in the import file. | N/A | N/A | Variable Character (100) |
Node Type | This field contains the predefined node type options. | A VDT Node needs to have a Node Type | N/A | Parent KPI Constant Reference | N/A | N/A |
Trend | This field contains the predefined Trend options. | Must be a valid email Trend. | N/A | Downwards Upwards | N/A | N/A |
Decimals | This field contains the decimal count. | Numeric | N/A | N/A | N/A | Variable Character (16) |
Expression | This field contains the formula to be used by a parent node. | Alphanumeric value | N/A | N/A | N/A | Variable Character (10) |
Comment | This field contains a comment captured for the node. | Alphanumeric value | N/A | N/A | N/A | N/A |
Expression Reference | This field contains the reference of the VDT within the parent. | Alphanumeric value | Must be specified | N/A | N/A | N/A |
KPI Code | This field contains the code of the KPI to be linked to the KPI Node. | This value must be valid in the system. The Code must match up with an existing KPI Code. | Only for KPI Nodes | N/A | N/A | Lookup (KPIs) |
Reference Node | This field contains the name of a Parent node in the Excel file. | This value must be valid in the Excel file. | Only Parent nodes can be captured | N/A | N/A | N/A |
Constant Node | This field contains a constant value | Numeric value | N/A | N/A | N/A | N/A |