PeopleSoft 9.0
Cash Management

Table Name PSTREENODE

Table Description
PSTREENODE
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
SETCNTRLVALUE CHAR(20) Yes Yes
TREE_NAME CHAR(18) Yes Yes
EFFDT PSDATE Yes Yes
TREE_NODE_NUM int Yes No
TREE_NODE char(20) Yes No
TREE_BRANCH char(20) Yes No
TREE_NODE_NUM_END int No No
TREE_LEVEL_NUM smallint No No
TREE_NODE_TYPE char(1) No No
PARENT_NODE_NUM int No No
PARENT_NODE_NAME char(20) No No
OLD_TREE_NODE_NUM char(1) No No
NODECOL_IMAGE char(30) No No
NODEEXP_IMAGE char(30) No No
Index
Name Type Unique Member
PS_PSTREENODE PK Yes
PSAPSTREENODE IE1 No
PSBPSTREENODE IE2 No
PSCPSTREENODE IE3 No
PSDPSTREENODE IE4 No
PSFPSTREENODE IE5 No
Member(s) of "PS_PSTREENODE" Index
SETID
SETCNTRLVALUE
TREE_NAME
EFFDT
TREE_NODE_NUM
TREE_NODE
TREE_BRANCH
Member(s) of "PSAPSTREENODE" Index
SETID
TREE_NAME
EFFDT
TREE_BRANCH
TREE_NODE
TREE_NODE_NUM
TREE_NODE_NUM_END
TREE_NODE_TYPE
Member(s) of "PSBPSTREENODE" Index
SETID
TREE_NAME
TREE_BRANCH
TREE_NODE_NUM
TREE_NODE
TREE_NODE_NUM_END
TREE_LEVEL_NUM
TREE_NODE_TYPE
Member(s) of "PSCPSTREENODE" Index
TREE_NODE
Member(s) of "PSDPSTREENODE" Index
SETID
TREE_NAME
EFFDT
PARENT_NODE_NUM
Member(s) of "PSFPSTREENODE" Index
TREE_NAME
EFFDT

Published April 30, 2007