DEPT_TDEFN_VW(SQL View) |
Index Back |
|---|---|
Tree Definition |
| SELECT SETID , SETCNTRLVALUE , TREE_NAME , EFFDT , EFF_STATUS , VERSION , TREE_STRCT_ID , DESCR , ALL_VALUES , USE_LEVELS , VALID_TREE , LEVEL_COUNT , NODE_COUNT , LEAF_COUNT , TREE_HAS_RANGES , DUPLICATE_LEAF , TREE_CATEGORY , TREE_ACC_METHOD , TREE_ACC_SELECTOR , TREE_ACC_SEL_OPT , LASTUPDDTTM , LASTUPDOPRID , TREE_IMAGE , BRANCH_IMAGE , NODECOL_IMAGE , NODEEXP_IMAGE , LEAF_IMAGE FROM PSTREEDEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_NOMETA_VW |
| 2 | SETCNTRLVALUE |
Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 7 | TREE_STRCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Name (see PSTREESTRCT).
Prompt Table: PSTREESTRCT |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | ALL_VALUES | Character(1) | VARCHAR2(1) NOT NULL | Tree Level All Values flag |
| 10 | USE_LEVELS | Character(1) | VARCHAR2(1) NOT NULL |
Tree Definition Level Use Type
L=Loosely Enforced N=Level Not Used S=Strictly Enforced |
| 11 | VALID_TREE | Character(1) | VARCHAR2(1) NOT NULL |
Valid Tree
N=Draft Tree Y=Valid Tree |
| 12 | LEVEL_COUNT | Number(3,0) | SMALLINT NOT NULL | Level Count |
| 13 | NODE_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Tree Definition Node Count |
| 14 | LEAF_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Leaf Count |
| 15 | TREE_HAS_RANGES | Character(1) | VARCHAR2(1) NOT NULL | Tree Has Ranges |
| 16 | DUPLICATE_LEAF | Character(1) | VARCHAR2(1) NOT NULL | Tree Definition allow duplicate leaf flag |
| 17 | TREE_CATEGORY | Character(18) | VARCHAR2(18) NOT NULL | Category name for the Tree |
| 18 | TREE_ACC_METHOD | Character(1) | 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 |
| 19 | TREE_ACC_SELECTOR | Character(1) | VARCHAR2(1) NOT NULL |
Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
D=Dynamic Selectors S=Static Selector |
| 20 | TREE_ACC_SEL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Tree Defintion Tree Access Selector Option for nVision
B=Range of Values (BETWEEN) R=Range of Values (>=...<=) S=Single Values |
| 21 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | 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. |
| 22 | LASTUPDOPRID | Character(30) | 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. |
| 23 | TREE_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Field for the image to be used for tree |
| 24 | BRANCH_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Branched Tree Image Name |
| 25 | NODECOL_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Collapsed Node Image Field |
| 26 | NODEEXP_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Expanded Node Image Field |
| 27 | LEAF_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |