PSPTTREEDEFN_VW

index back

Tree Definition


SELECT DISTINCT A.SETID , A.SETCNTRLVALUE , A.TREE_NAME , A.TREE_BRANCH , B.TREE_STRCT_ID , B.VALID_TREE , B.LASTUPDDTTM , B.LASTUPDOPRID , B.TREE_CATEGORY , B.VERSION FROM PSTREEBRANCH A , PSTREEDEFN B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT A.SETID , A.SETCNTRLVALUE , A.TREE_NAME , ' ' , A.TREE_STRCT_ID , A.VALID_TREE , A.LASTUPDDTTM , A.LASTUPDOPRID , A.TREE_CATEGORY , A.VERSION FROM PSTREEDEFN A WHERE NOT EXISTS ( SELECT 'X' FROM PSTREEBRANCH B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME)

PeopleSoft Field NameField TypeColumn TypeDescription
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
TREE_BRANCHCharacter(20)VARCHAR2(20) NOT NULLTree Branch
TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).

Prompt Table: PSTREESTRCT

VALID_TREECharacter(1)VARCHAR2(1) NOT NULLValid Tree
N=Draft Tree
Y=Valid Tree
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
TREE_CATEGORYCharacter(18)VARCHAR2(18) NOT NULLCategory name for the Tree

Default: DEFAULT

VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19