File Layout Details
Each record starts with a unique identifier for that record type, followed by the associated column data. All data is in a fixed format.
Tree Structure Layout (TREE_STRUCTURE)
For the Tree Structure layout, most column names map directly to the PSTREESTRCT record.
Note:
The tree structure record is optional if the database already has the structure defined for the new tree.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 1. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add mode is supported at this time) |
|
TREE_STRCT_ID |
Character |
18 |
3 |
20 |
None |
|
DESCR |
Character |
30 |
21 |
50 |
None |
|
TREE_STRCT_TYPE |
Character |
1 |
51 |
51 |
None |
|
DYNAMIC_RANGE |
Character |
1 |
52 |
52 |
Y or N |
|
SETCNTRL_IND |
Character |
1 |
53 |
53 |
S, B, U, or N |
|
LEVEL_RECNAME |
Character |
15 |
54 |
68 |
None |
|
LEVEL_PNLNAME |
Character |
18 |
69 |
86 |
None |
|
LEVEL_MENUNAME |
Character |
30 |
87 |
116 |
None |
|
LEVEL_BARNAME |
Character |
30 |
117 |
146 |
None |
|
NODE_RECNAME |
Character |
15 |
147 |
161 |
None |
|
NODE_PNLNAME |
Character |
18 |
162 |
179 |
None |
|
NODE_FIELDNAME |
Character |
18 |
180 |
197 |
None |
|
SETCNTRLFLD |
Character |
18 |
198 |
215 |
None |
|
NODE_MENUNAME |
Character |
30 |
216 |
245 |
None |
|
NODE_BARNAME |
Character |
30 |
246 |
275 |
None |
|
DTL_RECNAME |
Character |
15 |
276 |
290 |
None |
|
DTL_FIELDNAME |
Character |
18 |
291 |
308 |
None |
|
DTL_PNLNAME |
Character |
18 |
309 |
326 |
None |
|
DTL_MENUNAME |
Character |
30 |
327 |
356 |
None |
|
DTL_BARNAME |
Character |
30 |
357 |
386 |
None |
|
DTL_SETID |
Character |
5 |
387 |
391 |
None |
|
SETCNTRLVALUE |
Character |
20 |
392 |
411 |
None |
|
DTL_TREE_NAME |
Character |
18 |
412 |
429 |
None |
|
DTL_TREE_LEVEL_NUM |
Character |
5 |
430 |
434 |
None |
|
LEVEL_PNLGRPNAME |
Character |
50 |
436 |
485 |
Only for release 8.1 and later. |
|
NODE_PNLGRPNAME |
Character |
50 |
487 |
536 |
Only for release 8.1 and later. |
|
DTL_PNLGRPNAME |
Character |
50 |
538 |
587 |
Only for release 8.1 and later. |
|
LEVEL_ITEMNAME |
Character |
30 |
589 |
618 |
Only for release 8.1 and later. |
|
NODE_ITEMNAME |
Character |
30 |
620 |
649 |
Only for release 8.1 and later. |
|
DTL_ITEMNAME |
Character |
30 |
651 |
680 |
Only for release 8.1 and later. |
TreeMover Tree Definition Layout (TREE_DEFN)
The tree definition record columns require either a tree structure defined in the database or a previous tree structure record in the file. For the Tree Definition layout, most column names map directly to the PSTREEDEFN record.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 2. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add is mode supported at this time). |
|
SETID |
Character |
5 |
3 |
7 |
None |
|
SETCNTRLVALUE |
Character |
20 |
8 |
27 |
None |
|
TREE_NAME |
Character |
18 |
28 |
45 |
None |
|
EFFDT |
Date |
10 |
46 |
55 |
YYYY-MM-DD format. |
|
TREE_STRCT_ID |
Character |
18 |
56 |
73 |
None |
|
DESCR |
Character |
30 |
74 |
103 |
None |
|
NODE_COUNT |
Character |
10 |
104 |
113 |
None |
|
ALL_VALUES |
Character |
1 |
114 |
114 |
Y or N |
|
USE_LEVELS |
Character |
1 |
115 |
115 |
S, L, or N |
|
DUPLICATE_LEAF |
Character |
1 |
116 |
116 |
Y or N |
|
TREE_CATEGORY |
Character |
18 |
117 |
134 |
None |
|
EFF_STATUS |
Character |
1 |
135 |
135 |
None |
|
TREE_ACC_METHOD |
Character |
1 |
136 |
136 |
None |
|
TREE_ACC_SELECTOR |
Character |
1 |
137 |
137 |
None |
|
TREE_ACC_SEL_OPT |
Character |
1 |
138 |
138 |
None |
|
LEAF_COUNT |
Character |
10 |
139 |
148 |
None |
|
TREE_IMAGE |
Character |
30 |
139 |
168 |
Only for release 8.1 and later. |
|
BRANCH_IMAGE |
Character |
30 |
170 |
199 |
Only for release 8.1 and later. |
|
NODECOL_IMAGE |
Character |
30 |
201 |
230 |
Only for release 8.1 and later. |
|
NODEEXP_IMAGE |
Character |
30 |
232 |
261 |
Only for release 8.1 and later. |
|
LEAF_IMAGE |
Character |
30 |
263 |
292 |
Only for release 8.1 and later. |
Tree User Level Data Layout (TREE_USERLEVEL)
The columns in this layout correspond to the columns in the TREE_LEVEL_TBL record.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 3. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add mode is supported at this time). |
|
SETID |
Character |
5 |
3 |
7 |
None |
|
TREE_LEVEL |
Character |
10 |
8 |
17 |
None |
|
EFFDT |
Date |
10 |
18 |
27 |
YYYY-MM-DD format. |
|
EFF_STATUS |
Character |
1 |
28 |
28 |
None |
|
DESCR |
Character |
30 |
29 |
58 |
None |
|
DESCRSHORT |
Character |
10 |
59 |
68 |
None |
Tree Level Record Layout (TREE_LEVEL)
The tree level layout requires a tree definition record in the file previous to this record type. The columns in this layout correspond to the columns in the PSTREELEVEL record.
Note:
No-level records should be defined for no-level trees.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 4. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add mode is supported at this time). |
|
TREE_LEVEL |
Character |
10 |
3 |
12 |
None |
|
TREE_LEVEL_NUM |
Character |
3 |
13 |
15 |
None |
|
ALL_VALUES |
Character |
1 |
16 |
16 |
Y or N |
Tree Node Data Layout (TREE_USERNODE)
The columns in this layout correspond to the columns in the TREE_NODE_TBL record.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 5. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add mode is supported at this time). |
|
SETID |
Character |
5 |
3 |
7 |
None |
|
TREE_NODE |
Character |
20 |
8 |
27 |
None |
|
EFFDT |
Date |
10 |
28 |
37 |
YYYY-MM-DD format. |
|
EFF_STATUS |
Character |
1 |
38 |
38 |
None |
|
DESCR |
Character |
30 |
39 |
68 |
None |
Tree Node Record Columns (TREE_NODE)
Tree node record columns require a tree definition record in the file previous to this record type and level records if the tree has levels. Node records must have parents defined before their children. Detail records can be interspersed between node records.
Note:
Node type is either G or R. G is for standard nodes, and R is for Query Access Group record nodes. Branch nodes are not supported at this time.
| Column Name | Column Type | Length | Start Position | End Position | Comments |
|---|---|---|---|---|---|
|
File Record ID |
Number |
1 |
1 |
1 |
Always 6. |
|
UPDATE_ACTION |
Character |
1 |
2 |
2 |
Always A (only add mode is supported at this time). |
|
TREE_NODE |
Character |
20 |
3 |
22 |
Only for node records. |
|
PARENT_NODE_NAME |
Character |
20 |
23 |
42 |
Tree TREE_NODE for the parent node of the node or detail. |
|
TREE_NODE_TYPE |
Character |
1 |
43 |
43 |
Only for node records; must be G or R. |
|
TREE_LEVEL_NUM |
Character |
3 |
44 |
46 |
Only for node records. |
|
TREE_NODE_PREV_SIB |
Character |
20 |
47 |
66 |
Only for node records. |
|
RANGE_FROM |
Character |
30 |
67 |
96 |
Only for detail records. |
|
RANGE_TO |
Character |
30 |
97 |
126 |
Only for detail records. |
|
DYNAMIC_RANGE |
Character |
1 |
127 |
127 |
Only for detail records; must be Y or N. |
|
LEAF_IMAGE |
Character |
30 |
129 |
158 |
Only for release 8.1 and later. |
|
NODECOL_IMAGE |
Character |
8 |
160 |
167 |
Only for release 8.1 and later. |
|
NODEEXP_IMAGE |
Character |
8 |
169 |
176 |
Only for release 8.1 and later. |