PSTREEDEFN: Tree Definition
PSTREEDEFN (Tree Definition) table is the system table that defines an effective-dated version of a tree.
The following table lists the field names, types, lengths, formats, and long names of the PSTREEDEFN table.
| Field Name | Type | Length | Format | Long Name |
|---|---|---|---|---|
|
SETID |
Char |
5 |
Upper |
setID |
|
SETCNTRLVALUE |
Char |
5 |
Upper |
Set control value. Alternative to setID |
|
TREE_NAME |
Char |
18 |
Upper |
Tree name |
|
EFFDT |
Date |
10 |
N/A |
Effective date |
|
EFF_STATUS |
Char |
1 |
Upper |
Status as of effective date |
|
VERSION |
Nbr |
10 |
Raw B |
Version |
|
TREE_STRCT_ID |
Char |
18 |
Upper |
Tree structure ID |
|
DESCR |
Char |
30 |
Mixed |
Description |
|
ALL_VALUES |
Char |
1 |
Upper |
All values |
|
USE_LEVELS |
Char |
1 |
Upper |
Use levels |
|
VALID_TREE |
Char |
1 |
Upper |
Valid tree |
|
LEVEL_COUNT |
Nbr |
3 |
N/A |
Level count |
|
NODE_COUNT |
Nbr |
5 |
Raw B |
Node count |
|
LEAF_COUNT |
Nbr |
5 |
Raw B |
Leaf count |
|
TREE_HAS_RANGES |
Char |
1 |
Upper |
Tree has ranges |
|
DUPLICATE_LEAF |
Char |
1 |
Upper |
Allow duplicate leaf |
|
TREE_CATEGORY |
Char |
18 |
Upper |
Category |
|
TREE_ACC_METHOD |
Char |
1 |
Upper |
Tree access method |
|
TREE_ACC_SELECTOR |
Char |
1 |
Upper |
Tree access selector |
|
TREE_ACC_SEL_OPT |
Char |
1 |
Upper |
Tree access selector option |