| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPHierarchical Derivation Service |
| 1 | THDS_TREE | Header of a Derivation Tree | 4 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 2 | THDS_TREE_A | Header of a Derivation Tree | 4 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 3 | THDS_TREE_ACTIVE | Comprises Active Versions of Trees | 5 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 4 | THDS_TREE_ACT_A | Comprises Active Versions of Trees | 5 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 5 | THDS_TREE_ACT_S | Comprises Active Versions of Trees | 4 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 6 | THDS_TREE_HIST | History Table - HDS Trees | 7 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 7 | THDS_TREE_HIST_A | History Table - HDS Trees | 7 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 8 | THDS_TREE_HIST_S | History Table - HDS Trees | 6 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
| 9 | THDS_TREE_S | Header of a Derivation Tree | 3 | TREE_TIMESTAMP | Time Stamp of Last Change | decimal | 21 | 7 | | |
