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 |