PSTREEDEFN |
| PeopleSoft Field Name | Field Type | Description |
|---|---|---|
 SETID | VARCHAR2(5) NOT NULL | SetID Prompt Table: SETID_NOMETA_VW |
| SETCNTRLVALUE | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| TREE_NAME | VARCHAR2(18) NOT NULL | Tree Name |
| EFFDT | DATE NOT NULL | Effective Date |
| EFF_STATUS | VARCHAR2(1) NOT NULL | Effective Status A=Active I=Inactive |
| VERSION | DECIMAL(10) NOT NULL | Version |
| TREE_STRCT_ID | VARCHAR2(18) NOT NULL | Tree Structure Name Prompt Table: PSTREESTRCT |
| DESCR | VARCHAR2(30) NOT NULL | Description |
| ALL_VALUES | VARCHAR2(1) NOT NULL | Tree Level All Values flag |
| USE_LEVELS | VARCHAR2(1) NOT NULL | Tree Definition Level Use Type L=Loosely Enforced N=Level Not Used S=Strictly Enforced |
| VALID_TREE | VARCHAR2(1) NOT NULL | Valid Tree N=Saved As Draft Y=Saved As Valid Tree |
| LEVEL_COUNT | SMALLINT NOT NULL | Level Count |
| NODE_COUNT | DECIMAL(10) NOT NULL | Tree Definition Node Count |
| LEAF_COUNT | DECIMAL(10) NOT NULL | Leaf Count |
| TREE_HAS_RANGES | VARCHAR2(1) NOT NULL | Tree Has Ranges |
| DUPLICATE_LEAF | VARCHAR2(1) NOT NULL | Tree Definition allow duplicate leaf flag |
| TREE_CATEGORY | VARCHAR2(18) NOT NULL | Category name for the Tree Default: DEFAULT |
| TREE_ACC_METHOD | VARCHAR2(1) NOT NULL | 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: S |
| TREE_ACC_SELECTOR | VARCHAR2(1) NOT NULL | Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors D=Dynamic Selectors S=Static Selector Default: S |
| TREE_ACC_SEL_OPT | VARCHAR2(1) NOT NULL | Tree Defintion Tree Access Selector Option for nVision B=Range of Values (BETWEEN) R=Range of Values (>=...<=) S=Single Values Default: R |
| LASTUPDDTTM | DATE | 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 | VARCHAR2(30) NOT NULL | 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 | VARCHAR2(30) NOT NULL | Field for the image to be used for tree |
| BRANCH_IMAGE | VARCHAR2(30) NOT NULL | Branched Tree Image Name |
| NODECOL_IMAGE | VARCHAR2(30) NOT NULL | Collapsed Node Image Field |
| NODEEXP_IMAGE | VARCHAR2(30) NOT NULL | Expanded Node Image Field |
| LEAF_IMAGE | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 06 February 2013 |