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 |