| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPHierarchical Derivation Service |
| 1 | THDS_TREE_ACTIVE | Comprises Active Versions of Trees | 7 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
| 2 | THDS_TREE_ACT_A | Comprises Active Versions of Trees | 7 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
| 3 | THDS_TREE_ACT_S | Comprises Active Versions of Trees | 6 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
| 4 | THDS_TREE_HIST | History Table - HDS Trees | 9 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
| 5 | THDS_TREE_HIST_A | History Table - HDS Trees | 9 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
| 6 | THDS_TREE_HIST_S | History Table - HDS Trees | 8 | TREE_STRING | HDS Tree Complete as String | ntext | 1073741823 | 0 | | |
