PeopleSoft 9.0
Cash Management

Table Name PSTREEDEFN

Table Description
PSTREEDEFN
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
SETCNTRLVALUE CHAR(20) Yes No
TREE_NAME CHAR(18) Yes No
EFFDT PSDATE Yes No
EFF_STATUS CHAR(1) No No
VERSION INT No No
TREE_STRCT_ID CHAR(18) No No
DESCR CHAR(30) No No
ALL_VALUES CHAR(1) No No
USE_LEVELS CHAR(1) No No
VALID_TREE CHAR(1) No No
LEVEL_COUNT SMALLINT No No
NODE_COUNT INT No No
LEAF_COUNT INT No No
TREE_HAS_RANGES CHAR(1) No No
DUPLICATE_LEAF CHAR(1) No No
TREE_CATEGORY CHAR(18) No No
TREE_ACC_METHOD CHAR(1) No No
TREE_ACC_SELECTOR CHAR(1) No No
TREE_ACC_SEL_OPT CHAR(1) No No
LASTUPDDTTM PSDATETIME No No
LASTUPDOPRID CHAR(30) No No
TREE_IMAGE CHAR(30) No No
BRANCH_IMAGE CHAR(30) No No
NODECOL_IMAGE CHAR(30) No No
NODEEXP_IMAGE CHAR(30) No No
LEAF_IMAGE CHAR(30) No No
Index
Name Type Unique Member
XPKPSTREEDEFN PK Yes
PS_PSTREEDEFN AK1 Yes
PSAPSTREEDEFN IE1 No
PSBPSTREEDEFN IE2 No
PSCPSTREEDEFN IE3 No
PSDPSTREEDEFN IE4 No
Member(s) of "XPKPSTREEDEFN" Index
SETID
SETCNTRLVALUE
TREE_NAME
EFFDT
Member(s) of "PS_PSTREEDEFN" Index
SETID
SETCNTRLVALUE
TREE_NAME
EFFDT
Member(s) of "PSAPSTREEDEFN" Index
TREE_STRCT_ID
SETID
TREE_NAME
EFFDT
EFF_STATUS
Member(s) of "PSBPSTREEDEFN" Index
SETID
TREE_NAME
EFFDT
VERSION
Member(s) of "PSCPSTREEDEFN" Index
VERSION
Member(s) of "PSDPSTREEDEFN" Index
TREE_NAME
EFFDT

Published April 30, 2007