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 |
Title | This field contains the full name of the VDT Node. | Alphanumeric value | N/A | N/A | N/A | Variable Character (100) |
Parent Node | 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 Type is a required field | Must be specified | Parent KPI Constant Reference | N/A | N/A |
Expected Trend | This field contains the predefined Trend options. | Must be a valid Expected Trend. | N/A | Upwards Downwards | 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) |
Comments | This field contains a comment captured for the node. | Alphanumeric value | N/A | N/A | N/A | N/A |
Reference | This field contains the reference of the node within the VDT. | 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 Parent Node | This field contains the name of the parent node that will be referenced by this node. | This value must be valid in the Excel file. | Only Parent nodes can be referenced | N/A | N/A | N/A |
Constant Value | This field contains a constant value. | Numeric value | N/A | N/A | N/A | N/A |