| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 TREE_STRCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Name
|
| VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| DYNAMIC_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Leaf Dynamic detail range flag
|
| LEVEL_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Tree Structure Level Record name
Prompt Table:
PSRECDEFNPVW
|
| LEVEL_PNLGRPNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Level Component Name
Prompt Table:
PSTREECMPLVLVW
|
| LEVEL_PNLNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Level Panel/Page name
Prompt Table:
PSTREEPAGEVW
|
| SETCNTRL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Structure User Key Field Type Indicator
B=Business Unit
N=None
S=SetId Indirection
U=User Defined
Default: S
|
| SETCNTRL_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Set Control Field Count
|
| NODE_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Tree Structure Node Record name
Prompt Table:
PSRECDEFNPVW
|
| NODE_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node Field name
Prompt Table:
PSTREEFLDNODVW
|
| SETCNTRLFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table:
PSTREEFLDNODVW
|
| NODE_PNLGRPNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Node Component Name
Prompt Table:
PSTREECMPNODVW
|
| NODE_PNLNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node Panel/Page name
Prompt Table:
PSTREEPAGEVW
|
| DTL_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Tree Structure Detail Record name
Prompt Table:
PSRECDEFNPVW
|
| DTL_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Detail Record name
Prompt Table:
PSTREEFLDDTLVW
|
| DTL_PNLGRPNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Component Name used to maintain detail values in tree
Prompt Table:
PSTREECMPDTLVW
|
| DTL_PNLNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Detail Panel/Page name
Prompt Table:
PSTREEPAGEVW
|
| NODE_MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Node Menu name
Prompt Table:
PSTREEMENUNODVW
|
| DTL_MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Detail Menu name
Prompt Table:
PSTREEMENUDTLVW
|
| TREE_STRCT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Structure Type: "D" = detail or "S" = summary
D=Detail
S=Summary
Default: D
|
| DTL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Tree Structure Summary Detail Tree SetId
Prompt Table:
PSTREEDEFDSETVW
|
| SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| DTL_TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Summary Detail Tree Name
Prompt Table:
PSTREEDEFDTLVW
|
| DTL_TREE_LEVEL_NUM |
Number(5,0) |
INTEGER NOT NULL |
Tree Structure Summary Detail Tree Level Number
Prompt Table:
PSTREELVLNUMVW
|
| LEVEL_MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Level Menu name
Prompt Table:
PSTREEMENULVLVW
|
| LEVEL_BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Level Menu Bar name
Prompt Table:
PSTREEMNBRLVLVW
|
| NODE_BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Node Menu Bar name
Prompt Table:
PSTREEMNBRNODVW
|
| DTL_BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Structure Detail Menu Bar name
Prompt Table:
PSTREEMNBRDTLVW
|
| LEVEL_ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Item Name for Tree Levels
Prompt Table:
PSTREEMNITLVLVW
|
| NODE_ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Item Name for Tree Nodes
Prompt Table:
PSTREEMNITNODVW
|
| DTL_ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Item Name for Tree Details (Leafs)
Prompt Table:
PSTREEMNITDTLVW
|
| NODE_MULTINAVIGATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Multi-Navigate Flag: "N" = No or "Y" = Yes
Y/N Table Edit
Default: N
|
| DTL_MULTINAVIGATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail Multi-Navigate Flag: "N" = No or "Y" = Yes
Y/N Table Edit
Default: N
|
| 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.
|
| 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.
|