| PeopleSoft Field Name | Description |
|---|
 SETID | SetID Prompt Table: SETID_NOMETA_VW |
| SETCNTRLVALUE | Tree Definition User Key Value |
| TREE_NAME | Tree Name |
| EFFDT | Effective Date |
| EFF_STATUS | Effective Status
A=Active
I=Inactive |
| VERSION | Internal PeopleTools version to control reloading of Tree objects in cache. OBJECTTYPE = 'TAM', Tree. Also on PSLOCK |
| TREE_STRCT_ID | Tree Structure Name Prompt Table: PSTREESTRCT |
| DESCR | Description |
| ALL_VALUES | Tree Level All Values flag
N=No
Y=Yes |
| USE_LEVELS | Tree Definition Level Use Type
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced |
| VALID_TREE | Valid Tree
N=Saved As Draft
Y=Saved As Valid Tree |
| LEVEL_COUNT | Level Count |
| NODE_COUNT | Tree Definition Node Count |
| LEAF_COUNT | Leaf Count |
| TREE_HAS_RANGES | Tree Has Ranges |
| DUPLICATE_LEAF | Tree Definition allow duplicate leaf flag |
| TREE_CATEGORY | Category name for the Tree Default: DEFAULT |
| TREE_ACC_METHOD | Tree Access Method for nVision: S=Sub-select, J=Join to Selector, L=Use Literal Values (Suppress Joins)
D=Use Application Defaults
J=Join to Tree Selector
L=Use Literal Values
S=Sub-SELECT Tree Selector (default) |
| TREE_ACC_SELECTOR | Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
D=Dynamic Selectors
S=Static Selector (default) |
| TREE_ACC_SEL_OPT | Tree Defintion Tree Access Selector Option for nVision
B=Range of Values (BETWEEN)
R=Range of Values (>=...<=) (default)
S=Single Values |
| LASTUPDDTTM | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| LASTUPDOPRID | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| TREE_IMAGE | Field for the image to be used for tree |
| BRANCH_IMAGE | Branched Tree Image Name |
| NODECOL_IMAGE | Collapsed Node Image Field |
| NODEEXP_IMAGE | Expanded Node Image Field |
| LEAF_IMAGE | Name of image that is used for leaf , i.e. detail values in tree |