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 needs to have a Node Type | N/A | Parent KPI Constant Reference Variable | N/A | N/A |
| Expected 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 |
| 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 Parent 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 |
| NonFinancial Category | This field contains the Non-Financial Category to be linked | This value must match an existing Non Financial category | N/A | N/A | N/A | Lookup (Non-Financial Categories) |
| Baseline | This is the baseline value of the VDT Node | Numeric | Only for Constant and KPI Nodes | N/A | N/A | N/A |
| Target | This is the target value of the VDT Node | Numeric | Only for Constant and KPI Nodes | N/A | N/A | N/A |
| Actual | This is the actual value of the VDT Node | Numeric | Only for Constant and KPI Nodes | N/A | N/A | N/A |
| Default Value | This is the default value of the VDT Node | Numeric | For KPI Nodes Only | N/A | N/A | N/A |
| Benefit Calculation Method | This is the benefit calculation method on the KPI Node | String | N/A | No Impact On Benefits, Baseline vs Actual | Baseline vs Actual | Lookup (Benefit Calculation Methods) |
| Exclude from Reporting | This field contains the reporting exclusion label | If 'Yes' is inserted. This node is excluded from all reports | N/A | N/A | N/A | Variable Character (MAX) |